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

Compare with Current View Page History

« Previous Version 9 Next »

Status

  Update in progress

Owner
Stakeholders

Purpose

The purpose of this document is to define the conversion approach to create1039 - Master Recipe in S/4 HANA.

Master recipes are assigned to a plant and are part of a plant-independent recipe group.

In the recipe header, master recipes used for production are linked to the materials to be produced. The production versions of the materials also link them to the alternative BOM required for production.

Master recipes are used as the basis for process orders. The business object master recipe is the description of an enterprise-specific process in process industries, that does not relate to a specific order. The master recipe is used for the manufacture of products. In all Manufacturing plants that are using SAP PP-PI ( Production Planning for process Industries), This is the most important Master Data, This Master Data includes BOM, Resources, Formulas, Costing Data and others, relevant for creating Process Orders.



Conversion Scope

The scope of this document covers the approach for converting active1039- Master Recipe from Legacy Source Systems into S/4HANA following the1039 Master Data Design Standard. 


The data from legacy system includes:

  1. Active Master Recipes, used in Process Orders for the last 3 years
  2. Active Master Recipes valid for active materials
  3. Active Master Recipes valid for Material / Plant Combination (according with the latest Plant Mapping)

The data from legacy system excludes:

  1. Active Master Recipes NOT used for the last three years
  2. Master recipes with deletion flag
  3. Master Recipes for materials flagged for deletion
  4. Master Recipes for materials without active status
  5. Master recipes for Material / Plant combination that are Out of Scope


List of source systems and approximate number of records
SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2Master Recipes will be extracted from PF215,000S/4 HANA10,000
WP2Master Recipes will be extracted from WP215,000S/4 HANA12,000
DCTWe will use a DCT for data conversion from Specific Routing to Master Recipe, for plants are still using Discrete Manufacturing3000S/4 HANA1500

Additional Information

Multi-language Requirement

Document Management

N/A

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
PLKOPLNTYPLNTYKey which classifies task lists according to their functionality.
In Syensqo production context this value is defaulted to "2"
CHAR1R : For PP PI the master recipe is a task list with type "2"
In case of Rate routing value from As Is = "R" will be mapped to value "2"
PLMZRGEKZRGEKZBackflushCHAR1



PLKOPLNTYPLNTYKey which classifies task lists according to their functionality. In Syensqo production context this value is defaulted to "2"CHAR1R : For PP PI the master recipe is a task list with type "2"
In case of Rate routing value from As Is = "R" will be mapped to value "2"
PLKOPLNNRPLNNRKey that uniquely identifies a recipe group.CHAR8S
PLKOPLNALPLNALKey that identifies a master recipe within a recipe group.CHAR2S
PLKODATUVDATUVDate from which the recipe object is valid.DATS8R : By default the system date but the user can enter a valid from date
PLKOVALID_TODATUVEnd of the validity period of the recipe object.DATS8R
PLKOAENNRAENNRKey for the change master record or engineering change order that the chosen change status of the recipe object was created with.CHAR12NU
PLKOVERWEPLN_VERWEKey indicating what the recipe is used for, such as production or plant maintenance. for Syensqo production scope the value used will be "1"CHAR3R : Syensqo production scope the value used will be "1"
PLKOWERKSWERKS_DPlant of the material to be produced.CHAR4R
PLKOSTATUPLNSTStatus key to indicate the processing status of a recipe. For example, indicate whether the recipe is still in the creation phase or has already been released.CHAR3R
PLKOPLNMEPLNMEUnit of measure of the charge quantityUNIT3R
PLKOLOSVNLOSGRVONLower limit of the charge quantity range for which the recipe is valid.QUAN13C : If a value is entered, then the recipe can be used only for process orders with quantity superior to the minimum lot size
PLKOLOSBSLOSGRBISUpper limit of the charge quantity range for which the recipe is valid.QUAN13C : If a value is entered, then the recipe can be used only for process orders with quantity inferior to the maximum lot size
PLKOVAGRPVAGRPKey of the planner group responsible for maintaining the recipe.CHAR3C : Business rule. If reporting is needed by planner group for the master recipe this field need to be populated. Empty is a valid value
PLKOKTEXTPLANTEXTDescribes the recipeCHAR40R
PLKOTXTSPSPRASLanguage keyLANG1S
PLKOLOEKZLKENZIndicator set if the recipe to be completely deleted at the next reorganization run, with all its change states.CHAR1S
PLKOPROFIDNETZPROFID_STDA profile is a collection of default values and settings for maintenance of routings or master recipes or standard networks.CHAR7R
PLKOBMSCHBMSCHQuantity of the material to be produced to which the standard values of the operation refer.QUAN13R
PLKOQKZRASTERQKZRASTERIdentifier for Inspection Point Field Combination, Inspection points are used as reference objects for recording inspection results below operation level. If a value is entered for the inspection point, this value is copied to the inspection lots.CHAR1NU
PLKOPPKZTLZUQPPKZTLZUPartial Lot Assignment in an Inspection During Production
he entry in this list field  to set the detail levels for the assignment of manufactured quantities.

