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

Compare with Current View Page History

« Previous Version 13 Next »

Status

  Approved

Owner
Stakeholders

Purpose

The purpose of this document is to define the conversion approach to upload Materials - Classification and Characteristic Assignment in S/4 HANA as part of the Material Data Migration.

Link to MDS: DD-FUN-050 Master Data Standard_2023-Materials - Classification and Characteristic Assignment


Conversion Scope

The scope of this document covers the approach for converting active Values data, linked to Materials and Characteristics of Class Type 001, from Legacy Source Systems into S/4HANA following the Material Master Data Design Standard.


This object is migrated after Material Basic Data, therefore only materials in scope for the object "2019 - Materials Basic Data View" are in scope for this object.  Click here to go to the Conversion Spec for 2019 to see the full set of relevancy rules.


List of source systems and approximate number of records ***************
SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

DCTLinking Materials (2019 - Materials Basic Data View) to Classes (2017 Material - Class Type 001)

Materials: 260,000 **
Classes: 4

** As per Material relevancy criteria

S4H197,141 **
** This will change based on the Material Deduplication Process
DCTLinking Classes to Characteristics (2018 Materials - Characteristics of Class Type 001)Classes: 4
Characteristics: 41
S4H164 ******
****** Need info
DCTMaterials & Characteristics to Values assignment

Materials: 260,000 **
Characteristics: 39

** This will change based on the Material Deduplication Process

S4H10.14 Million
PF2 & WP2Materials & Characteristics to Values assignment specifically for:
Characteristics: Z_SY_MAT_OLD_PART_NUMBER & Z_SY_MAT_OLD_PART_DESCRIPTION
Values: MARA-MATNR & MAKT-MAKTX, as well as the BAAN info.

Materials: 260,000 **
Characteristics: 2

** This will change based on the Material Deduplication Process

S4H520,000 **
** This will change based on the Material Deduplication Process

Predecessor Object

2017 Materials - Class Type 001 → 2018 Materials - Characteristics of Class Type 0012023 Materials - Classification and Characteristic Assignment.
                                                                                  2019 Materials - Basic Data View


Additional Information

Multi-language Requirement

Not Applicable

Document Management

Not Applicable

Legal Requirement

Not Applicable

Special Requirements

Not Applicable



Target Design

As per MDS.  This is for reference, see below for the actual requirement.

TableFieldField DescriptionData TypeLengthRequirement
MARAMATNRMaterial NumberCHAR18Required
KLAHKLARTClass typeCHAR3Required
KLAHCLASSClassCHAR18Required
KSSKSTDCLIndicator: Standard ClassCHAR1System
KSSKSTATUClassification statusCHAR1System
KSSKZAEHLSort positionINT25System
CABNTATBEZCharacteristic DescriptionCHAR30System
AUSPATWRTCharacteristic Value--Required


The technical design of the target for this conversion approach.

TableFieldField DescriptionData TypeLengthRequirementTemp
MARAMATNRMaterial NumberCHAR18Required
MARAMTARTMaterial TypeCHAR4Required
TableFieldField DescriptionData TypeLengthRequirementTemp
KLAHCLINTInternal Class NumberNUMC10Required
KLAHCLASSClass NameCHAR18Required
TableFieldField DescriptionData TypeLengthRequirementTemp
CABNATINNInternal CharacteristicNUMC10Required
CABNATNAMCharacteristic NameCHAR30Required
TableFieldField DescriptionData TypeLengthRequirementTemp

CAWN

ATINN

Internal characteristic

NUMC

10

Required


CAWN

ATZHL

Int Counter

NUMC

4

Required


CAWN

ATWRT

Value

CHAR

70

Required


CAWN

ATSTD

Default Value

CHAR

1

Conditional


TableFieldField DescriptionData TypeLengthRequirementTemp
KSMLCLINTInternal Class NumberNUMC10Required
KSMLPOSNRItem NumberNUMC3Required
KSMLIMERKInternal CharacteristicNUMC10Required
KSMLKLARTClass TypeCHAR3Required
TableFieldField DescriptionData TypeLengthRequirementTemp
KSSKOBJEKKey of Object to be ClassifiedCHAR90Required
KSSKMAFIDIndicator: Object/ClassCHAR1RequiredDefault to "O"
KSSKKLARTClass TypeCHAR3Required
KSSKCLINTInternal Class NumberNUMC10Required
KSSKSTDCLIndicator: Standard ClassCHAR1System
KSSKSTATUClassification StatusCHAR1System
KSSKZAEHLSort PositionINT25System
TableFieldField DescriptionData TypeLengthRequirementTemp
AUSPOBJEKKey of Object to be ClassifiedCHAR90Required
AUSPATINNInternal CharacteristicNUMC10Required
AUSPATZHLCharacteristic Value CounterNUMC3RequiredDefault to 1
AUSPMAFIDIndicator: Object/ClassCHAR1RequiredDefault to "O"
AUSPKLARTClass TypeCHAR3Required
AUSPATWRTCharacteristic ValueCHAR70Required


