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

Compare with Current View Page History

« Previous Version 25 Next »

Status

  Update in progress

OwnerCASTRO MONCAYO-ext, Jose Luis 
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.


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)


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  

TBDS/4 HANATBD
DCTResources for Plant / Resources combination which do not have data existing from PF2 and PF2TBDS/4 HANATBD










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

1CHRDOBJTYCR_OBJTYObject typeCHAR2SIn Scope
2CHRDOBJIDCR_OBJIDObject IDNUMC8S
3CHRDARBPLARBPLWork CenterCHAR8RTBD
4CHRDWERKSWERKS_DPlantCHAR4RTBD
5CHRDVERWEAP_VERWEWork Center CategoryCHAR4R

0008 Processing Unit
6CHRDPLANVAP_PLANVKey for task list usageCHAR3R

0008 Master Recipe + Process Order
7CHRDSTANDAP_STANDWork center locationCHAR10C

MFG Execution Config Register
8CHRDVERANAP_VERANPerson Responsible for the Work CenterCHAR3C

MFG Execution Config Register
9CHRDVGWTSVORGSCHLStandard Value KeyCHAR4R

TBD
10CHRDVGM01AP_VGW_MESRule for standard value maintenanceCHAR1C
11CHRDVGM02AP_VGW_MESRule for standard value maintenanceCHAR1C
12CHRDVGM03AP_VGW_MESRule for standard value maintenanceCHAR1C
13CHRDVGM04AP_VGW_MESRule for standard value maintenanceCHAR1CIn Scope
14CHRDVGM05AP_VGW_MESRule for standard value maintenanceCHAR1C
15CHRDVGM06AP_VGW_MESRule for standard value maintenanceCHAR1C
16CHRDZGR01IDZEITGRADKey for performance efficiency rateCHAR3NU
17CHRDZGR02IDZEITGRADKey for performance efficiency rateCHAR3NU

18CHRDZGR03IDZEITGRADKey for performance efficiency rateCHAR3NU

19CHRDZGR04IDZEITGRADKey for performance efficiency rateCHAR3NU

20CHRDZGR05IDZEITGRADKey for performance efficiency rateCHAR3NU

21CHRDZGR06IDZEITGRADKey for performance efficiency rateCHAR3NU

22CHRDPRVBEPRVBEProduction Supply AreaCHAR10C

23CHRDRGEKZRGEKZAPIndicator: BackflushingCHAR1C

24CHRDSTEUSSTEUSControl KeyCHAR4R

25CHRDVGE01VGWRTEHUnit of measure for the standard valueUNIT3C

26CHRDVGE02VGWRTEHUnit of measure for the standard valueUNIT3C

27CHRDVGE03VGWRTEHUnit of measure for the standard valueUNIT3C

28CHRDVGE04VGWRTEHUnit of measure for the standard valueUNIT3C

29CHRDVGE05VGWRTEHUnit of measure for the standard valueUNIT3C

30CHRDVGE06VGWRTEHUnit of measure for the standard valueUNIT3C

31CHRDKAPARKAPARTCapacity categoryCHAR3C

32CHRDKAPNAMEKAPNAMECapacity nameCHAR8C

33CHRDFORT1AP_FORM_T1Formula for setup timeCHAR6NU


TBD

34CHRDFORT2AP_FORM_T2Formula for the duration of processing timeCHAR6NU


TBD
35CHRDFORT3AP_FORM_T3Formula for teardown timeCHAR6NU


TBD
36CHRDFORTNAP_FORM_TNFormula for the duration of other types of int. processingCHAR6NU


TBD
37CRTXOBJTYCR_OBJTYObject typeCHAR2S

38CRTXOBJIDCR_OBJIDObject IDNUMC8S

39CRTXSPRASSPRASLanguageCHAR1R

40CRTXKTEXTCR_KTEXTShort descriptionCHAR40R

41CRCAOBJTYCR_OBJTYObject TypeCHAR2S