In the first and most detailed level ("Partial lots not defined"), the manufactured partial quantities are assigned to inspection points for which inspection results are also recorded.
In the second detail level ("Partial lot for each inspection point"), the partial quantities, to which the inspection points are assigned, are combined into partial lots.
In the third detail level ("Partial lot and batch for each inspection point"), partial lots are combined into batches.
CHAR1NU
PLKOQPRZIEHVERQPRZIEHVERA master data object in QM sample management that contains instructions for a sample drawing.CHAR8NU
PLKOQDYNHEADQDYNHEADIdentifies the level at which the decision for inspection stages is made and the quality level maintained.CHAR1NU
PLKOQDYNREGELQDYNREGELContains the definition of inspection stages and the conditions that lead to changes in inspection stages.CHAR3NU
PLKOCHRULER_CHRULEKey that specifies which change procedure must be used for recipe or inspection plan editing.CHAR1C : If change numbers are not activated this value is defaulted as "Empty"
MAPLPLNNRPLNNRKey that uniquely identifies a recipe group.CHAR8S
MAPLPLNALPLNALKey that identifies a master recipe within a recipe group.CHAR2S
MAPLMATNRMATNRMaterial Number for witch the receipe is createdCHAR18R
MAPLWERKSWERKS_DPlantCHAR4R
PLPODATUVDATUVValid from dateDATS8R
PLPODATUBDATUVValid to dateDATS8R
PLPOVORNRVORNRDetermines in which order the operations of a sequence are carried out.CHAR4S
PLPOPHFLGPHFLGndicator for phases as opposed to operations.CHAR1S
PLPOPVZNRPVZNRKey of the operation to which the phase is subordinated. This field is used for phases but not for operations.CHAR1S
PLPOARBIDOBJEKTIDRessource used to perform the activityNUMC8R : PLPO-ARBID = CRHD-OBJID that represent the ressource CRHD-ARBPL
PLPOSTEUSSTEUSDetermines which business transactions should be executed for the object that belongs to the task list or order (for example scheduling or costing).CHAR4R : Value mapping to be completed during remaining detailed design phase
PLPOLTXA1LTXA1Operation Short TextCHAR40R
PLPOSPRASSPRASLanguage KeyCHAR2S
PLPOBMSCHBMSCHQuantity of the material to be produced to which the standard values of the operation refer.QUAN13R
PLPOMEINHVORMEUnit of measure used in the operation for the material to be produced.UNIT3R
PLPOWERKSWERKS_DPlantCHAR4R
PLPOUMRENCP_UMRENDenominator for Converting Routing and Operation UoMDEC5C : If Recipe unit of measure (PLKO-PLNME) is different from phase unit of measure (PLPO-MEINH) this field need to be populated
PLPOUMREZCP_UMREZNumerator for Converting Routing and Operation UoMDEC5C : If Recipe unit of measure (PLKO-PLNME) is different from phase unit of measure (PLPO-MEINH) this field need to be populated
PLPOZMERHDZMERHBreak TimeQUAN9R (If empty = 0)
PLPOZEIERDZEIERUnit for a Break TimeUNIT3R
PLPOLAR01LSTARActivity TypeCHAR6C : If an activity type is used for the ressource used in an operation this field is requiered 
PLPOVGE01VGWRTEHUnit of Measurement of Standard ValueUNIT3C : If an activity type is used for the ressource used in an operation this field is requiered 
PLPOVGW01VGWRTStandard ValueQUAN9C : If an activity type is used for the ressource used in an operation this field is requiered 
PLPOLAR02LSTARActivity TypeCHAR6C : If an activity type is used for the ressource used in an operation this field is requiered 
PLPOVGE02VGWRTEHUnit of Measurement of Standard ValueUNIT3C : If an activity type is used for the ressource used in an operation this field is requiered 
PLPOVGW02VGWRTStandard ValueQUAN9C : If an activity type is used for the ressource used in an operation this field is requiered 
PLPOLAR03LSTARActivity TypeCHAR6C : If an activity type is used for the ressource used in an operation this field is requiered 
PLPOVGE03VGWRTEHUnit of Measurement of Standard ValueUNIT3C : If an activity type is used for the ressource used in an operation this field is requiered 
PLPOVGW03VGWRTStandard ValueQUAN9C : If an activity type is used for the ressource used in an operation this field is requiered 
PLPOLAR04LSTARActivity TypeCHAR6C : If an activity type is used for the ressource used in an operation this field is requiered 
PLPOVGE04VGWRTEHUnit of Measurement of Standard ValueUNIT3C : If an activity type is used for the ressource used in an operation this field is requiered 
PLPOVGW04VGWRTStandard ValueQUAN9C : If an activity type is used for the ressource used in an operation this field is requiered 
PLPOLAR05LSTARActivity TypeCHAR6C : If an activity type is used for the ressource used in an operation this field is requiered 
PLPOVGE05VGWRTEHUnit of Measurement of Standard ValueUNIT3C : If an activity type is used for the ressource used in an operation this field is requiered 
PLPOVGW05VGWRTStandard ValueQUAN9C : If an activity type is used for the ressource used in an operation this field is requiered 
PLPOLAR06LSTARActivity TypeCHAR6C : If an activity type is used for the ressource used in an operation this field is requiered 
PLPOVGE06VGWRTEHUnit of Measurement of Standard ValueUNIT3C : If an activity type is used for the ressource used in an operation this field is requiered 
PLPOVGW06VGWRTStandard ValueQUAN9C : If an activity type is used for the ressource used in an operation this field is requiered 
PLPOZERMADZERMAKey which controls how the standard values are calculated (for example, using CAPP or comparison).CHAR5NU
PLPOLOANZLOHNANZNumber of confirmation slips to be printed for an operation or an activityDEC3NU
PLPORFGRPRUEFAGRPClassification which combines setup group keys in groups.CHAR10C : If a value in set up activity type is entered in standard value this field is requiered.
PLPORFSCHRUEFASCHLUKey that specifies who sets up a recipe (for example, machine servicer, setup person or a setup crew). The value from the ressource is the default in the recipe.CHAR10C : If a value in set up activity type is entered in standard value this field is requiered 
PLPOAUFAKAUSCHUFAKScrap factor. DEC5C : If scrap factor is related to an operation and will flow to the process order this field is requiered to be populated
PLPOUEMUSUEMUSKZIndicator which specifies that overlapping is required.
During scheduling the system determines from the minimum send-ahead quantity and the minimum overlap time.
Whether the operations can overlap
An overlap is only permissible, if the time the operations overlap is larger than the  minimum overlap time.
When is the start date of the following operation
If operations overlap, the next operation can start when the minimum send-ahead quantity has been produced. If a move is necessary, this is taken into account with the minimum move time.
The following operation is scheduled so that no interruptions occur.
CHAR1C : If operation overlap is permited and requiered to be taken into account during the detailed scheduling process. this field need to be populated. other wise the field is empty 
PLPOUEKANUEKANKZIndicator which specifies that the operation can be overlapped with the next one if the execution time is to be reduced.CHAR1C : If operation overlap is permited and can be taken into account during the detailed scheduling process to reduce operation time. this field need to be populated. other wise the field is empty 
PLPOZEIMUDZEIMUUnit for the Minimum Overlap TimeUNIT3C if PLPO-UEKAN or PLPO-UEMUS is not empty this field need to be populated
PLPOZMINUDZMINUShortest time the operation must overlap with the next operation if overlapping is to be economical.
The minimum overlap time is taken into account during lead time scheduling.
QUAN9C : If overlap is permited or requiered only after a given time. this filed need to be populated
PLPOSPMUSSPLITTUNGSplitting RequiredCHAR1C : If operation splititng is riquired by the business a value need to be entered. Empty is a valid value
PLPOSPLIMSPLITTANZMaximum Number of SplitsDEC3C : if a value is entered in Splitting this field needs to be populated
PLPOZMINBDZMINBMinimum Processing TimeQUAN9C : if a value is entered in Splitting this field needs to be populated
PLPOZLMAXDZLMAXMaximum wait timeQUAN9C : if not defined by business and there is more than one operation in the recipe this field take the value 1 sec
PLPOZLPRODZLPROMinimum Wait TimeQUAN9NU
PLPOZWNORDZWNORStandard Queue TimeQUAN9NU
PLPOZWMINDZWMINMinimum Queue TimeQUAN9NU
PLPOZTNORDZTNORStandard Move TimeQUAN9NU
PLPOZTMINDZTMINMinimum Move TimeQUAN9NU
PLPOABLIPKZABLIPKZTeardown and Wait Occur in ParallelCHAR1NU
PLPORSTRARSTRAReduction Strategy per OperationCHAR2C : Business rule If a reduction strategy is used by business this field need to be populated. Empty is a valid value
PLPOLIFNRLIFNRSupplier numberCHAR10C : If the operation is performed at an external partner the subcontractor number need to be entered in this field
PLPOPLIFZPLIFZPlanned Delivery Time in DaysDEC3C : If the operation is performed at an external partner the delivery time in days is to be entered in this field to update planning
PLPOPREISIPREINet Price in Purchasing Info RecordCURR11C : If the operation is performed at an external partner the operation price need to be entered in this field
PLPOPEINHEPEINPrice unitDEC5C : If the operation is performed at an external partner the operation price unit need to be entered in this field
PLPOSAKTOKSTARCost ElementCHAR10C : If subcontracting flag in the ressource is entred this field is requiered
PLPOWAERSWAERSCurrency KeyCUKY5C : If a subcontracting price is entered the price currency is to be entered in this field
PLPOINFNRINFNRNumber of purchasing info recordCHAR10C : If the operation is subcontracted and a Purchase Info Record exist and to be used for this operation then the PIR number need to be populated in this field
PLPOESOKZESOKZPurchasing info record categoryCHAR1C : In case of subcontracting (PLPO-FRDLB) is not empty, value is "3"
Otherwise "Empty"
PLPOEKORGEKORGPurchasing OrganizationCHAR4C : C : If the operation is subcontracting this field need to be populated. Mapping to be provided to link As Is values with To be purch org
PLPOEKGRPVG_EKGRPPurchasing Group for External Processing ActivityCHAR3C : If the operation is subcontracting this field need to be populated. Mapping to be provided to link As Is values with To be purch group
PLPOKZLGFKZLGFIndicator: Lot-Size-Independent External ProcessingCHAR1NU
PLPODAUMIDAUMINMinimum activity durationQUAN5NU
PLPODAUMEDAUMINEUnit for the minimum durationUNIT3NU
PLPODDEHNDAUDEHNIndicator: flexible durationCHAR1C : If the operation duration can be extended this field is marked. empty is valid value
PLPOANFKOANFKORequesting Cost CenterCHAR10NU
PLPOCKSELKZCK_SELKZIndicator for Relevancy to CostingCHAR1C : If the operation is not relevant for costing this field is empty, otherwise the value is "X"
PLPOPHFLGPHFLGIndicator: PhaseCHAR1S
PLPOFRDLBCO_FRDLBIndicator: External Processing Operation with SubcontractingCHAR1C : If an operation is subcontracted this field need to be populated
PLPOBMVRGBMVRGOrder QuantityQUAN13C : If the operation quantity/ Unit of measure is different from the header quantity/ unit of measure a conversion factor needs to be populated in this field
PLPOANZMAANZMSNb Of employeesDEC5C : If the information is relevant to plan the activities or to send to planning system a value needs to be populated as information
PLPODAUNODAUNORNormal durationQUAN5NU
PLPODAUNEDAUNORENormal duration unitUNIT3NU
PLPOARBEITARBEITWork involved in the activityCHAR1NU
PLPOARBEITEARBEITEUnit for workCHAR3NU
PLPOANZKAPANZKAPNumber of capacities requiredCHAR2NU
PLPOBURKSBURKSCompany codeCHAR4NU
PLPOKALIDWFCIDFactory calendarCHAR2S
PLPOAUFKTAFAKTExecution factorDEC3NU
PLPOANZZLANZKAPNumber of individual capacitiesINT13NU
PLPOSLWIDSLWIDKey word ID for user-defined fieldsCHAR7C : If business use user fields to store additional informations this field need to be populated
PLPOUSR00USRCHAR20User field with 20 charactersCHAR20C : If business use user fields to store additional informations this field need to be populated
PLPOUSR01USRCHAR20User field with 20 charactersCHAR20C : If business use user fields to store additional informations this field need to be populated
PLPOUSR02USRCHAR10User Field with 10 CharactersCHAR10C : If business use user fields to store additional informations this field need to be populated
PLPOUSR03USRCHAR10User Field with 10 CharactersCHAR10C : If business use user fields to store additional informations this field need to be populated
PLPOUSR04USRQUAN13User field for quantity (length 10.3)QUAN13C : If business use user fields to store additional informations this field need to be populated
PLPOUSE04USRUNITUser field: Unit for quantity fieldsUNIT3C : If business use user fields to store additional informations this field need to be populated
PLPOUSR05USRQUAN13User field for quantity (length 10.3)QUAN13C : If business use user fields to store additional informations this field need to be populated
PLPOUSE05USRUNITUser field: Unit for quantity fieldsUNIT3C : If business use user fields to store additional informations this field need to be populated
PLPOUSR06USRCURR13User field for quantity (length 10.3)CURR13C : If business use user fields to store additional informations this field need to be populated
PLPOUSE06USRCUKYUser field: Unit for quantity fieldsCUKY5C : If business use user fields to store additional informations this field need to be populated
PLPOUSR07USRCURR13User field for quantity (length 10.3)CURR13C : If business use user fields to store additional informations this field need to be populated
PLPOUSE07USRCUKYUser field: Unit for quantity fieldsCUKY5C : If business use user fields to store additional informations this field need to be populated
PLPOUSR08USRDATEUser field for dateDATS8C : If business use user fields to store additional informations this field need to be populated
PLPOUSR09USRDATEUser field for dateDATS8C : If business use user fields to store additional informations this field need to be populated
PLPOUSR10USRFLAGUser-defined field: Indicator for reportsCHAR1C : If business use user fields to store additional informations this field need to be populated
PLPOUSR11USRFLAGUser-defined field: Indicator for reportsCHAR1C : If business use user fields to store additional informations this field need to be populated
PLPOERFSICHTQERFSICHTThe recording view is used to specify different characteristic overview screens, which are called up after entering the results recording functionCHAR2C : If result recoring is activated and business requiered special characteristic overview screens this field need to be populated. Empty is a valid value
PLMZPLNTYPLNTYTask List TypeCHAR1R
PLMZPLNNRPLNNRGroupCHAR8S
PLMZZAEHLCIM_COUNTCounterNUMC8S
PLMZZUONRZUONRAllocation numberCHAR3R
PLMZDATUVDATUVValid fromDATS8R
PLMZAENNRAENNRChange NumberCHAR12NU
PLMZLOEKZLKENZDeletion IndicatorCHAR1S
PLMZPLNALPLNALGroup CounterCHAR2R
PLMZPLNFLPLNFLSequenceCHAR3NU
PLMZPLNKNPLNKNTask list nodeNUMC8R
PLMZSTLTYSTLTYBOM categoryCHAR1R
PLMZSTLNRSTNUMBill of MaterialCHAR8R
PLMZSTLALSTLALAlternative BOMCHAR2R
PLMZSTLKNSTLKNNodes of the BOM item assignedCHAR4R
PLMZWERKS_STLWERKS_STLPlantCHAR4R
PLMZIMENGIMENGComponent QuantityNUMC10R
PLMZIMEINKMPMEComponent UoMUNIT3S
PLMZANDATANDATCreated OnDATS8S
PLMZANNAMANNAMCreated byCHAR12S
PLMZAEDATCIM_AEDATChanged onDATS8S
PLMZAENAMAENAMChanged ByCHAR12S
PLMZRGEKZRGEKZBackflushCHAR1S
PLMZPLNTYPLNTYTask List TypeCHAR1R
PLMZPLNNRPLNNRGroupCHAR8S
PLMZZAEHLCIM_COUNTCounterNUMC8S
PLMZZUONRZUONRAllocation numberCHAR3R
PLMZDATUVDATUVValid fromDATS8R
PLMZAENNRAENNRChange NumberCHAR12NU
PLMZLOEKZLKENZDeletion IndicatorCHAR1S
PLMZPLNALPLNALGroup CounterCHAR2R
PLMZPLNFLPLNFLSequenceCHAR3NU
PLMZPLNKNPLNKNTask list nodeNUMC8R
PLMZSTLTYSTLTYBOM categoryCHAR1R
PLMZSTLNRSTNUMBill of MaterialCHAR8R
PLMZSTLALSTLALAlternative BOMCHAR2R
PLMZSTLKNSTLKNNodes of the BOM item assignedCHAR4R
PLMZWERKS_STLWERKS_STLPlantCHAR4R
PLMZIMENGIMENGComponent QuantityNUMC10R
PLMZIMEINKMPMEComponent UoMUNIT3S
PLMZANDATANDATCreated OnDATS8S
PLMZANNAMANNAMCreated byCHAR12S
PLMZAEDATCIM_AEDATChanged onDATS8S
PLMZAENAMAENAMChanged ByCHAR12S
PLMZRGEKZRGEKZBackflushCHAR1S
PLABPLNTYPLNTYTask List TypeCHAR1R
PLABPLNALPLNALGroup counterCHAR2S
PLABPLNNRAOB_PLNNRNumber of the Standard NetworkCHAR8R
PLABPLNRNPLNRNGroup Counter??R
PLABPLNKNPLNKNNumber of the Task List NodeNUMC8R
PLABPLNRNAOB_PLNRNNumber of the Standard NetworkCHAR8R
PLABALNRNPLNALGroup CounterCHAR2R
PLABKNNRNPLNKNNumber of the Task List NodeNUMC8R
PLABAOBARAOBARType of relationshipCHAR2R
PLABMIMAXDAUMIMAXIndicates whether maximum time interval will be consideredCHAR1R
PLABZAEHLCIM_COUNTInternal counterNUMC8S
PLABDATUVCIM_DATEValid-from dateDATS8R
PLABTECHVTECHVTechnical status fromCHAR12NU
PLABAENNRAENNRChange NumberCHAR12NU
PLABZEINHAOBDAUEHUnit for the time interval between relationshipsUNIT3R
PLABDAUERAOBDAUERTime Interval Between RelationshipsQUAN5R
PLABDAUKZAOBDAUKZIndicator for the duration of the relationshipCHAR1R
PLABVORNCVORG_NACHIndicator: maintained after successorCHAR1R
PLABNCVORNACH_VORGIndicates whether data after predecessor is maintainedCHAR1R
PLABLOEKZLOEKZAsset class marked for deletionCHAR1S
PLABKALIDWFCIDFactory CalendarCHAR2S
PLABPRZNTAOB_PRZNT% used to calc. time interval between predecessor/successorNUMC3C : Business rule if time integrval is calculated this field is populated/ Empty is a valid value
PLABPROVGAOB_PROVGKey for defining time intervals in a relationshipCHAR1C : Business rule if time integrval is calculated this field is populated/ Empty is a valid value
PLABWERKSWERKS_DPlantCHAR4R
PLABANDATANDATDate Record Created OnDATS8S
PLABANNAMANNAMUser who created recordCHAR12S
PLABDAUERMAXAOBDAUERMAXMaximum time interval for relationshipQUAN5R
PLABVALID_TO
Valid-to dateDATS8R
PLABLOEKZ_INHERITED
Deletion IndicatorCHAR1S
PLMKPLNTYPLNTYTask List TypeCHAR1R
PLMKPLNNRPLNNRKey for Task List GroupCHAR8S
PLMKPLNKNPLNKNNumber of the Task List NodeNUMC8S
PLMKKZEINSTELLQKZEINSTMKCharacteristic Type : Quantitative or QualitativeCHAR1S
PLMKMERKNRQMERKNRPInspection Characteristic NumberNUMC4R
PLMKZAEHLCIM_COUNTInternal counterNUMC8S
PLMKGUELTIGABDATUVValid-From DateDATS8R
PLMKSERNVTECHVTechnical status fromCHAR12S
PLMKLOEKZLKENZDeletion IndicatorCHAR1S
PLMKPARKZPARKZIndicator: inactive changesCHAR1R
PLMKAENDERGNRAENNRChange NumberCHAR12NU
PLMKERSTELLERANNAMUser who created recordCHAR12S
PLMKERSTELLDATANDATSystem Date on Which Data Record Was CreatedDATS8S
PLMKAENDERERQAENDERERName of User Who Last Changed Data RecordCHAR12S
PLMKAENDERDATQDATUMAENDSystem Date on Which Data Record Was ChangedDATS8S
PLMKSTEUERKZQMKCONTROLCntrl Indicator String for Insp. Char./Master Insp. Char.CHAR30S
PLMKQMTB_WERKSQ_METH_PLANTPlant for Inspection MethodCHAR4S
PLMKPMETHODEQPMETHODEAn inspection method describes how to inspect an inspection characteristic.CHAR8S
PLMKPMTVERSIONQVERSNRPMVersion Number of Inspection MethodCHAR6S
PLMKQPMK_REFQKZ_REFReference to Master Insp. Characteristic in Task ListCHAR1R
PLMKQPMK_ZAEHLQZAEHLERPlant for Master Inspection CharacteristicCHAR4R
PLMKVERWMERKMQMERKNRAn inspection characteristic describes what is to be inspectedCHAR8R
PLMKMKVERSIONQVERSNRMKVersion Number of Master Inspection CharacteristicCHAR6S
PLMKMKVERSDATQVERSDATKey Date for Version SelectionDATS8S
PLMKMERKGEWQMERKGEWClassification of inspection characteristics according to their weighting (importance).CHAR2S
PLMKPROBENRQPROBEPLPartial Sample No. for Inspection Charac. in Task ListNUMC3NU
PLMKPRUEFQUALIQPRQUALIFQualification that an inspector must have and, if necessary, validate in order to be able to conduct an inspection.CHAR5S
PLMKTOLERANZSLQTOLERANZTolerance KeyCHAR4S
PLMKKURZTEXTQTXT_CHAShort Text for Inspection CharacteristicCHAR40S
PLMKLTEXTKZQLTEXTKZInspection Characteristic Long Text ExistsCHAR1S
PLMKLTEXTSPRSPRASLanguage KeyLANG1S
PLMKLTEXTEKZQKZPRZIEHSample-Drawing Text ExistsCHAR1S
PLMKLTXTENTSPRSPRASLanguage KeyLANG1S
PLMKSTELLENQSTELLENdefine the accuracy (number of decimal places), to which the value is calculated.INT13S
PLMKMASSEINHSWQMASSEHUnit of Measurement in Which Quantitative Data Is StoredUNIT3S
PLMKSOLLWERTQSOLLWERTEValue of a quantitative characteristic, from which the actual value of the inspection characteristic should deviate as little as possible.FLTP16R
PLMKSOLLWNIQNINITIALValue Not Initial If SetCHAR1S
PLMKTOLERANZOBQTOLOBUpper limit value for the actual value of an inspection characteristic.FLTP16C : This field represent the upper limit of the characteristic value for the test results. business need to define the value
PLMKTOLOBNIQNINITIALValue Not Initial If SetCHAR1S
PLMKTOLERANZUNQTOLUNLower limiting value for the actual value of an inspection characteristic.FLTP16C : This field represent the lower limit of the characteristic value for the test results. business need to define the value
PLMKTOLUNNIQNINITIALValue Not Initial If SetCHAR1S
PLMKKLASANZAHLQKLASSZAHLNumber of Value Classes for Inspection ResultsINT13NU
PLMKKLASBREITEQKLASSBRClass WidthFLTP16NU
PLMKKLASBRNIQNINITIALValue Not Initial If SetCHAR1NU
PLMKKLASMITTEQKLASSMITClass MidpointFLTP16NU
PLMKKLASMINIQNINITIALValue Not Initial If SetCHAR1NU
PLMKGRENZEOB1QGRENZOB1Upper limit value of a user-specified limit, for example, a warning limit.
The system does not use the contents of this field. This field provides a place to store a user-specified limit value that is relevant
FLTP16NU
PLMKGRENZOB1NIQNINITIALValue Not Initial If SetCHAR1NU
PLMKGRENZEUN1QGRENZUN1Lower limiting value of a user-specified limit, for example, a warning limit
The system does not use the contents of this field. This field provides a place to store a user-specified limit value that is relevant for a quantitative characteristic.
FLTP16NU
PLMKGRENZUN1NIQNINITIALValue Not Initial If SetCHAR1NU
PLMKGRENZEOB2QGRENZOB2Upper limit value of a user-specified limit, for example, a warning limit.
The system does not use the contents of this field. This field provides a place to store a user-specified limit value that is relevant
FLTP16NU
PLMKGRENZOB2NIQNINITIALValue Not Initial If SetCHAR1NU
PLMKGRENZEUN2QGRENZUN2Lower limiting value of a user-specified limit, for example, a warning limit
The system does not use the contents of this field. This field provides a place to store a user-specified limit value that is relevant for a quantitative characteristic.
FLTP16NU
PLMKGRENZUN2NIQNINITIALValue Not Initial If SetCHAR1NU
PLMKPLAUSIOBENQPLAUSIOBMaximum plausible value of a plausibility limit.It protects against the recording and processing of invalid or improbable valuesFLTP16C : if an additional control is needed to ensure that the users don't enter values that not make sens. this field need to be populated
PLMKPLAUSIOBNIQNINITIALValue Not Initial If SetCHAR1S
PLMKPLAUSIUNTEQPLAUSIUNMinimum plausible value of a plausibility limit.This field is used only for results recording of quantitative characteristics. It protects against the recording and processing of invalid or improbable values.FLTP16C : if an additional control is needed to ensure that the users don't enter values that not make sens. this field need to be populated
PLMKPLAUSIUNNIQNINITIALValue Not Initial If SetCHAR1S
PLMKTOLERWEIOBQTOLWOBAmount by which the specification limit is temporarily increased or decreased.FLTP16NU
PLMKTOLWOBNIQNINITIALValue Not Initial If SetCHAR1S
PLMKTOLERWEIUNQTOLWUNAmount by which the specification limit is temporarily increased or decreased.FLTP16NU
PLMKTOLWUNNIQNINITIALValue Not Initial If SetCHAR1S
PLMKTOLERWABQTOLWABDate from Which the Tolerance Change Is ValidDATS8C : If PLMK-TOLERWEIOB or PLMK-TOLERWEIUN is not empty this field need to be populated;
PLMKTOLERWBISQTOLWBISDate Until Which the Tolerance Change Is ValidDATS8C : If PLMK-TOLERWEIOB or PLMK-TOLERWEIUN is not empty this field need to be populated;
PLMKSTICHPRVERQSTICHVERFSampling Procedure in Inspection CharacteristicCHAR8R
PLMKFAKPLANMEQUMRENFactor for Converting MatUnitOfMeasure to SampUnitOfMeasureFLTP16S
PLMKFAKPROBMEQUMRENPMEFactor for Converting SampUnitOfMeasure to MatUnitOfMeasureFLTP16S
PLMKPROBEMGEHQPROBMESample Unit of MeasureUNIT3S
PLMKPRUEFEINHQPROBEFAKSample Quantity Factor for Sample(Mult. Sample Unit of Msr.)DEC5NU
PLMKDYNKRITQDYNSTRINGString for Dynamic Modification Criteria (Database Relevant)CHAR10NU
PLMKFORMELSLQFORMELSLCheck and Calculate Formula in QMCHAR1NU
PLMKFORMEL1QFORMELFormula FieldCHAR60NU
PLMKFORMEL2QFORMELFormula FieldCHAR60NU
PLMKCODEGR9UQCODEGRPUCode from a code group in the defect catalog (catalog type 9) that has been assigned to a quantitative characteristic with a lower specification limit.CHAR8C : If a set of values is defined for the lower value and the user need to be forced with those values an entry need to be populated
PLMKCODE9UQCODEUCode from a code group in the defect catalog (catalog type 9) that has been assigned to a quantitative characteristic with a lower specification limit.CHAR4C : If a set of values is defined for the lower value and the user need to be forced with those values an entry need to be populated
PLMKCODEVR9UQVERSNRVersion NumberCHAR6S
PLMKCODEGR9OQCODEGRPOCode group from the defect catalog (catalog type 9) that has been assigned to a quantitative characteristic with an upper specification limit.CHAR8NUC : If a set of values is defined for the upper value and the user need to be forced with those values an entry need to be populated
PLMKCODE9OQCODEOCode group from the defect catalog (catalog type 9) that has been assigned to a quantitative characteristic with an upper specification limit.CHAR4NUC : If a set of values is defined for the upper value and the user need to be forced with those values an entry need to be populated
PLMKCODEVR9OQVERSNRVersion NumberCHAR6S
PLMKKATAB1QKTTABCatalog Entry Is a Selected SetCHAR1C : Depending on the entries in the defect code group
PLMKKATALGART1QKATAUSWMain category by which code groups and codes are classified according to their contents (e.g. characteristic attributes, defect types, usage decisions).CHAR1C : Depending on the entries in the defect code group
PLMKAUSWMENGE1QCGRAUSWAssigned Code Group or Selected SetCHAR8S
PLMKAUSWMGWRK1QWERKAUSWPlant of the Assigned Selected SetCHAR4S
PLMKAUSWVERS1QVERSNRVersion NumberCHAR6S
PLMKAUSWDAT1QVERSDATKey Date for Version SelectionDATS8S
PLMKKATAB2QKTTABCatalog Entry Is a Selected SetCHAR1C : Depending on the entries in the defect code group
PLMKKATALGART2QKATAUSWCatalog Type of Assigned Code Group or Selected SetCHAR1C : Depending on the entries in the defect code group
PLMKAUSWMENGE2QCGRAUSWAssigned Code Group or Selected SetCHAR8S
PLMKAUSWMGWRK2QWERKAUSWPlant of the Assigned Selected SetCHAR4S
PLMKAUSWVERS2QVERSNRVersion NumberCHAR6S
PLMKAUSWDAT2QVERSDATKey Date for Version SelectionDATS8S
PLMKKATAB3QKTTABCatalog Entry Is a Selected SetCHAR1C : Depending on the entries in the defect code group
PLMKKATALGART3QKATAUSWCatalog Type of Assigned Code Group or Selected SetCHAR1C : Depending on the entries in the defect code group
PLMKAUSWMENGE3QCGRAUSWAssigned Code Group or Selected SetCHAR8S
PLMKAUSWMGWRK3QWERKAUSWPlant of the Assigned Selected SetCHAR4S
PLMKAUSWVERS3QVERSNRVersion NumberCHAR6S
PLMKAUSWDAT3QVERSDATKey Date for Version SelectionDATS8S
PLMKKATAB4QKTTABCatalog Entry Is a Selected SetCHAR1C : Depending on the entries in the defect code group
PLMKKATALGART4QKATAUSWCatalog Type of Assigned Code Group or Selected SetCHAR1C : Depending on the entries in the defect code group
PLMKAUSWMENGE4QCGRAUSWAssigned Code Group or Selected SetCHAR8S
PLMKAUSWMGWRK4QWERKAUSWPlant of the Assigned Selected SetCHAR4S
PLMKAUSWVERS4QVERSNRVersion NumberCHAR6S
PLMKAUSWDAT4QVERSDATKey Date for Version SelectionDATS8S
PLMKKATAB5QKTTABCatalog Entry Is a Selected SetCHAR1C : Depending on the entries in the defect code group
PLMKKATALGART5QKATAUSWCatalog Type of Assigned Code Group or Selected SetCHAR1C : Depending on the entries in the defect code group
PLMKAUSWMENGE5QCGRAUSWAssigned Code Group or Selected SetCHAR8S
PLMKAUSWMGWRK5QWERKAUSWPlant of the Assigned Selected SetCHAR4S
PLMKAUSWVERS5QVERSNRVersion NumberCHAR6S
PLMKAUSWDAT5QVERSDATKey Date for Version SelectionDATS8S
PLMKDUMMY10QTXT10This field is used to store information only. The system does not use the contents of this field. Its only purpose is to provide a place to store information that is relevant to an objectCHAR10C : If text information is requiered this field can be populated
PLMKDUMMY20QTXT20This field is used to store information only. The system does not use the contents of this field. Its only purpose is to provide a place to store information that is relevant to an objectCHAR20C : If text information is requiered this field can be populated
PLMKDUMMY40QTXT40This field is used to store information only. The system does not use the contents of this field. Its only purpose is to provide a place to store information that is relevant to an objectCHAR40C : If text information is requiered this field can be populated
PLMKCHARACT_ID1QCHARACT_ID1Characteristic Description for Quality Data ExchangeCHAR40NU
PLMKQERGDATHQERGDATHPLPlanned Results Data OriginCHAR2NU
PLMKEEANTVERFQEANTVERFFraction CalculationCHAR2NU
PLMKQDYNREGELQDYNREGELDynamic Modification RuleCHAR3NU
PLMKDYNMERKREFQMERKDYNCharacteristic (in Plan) whose Q-Level Will Be CopiedNUMC4NU
PLMKPZLFHQPZLFHAssigned Test EquipmentNUMC8NU
PLMKCODEGRQUALQCODEGRPQLDefect Code Group for General RejectionCHAR8NU
PLMKCODEQUALQCODEQLDefect Code for Rejection: GeneralCHAR4NU
PLMKSPCKRITQSPCKRITSPC CriterionCHAR3NU
PLMKINPPROCQINPPROCParameters for Input Processing in QM Results RecordingCHAR3NU
PLMKRES_PLANQP_RESPLANResponse PlanCHAR3NU
PLMKCTRMETHQP_CTRMETHControl MethodCHAR3NU
PLMKCHAORIGQP_CHAORIGInspection Characteristic OriginCHAR3NU
PLMKCHAORIG_GUIDQP_CHAORIG_GUIDReference to Characteristic That Was AdoptedRAW16NU
PLMKCHAR_RELEVANCE
Relevance of Characteristic for Inspection