Data Cleansing

IDCriticalityError Message/Report DescriptionRuleOutputSource System


Not Applicable




Conversion Process

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


Field Governance Rules

These governance rules apply to the individual fields within the data record.

Rule #

Field Label

Rule Description

Validation Method

Conditional Logic

Cleansing Rule (Also see Data Cleansing section above)



Not Applicable





Data Privacy and Sensitivity

Not Applicable

Extraction

The source for Classes to Characteristics is a Load-File/DCT (see below in the DCT section for more details).

The source for Materials to Classes is a Load-File/DCT (see below in the DCT section for more details) and is based on a mapping of Material Type to Class.

For Materials & Characteristics to Values, the source is a DCT****************.

The source for Materials & Characteristics to Values assignment specifically for Old Material Number and Description is PF2 & WP2

Where applicable above, the source for Materials is PF2 & WP2.  This will be extracted by Syniti and the Relevancy criteria, as specified in object "2019 - Materials Basic Data View", applied to identify the records that are applicable for the Target load.

Extraction Run Sheet

Req #Requirement DescriptionTeam Responsible

1

Extract data from source system based on relevancy rules.

Syniti

2

Extract data from the DCTs.

Syniti


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 Materials - Classification and Characteristic Assignment data with the fields requiring transformation as mentioned in the transformation rule.

DCT Rules for linking Materials to Classes:

Field NameField DescriptionRuleTool TipzCommentzDelete
MARA-MTARTMaterial TypeMandatory.  Use drop-down based on (S4H) T134.Key that groups materials, e.g. raw materials, finished products or trading goods.

KLAH-CLASSClass NameMandatory.Name used to uniquely identify a class within a class type.

KSSK-KLARTClass TypeRead-only.  From KLAH-KLART.



DCT Rules for linking Classes to Characteristics:

Field NameField DescriptionRuleTool TipzCommentzDelete
KLAH-CLASSClass NameMandatory.Name used to uniquely identify a class within a class type.

CABN-ATNAMCharacteristic NameMandatory.Unique technical name identifying the characteristic (e.g. LENGTH, COLOR).


DCT Rules for Materials & Characteristics to Values assignment:

Field NameField DescriptionRuleTool TipzCommentzDelete
AUSP-OBJEKMaterial NumberMandatory.  Based on MARA-MATNRThe Material Number will be used to identify the corresponding Target Material Number.

KLAH-CLASSClass NameMandatory.  Use drop-down based on KSSK.Name used to uniquely identify a class within a class type.

AUSP-KLARTClass TypeRead-only.  From KLAH-KLART.


CABN-ATNAMCharacteristic NameMandatory.  Use drop-down based on KLAH-CLASS via KSSK to KSML.Unique technical name identifying the characteristic (e.g. LENGTH, COLOR).

AUSP-ATWRTValue

Required.

----------------------------------------------------------------------
When a new DCT record is shown and once KLAH-CLASS and CABN-ATNAM are selected, use default value of CAWN-ATWRT WHERE CAWN-ATSTD = 'X', else show a Blank.
This is from KSML to CABN to CAWN.
If the above cannot be done easily then leave it out.
----------------------------------------------------------------------

Use drop-down based on CAWN-ATWRT (Value) and CAWNT-ATWTB (Value Description) WHERE CAWNT-SPRAS='E'.
This is from KSML to CABN to CAWN to CAWNT.

List of permissible predefined characteristic values (e.g. RED, BLUE, GREEN).

Extraction Dependencies

Item #Step DescriptionTeam Responsible

1

Data relevancy and deduplication of legacy Material data must be completed.

Syniti & S2P Data Team

2

As-Is to To-Be Material Type Mapping must be complete

S2P Data Team







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 Syniti ADMM 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 ADMM.
  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

Verify that Material data is extracted from both source systems.

Syniti / S2P Data Team

2

Verify that data has been loaded into the DCTs.

Syniti / S2P Data Team

3

