Status	Approved
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 and with informal words. 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:

Characteristics assigned to Classes with below Class Type
- 001-Material Class
- 002-Equipment Class
- 003-Functional Location
- 017-Document Management
- 018-Task List Class
- 037-Measuring Point Class
- 080-Maintenance Plans Class
Characteristics assigned to Active Legacy Measuring Points
Valid from [Current Date]
Status = 1 (Released)

The data from legacy system excludes:

Characteristics for Deletion (Deletion Indicator = X)

List of source systems and approximate number of records

Source

Scope

Source Approx No. of Records

Target System

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

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

Additional Information

Multi-language Requirement

EAM Characteristic description will be made available in English.
Multi language is supported for EAM Characteristics. Login via a different language will have its description displayed in the logon language if the language key is maintained in the 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

Table	Field	Data Element	Field Description	Data Type	Length	Requirement
CABN	ATNAM	ATNAM	Characteristic Name	CHAR	30	Mandatory
CABN	DATUV	DATUV	Valid-From Date	DATS	8	Mandatory
CABN	ATKLA	ATKLA	Characteristics Group	CHAR	10
CABN	ATMST	ATMST	Status of a characteristic	CHAR	1	Mandatory
CABN	ATFOR	ATFOR	Data Type	CHAR	4	Mandatory
CABN	ANZST	ANZST	Number of Characters	INT2	5	Mandatory (When Data Type = CURR, CHAR, NUM)
CABN	ANZDZ	ANZDZ	Number of Decimal Places	INT2	5	Mandatory (When Data Type = NUM)
CABN	ATKLE	ATKLE	Case Sensitive	CHAR	1
CABN	CURRENCY	CURRENCY	Currency Key	CUKY	1	Mandatory (When Data Type = CURR)
CABN	MSEHI	MSEHI	Unit of Measure	UNIT	6
CABN	ATSCH	ATSCH	Value with template	CHAR	30
CABN	ATDEX	ATDEX	Exponent Display Format	NUMC	1
CABN	ATEIN	ATEIN	Single Value	CHAR	1
CABN	ATAME	ATAME	Indicator: More Than One Value Allowed for Characteristic	CHAR	1
CABN	ATGLA	ATGLA	Indicator: restrictable characteristic	CHAR	1
CABN	ATERF	ATERF	Entry Required	CHAR	1
CABN	ATINT	ATINT	Interval values allowed	CHAR	1
CABN	ATVOR	ATVOR	Value with Plus or Minus Sign	CHAR	1
CABN	ATSON	ATSON	Indicator: Additional Values	CHAR	1

2. Characteristic Descriptions

Table	Field	Data Element	Field Description	Data Type	Length	Requirement
CABN	ATNAM	ATNAM	Characteristic Name	CHAR	30	Mandatory
CABNT	ATBEZ	ATBEZ	Characteristic description	CHAR	40	Mandatory
CABNT	SPRAS	SPRAS	Language Key (Characteristic Description)	LANG	1	Mandatory

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

Table	Field	Data Element	Field Description	Data Type	Length	Requirement
CABN	ATNAM	ATNAM	Characteristic Name	CHAR	30	Mandatory
KSML	KLART	KLASSENART	Class Type	CHAR	3	Mandatory

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

4. Characteristic Values

Table	Field	Data Element	Field Description	Data Type	Length	Requirement
CABN	ATNAM	ATNAM	Characteristic Name	CHAR	30	Mandatory
CAWN	ATWRT	ATWRT	Characteristic Value	CHAR	30	Mandatory
CAWN	ATSTD	ATSTD	Default value	CHAR	1

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

5. Characteristic Value Descriptions

Table	Field	Data Element	Field Description	Data Type	Length	Requirement
CABN	ATNAM	ATNAM	Characteristic Name	CHAR	30	Mandatory
CAWNT	SPRAS	SPRAS	Language Key (Characteristic Value Description)	LANG	1	Mandatory
CAWN	ATWRT	ATWRT	Characteristic Value	CHAR	30	Mandatory
CAWNT	ATWTB	ATWTB	Characteristic Value Description	CHAR	30	Mandatory

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

ID	Criticality	Error Message/Report Description	Rule	Output	Source System
		Not Applicable

Conversion Process

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

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

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 Description	Team Responsible
1	Extract data from source system based on relevancy rule	SyWay Data Team
2	Google Sheet report pre-populated with PF2 and WP2 information to be generated based on relevancy criteria.	SyWay Data Team

Selection Screen

Selection Ref Screen	Parameter Name	Selection Type	Requirement	Value 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.

