Status

Owner
StakeholdersThe business stakeholders involved in making, reviewing, and endorsing this decision. Type @ to mention people by name

Purpose

The purpose of this document is to define the conversion approach to create Vendors - Classification and Characteristic Assignment in S/4 HANA as part of the Vendor Master Data Migration in S/4 HANA.


Conversion Scope

The scope of this document covers the approach for converting active Vendors - Classification and Characteristic Assignment of vendors class type 0101 from Legacy Source Systems into S/4HANA following Master Data Design Standard.

Link to MDS:

The data from legacy system includes:

  1. Characteristics (CABN-ATNAM) assigned to Classes with the Class Type (KLAH-KLART) = 010
  2. Status (KLAH-STATU) = 1 (Released)
  3. Status (CABN-ATMST) = 1 (Released
  4. Agreed list of Characteristics list with the Characteristic values will be migrated
  5. Vendors’ relevant general data according to relevancy criteria. 
  6. Vendor classes (Reference - CNV-1139 -Vendors - Class Type 010) used by active vendors with activities based on the relevancy criteria of CNV-3007
  7. Vendor Characteristics of class type 010 (Reference - CNV-3025 -Vendors - Characteristics of Class Type 010) used by active vendors with activities based on the relevancy criteria of CNV-3007

The data from legacy system excludes:

  1. Characteristics for Deletion (CABN-LKENZ = "X")
  2. Vendors blocked or marked for deletion.
  3. Purchasing organization not in scope
  4. Inactive vendors with no transactions based on the relevancy criteria of CNV-3007


List of source systems and approximate number of records
SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

WP2 / PF2

Vendors Classification and Characteristic Assignment

AUSP: Characteristic values assigned to the objects (in this cases Business Partners) - Actual assigned values for specific objects for the vendors class type 010


60,000S4 Hana60,000
DCT

Vendors Classification and Characteristic Assignment will be build based on the below

Vendors are in the scope based on relevancy criteria of CNV-3007

 Characteristics of a class type 010 can also be collected via DCT. An initial extract of the relevant classes will be provided in google sheet format to assist business in decision making on including any relevant classes from PF2 and WP2 as Vendor Class

Any additional characteristics of class type 010 also need to be created to support the new design may be added in the DCT.

A review and standardization will be done across all the characteristics of class type 010 in the DCT. 

Please see an indication of what will be baselined from source systems below and what will be constructed 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.

TBCS4 HanaTBC

Additional Information

Multi-language Requirement

Multi language is supported for Vendor Classification and Characteristics assignment. Login via a different language will have its description displayed in the logon language if the language key is maintained in the vendor classifications data.

Document Management

N/A

Legal Requirement

N/A

Special Requirements

N/A


Target Design

The technical design of the target for this conversion approach.

MDS Rules and Google Drive path for the MDS - DD-FUN-050 Master Data Standard_3XXX_Consolidated-Business Partners.xlsx - Google Sheets


TableFieldData ElementField DescriptionData TypeLengthRequirement
AUSPOBJEKOBJEKObject to be classifiedCHAR90R
AUSPATINNATINNInternal char no.NUMC10R
AUSPATZHLATZHLInt counterNUMC3S
AUSPMAFIDMAFIDIndicator: Object/ClassCHAR1R
AUSPKLARTKLARTClass TypeCHAR3R
AUSPADZHLADZHLInt. counterNUMC4S
AUSPATWRTATWRTCharacteristic ValueCHAR70C
AUSPATFLVATFLVValue fromNUMC10S
AUSPATAWEATAWEInternal UoMCHAR3C
AUSPATFLBATFLBValue toNUMC10S
AUSPATAW1ATAW1Internal UoMCHAR3C
AUSPATCODATCODCodeCHAR1C
AUSPATTLVATTLVTolerance fromNUMC10C
AUSPATTLBATTLBTolerance toNUMC10C
AUSPATPRZATPRZPercentageCHAR1C
AUSPATINCATINCIncrementNUMC10C
AUSPATAUTATAUTAuthorization GroupCHAR1C
AUSPAENNRAENNRChange NumberCHAR12C
AUSPDATUVDATUVValid FromDATS8C
AUSPLKENZLKENZDeletion indicatorCHAR1C
AUSPATIMBATIMBCharacteristic numberNUMC10C
AUSPATZISATZISInstance counterNUMC3C
AUSPATSRTATSRTSort field for characteristic values.NUMC4C
AUSPATVGLARTATVGLARTComparison type for characteristic valuesCHAR1C
AUSPDATUBDATUBValid toDATS8C
AUSPDEC_VALUE_FROMDEC_VALUE_FROMLower boundary for numeric fieldsDEC16C
AUSPDEC_VALUE_TODEC_VALUE_TOUpper boundary for numeric fieldsDEC16C
AUSPCURR_VALUE_FROMCURR_VALUE_FROMLower boundary for currency fieldsCURR16C
AUSPCURR_VALUE_TOCURR_VALUE_TOUpper boundary for currency fieldsCURR16C
AUSPCURRENCYCURRENCYCurrencyCUKY/CHAR5C
AUSPDATE_FROMDATE_FROMLowrBndry DateDATS8C
AUSPDATE_TODATE_TOUprBndry DateDATS8C
AUSPTIME_FROMTIME_FROMLowrBndry TimeTIME6C
AUSPTIME_TOTIME_TOUprBndry TimeTIME6C
AUSPPARTNER_GUIDPARTNER_GUIDBusiness Partner GUIDRAW16S


TableFieldData ElementField Label
Field Detail DescriptionsLengthRequirement
AUSPOBJEKOBJEKObject to be classifiedRequired - Supplier. Key of the object to be classified. Primary key - mandatory. BP already created in the system. Upfront automated.

Type: CHAR
Length: 90
CHAR90R
AUSPATINNATINNInternal char no.Required - Internal Characteristic Number. Primary key - mandatory. Naming convention to be followed. Upfront automated.

Type: NUMC
Length: 10
NUMC10R
AUSPATZHLATZHLInt counterSystem Generated - Internal numeric counter for a characteristic value. Primary key - mandatory. Derived by the system. Upfront automated.

Type: NUMC
Length: 3
NUMC3S
AUSPMAFIDMAFIDIndicator: Object/ClassRequired - Indicator: Object/Class. Primary key - mandatory. Flag. Upfront automated.

Type: CHAR
Length: 1
CHAR1R
AUSPKLARTKLARTClass TypeRequired - Uniquely identifies the class type. Upfront automated.
Class types are created in customizing for Classification. Value 010: Vendor. Primary key - mandatory.

Type: CHAR
Length: 3
CHAR3R
AUSPADZHLADZHLInt. counterSystem Generated -Internal Counter (e.g., sequence number for values). Derived by the system, technically is filled automatically. Optional for the user. Upfront automated.

Type: NUMC
Length: 4
NUMC4S
AUSPATWRTATWRTCharacteristic ValueConditional - Value of a characteristic. Follow the naming convention. Ongoing Manual
If the characteristic has character format (CHAR), this field contains a single character string.
Values in time format (TIME) must have the format HH:MM:SS. The separators are set automatically.
Example: 112855 --> 11:28:55
The values in date format (DATE) must have the format DD.MM.YYYY. The separators are set automatically.
Example: 110100 --> 11.01.2000
Note

If you valuate validity parameters, you cannot specify intervals. You can only specify individual values.

The following description does not apply to the valuation of validity parameters:
If the characteristic format is numeric (NUM), time (TIME), or date (DATE), you can enter a number or (if allowed) an interval.
Intervals are written in the following format:

Value1 - Value2 (from Value1 to Value2)
>Value1 (greater than Value1)
>=Value1 (greater than or equal to Value1)
<Value2 (less than Value2)
<=Value2 (less than or equal to Value2)
>Value1 - <Value2 (greater than Value1 and less than Value2)
Value1 - <Value2 (greater than or equal to Value1 and less than
Value2)
>Value1 - Value2 (greater than Value1 and less than or equal to
Value2)
If the characteristic has more than one value, you can enter multiple values separated by semicolons.

If you have maintained a unit of measure for numeric values in the formatting data of the characteristic,
 the unit is displayed automatically when you confirm.

Note
If you want to define intervals as allowed values of a characteristic, you must define the characteristic as "multiple-value" when you maintain the characteristic in the Classification System. This also allows you to enter more than one interval.

However, if you assign more than one interval to a characteristic of a class during configuration (for example, 1-2 and 5-6 for characteristic LENGTH), the system only reads one of the intervals when generating an inspection lot in QM. To avoid this problem, do NOT assign more than one interval to a characteristic.
CHAR70C
AUSPATFLVATFLVValue fromSystem Generated -Lower boundary for numeric values. Derived by the system, technically is filled automatically. Optional for the user. Date, upfront automated.

Type: NUMC
Length: 10
NUMC10S
AUSPATAWEATAWEInternal UoMConditional - Units of Measure associated with the characteristic. Both link to the unit table. It can be left blank depending on whether that data is relevant for a given record. System checks against the UoM values in the system, customizing, upfront automated.
Must be a valid UoM from T006.

Type: CHAR
Length: 3
CHAR3C
AUSPATFLBATFLBValue toSystem Generated -Upper boundary for numeric values. Derived by the system, technically is filled automatically. Optional for the user. Date, upfront automated.

Type: NUMC
Length: 10
NUMC10S
AUSPATAW1ATAW1Internal UoMConditional - Units of Measure associated with the characteristic. Both link to the unit table. It can be left blank depending on whether that data is relevant for a given record.
Must be a valid UoM from T006.

Type: CHAR
Length: 3
CHAR3C
AUSPATCODATCODCodeConditional - Indicates value dependency (e.g., used in variant configuration). Against the codes in the system. Upfront automated.

Type: CHAR
Length: 1
CHAR1C
AUSPATTLVATTLVTolerance fromConditional - Lower limit tolerance value. It can be left blank depending on whether that data is relevant for a given record. Numeric. Upfront automated.

Type: NUMC
Length: 10
NUMC10C
AUSPATTLBATTLBTolerance toConditional - Upper limit tolerance value. It can be left blank depending on whether that data is relevant for a given record. Numeric. Upfront automated.

Type: NUMC
Length: 10
NUMC10C
AUSPATPRZATPRZPercentageConditional - Indicates if tolerance should be shown as a percentage. It can be left blank depending on whether that data is relevant for a given record. Numeric. Upfront automated.

Type: CHAR
Length: 1
CHAR1C
AUSPATINCATINCIncrementConditional - Step value or interval for increments. It can be left blank depending on whether that data is relevant for a given record. Numeric. Upfront automated.

Type: NUMC
Length: 10
NUMC10C
AUSPATAUTATAUTAuthorization GroupConditional - This key defines whether a user is allowed to maintain this characteristic. Ongoing Manual
This authorization must be defined in the user master record.
The authorization object is C_CABN_GRP.

Type: CHAR
Length: 1
CHAR1C
AUSPAENNRAENNRChange NumberConditional - Change Number (linked to change documents/transport) Only required if the charc. is linked to a doc. System checks against the doc linked to in S4HANA. Upfront automated.

Type: CHAR
Length: 12
CHAR12C
AUSPDATUVDATUVValid FromConditional - Specifies the start date for the validity period of an object (such as material, BOM, or routing). Date, upfront automated.

Type: DATS
Length: 8
DATS8C
AUSPLKENZLKENZDeletion indicatorConditional - Deletion Indicator (logical deletion flag). It can be left blank depending on whether that data is relevant for a given record. Flag. Upfront automated.

Type: CHAR
Length: 1
CHAR1C
AUSPATIMBATIMBCharacteristic numberConditional - Characteristic number of a user-defined data type. This often refers to characteristics defined outside standard domain. Upfront automated.

Type: NUMC
Length: 10
NUMC10C
AUSPATZISATZISInstance counterConditional - Used to differentiate multiple instances of characteristic values within the same object. Upfront automated.

Type: NUMC
Length: 3
NUMC3C
AUSPATSRTATSRTSort field for characteristic values.Conditional - Sort field for characteristic values. Determines ordering when multiple values are processed or displayed. It can be left blank depending on whether that data is relevant for a given record. On going manual.

Type: NUMC
Length: 4
NUMC4C
AUSPATVGLARTATVGLARTComparison type for characteristic valuesConditional - Values range from blank to '7', indicating inclusion/exclusion logic like subset, superset, identical, or exclusive conditions. It can be left blank depending on whether that data is relevant for a given record. System checks against the options in the system. Upfront automated.

Type: CHAR
Length: 1
CHAR1C
AUSPDATUBDATUBValid toConditional - End date of the characteristic’s validity period. Used to control when a characteristic becomes inactive in classification. It can be left blank depending on whether that data is relevant for a given record. Date, upfront automated

Type: DATS
Length: 8
DATS8C
AUSPDEC_VALUE_FROMDEC_VALUE_FROMLower boundary for numeric fieldsConditional - Used when characteristic value represents a numeric range. It can be left blank depending on whether that data is relevant for a given record. Numeric, upfront automated.

Type: DEC
Length: 16
DEC16C
AUSPDEC_VALUE_TODEC_VALUE_TOUpper boundary for numeric fieldsConditional - Together with DEC_VALUE_FROM, defines a numeric interval. It can be left blank depending on whether that data is relevant for a given record. Numeric, upfront automated.

Type: DEC
Length: 16
DEC16C
AUSPCURR_VALUE_FROMCURR_VALUE_FROMLower boundary for currency fieldsConditional - Used when characteristic value represents a currency range. It can be left blank depending on whether that data is relevant for a given record. Numeric, upfront automated.

Type: CURR
Length: 16
CURR16C
AUSPCURR_VALUE_TOCURR_VALUE_TOUpper boundary for currency fieldsConditional - Defines the top end of a monetary range. It can be left blank depending on whether that data is relevant for a given record. Numeric, upfront automated.

Type: CURR
Length: 16
CURR16C
AUSPCURRENCYCURRENCYCurrencyConditional - Currency key. System checked against the values already customized in the system. Upfront automated.

Type: CUKY/CHAR
Length: 5
CUKY/CHAR5C
AUSPDATE_FROMDATE_FROMLowrBndry DateConditional - Start of date range. It can be left blank depending on whether that data is relevant for a given record. Date, upfront automated.

Type: DATS
Length: 8
DATS8C
AUSPDATE_TODATE_TOUprBndry DateConditional - End of date range. It can be left blank depending on whether that data is relevant for a given record. Date, upfront automated.

Type: DATS
Length: 8
DATS8C
AUSPTIME_FROMTIME_FROMLowrBndry TimeConditional - Start time in time interval. It can be left blank depending on whether that data is relevant for a given record. Timing, upfront automated.

Type: TIME
Length: 6
TIME6C
AUSPTIME_TOTIME_TOUprBndry TimeConditional - End time in time interval. It can be left blank depending on whether that data is relevant for a given record. Timing, upfront automated.

Type: TIME
Length: 6
TIME6C
AUSPPARTNER_GUIDPARTNER_GUIDBusiness Partner GUIDSystem Generated -Used when the classified object is a Business Partner, providing a unique identifier. Derived by the system technically, optional for the user. Upfront automated

Type: RAW
Length: 16
RAW16S

Data Cleansing

No data cleansing is required for the Vendors - Classification and Characteristic Assignment in the legacy system. If any cleansing is deemed necessary, it will be performed outside of the system.

As a result, the cleansed Vendors - Classification and Characteristic Assignment data will be populated directly in the Data Collection Template (DCT).


Conversion Process

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

  • For sites not on SAP-PF2 or WP2 systems
  • For new Vendors - Classification and Characteristic Assignment data that need to be created to support the to-be design

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


Data Privacy and Sensitivity

N/A



Extraction

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

  1. Extract data from a source into Syniti
  2. The data does not exist (or cannot be converted from its current state) which should manually provided by the business with the help of data team directly in Syniti The
  3. This is to be conducted using DCT (Data Collection Template) in Syniti.

Extraction Run Sheet

Req #Requirement DescriptionTeam Responsible

1

Extract data from source system based on relevancy criteria

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

If applicable, this section will give the details on any selection screen parameters, including the parameter type, that are required to be entered to ensure consistent data extracts.
Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set
N/A




Data Collection Template (DCT)


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

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

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


CNV 3028 -Vendors - Classification and Characteristic Assignment DCT Rules:

Table - Field NameField DescriptionRuleData TypeLength Requirement
AUSP-OBJEKObject to be classifiedSupplier. Key of the object to be classified. Primary key - mandatory. BP already created in the system. Upfront automated.CHAR90R
AUSP-ATINNInternal char no.Internal Characteristic Number. Primary key - mandatory. Naming convention to be followed. Upfront automated.NUMC10R
AUSP-ATZHLInt counterInternal numeric counter for a characteristic value. Primary key - mandatory. Derived by the system. Upfront automated.NUMC3S
AUSP-MAFIDIndicator: Object/ClassIndicator: Object/Class. Primary key - mandatory. Flag. Upfront automated.CHAR1R
AUSP-KLARTClass TypeUniquely identifies the class type. Upfront automated.
Class types are created in customizing for Classification. Value 010: Vendor. Primary key - mandatory.
CHAR3R
AUSP-ADZHLInt. counterInternal Counter (e.g., sequence number for values). Derived by the system, technically is filled automatically. Optional for the user. Upfront automated.NUMC4S
AUSP-ATWRTCharacteristic ValueValue of a characteristic. Follow the naming convention. Ongoing Manual
If the characteristic has character format (CHAR), this field contains a single character string.
Values in time format (TIME) must have the format HH:MM:SS. The separators are set automatically.
Example: 112855 --> 11:28:55
The values in date format (DATE) must have the format DD.MM.YYYY. The separators are set automatically.
Example: 110100 --> 11.01.2000
Note

If you valuate validity parameters, you cannot specify intervals. You can only specify individual values.

The following description does not apply to the valuation of validity parameters:
If the characteristic format is numeric (NUM), time (TIME), or date (DATE), you can enter a number or (if allowed) an interval.
Intervals are written in the following format:

Value1 - Value2 (from Value1 to Value2)
>Value1 (greater than Value1)
>=Value1 (greater than or equal to Value1)
<Value2 (less than Value2)
<=Value2 (less than or equal to Value2)
>Value1 - <Value2 (greater than Value1 and less than Value2)
Value1 - <Value2 (greater than or equal to Value1 and less than
Value2)
>Value1 - Value2 (greater than Value1 and less than or equal to
Value2)
If the characteristic has more than one value, you can enter multiple values separated by semicolons.

If you have maintained a unit of measure for numeric values in the formatting data of the characteristic, the unit is displayed automatically when you confirm.

Note
If you want to define intervals as allowed values of a characteristic, you must define the characteristic as "multiple-value" when you maintain the characteristic in the Classification System. This also allows you to enter more than one interval.

However, if you assign more than one interval to a characteristic of a class during configuration (for example, 1-2 and 5-6 for characteristic LENGTH), the system only reads one of the intervals when generating an inspection lot in QM. To avoid this problem, do NOT assign more than one interval to a characteristic.
CHAR70C
AUSP-ATFLVValue fromLower boundary for numeric values. Derived by the system, technically is filled automatically. Optional for the user. Date, upfront automated.NUMC10S
AUSP-ATAWEInternal UoMUnits of Measure associated with the characteristic. Both link to the unit table. It can be left blank depending on whether that data is relevant for a given record. System checks against the UoM values in the system, customizing, upfront automated.
Must be a valid UoM from T006.
CHAR3C
AUSP-ATFLBValue toUpper boundary for numeric values. Derived by the system, technically is filled automatically. Optional for the user. Date, upfront automated.NUMC10S
AUSP-ATAW1Internal UoMUnits of Measure associated with the characteristic. Both link to the unit table. It can be left blank depending on whether that data is relevant for a given record.
Must be a valid UoM from T006.
CHAR3C
AUSP-ATCODCodeIndicates value dependency (e.g., used in variant configuration). Against the codes in the system. Upfront automated.CHAR1C
AUSP-ATTLVTolerance fromLower limit tolerance value. It can be left blank depending on whether that data is relevant for a given record. Numeric. Upfront automated.NUMC10C
AUSP-ATTLBTolerance toUpper limit tolerance value. It can be left blank depending on whether that data is relevant for a given record. Numeric. Upfront automated.NUMC10C
AUSP-ATPRZPercentageIndicates if tolerance should be shown as a percentage. It can be left blank depending on whether that data is relevant for a given record. Numeric. Upfront automated.CHAR1C
AUSP-ATINCIncrementStep value or interval for increments. It can be left blank depending on whether that data is relevant for a given record. Numeric. Upfront automated.NUMC10C
AUSP-ATAUTAuthorization GroupThis key defines whether a user is allowed to maintain this characteristic. Ongoing Manual
This authorization must be defined in the user master record.
The authorization object is C_CABN_GRP.
CHAR1C
AUSP-AENNRChange NumberChange Number (linked to change documents/transport) Only required if the charc. is linked to a doc. System checks against the doc linked to in S4HANA. Upfront automated.CHAR12C
AUSP-DATUVValid FromSpecifies the start date for the validity period of an object (such as material, BOM, or routing). Date, upfront automated.DATS8C
AUSP-LKENZDeletion indicatorDeletion Indicator (logical deletion flag). It can be left blank depending on whether that data is relevant for a given record. Flag. Upfront automated.CHAR1C
AUSP-ATIMBCharacteristic numberCharacteristic number of a user-defined data type. This often refers to characteristics defined outside standard domain. Upfront automated.NUMC10C
AUSP-ATZISInstance counterUsed to differentiate multiple instances of characteristic values within the same object. Upfront automated.NUMC3C
AUSP-ATSRTSort field for characteristic values.Sort field for characteristic values. Determines ordering when multiple values are processed or displayed. It can be left blank depending on whether that data is relevant for a given record. On going manual.NUMC4C
AUSP-ATVGLARTComparison type for characteristic valuesValues range from blank to '7', indicating inclusion/exclusion logic like subset, superset, identical, or exclusive conditions. It can be left blank depending on whether that data is relevant for a given record. System checks against the options in the system. Upfront automated.CHAR1C
AUSP-DATUBValid toEnd date of the characteristic’s validity period. Used to control when a characteristic becomes inactive in classification. It can be left blank depending on whether that data is relevant for a given record. Date, upfront automatedDATS8C
AUSP-DEC_VALUE_FROMLower boundary for numeric fieldsUsed when characteristic value represents a numeric range. It can be left blank depending on whether that data is relevant for a given record. Numeric, upfront automated.DEC16C
AUSP-DEC_VALUE_TOUpper boundary for numeric fieldsTogether with DEC_VALUE_FROM, defines a numeric interval. It can be left blank depending on whether that data is relevant for a given record. Numeric, upfront automated.DEC16C
AUSP-CURR_VALUE_FROMLower boundary for currency fieldsUsed when characteristic value represents a currency range. It can be left blank depending on whether that data is relevant for a given record. Numeric, upfront automated.CURR16C
AUSP-CURR_VALUE_TOUpper boundary for currency fieldsDefines the top end of a monetary range. It can be left blank depending on whether that data is relevant for a given record. Numeric, upfront automated.CURR16C
AUSP-CURRENCYCurrencyCurrency key. System checked against the values already customized in the system. Upfront automated.CUKY/CHAR5C
AUSP-DATE_FROMLowrBndry DateStart of date range. It can be left blank depending on whether that data is relevant for a given record. Date, upfront automated.DATS8C
AUSP-DATE_TOUprBndry DateEnd of date range. It can be left blank depending on whether that data is relevant for a given record. Date, upfront automated.DATS8C
AUSP-TIME_FROMLowrBndry TimeStart time in time interval. It can be left blank depending on whether that data is relevant for a given record. Timing, upfront automated.TIME6C
AUSP-TIME_TOUprBndry TimeEnd time in time interval. It can be left blank depending on whether that data is relevant for a given record. Timing, upfront automated.TIME6C
AUSP-PARTNER_GUIDBusiness Partner GUIDUsed when the classified object is a Business Partner, providing a unique identifier. Derived by the system technically, optional for the user. Upfront automatedRAW16S

Extraction Dependencies

List the steps that need to occur before extraction can commence

N/A


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 to make the data Target ready.

Prepare target-ready data in the structure and format that is required for loading via prescribed Load Tool. This step also produces the load data ready for business to perform Pre-load Data Validation

Transformation Run Sheet

Item #Step DescriptionTeam Responsible

1

Obtain DCT Sign-off from Business

SyWay S2P Data Team

2

Select the wave – S4/HANA – S2P(Source to Pay)

Syniti

3

Go to Process Area Launch and Process the Object – Vendor Classifications

Syniti

4

Review and Validate Error and Preload Reports

Syniti

5

Execute the transformation to prepare the target tables

Syniti

6

Review and Validate Error and Preload Reports

Business/Data owner

7

Generate Load Files

Syniti


Transformation Rules

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









































Transformation Mapping

Use the exact name and reference this section in the “Transformation rules” above
Mapping Table NameMapping Table Description








Transformation Dependencies

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













Pre-Load Validation

Project Team

The following pre-load validations will be performed by the Project Team.

Completeness

TaskAction
titlespecific details of what and how the task needs to be performed e.g. which reports are being used etc.





Accuracy

TaskAction
titlespecific details of what and how the task needs to be performed e.g. which reports are being used etc.





Business

The following pre-load validations will be performed by the business.

Completeness

TaskAction
titlespecific details of what and how the task needs to be performed e.g. which reports are being used etc.





Accuracy

TaskAction
titlespecific details of what and how the task needs to be performed e.g. which reports are being used etc.





Load

The load process includes:

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

Load Run Sheet

Item #Step DescriptionTeam Responsible













Load Phase and Dependencies

Identify the phase as to “when” the load for this object will occur. <Pre-Cutover, Cutover, Post Cutover> and list the steps that need to occur before the load can commence

Configuration

List the Configurations required before loading can commence

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

The table below depicts some possible system errors for this data object during data load. All data load error is to be logged as defect and managed within the Defect Management

Error TypeError DescriptionAction Taken










Post-Load Validation

Project Team

The following post-load validations will be performed by the Project Team.

Completeness

TaskAction
titlespecific details of what and how the task needs to be performed e.g. which reports are being used etc.





Accuracy

TaskAction
titlespecific details of what and how the task needs to be performed e.g. which reports are being used etc.





Business

The following post-load validations will be performed by the business.

Completeness

TaskAction
titlespecific details of what and how the task needs to be performed e.g. which reports are being used etc.





Accuracy

TaskAction
titlespecific details of what and how the task needs to be performed e.g. which reports are being used etc.





Key Assumptions

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

Any additional key assumptions.


See also

Insert links and references to other documents which are relevant when trying to understand this decision and its implications. Other decisions are often impacted, so it's good to list them here with links. Attachments are also possible but dangerous as they are static documents and not updated by their authors.

Change log

Workflow history