42CRCAOBJIDCR_OBJIDObject IDNUMC8S

43CRCACANUMCR_CAPNUMCapacity allocation numberCHAR6S


TBD
44CRCAFORK1AP_FORM_K1Formula for Setup Capacity RequirementsCHAR6NU

45CRCAFORK2AP_FORM_K2Formula for Processing Capacity RequirementsCHAR6NU

46CRCAFORK3AP_FORM_K3Formula for Teardown Capacity RequirementsCHAR6NU

47CRCAFORKNAP_FORM_KNFormula for Other Capacity RequirementsCHAR6NU

48CRCAKAPIDKAPIDCapacity IDNUMC8S

49KAKTKAPIDKAPIDCapacity IDNUMC8S

50KAKTSPRASSPRASLanguageCHAR1C

51KAKTKTEXTCR_KTEXTCapacity TextCHAR40C

52CRCOOBJTYCR_OBJTYObject typeCHAR2S

53CRCOOBJIDCR_OBJIDObject IDNUMC8S

54CRCOLASET#N/AActivity Type SetCHAR6S

55CRCOENDDAENDDATUMEnd DateDATS8C



56CRCOBEGDABEGDATUMStart DateDATS8C

57CRCOKOKRSKOKRSCO AreaCHAR4R

58CRCOKOSTLKOSTLCost CenterCHAR10R

59CRCOLSTAR1LSTARActivity TypeCHAR6R

60CRCOLEINH1LEINHActivity UnitUNIT3C

61CRCOFORML1FORMLFormula key for costingCHAR6R

62CRCOLSTAR2LSTARActivity TypeCHAR6R

63CRCOLEINH2LEINHActivity UnitUNIT3C

64CRCOFORML2FORMLFormula key for costingCHAR6R

65CRCOLSTAR3LSTARActivity TypeCHAR6R

66CRCOLEINH3LEINHActivity UnitUNIT3C

67CRCOFORML3FORMLFormula key for costingCHAR6R

68CRCOLSTAR4LSTARActivity TypeCHAR6R

69CRCOLEINH4LEINHActivity UnitUNIT3C

70CRCOFORML4FORMLFormula key for costingCHAR6R

71CRCOLSTAR5LSTARActivity TypeCHAR6R

72CRCOLEINH5LEINHActivity UnitUNIT3C

73CRCOFORML5FORMLFormula key for costingCHAR6R

74CRCOLSTAR6LSTARActivity TypeCHAR6R

75CRCOLEINH6LEINHActivity UnitUNIT3C

76CRCOFORML6FORMLFormula key for costingCHAR6R


Data Cleansing

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

DCT Rules

Field Name

Field description

Rule

CRHD-OBJTYObject type

Internally used key which identifies the type of operating resource. For example, the following indicators represent:

Data Type: Character

Length: 2

CRHD-OBJIDObject ID

This internally used number and the object type identify the operating resource

Data Type: Numeric

Length: 8

CRHD-ARBPLWork Center

Represents a machine, group of machines, production line or a person assigned to an operation

Data Type: Character

Length: 8

CRHD-WERKSPlant

Key uniquely identifying a plant

Data Type: Character

Length: 4

CRHD-VERWEWork Center Category

Key differentiating resources according to their category (e.g. resource network, process unit)

Data Type: Character

Length: 4

CRHD-PLANVKey for task list usage

Controls which type of tasks list are allowed to use this resource

Data Type: Character

Length: 3

CRHD-STANDWork center location

Represents the physical location of the resource

Data Type: Character

Length: 10

CRHD-VERANPerson Responsible for the Work Center

The person or group of people who are responsible for the maintenance of the resource - Useful for Reporting purposes

Data Type: Character

Length: 3

CRHD-VGWTSStandard Value Key

The system uses standard values as parameters with origin "standard value" in formulas to calculate execution time, capacity requirements and costs

Data Type: Character