NU
PLMKQP_CHAORIG_IDQMIP_CHAORIG_IDOriginal Identification for CharacteristicCHAR40NU
PLMKCHARGROUP
Characteristic Group

S
PLMKCHARGROUP_CREF
Source Characteristic of Characteristic Group Division

NU
PLMKDIVISIONINT
Internal Division ID

NU
PLMKVALID_TO_ON_DB
Valid-to date

S
PLMKVERSN
Routing Version

NU
PLMKVERSN_SOURCE
Source Routing Version

NU
PLMKVERSN_SOURCE_PLNKN
Task List Version: Number of source list node

NU
PLMKVERSN_SOURCE_ME
Task List Version: Souce Inspection Characteristic Number

NU


Data Cleansing

IDCriticalityError Message/Report DescriptionRuleOutputSource System
1039-1C1Master Recipe has a flag for deletionNO Master recipes with flag for deletion won't be migratedDeletion Flag for master recipePF2/WP2
1039-2C1 Inactive status (source system might have various statuses to identify)Inactive Master recipes won't be migratedMark all inactive Master recipePF2/WP2
1039-3C1Not a part of any active FG BOM . Here data cleansing would be necessary or this could be a case of outsourced/subcontracting  SFG BOM.SFG Active Master Recipe, only for active FGSFG active and part of the FG PDS must be considered to migratePF2/WP2
1039-4C1If all the parent part/s are inactive, then this SFG is not relevant for migration.SFG part of inactive FG not considered for migrationSFG is part of a Inactive FGPF2/WP2
1039-5C1No usage in the past 3 years.Master recipes not used for the last 3 years are not considered to migrateRemove all Master Recipes with no usage for the last three yearsPF2 / WP2
1039-6C1  BOM status is inactiveMaster Recipe to include a inactive BOM not to be consideredBOM is inactivePF2/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 ruleData Team
2Google Sheet report pre-populated with PF2 and WP2 information to be generated based on relevancy criteria. Data Team
3Sinity Extraction in SQL / Excel to check the resultSinity/ Data 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 NameField DescriptionRule












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 Master Recipe 

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









































