You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 28 Current »

Status

  Revision in Progress

Owner
Stakeholders

Purpose

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

In both legacy systems, batch characteristics (class type 023) are used to hold key information related to Logistics & Quality information. Currently, there are more than 1,000 characteristics where these are duplicated with identical descriptions and assigned to different classes. To enable effective global utilization and reporting purposes, these characteristics need to be standardized. SyWay program to harmonize and standardize these characteristics across the organization.


Conversion Scope

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

SAP Batch Characteristics are specific data fields used within the SAP system to describe and manage the properties of a batch of materials. They are part of the SAP Classification System and are typically associated with class type 023 (Batch Class).

Material Batches capture detailed information about each batch, such as production date, quality parameters, supplier details, or any other relevant property and enable traceability; allow track and trace batches throughout the supply chain with structured data for analysis and reporting.

The data from legacy system includes:

  1. Characteristics assigned to Classes with below Class Type
    • 023 – Batch Class (PF2, WP2)
  2. Batch Characteristics assigned to Active Classes of 023.
  3. Valid from [Current Date]
  4. Status = 1 (Released)

The data from legacy system excludes:

  1. Characteristics for Deletion (Deletion Indicator = X)


List of source systems and approximate number of records
SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2

Batch Characteristics will be collected via DCT. An extract of the relevant Characteristics will be provided to assist business in standardizing the Characteristics from PF2 and WP2.

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


SAP S/4 HANA


WP2

Batch Characteristics will be collected via DCT. An extract of the relevant Characteristics will be provided to assist business in standardizing the Characteristics from PF2 and WP2.

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


SAP S/4 HANA


Additional Information

Multi-language Requirement

Characteristics descriptions are maintained in different languages. TBD on the Language Keys

Document Management

NA

Legal Requirement

NA

Special Requirements

NA




Target Design

The technical design of the target for this conversion approach.

Characteristics Definitions

TableFieldData ElementField DescriptionData TypeLengthRequirement
CABNATNAMATNAMCharacteristicCHAR30Mandatory
CABNDATUV

DATUV

Valid FromDATS8Mandatory
CABNTATBEZTEXT30DescriptionCHAR30Mandatory
CABNATKLAATKLACharacteristic GroupCHAR10Conditional
CABNATMSTATMSTStatusCHAR1Mandatory
CABNATFORATFORData TypeCHAR4Mandatory
CABNANZST

ANZST

Number of CharactersINT25Mandatory
CABNATKLE

ATKLE

Case SensitiveCHAR1Optional
CABNATSCHATSCHTemplateCHAR30Optional
CABNANZDZANZDZDecimal placesINT25

Optional

But if Data Type is CURR, this is Mandatory

CABNCURRENCYWAERS_CURCCurrencyCUKY1Mandatory (For Currency related Characteristics) / Optional
CABNATEINATEINValue AssignmentCHAR1Mandatory
CABNMSEHI

MSEHI

Unit of MeasureUNIT3Mandatory
CABNATDIMATDIM

Exponent display

INT25Mandatory
CABNATINTATINTInterval values allowedCHAR1Optional
CABNATVORATVORNegative values allowedCHAR1Optional
CABNATERFATERFEntry RequiredCHAR1Optional
CABNATGLAATGLARestrictedCHAR1Optional
CABNTSPRASSPRASLanguageLANG1Mandatory
CABNATSONATSONAdditional ValuesCHAR1Optional
CABNATPRTATPRTCheck TableCHAR30Conditional
CABNATTABATTABReference TableCHAR30Optional
CABNATFELATFELReference FieldCHAR30Optional
CABNATINPATINPNot ready for inputCHAR1Optional
CABNATVIEATVIENo displayCHAR1Optional
CABNATWRDATWRDDisplay Allowed ValuesCHAR1Optional
CABNATFODATFODUnformatted EntryCHAR1Optional
CABNATVSCATVSCPropose TemplateCHAR1Optional


Characteristics Values (SAP Standard and Custom Defined)


TableFieldData ElementField DescriptionData TypeLengthRequirement
CAWNATINNATINNInternal characteristicNUMC10Mandatory
CAWNATZHLATZHLInt counterNUMC4System Generated
CAWNATWRTATWRTCharacteristic ValueCHAR70Optional
CAWNDEC_FROM