The extracted report will be loaded into the required structure using the DCT.
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 Name	Field Description	Rule
ATNAM	Characteristic Name	Mandatory. The naming convention for characteristics will follow the structure: EAM_NNNNNN NNNNNN = will be running sequential number examples EAM_000001 - Pressure EAM_000002 - Allowed Construction Type
DATUV	Valid-From Date	Conditional. Provide a value indicating when this characteristic will be valid for use. Otherwise, leave blank.
ATKLA	Characteristics 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.
ATFOR	Data 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.
ANZST	Number 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
ANZDZ	Number 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.
ATKLE	Case Sensitive	Conditional. Indicator (check box). Allowed Values: " " = Not Checked "X" = Checked This field can to be filled, when Data Type chosen CHAR.
CURRENCY	Currency Key	Conditional. This needs to be filled, when data type chosen CURR.
MSEHI	Unit of Measure	Conditional. This can be filled, when data type chosen NUM
ATSCH	Value with template	Conditional. Allowed Values: Values as per configuration (TCPS) This can be filled, when data type chosen CHAR, NUM, CURR
ATDEX	Exponent Display Format	Conditional. Allowed values: 0: No exponent 1: Standard 2: Exponent entered 3: Scientific exponent
ATEIN	Single Value	Conditional. Indicator (check box). Allowed Values: " " = Not Checked "X" = Checked Select this option if only a single value is allowed for the characteristic. If ‘Single Value’ is selected, the indicator ‘More Than One Value Allowed for Characteristic’ cannot be chosen.
ATAME	Indicator: More Than One Value Allowed for Characteristic	Conditional. Indicator (check box). Allowed Values: " " = Not Checked "X" = Checked Select this option if multiple value is allowed for the characteristic. If ‘More Than One Value Allowed for Characteristic’ is selected, the indicator ‘Single Value’ cannot be chosen.
ATGLA	Indicator: 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").
ATERF	Entry Required	Conditional. Indicator (check box). Allowed Values: " " = Not Checked "X" = Checked This can be marked, when data type chosen CHAR, CURR, DATE, NUM, TIME
ATINT	Interval values allowed	Conditional. Indicator (check box). Allowed Values: " " = Not Checked "X" = Checked This can be marked, when data type chosen CURR, DATE, NUM, TIME
ATVOR	Value 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
ATSON	Indicator: 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_EN	Description (English)	Mandatory. Ensure to that this Class Description is in English.
ATBEZ_FR	Description (French)	Mandatory. Ensure to that this Class Description is in French.
ATBEZ_IT	Description (Italian)	Mandatory. Ensure to that this Class Description is in Italian.
ATBEZ_ZH	Description (Mandarin)	Mandatory. Ensure to that this Class Description is in Mandarin.
ATBEZ_BR	Description (Brazilian)	Mandatory. Ensure to that this Class Description is in Brazilian.
ATBEZ_PT	Description (Portuguese)	Mandatory. Ensure to that this Class Description is in Portuguese.
ATBEZ_DE	Description (German)	Mandatory. Ensure to that this Class Description is in German.
ATBEZ_ES	Description (Spanish)	Mandatory. Ensure to that this Class Description is in Spanish.
KLART_001	Class Type (Material Class)	Conditional. Indicator (check box). Allowed Values: " " = Not Checked "X" = Checked Select if to be assigned with 001-Material Class Type
KLART_002	Class Type (Equipment Class)	Conditional. Indicator (check box). Allowed Values: " " = Not Checked "X" = Checked Select if to be assigned with 002-Equipment Class Type
KLART_003	Class Type (Functional Location)	Conditional. Indicator (check box). Allowed Values: " " = Not Checked "X" = Checked Select if to be assigned with 003-Functional Location Class Type
KLART_017	Class Type (Document Management)	Conditional. Indicator (check box). Allowed Values: " " = Not Checked "X" = Checked Select if to be assigned with 017-Document Management Class Type
KLART_018	Class 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_037	Class 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_080	Class 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 Name	Field Description	Rule
ATNAM	Characteristic Name	Mandatory. Should exist in Characteristics DCT Rules
ATWRT	Characteristic Value	Conditional. If the characteristic has character format (CHAR), this field contains alphanumeric characters. If values in time format (TIME) must have the format HH:MM:SS. The separators are set automatically. Example: 112855 --> 11:28:55 If the values in date format (DATE) must have the format DD.MM.YYYY. The separators are set automatically. Example: 110100 --> 11.01.2000 If the values in NUM format, the field should contain only numerical characters. If the values in CURR format, this field should contain only numerical characters.
ATSTD	Default 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_EN	Description (English)	Mandatory. Ensure to that this Class Description is in English.
ATWTB_FR	Description (French)	Mandatory. Ensure to that this Class Description is in French.
ATWTB_IT	Description (Italian)	Mandatory. Ensure to that this Class Description is in Italian.
ATWTB_ZH	Description (Mandarin)	Mandatory. Ensure to that this Class Description is in Mandarin.
ATWTB_BR	Description (Brazilian)	Mandatory. Ensure to that this Class Description is in Brazilian.
ATWTB_PT	Description (Portuguese)	Mandatory. Ensure to that this Class Description is in Portuguese.
ATWTB_DE	Description (German)	Mandatory. Ensure to that this Class Description is in German.
ATWTB_ES	Description (Spanish)	Mandatory. Ensure to that this Class Description is in Spanish.

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