Length: 4

CRHD-VGM01Rule for standard value maintenance

Determines how the system reacts when you enter or do not enter a standard value in an operation of a Master Recipe (must be entered, should be entered, should not be entered, cannot be entered)

Data Type: Character

Length: 1

CRHD-VGM02Rule for standard value maintenance

Determines how the system reacts when you enter or do not enter a standard value in an operation of a Master Recipe (must be entered, should be entered, should not be entered, cannot be entered)

Data Type: Character

Length: 1

CRHD-VGM03Rule for standard value maintenance

Determines how the system reacts when you enter or do not enter a standard value in an operation of a Master Recipe (must be entered, should be entered, should not be entered, cannot be entered)

Data Type: Character

Length: 1

CRHD-VGM04Rule for standard value maintenance

Determines how the system reacts when you enter or do not enter a standard value in an operation of a Master Recipe (must be entered, should be entered, should not be entered, cannot be entered)

Data Type: Character

Length: 1

CRHD-VGM05Rule for standard value maintenance

Determines how the system reacts when you enter or do not enter a standard value in an operation of a Master Recipe (must be entered, should be entered, should not be entered, cannot be entered)

Data Type: Character

Length: 1

CRHD-VGM06Rule for standard value maintenance

Determines how the system reacts when you enter or do not enter a standard value in an operation of a Master Recipe (must be entered, should be entered, should not be entered, cannot be entered)

Data Type: Character

Length: 1

CRHD-PRVBEProduction Supply Area

Serves as a place for interim storage on the shop floor and is used to make material directly available for production purposes
 Will be used for EWM flows

Data Type: Character

Length: 10

CRHD-RGEKZIndicator: Backflushing

Indicates that material components allocated to the operation are backflushed

Data Type: Character

Length: 1

CRHD-STEUSControl Key

Determines which business transactions should be executed for the object that belongs to the task list or order (for example scheduling or costing).

Data Type: Character

Length: 4

CRHD-VGE01Unit of measure for the standard value

Unit of the standard value. If you have specified a unit in the work center, your entry is taken as the default value

Data Type: Unit

Length: 3

CRHD-VGE02Unit of measure for the standard value

Unit of the standard value. If you have specified a unit in the work center, your entry is taken as the default value

Data Type: Unit

Length: 3

CRHD-VGE03Unit of measure for the standard value

Unit of the standard value. If you have specified a unit in the work center, your entry is taken as the default value

Data Type: Unit

Length: 3

CRHD-VGE04Unit of measure for the standard value

Unit of the standard value. If you have specified a unit in the work center, your entry is taken as the default value

Data Type: Unit

Length: 3

CRHD-VGE05Unit of measure for the standard value

Unit of the standard value. If you have specified a unit in the work center, your entry is taken as the default value

Data Type: Unit

Length: 3

CRHD-VGE06Unit of measure for the standard value

Unit of the standard value. If you have specified a unit in the work center, your entry is taken as the default value

Data Type: Unit

Length: 3

CRHD-KAPARTCapacity category

Field Categorizes the Capacity of a Work Center

Data Type: Character

Length: 3

CRHD-KAPNAMECapacity name

Capacity Name or Capacity Description 

Data Type: Character

Length: 4

CRHD-FORT1Formula for setup time

Formula used in scheduling to calculate the setup time of an operation

Data Type: Character

Length: 6

TBD not sure if this will be used - Functional to advise

CRHD-FORT2Formula for the duration of processing time

Formula used in scheduling to determine the operation processing time

Data Type: Character

Length: 6

TBD not sure if this will be used - Functional to advise

CRHD-FORT3Formula for teardown time

Formula used in scheduling to determine teardown time in an operation

Data Type: Character

Length: 6

TBD not sure if this will be used - Functional to advise

CRHD-FORTNFormula for the duration of other types of int. processing

Formula for calculating the duration times of other types of internal processing in scheduling

Data Type: Character