CAWN_DEC_FROM

Lower Boundary for Numeric Field

DECFLOAT34

34Optional
CAWNDEC_TO

CAWN_DEC_TO

Upper Boundary for Numeric Field

DECFLOAT34

34Optional

 There are certain characteristics in system which are assigned as a Function Module (For Eg: Characteristic: LOBM_UDCODE) and these Characteristics values are deriving from Configuration. TBD to discuss with Functional for detail design.

Data Cleansing

No data cleansing is required within the source systems. Standardization and cleansing activities will be carried out outside of the Syniti tool, and the finalized characteristics will be populated in the DCT.

IDCriticalityError Message/Report DescriptionRuleOutputSource System

NANANANANA



Conversion Process

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


Data Privacy and Sensitivity

NA


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
1Legacy System Extraction (PF2 & WP2) based on the Relevancy Rules from Table: CABN & CABNTSyWay Data Team










Selection Screen

NA
Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set
NA




Data Collection Template (DCT)

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

Batch Characteristics Definition - DCT Rules

Field NameField DescriptionRule
ATNAM

Characteristic Name


Name that uniquely identifies a characteristic.

Follow the naming convention which will distinguish across different functions

For Eg:

QM_00001 (QM Related Characteristics)

SC_00001 (Supply/Logistics Related Characteristics)



Mandatory

TBD

Characteristics Name - Need to follow the naming Convention which will distinguish across different functions (Eg; Vendor Classification or EAM Characteristics)

DATUV

Valid From

The class validity starts from this date. If it is not set the current system date will be used as valid-from date.

Mandatory

When the Load File is generated, Current Date should be captured

ATBEZ

Description

Language-dependent description of characteristic.

  • Descriptions need to follow a standard naming convention across all characteristics.
  • Use similar formats for similar types of characteristics
  • Avoid abbreviations unless they are commonly accepted by Syensqo
ATKLA

Characteristic Group


The characteristics group can be used to group together similar characteristics. It is used to make finding characteristics easier.

Conditional

Need to select the appropriate characteristics group for the batch characteristics. As these are configurable values, these are TBD until Functional defines it.


ATMST

Status

The characteristic status gives information on the processing status of the characteristic and determines whether it can be used elsewhere in the system.
Possible values:
0 = in preparation
1 = released
2 = locked

Mandatory

Fixed Value as 1 - Released

ATFOR

Data Type

The data type defines whether a characteristic value is a character string, a number, a date, or a time.
CHAR Character Format
CURR Currency Format
DATE Date Format
NUM Numeric Format
TIME Time Format
UDEF User-Defined Data Type

Mandatory 

Below are list of values used: 

  • 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 (NUM): for characteristic values that are entered in a currency
ANZST

Number of Characters

Total number of characters that you can enter when you assign a value to this characteristic. This figure includes the number of decimal places.

This figure does not include plus or minus signs or decimal points.

Important:
In the S/4HANA cloud system, the number of characters, in a character format(CHAR) characteristic, max to 30.

Mandatory

  • If a characteristic has data type "character" (CHAR), you can maintain a language-dependent description for values. This description can be up to 30 characters long, regardless of the number you enter here.
  • If a characteristic has data type "Currency" (CURR), No of Characters to be maximum 15
  • If a characteristic has data type "Number" (CURR), No of Characters to be maximum 15
ATKLE

Case Sensitive

This indicator determines whether lower-case letters can be entered in characteristic values.
If this field is blank, the characteristic values entered are automatically converted into upper-case letters.
'X' = Case sensitive

Conditional

Indicator to set the characteristic values entered are automatically converted into upper-case letters.

ATSCH

Template

Entries for this characteristic are checked against this template.
Character format (CHAR): You can only define template characters which have been defined in Customizing. These settings determine whether a template can contain only letters, figures, figures or letters, or special characters.
Numeric format (NUM): Numeric template characters can also be defined in Customizing.

Optional

If these are defined in Configuration for  "character" (CHAR)for Need to use the specific template for this Characteristics. 

If these are defined in Configuration for  "Currency" (CURR), it is automatically populated.


ANZDZ

Decimal places


Total number of characters that you can enter when you assign a value to this characteristic. This figure includes the number of decimal places.

This figure does not include plus or minus signs or decimal points

When CURR is selected, Decimal Places are automatically populated
CURRENCY