Extraction Dependencies

Item #	Step Description	Team 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:

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
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 Description	Team 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 system	Source Table	Source Field	Source Description	Target System	Target Table	Target Field	Target Description	Transformation Logic
1	DCT	CABN	ATNAM	Characteristic Name	S/4 Hana	CABN	ATNAM	Characteristic Name	Direct Mapping A Global Value Mapping (Characteristic A2D) will be created to reference old PM Characteristics.
2	DCT	CABN	DATUV	Valid-From Date	S/4 Hana	CABN	DATUV	Valid-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 = "Valid-From Date".
3	DCT	CABN	ATKLA	Characteristics Group	S/4 Hana	CABN	ATKLA	Characteristics Group	Direct Mapping
4	DCT	CABN	ATMST	Status of a characteristic	S/4 Hana	CABN	ATMST	Status of a characteristic	Default to ''1''
5	DCT	CABN	ATFOR	Data Type	S/4 Hana	CABN	ATFOR	Data Type	Direct Mapping
6	DCT	CABN	ANZST	Number of Characters	S/4 Hana	CABN	ANZST	Number of Characters	Direct Mapping
7	DCT	CABN	ANZDZ	Number of Decimal Places	S/4 Hana	CABN	ANZDZ	Number of Decimal Places	Direct Mapping
8	DCT	CABN	ATKLE	Case Sensitive	S/4 Hana	CABN	ATKLE	Case Sensitive	Direct Mapping
9	DCT	CABN	CURRENCY	Currency Key	S/4 Hana	CABN	CURRENCY	Currency Key	Direct Mapping
10	DCT	CABN	MSEHI	Unit of Measure	S/4 Hana	CABN	MSEHI	Unit of Measure	Direct Mapping
11	DCT	CABN	ATSCH	Value with template	S/4 Hana	CABN	ATSCH	Value with template	Direct Mapping
12	DCT	CABN	ATDEX	Exponent Display Format	S/4 Hana	CABN	ATDEX	Exponent Display Format	Direct Mapping
13	DCT	CABN	ATEIN	Single Value	S/4 Hana	CABN	ATEIN	Single Value	Direct Mapping
14	DCT	CABN	ATAME	Indicator: More Than One Value Allowed for Characteristic	S/4 Hana	CABN	ATAME	Indicator: More Than One Value Allowed for Characteristic	Direct Mapping
15	DCT	CABN	ATGLA	Indicator: restrictable characteristic	S/4 Hana	CABN	ATGLA	Indicator: restrictable characteristic	Direct Mapping
16	DCT	CABN	ATERF	Entry Required	S/4 Hana	CABN	ATERF	Entry Required	Direct Mapping
17	DCT	CABN	ATINT	Interval values allowed	S/4 Hana	CABN	ATINT	Interval values allowed	Direct Mapping
18	DCT	CABN	ATVOR	Value with Plus or Minus Sign	S/4 Hana	CABN	ATVOR	Value with Plus or Minus Sign	Direct Mapping
19	DCT	CABN	ATSON	Indicator: Additional Values	S/4 Hana	CABN	ATSON	Indicator: Additional Values	Direct Mapping

2. Characteristic Descriptions

Rule #

Source system

Source Table

Source Field

Source Description

Target System

Target Table

Target Field

Target Description

Transformation Logic

1

DCT

CABN

ATNAM

Characteristic Name

S/4 Hana

CABN

ATNAM

Characteristic Name

Direct Mapping

DCT

CABNT

ATBEZ_EN

Characteristic Description (English)

S/4 Hana

CABNT

ATBEZ

Characteristic description

Direct Mapping

Value Mapping: OTH_Informal Words and OTH_Informal Characters
Review the value mappings for the presence of informal words or invalid characters.
If any are identified, replace them with the appropriate standardized values as specified in the mappings.

