Versions Compared

Old Version 2

changes.mady.by.user ERGUIZA-ext, Pinky Love

Saved on

compared with

New Version Current

changes.mady.by.user ERGUIZA-ext, Pinky Love

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Status

Page Status

Owner

ERGUIZA-ext, Pinky Love 

Stakeholders

VILARES, ines LEIGHTON-ext, Dean PUN-ext, Eddy TEE-ext, Paul JOSHI-ext, Aditya MOUSSA-ext, Eva HUSSAN-ext, Nishin  SARUKAN-ext, Ayse STEFANESCU-ext, Aurelia 

Purpose

The purpose of this document is to define the conversion approach to create EAM Characteristics in S/4 HANA. 

Legacy Plant Maintenance Characteristics is using a diverse range of formats across the different systems. There are instances where the same characteristics are duplicated within and across sources

, with informal words, and linked to Plant Maintenance Classes but are not used by Plant Maintenance objects at all

. This results in data inconsistency. As per SyWay design, EAM Characteristics will be standardized.


Conversion Scope

The scope of this document covers the approach for converting active EAM Characteristics from Legacy Source Systems into S/4HANA following the EAM Characteristics Master Data Design Standard. 

Characteristics define a single custom field used to capture specific properties, attributes or values of an object. In SAP, Classes and Characteristics together form the “Classification System”.
For Syensqo, Characteristics will be used to record key attributes supporting reliability categorization and various analyses. It will be primarily used for information and reporting of attribute data across a large set of technical objects (e.g. Functional Location Structure). These Characteristics will be created centrally and assigned to relevant Classes.

From the current source systems’ perspective, Class and Characteristic concepts already exist (but in slightly different structure). Characteristic data and their allowed values are independently managed between PF2 and WP2. While these have been identified as source systems, a considerable amount of data construction will be required to support the production of data load sheets in the desired format.

While these systems serve as sources, extensive construction will be necessary to produce properly formatted data load sheets for S/4 HANA. 
The scope of this document covers the approach for converting active Characteristics from Legacy systems (PF2, WP2) and creation of New EAM Characteristics into S/4 HANA following the Characteristics Master Data Design Standard. 

The data from legacy system includes:

  1. Characteristics (CABN-ATNAM) assigned to Classes with
Class Status = 1 (Released)Characteristics assigned to Classes with below Class Type
  1. below Class Type (KLAH-KLART)
    • 001-Material Class
    • 002-Equipment
class
    • Class
    • 003-Functional