Currency


Key for the currency in which the amounts are managed in the system (in ISO code).
The field is mandatory if the data type is currency (CURR).

Mandatory 

If CURR Data type is selected, Fill in the Currency of the characteristic.

ATEIN

Value Assignment

The possible entries for value assignment(Single/Multiple Value):
Value Descriptions
 S Single-value
 M Multiple value

Two options are possible: 

  • Single Values
  • Multiple Values
MSEHI

Unit of Measure


Unit in which a numeric characteristic value is entered. When you assign a value to the characteristic, you can enter a different unit if it can be converted to the unit entered in characteristics maintenance. The dimension (such as length or volume) determines which units can be converted to which

Conditional.

This can be filled, when data type chosen NUM
ATDIM

Exponent display

Specifies how the numerical value of a characteristic is to be displayed with an exponent.
Possible values:
0 = Display w/o an exponent
1 = Exponent set automatically.
 There's always one place before the decimal point
 Example: _,____E+__
2 = Display w/ exponent entered.
 Example: _,____E+33
3 = Display in scientific format (3,6,9)
 There are always three places before the decimal point
 Example: __,_____E+SS


Exponent used when characteristic value is displayed.
Can only be used for numerical characteristics

Conditional.

This can to be filled, when data type chosen NUM

List of Values: 
0: No exponent
1: Standard
2: Exponent entered
3: Scientific exponent

ATINT

Interval values allowed


This indicator determines whether you have the option of entering an interval as a value for a numeric characteristic.
'X' = Interval values allowed

Conditional.

Indicator (check box).

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

Negative values allowed


Defines whether negative values can be assigned to a characteristic.
'X' = negative values can be assigned

Conditional.

Indicator (check box).

ATERF

Entry Required

Determines whether you are required to assign a value to a characteristic.
'X' = entry is required

Conditional.

Indicator (check box).

SPRAS

Language

Please enter here the language of your description (ISO format).

Sy-Way Program Languages Scope: 

English, French, Italian, Mandarin, Brazilian Portuguese, German and Spanish.


English, French, Italian, Mandarin, Brazilian Portuguese, German and Spanish.


ATSON

Additional Values


This indicator determines whether values that are not defined as allowed values can be assigned to a characteristic.
'X' = no value check
The additional values indicator can be set to 'X' in the following value check types:
1. Allowed values
2. Function module

Conditional.

Indicator (check box).

ATGLA

Restrictable characteristic


This indicator shows that the allowed values of this characteristic can restricted during Variant
Configuration, depending on the configuration environment.
Note:
You can only use this indicator in constraints.
This indicator is not relevant to classification.

This is an indicator field. If the criterion is met, enter X. If not, leave the field empty.

Conditional 

Indicator (check box).

ATTAB

Reference Table


Name of a table that contains the allowed values for the characteristic.

This table can have exactly one key field. Tables that do not conform to this specification are not accepted.
This can can also contain a client.

If you want to check values using a table that does not conform to this specification, you can use a function module to define the check table.

Conditional

If the format of the Characteristics need to refer from Table, this is filled in

ATPRT

Check Table

To get the Characteristics values from Reference Table, Need to select this option so that we can reference the table to get the Characteristics Value. For Eg: UD Code Etc., 

Conditional

Transparent Table ( Check Table is maintained so that Characteristics Values are used from the Table in Transaction Data) 

ATFEL

Reference Field

This table can have exactly one key field


Conditional

If the format of the Characteristics need to refer from Table-Field, this is filled in

ATINP

Not ready for input

This indicator determines whether the characteristic is shown as available for entry on the characteristic value assignment screen.

If you do not want a value to be assigned to a characteristic, you must select this indicator. For example, the value may be inferred from object dependencies.

Conditional - If Reference Table and Field are not provided 

Mandatory - If the format of the characteristics needs to be referenced from a table, this information should be provided here.

ATVIE

No display

Characteristic Not to be Displayed

If you select this indicator, the characteristic is not shown on the characteristic value assignment screen. You see the Hidden characteristics pushbutton on the characteristic value assignment screen. Choose this pushbutton to see the characteristic.

If the Entry required indicator is set for the characteristic, you must assign a value to the characteristic, even if it is not shown on the screen. You see a dialog box before you leave the characteristic value assignment screen, in which you can assign a value to the characteristic.