Transformation Mapping

Mapping Table NameMapping Table Description








Transformation Dependencies

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

1

Ensure DCT tables completeness

SyWay 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 Count 

Data team to verify that the total number of relevant records from the source systems is equal to the total number of records in the Preload and Load Sheets.


Accuracy

TaskAction

Conversion Accuracy

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

1. Mandatory Fields

2. Field and Value Mapping Correctness

3. Null Checks

4. Text Length Checks

Review error reports

Review and correct the errors.  Achieve a zero-error record count as much as possible. Raise defects for data remediated and requiring a correction in the source data.


Business

Completeness

TaskAction

Verify Record Count 

Business team to verify that the total number of relevant records from the source systems is equal to the total number of records in the Preload and Load Sheets.


Accuracy

TaskAction

Conversion Accuracy

Business  to verify that all the data in the load table/file is accurate as per endorsed transformation/mapping rules (and signed-off 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. MDO4SyWay Data Team
5Generate 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










Post-Load Validation

Project Team

Completeness

TaskAction

Verify Count

Data team to verify the record count created in target S/4 HANA by accessing post load reports in Sinity Migrate or standard reports from S/4 HANA.

Verify Logs

Check if there is data that failed to load and perform the necessary actions (e.g. register as post load issue, or attempt to load the record again, etc.).


Accuracy

TaskAction

Conversion Accuracy

Data team to verify that the Measuring Point data in target S/4 HANA were loaded correctly via Sinity Migrate post load reports or standard reports from S/4 HANA. 


Business

Completeness

TaskAction

Verify Count

Download Post Load Reports from Sinity Migrate and verify that the record count loaded in the target S/4 HANA is the same count as of the endorsed load file.


Accuracy

TaskAction

Conversion Accuracy 

Verify that the Measuring Point 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. 9) Apr 29, 2026 08:28 ULLAH-ext, Colin
v. 86 Apr 28, 2026 09:59 ULLAH-ext, Colin
v. 85 Apr 22, 2026 14:34 ULLAH-ext, Colin
v. 84 Apr 22, 2026 06:52 ULLAH-ext, Colin
v. 83 Apr 21, 2026 11:54 ULLAH-ext, Colin
v. 82 Apr 17, 2026 08:27 ULLAH-ext, Colin
v. 81 Apr 14, 2026 13:50 ULLAH-ext, Colin
v. 80 Mar 26, 2026 11:14 ULLAH-ext, Colin
v. 79 Feb 26, 2026 16:18 ULLAH-ext, Colin
v. 78 Feb 24, 2026 11:55 ULLAH-ext, Colin

Go to Page History

Workflow history

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

  • No labels