3

DCT

CABNT

SPRAS

Language Key (Characteristic Description)

S/4 Hana

CABNT

SPRAS

Language Key (Characteristic Description)

Default to "E"

UNION

Rule #

Source system

Source Table

Source Field

Source Description

Target System

Target Table

Target Field

Target Description

Transformation Logic

1

DCT

CABN

ATNAM

Characteristic Name

S/4 Hana

CABN

ATNAM

Characteristic Name

Direct Mapping

DCT

CABNT

ATBEZ_FR

Characteristic description (French)

S/4 Hana

CABNT

ATBEZ

Characteristic description

Direct Mapping

Value Mapping: OTH_Informal Words and OTH_Informal Characters
Review the value mappings for the presence of informal words or invalid characters.
If any are identified, replace them with the appropriate standardized values as specified in the mappings.

3

DCT

CABNT

SPRAS

Language Key (Characteristic Description)

S/4 Hana

CABNT

SPRAS

Language Key (Characteristic Description)

Default to "F"

UNION

Rule #

Source system

Source Table

Source Field

Source Description

Target System

Target Table

Target Field

Target Description

Transformation Logic

1

DCT

CABN

ATNAM

Characteristic Name

S/4 Hana

CABN

ATNAM

Characteristic Name

Direct Mapping

DCT

CABNT

ATBEZ_IT

Characteristic description (Italian)

S/4 Hana

CABNT

ATBEZ

Characteristic description

Direct Mapping

Value Mapping: OTH_Informal Words and OTH_Informal Characters
Review the value mappings for the presence of informal words or invalid characters.
If any are identified, replace them with the appropriate standardized values as specified in the mappings.

3

DCT

CABNT

SPRAS

Language Key (Characteristic Description)

S/4 Hana

CABNT

SPRAS

Language Key (Characteristic Description)

Default to "I"

UNION

Rule #

Source system

Source Table

Source Field

Source Description

Target System

Target Table

Target Field

Target Description

Transformation Logic

1

DCT

CABN

ATNAM

Characteristic Name

S/4 Hana

CABN

ATNAM

Characteristic Name

Direct Mapping

DCT

CABNT

ATBEZ_ZH

Characteristic description (Mandarin)

S/4 Hana

CABNT

ATBEZ

Characteristic description

Direct Mapping

Value Mapping: OTH_Informal Words and OTH_Informal Characters
Review the value mappings for the presence of informal words or invalid characters.
If any are identified, replace them with the appropriate standardized values as specified in the mappings.

3

DCT

CABNT

SPRAS

Language Key (Characteristic Description)

S/4 Hana

CABNT

SPRAS

Language Key (Characteristic Description)

Default to "1"

UNION

Rule #

Source system

Source Table

Source Field

Source Description

Target System

Target Table

Target Field

Target Description

Transformation Logic

1

DCT

CABN

ATNAM

Characteristic Name

S/4 Hana

CABN

ATNAM

Characteristic Name

Direct Mapping

DCT

CABNT

ATBEZ_BR

Characteristic description (Brazilian)

S/4 Hana

CABNT

ATBEZ

Characteristic description

Direct Mapping

Value Mapping: OTH_Informal Words and OTH_Informal Characters
Review the value mappings for the presence of informal words or invalid characters.
If any are identified, replace them with the appropriate standardized values as specified in the mappings.

3

DCT

CABNT

SPRAS

Language Key (Characteristic Description)

S/4 Hana

CABNT

SPRAS

Language Key (Characteristic Description)

Default to "BR"

UNION

Rule #

Source system

Source Table

Source Field

Source Description

Target System

Target Table

Target Field

Target Description

Transformation Logic

1

DCT

CABN

ATNAM

Characteristic Name

S/4 Hana

CABN

ATNAM

Characteristic Name

Direct Mapping

DCT

CABNT

ATBEZ_PT

Characteristic description (Portuguese)

S/4 Hana

CABNT

ATBEZ

Characteristic description

Direct Mapping

Value Mapping: OTH_Informal Words and OTH_Informal Characters
Review the value mappings for the presence of informal words or invalid characters.
If any are identified, replace them with the appropriate standardized values as specified in the mappings.

3

DCT

CABNT

SPRAS

Language Key (Characteristic Description)

S/4 Hana

CABNT

SPRAS

Language Key (Characteristic Description)

Default to "P"

UNION

Rule #

Source system

Source Table

Source Field

Source Description

Target System

Target Table

Target Field

Target Description

Transformation Logic

1

DCT

CABN

ATNAM

Characteristic Name

S/4 Hana

CABN

ATNAM

Characteristic Name