Conditional.

Indicator (check box).

ATWRD

Display Allowed Values


Display allowed values defined in characteristic
Determines whether the allowed values for a characteristic are displayed after the characteristic when you assign values to a characteristic.

Conditional.

Indicator (check box).

ATFOD

Unformatted Entry


Unformatted entry control

Used to define the length of the entry field when assigning values to a characteristic.

If this field is not selected, the entry field is shortened to the number of characters in the format for the characteristic. Otherwise, a 30-character field is available for entry, so that you can enter intervals or several values, separated by a semicolon.

Conditional.

Indicator (check box).

ATVSC

Propose Template

If we use template to populate the Characteristics Values using the Template.

Indicator: display template when assigning values
Indicator: defines whether the template is displayed in the characteristic value field as an aid to entry.


For Eg: 

 If we use template, Example: _,____E+__


Conditional.

Indicator (check box).


Characteristics Values - DCT Rules


Field NameField DescriptionRule
ATINN

Internal characteristic

Name that uniquely identifies a characteristic.

Mandatory

TBD

This should be assigned from CABN-ATNAM

ATZHL

Int counter

The item number is only an additional technical key to allow multiple values in the file and to prevent errors by the duplicate record check.
It must be unique over all "Value" structures because it is also a key field for the "Value Descriptions".
It is not mapped to a target field.
Please maintain a number from 0001 to 9999 per multiple value.

System Generated. 

System creates a internal sequential number for each Characteristic Value


ATWRT

Characteristic Value


The language-dependent long value of a characteristic.
You must either maintain the language-dependent value (description) here in this column.

Important:
In the S/4HANA cloud system, the length of the characteristic value, in a character format(CHAR) characteristic, max to 30.

Optional

Characteristics values are defined here if these are created in Characters.

DEC_FROM

Lower Boundary for Numeric Field

Internal Floating Point From

Numerical Value from (Floating point)
Ignore the automatically set decimals.
NUM values can be entered with or without a decimal separator, for example 1000 or 1000.99.
Missing Decimals are automatically set when pressing Enter.
The value is related on the Unit of measure (UoM) maintained on the header data of the characteristics.
For example, if the UoM of the characteristic is JHR, '2' means two years.
The system ignores units in the fields UNIT_FROM and UNIT_TO here. These are used only for later display.
It is important that the UoM according to ISO 639 in the field VALUE_FROM_ISO is the same as the characteristic that was defined for the characteristic.



Optional

From Characteristics values are defined here if these are created in Numeric For Eg: 0 % - 100% Etc.


Relational operators to define the intervals with the following input options:
 Code Operator Value1(Value From) Operator Value2(Value To)
 1 EQ =
 2 GE >= LT <
 3 GE >= LE <=
 4 GT > LT <
 5 GT > LE <=
 6 LT <
 7 LE <=
 8 GT >
 9 GE >=
For example:
VALUE_FROM: 20
VALUE_TO: 28
VALUE_RELATION: 2
Imported value: 20 - < 28

DEC_TO

Upper Boundary for Numeric Field

Internal Floating Point To

Numerical Value to (Floating point) (only used in intervals)
Ignore the automatically set decimals.
NUM values can be entered with or without a decimal separator, for example 1000 or 1000.99.
Missing Decimals are automatically set by the Spreadsheet, when pressing Enter.
The value is related on the characteristic's Unit of measure.

To Characteristics values are defined here if these are created in Numeric For Eg: 0 % - 100% Etc.

Extraction Dependencies

Item #Step DescriptionTeam Responsible
1Extract data from source systems PF2 and WP2Syniti
2Populate in a report in a Downloadable formatSyniti
3Data is populated in the DCT or uploaded from downloaded Excel template Business/Data Owners
4If the data is uploaded to DCT in bulk via excel template, any upload errors need to be reviewed and corrected  Business/Data Owners
5The data which has passed validation checks in DCT will be used for transformation/further processing  Business/Data Owners


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.

SCM Data Team

2

In dspMigrate, select the wave – S4/HANA – P2F-SCM

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

Batch Characteristics Definition - DCT Rules 

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCTCABNATNAMCharacteristicS/4 HANACABNATNAMCharacteristic

Direct Mapping