Length: 6

TBD not sure if this will be used - Functional to advise

CRTX-OBJTYObject type

Internally used key which identifies the type of operating resource. For example, the following indicators represent:

Data Type: Character

Length: 2

CRTX-OBJIDObject ID

This internally used number and the object type identify the operating resource

Data Type: Numeric

Length: 8

CRTX-SPRASLanguage

Language in which the resource description is maintained

Data Type: Character

Length: 1

CRTX-KTEXTShort description

Contains a brief description of the resource

Data Type: Character

Length: 40

CRCA-OBJTYObject Type

Internally used key which identifies the type of operating resource. For example, the following indicators represent:

Data Type: Character

Length: 2

CRCA-OBJIDObject ID

This internally used number and the object type identify the operating resource

Data Type: Numeric

Length: 8

CRCA-CANUMCapacity allocation number

The number along with the capacity category which identifies the capacity in the resource

Data Type: Character

Length: 6

CRCA-KAPIDCapacity ID

ID to identify the capacity header

Data Type: Numeric

Length: 8

KAKT-KAPIDCapacity ID

ID to identify the capacity header

Data Type: Numeric

Length: 8

KAKT-SPRASLanguage

Language of the text displayed

Data Type: Character

Length: 1

KAKT-KTEXTCapacity Text

Description of Capacity

Data Type: Character

Length: 40

CRCO-OBJTYObject type

Internally used key which identifies the type of operating resource. For example, the following indicators represent:

Data Type: Character

Length: 2

CRCO-OBJIDObject ID

This internally used number and the object type identify the operating resource

Data Type: Numeric

Length: 8

CRCO-LASETActivity Type Set

Represents the assignment number of an activity type within a work center's costing data

Data Type: Character

Length: 6

CRCO-ENDDAEnd Date

date that identifies the end of the validity period

Data Type: Date Field

Length: 8 DD/MM/YYYY

CRCO-BEGDAStart Date

date that identifies the start of a validity period

Data Type: Date Field

Length: 8 DD/MM/YYYY


CRCO-KOKRSCO Area

An organizational unit within an enterprise for which a complete cost accounting can be performed within a closed system

Data Type: Character

Length: 4

CRCO-KOSTLCost Center

Represents a delimited location where costs occur

Data Type: Character

Length: 10

CRCO-LSTAR1Activity Type

Activity types describe the activity produced by a cost center and are measured in units of time or quantity

Data Type: Character

Length: 6

CRCO-LEINH1Activity Unit

The activity unit is either the time or quantity unit used to post the consumed activity quantities

Data Type: Unit

Length: 3

CRCO-FORML1Formula key for costing

Refers to the formula used for Calculation of costs of a work center's activity type

Data Type: Character

Length: 6

CRCO-LSTAR2Activity Type

Activity types describe the activity produced by a cost center and are measured in units of time or quantity

Data Type: Character

Length: 6

CRCO-LEINH2Activity Unit

The activity unit is either the time or quantity unit used to post the consumed activity quantities

Data Type: Unit

Length: 3

CRCO-FORML2Formula key for costing

Refers to the formula used for Calculation of costs of a work center's activity type

Data Type: Character

Length: 6

CRCO-LSTAR3Activity Type

Activity types describe the activity produced by a cost center and are measured in units of time or quantity

Data Type: Character

Length: 6

CRCO-LEINH3Activity Unit

The activity unit is either the time or quantity unit used to post the consumed activity quantities

Data Type: Unit

Length: 3

CRCO-FORML3Formula key for costing

Refers to the formula used for Calculation of costs of a work center's activity type

Data Type: Character

Length: 6

CRCO-LSTAR4Activity Type

Activity types describe the activity produced by a cost center and are measured in units of time or quantity

Data Type: Character

Length: 6

CRCO-LEINH4Activity Unit

The activity unit is either the time or quantity unit used to post the consumed activity quantities

Data Type: Unit

Length: 3