Direct Mapping

DCT

CABNT

ATBEZ_DE

Characteristic description (German)

S/4 Hana

CABNT

ATBEZ

Characteristic description

Direct Mapping

Value Mapping: OTH_Informal Words and OTH_Informal Characters
Review the value mappings for the presence of informal words or invalid characters.
If any are identified, replace them with the appropriate standardized values as specified in the mappings.

3

DCT

CABNT

SPRAS

Language Key (Characteristic Description)

S/4 Hana

CABNT

SPRAS

Language Key (Characteristic Description)

Default to "D"

UNION

Rule #

Source system

Source Table

Source Field

Source Description

Target System

Target Table

Target Field

Target Description

Transformation Logic

1

DCT

CABN

ATNAM

Characteristic Name

S/4 Hana

CABN

ATNAM

Characteristic Name

Direct Mapping

DCT

CABNT

ATBEZ_ES

Characteristic description (Spanish)

S/4 Hana

CABNT

ATBEZ

Characteristic description

Direct Mapping

Value Mapping: OTH_Informal Words and OTH_Informal Characters
Review the value mappings for the presence of informal words or invalid characters.
If any are identified, replace them with the appropriate standardized values as specified in the mappings.

3

DCT

CABNT

SPRAS

Language Key (Characteristic Description)

S/4 Hana

CABNT

SPRAS

Language Key (Characteristic Description)

Default to "S"

3. Characteristic Characteristic Restrictions to Class Types

Only get the records where KLART_001 = "X"

Rule #	Source system	Source Table	Source Field	Source Description	Target System	Target Table	Target Field	Target Description	Transformation Logic
1	DCT	CABN	ATNAM	Characteristic Name	S/4 Hana	CABN	ATNAM	Characteristic Name	Direct Mapping
2	DCT	KSML	KLART_001	Class Type (Material Class)	S/4 Hana	KSML	KLART	Class Type	Default to "001"

UNION

Only get the records where KLART_002 = "X"

Rule #	Source system	Source Table	Source Field	Source Description	Target System	Target Table	Target Field	Target Description	Transformation Logic
1	DCT	CABN	ATNAM	Characteristic Name	S/4 Hana	CABN	ATNAM	Characteristic Name	Direct Mapping
2	DCT	KSML	KLART_002	Class Type (Equipment Class)	S/4 Hana	KSML	KLART	Class Type	Default to "002"

UNION

Only get the records where KLART_003 = "X"

Rule #	Source system	Source Table	Source Field	Source Description	Target System	Target Table	Target Field	Target Description	Transformation Logic
1	DCT	CABN	ATNAM	Characteristic Name	S/4 Hana	CABN	ATNAM	Characteristic Name	Direct Mapping
2	DCT	KSML	KLART_003	Class Type (Functional Location)	S/4 Hana	KSML	KLART	Class Type	Default to "003"

UNION

Only get the records where KLART_017 = "X"

Rule #	Source system	Source Table	Source Field	Source Description	Target System	Target Table	Target Field	Target Description	Transformation Logic
1	DCT	CABN	ATNAM	Characteristic Name	S/4 Hana	CABN	ATNAM	Characteristic Name	Direct Mapping
2	DCT	KSML	KLART_017	Class Type (Document Management)	S/4 Hana	KSML	KLART	Class Type	Default to "017"

UNION

Only get the records where KLART_018 = "X"

Rule #	Source system	Source Table	Source Field	Source Description	Target System	Target Table	Target Field	Target Description	Transformation Logic
1	DCT	CABN	ATNAM	Characteristic Name	S/4 Hana	CABN	ATNAM	Characteristic Name	Direct Mapping
2	DCT	KSML	KLART_018	Class Type (Task List Class)	S/4 Hana	KSML	KLART	Class Type	Default to "018"

UNION

Only get the records where KLART_037 = "X"

Rule #	Source system	Source Table	Source Field	Source Description	Target System	Target Table	Target Field	Target Description	Transformation Logic
1	DCT	CABN	ATNAM	Characteristic Name	S/4 Hana	CABN	ATNAM	Characteristic Name	Direct Mapping
2	DCT	KSML	KLART_037	Class Type (Measuring Point Class)	S/4 Hana	KSML	KLART	Class Type	Default to "037"

UNION

Only get the records where KLART_080 = "X"

Rule #	Source system	Source Table	Source Field	Source Description	Target System	Target Table	Target Field	Target Description	Transformation Logic
1	DCT	CABN	ATNAM	Characteristic Name	S/4 Hana	CABN	ATNAM	Characteristic Name	Direct Mapping
2	DCT	KSML	KLART_080	Class Type (Maintenance Plans Class)	S/4 Hana	KSML	KLART	Class Type	Default to "080"