3DCTCABNDATUVValid FromS/4 HANACABNDATUVValid From

If has value in DCT, Direct Mapping.

If blank, default to Creation Date.

4DCTCABNTATBEZDescriptionS/4 HANACABNTATBEZDescriptionDirect Mapping
5DCTCABNATKLACharacteristic GroupS/4 HANACABNATKLACharacteristic GroupDirect Mapping
6DCTCABNATMSTStatusS/4 HANACABNATMSTStatusDirect Mapping
8DCTCABNATFORData TypeS/4 HANACABNATFORData Type

Direct Mapping

Need Dropdown in DCT.

1) CHAR

2) NUM

3) CURR

9DCTCABNANZSTNumber of CharactersS/4 HANACABNANZSTNumber of CharactersDirect Mapping
10DCTCABNATKLECase SensitiveS/4 HANACABNATKLECase SensitiveDirect Mapping
11DCTCABNATSCHTemplateS/4 HANACABNATSCHTemplateDirect Mapping
12DCTCABNANZDZDecimal placesS/4 HANACABNANZDZDecimal places

Direct Mapping

Valid for only Data Type CURR 

13DCTCABNCURRENCYCurrencyS/4 HANACABNCURRENCYCurrencyDirect Mapping
14DCTCABNATEINValue AssignmentS/4 HANACABNATEINValue AssignmentDirect Mapping
15DCTCABNMSEHIUnit of MeasureS/4 HANACABNMSEHIUnit of MeasureDirect Mapping
16DCTCABNATDIM

Exponent display

S/4 HANACABNATDIM

Exponent display

Direct Mapping
17DCTCABNATINTInterval values allowedS/4 HANACABNATINTInterval values allowedDirect Mapping
18DCTCABNATVORNegative values allowedS/4 HANACABNATVORNegative values allowedDirect Mapping
20DCTCABNATERFEntry RequiredS/4 HANACABNATERFEntry RequiredDirect Mapping

DCTCABNATGLARestrictedS/4 HANACABNATGLARestrictedDirect Mapping
21DCTCABNTSPRASLanguageS/4 HANACABNTSPRASLanguageDirect Mapping
22DCTCABNATSONAdditional ValuesS/4 HANACABNATSONAdditional ValuesDirect Mapping
23DCTCABNATTABReference TableS/4 HANACABNATTABReference TableDirect Mapping
24DCTCABNATFELReference FieldS/4 HANACABNATFELReference FieldDirect Mapping
25DCTCABNATPRTCheck TableS/4 HANACABNATPRTCheck Table

Direct Mapping

If check table is assigned then Characteristics Values are not populated in Characteristic Values DCT.

26DCTCABNATINPNot ready for inputS/4 HANACABNATINPNot ready for inputDirect Mapping
27DCTCABNATVIENo displayS/4 HANACABNATVIENo displayDirect Mapping
28DCTCABNATWRDDisplay Allowed ValuesS/4 HANACABNATWRDDisplay Allowed ValuesDirect Mapping
29DCTCABNATFODUnformatted EntryS/4 HANACABNATFODUnformatted EntryDirect Mapping
30DCTCABNATVSCPropose TemplateS/4 HANACABNATVSCPropose TemplateDirect Mapping


Characteristics Values - DCT Rules


Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCTCAWNATINNInternal characteristicS/4 HANACAWNATINNInternal characteristic

Direct Mapping

2DCTCAWNATZHLInt counterS/4 HANACAWNATZHLInt counterDirect Mapping
3DCTCAWNATWRTCharacteristic ValueS/4 HANACAWNATWRTCharacteristic ValueDirect Mapping
4DCTCAWNDEC_FROM

Lower Boundary for Numeric Field

S/4 HANACAWNDEC_FROM

Lower Boundary for Numeric Field

Direct Mapping
5DCTCAWNDEC_TO

Upper Boundary for Numeric Field

S/4 HANACAWNDEC_TO

Upper Boundary for Numeric Field

Direct Mapping

Transformation Mapping

Mapping Table NameMapping Table Description








Transformation Dependencies

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

1

Ensure DCT tables completeness

Syniti

2

Ensure all Transformation mappings are up to date.

Syniti








Pre-Load Validation

Project Team

Completeness

TaskAction
Verify DCT & Load File Count

SCM 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.

Verify Consent