CRCO-FORML4Formula key for costingRefers to the formula used for Calculation of costs of a work center's activity type
CRCO-LSTAR5Activity TypeActivity types describe the activity produced by a cost center and are measured in units of time or quantity
CRCO-LEINH5Activity Unit

The activity unit is either the time or quantity unit used to post the consumed activity quantities

Data Type: Unit

Length: 3

CRCO-FORML5Formula key for costing

refers to the formula used for Calculation of costs of a work center's activity type

Data Type: Character

Length: 6

CRCO-LSTAR6Activity Type

Activity types describe the activity produced by a cost center and are measured in units of time or quantity

Data Type: Character

Length: 6

CRCO-LEINH6Activity Unit

The activity unit is either the time or quantity unit used to post the consumed activity quantities

Data Type: Unit

Length: 3

CRCO-FORML6Formula key for costing

refers to the formula used for Calculation of costs of a work center's activity type

Data Type: Character

Length: 6

Extraction Dependencies

Item #Step DescriptionTeam Responsible













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
1PF2CHRDOBJTYObject typeS4 HANACRHDOBJTYObject type

System Generated Field

2PF2CRHDOBJIDObject IDS4 HANACRHDOBJIDObject IDSystem Generated Field
3PF2CRHDARBPLResource IDS4 HANACRHDARBPLResource ID

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

Existing Plant-New Plant mapping Check Resource name.

4PF2CRHDWERKSPlantS4 HANACRHDWERKSPlant

Map from Old Plants to New Plants

5PF2CHRDVERWEWork Center CategoryS4 HANACHRDVERWEWork Center Category

VALUE 0008

6PF2CHRDPLANVKey for task list usageS4 HANACHRDPLANVKey for task list usage

Value Direct from the current system