4. Characteristic Values

Rule #	Source system	Source Table	Source Field	Source Description	Target System	Target Table	Target Field	Target Description	Transformation Logic
1	DCT	CABN	ATNAM	Characteristic Name	S/4 Hana	CABN	ATNAM	Characteristic Name	Direct Mapping
2	DCT	CAWN	ATWRT	Characteristic Value	S/4 Hana	CAWN	ATWRT	Characteristic Value	Direct Mapping
3	DCT	CAWN	ATSTD	Default value	S/4 Hana	CAWN	ATSTD	Default value	Direct Mapping

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

5. Characteristic Value Descriptions

Rule #	Source system	Source Table	Source Field	Source Description	Target System	Target Table	Target Field	Target Description	Transformation Logic
1	DCT	CABN	ATNAM	Characteristic Name	S/4 Hana	CABN	ATNAM	Characteristic Name	Direct Mapping
2	DCT	CAWNT	SPRAS	Language Key (Characteristic Value Description)	S/4 Hana	CAWNT	SPRAS	Language Key (Characteristic Value Description)	Default to "E"
3	DCT	CAWN	ATWRT	Characteristic Value	S/4 Hana	CAWN	ATWRT	Characteristic Value	Direct Mapping
4	DCT	CAWNT	ATWTB_EN	Characteristic Value Description (English)	S/4 Hana	CAWNT	ATWTB	Characteristic Value Description	Direct Mapping Value Mapping: OTH_Informal Words and OTH_Informal Characters Review the value mappings for the presence of informal words or invalid characters. If any are identified, replace them with the appropriate standardized values as specified in the mappings.

UNION

Rule #	Source system	Source Table	Source Field	Source Description	Target System	Target Table	Target Field	Target Description	Transformation Logic
1	DCT	CABN	ATNAM	Characteristic Name	S/4 Hana	CABN	ATNAM	Characteristic Name	Direct Mapping
2	DCT	CAWNT	SPRAS	Language Key (Characteristic Value Description)	S/4 Hana	CAWNT	SPRAS	Language Key (Characteristic Value Description)	Default to "F"
3	DCT	CAWN	ATWRT	Characteristic Value	S/4 Hana	CAWN	ATWRT	Characteristic Value	Direct Mapping
4	DCT	CAWNT	ATWTB_FR	Characteristic Value Description (French)	S/4 Hana	CAWNT	ATWTB	Characteristic Value Description	Direct Mapping Value Mapping: OTH_Informal Words and OTH_Informal Characters Review the value mappings for the presence of informal words or invalid characters. If any are identified, replace them with the appropriate standardized values as specified in the mappings.

UNION

Rule #	Source system	Source Table	Source Field	Source Description	Target System	Target Table	Target Field	Target Description	Transformation Logic
1	DCT	CABN	ATNAM	Characteristic Name	S/4 Hana	CABN	ATNAM	Characteristic Name	Direct Mapping
2	DCT	CAWNT	SPRAS	Language Key (Characteristic Value Description)	S/4 Hana	CAWNT	SPRAS	Language Key (Characteristic Value Description)	Default to "I"
3	DCT	CAWN	ATWRT	Characteristic Value	S/4 Hana	CAWN	ATWRT	Characteristic Value	Direct Mapping
4	DCT	CAWNT	ATWTB_IT	Characteristic Value Description (Italian)	S/4 Hana	CAWNT	ATWTB	Characteristic Value Description	Direct Mapping Value Mapping: OTH_Informal Words and OTH_Informal Characters Review the value mappings for the presence of informal words or invalid characters. If any are identified, replace them with the appropriate standardized values as specified in the mappings.

UNION

Rule #	Source system	Source Table	Source Field	Source Description	Target System	Target Table	Target Field	Target Description	Transformation Logic
1	DCT	CABN	ATNAM	Characteristic Name	S/4 Hana	CABN	ATNAM	Characteristic Name	Direct Mapping
2	DCT	CAWNT	SPRAS	Language Key (Characteristic Value Description)	S/4 Hana	CAWNT	SPRAS	Language Key (Characteristic Value Description)	Default to "1"
3	DCT	CAWN	ATWRT	Characteristic Value	S/4 Hana	CAWN	ATWRT	Characteristic Value	Direct Mapping
4	DCT	CAWNT	ATWTB_ZH	Characteristic Value Description(Mandarin)	S/4 Hana	CAWNT	ATWTB	Characteristic Value Description	Direct Mapping Value Mapping: OTH_Informal Words and OTH_Informal Characters Review the value mappings for the presence of informal words or invalid characters. If any are identified, replace them with the appropriate standardized values as specified in the mappings.

