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

Compare with Current View Page History

« Previous Version 67 Next »

Status

  Update in progress

Owner
Stakeholders

Purpose

The purpose of this document is to define the conversion approach to create 1056 - Resources in S/4 HANA.

Resources are used to identify the production lines, equipment and all the machines related to the production execution process. Resources are the main data to be used to design the Master Recipes for all the Syensqo plants. 



Conversion Scope

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

Stand alone rules

The data from legacy system includes:

  1. Active Resources as of > three (3) years with history and/or included in active Recipes / Process Orders
  2. Resources W/O Deletion Flag
  3. Resources that will be migrated to the To-Be Plant Mapping (Take in consideration the To-Be definition of Plants

The data from legacy system excludes:

  1. Inactive Resources with more than three (3) years.
  2. Resources marked for deletion
  3. Resources belonging to Deleted plants (New plant Definition according with the To-Be Plant mapping)

Relevancy rule

  1. Material/Plant with history and include active process orders - Materials defined via Status at global and Plant level (MARC/MARA)
  2. Defined materials which are recognised as active and contain 3 years process order history, these are then checked against active BOMS to define Master Recipe at Plant level
  3. Master Recipes defined as per the Material Master containing 3 years Process order History, define the Resource by Plant

Material Plant Active with three years Process order History Red Arrow defines Active BOMS by Plant Red Arrow defines Active Master Recipe by Plant Red Arrow Defines the Resource by Plant.

Plant Merging

Plants will be defined accordingly as some plants will be merged into one plant. Plants will be defined as NEW plant codes and be transformed via a transformation table, which will be contained in Syniti.


List of source systems and approximate number of records
SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2, WP2

Resources will be extracted from PF2 and WP2  

PF2 - 6096 WP2 - 9077

S/4 HANAPF2 - 6096 WP2 - 9077

Additional Information

Multi-language Requirement

English , French, Chinese, Spanish

Document Management

Legal Requirement

N/A

Special Requirements

N/a

N/a




Target Design

The technical design of the target for this conversion approach.


TableFieldData ElementField DescriptionData TypeLengthRequirement

MDS Field Mapping in Scope


Field Value in MDS

1CRHDOBJTYCR_OBJTYObject typeCHAR2SIn Scope
2CRHDOBJIDCR_OBJIDObject IDNUMC8S
3CRHDARBPLARBPLWork CenterCHAR8RTBD
4CRHDWERKSWERKS_DPlantCHAR4RTBD
5CRHDVERWEAP_VERWEWork Center CategoryCHAR4R

0008 Processing Unit
6CRHDPLANVAP_PLANVKey for task list usageCHAR3R

0008 Master Recipe + Process Order
7CRHDSTANDAP_STANDWork center locationCHAR10C

MFG Execution Config Register
8CRHDVERANAP_VERANPerson Responsible for the Work CenterCHAR3C

Copy from Legacy
9CRHDVGWTSVORGSCHLStandard Value KeyCHAR4R

TBD
10CRHDVGM01AP_VGW_MESRule for standard value maintenanceCHAR1C
11CRHDVGM02AP_VGW_MESRule for standard value maintenanceCHAR1C
12CRHDVGM03AP_VGW_MESRule for standard value maintenanceCHAR1C
13CRHDVGM04AP_VGW_MESRule for standard value maintenanceCHAR1C

14CRHDVGM05AP_VGW_MESRule for standard value maintenanceCHAR1NU
15CRHDVGM06AP_VGW_MESRule for standard value maintenanceCHAR1NU
16CRHDZGR01IDZEITGRADKey for performance efficiency rateCHAR3NU
17CRHDZGR02IDZEITGRADKey for performance efficiency rateCHAR3NU

18CRHDZGR03IDZEITGRADKey for performance efficiency rateCHAR3NU

19CRHDZGR04IDZEITGRADKey for performance efficiency rateCHAR3NU

20CRHDZGR05IDZEITGRADKey for performance efficiency rateCHAR3NU

21CRHDZGR06IDZEITGRADKey for performance efficiency rateCHAR3NU

22CRHDPRVBEPRVBEProduction Supply AreaCHAR10C

23CRHDRGEKZRGEKZAPIndicator: BackflushingCHAR1C

24CRHDSTEUSSTEUSControl KeyCHAR4R

25CRHDVGE01VGWRTEHUnit of measure for the standard valueUNIT3C

26CRHDVGE02VGWRTEHUnit of measure for the standard valueUNIT3C

27CRHDVGE03VGWRTEHUnit of measure for the standard valueUNIT3C

28CRHDVGE04VGWRTEHUnit of measure for the standard valueUNIT3C

29CRHDVGE05VGWRTEHUnit of measure for the standard valueUNIT3NU

30CRHDVGE06VGWRTEHUnit of measure for the standard valueUNIT3NU

31CRHDFORT1AP_FORM_T1Formula for setup timeCHAR6C



32CRHDFORT2AP_FORM_T2Formula for the duration of processing timeCHAR6R



33CRHDFORT3AP_FORM_T3Formula for teardown timeCHAR6C



34CRHDFORTNAP_FORM_TNFormula for the duration of other types of int. processingCHAR6NU



35CRTXOBJTYCR_OBJTYObject typeCHAR2S

36CRTXOBJIDCR_OBJIDObject IDNUMC8S

37CRTXSPRASSPRASLanguageCHAR1R

38CRTXKTEXTCR_KTEXTShort descriptionCHAR40R

39CRCAOBJTYCR_OBJTYObject TypeCHAR2S

40CRCAOBJIDCR_OBJIDObject IDNUMC8S

41CRCACANUMCR_CAPNUMCapacity allocation numberCHAR6S


TBD
42CRCAFORK1AP_FORM_K1Formula for Setup Capacity RequirementsCHAR6NU

43CRCAFORK2AP_FORM_K2Formula for Processing Capacity RequirementsCHAR6NU

44CRCAFORK3AP_FORM_K3Formula for Teardown Capacity RequirementsCHAR6NU

45CRCAFORKNAP_FORM_KNFormula for Other Capacity RequirementsCHAR6NU

46CRCAKAPIDKAPIDCapacity IDNUMC8S

47KAKTKAPIDKAPIDCapacity IDNUMC8S

48KAKTSPRASSPRASLanguageCHAR1R

49KAKTKTEXTCR_KTEXTCapacity TextCHAR40R

50CRCOOBJTYCR_OBJTYObject typeCHAR2S

51CRCOOBJIDCR_OBJIDObject IDNUMC8S

52CRCOLASET#N/AActivity Type SetCHAR6S

53CRCOENDDAENDDATUMEnd DateDATS8R


31/12/9999
54CRCOBEGDABEGDATUMStart DateDATS8R

55CRCOKOKRSKOKRSCO AreaCHAR4R

56CRCOKOSTLKOSTLCost CenterCHAR10R

57CRCOLSTAR1LSTARActivity TypeCHAR6C

58CRCOLEINH1LEINHActivity UnitUNIT3C

59CRCOFORML1FORMLFormula key for costingCHAR6R

60CRCOLSTAR2LSTARActivity TypeCHAR6C

61CRCOLEINH2LEINHActivity UnitUNIT3C

62CRCOFORML2FORMLFormula key for costingCHAR6R

63CRCOLSTAR3LSTARActivity TypeCHAR6C

64CRCOLEINH3LEINHActivity UnitUNIT3C

65CRCOFORML3FORMLFormula key for costingCHAR6R

66CRCOLSTAR4LSTARActivity TypeCHAR6C

67CRCOLEINH4LEINHActivity UnitUNIT3C

68CRCOFORML4FORMLFormula key for costingCHAR6R

69CRCOLSTAR5LSTARActivity TypeCHAR6NU

70CRCOLEINH5LEINHActivity UnitUNIT3NU

71CRCOFORML5FORMLFormula key for costingCHAR6NU

72CRCOLSTAR6LSTARActivity TypeCHAR6NU

73CRCOLEINH6LEINHActivity UnitUNIT3NU

74CRCOFORML6FORMLFormula key for costingCHAR6NU

75KAKOKAPIDKAPIDCapacity IDNUMC8S

76KAKOAZMAXKAPANZAHLNo. Ind. CapacitiesINT25NU

77KAKOAZNORKAPANZAHLNo. Ind. CapacitiesINT25R

78KAKOBASNEKAPBASNENDenominator base capDEC5S

79KAKOBASZLKAPBASZHLNumerator base cap.DEC5S

80KAKOBEGZTKAPBEGZTStart TimeINT410R

81KAKOENDZTKAPENDZTEnd TimeINT410R

82KAKOKALIDCR_WFCIDFactory CalendarCHAR2C

83KAKOKAPARKAPARTCapacity categoryCHAR3R

84KAKOMEINSKAPBASISCapacity Base UnitUNIT3R

85KAKOMOSIDSCHGRUPShift GroupingCHAR2C

86KAKONAMEKAPNAMECapacityCHAR8NU

87KAKONGRADNUTZGRADCapacity UtilizationNUMC3R

88KAKOPAUSEKAPPAUSEBreak DurationINT410R

89KAKOPLANRKAPPLANERCapacity Responsible PlannerCHAR3R

90KAKOPOOLKKAP_KZPOOLPooled Capacity IndicatorCHAR1C

91KAKOREFANKAPREFANZNNumber (ref. cap.)INT13C
Not used because it is only used if you are going to do a new creation once we are live
92KAKOREFAZKAPREFANZZNumber (capacity)INT13C
Not used because it is only used if you are going to do a new creation once we are live
93KAKOREFIDKAPIDCapacity IDNUMC8C
Not used because it is only used if you are going to do a new creation once we are live
94KAKOSUPPKKAP_SUPPLYAvail. cap. limitsCHAR1C (if not entered, 100% will be the default)

95KAKOVERSAKAPVERSAKTActive VersionNUMC2R

96KAKOWERKSWERKS_DPlantCHAR4NU

97KAKOKAPIEKAPIDCapacity IDNUMC8NU

98KAKOKAPTERKAP_KZTERRelevant to Finite SchedulingCHAR1C

99KAKOKAPAVOKAP_KZAVOCan be used by several operationsCHAR1C

100KAKOUEBERLASTUEBERLASTOverload (%)NUMC3C

101KAKOKAPLPLKAP_KZLPLNo Long-Term PlanningCHAR1C

102KAKOKAPEHCR_KAPEHCapacity UnitUNIT3NU

103KAKOMEHRKAP_MEHRHas Individual CapacitiesCHAR1NU

104KAKOANG_UNITKAPAZIT_VM_UNITAv. cap. unitUNIT3C

105KAKOANG_MINKAPAZIT_VM_MINMinimum capacityQUAN13C

106KAKOANG_MAXKAPAZIT_VM_MAXMax. capacityQUAN13C


Data Cleansing

Business will perform data cleansing in the current ECC system. This means ECC will serve as the single source of truth for Manufacturing Data prior to the migration to S/4HANA.

IDCriticalityError Message/Report DescriptionRuleOutputSource System
1056-1C1Resource is not used for the last 3 yearsAll Resources not used for the last 3 years, won't be migratedActive Resources during the last 3 yearsPF2 /WP2
1056-2C1Resource is flagged for deletionAll Resources flagged for deletion won't be migratedResources with NO flag for deletionPF2/WP2
1056-3C1Resources in Plants that are Out of ScopeResources created in Plants Out of Scope won't be migratedResources valid in Active plants (To Be mapping)PF2/WP2
1056-4C1Resources with No formulas for capacity, scheduling or costingResources with missing capacity, Scheduling and costing formulas won't be migrated Only Resources with all formulas will be migratedPF2/WP2



Conversion Process

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


Data Privacy and Sensitivity


Extraction

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

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

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

Extraction Run Sheet

Req #Requirement DescriptionTeam Responsible
1Extract data from source system based on relevancy ruleSyWay Data Team
2Google Sheet/ MS Excel/ SQL report pre-populated with PF2 and WP2 information to be generated based on relevancy criteria. SyWay Data Team
3Sinity will extract data and convert it into SQL data base ad share with the teamSinity team


Selection Screen

Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set





















Data Collection Template (DCT)

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

The Data Collection Template (DCT) will not be applicable in this case. If there is a need to create a new Master Data (MD) for Production Version object, the business must perform this activity in the source system. The newly created object will then be captured and migrated as part of the standard migration process. DCT Rules

Field Name

Field description

Rule

 

 

 

Extraction Dependencies

Item #Step DescriptionTeam Responsible
1

Source System Availability

  • Ensure that the source database or application is accessible.
  • Confirm that necessary credentials and permissions are granted

Syensqo IT

2

Data Structure

  • Identify relationships between tables, views, and stored procedures.

Syniti

3

Referential Integrity

  • Ensure dependent records are extracted together.

Syniti

4

Extraction Methodology

  • Define whether extraction is full, incremental, or delta-based.
  • Establish batch processing schedules for large datasets.

Syniti


5

Performance and Scalability Considerations

  • Optimize extraction queries to prevent system overload.
  • Ensure network bandwidth supports data transfer volumes.

Syniti

6

Security and Compliance

  • Adhere to regulatory standards for sensitive information if applicable

Syniti

7

Data cleansing of legacy Resource -

If standardization within the DCT begins using relevant data from PF2 and WP2 before the cleansing is finalized, it is understood that the business will take due diligence to ensure any subsequent delta cleansing is verified and aligned within the DCT.

Business


Transformation

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

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

Transformation Run Sheet

Item #Step DescriptionTeam Responsible
1Obtain DCT Sign-off from BusinessSyWay Data Team
2<Add steps from Syniti Migrate here>SyWay Data Team
3Review and Validate Error and Preload ReportsSyWay Data Team
4Generate Load FilesSyWay Data Team


Transformation Rules

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1PF2/WP2CRHDOBJTYObject typeS4 HANACRHDOBJTYObject type

System Generated Field

2PF2/WP2CRHDOBJIDObject IDS4 HANACRHDOBJIDObject IDSystem Generated Field
3PF2/WP2CRHDARBPLResource IDS4 HANACRHDARBPLResource ID

Look at the file Resources equivalent for Plant - Resource Name as

Existing Plant-New Plant mapping Check Resource name.

4PF2/WP2CRHDWERKSPlantS4 HANACRHDWERKSPlant

Map from Old Plants to New Plants

5PF2/WP2CRHDVERWEWork Center CategoryS4 HANACHRDVERWEWork Center Category

VALUE 0008

6PF2/WP2CRHDPLANVKey for task list usageS4 HANACHRDPLANVKey for task list usage

Value Direct from the current system

7PF2/WP2CRHDSTANDWork Center locationS4 HANACHRDSTANDWork Center location

Copy from Legacy

8PF2/WP2CRHDVERANPerson Responsible for the Work CenterS4 HANACHRDVERAN

Copy from Legacy

9PF2/WP2CRHDVGWTSStandard Value KeyS4 HANACHRDVGWTSStandard Value KeyFollow Mfg Execution Config book (one standard value key for all resources / all GBUs) Value - SAP9
10PF2/WP2CRHDVGM01Rule for standard value maintenanceS4 HANACHRDVGM01Rule for standard value maintenanceIf the standard value is pulled and used then this field is required. Value to be taken from VGWTS - STD value key Value - SAP_01
11PF2/WP2CRHDVGM02Rule for standard value maintenanceS4 HANACHRDVGM02Rule for standard value maintenanceIf the standard value is pulled and used then this field is required. Value to be taken from VGWTS - STD value key Value - SAP_02
12PF2/WP2CRHDVGM03Rule for standard value maintenanceS4 HANACHRDVGM03Rule for standard value maintenanceIf the standard value is pulled and used then this field is required. Value to be taken from VGWTS - STD value key Value - SAP_03
13PF2/WP2CRHDVGM04Rule for standard value maintenanceS4 HANACHRDVGM04Rule for standard value maintenanceIf the standard value is pulled and used then this field is required. Value to be taken from VGWTS - STD value key Value - SAP_20
14PF2/WP2CRHDPRVBEProduction Supply AreaS4 HANACHRDPRVBEProduction Supply Area

Business Rule
This field will be populated if relevant for EWM based on the plant (this has not been completely defined yet) MDS for EWM           DD-FUN-050 Master Data  Standard_1180-PSA (EWM)

Because the warehouse can support holding stock that belongs to more than one plant, the PP PSA is replicated to EWM by adding the plant number preceded by a "/" to be able to tell in the warehouse to which plant the original PSA belongs. - Value Mapping

15   PF2/WP2CRHDRGEKZIndicator: BackflushingS4 HANACHRDRGEKZIndicator: BackflushingBusiness Rule
If all components used at a machine/line should be automatically issued at confirmation - Copy from Legacy
16PF2/WP2CRHDSTEUSControl KeyS4 HANACHRDSTEUSControl KeyMandatory Direct from the current system
17PF2/WP2CRHDVGE01Unit of measure for the standard valueS4 HANACHRDVGE01Unit of measure for the standard valueIf the rule of the corresponding standard Value is used then this unit should be filled. Value to be taken from VGWTS - STD value key
18PF2/WP2CRHDVGE02Unit of measure for the standard valueS4 HANACHRDVGE02Unit of measure for the standard valueIf the rule of the corresponding standard Value is used then this unit should be filled. Value to be taken from VGWTS - STD value key
19PF2/WP2CRHDVGE03Unit of measure for the standard valueS4 HANACHRDVGE03Unit of measure for the standard valueIf the rule of the corresponding standard Value is used then this unit should be filled. Value to be taken from VGWTS - STD value key
20PF2/WP2CRHDVGE04Unit of measure for the standard valueS4 HANACHRDVGE04Unit of measure for the standard valueIf the rule of the corresponding standard Value is used then this unit should be filled. Value to be taken from VGWTS - STD value key
21PF2/WP2CRHDFORT1Formula for setup timeS4 HANACHRDFORT1Formula for setup timeStandard Formula SAP001
22PF2/WP2CRHDFORT2Formula for the duration of processing timeS4 HANACHRDFORT2Formula for the duration of processing timeStandard Formula SAP002
23PF2/WP2CRHDFORT3Formula for teardown timeS4 HANACHRDFORT3Formula for teardown timeStandard Formula SAP010
24PF2/WP2CRTXOBJTYObject typeS4 HANACRTXOBJTYObject typeSystem Generated Field
25PF2/WP2CRTXOBJIDObject IDS4 HANACRTXOBJIDObject IDSystem Generated Field
26PF2/WP2CRTXSPRASLanguage S4 HANACRTXSPRASLanguage Value direct from the current SAP system, Languages will need to be configured, mostly set as EN (Language which the Resource is maintained) 
27PF2/WP2CRTXKTEXTShort descriptionS4 HANACRTXKTEXTShort descriptionCopy from Legacy
28PF2/WP2CRCAOBJTYObject TypeS4 HANACRCAOBJTYObject TypeSystem Generated Field
29PF2/WP2CRCAOBJIDObject IDS4 HANACRCAOBJIDObject IDSystem Generated Field
30PF2/WP2CRCACANUMCapacity allocation numberS4 HANACRCACANUMCapacity allocation numberSystem Generated Field
31PF2/WP2CRCAKAPIDCapacity IDS4 HANACRCAKAPIDCapacity IDSystem Generated Field
32PF2/WP2KAKTKAPIDCapacity IDS4 HANAKAKTKAPIDCapacity IDSystem Generated Field
33PF2/WP2KAKTSPRASLanguageS4 HANAKAKTSPRASLanguageValue direct from the current SAP system, Languages will need to be configured, mostly set as EN (Language which the Capacity is maintained) 
34PF2/WP2KAKTKTEXTCapacity TextS4 HANAKAKTKTEXTCapacity TextCopy From Legacy
35PF2/WP2CRCOOBJTYObject typeS4 HANACRCOOBJTYObject typeSystem Generated Field
36PF2/WP2CRCOOBJIDObject IDS4 HANACRCOOBJIDObject IDSystem Generated Field
37PF2/WP2CRCOLASETActivity Type SetS4 HANACRCOLASETActivity Type SetSystem Generated Field
38PF2/WP2CRCOENDDAEnd DateS4 HANACRCOENDDAEnd DateEnd date has value set to 31/12/9999 
39PF2/WP2CRCOBEGDAStart DateS4 HANACRCOBEGDAStart DateDate value setting DD.MM.YYYY Copy from current system
40PF2/WP2CRCOKOKRSCO AreaS4 HANACRCOKOKRSCO AreaThis is Part of DCT in the Cost centre Conversion Spec - Value Mapping
41PF2/WP2CRCOKOSTLCost CenterS4 HANACRCOKOSTLCost CenterThis is Part of DCT in the Cost centre Conversion Spec - Value Mapping
42PF2/WP2CRCOLSTAR1Activity TypeS4 HANACRCOLSTAR1Activity TypeThis is Part of DCT in the Cost centre Conversion Spec - Value Mapping
43PF2/WP2CRCOLEINH1Activity UnitS4 HANACRCOLEINH1Activity UnitThis is Part of DCT in the Cost centre Conversion Spec - Value Mapping
44PF2/WP2CRCOFORML1Formula key for costingS4 HANACRCOFORML1Formula key for costing

Value to be taken from VGWTS - STD value key Value - SAP001

45PF2/WP2CRCOLSTAR2Activity TypeS4 HANACRCOLSTAR2Activity TypeThis is Part of DCT in the Cost centre Conversion Spec - Value Mapping
46PF2/WP2CRCOLEINH2Activity UnitS4 HANACRCOLEINH2Activity UnitThis is Part of DCT in the Cost centre Conversion Spec - Value Mapping
47PF2/WP2CRCOFORML2Formula key for costingS4 HANACRCOFORML2Formula key for costingValue to be taken from VGWTS - STD value key Value - SAP002
48PF2/WP2CRCOLSTAR3Activity TypeS4 HANACRCOLSTAR3Activity TypeThis is Part of DCT in the Cost centre Conversion Spec - Value Mapping
49PF2/WP2CRCOLEINH3Activity UnitS4 HANACRCOLEINH3Activity UnitThis is Part of DCT in the Cost centre Conversion Spec - Value Mapping
50PF2/WP2CRCOFORML3Formula key for costingS4 HANACRCOFORML3Formula key for costingValue to be taken from VGWTS - STD value key Value - SAP003
51PF2/WP2CRCOLSTAR4Activity TypeS4 HANACRCOLSTAR4Activity TypeThis is Part of DCT in the Cost centre Conversion Spec - Value Mapping
52PF2/WP2CRCOLEINH4Activity UnitS4 HANACRCOLEINH4Activity UnitThis is Part of DCT in the Cost centre Conversion Spec - Value Mapping
53PF2/WP2CRCOFORML4Formula key for costingS4 HANACRCOFORML4Formula key for costingValue to be taken from VGWTS - STD value key Value - SAP010
54PF2/WP2KAKOKAPIDCapacity IDS4 HANAKAKOKAPIDCapacity ID

System Generated

55PF2/WP2KAKOAZNORNo. Ind. CapacitiesS4 HANAKAKOAZNORNo. Ind. CapacitiesCopy From ECC
56PF2/WP2KAKOBASNEDenominator base capS4 HANAKAKOBASNEDenominator base capSystem Generated
57PF2/WP2KAKOBASZLNumerator base cap.S4 HANAKAKOBASZLNumerator base cap.System Generated
58PF2/WP2KAKOBEGZTStart TimeS4 HANAKAKOBEGZTStart TimeCopy From ECC
59PF2/WP2KAKOENDZTEnd TimeS4 HANAKAKOENDZTEnd TimeCopy From ECC
60PF2/WP2KAKOKALIDFactory CalendarS4 HANAKAKOKALIDFactory CalendarConditional : Business Rule
Assign the correct Factory Calendar to the resource. If left blank, the system will use directly the plant factory calendar by default
The calendar used is the one assigned to the plant or it's a calendar defined in the same country - Factory Calendar under TM team to define the values, Value Mapping
61PF2/WP2KAKOKAPARCapacity categoryS4 HANAKAKOKAPARCapacity categoryCopy From ECC
62PF2/WP2KAKOMEINSCapacity Base UnitS4 HANAKAKOMEINSCapacity Base UnitCopy From ECC
63PF2/WP2KAKOMOSIDShift GroupingS4 HANAKAKOMOSIDShift GroupingCopy values by plant from Legacy
64PF2/WP2KAKONGRADCapacity UtilizationS4 HANAKAKONGRADCapacity UtilizationCopy From ECC
65PF2/WP2KAKOPAUSEBreak DurationS4 HANAKAKOPAUSEBreak DurationCopy From ECC
66PF2/WP2KAKOPLANRCapacity Responsible PlannerS4 HANAKAKOPLANRCapacity Responsible PlannerCopy From ECC
67PF2/WP2KAKOPOOLKPooled Capacity IndicatorS4 HANAKAKOPOOLKPooled Capacity IndicatorSystem Generated
68PF2/WP2KAKOSUPPKAvail. cap. limitsS4 HANAKAKOSUPPKAvail. cap. limitsConditional: Business Rule
If not entered 100% capacity will be used by default in the system - Copy from ECC
69PF2/WP2KAKOVERSAActive VersionS4 HANAKAKOVERSAActive VersionCopy From ECC
70PF2/WP2KAKOKAPTERRelevant to Finite SchedulingS4 HANAKAKOKAPTERRelevant to Finite SchedulingAlways set to X
71PF2/WP2KAKOKAPAVOCan be used by several operationsS4 HANAKAKOKAPAVOCan be used by several operationsAlways set to X
72PF2/WP2KAKOUEBERLASTOverload (%)S4 HANAKAKOUEBERLASTOverload (%)Copy from ECC
73PF2/WP2KAKOKAPLPLNo Long-Term PlanningS4 HANAKAKOKAPLPLNo Long-Term PlanningAlways set to X
74PF2/WP2KAKOANG_UNITAv. cap. unitS4 HANAKAKOANG_UNITAv. cap. unit
75PF2/WP2KAKOANG_MINMinimum capacityS4 HANAKAKOANG_MINMinimum capacity
76PF2/WP2KAKOANG_MAXMax. capacityS4 HANAKAKOANG_MAXMax. capacity


Transformation Mapping

Mapping Table NameMapping Table Description
Work CentreMapping of legacy Work Center to new Work Centers to target system value
PlantMapping of legacy Plants to new Plants to target system value
Standard Value KeyMapping of legacy Standard Value Key  to new Standard Value Key to target system value


Transformation Dependencies

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

1

Ensure DCT tables completeness

SyWay Data Team

2

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

SyWay Data Team


Pre-Load Validation

Project Team

Completeness

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

Accuracy

TaskAction
Conversion Accuracy

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

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

Business

Completeness

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

Accuracy

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


Load

The load process includes:

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

Load Run Sheet

Item #Step DescriptionTeam Responsible
1Go to <Load Tool>SyWay Data Team
2Load 3 records for < > to validate if data is loaded successfully without errorsSyWay Data Team
3Proceed with full load if steps 2 and 3 are validatedSyWay Data Team
4Validate few records loaded by accessing standard transactions from S/4HNA eg. CS04SyWay Data Team
5Generate post load report if step 5 is validatedSyWay Data Team


Load Phase and Dependencies

Configuration

Item #Configuration Item
1T001W-Plants/Branches
2TC30-Work Centre Category
3TC23-Key for use of the work center in the task lists
4T499S-Work Centre Location
5TC24-Person responsible for the work center
6TC21-Standard Value Key
7PVKT-Production Supply Area
8T430-Control Key
9T006-Units of Measurement
10TC26-Capacity Category
11TKA01-Controlling Areas
12OP54-Formula key for costing
13TFACD-Factory Calendar
14TC39A-Shifting Group
15TC27-Capacity Responsible Planner
16TC36-Active Version

Conversion Objects

Object #Preceding Object Conversion Approach
1071Activity Type
1074Cost Centre

Error Handling

Error TypeError DescriptionAction Taken
1Work Centre has not been created in a PlantEnsure the Work centre mapping is correct and or create the Work centre if it is valid
2Configuration is missing

Verify that all configuration exists and reprocess when they are available (See configuration in Spec)


Post-Load Validation

Project Team

Completeness

TaskAction
Verify CountSyWay P2F 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 LogsCheck 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 CountDownload 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 AccuracyVerify that the Resource data in target S/4 HANA were loaded correctly via DSP Migrate 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.
  • is in scope based on data design and any exception requested by business.


See also

Change log

Version Published Changed By Comment
CURRENT (v. 67) Apr 29, 2026 14:24 ULLAH-ext, Colin
v. 114 Apr 28, 2026 08:50 ULLAH-ext, Colin
v. 113 Apr 17, 2026 15:50 ULLAH-ext, Colin
v. 112 Apr 17, 2026 14:38 ULLAH-ext, Colin
v. 111 Apr 02, 2026 13:57 ULLAH-ext, Colin
v. 110 Apr 02, 2026 13:25 ULLAH-ext, Colin
v. 109 Apr 02, 2026 12:51 ULLAH-ext, Colin
v. 108 Mar 12, 2026 15:35 ULLAH-ext, Colin
v. 107 Mar 12, 2026 14:56 ULLAH-ext, Colin ADDED OBJTY AND OBJID to DCT for KAKO and KAKT
v. 106 Mar 02, 2026 15:51 ULLAH-ext, Colin

Go to Page History

Workflow history

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

  • No labels