location
  • 004-Ref. functional location
  • 007-Code groups
      • Location
      • </Start CR0164> 017-Document Management </End CR0164>
    009-Prod. resources/tools
      • 018-Task
    list class019-Work center class
      • List Class
      • 037-Measuring
    point
      • Point Class
  • 039-Master warranty
  • 049-Permits
      • 080-Maintenance Plans Class
    2. Characteristics assigned to active Legacy Measuring Points (IMPTT-POINT)
      1. Legacy Measuring Point linked to active Legacy Functional Location (IFLOT-TPLNR with System Status TJ02T-TXT04 <> INAC)
      2. Legacy Measuring Point linked to active Legacy Equipment (EQUI-EQNR with System Status TJ02T-TXT04 <> INAC)
    3. Status (CABN-ATMST) = 1 (Released)
    Valid from [Current Date]

    The data from legacy system excludes:

    1. Characteristics for Deletion (
    Deletion Indicator
    1. CABN-LKENZ = "X")

    List of source systems and approximate number of records 

    SourceScope

    Source Approx No. of Records

    		Target SystemTarget Approx

    No. of Records

    PF2, WP2

    Characteristics will be collected via DCT. An initial extract of the relevant Characteristics will be provided in google sheet format to assist business in decision making on including any relevant Characteristics from PF2 and WP2 as EAM Characteristics.

    Any additional Characteristics that need to be created to support the new design may be added in the DCT.

    A review and standardization will be done across all characteristics in the DCT. 

    		6,500

    Note: A full Data Construct will be created for Characteristics, as the SyWay design is changing and a complete standardization will be performed. While data may already exist, it cannot be easily transformed to align with the new SyWay data setup.

    		6,500
    		6,5008,000

    Additional Information

    Multi-language Requirement

    EAM Class Characteristic description will be made available in English.
    Multi language is supported for EAM ClassCharacteristics. Login Login via a different language will have its description displayed in the logon language if the language key is maintained in the Class Characteristics.

    Document Management

    Not Applicable

    Legal Requirement

    Not Applicable

    Special Requirements

    Not Applicable


    Target Design

    The technical design of the target for this conversion approach.


    1. Characteristics

    TableFieldData ElementField DescriptionData TypeLengthRequirement

    Data Cleansing

    Not Applicable. Standardization activities (including deduplication, standardization and additions)  will be carried out within the DCT.

    IDCriticalityError Message/Report DescriptionRuleOutputSource System

    Conversion Process

    The high-level process is represented by the diagram below:

    Data Privacy and Sensitivity

    CABNATNAMATNAMCharacteristic NameCHAR30Mandatory
    CABNDATUVDATUVValid-From DateDATS8Mandatory
    CABNATKLAATKLACharacteristics GroupCHAR10
    CABNATMSTATMSTStatus of a characteristicCHAR1Mandatory
    CABNATFORATFORData TypeCHAR4Mandatory
    CABNANZSTANZSTNumber of CharactersINT25

    Mandatory

    (When Data Type = CURR, CHAR, NUM)

    CABNANZDZANZDZNumber of Decimal PlacesINT25

    Mandatory

    (When Data Type = NUM)

    CABNATKLEATKLECase SensitiveCHAR1

     

    CABNCURRENCYCURRENCYCurrency KeyCUKY1

    Mandatory

    (When Data Type = CURR)

    CABNMSEHIMSEHIUnit of MeasureUNIT6


    CABNATSCHATSCHValue with templateCHAR30

     

    CABNATDEXATDEXExponent Display FormatNUMC1


    CABNATEINATEINSingle ValueCHAR1
    CABNATGLAATGLAIndicator: restrictable characteristicCHAR1
    CABNATERFATERFEntry RequiredCHAR1
    CABNATINTATINTInterval values allowedCHAR1
    CABNATVORATVORValue with Plus or Minus SignCHAR1
    CABNATSONATSONIndicator: Additional ValuesCHAR1
    CABNATBEWATBEWSingle/Multiple ValueCHAR1System


    2. Characteristic Descriptions

    TableFieldData ElementField DescriptionData TypeLengthRequirement
    CABNATNAMATNAMCharacteristic NameCHAR30Mandatory
    CABNTATBEZATBEZCharacteristic descriptionCHAR30Mandatory
    CABNTSPRASSPRASLanguage Key (Characteristic Description)LANG1Mandatory

    Note: Each Characteristic must have 1 entry for each language in scope: English, French, Italian, Mandarin, Brazilian Portuguese, German and Spanish


    3. Characteristic Restrictions to Class Types

    TableFieldData ElementField DescriptionData TypeLengthRequirement
    CABNATNAMATNAMCharacteristic NameCHAR30Mandatory
    KSMLKLARTKLASSENARTClass TypeCHAR3Mandatory

    Note: One Characteristic should have at least one Class Type Restriction assigned.


    4. Characteristic Values

    TableFieldData ElementField DescriptionData TypeLengthRequirement
    CABNATNAMATNAMCharacteristic NameCHAR30Mandatory
    CAWNATWRTATWRTCharacteristic ValueCHAR30
    CAWNCURR_FROMCAWN_CURR_FROMCharacteristic ValueCURR23
    CAWNCURR_TOCAWN_CURR_TOCharacteristic ValueCURR23
    CAWNCURRENCYWAERS_CURRCharacteristic ValueCUKY5
    CAWNDATE_FROMCAWN_DATE_FROMCharacteristic ValueDATS8
    CAWNDATE_TOCAWN_DATE_TOCharacteristic ValueDATS8
    CAWNDEC_FROMCAWN_DEC_FROMCharacteristic ValueDECFLOAT3434
    CAWNDEC_TOCAWN_DEC_TOCharacteristic ValueDECFLOAT3434
    CAWNTIME_FROMCAWN_TIME_FROMCharacteristic ValueTIMS6
    CAWNTIME_TOCAWN_TIME_TOCharacteristic ValueTIMS6
    CAWNATSTDATSTDDefault valueCHAR1
    CAWNATCODATCODCode for Value DependencyCHAR1System

    Note: Allowed Values is to be defined for the Characteristic (where applicable).


    5. Characteristic Value Descriptions

    TableFieldData ElementField DescriptionData TypeLengthRequirement
    CAWNATNAMATNAMCharacteristic NameCHAR30Mandatory
    CAWNATWRTATWRTCharacteristic ValueCHAR30Mandatory
    CAWNTSPRASSPRASLanguage Key (Characteristic Value Description)LANG1Mandatory
    CAWNTATWTBATWTBCharacteristic Value DescriptionCHAR30Mandatory

    Note: Each Characteristic Value must have 1 entry for each language in scope: English, French, Italian, Mandarin, Brazilian, Portuguese, German and Spanish


    Characteristics A2D Data strictly adheres to the Master Data Standard. The complete information of the key fields that hold the Characteristic information follows the Master Data Standard document that is located here.


    Data Cleansing

    No data cleansing is required for Characteristics in the legacy systems. If any cleansing is deemed necessary, it will be performed outside of the systems.

    As a result, the cleansed Characteristics data will be populated directly in the Data Collection Template (DCT).

    IDCriticalityError Message/Report DescriptionRuleOutputSource System


    		Not Applicable



    Conversion Process

    The high-level process is represented by the diagram below:

    Image Added

    Collection will be done manually in the Data Collection Template for the following scenarios:

    • For new Characteristics that need to be created to support the to-be design


    Data Privacy and Sensitivity

    Not Applicable


    Extraction

    1. Extract data from a source into Syniti Migrate. There are 2 possibilities:

      1. The data exists. Syniti Migrate connects to the source and loads the data into Syniti Migrate. There are 3 methods:
        1. Perform full data extraction from relevant tables in the source system(s).
        2. Perform extraction through the application layer.
        3. Only if Syniti Migrate; cannot connect to the source, data is loaded to the repository from the provided source system extract/report.
      2. The data does not exist (or cannot be converted from its current state). The data is manually collected by the business directly in Syniti Migrate. This is to be conducted using DCT (Data Collection Template) in Syniti Migrate

      The agreed Relevancy criteria is applied to the extracted records as reference point to identify the records that are applicable for the data construction in the DCT.

    Extraction Run Sheet

    Req #Requirement DescriptionTeam Responsible
    1Extract data from source system based on relevancy ruleSyWay Data Team
    2Google Sheet report pre-populated with PF2 and WP2 information to be generated based on relevancy criteria. SyWay Data Team


    Selection Screen

    Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set
    Not Applicable




    Data Collection Template (DCT)

    Target Ready Data Collection Template will be created for EAM Characteristics  data with exception of some fields which require transformation as mentioned in the transformation rule.

    1. The extracted report will be loaded into the required structure using the DCT.
    2. Standardization activities (including deduplication, standardization and additions)  will be carried out within the DCT.

    Delta Data Management: Initial collection will be done via the report and one-time load to the DCT will be performed. Any delta after the initial collection within the DCT will require business to take due diligence to ensure any subsequent delta cleansing is verified and aligned within the DCT.

    Note: All rules specified below should be documented as a tooltip in the DC Page.

    Format:

    • Line 1: Mandatory / Conditional
    • Line 2: Remaining text

    1. Characteristics Data Construction Rules

    Field NameField DescriptionRule
    ATNAMCharacteristic Name

    Mandatory.

    Staging identifier used to uniquely define an A2D characteristic.

    DATUVValid-From Date

    Conditional.

    Provide a value indicating when this characteristic will be valid for use. Otherwise, leave blank.

    ATKLACharacteristics Group

    Conditional.

    • Must be a valid Characteristic Group (TCMG).
    • If the characteristic belongs to a group of similar characteristics, assign it to the appropriate characteristic group. Otherwise, leave the field blank
    • Characteristic Groups have the format <Group Code>_XXXX where Group Code is a 2 character field representing the functional group it relates to e.g. AM – Asset Management and XXXX is a 4 character abbreviation of the class the characteristics relate to.
    • For characteristics that are specific to a Measuring Point and intended for use only on that object, the characteristic will be assigned to a dedicated Characteristics Group called MP_GNRL with description ''Asset Measuring Points'' 
    • Char groups shall align with class groups.
    ATFORData Type

    Mandatory.

    Allowed values:

    • Character format (CHAR): for characteristic values that consist of a character string
    • Numeric format (NUM): for numeric characteristic values
    • Date format (DATE): for characteristic values that represent a date
    • Time format (TIME): for characteristic values that represent a time
    • Currency format (CURR): for characteristic values that are entered in a currency

    Ensure use of a valid data type.

    ANZSTNumber of Characters

    Conditional.

    This field must be filled, when Data Type chosen '' CURR, CHAR, NUM'' 
    Maximum value=30 for CHAR
    Maximum value=15 for CURR
    Maximum value=15 for NUM

    ANZDZNumber of Decimal Places

    Conditional.

    This field must be filled when the Data Type is set to NUM. 
    When 'CURR' is chosen, the field is automatically populated based on the selected currency.

    ATKLECase Sensitive

    Conditional.

    Indicator (check box).

    Allowed Values:

    " " = Not Checked

    "X" = Checked

    This field can to be filled, when Data Type chosen CHAR.

    CURRENCYCurrency Key

    Conditional.

    This needs to be filled, when data type chosen CURR.

    MSEHIUnit of Measure

    Conditional.

    This can be filled, when data type chosen NUM

    ATSCHValue with template

    Conditional.

    Allowed Values:

    Values as per configuration (TCPS)

    This can be filled, when data type chosen CHAR, NUM, CURR

    ATDEXExponent Display Format

    Conditional.

    Allowed values:              
    0: No exponent
    1: Standard
    2: Exponent entered
    3: Scientific exponent

    ATEINSingle Value

    Conditional.

    Indicator (check box).

    Allowed Values:

    " " = Not Checked

    "X" = Checked

    If the option 'Single Value' is selected "X", this means only one value can be assigned to the Characteristic.
    If the option 'Single Value' is not selected "", this means multiple values can be assigned to the Characteristic.

    ATGLAIndicator: restrictable characteristic

    Conditional.

    Indicator (check box).

    Allowed Values:

    " " = Not Checked

    "X" = Checked

    This can be marked, when data type chosen CHAR, CURR, DATE, NUM, TIME
    This can only be checked (marked "X") if the "Single Value" checkbox is checked (marked "X").

    ATERFEntry Required

    Conditional.

    Indicator (check box).

    Allowed Values:

    " " = Not Checked

    "X" = Checked

    This can be marked, when data type chosen CHAR, CURR, DATE, NUM, TIME

    ATINTInterval values allowed

    Conditional.

    Indicator (check box).

    Allowed Values:

    " " = Not Checked

    "X" = Checked

    This can be marked, when data type chosen CURR, DATE, NUM, TIME

    ATVORValue with Plus or Minus Sign

    Conditional.

    Indicator (check box).

    Allowed Values:

    " " = Not Checked

    "X" = Checked

    This can be marked, when data type chosen CURR, NUM

    ATSONIndicator: Additional Values

    Conditional.

    Indicator (check box).

    Allowed Values:

    " " = Not Checked

    "X" = Checked

    This can only be checked (marked "X") if the “Indicator: restrictable characteristic” checkbox is checked (marked "X").

    ATBEZ_ENDescription (English)

    Mandatory.

    Ensure to that this Class Description is in English.

    Ensure that it does not include any of below characters: 
    ;        Semi-colon
    :        Colon
    ::        Double Colon
    ?        Question Mark
    /        Forward Slash
    @        At sign
    &        Ampersand
    =        Equal Sign
    +        Plus Sign
    $        Dollar Sign
    %        Percent
    |        Vertical Bar
    []        Left or Right Square Bracket
    "        Double Quotes

    ATBEZ_FRDescription (French)

    Mandatory.

    Ensure to that this Class Description is in French.

    Ensure that it does not include any of below characters: 
    ;        Semi-colon
    :        Colon
    ::        Double Colon
    ?        Question Mark
    /        Forward Slash
    @        At sign
    &        Ampersand
    =        Equal Sign
    +        Plus Sign
    $        Dollar Sign
    %        Percent
    |        Vertical Bar
    []        Left or Right Square Bracket
    "        Double Quotes

    ATBEZ_ITDescription (Italian)

    Mandatory.

    Ensure to that this Class Description is in Italian.

    Ensure that it does not include any of below characters: 
    ;        Semi-colon
    :        Colon
    ::        Double Colon
    ?        Question Mark
    /        Forward Slash
    @        At sign
    &        Ampersand
    =        Equal Sign
    +        Plus Sign
    $        Dollar Sign
    %        Percent
    |        Vertical Bar
    []        Left or Right Square Bracket
    "        Double Quotes

    ATBEZ_ZHDescription (Mandarin)

    Mandatory.

    Ensure to that this Class Description is in Mandarin.

    Ensure that it does not include any of below characters: 
    ;        Semi-colon
    :        Colon
    ::        Double Colon
    ?        Question Mark
    /        Forward Slash
    @        At sign
    &        Ampersand
    =        Equal Sign
    +        Plus Sign
    $        Dollar Sign
    %        Percent
    |        Vertical Bar
    []        Left or Right Square Bracket
    "        Double Quotes

    ATBEZ_PTDescription (Brazilian Portuguese)

    Mandatory.

    Ensure to that this Class Description is in Portuguese.

    Ensure that it does not include any of below characters: 
    ;        Semi-colon
    :        Colon
    ::        Double Colon
    ?        Question Mark
    /        Forward Slash
    @        At sign
    &        Ampersand
    =        Equal Sign
    +        Plus Sign
    $        Dollar Sign
    %        Percent
    |        Vertical Bar
    []        Left or Right Square Bracket
    "        Double Quotes

    ATBEZ_DEDescription (German)

    Mandatory.

    Ensure to that this Class Description is in German.

    Ensure that it does not include any of below characters: 
    ;        Semi-colon
    :        Colon
    ::        Double Colon
    ?        Question Mark
    /        Forward Slash
    @        At sign
    &        Ampersand
    =        Equal Sign
    +        Plus Sign
    $        Dollar Sign
    %        Percent
    |        Vertical Bar
    []        Left or Right Square Bracket
    "        Double Quotes

    ATBEZ_ESDescription (Spanish)

    Mandatory.

    Ensure to that this Class Description is in Spanish.

    Ensure that it does not include any of below characters: 
    ;        Semi-colon
    :        Colon
    ::        Double Colon
    ?        Question Mark
    /        Forward Slash
    @        At sign
    &        Ampersand
    =        Equal Sign
    +        Plus Sign
    $        Dollar Sign
    %        Percent
    |        Vertical Bar
    []        Left or Right Square Bracket
    "        Double Quotes

    KLART_001Class Type (Material Class)

    Conditional.

    Indicator (check box).

    Allowed Values:

    " " = Not Checked

    "X" = Checked

    Select if to be assigned with 001-Material Class Type

    KLART_002Class Type (Equipment Class)

    Conditional.

    Indicator (check box).

    Allowed Values:

    " " = Not Checked

    "X" = Checked

    Select if to be assigned with 002-Equipment Class Type

    KLART_003Class Type (Functional Location)

    Conditional.

    Indicator (check box).

    Allowed Values:

    " " = Not Checked

    "X" = Checked

    Select if to be assigned with 003-Functional Location Class Type

    </Start CR0164>

    KLART_017

    </End CR0164>

    </Start CR0164>

    Class Type (Document Management)

    </End CR0164>

    </Start CR0164>

    Conditional.

    Indicator (check box).

    Allowed Values:

    " " = Not Checked

    "X" = Checked

    Select if to be assigned with 017-Document Management Class Type

    </End CR0164>

    KLART_018Class Type (Task List Class)

    Conditional.

    Indicator (check box).

    Allowed Values:

    " " = Not Checked

    "X" = Checked

    Select if to be assigned with 018-Task List Class Type

    KLART_037Class Type (Measuring Point  Class)

    Conditional.

    Indicator (check box).

    Allowed Values:

    " " = Not Checked

    "X" = Checked

    Select if to be assigned with 037-Measuring Point Class Type

    KLART_080Class Type (Maintenance Plans Class)

    Conditional.

    Indicator (check box).

    Allowed Values:

    " " = Not Checked

    "X" = Checked

    Select if to be assigned with 080-Maintenance Plan Class Type


    2. Characteristic Value Data Construction Rules

    Field NameField DescriptionRule
    ATNAMCharacteristic Name

    Mandatory.

    Should exist in Characteristics DCT Rules

    ATWRTCharacteristic Value

    Conditional.

    • If the characteristic has character format (CHAR), populate with alphanumeric characters.
    • If the characteristic has character format (DATE), must have the format DDMMYYYY. E.g. 31122000
    • If the characteristic has character format (TIME), must have the format HHMMSS. E.g. 110000
    • If the characteristic has character format (NUM), the field should contain only numerical characters. E.g. 888
    • If the characteristic has character format (CURR), this field should contain only numerical characters. E.g. 200

    Note for DATE, TIME, NUM and CURR formats:

    • If a range is required, the from and to values should be concatenated using a hyphen (" - ").
      • E.g. DATE: 1 - 2, 110000 -112855
    • Fill in only if Characteristic - Interval values allowed (ATINT) is populated with "X"
    • The Characteristic Value (From) should be <= Characteristic Value (To)
    ATSTDDefault value

    Conditional.

    Indicator (check box).

    Allowed Values:

    " " = Not Checked

    "X" = Checked

    If the business selects this checkbox for a value, it shall be marked; otherwise, it shall remain blank.

    ATWTB_ENDescription (English)

    Mandatory for Characteristics with Data Type = CHAR.

    Ensure to that this Class Description is in English.

    Ensure that it does not include any of below characters: 
    ;        Semi-colon
    :        Colon
    ::        Double Colon
    ?        Question Mark
    /        Forward Slash
    @        At sign
    &        Ampersand
    =        Equal Sign
    +        Plus Sign
    $        Dollar Sign
    %        Percent
    |        Vertical Bar
    []        Left or Right Square Bracket
    "        Double Quotes

    ATWTB_FRDescription (French)

    Mandatory for Characteristics with Data Type =CHAR.

    Ensure to that this Class Description is in French.

    Ensure that it does not include any of below characters: 
    ;        Semi-colon
    :        Colon
    ::        Double Colon
    ?        Question Mark
    /        Forward Slash
    @        At sign
    &        Ampersand
    =        Equal Sign
    +        Plus Sign
    $        Dollar Sign
    %        Percent
    |        Vertical Bar
    []        Left or Right Square Bracket
    "        Double Quotes

    ATWTB_ITDescription (Italian)

    Mandatory for Characteristics with Data Type =CHAR.

    Ensure to that this Class Description is in Italian.

    Ensure that it does not include any of below characters: 
    ;        Semi-colon
    :        Colon
    ::        Double Colon
    ?        Question Mark
    /        Forward Slash
    @        At sign
    &        Ampersand
    =        Equal Sign
    +        Plus Sign
    $        Dollar Sign
    %        Percent
    |        Vertical Bar
    []        Left or Right Square Bracket
    "        Double Quotes

    ATWTB_ZHDescription (Mandarin)

    Mandatory for Characteristics with Data Type =CHAR.

    Ensure to that this Class Description is in Mandarin.

    Ensure that it does not include any of below characters: 
    ;        Semi-colon
    :        Colon
    ::        Double Colon
    ?        Question Mark
    /        Forward Slash
    @        At sign
    &        Ampersand
    =        Equal Sign
    +        Plus Sign
    $        Dollar Sign
    %        Percent
    |        Vertical Bar
    []        Left or Right Square Bracket
    "        Double Quotes

    ATWTB_PTDescription (Brazilian Portuguese)

    Mandatory for Characteristics with Data Type =CHAR.

    Ensure to that this Class Description is in Portuguese.

    Ensure that it does not include any of below characters: 
    ;        Semi-colon
    :        Colon
    ::        Double Colon
    ?        Question Mark
    /        Forward Slash
    @        At sign
    &        Ampersand
    =        Equal Sign
    +        Plus Sign
    $        Dollar Sign
    %        Percent
    |        Vertical Bar
    []        Left or Right Square Bracket
    "        Double Quotes

    ATWTB_DEDescription (German)

    Mandatory for Characteristics with Data Type =CHAR.

    Ensure to that this Class Description is in German.

    Ensure that it does not include any of below characters: 
    ;        Semi-colon
    :        Colon
    ::        Double Colon
    ?        Question Mark
    /        Forward Slash
    @        At sign
    &        Ampersand
    =        Equal Sign
    +        Plus Sign
    $        Dollar Sign
    %        Percent
    |        Vertical Bar
    []        Left or Right Square Bracket
    "        Double Quotes

    ATWTB_ESDescription (Spanish)

    Mandatory for Characteristics with Data Type =CHAR.

    Ensure to that this Class Description is in Spanish.

    Ensure that it does not include any of below characters: 
    ;        Semi-colon
    :        Colon
    ::        Double Colon
    ?        Question Mark
    /        Forward Slash
    @        At sign
    &        Ampersand
    =        Equal Sign
    +        Plus Sign
    $        Dollar Sign
    %        Percent
    |        Vertical Bar
    []        Left or Right Square Bracket
    "        Double Quotes

    Note: Data Selection Value is to be defined for the Characteristic (where applicable).


    Extraction Dependencies

    Item #Step DescriptionTeam Responsible

    Not Applicable



    Transformation

    The Target fields are mapped to the applicable Legacy field that will be its source, this is a 3-way activity involving the Business, Functional team and Data team. This identifies the transformation activity required to allow to make the data Target ready:

    1. Perform value mapping and data transformation rules.
      1. Legacy values are mapped to the to-be values (this could include a default value)
      2. Values are transformed according to the rules defined in
    2. Prepare target-ready data in the structure and format that is required for loading via prescribed Load Tool. This step also produces the load data ready for business to perform Pre-load Data Validation

    Transformation Run Sheet

    Item #Step DescriptionTeam Responsible

    1

    Obtain DCT Sign-off from Business.

    SyWay Data Team

    2

    In dspMigrate, select the wave – S4/HANA – Plant Maintenance

    Syniti

    3

    Go to Process Area Launch and Process the Object – Characteristics

    Syniti

    4

    Review and Validate Error and Preload Reports

    Syniti

    5

    Execute the transformation to prepare the target tables

    Syniti

    6

    Validate data from pre-load and error reports

    Business/Data owner

    7

    Generate load files

    Syniti


    Transformation Rules

    1. Characteristics

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Generate as per this format: EAM_NNNNNN

    (NNNNNN represents a sequential number)

    • e.g. 
      EAM_000001 - 1st Characteristic in the DCT
    • EAM_000002 - 2nd Characteristic in the DCT
    • EAM_000099 - 99th Characteristic in the DCT, etc

    Note: For future deployments, this setup will need to be revisited to ensure the maximum EAM_NNNNNN value configured in the target system is considered. The next characteristic to be created should be Max(EAM_NNNNNN) + 1.

    2DCTCABNDATUVValid-From DateS/4 HanaCABNDATUVValid-From Date

    If has value in DCT, Direct Mapping.

    If blank, derive the date as per Value Mapping: OTH_Migration_Date Relevant Values A2D (using Object ID "1015" and Field Name = "CABN-DATUV".

    3DCTCABNATKLACharacteristics GroupS/4 HanaCABNATKLACharacteristics GroupDirect Mapping
    4DCTCABNATMSTStatus of a characteristicS/4 HanaCABNATMSTStatus of a characteristicDefault to ''1''
    5DCTCABNATFORData TypeS/4 HanaCABNATFORData TypeDirect Mapping
    6DCTCABNANZSTNumber of CharactersS/4 HanaCABNANZSTNumber of CharactersDirect Mapping
    7DCTCABNANZDZNumber of Decimal PlacesS/4 HanaCABNANZDZNumber of Decimal PlacesDirect Mapping
    8DCTCABNATKLECase SensitiveS/4 HanaCABNATKLECase SensitiveDirect Mapping
    9DCTCABNCURRENCYCurrency KeyS/4 HanaCABNCURRENCYCurrency KeyDirect Mapping
    10DCTCABNMSEHIUnit of MeasureS/4 HanaCABNMSEHIUnit of MeasureDirect Mapping
    11DCTCABNATSCHValue with templateS/4 HanaCABNATSCHValue with templateDirect Mapping
    12DCTCABNATDEXExponent Display FormatS/4 HanaCABNATDEXExponent Display FormatDirect Mapping
    13DCTCABNATEINSingle ValueS/4 HanaCABNATEINSingle ValueDirect Mapping
    14DCTCABNATGLAIndicator: restrictable characteristicS/4 HanaCABNATGLAIndicator: restrictable characteristicDirect Mapping
    15DCTCABNATERFEntry RequiredS/4 HanaCABNATERFEntry RequiredDirect Mapping
    16DCTCABNATINTInterval values allowedS/4 HanaCABNATINTInterval values allowedDirect Mapping
    17DCTCABNATVORValue with Plus or Minus SignS/4 HanaCABNATVORValue with Plus or Minus SignDirect Mapping
    18DCTCABNATSONIndicator: Additional ValuesS/4 HanaCABNATSONIndicator: Additional ValuesDirect Mapping
    19----S/4 HanaCABNATBEWSingle/Multiple Value

    • If the option 'Single Value' is selected "ATEIN=X", set to "S".

    • Otherwise, set to "M".


    2. Characteristic Descriptions

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTCABNTATBEZ_ENCharacteristic Description (English)S/4 HanaCABNTATBEZCharacteristic description

    Direct Mapping

    3DCTCABNTSPRASLanguage Key (Characteristic Description)S/4 HanaCABNTSPRASLanguage Key (Characteristic Description)Default to "E"

     UNION

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTCABNTATBEZ_FRCharacteristic description (French)S/4 HanaCABNTATBEZCharacteristic description

    Direct Mapping

    3DCTCABNTSPRASLanguage Key (Characteristic Description)S/4 HanaCABNTSPRASLanguage Key (Characteristic Description)Default to "F"

      UNION

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTCABNTATBEZ_ITCharacteristic description (Italian)S/4 HanaCABNTATBEZCharacteristic description

    Direct Mapping

    3DCTCABNTSPRASLanguage Key (Characteristic Description)S/4 HanaCABNTSPRASLanguage Key (Characteristic Description)Default to "I"

    UNION

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTCABNTATBEZ_ZHCharacteristic description (Mandarin)S/4 HanaCABNTATBEZCharacteristic description

    Direct Mapping

    3DCTCABNTSPRASLanguage Key (Characteristic Description)S/4 HanaCABNTSPRASLanguage Key (Characteristic Description)Default to "1"


    UNION

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTCABNTATBEZ_PTCharacteristic description (Brazilian Portuguese)S/4 HanaCABNTATBEZCharacteristic description

    Direct Mapping

    3DCTCABNTSPRASLanguage Key (Characteristic Description)S/4 HanaCABNTSPRASLanguage Key (Characteristic Description)Default to "P"

    UNION

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTCABNTATBEZ_DECharacteristic description (German)S/4 HanaCABNTATBEZCharacteristic description

    Direct Mapping

    3DCTCABNTSPRASLanguage Key (Characteristic Description)S/4 HanaCABNTSPRASLanguage Key (Characteristic Description)Default to "D"

    UNION

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTCABNTATBEZ_ESCharacteristic description (Spanish)S/4 HanaCABNTATBEZCharacteristic description

    Direct Mapping

    3DCTCABNTSPRASLanguage Key (Characteristic Description)S/4 HanaCABNTSPRASLanguage Key (Characteristic Description)Default to "S"


    3. Characteristic Characteristic Restrictions to Class Types

    Only get the records where KLART_001 = "X"

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTKSMLKLART_001Class Type (Material Class)S/4 HanaKSMLKLARTClass TypeDefault to "001"

    UNION

    Only get the records where KLART_002 = "X"

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTKSMLKLART_002Class Type (Equipment Class)S/4 HanaKSMLKLARTClass TypeDefault to "002"

    UNION

    Only get the records where KLART_003 = "X"

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTKSMLKLART_003Class Type (Functional Location)S/4 HanaKSMLKLARTClass Type

    Default to "003"

    UNION

    </Start CR0164>

    Only get the records where KLART_017 = "X"

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Direct Mapping

    2DCTKSMLKLART_017Class Type (Document Management)S/4 HanaKSMLKLARTClass TypeDefault to "017"

    </End CR0164>

    UNION

    Only get the records where KLART_018 = "X"

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTKSMLKLART_018Class Type (Task List Class)S/4 HanaKSMLKLARTClass TypeDefault to "018"

    UNION

    Only get the records where KLART_037 = "X"

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTKSMLKLART_037Class Type (Measuring Point  Class)S/4 HanaKSMLKLARTClass TypeDefault to "037"

    UNION

    Only get the records where KLART_080 = "X"

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTKSMLKLART_080Class Type (Maintenance Plans Class)S/4 HanaKSMLKLARTClass TypeDefault to "080"



    4. Characteristic Values

    Only get the records where Characteristics with Data Type = CHAR

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTCAWNATWRTCharacteristic ValueS/4 HanaCAWNATWRTCharacteristic ValueDirect Mapping
    3DCTCAWNATSTDDefault valueS/4 HanaCAWNATSTDDefault valueDirect Mapping
    4----S/4 HanaCAWNATCODCode for Value DependencyDefault to "3"

    Only get the records where Characteristics with Data Type = CURR

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTCAWNATWRTCharacteristic ValueS/4 HanaCAWNCURR_FROMCharacteristic Value

    If range: values concatenated using " - ", derive the value before " - ".

    Otherwise, direct mapping.

    3DCTCAWNATWRTCharacteristic ValueS/4 HanaCAWNCURR_TOCharacteristic Value

    If range: values concatenated using " - ", derive the value after " - ".

    Otherwise, leave blank.

    4DCTCABNCURRENCYCurrency KeyS/4 HanaCAWNCURRENCYCurrencyDerive from Currency Key of the Characteristics
    5DCTCAWNATSTDDefault valueS/4 HanaCAWNATSTDDefault valueDirect Mapping
    6----S/4 HanaCAWNATCODCode for Value DependencyDefault to "3"

    Only get the records where Characteristics with Data Type = DATE

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTCAWNATWRTCharacteristic ValueS/4 HanaCAWNDATE_FROMCharacteristic Value

    If range: values concatenated using " - ", derive the value before " - ".

    Otherwise, direct mapping.

    3DCTCAWNATWRTCharacteristic ValueS/4 HanaCAWNDATE_TOCharacteristic Value

    If range: values concatenated using " - ", derive the value after " - ".

    Otherwise, leave blank.

    4DCTCAWNATSTDDefault valueS/4 HanaCAWNATSTDDefault valueDirect Mapping
    5----S/4 HanaCAWNATCODCode for Value DependencyDefault to "3"

    Only get the records where Characteristics with Data Type = NUM

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTCAWNATWRTCharacteristic ValueS/4 HanaCAWNDEC_FROMCharacteristic Value

    If range: values concatenated using " - ", derive the value before " - ".

    Otherwise, direct mapping.

    3DCTCAWNATWRTCharacteristic ValueS/4 HanaCAWNDEC_TOCharacteristic Value

    If range: values concatenated using " - ", derive the value after " - ".

    Otherwise, leave blank.

    4DCTCAWNATSTDDefault valueS/4 HanaCAWNATSTDDefault valueDirect Mapping
    5----S/4 HanaCAWNATCODCode for Value DependencyDefault to "3"

    Only get the records where Characteristics with Data Type = TIME

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTCAWNATWRTCharacteristic ValueS/4 HanaCAWNTIME_FROMCharacteristic Value

    If range: values concatenated using " - ", derive the value before " - ".

    Otherwise, direct mapping.

    3DCTCAWNATWRTCharacteristic ValueS/4 HanaCAWNTIME_TOCharacteristic Value

    If range: values concatenated using " - ", derive the value after " - ".

    Otherwise, leave blank.

    4DCTCAWNATSTDDefault valueS/4 HanaCAWNATSTDDefault valueDirect Mapping
    5----S/4 HanaCAWNATCODCode for Value DependencyDefault to "3"


    5. Characteristic Value Descriptions:

    Only get the records where Characteristics with Data Type = CHAR

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTCAWNTSPRASLanguage Key (Characteristic Value Description)S/4 HanaCAWNTSPRASLanguage Key (Characteristic Value Description)Default to "E"
    3DCTCAWNATWRTCharacteristic ValueS/4 HanaCAWNATWRTCharacteristic ValueDirect Mapping
    4DCTCAWNTATWTB_ENCharacteristic Value Description (English)S/4 HanaCAWNTATWTBCharacteristic Value Description

    Direct Mapping

    UNION

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTCAWNTSPRASLanguage Key (Characteristic Value Description)S/4 HanaCAWNTSPRASLanguage Key (Characteristic Value Description)Default to "F"
    3DCTCAWNATWRTCharacteristic ValueS/4 HanaCAWNATWRTCharacteristic ValueDirect Mapping
    4DCTCAWNTATWTB_FRCharacteristic Value Description (French)S/4 HanaCAWNTATWTBCharacteristic Value Description

    Direct Mapping

    UNION

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTCAWNTSPRASLanguage Key (Characteristic Value Description)S/4 HanaCAWNTSPRASLanguage Key (Characteristic Value Description)Default to "I"
    3DCTCAWNATWRTCharacteristic ValueS/4 HanaCAWNATWRTCharacteristic ValueDirect Mapping
    4DCTCAWNTATWTB_ITCharacteristic Value Description (Italian)S/4 HanaCAWNTATWTBCharacteristic Value Description

    Direct Mapping

    UNION

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTCAWNTSPRASLanguage Key (Characteristic Value Description)S/4 HanaCAWNTSPRASLanguage Key (Characteristic Value Description)Default to "1"
    3DCTCAWNATWRTCharacteristic ValueS/4 HanaCAWNATWRTCharacteristic ValueDirect Mapping
    4DCTCAWNTATWTB_ZHCharacteristic Value Description(Mandarin)S/4 HanaCAWNTATWTBCharacteristic Value Description

    Direct Mapping

    UNION

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTCAWNTSPRASLanguage Key (Characteristic Value Description)S/4 HanaCAWNTSPRASLanguage Key (Characteristic Value Description)Default to "P"
    3DCTCAWNATWRTCharacteristic ValueS/4 HanaCAWNATWRTCharacteristic ValueDirect Mapping
    4DCTCAWNTATWTB_PTCharacteristic Value Description (Brazilian Portuguese)S/4 HanaCAWNTATWTBCharacteristic Value Description

    Direct Mapping

    UNION

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTCAWNTSPRASLanguage Key (Characteristic Value Description)S/4 HanaCAWNTSPRASLanguage Key (Characteristic Value Description)Default to "D"
    3DCTCAWNATWRTCharacteristic ValueS/4 HanaCAWNATWRTCharacteristic ValueDirect Mapping
    4DCTCAWNTATWTB_DECharacteristic Value Description (German)S/4 HanaCAWNTATWTBCharacteristic Value Description

    Direct Mapping

    UNION

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCTCABNATNAMCharacteristic NameS/4 HanaCABNATNAMCharacteristic Name

    Value Mapping: Characteristic A2D

    2DCTCAWNTSPRASLanguage Key (Characteristic Value Description)S/4 HanaCAWNTSPRASLanguage Key (Characteristic Value Description)Default to "S"
    3DCTCAWNATWRTCharacteristic ValueS/4 HanaCAWNATWRTCharacteristic ValueDirect Mapping
    4DCTCAWNTATWTB_ESCharacteristic Value Description (Spanish)S/4 HanaCAWNTATWTBCharacteristic Value Description

    Direct Mapping


    List of Custom Target Reports for this object is maintained here: Conversion Specification - Custom Reports Register.

    Transformation Mapping

    Mapping Table NameMapping Table Description
    Characteristic A2DOld to New Characteristic A2D
    OTH_Migration_Date Relevant Values A2DDates to be defaulted for A2D objects for each Migration Cycle

    Transformation Dependencies

    List the steps that need to occur before transformation can commence
    Item #Step DescriptionTeam Responsible
    1Ensure DCT tables completenessSyWay Data Team
    2Ensure all Transformation mappings are up to date.SyWay Data Team


    Pre-Load Validation

    Project Team

    Completeness

    TaskAction
    Verify Record CountSyWay A2D Data Team to verify that the total number of relevant records from the  DCT is equal to the total number of records in the Preload and Load Sheets.

    Accuracy

    TaskAction
    Conversion Accuracy

    SyWay A2D Data Team to verify that all fields below meet pass the checks:

    1. Mandatory Fields
    2. Field and Value Mapping Correctness
    3. Null Checks
    4. Text Length Checks
    Review Error ReportsReview and correct the errors.  Achieve a zero-error record count as much as possible. Raise defects for data remediated and requiring a correction in the source data.

    Business

    Completeness

    TaskAction
    Verify Record CountBusiness Data Owner/s to verify that the total number of relevant records from the the DCT is equal to the total number of records in the Preload and Load Sheets.

    Accuracy

    TaskAction
    Conversion AccuracyBusiness Data Owner/s to verify that all the data in the load table/file is accurate as per endorsed transformation/mapping rules (and signed-off DCT data).


    Load

    The load process includes:

    1. Execute the automated data load into target system using load tool or product the load file if the load must be done manually
    2. Once the data is loaded to the target system, it will be extracted and prepared for Post Load Data Validation

    Load Run Sheet

    Item #Step DescriptionTeam Responsible

    1

    Ensure Pre-load sign-offs are obtained.

    SyWay Data team

    2

    Go to the load tool and select the correct load Program.

    SyWay Data team

    3

    Proceed with Data load.

    SyWay Data team

    4

    Validate few records loaded by accessing standard transactions.

    SyWay Data team

    5

    Generate the post load reports in the tool.

    SyWay Data team

    6

    Log errors as defects, if any and address resolutions. Close defects.

    SyWay Data team

    7

    Resolve defects by re-upload and re-generate post load reports if necessary.

    SyWay Data team

    8

    Business to validate the post load files as part of post-load validation, raise data defects or provide the post-load sign-off.

    Business

    9

    Repeat steps 5 to 7 if necessary.

    SyWay Data team


    Load Phase and Dependencies

    Pre-Cutover

    Configuration

    Item #Configuration Item
    1T002-Language Keys
    2T006-Units of Measurement
    3TCMG-Characteristic Group
    4TCMS-Characteristic Status
    5TCPS-Define Characters in Templates

    Conversion Objects

    Object #Preceding Object Conversion Approach
    Not Applicable

    Error Handling

    Error TypeError DescriptionAction Taken
    Configuration

    Invalid Language Key

    Engage Functional team to expedite and fix the error in the system

    Configuration

    Invalid Units of Measurement

    Engage Functional team to expedite and fix the error in the system

    Configuration

    Invalid Characteristic Group

    Engage Functional team to expedite and fix the error in the system

    Configuration

    Invalid Characteristic Status

    Engage Functional team to expedite and fix the error in the system

    Configuration

    Invalid Value Template (Define Characters in Templates)

    Engage Functional team to expedite and fix the error in the system


    Post-Load Validation

    Project Team

    Completeness

    TaskAction

    Verify Count

    SyWay A2D Data Team to verify the record count created in target S/4 HANA by accessing post load reports in dspMigrate or standard reports from S/4 HANA.

    Verify Logs

    Check if there is data that failed to load and perform the necessary actions (e.g. register as post load issue or attempt to load the record again, etc.).


    Accuracy

    TaskAction

    Conversion Accuracy

    SyWay A2D Data Team to verify that the EAM Characteristics data in target S/4 HANA were loaded correctly via dspMigrate post load reports or standard reports from S/4 HANA. 


    Business

    Completeness

    TaskAction

    Verify Count

    Download Post Load Reports from dspMigrate and verify that the record count loaded in the target S/4 HANA is the same count as of the endorsed load file.


    Accuracy

    TaskAction

    Conversion Accuracy

    Verify that the EAM Characteristics data in target S/4 HANA were loaded correctly via dspMigrate post load reports or standard reports from S/4 HANA.


    Key Assumptions

    • Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
    • Data cleansing has met the required percentage threshold for the specified mock cycle and all preparation activities have been completed. (If applicable for Cleansing)
    • Data entries in DCT are target-ready data unless a specific transformation rule is stated for that field in the transformation rules.
    • Not all legacy Plant Maintenance (PM) Characteristics need to be mapped to S/4 HANA PM Characteristics. If any of the successor objects is dependent on a PM Characteristic field with no mapped values, this will be an enrichment activity or manual transformation for the successor object to derive the PM Characteristic

    Extraction

    Extract data from a source into . There are 2 possibilities:

    1. The data exists. connects to the source and loads the data into . There are 3 methods:
      1. Perform full data extraction from relevant tables in the source system(s).
      2. Perform extraction through the application layer.
      3. Only if ; cannot connect to the source, data is loaded to the repository from the provided source system extract/report.
    2. The data does not exist (or cannot be converted from its current state). The data is manually collected by the business directly in . This is to be conducted using DCT (Data Collection Template) in

    The agreed Relevancy criteria is applied to the extracted records to identify the records that are applicable for the Target loads

    Extraction Run Sheet

    Req #Requirement DescriptionTeam Responsible

    Selection Screen

    Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set

    Data Collection Template (DCT)

    Target Ready Data Collection Template will be created for data with exception of some fields which require transformation as mentioned in the transformation rule.

    DCT Rules

    Field NameField DescriptionRule

    Extraction Dependencies

    Item #Step DescriptionTeam Responsible

    Transformation

    The Target fields are mapped to the applicable Legacy field that will be its source, this is a 3-way activity involving the Business, Functional team and Data team. This identifies the transformation activity required to allow to make the data Target ready:

    1. Perform value mapping and data transformation rules.
      1. Legacy values are mapped to the to-be values (this could include a default value)
      2. Values are transformed according to the rules defined in
    2. Prepare target-ready data in the structure and format that is required for loading via prescribed Load Tool. This step also produces the load data ready for business to perform Pre-load Data Validation

    Transformation Run Sheet

    Item #Step DescriptionTeam Responsible

    Transformation Rules

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic

    Transformation Mapping

    Mapping Table NameMapping Table Description

    Transformation Dependencies

    List the steps that need to occur before transformation can commenceItem #Step DescriptionTeam Responsible

    Pre-Load Validation

    Project Team

    Completeness

    TaskAction

    Accuracy

    TaskAction

    Business

    Completeness

    TaskAction

    Accuracy

    TaskAction

    Load

    The load process includes:

    1. Execute the automated data load into target system using load tool or product the load file if the load must be done manually
    2. Once the data is loaded to the target system, it will be extracted and prepared for Post Load Data Validation

    Load Run Sheet

    Item #Step DescriptionTeam Responsible

    Load Phase and Dependencies

    Configuration

    Item #Configuration Item

    Conversion Objects

    Object #Preceding Object Conversion Approachlist the exact title of the conversion object of only the immediate predecessor – this will then confirm the DDD (Data Dependency Diagram)

    Error Handling

    Error TypeError DescriptionAction Taken

    Post-Load Validation

    Project Team

    Completeness

    TaskAction

    Accuracy

    TaskAction

    Business

    Completeness

    TaskAction

    Accuracy

    TaskAction

    Key Assumptions

    • Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
    • is in scope based on data design and any exception requested by business.


    See also

    Change log

    Change History
    limit10

    Workflow history

    Workflow Report
    parent@self
    hideheadertrue
    typeapprovals