UNION

Rule #	Source system	Source Table	Source Field	Source Description	Target System	Target Table	Target Field	Target Description	Transformation Logic
1	DCT	CABN	ATNAM	Characteristic Name	S/4 Hana	CABN	ATNAM	Characteristic Name	Direct Mapping
2	DCT	CAWNT	SPRAS	Language Key (Characteristic Value Description)	S/4 Hana	CAWNT	SPRAS	Language Key (Characteristic Value Description)	Default to "BR"
3	DCT	CAWN	ATWRT	Characteristic Value	S/4 Hana	CAWN	ATWRT	Characteristic Value	Direct Mapping
4	DCT	CAWNT	ATWTB_BR	Characteristic Value Description (Brazilian)	S/4 Hana	CAWNT	ATWTB	Characteristic Value Description	Direct Mapping Value Mapping: OTH_Informal Words and OTH_Informal Characters Review the value mappings for the presence of informal words or invalid characters. If any are identified, replace them with the appropriate standardized values as specified in the mappings.

UNION

Rule #	Source system	Source Table	Source Field	Source Description	Target System	Target Table	Target Field	Target Description	Transformation Logic
1	DCT	CABN	ATNAM	Characteristic Name	S/4 Hana	CABN	ATNAM	Characteristic Name	Direct Mapping
2	DCT	CAWNT	SPRAS	Language Key (Characteristic Value Description)	S/4 Hana	CAWNT	SPRAS	Language Key (Characteristic Value Description)	Default to "P"
3	DCT	CAWN	ATWRT	Characteristic Value	S/4 Hana	CAWN	ATWRT	Characteristic Value	Direct Mapping
4	DCT	CAWNT	ATWTB_PT	Characteristic Value Description (Portuguese)	S/4 Hana	CAWNT	ATWTB	Characteristic Value Description	Direct Mapping Value Mapping: OTH_Informal Words and OTH_Informal Characters Review the value mappings for the presence of informal words or invalid characters. If any are identified, replace them with the appropriate standardized values as specified in the mappings.

UNION

Rule #	Source system	Source Table	Source Field	Source Description	Target System	Target Table	Target Field	Target Description	Transformation Logic
1	DCT	CABN	ATNAM	Characteristic Name	S/4 Hana	CABN	ATNAM	Characteristic Name	Direct Mapping
2	DCT	CAWNT	SPRAS	Language Key (Characteristic Value Description)	S/4 Hana	CAWNT	SPRAS	Language Key (Characteristic Value Description)	Default to "D"
3	DCT	CAWN	ATWRT	Characteristic Value	S/4 Hana	CAWN	ATWRT	Characteristic Value	Direct Mapping
4	DCT	CAWNT	ATWTB_DE	Characteristic Value Description (German)	S/4 Hana	CAWNT	ATWTB	Characteristic Value Description	Direct Mapping Value Mapping: OTH_Informal Words and OTH_Informal Characters Review the value mappings for the presence of informal words or invalid characters. If any are identified, replace them with the appropriate standardized values as specified in the mappings.

UNION

Rule #	Source system	Source Table	Source Field	Source Description	Target System	Target Table	Target Field	Target Description	Transformation Logic
1	DCT	CABN	ATNAM	Characteristic Name	S/4 Hana	CABN	ATNAM	Characteristic Name	Direct Mapping
2	DCT	CAWNT	SPRAS	Language Key (Characteristic Value Description)	S/4 Hana	CAWNT	SPRAS	Language Key (Characteristic Value Description)	Default to "S"
3	DCT	CAWN	ATWRT	Characteristic Value	S/4 Hana	CAWN	ATWRT	Characteristic Value	Direct Mapping
4	DCT	CAWNT	ATWTB_ES	Characteristic Value Description (Spanish)	S/4 Hana	CAWNT	ATWTB	Characteristic Value Description	Direct Mapping Value Mapping: OTH_Informal Words and OTH_Informal Characters Review the value mappings for the presence of informal words or invalid characters. If any are identified, replace them with the appropriate standardized values as specified in the mappings.

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

Transformation Mapping

Mapping Table Name	Mapping Table Description
Characteristic A2D	Old to New Characteristic A2D
OTH_Informal Words	List of Informal Words and the words used to replace
OTH_Informal Characters	List of Informal Characters
OTH_Migration_Date Relevant Values A2D	Dates 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 Description	Team Responsible
1	Ensure DCT tables completeness	SyWay Data Team
2	Ensure all Transformation mappings are up to date.	SyWay Data Team