Verify the appropriate consents for the records have been obtained by the business/Data Owners and properly recorded


Accuracy

TaskAction

Conversion Accuracy

SCM Data team to verify that all the data in the load table/file is accurate as per signed-off DCT contents and transformation rules with below checks: 

  1. Mandatory Fields
  2. Field and Value Mapping Correctness
  3. Null 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 Count

Business 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.

Verify Consent

Verify that the appropriate consents for the records have been obtained by the business and properly recorded


Accuracy

TaskAction

Conversion Accuracy

Business 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
  3. Load approach: Migration Cockpit using Staging Tables

Load Run Sheet

Item #Step DescriptionTeam Responsible

1

Ensure Pre-load sign-offs are obtained.

SCM Data team

2

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

SCM Data team

3

Proceed with Data load.

SCM Data team

4

Validate few records loaded by accessing standard transactions.

SCM Data team

5

Generate the post load reports in the tool.

SCM Data team

6

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

SCM Data team

7

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

SCM 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.

SCM Data team


Load Phase and Dependencies

Pre Cutover

Configuration


Item #Configuration Item
1V_CMG - Characteristics Group
2T002 - Language Keys

Conversion Objects

Object #Preceding Object Conversion Approach
NANA




Error Handling

Error TypeError DescriptionAction Taken
Configuration<configuration> is not valid/missing

If it is a missing configuration item, then engage Functional team to expedite and fix the error in the system.

Invalid Data

<parameter> is not valid.

The parameter entry needs to be reviewed

If it is an invalid data, business needs to review and correct the source of the data either in PE1 or if it’s mapped in DCT.

Technical Setup

Interface / Connection issue within target system’s landscape

N/A – the data will be loaded directly to S/4HANA environment


Post-Load Validation

Project Team

Completeness

TaskAction
Verify the count

Verify that the record count in the post-load file is the same as the record count based on the relevancy (including any deduplication) results 


Accuracy

TaskAction

Data Accuracy

SCM Data team to verify that all the data in the post load table/file is accurate as per signed-off transformation rules and DCT contents

Error Reports

Verify that all necessary error reports have been validated, and that errors have been addressed.

Data Consistency

Verify that the data loaded is correctly reflected in T-Code: CT04 or Table: CABN/CABNT.


Business

Completeness

TaskAction

Verify Count

Verify that the record count in the post load file is the same as the record count based on the relevancy (including deduplication) results

Validate Loaded Data

Validate, as per the load files signed-off, that all records were created


Accuracy

TaskAction

Data Accuracy

Verify that all the data in the S/4HANA table is accurate as per signed-off DCT contents and transformation rules

For mock loads, the post load data validation will be as per scrambled data, thus data accuracy is not to be checked against DCT which holds the actual data. Post-load data to be validated against the pre-load report (scrambled data).

Verify Relationships

Verify that each Vendor have been assigned to the appropriate Business Partner correctly


Key Assumptions

  • The Master Data Standards document is a evolving document where value mappings/validation checks are still being finalized as we are currently in the detailed phase as of September 2025.
  • Batch Characteristics is in scope based on data design and any exception requested by business.


See also

Change log

Version Published Changed By Comment
CURRENT (v. 28) Nov 19, 2025 15:29 RAYUDU-ext, Narasimha Kumar
v. 28 Nov 18, 2025 17:48 RAYUDU-ext, Narasimha Kumar
v. 27 Nov 18, 2025 17:05 RAYUDU-ext, Narasimha Kumar
v. 26 Oct 30, 2025 18:23 RAYUDU-ext, Narasimha Kumar Field ATPRT added.
v. 25 Oct 15, 2025 13:54 RAYUDU-ext, Narasimha Kumar Copy Paste Issue for Char Values
v. 24 Oct 08, 2025 14:15 RAYUDU-ext, Narasimha Kumar Added CAWN as there are standard and non standard Characteristics values in system.
v. 23 Sept 26, 2025 13:14 RAYUDU-ext, Narasimha Kumar
v. 22 Sept 26, 2025 12:36 RAYUDU-ext, Narasimha Kumar
v. 21 Sept 26, 2025 12:33 RAYUDU-ext, Narasimha Kumar
v. 20 Sept 26, 2025 12:30 RAYUDU-ext, Narasimha Kumar

Go to Page History

  • No labels