7PF2CHRDSTANDWork center locationS4 HANACHRDSTANDWork center locationValue set based upon MFG Execution Config Register
8PF2CHRDVERANPerson Responsible for the Work CenterS4 HANACHRDVERANPerson Responsible for the Work CenterValue set based upon MFG Execution Config Register
9PF2CHRDVGWTSStandard Value KeyS4 HANACHRDVGWTSStandard Value KeyTBD - Plant maybe part of transformation and mapping
10PF2CHRDVGM01Rule for standard value maintenanceS4 HANACHRDVGM01Rule for standard value maintenanceValue Direct from the current system
11PF2CHRDVGM02Rule for standard value maintenanceS4 HANACHRDVGM02Rule for standard value maintenanceValue Direct from the current system
12PF2CHRDVGM03Rule for standard value maintenanceS4 HANACHRDVGM03Rule for standard value maintenanceValue Direct from the current system
13PF2CHRDVGM04Rule for standard value maintenanceS4 HANACHRDVGM04Rule for standard value maintenanceValue Direct from the current system
14PF2CHRDVGM05Rule for standard value maintenanceS4 HANACHRDVGM05Rule for standard value maintenanceValue Direct from the current system
15PF2CHRDVGM06Rule for standard value maintenanceS4 HANACHRDVGM06Rule for standard value maintenanceValue Direct from the current system
16PF2CHRDPRVBEProduction Supply AreaS4 HANACHRDPRVBEProduction Supply AreaValue Direct from the current system
17PF2CHRDRGEKZIndicator: BackflushingS4 HANACHRDRGEKZIndicator: BackflushingValue is 'X' or 'Null'
18PF2CHRDSTEUSControl KeyS4 HANACHRDSTEUSControl KeyMandatory Direct from the current system? 
19PF2CHRDVGE01Unit of measure for the standard valueS4 HANACHRDVGE01Unit of measure for the standard valueValue Direct from the current system
20PF2CHRDVGE02Unit of measure for the standard valueS4 HANACHRDVGE02Unit of measure for the standard valueValue Direct from the current system
21PF2CHRDVGE03Unit of measure for the standard valueS4 HANACHRDVGE03Unit of measure for the standard valueValue Direct from the current system
22PF2CHRDVGE04Unit of measure for the standard valueS4 HANACHRDVGE04Unit of measure for the standard valueValue Direct from the current system
23PF2CHRDVGE05Unit of measure for the standard valueS4 HANACHRDVGE05Unit of measure for the standard valueValue Direct from the current system
24PF2CHRDVGE06Unit of measure for the standard valueS4 HANACHRDVGE06Unit of measure for the standard valueValue Direct from the current system
25PF2CHRDKAPARTCapacity categoryS4 HANACHRDKAPARTCapacity categoryValue Direct from the current system
26PF2CHRDKAPNAMECapacity nameS4 HANACHRDKAPNAMECapacity nameValue Direct from the current system
27PF2CHRDFORT1Formula for setup timeS4 HANACHRDFORT1Formula for setup timeRegistered as Not used, but this is to be decided, current SAP has values
28PF2CHRDFORT2Formula for the duration of processing timeS4 HANACHRDFORT2Formula for the duration of processing timeRegistered as Not used, but this is to be decided, current SAP has values
29PF2CHRDFORT3Formula for teardown timeS4 HANACHRDFORT3Formula for teardown timeRegistered as Not used, but this is to be decided, current SAP has values
30PF2CHRDFORTNFormula for the duration of other types of int. processingS4 HANACHRDFORTNFormula for the duration of other types of int. processingRegistered as Not used, but this is to be decided, current SAP has values
31PF2CRTXOBJTYObject typeS4 HANACRTXOBJTYObject typeSystem Generated Field
32PF2CRTXOBJIDObject IDS4 HANACRTXOBJIDObject IDSystem Generated Field
33PF2CRTXSPRASLanguage 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) 
34PF2CRTXKTEXTShort descriptionS4 HANACRTXKTEXTShort descriptionValue direct from current SAP system, free text field, brief description of the Resource SPRAS Language
35PF2CRCAOBJTYObject TypeS4 HANACRCAOBJTYObject TypeSystem Generated Field
36PF2CRCAOBJIDObject IDS4 HANACRCAOBJIDObject IDSystem Generated Field
37PF2CRCACANUMCapacity allocation numberS4 HANACRCACANUMCapacity allocation numberSystem Generated Field, The data value is TBD
38PF2CRCAKAPIDCapacity IDS4 HANACRCAKAPIDCapacity IDSystem Generated Field
39PF2KAKTKAPIDCapacity IDS4 HANAKAKTKAPIDCapacity IDSystem Generated Field
40PF2KAKTSPRASLanguageS4 HANAKAKTSPRASLanguageValue direct from the current SAP system, Languages will need to be configured, mostly set as EN (Language which the Capacity is maintained) 
41PF2KAKTKTEXTCapacity TextS4 HANAKAKTKTEXTCapacity TextValue direct from current SAP system, free text field, brief description of the Capacity SPRAS Language
42PF2CRCOOBJTYObject typeS4 HANACRCOOBJTYObject typeSystem Generated Field
43PF2CRCOOBJIDObject IDS4 HANACRCOOBJIDObject IDSystem Generated Field
44PF2CRCOLASETActivity Type SetS4 HANACRCOLASETActivity Type SetSystem Generated Field
45PF2CRCOENDDAEnd DateS4 HANACRCOENDDAEnd DateEnd date has value set to 31/12/9999 
46PF2CRCOBEGDAStart DateS4 HANACRCOBEGDAStart DateDate value setting DD.MM.YYYY 
47PF2CRCOKOKRSCO AreaS4 HANACRCOKOKRSCO AreaMandatory Value direct from current SAP system
48PF2CRCOKOSTLCost CenterS4 HANACRCOKOSTLCost CenterMandatory Value direct from current SAP system
49PF2CRCOLSTAR1Activity TypeS4 HANACRCOLSTAR1Activity TypeMandatory Value Direct from the current SAP system measured in units of time or Quantity
50PF2CRCOLEINH1Activity UnitS4 HANACRCOLEINH1Activity UnitValue Direct from the current SAP system 
51PF2CRCOFORML1Formula key for costingS4 HANACRCOFORML1Formula key for costingMandatory Value direct from current SAP system - Formula used to calculate cost of a work centers activity
52PF2CRCOLSTAR2Activity TypeS4 HANACRCOLSTAR2Activity TypeMandatory Value Direct from the current SAP system measured in units of time or Quantity
53PF2CRCOLEINH2Activity UnitS4 HANACRCOLEINH2Activity UnitValue Direct from the current SAP system 
54PF2CRCOFORML2Formula key for costingS4 HANACRCOFORML2Formula key for costingMandatory Value direct from current SAP system - Formula used to calculate cost of a work centers activity
55PF2CRCOLSTAR3Activity TypeS4 HANACRCOLSTAR3Activity TypeMandatory Value Direct from the current SAP system measured in units of time or Quantity
56PF2CRCOLEINH3Activity UnitS4 HANACRCOLEINH3Activity UnitValue Direct from the current SAP system 
57PF2CRCOFORML3Formula key for costingS4 HANACRCOFORML3Formula key for costingMandatory Value direct from current SAP system - Formula used to calculate cost of a work centers activity
58PF2CRCOLSTAR4Activity TypeS4 HANACRCOLSTAR4Activity TypeMandatory Value Direct from the current SAP system measured in units of time or Quantity
59PF2CRCOLEINH4Activity UnitS4 HANACRCOLEINH4Activity UnitValue Direct from the current SAP system 
60PF2CRCOFORML4Formula key for costingS4 HANACRCOFORML4Formula key for costingMandatory Value direct from current SAP system - Formula used to calculate cost of a work centers activity
61PF2CRCOLSTAR5Activity TypeS4 HANACRCOLSTAR5Activity TypeMandatory Value Direct from the current SAP system measured in units of time or Quantity
62PF2CRCOLEINH5Activity UnitS4 HANACRCOLEINH5Activity UnitValue Direct from the current SAP system 
63PF2CRCOFORML5Formula key for costingS4 HANACRCOFORML5Formula key for costingMandatory Value direct from current SAP system - Formula used to calculate cost of a work centers activity
64PF2CRCOLSTAR6Activity TypeS4 HANACRCOLSTAR6Activity TypeMandatory Value Direct from the current SAP system measured in units of time or Quantity
65PF2CRCOLEINH6Activity UnitS4 HANACRCOLEINH6Activity UnitValue Direct from the current SAP system 
66PF2CRCOFORML6Formula key for costingS4 HANACRCOFORML6Formula key for costingMandatory Value direct from current SAP system - Formula used to calculate cost of a work centers activity


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




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
3

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

SyWay Data Team
4Proceed with full load if steps 2 and 3 are validatedSyWay Data Team
5Validate few records loaded by accessing standard transactions from S/4HNA eg. CRC3SyWay Data Team
6Generate post load report if step 5 is validatedSyWay Data Team


Load Phase and Dependencies

Configuration

Item #Configuration Item






Conversion Objects

Object #Preceding Object Conversion Approach

list the exact title of the conversion object of only the immediate predecessor – this will then confirm the DDD (Data Dependency Diagram)




Error Handling

Error TypeError DescriptionAction Taken
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
2Mapping conversion errors with new data

Ensure the collection file includes any new data values and mapping is correct





Post-Load Validation

Project Team

Completeness

TaskAction
Verify CountSyWay S2P Data Team to verify the record count created in target S/4 HANA by accessing post load reports in dspMigrate or standard reports from S/4 HANA.





Accuracy

TaskAction
Verify 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 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.
  • is in scope based on data design and any exception requested by business.


See also

Change log

Version Published Changed By Comment
CURRENT (v. 25) 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