Pre-Load Validation

Project Team

Completeness

Task	Action
Verify Record Count	SyWay 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

Task

Action

Conversion Accuracy

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

Mandatory Fields
Field and Value Mapping Correctness
Null Checks
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

Task	Action
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

Task	Action
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:

Execute the automated data load into target system using load tool or product the load file if the load must be done manually
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 Description	Team 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
1	T002-Language Keys
2	T006-Units of Measurement
3	TCMG-Characteristic Group
4	TCMS-Characteristic Status
5	TCPS-Define Characters in Templates

Conversion Objects

Object #	Preceding Object Conversion Approach
Not Applicable

Error Handling

Error Type	Error Description	Action 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

Task	Action
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

Task	Action
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

Task	Action
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

Task	Action
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.

Change log

Version	Published	Changed By	Comment
CURRENT (v. 101)	Mar 17, 2026 07:56	ERGUIZA-ext, Pinky Love
v. 141	Dec 10, 2025 15:40	ERGUIZA-ext, Pinky Love
v. 140	Dec 10, 2025 15:22	ERGUIZA-ext, Pinky Love
v. 139	Nov 13, 2025 12:14	ERGUIZA-ext, Pinky Love
v. 138	Nov 13, 2025 12:10	ERGUIZA-ext, Pinky Love
v. 137	Nov 13, 2025 12:01	ERGUIZA-ext, Pinky Love
v. 136	Nov 13, 2025 11:50	ERGUIZA-ext, Pinky Love
v. 135	Nov 04, 2025 14:35	ERGUIZA-ext, Pinky Love	Consolidation of Char Values from 3 fields to 1 DCT Field
v. 134	Nov 04, 2025 14:30	ERGUIZA-ext, Pinky Love
v. 133	Nov 04, 2025 14:11	ERGUIZA-ext, Pinky Love

Go to Page History

Workflow history

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

Mar 25, 2026	Actor	Type	Activity	Version
Approved	MOUSSA-ext, Eva	State	changed state to Approved at 10:09 pm	v142
Revision under Review	MOUSSA-ext, Eva	State	gave Minor change approval at 10:09 pm PDM-1366
Revision under Review	MOUSSA-ext, Eva	State	changed state to Revision under Review at 10:08 pm	v142
Mar 18, 2026
Revision in Progress	WENNINGER-ext, Sascha	State	changed state to Revision in Progress at 5:39 pm	v142
Mar 17, 2026
Edited following Approval	ERGUIZA-ext, Pinky Love	Comment	commented 7:58 am PDM-1366: Updates on ATCOD & ATBEW required or Load Note I also renumbered the Rule # as 5 was after 3 previously (missing 4)
		Comment	commented 7:58 am PDM-1366: Updates on ATCOD & ATBEW required or Load Note I also renumbered the Rule # as 5 was after 3 previously (missing 4)
		Comment	commented 7:58 am PDM-1366: Updates on ATCOD & ATBEW required or Load Note I also renumbered the Rule # as 5 was after 3 previously (missing 4)
		Comment	commented 7:58 am PDM-1366: Updates on ATCOD & ATBEW required or Load
		Comment	commented 7:57 am PDM-1366: Updates on ATCOD & ATBEW required or Load
		Comment	commented 7:57 am PDM-1366: Updates on ATCOD & ATBEW required or Load
		Comment	commented 7:57 am PDM-1366: Updates on ATCOD & ATBEW required or Load
		Comment	commented 7:57 am PDM-1366: Updates on ATCOD & ATBEW required or Load
		Edit	updated the page at 7:56 am
		State	changed state to Edited following Approval at 6:56 am	v142
Dec 10, 2025
Approved	MOUSSA-ext, Eva	State	changed state to Approved at 4:35 pm	v141

Workflow history

Space shortcuts

Page tree

CNV-1015 Characteristic

Purpose

Conversion Scope

Additional Information

Multi-language Requirement

Document Management

Legal Requirement

Special Requirements

Target Design

Data Cleansing

Conversion Process

Extraction

Extraction Run Sheet

Selection Screen

Data Collection Template (DCT)

Transformation

Transformation Run Sheet

Transformation Mapping

Transformation Dependencies

Pre-Load Validation

Project Team

Completeness

Accuracy

Business

Completeness

Accuracy

Load

Load Run Sheet

Configuration

Conversion Objects

Error Handling

Post-Load Validation

Project Team

Completeness

Accuracy

Business

Completeness

Accuracy

Key Assumptions

See also

Change log

Workflow history