Transformation jobs are ready for execution.

Syniti

4

Generate Load Files

Syniti


Transformation Rules

Transformation Rules for linking Materials to Classes:

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

PF2,WP2,DCT

MARAMATNRMaterial NumberS4HKSSKOBJEKKey of Object to be ClassifiedWHERE ECC.MARA-MTART = DCT.MARA-MTART





S4HKSSKMAFIDIndicator: Object/ClassDefault to "O"





S4HKSSKKLARTClass TypeDefault to "001"

DCTKLAHCLASSClass NameS4HKSSKCLINTInternal Class NumberCopy KLAH-CLINT





S4HKSSKSTDCLIndicator: Standard ClassDefault to "X"





S4HKSSKSTATUClassification StatusDefault to "1"





S4HKSSKZAEHLSort PositionDefault to 10.  If a material is assigned to a 2nd Class then default to 20. 


Transformation Rules for linking Classes to Characteristics:

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

DCT

KLAHCLASSClass NameS4HKSMLCLINTInternal Class NumberCopy KLAH-CLINT





S4HKSMLPOSNRItem NumberInteger counter starting at 1 and incrementing by 1 for each CLINT.  When CLINT changes it starts from 1 again.

DCTCABNATNAMCharacteristic NameS4HKSMLIMERKInternal CharacteristicCopy CABN-ATINN





S4HKSMLKLARTClass TypeDefault to "001"


Transformation Rules for Materials & Characteristics to Values assignment:

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

DCT




S4HAUSPOBJEKKey of Object to be Classified





S4HAUSPATINNInternal Characteristic





S4HAUSPATZHLCharacteristic Value CounterDefault to 1





S4HAUSPMAFIDIndicator: Object/ClassDefault to "O"





S4HAUSPKLARTClass Type





S4HAUSPATWRTCharacteristic Value


Transformation Rules for Materials & Characteristics to Values assignment for Old Material Number & Description:

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

PF2 & WP2




S4HAUSPOBJEKKey of Object to be Classified





S4HAUSPATINNInternal Characteristic





S4HAUSPATZHLCharacteristic Value CounterDefault to 1





S4HAUSPMAFIDIndicator: Object/ClassDefault to "O"





S4HAUSPKLARTClass Type





S4HAUSPATWRTCharacteristic Value


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

SyWay S2P Data Team

2

Value Mappings are according to the latest design - <List of Value Mappings>

SyWay S2P Data Team








Pre-Load Validation

Project Team

Completeness

TaskAction

Verify Record Count

SyWay S2P 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 S2P 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 Reports

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






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

Load Run Sheet

Item #Step DescriptionTeam Responsible

1

Go to <Load Tool>

SyWay S2P Data Team

2

Load 3 records for < > to validate if data is loaded successfully without errors

SyWay S2P Data Team

3

Load 3 records for < > to validate if data is loaded successfully without errors

SyWay S2P Data Team

4

Proceed with full load if steps 2 and 3 are validated

SyWay S2P Data Team

5

Validate few records loaded by accessing standard transactions from S/4HNA eg. MM03

SyWay S2P Data Team

6

Generate post load report if step 5 is validated

SyWay S2P Data Team


Load Phase and Dependencies

Configuration

Item #Configuration Item






Conversion Objects

Object #Preceding Object Conversion Approach

list 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

Verify Count

SyWay S2P 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.






Accuracy

TaskAction

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






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 Material 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.
  • Materials - Classification and Characteristic Assignment is in scope based on data design and any exception requested by business.


See also

Change log

Version Published Changed By Comment
CURRENT (v. 13) Feb 17, 2026 13:50 CLARKE-ext, Steve
v. 56 Feb 16, 2026 11:47 CLARKE-ext, Steve
v. 55 Feb 16, 2026 11:43 CLARKE-ext, Steve
v. 54 Feb 13, 2026 15:17 CLARKE-ext, Steve
v. 53 Feb 13, 2026 13:08 CLARKE-ext, Steve
v. 52 Feb 13, 2026 11:30 CLARKE-ext, Steve
v. 51 Feb 13, 2026 11:17 CLARKE-ext, Steve
v. 50 Feb 10, 2026 12:05 CLARKE-ext, Steve
v. 49 Feb 06, 2026 15:07 CLARKE-ext, Steve Changes for CR0320
v. 48 Dec 10, 2025 14:22 CLARKE-ext, Steve

Go to Page History

Workflow history

Title Last Updated By Updated Status  
There are no pages at the moment.

  • No labels