Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Purpose

This document defines the conversion approach to create Work Orders in S/4 HANA.

A Work Order in SAP PM is a technical and financial document used to plan, execute, and settle maintenance tasks on technical objects. It serves as a detailed set of instructions, outlining tasks, required resources, parts, and schedules, while tracking costs, technical history, and compliance. 

Legacy Plant Maintenance Work Orders use diverse formats across different systems. In line with the SyWay design, EAM Maintenance Work Orders will be standardized.


Conversion Scope

This document covers the approach for converting active Work Orders from legacy source systems into S/4HANA.

A work order in SAP is a formal document that authorizes and tracks maintenance, repair, or production tasks within an organization It contains essential details for effective task management and is used to manage and document various tasks, including maintenance, repairs, and production activities. Key components of a work order include:

  • Work Description: Specific details of the task to be carried out.
  • Equipment Details: Information about the asset or machinery requiring attention.
  • Resources: Personnel, tools, and materials assigned for task completion.
  • Dates: Scheduled start and finish dates for timeline management.
  • Costing: Estimates for labour, materials, and other expenditures linked to budget accounts.
  • Priority & Status: Urgency level and progress tracking (e.g., created, released, completed, closed).
  • Operations: Step-by-step instructions or sub-tasks within the Work Order.


The data from legacy system includes:

  1. All open Work Orders (AUFK-AUFNR) with Active (JEST-INAC <> 'X') System Status (JEST-STAT) = Created (CRTD) or Released (REL).
  2. Work Orders (AUFK-AUFNR) with with Active (JEST-INAC <> 'X') System Status (JEST-STAT) = Technically Completed (TECO)  and relevant open Purchase Order (EKKN-EBELN) as defined in CNV-9045 Open Purchase Orders
  3. Work Orders (AUFK-AUFNR) with Maintenance Plant (AUFK-WERKS) existing in Value Mapping: Plant (Maintenance Plant = Yes).
  4. Work Orders (AUFK-AUFNR) assigned to active legacy Functional Locations (IFLOT-TPLR) ** (Active (JEST-INAC <> 'X') System Status TJ02T-TXT04 <> INAC or DLFL) or Equipment (EQUI-EQUNR) ** (Active (JEST-INAC <> 'X') System Status TJ02T-TXT04 <> INAC or DLFL or ESTO or AVLB)
  5. Work Orders (AUFK-AUFNR) generated from Maintenance Plan (AFIH-WARPL) with Basic Start Date (AFKO-GSTRP) <=  Business Continuity Cutoff Date OTH_Migration_Date Relevant Values A2D (using Object ID "9001" and Field Name = "MHIS-NPLDA")
  6. Work Orders (AUFK-AUFNR) linked to Notifications (AFIH-QMNUM) generated from Maintenance Plan (QMIH-WARPL) with Basic Start Date (AFKO-GSTRP) <=  Business Continuity Cutoff Date OTH_Migration_Date Relevant Values A2D (using Object ID "9001" and Field Name = "MHIS-NPLDA")
  7. A. Work Orders with no open PO, with Basic Start Date (AFKO-GSTRP) later than X Period prior of the Migration / "Go-Live" Date (OTH_Migration_Date Relevant Values A2D (using Object ID "9005" and Field Name = "AFKO-GSTRP") - OTH_Migration_Date Relevant Values A2D (using Object ID "9005" and Field Name = "AFKO-GSTRP_PERIOD"))
    B. Work Orders with no open PO, with Basic End Date (AFKO-GLTRP) later than X Period prior of the Migration / "Go-Live" Date (OTH_Migration_Date Relevant Values A2D (using Object ID "9005" and Field Name = "AFKO-GLTRP") - OTH_Migration_Date Relevant Values A2D (using Object ID "9005" and Field Name = "AFKO-GLTRP_PERIOD"))
    C. Work Orders with open PO, regardless of Basic Start (AFKO-GSTRP)/ Finish Date (AFKO-GLTRP)


Logic for checking PO (Purchase Order) assigned to Work Order

StepTableField(s)Logic
1AUFK / AFIHAUFK-AUFNR = AFIH-AUFNRIdentify PM Work Order
2EKKNEKKN-AUFNR = AUFK-AUFNRFind PO account assignment against the Work Order
3EKPOEKPO-EBELN = EKKN-EBELN and EKPO-EBELP = EKKN-EBELPGet PO item
4EKKOEKKO-EBELN = EKPO-EBELN

Get PO header


Check if the PO (Purchase Order) is Open using
EKPO-LOEKZ = space     "Not deleted"
AND EKPO-ELIKZ = space  "Final delivery / delivery completed not set"
AND EKPO-EREKZ = space  "Final invoice not set"

The data from legacy system excludes:

  1. Work Orders (AUFK-AUFNR) with Active (JEST-INAC <> 'X') System Status (JEST-STAT) = Technically Completed (TECO) that do not meet Inclusion Criteria #2
  2. Work Orders(AUFK-AUFNR) with Active (JEST-INAC <> 'X') System Status (JEST-STAT) = Deletion Flag (DLFL) status
  3. Work Orders (AUFK-AUFNR) with Active (JEST-INAC <> 'X') System Status (JEST-STAT) = Closed (CLSD) status
  4. Work Orders (AUFK-AUFNR) with Active (JEST-INAC <> 'X') System Status (JEST-STAT) = Not Completed/ Do Not Execute (NCMP) status
  5. Standing Work Orders (Value Mapping: Work Order Type, where Target WO Type = 'YA05').
  6. Work Orders (AUFK-AUFNR) which are Sub-orders (AFKO-MAUFNR <> '')
  7. Work Orders (AUFK-AUFNR) with blank Basic End Date (AFKO-GLTRP)
  8. Work Orders (AUFK-AUFNR) with Order type (AUFK-AUART) maintained in Work Order Type Exclusion List (EXC-Work Order Type)
  9. Work Orders (AUFK-AUFNR) with Active (JEST-INAC <> 'X') System Status (JEST-STAT) <> (TECO/ DLFL/ CLSD/ NCMP) and with a User Status maintained in the User Status Exclusion List (EXC-Work Order User Status)

List of Tables to extract for this object is maintained here: Extract Table Register.


List of source systems and approximate number of records
SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2, WP2

Relevant Work Orders will be extracted from PF2 and WP2

70,000

S/4HANA 

70,000

DCT

Work Orders for plants which do not have data existing from PF2 and WP2

TBD

S/4HANA 

TBD

Additional Information

Multi-language Requirement

Work Order does not have multi language support. Work Order text will be migrated using EN logon.

Multi language is supported for Work Order Long Text. Login via a different language will have its Long Text displayed in the logon language if the language key is maintained in the Work Order.

Document Management

Refer to the KDD085 - Document Management in the SyWay Solution

Note: Documents attached to Equipment will be migrated as part of 9104-EAM Attachments.

Legal Requirement

Not Applicable

Special Requirements

Not Applicable


Target Design

The technical design of the target for this conversion approach.

1. Work Order Header

TableFieldData ElementField DescriptionData TypeLengthRequirement
YA01 (Reactive Maintenance)
Requirement
YA02 (Proactive Maintenance)
Requirement
YA03 (Project Order)
AUFKAUFNRAUFNROrder NumberCHAR12MandatoryMandatoryMandatory
AUFKAUARTAUARTOrder TypeCHAR4MandatoryMandatoryMandatory
AUFKKTEXTKTEXTDescriptionCHAR40MandatoryMandatoryMandatory
AFIHPRIOKPRIOKPriorityCHAR80MandatoryMandatoryMandatory
AFKOGSTRPGSTRPBasic Start DateDATS8MandatoryMandatoryMandatory
AFKOGSUZPGSUZPBasic Start TimeTIMS6MandatoryMandatoryMandatory
AFKOGLTRPGLTRPBasic Finish DateDATS8MandatoryMandatoryMandatory
AFKOGLUZPGLUZPBasic Finish TimeTIMS6MandatoryMandatoryMandatory
IFLOTTPLNRTPLNRFunctional LocationCHAR30MandatoryMandatoryMandatory
AFIHEQUNREQUNREquipmentCHAR18ConditionalConditionalConditional
AFIHQMNUMQMNUMAssigned NotificationCHAR12MandatoryMandatoryMandatory
AFIHREVNRREVNRMaintenance Event/ RevisionCHAR8ConditionalConditionalConditional
AFIHILARTILARTMaintenance Activity TypeCHAR3MandatoryMandatoryMandatory
CRHDARBPLARBPLWork CenterCHAR8MandatoryMandatoryMandatory
CRHDWERKSWERKSWork Center PlantCHAR4MandatoryMandatoryMandatory
AFIHIWERKIWERKPlanning PlantCHAR80MandatoryMandatoryMandatory
AFIHINGPRINGPRPlanner GroupCHAR80MandatoryMandatoryMandatory
AUFKWERKSWERKSMaintenance PlantCHAR4MandatoryMandatoryMandatory
ILOABEBERBEBERPlant SectionCHAR3MandatoryMandatoryMandatory
ILOABUKRSBUKRSCompany CodeCHAR4MandatoryMandatoryMandatory
ILOAPROIDPROIDWBS Element (Acc Assignment)CHAR8ConditionalConditionalConditional
ILOAKOSTLKOSTLCost CenterCHAR10MandatoryMandatoryConditional

 

2. Work Order Operation Data

TableFieldData ElementField DescriptionData TypeLengthRequirement
YA01 (Reactive Maintenance)
Requirement
YA02 (Proactive Maintenance)
Requirement
YA03 (Project Order)
AUFKAUFNRAUFNROrder NumberCHAR12MandatoryMandatoryMandatory
AFVCVORNRVORNROperation NumberCHAR4MandatoryMandatoryMandatory
AFVCLTXA1LTXA1Operation DescriptionCHAR40MandatoryMandatoryMandatory
CRHDARBPLARBPLWork CenterCHAR8MandatoryMandatoryMandatory
CRHDWERKSWERKSWork Center PlantCHAR4MandatoryMandatoryMandatory
AFVCPERNRPERNRPerson ResponsibleCHAR8ConditionalConditionalConditional
AFVCSTEUSSTEUSControl KeyCHAR4MandatoryMandatoryMandatory
AFVCSAKTOSAKTOCost ElementCHAR10ConditionalConditionalConditional
AFVCEKORGEKORGPurchasing OrganisationCHAR4ConditionalConditionalConditional
AFVCEKGRPEKGRPPurchasing GroupCHAR3ConditionalConditionalConditional
AFVCMATKLMATKLMaterial GroupCHAR9ConditionalConditionalConditional
AFVCANLZUANLZUSystem ConditionCHAR1ConditionalConditionalConditional
AFVCLARNTLARNTActivity TypeCHAR6ConditionalConditionalConditional
AFVVARBEIARBEIWorkNUMC7MandatoryMandatoryMandatory
AFVVARBEHARBEHWork UnitCHAR3MandatoryMandatoryMandatory
AFVCINDETINDETCalculation KeyCHAR1MandatoryMandatoryMandatory
AFVVDAUNODAUNODurationNUMC5MandatoryMandatoryMandatory
AFVVDAUNEDAUNEDuration UnitCHAR3MandatoryMandatoryMandatory
AFVCANZZLANZZLRequired CapacitiesNUMC3MandatoryMandatoryMandatory
AFVVEINSAEINSAStart ConstraintCHAR1ConditionalConditionalConditional
AFVVNTANFNTANFStart Constraint DateDATS8ConditionalConditionalConditional
AFVVNTANZNTANZStart Constraint TimeTIMS6ConditionalConditionalConditional
AFVVEINSEEINSEFinish ConstraintCHAR1ConditionalConditionalConditional
AFVVNTENDNTENDFinish Constraint DateDATS8ConditionalConditionalConditional
AFVVNTENZNTENZFinish Constraint TimeTIMS6ConditionalConditionalConditional
AFVVMGVRGMGVRGOperation QuantityNUMC13ConditionalConditionalConditional
AFVVMEINHMEINHOperation Quantity UnitCHAR3ConditionalConditionalConditional
AFVCPREISPREISPriceCHAR11ConditionalConditionalConditional
AFVCWAERSWAERSCurrencyCHAR5ConditionalConditionalConditional
AFVCPEINHPEINHPrice UnitNUMC5ConditionalConditionalConditional
AFVCLIFNRLIFNRVendorCHAR10ConditionalConditionalConditional
AFVCWEMPFWEMPFRecipientCHAR12ConditionalConditionalConditional
AFVCBEDNRBEDNRTracking NumberCHAR10ConditionalConditionalConditional
AFVCSORTLSORTLSort TermCHAR10ConditionalConditionalConditional
AFVCINFNRINFNRPurchasing Info RecordCHAR10ConditionalConditionalConditional
AFVCAFNAMAFNAMName of RequisitionerCHAR12ConditionalConditionalConditional
AFVCABLADABLADUnloading PointCHAR25ConditionalConditionalConditional
AFVVPLIFZPLIFZPlanned Delivery Time - DayNUMC3ConditionalConditionalConditional
AFVC

NO_DISP

NO_DISP

Reservation Relevance / Generation of Purchase RequisitionCHAR1ConditionalConditionalConditional


 3. Work Order Operation Components

TableFieldData ElementField DescriptionData TypeLengthRequirement
YA01 (Reactive Maintenance)
Requirement
YA02 (Proactive Maintenance)
Requirement
YA03 (Project Order)
AUFKAUFNRAUFNROrder NumberCHAR12MandatoryMandatoryMandatory
AFVCVORNRVORNROperation NumberCHAR4MandatoryMandatoryMandatory
RESBPOSNRPOSNRItem Number of ReservationNUMC4MandatoryMandatoryMandatory
RESBMATNRMATNRMaterialCHAR18ConditionalConditionalConditional
RESBPOTX1POTX1DescriptionCHAR40ConditionalConditionalConditional
RESBPOSTPPOSTPItem CategoryCHAR1MandatoryMandatoryMandatory
RESBBDMNGBDMNGRequirement QuantityNUMC13MandatoryMandatoryMandatory
RESBMEINSMEINSUnitCHAR3MandatoryMandatoryMandatory
RESBNO_DISPNO_DISPReservation Relevance / Generation of Purchase RequisitionCHAR1ConditionalConditionalConditional
RESBWERKSWERKSPlantCHAR4ConditionalConditionalConditional
RESBBDTERBDTERRequirements DateDATS8ConditionalConditionalConditional
RESBKZMPFKZMPFManual Reqmt Date IndicatorCHAR1ConditionalConditionalConditional
RESBLGORTLGORTStorage LocationCHAR4ConditionalConditionalConditional
RESBCHARGCHARGBatchCHAR10ConditionalConditionalConditional
RESBGPREISGPREISPriceNUMC15,2ConditionalConditionalConditional
RESBPEINHPEINHPrice UnitNUMC5ConditionalConditionalConditional
RESBWAERSWAERSCurrencyCHAR155ConditionalConditionalConditional
RSADDEKORGEKORGPurchasing OrganizationCHAR4ConditionalConditionalConditional
RESBEKGRPEKGRPPurchasing GroupCHAR3ConditionalConditionalConditional
RESBLIFNRLIFNRSupplierCHAR10ConditionalConditionalConditional
RESBINFNRINFNRPurchasing Info RecordCHAR10ConditionalConditionalConditional
RESBMATKLMATKLMaterial GroupCHAR9ConditionalConditionalConditional
RESBSAKNRSAKNRG/L AccountCHAR10ConditionalConditionalConditional
RESBWEMPFWEMPFGoods RecipientCHAR12ConditionalConditionalConditional
RESBABLADABLADUnloading PointCHAR25ConditionalConditionalConditional
RESBSTARTDATESTARTDATEService Performance Start DateDATS8ConditionalConditionalConditional
RESB

PERFORMANCE

PERIODSTARTTIME

PERFORMANCE

PERIODSTARTTIME

Service Performance Start Time (UTC)TIMS6ConditionalConditionalConditional
RESBENDDATEENDDATEService Performance End DateDATS8ConditionalConditionalConditional
RESB

PERFORMANCE

PERIODENDTIME

PERFORMANCE

PERIODENDTIME

Service Performance End Time (UTC)TIMS6ConditionalConditionalConditional
RESB

SERVICE

DURATION

SERVICE

DURATION

Duration of Lean ServiceNUMC5ConditionalConditionalConditional
RESB

SERVICE

DURATIONUNIT

SERVICE

DURATIONUNIT

Duration Unit for a Lean ServiceCHAR3ConditionalConditionalConditional
ESUHCOMMITMENTCOMMITMENTExpected ValueNUMC13ConditionalConditionalConditional
ESUHSUMLIMITSUMLIMITOverall LimitNUMC13ConditionalConditionalConditional


4. Work Order Operation Relationships

TableFieldData ElementField DescriptionData TypeLengthRequirement
YA01 (Reactive Maintenance)
Requirement
YA02 (Proactive Maintenance)
Requirement
YA03 (Project Order)
AUFKAUFNRAUFNRPredecessor Order NumberCHAR12MandatoryMandatoryMandatory
AFVCVORNRVORNRPredecessor OperationCHAR4MandatoryMandatoryMandatory
AUFKAUFNRAUFNRSuccessor Order NumberCHAR12MandatoryMandatoryMandatory
AFVCVORNRVORNRSuccessor OperationCHAR4MandatoryMandatoryMandatory
AFABAOBARAOBARType of RelationshipCHAR2MandatoryMandatoryMandatory
AFABDAUERDAUERTime IntervalNUMC5ConditionalConditionalConditional
AFABZEINHZEINHUnitCHAR3ConditionalConditionalConditional


5. Work Order Object List

TableFieldData ElementField DescriptionData TypeLengthRequirement
YA01 (Reactive Maintenance)
Requirement
YA02 (Proactive Maintenance)
Requirement
YA03 (Project Order)
AUFKAUFNRAUFNROrder NumberCHAR12MandatoryMandatoryMandatory
OBJKOBZAEOBZAECounterCHAR10MandatoryMandatoryMandatory
OBJKSORTFSORTFSortCHAR20ConditionalConditionalConditional
IFLOTTPLNRTPLNRFunctional LocationCHAR30MandatoryMandatoryMandatory
OBJKEQUNREQUNREquipmentCHAR18ConditionalConditionalConditional
OBJKMATNRMATNRMaterialCHAR18ConditionalConditionalConditional
OBJKQMNUMQMNUMNotificationCHAR12MandatoryMandatoryMandatory


 6. Work Order Confirmation

TableFieldData ElementField DescriptionData TypeLengthRequirement
YA01 (Reactive Maintenance)
Requirement
YA02 (Proactive Maintenance)
Requirement
YA03 (Project Order)
AUFKAUFNRAUFNROrder NumberCHAR12MandatoryMandatoryMandatory
AFVCVORNRVORNROperationCHAR4MandatoryMandatoryMandatory
AFRUISMNWISMNWActual WorkNUMC7MandatoryMandatoryMandatory
AFRUAUERUAUERUFinal ConfirmationCHAR1ConditionalConditionalConditional
AFRUOFMNWOFMNWRemaining workNUMC7MandatoryMandatoryMandatory
AFRUISDDISDDWork Start DateDATS8MandatoryMandatoryMandatory
AFRUISDZISDZWork Start TimeTIMS6MandatoryMandatoryMandatory
AFRUIEDDIEDDWork Finish DateDATS8ConditionalConditionalConditional
AFRUIEDZIEDZWork Finish TimeTIMS6ConditionalConditionalConditional


 7. Work Order Operation Capacity Requirement

TableFieldData ElementField DescriptionData TypeLengthRequirement
YA01 (Reactive Maintenance)
Requirement
YA02 (Proactive Maintenance)
Requirement
YA03 (Project Order)
AUFKAUFNRAUFNROrder NumberCHAR12MandatoryMandatoryMandatory
AFVCVORNRVORNROperation NumberCHAR4MandatoryMandatoryMandatory
KBEDARBIDARBIDWork Centre IDCHAR8MandatoryMandatoryMandatory
KBEDSPLITSPLITSplit NumberCHAR3MandatoryMandatoryMandatory
KBEDPERNRPERNRPersonnel NumberCHAR8MandatoryMandatoryMandatory
KBEZARBEIARBEIWorkNUMC7MandatoryMandatoryMandatory
KBEZARBEHARBEHUnit of WorkCHAR3MandatoryMandatoryMandatory
KBEZDAUNODAUNONormal DurationNUMC5MandatoryMandatoryMandatory
KBEZDAUNEDAUNENormal duration unitCHAR3MandatoryMandatoryMandatory

  

8. Work Order Long Text Header

TableFieldData ElementField DescriptionData TypeLengthRequirement
YA01 (Reactive Maintenance)
Requirement
YA02 (Proactive Maintenance)
Requirement
YA03 (Project Order)
STXHTDOBJECTTDOBJECTTexts: application objectCHAR10MandatoryMandatoryMandatory
STXHTDNAMETDOBNAMENameCHAR70MandatoryMandatoryMandatory
STXH

TDID

TDID

Text IDCHAR4MandatoryMandatoryMandatory
STXHTDSPRASSPRASLanguage KeyLANG1MandatoryMandatoryMandatory


 9. Work Order Long Text Line

TableFieldData ElementField DescriptionData TypeLengthRequirement
YA01 (Reactive Maintenance)
Requirement
YA02 (Proactive Maintenance)
Requirement
YA03 (Project Order)
STXHTDOBJECTTDOBJECTTexts: application objectCHAR10MandatoryMandatoryMandatory
STXLTDNAMETDOBNAMENameCHAR70MandatoryMandatoryMandatory
STXL

TDID

TDID

Text IDCHAR4MandatoryMandatoryMandatory
STXLTDSPRASSPRASLanguage KeyLANG1MandatoryMandatoryMandatory
STXLTDFORMATTDFORMAT

Tag column

CHAR1

Mandatory

MandatoryMandatory
STXLROWCOUNTROWCOUNT

Row number

NUMC10MandatoryMandatoryMandatory
STXLTXLINETDLINE

Text Line

CHAR72MandatoryMandatoryMandatory


10. Work Order Operation Long Text Header

TableFieldData ElementField DescriptionData TypeLengthRequirement
YA01 (Reactive Maintenance)
Requirement
YA02 (Proactive Maintenance)
Requirement
YA03 (Project Order)
STXHTDOBJECTTDOBJECTTexts: application objectCHAR10MandatoryMandatoryMandatory
STXHTDNAMETDOBNAMENameCHAR70MandatoryMandatoryMandatory
STXH

TDID

TDID

Text IDCHAR4MandatoryMandatoryMandatory
STXHTDSPRASSPRASLanguage KeyLANG1MandatoryMandatoryMandatory


11. Work Order Operation Long Text Line

TableFieldData ElementField DescriptionData TypeLengthRequirement
YA01 (Reactive Maintenance)
Requirement
YA02 (Proactive Maintenance)
Requirement
YA03 (Project Order)
STXHTDOBJECTTDOBJECTTexts: application objectCHAR10MandatoryMandatoryMandatory
STXLTDNAMETDOBNAMENameCHAR70MandatoryMandatoryMandatory
STXL

TDID

TDID

Text IDCHAR4MandatoryMandatoryMandatory
STXLTDSPRASSPRASLanguage KeyLANG1MandatoryMandatoryMandatory
STXLTDFORMATTDFORMAT

Tag column

CHAR1

Mandatory

MandatoryMandatory
STXLROWCOUNTROWCOUNT

Row number

NUMC10MandatoryMandatoryMandatory
STXLTXLINETDLINE

Text Line

CHAR72MandatoryMandatoryMandatory



Data Cleansing

IDCriticalityError Message/Report DescriptionRuleOutputSource System
9005-001C1Open Work Order older than 1 month (based on Creation Date)

Work Order (AFKO-AUFNR) based on the relevancy criteria and Creation date (AUFK-ERDAT) <= (Current Date - 30)

Note: Business to perform either of the below
a) Set Work Order Status to Technically Completed (TECO); or
b) Change Basic Start/ End date to a future date if still needed.

Order No, Order Type, Plant, Description, Creation DatePF2, WP2
9005-002C1Open Priority Work Orders older than 2 weeks (based on Creation Date)

Work Order (AFKO-AUFNR) based on the relevancy criteria and Creation date (AUFK-ERDAT) <= (Current Date - 14) and Priority as list in the inclusion list (INC-Work Order Priority)

Note: Business to Set Work Order Status to Technically Completed (TECO).

Order No, Order Type, Plant, Description, Operation/ Activity No, Creation DatePF2, WP2
9005-003C1Open Work Order with Blank Order DescriptionWork Order (AFKO-AUFNR) based on the relevancy criteria and Blank Short Text (AUFK-KTEXT = '')
Note: Business to Set appropriate Work Order description
Order No, Order Type, PlantPF2, WP2
9005-004C1Open Work Order Operation with Blank Control Key

Work Order (AFKO-AUFNR) based on the relevancy criteria and Blank Control Key (AFVC-STEUS = '')

Note: Business to Set appropriate Work Order Operation Control Key

Order No, Order Type, Plant, Description, Operation/ Activity NoPF2, WP2
9005-005C1Open Work Order with Blank Order Operation Description

Work Order (AFKO-AUFNR) based on the relevancy criteria and Blank Operation Short Text (AFVC-LTXA1 = '')

Note: Business to Set appropriate Work Order Operation description

Order No, Order Type, Plant, Description, Operation/ Activity NoPF2, WP2
9005-006C1Completed Work Orders with Open Purchase Order and without any Reference Object (Functional Location/ Equipment assigned)

Work Order (AFKO-AUFNR)with System Status (JEST-STAT) and having Purchase Order (EKKN-AUFNR is not Blank) and Purchase Order (EKKN-EBELN) which are Open as defined in CNV-9045 Open Purchase Orders with no Technical Object (Functional Location/ Equipment/ Assembly) assigned on the WO header i,e (AFIH-ILOAN = '') and (AFIH-EQUNR = '') and (AFIH-BAUTL ='').

Note: Business to perform the below
a) Reverse TECO status for these Work Order
b) Populate the Functional Location/ Equipment on the WO Header
c) Complete (TECO) the Work Order

If not cleansed, these would have to be dealt after Go-Live.

Order No, Order Type, Plant, DescriptionPF2, WP2
9005-007C1

Release Work Orders with Operations having Blank value maintained for any of the below fields -

Work
Duration
No of Capacities

Work Order (AFKO-AUFNR)with System Status (JEST-STAT) = 'REL' and having Operation with any of the below fields with Blank value
-Work
-Duration
-No of Capacities

Note: Business to Set required values for the above Work Order Operation fields

Order No, Order Type, Plant, Description, Operation/ Activity No, Calculation Key, Work, Duration, No of CapacitiesPF2, WP2
9005-008C1

Open Work Orders with Basic Start Date in future and not having any PO assigned

Work Orders with no open PO, with Basic Start Date (AFKO-GSTRP) later than the Migration / "Go-Live" Date (OTH_Migration_Date Relevant Values A2D (using Object ID "9005" and Field Name = "AFKO-GSTRP") and Priority (AFIH-PRIOK) existing in the below list - 

SourcePriorityTypePriorityPriority
PF2Z16For next shutdown
PF2Z56Next shutdown
PF2Z58Turnaround 1YR
PF2Z65For next shutdown
WP2ZP5For next shutdown

Note: Business to create PO in source, otherwise these orders will not be migrated

Order No, Order Type, Plant, Description, Creation Date, Basic Start DatePF2, WP2
0099005-C3Info Report: Open Work Orders with External Operations/ Externally procured material but no Purchase Order existing

Open Work Orders with External Operations i.e where Operation Control Key (AFVC-STEUS) has External Processing Flag (T430-LIEF) <> '' and no Purchase Order existing (Check relevancy section for logic to find PO assigned to WO).

Note: These Work Orders Component line items will not be not migrated

Order No, Order Type, Plant, Description, Operation, Component, Component Description, System StatusPF2, WP2
9005-010C3Info Report: Open Work Orders with Open Purchase OrderWork Order (AFKO-AUFNR) based on the relevancy criteria having Purchase Order (EKKN-AUFNR is not Blank) and Purchase Order (EKKN-EBELN) which are Open as defined in CNV-9045 Open Purchase OrdersOrder No, Order Type, Plant, Description, Purchase Order No, Purchase Order ItemPF2, WP2
9005-011C3Info Report: Open Work Orders with Outstanding Reservation

Work Order (AFKO-AUFNR) based on the relevancy criteria having Reservation (RESB-AUFNR is not Blank) and the Reservation is not deleted (RESB-XLOEK = '' ) and not flagged as final issue (RESB-KZEAR = '') and having outstanding quantity (RESB-BDMNG > RESB-ENMNG)

Note: Business to check for the scenarios and cleanse accordingly - 
- Component no longer needed (wrong material / quantity / duplicate)
- Full qty already issued but reservation not “completed”
- Partial issue done, remainder will NOT be issued
- Order is TECO/closed but reservation/PR not marked for deletion
- Components in order but RESB still shows entries

Order No, Order Type, Plant, Description, Reservation No, Material No, Required Quantity, Withdrawal QuantityPF2, WP2
9005-012C3Info Report: Work Order not in scope for migration (not relevant)

Work Order (AFKO-AUFNR) based on the relevancy criteria (Exclusion)

Note: These Work Orders will not be not migrated

Order No, Order Type, Plant, DescriptionPF2, WP2
9005-013C3Info Report: Open Work Orders that have external services assigned and PO existingWork Order (AFKO-AUFNR) based on the relevancy criteria having Purchase Order (EKKN-AUFNR is not Blank) and Purchase Order (EKKN-EBELN) which are Open as defined in CNV-9045 Open Purchase Orders and having Service Items (EKPO-PSTYP = '9')Order No, Order Type, Plant, Description, Purchase Order, Purchase Order ItemPF2, WP2
9005-014C3Info Report: Open Work Orders with Functional Location and Assembly assigned and not EquipmentWork Order (AFKO-AUFNR) based on the relevancy criteria with (AFIH-ILOAN <>'') and (AFIH-EQUNR ='') and (AFIH-BAUTL <>'' and BAUTL not existing in Equipment Staging Mapping (OBJECT_ID))Order No, Order Type, Plant, Description, Functional Location, AssemblyPF2, WP2
9005-015C3Info Report: Open Work Orders without a Technical Object (Functional Location/ Equipment/ Assembly) assigned

Work Order (AFKO-AUFNR) based on the relevancy criteria with no Technical Object (Functional Location/ Equipment/ Assembly) assigned i,e (AFIH-ILOAN = '') and (AFIH-EQUNR = '') and (AFIH-BAUTL ='')

Note: These Work Orders will not be not migrated

Order No, Order Type, Plant, DescriptionPF2, WP2
9005-016C3Info Report: Open Work Orders with blank Basic End Date

Work Order (AFKO-AUFNR) based on the relevancy criteria with Basic End Date (AFKO-GLTRP) = '00000000'

Note: These Work Orders will not be not migrated

Order No, Order Type, Plant, Description, Basic Start Date, Basic End DatePF2, WP2
9005-017C3Info Report: Open Work Orders maintained as Sub Orders

Work Order (AFKO-AUFNR) based on the relevancy criteria for which Superior Order exists (AFKO-MAUFNR is not Blank)

Note: These Work Orders will not be not migrated

Order No, Order Type, Plant, DescriptionPF2, WP2
9005-018C3Info Report: Open Work Order with Materials assigned to Object List

Work Order (AFKO-AUFNR) based on the relevancy criteria for which Object List contains Materials (OBJK-MATNR).

Note: These Work Orders Object List entries will not be not migrated

Order No, Order Type, Plant, Description, Material, Material DescriptionPF2, WP2
9005-019C3Info Report: Open Refurbishment Work Orders

Work Order (AFKO-AUFNR) based on the relevancy criteria having  Order Type (AUFK-AUART) = 'ZPM4'

Note: These Work Orders will not be not migrated

Order No, Order Type, Plant, DescriptionWP2

Note: List of Cleansing is maintained here: Conversion Specs Register (DCT & Cleansing Report)

 

Conversion Process

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

The following represents the high-level process for Source System Extraction:

image-2025-10-29_17-38-58.png

The following represents the high-level process for DCT:

Collection will be done manually in the Data Collection Template for sites not on SAP- PF2 or WP2 systems 


Data Privacy and Sensitivity

Not Applicable


Extraction

Extract data from a source into Advanced Data Migration and Management (ADMM). There are 2 possibilities:

  1. The data exists. connects to the source and loads the data into the repository. 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 ADMM 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 the repository. This is to be conducted using DCT (Data Collection Template) in Advanced Data Migration and Management (ADMM).

Extraction Run Sheet

Req #Requirement DescriptionTeam Responsible
1Extract data from source system based on relevancy ruleSyWay Data Team


Selection Screen

Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set
Not Applicable




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. 

Note: All rules specified below should be documented as a tooltip in the DC Page.

Format:

  • Line 1: Mandatory / Conditional
  • Line 2: Remaining text

 

1. Work Order Header Data Construction Rules

Field NameField DescriptionRule
WERKSPlant

Mandatory.

Populate the Plant to which the Work Order is associated.

Allowed values: List from Value Mapping - Plant (where Maintenance Plant = Yes)

zLegacyAUFNRLegacy Order Number

Mandatory.

AUARTOrder Type

Mandatory.

Allowed values: 

YA01    Reactive Maintenance
YA02    Proactive Maintenance
YA03    Project Orders

KCHARDescription

Mandatory.

Populate with a meaningful Order Description. 

Ensure that it does not include any of below characters: 

;        Semi-colon
:        Colon
::        Double Colon
?        Question Mark
/        Forward Slash
@        At sign
&        Ampersand
=        Equal Sign
+        Plus Sign
$        Dollar Sign
%        Percent
|        Vertical Bar
[]        Left or Right Square Bracket
"        Double Quotes

PRIOKPriority

Mandatory.

Needs to be selected from value list (T356).

GSTRPBasic Start Date

Mandatory.

Populate the Work Order planned start date in YYYYMMDD format. 

GSUZPBasic Start Time

Mandatory.

Populate the Work Order planned start time in HHMMSS format. 

GLTRPBasic End Date

Mandatory.

Populate the Work Order planned end date in HHMMSS format. 

GLUZPBasic End Time

Mandatory.

Populate the Work Order planned end time in HHMMSS format. 

TPLNRFunctional Location

Mandatory.

Populate the Functional Location associated to the asset.

Value must exist in Functional Location DCT. 

EQUNREquipment

Conditional.

Populate if the Asset being maintained is an Equipment. Otherwise, leave the field blank.

Value must exist in Equipment DCT.

ILARTMaintenance Activity Type

Mandatory.

Needs to be selected from value list (T353I) where ILART starting with M (M01, M02...)

PROIDWBS Element (Acc Assignment)

Conditional.

  • Populate only for Project Work Orders 
  • Should be a valid WBS Element (S4)

 

2. Work Order Operation Data Construction Rules

Field NameField DescriptionRule
WERKSPlant

Mandatory.

Populate the Plant to which the Work Order is associated.

Allowed values: List from Value Mapping - Plant where Maintenance Plant = Yes

zLegacyAUFNRLegacy Order Number

Mandatory.

Key to link to Work Order. Must exist in Order Header DCT.

zLegacyVORNRLegacy Operation Number

Mandatory.

Sequence number that uniquely identifies an operation in the order.

Populate in increments of 10 (e.g., 0010, 0020, 0030) for multiple operations. 

LTXA1Operation Description

Mandatory.

Populate with a meaningful description for the Work Order Operation.

;        Semi-colon
:        Colon
::        Double Colon
?        Question Mark
/        Forward Slash
@        At sign
&        Ampersand
=        Equal Sign
+        Plus Sign
$        Dollar Sign
%        Percent
|        Vertical Bar
[]        Left or Right Square Bracket
"        Double Quotes

PERNRPerson Responsible

Conditional

Populate the Personnel Number of the person responsible/assigned to perform the operation.

Value must be an active Person Responsible.

STEUSControl Key

Mandatory.

Populate appropriate Control Key based on the how the operation is to be processed (internal/external, etc.).

Needs to be selected fromValue List (T430) with pattern 'PMXX'

SAKTOCost Element

Conditional.

Populate the Cost posting account for external services/materials depending on process.

Should be a valid Cost Element (S4)

EKORGPurchasing Organisation

Conditional.

Populate Purchasing org responsible for procurement activities.

Needs to be selected from value list (T024E)

EKGRPPurchasing Group

Conditional.

Populate Buyer/group responsible for procurement.

Needs to be selected from value list (T024)

MATKLMaterial Group

Conditional.

Populate Material Group for the required Materials/ Services. 

Needs to be selected from value list (T023)

ANLZUSystem Condition

Conditional.

Populate Condition of the System/ Asset during the maintenance activity. 

Needs to be selected from value list (T375M)

DAUNODuration

Mandatory.

Populate duration to perform the activity. 

ANZZLRequired Capacities

Mandatory.

Populate the number of required capacities to perform the activity.

Must be an integer value. Cannot be 0.

EINSAStart Constraint

Conditional.

Populate only if Start Constraint logic is used to be used for scheduling in target. Otherwise, leave the field blank.

Allowed values: Select from the below list - 

1 - Must start on
2 - Cannot start before
3 - Cannot start later
5 - Start from resource planning

NTANFStart Constraint Date

Conditional.

Date on which the constrained start is required. 

Populate only if EINSA is populated. Otherwise, leave the field blank.

Date Format DDMMYYYY.

NTANZStart Constraint Time

Conditional.

Time for the constrained start

Populate only if EINSA and NTANF is populated. Otherwise, leave the field blank. 

Time Format HHMMSS. 

EINSEFinish Constraint

Conditional.

Populate only if Finish Constraint logic is to be used for scheduling in target. Otherwise, leave the field blank.

Allowed values: Select from the below list - 

1 - Must finish on
2 - Cannot finish before
3 - Finish not later
4 - Finish from confirmation

NTENDFinish Constraint Date

Conditional.

Date on which the constrained finish is required.

Populate only if EINSE is populated. Valid Date. Otherwise, leave the field blank.

Date Format DDMMYYYY. 

NTENZFinish Constraint Time

Conditional.

Time for the constrained finish.

Populate only if EINSE and NTEND is populated. Valid Time. Otherwise, leave the field blank.

Time Format HHMMSS.

MGVRGOperation Quantity

Conditional.

Populate only if the Operation is quantity-based (e.g., service quantity) in the target design. Otherwise, leave the field blank.

Numeric value only. Cannot be 0.

MEINHUnit

Conditional.

Populate only if MGVRG is populated. Otherwise, leave the field blank.

Needs to be selected from value list (T006)

PREISPrice

Conditional.

Populate price amount only if the Operation is externally procured / service-related. Otherwise, leave the field blank.

Numeric value only. Cannot be negative. 

PEINHPrice Unit

Conditional.

Number of units to which the price refers. 

Populate only if PREIS is populated. Otherwise, leave the field blank.

Must be an integer value. Cannot be 0. 

LIFNRVendor

Conditional.

Populate external vendor for the external service/ material if information exist. Otherwise, leave the field blank.

Value must exist in Vendor DCT

WEMPFRecipient

Conditional.

Populate Goods recipient name for purchasing documents if information exists. Otherwise, leave the field blank.

BEDNRTracking Number

Conditional.

Populate tracking number for PR/PO creation if information exists. Otherwise, leave the field blank.

SORTLSort Term

Conditional.

Populate sort term for the procurement scenario if information exists. Otherwise, leave the field blank.

AFNAMName of Requisitioner

Conditional.

Populate name of the Person requesting procurement if information exists. Otherwise, leave the field blank.

NO_DISP

Reservation Relevance / Generation of Purchase Requisition

Populate from the below value list as applicable. 

  • 1 (Never): Reservations/PRs are not created automatically. Requires manual intervention to initiate procurement.
  • 2 (From Release): Reservations/PRs are generated only when the maintenance order is released (system status REL). This is the most common setting to prevent procurement for planned, but not yet approved, work.
  • 3 (Immediately): Reservations for stock items (Item Cat 'L') are created immediately upon saving the order, or PRs for non-stock items (Item Cat 'N') are generated instantly, regardless of order release.

    Note: This will be set to 1 (Never) if the Purchase Order exist for the Operation.


3. Work Order Operation Components Data Construction Rules  

Field NameField DescriptionRule
WERKSPlant

Mandatory.

Populate the Plant to which the Work Order is associated.

Allowed values: List from Value Mapping - Plant where Maintenance Plant = Yes

zLegacyAUFNRLegacy Order Number

Mandatory.

Key to link to Work Order

zLegacyVORNRLegacy Operation Number

Mandatory.

Key to link to Work Order Operation. Key to link to Work Order. Must exist in Order Operation DCT.

POSNRItem Number of Reservation

Mandatory.

Sequence number that uniquely identifies Component assigned in the Order Operation.

Populate in increments of 10 (e.g., 0010, 0020, 0030) for multiple Materials. 

MATNRMaterial

Conditional

Populate with legacy Material number for the component line.

Value must exist in Material Master Basic view DCT

POTX1Description

Conditional

Populate with a meaningful description for the component line item.

  • If Material Master exists (MATNR populated), leave blank
  • If Free-text material/service (no MATNR), populate from legacy component/PR/PO line description if existing
POSTPItem Category

Mandatory.

Populate a valid component item category from the below. 

Item CategoryDescriptionProcurement Via
LStock ItemInventory
NNon-Stock ItemPurchase Req
EEnhanced LimitPurchase Req

Note - If populating data for a lean service, the values could only be "N" (Non-stock) or "E" (Enhanced Limit).

BDMNGQuantity

Mandatory.

Populate Component quantity requested for the component line.

MEINSUnit

Mandatory.

Populate if BDMNG is populated.

Needs to be selected from value list (T006)

NO_DISPReservation Relevance / Generation of Purchase Requisition

Mandatory.

Populate from the below value list as applicable. 

  • 1 (Never): Reservations/PRs are not created automatically. Requires manual intervention to initiate procurement.
  • 2 (From Release): Reservations/PRs are generated only when the maintenance order is released (system status REL). This is the most common setting to prevent procurement for planned, but not yet approved, work.
  • 3 (Immediately): Reservations for stock items (Item Cat 'L') are created immediately upon saving the order, or PRs for non-stock items (Item Cat 'N') are generated instantly, regardless of order release.

Note: This will be set to 1 (Never) if the Purchase Order exist for the Component.

BDTERRequirements Date

Conditional

Populate the date on which the requested quantity of material is required.

If populating this field ensure the Manual Maintenance of Requirement Date is set as 'X' (Yes).

Date Format DDMMYYYY. 

KZMPFManual Reqmt Date Indicator

Conditional

Populate Maintenance of Requirement Date Flag from the below list.

'' = NO
'X' = YES

LGORTStorage Location

Conditional

Populate legacy Storage Location from where stock is planned to be issued. 

Needs to be selected from value list (T001L) specifc to the Plant (WERKS) for which the data is being populated.

GPREISPrice

Conditional

Populate price for the external component/service line as applicable.

PEINHPrice Unit

Conditional

Populate Number of units to which the price refers.

Example
If 10 gallons of gasoline cost $12.00, the price unit is 10.

Populate only if GPREIS is populated. Otherwise, leave the field blank.

Must be an integer value. Cannot be 0. 

WAERSCurrency

Conditional

Populate the currency key for the component price. Must be maintained if GPREIS is populated.

Needs to be selected from value list (TCURC)

EKORGPurchasing Organisation

Conditional.

Populate Purchasing org responsible for procurement activities.

Needs to be selected from value list (T024E)

EKGRPPurchasing Group

Conditional.

Populate Buyer/group responsible for procurement.

Needs to be selected from value list (T024)

LIFNRSupplier

Conditional.

Populate external vendor for the service/ material if information exist. Otherwise, leave the field blank.

Value must exist in Value Mapping: Vendor Number 

INFNRPurchasing Info Record

Conditional.

Populate Number of purchasing info record if information exists. Otherwise, leave the field blank.

Value must exist in Value Mapping: Purchasing Info Record Number

MATKLMaterial Group

Conditional.

Populate Material Group if information exists. Otherwise, leave the field blank.

Needs to be selected from value list (T023)

SAKNRG/L Account

Conditional

Populate G/L account as required for account assignment.

Value must exist in Value Mapping: GL Account

WEMPFGoods Recipient

Conditional

Populate Goods recipient name for purchasing documents if information exists. Otherwise, leave the field blank.

ABLADUnloading Point

Conditional

Populate unloading point if information exists. Otherwise, leave the field blank.

STARTDATEService Performance Start Date

Conditional

To be populated for Lean Service Component Only. 

Populate performance start date of the Lean Service item. Leave blank if KZMPF (Manual Reqmt Date Indicator) = ''

Date Format DDMMYYYY.

PERFORMANCE
PERIODSTARTTIME
Service Performance Start Time (UTC)

Conditional

To be populated for Lean Service Component Only. 

Populate the start time of the lean service. Only populate if STARTDATE is maintained, else leave blank.

Time Format HHMMSS.

ENDDATEService Performance End Date

Conditional

To be populated for Lean Service Component Only. 

Populate performance start end of the Lean Service item. Leave blank if KZMPF (Manual Reqmt Date Indicator) = ''

Date Format DDMMYYYY.

PERFORMANCE
PERIODENDTIME
Service Performance End Time (UTC)

Conditional

To be populated for Lean Service Component Only. 

Populate the end time of the lean service. Only populate if ENDDATE is maintained, else leave blank.

Time Format HHMMSS.

SERVICE
DURATION
Duration of Lean Service

Conditional

To be populated for Lean Service Component Only. 

Populate the duration value of the Lean Service. Leave blank if Component is not a Lean Service.

SERVICE
DURATIONUNIT
Duration Unit for a Lean Service

Conditional

To be populated for Lean Service Component Only. 

Populate Lean Service duration unit (e.g., Hour, Day).

Needs to be selected from value list (T006)

COMMITMENTExpected Value

Conditional

Populate expected value for the Lean Service.

The value must be maintained, if the item category "E" (= Enhanced Limit) has been set for the item (lean service).

Please make sure, that this value is less than or equal to the overall limit.

SUMLIMITOverall Limit

Conditional

Populate maximum expenditure value for the Lean Service. 

The value must be maintained (mandatory), if the item category "E" (= Enhanced Limit) has been set for the item (lean service).

Please ensure, that this value is greater than or equal to the expected value.


4. Work Order Operation Relationships Data Construction Rules  

Field NameField DescriptionRule
WERKSPlant

Mandatory.

Populate the Plant to which the Work Order is associated.

Allowed values: List from Value Mapping - Plant where Maintenance Plant = Yes

zLegacyAUFNR_PRE

Legacy Order Number (Predecessor)

Mandatory.

Populate with the Predecessor order number to which the Predecessor operation belongs.

zLegacyVORNR_PREPredecessor Operation Number

Mandatory.

Populate with the Predecessor operation number within the Predecessor order.

zLegacyAUFNR_SUCLegacy Order Number (Successor)

Mandatory.

Populate with the successor order number to which the successor operation belongs.

zLegacyVORNR_SUCSuccessor Operation Number

Mandatory.

Populate with the successor operation number within the successor order.

AOBARType of Relationship

Mandatory.

Populate relationship type between predecessor and successor operations as required the below list. 

FS - Finish-to-Start

SS - Start-to-Start

FF - Finish-to-Finish

SF - Start-to-Finish

DAUERTime Interval

Conditional.

Populate lag/lead (positive/negative) duration value between operations.

ZEINHUnit

Conditional.

Populate duration unit (e.g., Hour, Day) only when DAUER has been populated. 

Needs to be selected from value list (T006)


5. Work Order Object List Data Construction Rules  

Field NameField DescriptionRule
WERKSPlant

Mandatory.

Populate the Plant to which the Work Order is associated.

Allowed values: List from Value Mapping - Plant where Maintenance Plant = Yes

zLegacyAUFNRLegacy Order Number

Mandatory.

Key to link to Work Order

OBZAECounter

Mandatory.

Populate with a sequential counter per AUFNR representing each object list item (e.g., 0001, 0002…).

SORTFSort

Conditional

Populate a sort key to control grouping of object list items (e.g., by object type, priority, hierarchy). Else leave blank.

TPLNRFunctional Location

Mandatory.

Populate with the legacy Functional Location assigned to the order.

Value must exist in Functional Location DCT. 

EQUNREquipment

Conditional.

Populate with the legacy Equipment assigned to the order.

Value must exist in Equipment DCT. 


6. Work Order Long Text Line Data Construction Rules  

Field NameField DescriptionRule
WERKSPlant

Mandatory.

Populate the Plant to which the Work Order is associated.

Allowed values: List from Value Mapping - Plant where Maintenance Plant = Yes

zLegacyAUFNR

Legacy Order Number

Mandatory.

Key to link to Work Order

TDLINE_LCText Line (Local Language)

Conditional

User to populate Free Text in language of the country in which each plant is located (French, Italian, Mandarin, Brazilian Portuguese, German or Spanish).


7. Work Order Operation Long Text Line Data Construction Rules 

Field NameField DescriptionRule
WERKSPlant

Mandatory.

Populate the Plant to which the Work Order is associated.

Allowed values: List from Value Mapping - Plant where Maintenance Plant = Yes

zLegacyAUFNR

Legacy Order Number

Mandatory.

Key to link to Work Order

zLegacyVORNRLegacy Operation Number

Mandatory.

Key to link to Work Order Operation

TDLINE_LCText Line (Local Language)

Conditional

User to populate Free Text in language of the country in which each plant is located (French, Italian, Mandarin, Brazilian Portuguese, German or Spanish).

Extraction Dependencies

Item #Step DescriptionTeam Responsible

1

Not Applicable



Transformation

The Target fields are mapped to the applicable Legacy field that will be its source, this is a 3-way activity involving the Business, Functional team and Data team.  This identifies the transformation activity required to allow ADMM 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 Advanced Data Migration and Management (ADMM)
  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

1

Obtain DCT Sign-off from Business.

SyWay Data Team

2

In dspMigrate, select the wave – S4/HANA – Plant Maintenance

Syniti

3

Go to Process Area Launch and Process the Object – Work Order

Syniti

4

Review and Validate Error and Preload Reports

Syniti

5

Execute the transformation to prepare the target tables

Syniti

6

Validate data from pre-load and error reports

Business/Data owner

7

Generate load files

Syniti


Transformation Rules

Note: Unless otherwise specified, the transformation rules applies to YA01, YA02 and YA03 Order Types.

Work Order System Status Migration:

WO System Status to be transformed based on Legacy WO status, PR/Reservation existence, and whether the Basic Start Date is Before Cutover, within the Cutover Window, or After Cutover. The transformation logic should be developed as per the scenarios stated in the below matrix.

For illustration:

  • Cutover Date: 01-Oct-2026

  • X = 4 weeks before Cutover

  • Y = 4 weeks after Cutover

So:

  • X weeks before: 03-Sep-2026

  • Y weeks after: 29-Oct-2026

Legacy WO statusPR/Reservation exists?Basic Start Date conditionExample Basic Start DateFinal Status
CRTDYesBefore Cutover (≥ X weeks before)20-Aug-26CRTD
CRTDNoBefore Cutover (≥ X weeks before)15-Aug-26CRTD
RELYesBefore Cutover (≥ X weeks before)25-Aug-26REL
RELNoBefore Cutover (≥ X weeks before)18-Aug-26CRTD
CRTDYesAround Cutover (X weeks before → Y weeks after)10-Sep-26CRTD
CRTDNoAround Cutover (X weeks before → Y weeks after)25-Sep-26CRTD
RELYesAround Cutover (X weeks before → Y weeks after)5-Oct-26REL
RELNoAround Cutover (X weeks before → Y weeks after)20-Oct-26REL
CRTDYesAfter Cutover (≥ Y weeks after)10-Nov-26CRTD
CRTDNoAfter Cutover (≥ Y weeks after)15-Nov-26CRTD
RELYesAfter Cutover (≥ Y weeks after)20-Nov-26CRTD
RELNoAfter Cutover (≥ Y weeks after)5-Dec-26CRTD

XOTH_Migration_Date Relevant Values A2D (using Object ID "9005" and Field Name = "AFKO-GSTRP_POSTGOLIV1")
Y - OTH_Migration_Date Relevant Values A2D (using Object ID "9005" and Field Name = "AFKO-GSTRP_POSTGOLIV2")
Cutover - OTH_Migration_Date Relevant Values A2D (using Object ID "9005" and Field Name = "AFKO-GSTRP")

A.1 Logic for checking PR (Purchase Requisition) assign to a Work Order:

StepTableField(s)Logic
1AUFK / AFIHAUFK-AUFNR = AFIH-AUFNRIdentify the PM Work Order
2EBKNEBKN-AUFNR = AUFK-AUFNRFind PR account assignment against the Work Order
3EBANEBAN-BANFN = EBKN-BANFN and EBAN-BNFPO = EBKN-BNFPOGet PR item

A.2 Check if the PR (Purchase Requisition) is Open using

EBAN-LOEKZ = space    "Not deleted"
AND EBAN-EBAKZ = space "Not closed"
AND EBAN-MENGE > EBAN-BSMNG "Requested quantity > Quantity already ordered / assigned to PO"

B.1 Logic for checking Reservation assign to a Work Order: 

StepTableField(s)Logic
1AUFK / AFIHAUFK-AUFNR = AFIH-AUFNRIdentify the PM Work Order
2RESBRESB-AUFNR = AUFK-AUFNRFind reservations belonging to the Work Order

B.2 Check if the Reservation is Open using

RESB-XLOEK = space "Reservation item is not deleted"
AND RESB-KZEAR = space "Reservation item is not finally issued / not completed"
AND RESB-BDMNG > RESB-ENMNG "Required quantity is still greater than Issued quantity, so there is outstanding quantity"


1. Work Order Header Transformation Rule (ECC)

Exception: For Work Orders (AUFK-AUFNR) with System Status (JEST-STAT) = Technically Completed (
TECO) and relevant open Purchase Order (EKKN-EBELN) as defined in CNV-9045 Open Purchase Orders only Work Order Header needs to be migrated.

Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1----S/4 HANAAUFKAUFNROrder Number

System (Internal numbering)

2PF2, WP2AUFKAUARTOrder TypeS/4 HANAAUFKAUARTOrder TypeValue Mapping: Work Order Type (based on Legacy Work Order Type (AUART) and Maintenance Activity Type (ILART))
3PF2, WP2AUFKKTEXTDescriptionS/4 HANAAUFKKTEXTDescription
  1. If not blank, Direct Mapping
  2. If blank, derive the value as per Value Mapping: OTH_Migration_Date Relevant Values A2D (using Object ID "9005" and Field Name = "AUFK-KTEXT")
4PF2, WP2AFIHPRIOKPriorityS/4 HANAAFIHPRIOKPriority
  1. If not blank, Value Mapping
  2. If blank, derive the value as per Value Mapping: OTH_Migration_Date Relevant Values A2D (using Object ID "9005" and Field Name = "AUFK-PRIOK")
5PF2, WP2AFKOGSTRPBasic Start DateS/4 HANAAFKOGSTRPBasic Start DateDirect Mapping
6PF2, WP2AFKOGSUZPBasic Start TimeS/4 HANAAFKOGSUZPBasic Start TimeDirect Mapping
7PF2, WP2AFKOGLTRPBasic End DateS/4 HANAAFKOGLTRPBasic End DateDirect Mapping
8PF2, WP2AFKOGLUZPBasic End TimeS/4 HANAAFKOGLUZPBasic End TimeDirect Mapping
9PF2, WP2IFLOTTPLNRFunctional LocationS/4 HANAIFLOTTPLNRFunctional Location
  1. If Equipment is not blank then Not used.
  2. If S4 Equipment is blank, use Value Mapping: Functional Location.
10PF2, WP2AFIHEQUNREquipmentS/4 HANAAFIHEQUNREquipment
  • If not blank, Use Value Mapping: Equipment
  • If legacy AFIH-EQUNR is blank, check

- if there is S4 EQUNR available for legacy AFIH-ILOAN (Use TPLNR value) using Value Mapping: Equipment. If yes, use that

- if there is S4 EQUNR available for legacy AFIH-BAUTL using Value Mapping: Equipment. If yes, use that

If there is S4 EQUNR available for both legacy AFIH-ILOAN and AFIH-BAUTL, then the S4 EQUNR for legacy AFIH-BAUTL will have precedence.

If there is S4 EQUNR available for legacy AFIH-EQUNR and legacy AFIH-ILOAN and AFIH-BAUTL, then the S4 EQUNR for legacy AFIH-BAUTL will have precedence.

11PF2, WP2IFLOTTPLNRFunctional LocationS/4 HANAAFIHEQUNREquipment

Note: Transformation Rule for legacy EQUNR must run before this rule. This rule is for legacy Functional Locations which are converted to Equipment in S4

  1. If S4 EQUNR is blank then Value Mapping: Equipment
12PF2, WP2AFIHBAUTLAssemblyS/4HANAAFIHEQUNREquipment

Note: Transformation Rule for legacy EQUNR and legacy TPLNR to EQUNR must run before this rule. This rule is for legacy Assemblies which are converted to Equipment in S4

  1. If S4 EQUNR is blank then Value Mapping: Equipment
13PF2, WP2AFIHQMNUMAssigned NotificationS/4 HANAAFIHQMNUMAssigned NotificationValue Mapping: Notification
14PF2, WP2AFIHREVNRMaintenance Event/ RevisionS/4 HANAAFIHREVNRMaintenance Event/ RevisionNot relevant for load
15PF2, WP2AFIHILARTMaintenance Activity TypeS/4 HANAAFIHILARTMaintenance Activity Type
  1. If not blank, Value Mapping: Maintenance Activity Type
  2. If blank, derive the value as per Value Mapping: OTH_Migration_Date Relevant Values A2D (using Object ID "9005" and Field Name = "AFIH-ILART")
16----S/4 HANACRHDARBPLWork Center
  1. If EQUNR is not blank then derive from S4 EQUZ-GEWRK (Use logic EQUZ-GEWRK = CRHD-GEWRK to get CRHD-ARBPL)
  2. If EQUNR is blank then derive from S4 IFLOT-GEWRK (Use logic IFLOT-GEWRK = CRHD-GEWRK to get CRHD-ARBPL)
17----S/4 HANACRHDWERKSWork Center PlantDerive the CRHD-WERKS from the derived CRHD-ARBPL value
18----S/4 HANAAFIHIWERKPlanning Plant
  1. If EQUNR is not blank then derive from S4 EQUZ-IWERK
  2. If EQUNR is blank then derive from S4 IFLOT-IWERK
19----S/4 HANAAFIHINGPRPlanner group
  1. If EQUNR is not blank then derive from S4 EQUZ-INGRP
  2. If EQUNR is blank then derive from S4 IFLOT-INGRP
20----S/4 HANAAUFKWERKSMaintenance Plant

Copy from IWERK (Planning Plant)

21----S/4 HANAILOABEBERPlant Section
  1. If EQUNR is not blank then derive from S4 ILOA-BEBER (Use logic EQUZ-ILOAN = ILOA-ILOAN)
  2. If EQUNR is blank then derive from S4 ILOA-BEBER (Use logic IFLOT-ILOAN = ILOA-ILOAN)
22----S/4 HANAILOABUKRSCompany Code
  1. If EQUNR is not blank then derive from S4 ILOA-BUKRS (Use logic EQUZ-ILOAN = ILOA-ILOAN)
  2. If EQUNR is blank then derive from S4 ILOA-BUKRS (Use logic IFLOT-ILOAN = ILOA-ILOAN)
23PF2, WP2ILOAPROIDWBS Element (Acc Assignment)S/4 HANAILOAPROIDWBS Element (Acc Assignment)

If Legacy PROID exists in either of the below ADMM Deployment Prep reports with ILOA-PROID = Report-POSID, where Report-ZACTIVE_PROJECT_OPEN_CLOSED = 'OPEN' and Report-ZACTIVE= 'TRUE'

-I2M_ECC_SAPWP2_WBS_REPORT
-I2M_ECC_SAPPF2_WBS_REPORT

then use Value Mapping : WBS Element Number. Else Not used

24----S/4 HANAILOAKOSTLCost Center

For Order Types YA01 and YA02 use below logic- 

  1. If EQUNR is not blank then derive from S4 ILOA-KOSTL (Use logic EQUZ-ILOAN = ILOA-ILOAN)
  2. If EQUNR is blank then derive from S4 ILOA-KOSTL (Use logic IFLOT-ILOAN = ILOA-ILOAN)

For Order Types YA03 if S4 PROID exist then pass as BLANK else use below logic- 

  1. If EQUNR is not blank then derive from S4 ILOA-KOSTL (Use logic EQUZ-ILOAN = ILOA-ILOAN)
  2. If EQUNR is blank then derive from S4 ILOA-KOSTL (Use logic IFLOT-ILOAN = ILOA-ILOAN)


2.  Work Order Header Transformation Rule (DCT)

Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1DCTAUFKzLegacyAUFNRLegacy Order NumberS/4 HANAAUFKAUFNROrder Number

System (Internal numbering)

2DCTAUFKAUARTOrder TypeS/4 HANAAUFKAUARTOrder TypeDirect Mapping
3DCTAUFKKCHARDescriptionS/4 HANAAUFKKCHARDescriptionDirect Mapping
4DCTAFIHPRIOKPriorityS/4 HANAAFIHPRIOKPriorityDirect Mapping
5DCTAFKOGSTRPBasic Start DateS/4 HANAAFKOGSTRPBasic Start DateDirect Mapping
6DCTAFKOGSUZPBasic Start TimeS/4 HANAAFKOGSUZPBasic Start TimeDirect Mapping
7DCTAFKOGLTRPBasic End DateS/4 HANAAFKOGLTRPBasic End DateDirect Mapping
8DCTAFKOGLUZPBasic End TimeS/4 HANAAFKOGLUZPBasic End TimeDirect Mapping
9DCTIFLOTTPLNRFunctional LocationS/4 HANAIFLOTTPLNRFunctional LocationDirect Mapping
10DCTAFIHEQUNREquipmentS/4 HANAAFIHEQUNREquipmentValue Mapping: Equipment
11DCTAFIHQMNUMAssigned NotificationS/4 HANAAFIHQMNUMAssigned NotificationNot used
12----S/4 HANAAFIHREVNRMaintenance Event/ RevisionNot used
13----S/4 HANAAFIHILARTMaintenance Activity TypeDirect Mapping
14----S/4 HANACRHDARBPLWork Center
  1. If EQUNR is not blank then derive from S4 EQUZ-GEWRK (Use logic EQUZ-GEWRK = CRHD-GEWRK to get CRHD-ARBPL)
  2. If EQUNR is blank then derive from S4 IFLOT-GEWRK (Use logic IFLOT-GEWRK = CRHD-GEWRK to get CRHD-ARBPL)
15----S/4 HANACRHDWERKSWork Center PlantDerive the S4 CRHD-WERKS from the derived S4 CRHD-ARBPL value
16----S/4 HANAAFIHIWERKPlanning Plant
  1. If EQUNR is not blank then derive from S4 EQUZ-IWERK
  2. If EQUNR is blank then derive from S4 IFLOT-IWERK
17----S/4 HANAAFIHINGPRPlanner group
  1. If EQUNR is not blank then derive from S4 EQUZ-INGRP
  2. If EQUNR is blank then derive from S4 IFLOT-INGRP
18----S/4 HANAAUFKWERKSMaintenance Plant

Copy from IWERK (Planning Plant)

19----S/4 HANAILOABEBERPlant Section
  1. If EQUNR is not blank then derive from S4 ILOA-BEBER (Use logic EQUZ-ILOAN = ILOA-ILOAN)
  2. If EQUNR is blank then derive from S4 ILOA-BEBER (Use logic IFLOT-ILOAN = ILOA-ILOAN)
20----S/4 HANAILOABUKRSCompany Code
  1. If EQUNR is not blank then derive from S4 ILOA-BUKRS (Use logic EQUZ-ILOAN = ILOA-ILOAN)
  2. If EQUNR is blank then derive from S4 ILOA-BUKRS (Use logic IFLOT-ILOAN = ILOA-ILOAN)
21DCTILOAPROIDWBS Element (Acc Assignment)S/4 HANAILOAPROIDWBS Element (Acc Assignment)

Direct mapping for Order Type (AUART) = 'YA03', Else Not used

22-ILOAKOSTLCost CenterS/4 HANAILOAKOSTLCost Center

If Legacy PROID doesn't exists as per the rule mentioned above, then derive Cost Centre from -

  1. If EQUNR is not blank then derive from S4 ILOA-KOSTL (Use logic EQUZ-ILOAN = ILOA-ILOAN)
  2. If EQUNR is blank then derive from S4 ILOA-KOSTL (Use logic IFLOT-ILOAN = ILOA-ILOAN)


3.  Work Order Operation Transformation Rule (ECC)


Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1----S/4 HANAAFVCAUFNROrder Number

System (Internal numbering)

2PF2, WP2AFVCVORNRLegacy Operation/ActivityS/4 HANAAFVCVORNROperation/ActivityDirect Mapping
3PF2, WP2AFVCLTXA1Operation DescriptionS/4 HANAAFVCLTXA1Operation Description
  1. If not blank, Direct Mapping
  2. If blank, derive the value as per Value Mapping: OTH_Migration_Date Relevant Values A2D (using Object ID "9005" and Field Name = "AFVC-LTAX1")
4PF2, WP2CRHDARBPLWork CenterS/4 HANACRHDARBPLWork Center
  1. If not blank, Value Mapping: Work Centre A2D
  2. Else, copy Work Order Header Work Center
5PF2, WP2CRHDWERKSWork Center PlantS/4 HANACRHDWERKSWork Center PlantDerive the S4 CRHD-WERKS from the derived S4 CRHD-ARBPL value
6PF2, WP2AFVCPERNRPerson ResponsibleS/4 HANAAFVCPERNRPerson Responsible

Value Mapping: Employee Personnel

7PF2, WP2AFVCSTEUSControl KeyS/4 HANAAFVCSTEUSControl Key

Value Mapping: Control Key

8PF2, WP2AFVCSAKTOCost ElementS/4 HANAAFVCSAKTOCost Element

Direct Mapping

9PF2, WP2AFVCEKORGPurchasing OrganizationS/4 HANAAFVCEKORGPurchasing Organisation

Value Mapping: Purchasing Organization

10PF2, WP2AFVCEKGRPPurchasing GroupS/4 HANAAFVCEKGRPPurchasing Group

Value Mapping: Purchasing Group

11PF2, WP2AFVCMATKLMaterial GroupS/4 HANAAFVCMATKLMaterial GroupValue Mapping: Material Group
12PF2, WP2AFVCANLZUSystem ConditionS/4 HANAAFVCANLZUSystem ConditionValue Mapping: System Condition
13PF2, WP2AFVCLARNTActivity TypeS/4 HANAAFVCLARNTActivity TypeDerive Activity Type (CRCO-LSTAR) from Target Work Centre (CRHD-ARBPL)
14PF2, WP2AFVVARBEIWorkS/4 HANAAFVVARBEIWork

Direct Mapping

If ARBEI is not in Hours, convert ARBEI value to Hours as below

IF Unit = 'H'
Hours = Value

ELSE IF Unit = 'MIN'
Hours = Value / 60

ELSE Unit = 'SEC'
Hours = Value / 3600


ELSE IF Unit = 'DAY'
Hours = Value * Working Hours per Work Center Capacity Unit (Logic mentioned at the end of section)

15PF2, WP2AFVVARBEHWork UnitS/4 HANAAFVVARBEHWork Unit

Default to 'H' (Hours)

16PF2, WP2AFVCINDETCalculation KeyS/4 HANAAFVCINDETCalculation Key

Default to“0 – Maintain Manually”

17PF2, WP2AFVVDAUNODurationS/4 HANAAFVVDAUNODuration

Direct Mapping

If DAUNE is not in Hours, convert DAUNO value to Hoursas below

IF Unit = 'H'
Hours = Value

ELSE IF Unit = 'MIN'
Hours = Value / 60

ELSE Unit = 'SEC'
Hours = Value / 3600


ELSE IF Unit = 'DAY'
Hours = Value * Working Hours per Work Center Capacity Unit (Logic mentioned at the end of section)

18PF2, WP2AFVVDAUNEDuration UnitS/4 HANAAFVVDAUNEDuration UnitDefault to 'H' (Hours)
19PF2, WP2AFVCANZZLRequired CapacitiesS/4 HANAAFVCANZZLRequired Capacities

Direct Mapping

20PF2, WP2AFVVEINSAStart ConstraintS/4 HANAAFVVEINSAStart ConstraintDirect Mapping
21PF2, WP2AFVVNTANFStart Constraint DateS/4 HANAAFVVNTANFStart Constraint DateDirect Mapping
22PF2, WP2AFVVNTANZStart Constraint TimeS/4 HANAAFVVNTANZStart Constraint TimeDirect Mapping
23PF2, WP2AFVVEINSEFinish ConstraintS/4 HANAAFVVEINSEFinish ConstraintDirect Mapping
24PF2, WP2AFVVNTENDFinish Constraint DateS/4 HANAAFVVNTENDFinish Constraint DateDirect Mapping
25PF2, WP2AFVVNTENZFinish Constraint TimeS/4 HANAAFVVNTENZFinish Constraint TimeDirect Mapping
26PF2, WP2AFVVMGVRGOperation QuantityS/4 HANAAFVVMGVRGOperation QuantityDirect Mapping
27PF2, WP2AFVVMEINHOperation Quantity UnitS/4 HANAAFVVMEINHOperation Quantity UnitDirect Mapping
28PF2, WP2AFVCPREISPriceS/4 HANAAFVCPREISPriceDirect Mapping
29PF2, WP2AFVCWAERSCurrencyS/4 HANAAFVCWAERSCurrencyDirect Mapping
30PF2, WP2AFVCPEINHPrice UnitS/4 HANAAFVCPEINHPrice UnitDirect Mapping
31PF2, WP2AFVCLIFNRVendorS/4 HANAAFVCLIFNRVendorValue Mapping: Vendor Number
34PF2, WP2AFVCWEMPFRecipientS/4 HANAAFVCWEMPFRecipientDirect Mapping
35PF2, WP2AFVCBEDNRTracking NumberS/4 HANAAFVCBEDNRTracking NumberDirect Mapping
36PF2, WP2AFVCSORTLSort TermS/4 HANAAFVCSORTLSort TermDirect Mapping
37PF2, WP2AFVCINFNRPurchasing Info RecordS/4 HANAAFVCINFNRPurchasing Info RecordValue Mapping: Purchasing Info Record Number
38PF2, WP2AFVCAFNAMName of RequisitionerS/4 HANAAFVCAFNAMName of RequisitionerDirect Mapping
39PF2, WP2AFVCABLADUnloading PointS/4 HANAAFVCABLADUnloading PointDirect Mapping
40PF2, WP2AFVVPLIFZPlanned Delivery Time - DayS/4 HANAAFVVPLIFZPlanned Delivery Time - DayDirect Mapping
41PF2, WP2AFVCNO_DISPReservation Relevance / Generation of Purchase RequisitionS/4 HANAAFVCNO_DISPReservation Relevance / Generation of Purchase RequisitionCheck if PO exist in Legacy (PF2/WP2), then set to '1' (Never)

Else map based on the below table.

Function

Legacy Table

Target Load

Never

1

1

From Release

X

2

Immediately

Blank

3

Logic to get Working Hours per Work Center Capacity Unit - 

StepTableField(s)Logic
1CRHDCRHD-ARBPL, CRHD-WERKSIdentify the Work Center
2CRHDCRHD-OBJTY = 'A', CRHD-OBJIDInternal Work Center object
3CRCACRCA-OBJTY = CRHD-OBJTY and CRCA-OBJID = CRHD-OBJIDGet capacity allocation
4CRCACRCA-KAPIDCapacity ID assigned to Work Center
5KAKOKAKO-KAPID = CRCA-KAPIDGet standard capacity / working hours

Working Hours per Capacity Unit = (KAKO-ENDZT - KAKO-BEGZT - KAKO-PAUSE) / 3600

(Note - Values for the field mentioned would be in seconds and therefore this conversion is required)

KAKO-BEGZT "Start Time"
KAKO-ENDZT "End Time"
KAKO-PAUSE "Total Break Time"


4.  Work Order Operation Transformation Rule (DCT)

Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1DCTAFVCzLegacyAUFNRLegacy Order NumberS/4 HANAAFVCAUFNROrder Number

Direct Mapping

2DCTAFVCzLegacyVORNRLegacy Operation/ActivityS/4 HANAAFVCVORNROperation/ActivityDirect Mapping
3DCTAFVCLTXA1Operation DescriptionS/4 HANAAFVCLTXA1Operation DescriptionDirect Mapping
4DCTCRHDARBPLWork CenterS/4 HANACRHDARBPLWork CenterDirect Mapping
5DCTCRHDWERKSWork Center PlantS/4 HANACRHDWERKSWork Center PlantDirect Mapping
6DCTAFVCPERNRPerson ResponsibleS/4 HANAAFVCPERNRPerson Responsible

Value Mapping: Employee Personnel

7DCTAFVCSTEUSControl KeyS/4 HANAAFVCSTEUSControl Key

Direct Mapping

8DCTAFVCSAKTOCost ElementS/4 HANAAFVCSAKTOCost Element

Direct Mapping

9DCTAFVCEKORGPurchasing OrganizationS/4 HANAAFVCEKORGPurchasing Organisation

Direct Mapping

10DCTAFVCEKGRPPurchasing GroupS/4 HANAAFVCEKGRPPurchasing Group

Direct Mapping

11DCTAFVCMATKLMaterial GroupS/4 HANAAFVCMATKLMaterial GroupDirect Mapping
12DCTAFVCANLZUSystem ConditionS/4 HANAAFVCANLZUSystem ConditionDirect Mapping
13DCTAFVCLARNTActivity TypeS/4 HANAAFVCLARNTActivity TypeDerive Activity Type (CRCO-LSTAR) from Target Work Centre (CRHD-ARBPL)
14DCTAFVVARBEIWorkS/4 HANAAFVVARBEIWorkDerive Work = DAUNO X ANZZL
15DCTAFVVARBEHWork UnitS/4 HANAAFVVARBEHWork UnitDefault to 'H' (Hours)
16DCTAFVCINDETCalculation KeyS/4 HANAAFVCINDETCalculation KeyDefault to '2' (Calculate Work)
17DCTAFVVDAUNODurationS/4 HANAAFVVDAUNODurationDirect Mapping
18DCTAFVVDAUNEDuration UnitS/4 HANAAFVVDAUNEDuration UnitDefault to 'H' (Hours)
19DCTAFVCANZZLRequired CapacitiesS/4 HANAAFVCANZZLRequired CapacitiesDirect Mapping
20DCTAFVVEINSAStart ConstraintS/4 HANAAFVVEINSAStart ConstraintDirect Mapping
21DCTAFVVNTANFStart Constraint DateS/4 HANAAFVVNTANFStart Constraint DateDirect Mapping
22DCTAFVVNTANZStart Constraint TimeS/4 HANAAFVVNTANZStart Constraint TimeDirect Mapping
23DCTAFVVEINSEFinish ConstraintS/4 HANAAFVVEINSEFinish ConstraintDirect Mapping
24DCTAFVVNTENDFinish Constraint DateS/4 HANAAFVVNTENDFinish Constraint DateDirect Mapping
25DCTAFVVNTENZFinish Constraint TimeS/4 HANAAFVVNTENZFinish Constraint TimeDirect Mapping
26DCTAFVVMGVRGOperation QuantityS/4 HANAAFVVMGVRGOperation QuantityDirect Mapping
27DCTAFVVMEINHOperation Quantity UnitS/4 HANAAFVVMEINHOperation Quantity UnitDirect Mapping
28DCTAFVCPREISPriceS/4 HANAAFVCPREISPriceDirect Mapping
29DCTAFVCWAERSCurrencyS/4 HANAAFVCWAERSCurrencyDirect Mapping
30DCTAFVCPEINHPrice UnitS/4 HANAAFVCPEINHPrice UnitDirect Mapping
31DCTAFVCLIFNRVendorS/4 HANAAFVCLIFNRVendorValue Mapping
34DCTAFVCWEMPFRecipientS/4 HANAAFVCWEMPFRecipientDirect Mapping
35DCTAFVCBEDNRTracking NumberS/4 HANAAFVCBEDNRTracking NumberDirect Mapping
36DCTAFVCSORTLSort TermS/4 HANAAFVCSORTLSort TermDirect Mapping
37DCTAFVCINFNRPurchasing Info RecordS/4 HANAAFVCINFNRPurchasing Info RecordDirect Mapping
38DCTAFVCAFNAMName of RequisitionerS/4 HANAAFVCAFNAMName of RequisitionerDirect Mapping
39DCTAFVCABLADUnloading PointS/4 HANAAFVCABLADUnloading PointDirect Mapping
40DCTAFVVPLIFZPlanned Delivery Time - DayS/4 HANAAFVVPLIFZPlanned Delivery Time - DayDirect Mapping
41DCTAFVC

NO_DISP

Reservation Relevance / Generation of Purchase RequisitionS/4 HANAAFVC

NO_DISP

Reservation Relevance / Generation of Purchase RequisitionIf Purchase Order exist default to '1', Else
Direct Mapping


5.  Work Order Operation Component Transformation Rule (ECC)

Criteria - Load all components except for the following scenario:
- Work Order Operation (AFVC-VORNR) status (JEST-STAT) is CNF, or
- Item Category (RESB-POSTP) = L, and Requirement Quantity (RESB-BDMNG) =< Withdrawn Quantity (RESB-ENMNG), or
- Item Category (RESB-POSTP) = N, and Requirement Quantity (RESB-BDMNG) = PO Quantity (EKPO-MENGE) or 
-
Item Category (RESB-POSTP) = L/N/T, and Final Issue (RESB-KZEAR) isticked

Logic to Link Reservation (RESB) and Purchase Orders (EKPO)

StepTableField(s)Logic
1AUFK / AFIHAUFK-AUFNR = AFIH-AUFNRIdentify PM Work Order
2RESBRESB-AUFNR = AUFK-AUFNRGet reservation items for the Work Order
3RESBRESB-BANFN, RESB-BNFPOPR number and PR item referenced by reservation
4EKPOEKPO-BANFN = RESB-BANFN and EKPO-BNFPO = RESB-BNFPOGet PO item created from that PR
5EKKOEKKO-EBELN = EKPO-EBELNGet PO header


Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1----S/4 HANAAFVCAUFNROrder Number

System (Internal numbering)

2PF2, WP2AFVCVORNROperation NumberS/4 HANAAFVCVORNROperation NumberDirect Mapping
3PF2, WP2RESBPOSNRItem Number of ReservationS/4 HANARESBPOSNRItem Number of ReservationDirect Mapping
4PF2, WP2RESBMATNRMaterial NumberS/4 HANARESBMATNRMaterial

Value Mapping: Material Master

5PF2, WP2RESBPOTX1DescriptionS/4 HANARESBPOTX1Description

Direct Mapping, If Material number is blank.

This field is defaulted from the Material Master. Only load if Material Number is blank.

If Material number is not blank, retrieve from Material table for reference only.

6PF2, WP2RESBPOSTPItem CategoryS/4 HANARESBPOSTPItem Category
  1. If not blank, Direct Mapping
  2. If blank, derive the value as per Value Mapping: OTH_Migration_Date Relevant Values A2D (using Object ID "9005" and Field Name = "RESB-POSTP")

Validation to ensure – if legacy material number is blank, value must be “N” or “T”

7PF2, WP2RESBBDMNGRequirement QuantityS/4 HANARESBBDMNGRequirement Quantity

If Item Category = “L”

  • Requirement Quantity(RESB-BDMNG) minus Withdrawn Quantity (RESB-ENMNG)

If Item Category = N”

  • Requirement Quantity (RESB-BDMNG) minus  PO Quantity (EKPO-MENGE)

Select MENGE from EKPO where AFVC.AUFNR = RESB.AUFNR and  AFVC.VORNR = RESB.VORNR and RESB.RSNUM = EBAN.ARSNR and RESB.RSPOS = EBAN.ARSPS and RESB.XLOEK<> ‘X’ and EBAN.BANFN = EKPO.BANFN and EBAN.BNFPO = EKPO.BNFPO

8PF2, WP2RESBMEINSUnitS/4 HANARESBMEINSUnitDirect Mapping
9PF2, WP2RESBNO_DISPReservation Relevance / Generation of Purchase RequisitionS/4 HANARESBNO_DISPReservation Relevance / Generation of Purchase Requisition

If PO exist in Legacy (PF2/WP2), then set to '1' (Never)

Else map based on the below table.

Function

Legacy Table

Target Load

Never

1

1

From Release

X

2

Immediately

Blank

3

10PF2, WP2RESBWERKSPlantS/4 HANARESBWERKSPlantValue Mapping: Plant
11PF2, WP2RESBBDTERRequirements DateS/4 HANARESBBDTERRequirements DateDirect Mapping
12PF2, WP2RESBKZMPFManual Reqmt Date IndicatorS/4 HANARESBKZMPFManual Reqmt Date IndicatorDirect Mapping
13PF2, WP2RESBLGORTStorage LocationS/4 HANARESBLGORTStorage Location

Value Mapping: Storage Location.

Ensure material is extended to the storage location.

14PF2, WP2RESBCHARGBatchS/4 HANARESBCHARGBatchNot used
15PF2, WP2RESBGPREISPriceS/4 HANARESBGPREISPrice

Direct Mapping

16PF2, WP2RESBPEINHPrice UnitS/4 HANARESBPEINHPrice Unit

Direct Mapping

17PF2, WP2RESBWAERSCurrencyS/4 HANARESBWAERSCurrency

Only for Item Category = N,

Transform based on mapping table for Currency Code

Error if cannot be mapped.

Not applicable if Item Category <> N

18PF2, WP2RSADDEKORGPurchasing OrganizationS/4 HANARSADDEKORGPurchasing OrganizationValue Mapping: Purchasing Organization
19PF2, WP2RESBEKGRPPurchasing GroupS/4 HANARESBEKGRPPurchasing GroupValue Mapping: Purchasing Group
20PF2, WP2RESBLIFNRSupplierS/4 HANARESBLIFNRSupplierIf not blank, Value Mapping: Vendor
21PF2, WP2RESBINFNRPurchasing Info RecordS/4 HANARESBINFNRPurchasing Info RecordIf not blank, Value Mapping: Purchasing Info Record
22PF2, WP2RESBMATKLMaterial GroupS/4 HANARESBMATKLMaterial GroupIf not blank, Value Mapping: Material Group
23PF2, WP2RESBSAKNRG/L AccountS/4 HANARESBSAKNRG/L AccountIf not blank, Value Mapping: G/L Account
24PF2, WP2RESBWEMPFGoods RecipientS/4 HANARESBWEMPFGoods RecipientDirect Mapping
25PF2, WP2RESBABLADUnloading PointS/4 HANARESBABLADUnloading PointDirect Mapping
26----S/4 HANARESBSTARTDATEService Performance Start DateNot used
27----S/4 HANARESBPERFORMANCE
PERIODSTARTTIME
Service Performance Start Time (UTC)Not used
28----S/4 HANARESBENDDATEService Performance End DateNot used
29----S/4 HANARESBPERFORMANCE
PERIODENDTIME
Service Performance End Time (UTC)Not used
30----S/4 HANARESBSERVICEDURATIONDuration of Lean ServiceNot used
31----S/4 HANARESBSERVICEDURATIONUNITDuration Unit for a Lean ServiceNot used
32----S/4 HANAESUHCOMMITMENTExpected ValueNot used
33----S/4 HANAESUHSUMLIMITOverall LimitNot used


6.  Work Order Operation Lean Service Transformation Rule (ECC)

Lean Service Criteria: External Services will be mapped to Lean Service Materials. 
Lean service is mandatory when:
1. Work Order Operation is external service (AFVC-STEUS=T430-STEUS, T430-LIEF is not blank and T430-SERVICE is not blank)
2. Service Package with the following condition exists: AFVC-PACKNO=ESLL-PACKNO and ESLL-PACKAGE is not blank, get ESLL-SUB_PACKNO. Extract all data ESLL-SUB_PACKNO=ESLL-PACKNO

Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1----S/4 HANAAFVCAUFNROrder Number

System (Internal numbering)

2PF2, WP2AFVCVORNROperation NumberS/4 HANAAFVCVORNROperation NumberDirect Mapping
3----S/4 HANARESBPOSNRItem Number of Reservation
  • If a POSNR value already exists for the operation (AFVC-VORNR) in the legacy system, assign the next sequential POSNR by incrementing the existing value by +1 for each Lean Service entry recorded in the DCT.

  • If no POSNR value exists for the operation (AFVC-VORNR) in the legacy system, start with POSNR = ‘0001’ for the first Lean Service entry, and increment sequentially for subsequent entries (0002, 0003, …).

4DCTRESBMATNRMaterial NumberS/4 HANARESBMATNRMaterial

Direct Mapping

5----S/4 HANARESBPOTX1Description

Not used

6DCTRESBPOSTPItem CategoryS/4 HANARESBPOSTPItem Category

Direct Mapping

7DCTRESBBDMNGRequirement QuantityS/4 HANARESBBDMNGRequirement Quantity

Direct Mapping

8DCTRESBMEINSUnitS/4 HANARESBMEINSUnitDirect Mapping
9DCTRESBNO_DISPReservation Relevance / Generation of Purchase RequisitionS/4 HANARESBNO_DISPReservation Relevance / Generation of Purchase Requisition

If Purchase Order exist default to '1', Else
Direct Mapping

10DCTRESBWERKSPlantS/4 HANARESBWERKSPlantDirect Mapping
11DCTRESBBDTERRequirements DateS/4 HANARESBBDTERRequirements DateDirect Mapping
12DCTRESBKZMPFManual Reqmt Date IndicatorS/4 HANARESBKZMPFManual Reqmt Date IndicatorDirect Mapping
13----S/4 HANARESBLGORTStorage Location

Not used

14----S/4 HANARESBCHARGBatchNot used
15----S/4 HANARESBGPREISPrice

Not used

16----S/4 HANARESBPEINHPrice Unit

Not used

17----S/4 HANARESBWAERSCurrency

Not used

18----S/4 HANARSADDEKORGPurchasing OrganizationNot used
19----S/4 HANARESBEKGRPPurchasing GroupNot used
20----S/4 HANARESBLIFNRSupplierNot used
21----S/4 HANARESBINFNRPurchasing Info RecordNot used
22----S/4 HANARESBMATKLMaterial GroupNot used
23----S/4 HANARESBSAKNRG/L AccountNot used
24----S/4 HANARESBWEMPFGoods RecipientDirect Mapping
25----S/4 HANARESBABLADUnloading PointNot used
26DCTRESBRESBSTARTDATEService Performance Start DateRESBSTARTDATEService Performance Start DateDirect Mapping
27DCTRESBRESBPERFORMANCE
PERIODSTARTTIME
Service Performance Start Time (UTC)RESBPERFORMANCE
PERIODSTARTTIME
Service Performance Start Time (UTC)Direct Mapping
28DCTRESBRESBENDDATEService Performance End DateRESBENDDATEService Performance End DateDirect Mapping
29DCTRESBRESBPERFORMANCE
PERIODENDTIME
Service Performance End Time (UTC)RESBPERFORMANCE
PERIODENDTIME
Service Performance End Time (UTC)Direct Mapping
30DCTRESBRESBSERVICEDURATIONDuration of Lean ServiceRESBSERVICEDURATIONDuration of Lean ServiceDirect Mapping
31DCTRESBRESBSERVICEDURATIONUNITDuration Unit for a Lean ServiceRESBSERVICEDURATIONUNITDuration Unit for a Lean ServiceDirect Mapping
32DCTRESBESUHCOMMITMENTExpected ValueESUHCOMMITMENTExpected ValueDirect Mapping
33DCTRESBESUHSUMLIMITOverall LimitESUHSUMLIMITOverall LimitDirect Mapping


7.  Work Order Operation Component Transformation Rule (DCT)

Note: External Services will be mapped to Lean Service Materials.

Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1DCTAFVCzLegacyAUFNRLegacy Order NumberS/4 HANAAFVCAUFNROrder Number

System (Internal numbering)

2DCTAFVCzLegacyVORNRLegacy Operation NumberS/4 HANAAFVCVORNROperation NumberDirect Mapping
3DCTRESBPOSNRItem Number of ReservationS/4 HANARESBPOSNRItem Number of ReservationDirect Mapping
4DCTRESBMATNRMaterial NumberS/4 HANARESBMATNRMaterial

Value Mapping: Material Master

5DCTRESBPOTX1DescriptionS/4 HANARESBPOTX1Description

Direct Mapping

6DCTRESBPOSTPItem CategoryS/4 HANARESBPOSTPItem Category

Direct Mapping

7DCTRESBBDMNGRequirement QuantityS/4 HANARESBBDMNGRequirement Quantity

Direct Mapping

8DCTRESBMEINSUnitS/4 HANARESBMEINSUnitDirect Mapping
9DCTRESBNO_DISPReservation Relevance / Generation of Purchase RequisitionS/4 HANARESBNO_DISPReservation Relevance / Generation of Purchase Requisition

Direct Mapping

10DCTRESBWERKSPlantS/4 HANARESBWERKSPlantDirect Mapping
11DCTRESBBDTERRequirements DateS/4 HANARESBBDTERRequirements DateDirect Mapping
12DCTRESBKZMPFManual Reqmt Date IndicatorS/4 HANARESBKZMPFManual Reqmt Date IndicatorDirect Mapping
13DCTRESBLGORTStorage LocationS/4 HANARESBLGORTStorage Location

Direct Mapping

14DCTRESBCHARGBatchS/4 HANARESBCHARGBatchNot used
15DCTRESBGPREISPriceS/4 HANARESBGPREISPrice

Direct Mapping

16DCTRESBPEINHPrice UnitS/4 HANARESBPEINHPrice Unit

Direct Mapping

17DCTRESBWAERSCurrencyS/4 HANARESBWAERSCurrency

Direct Mapping

18DCTRSADDEKORGPurchasing OrganizationS/4 HANARSADDEKORGPurchasing OrganizationDirect Mapping
19DCTRESBEKGRPPurchasing GroupS/4 HANARESBEKGRPPurchasing GroupDirect Mapping
20DCTRESBLIFNRSupplierS/4 HANARESBLIFNRSupplierDirect Mapping
21DCTRESBINFNRPurchasing Info RecordS/4 HANARESBINFNRPurchasing Info RecordDirect Mapping
22DCTRESBMATKLMaterial GroupS/4 HANARESBMATKLMaterial GroupDirect Mapping
23DCTRESBSAKNRG/L AccountS/4 HANARESBSAKNRG/L AccountDirect Mapping
24DCTRESBWEMPFGoods RecipientS/4 HANARESBWEMPFGoods RecipientDirect Mapping
25DCTRESBABLADUnloading PointS/4 HANARESBABLADUnloading PointDirect Mapping
26DCT---S/4 HANARESBSTARTDATEService Performance Start DateNot used
27DCT---S/4 HANARESBPERFORMANCE
PERIODSTARTTIME
Service Performance Start Time (UTC)Not used
28DCT---S/4 HANARESBENDDATEService Performance End DateNot used
29DCT---S/4 HANARESBPERFORMANCE
PERIODENDTIME
Service Performance End Time (UTC)Not used
30DCT---S/4 HANARESBSERVICEDURATIONDuration of Lean ServiceNot used
31DCT---S/4 HANARESBSERVICEDURATIONUNITDuration Unit for a Lean ServiceNot used
32DCT---S/4 HANAESUHCOMMITMENTExpected ValueNot used
33DCT---S/4 HANAESUHSUMLIMITOverall LimitNot used


8. Work Order Operation Relationships Transformation Rule (ECC)

Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1PF2, WP2AFVCAUFNRPredecessor Order NumberS/4 HANAAFVCAUFNRPredecessor Order Number

System (Internal numbering)

2PF2, WP2AFVCVORNRPredecessor Order OperationS/4 HANAAFVCVORNRPredecessor Order OperationDirect Mapping
3PF2, WP2AFVCAUFNRSuccessor Order NumberS/4 HANAAFVCAUFNRSuccessor Order NumberSystem (Internal numbering)
4PF2, WP2AFVCVORNRSuccessor Order OperationS/4 HANAAFVCVORNRSuccessor Order OperationDirect Mapping
5PF2, WP2AFABAOBARType of RelationshipS/4 HANAAFABAOBARType of RelationshipDirect Mapping
6PF2, WP2AFABDAUERTime IntervalS/4 HANAAFABDAUERTime IntervalDirect Mapping
7PF2, WP2AFABZEINHUnitS/4 HANAAFABZEINHUnitDirect Mapping


9. Work Order Operation Relationships Transformation Rule (DCT)

Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1DCTAFVCzLegacyAUFNR_PREPredecessor Order NumberS/4 HANAAFVCAUFNRPredecessor Order Number

System (Internal numbering)

2DCTAFVCVORNR_PREPredecessor Order OperationS/4 HANAAFVCVORNRPredecessor Order OperationDirect Mapping
3DCTAFVCzLegacyAUFNR_SUCSuccessor Order NumberS/4 HANAAFVCAUFNRSuccessor Order NumberSystem (Internal numbering)
4DCTAFVCVORNR_SUCSuccessor Order OperationS/4 HANAAFVCVORNRSuccessor Order OperationDirect Mapping
5DCTAFABAOBARType of RelationshipS/4 HANAAFABAOBARType of RelationshipDirect Mapping
6DCTAFABDAUERTime IntervalS/4 HANAAFABDAUERTime IntervalDirect Mapping
7DCTAFABZEINHUnitS/4 HANAAFABZEINHUnitDirect Mapping


10. Work Order Object List Transformation Rule (ECC)

Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1----S/4 HANAAFVCAUFNROrder Number

System (Internal numbering)

2PF2, WP2OBJKOBZAECounterS/4 HANAOBJKOBZAECounter

Direct Mapping

3PF2, WP2OBJKSORTFSortS/4 HANAOBJKSORTFSortDirect Mapping
4PF2, WP2IFLOTTPLNRFunctional LocationS/4 HANAIFLOTTPLNRFunctional LocationIf not blank, Use Value Mapping: Functional Location
5PF2, WP2OBJKEQUNREquipmentS/4 HANAOBJKEQUNREquipment

If not blank, Use Value Mapping: Equipment

6PF2, WP2IFLOTTPLNRFunctional LocationS/4 HANAOBJKEQUNREquipment

Note: Transformation Rule for legacy EQUNR must run before this rule. This rule is for legacy Functional Locations which are converted to Equipment in S4

  1. If S4 EQUNR is blank then Value Mapping: Equipment
7PF2, WP2OBJKBAUTLAssemblyS/4 HANAOBJKEQUNREquipment

Note: Transformation Rule for legacy EQUNR and legacy TPLNR to EQUNR must run before this rule. This rule is for legacy Assemblies which are converted to Equipment in S4

  1. If S4 EQUNR is blank then Value Mapping: Equipment
8PF2, WP2OBJKMATNRMaterialS/4 HANAOBJKMATNRMaterialValue Mapping: Material Master
9PF2, WP2OBJKQMNUMNotificationS/4 HANAOBJKQMNUMNotificationValue Mapping: Notification


11. Work Order Object List Transformation Rule (DCT) 

Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1DCTAFVCzLegacyAUFNRLegacy Order NumberS/4 HANAAFVCAUFNROrder Number

System (Internal numbering)

2PF2, WP2OBJKOBZAECounterS/4 HANAOBJKOBZAECounter

Direct Mapping

3PF2, WP2OBJKSORTFSortS/4 HANAOBJKSORTFSortDirect Mapping
4PF2, WP2IFLOTTPLNRFunctional LocationS/4 HANAIFLOTTPLNRFunctional LocationValue Mapping: Functional Location
5PF2, WP2OBJKEQUNREquipmentS/4 HANAOBJKEQUNREquipmentValue Mapping: Equipment
6PF2, WP2OBJKMATNRMaterialS/4 HANAOBJKMATNRMaterialNot used
7PF2, WP2OBJKQMNUMNotificationS/4 HANAOBJKQMNUMNotificationValue Mapping: Notification


12. Work Order Confirmation Transformation Rule (ECC)

Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1----S/4 HANAAUFKAUFNROrder Number

System (Internal numbering)

2PF2, WP2AFVCVORNROperation NumberS/4 HANAAFVCVORNROperation NumberDirect Mapping
3----S/4 HANAAFRUISMNWActual WorkDefault to '0'
4PF2, WP2AFRUAUERUFinal ConfirmationS/4 HANAAFRUAUERUFinal ConfirmationIf Operation Status = CNF, then default 'X' else Blank
5----S/4 HANAAFRUOFMNWRemaining workDefault to '0'
6----S/4 HANAAFRUISDDWork Start Date

Default Current Date

7----S/4 HANAAFRUISDZWork Start Time

Default “000000”

9----S/4 HANAAFRUIEDDWork Finish Date

Default Current Date

10----S/4 HANAAFRUIEDZWork Finish Time

Default “000000”


13. Work Order Operation Capacity Requirement Transformation Rule (ECC)

Work Order Operation Capacity Requirement is to be migrated only for work orders - 

  • within creation date (AUFK-ERDAT) later than X Period prior of the Migration / "Go-Live" Date (OTH_Migration_Date Relevant Values A2D (using Object ID "9005" and Field Name = "AUFK-ERDAT") - OTH_Migration_Date Relevant Values A2D (using Object ID "9005" and Field Name = "AUFK-ERDAT_PERIOD"))
  • with entries existing in KBED
Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1----S/4 HANAAUFKAUFNROrder Number

System (Internal numbering)

2PF2, WP2AFVCVORNROperation NumberS/4 HANAAFVCVORNROperation NumberDirect Mapping
3PF2, WP2KBEDARBIDWork Centre IDS/4 HANAKBEDARBIDWork Centre ID

Use below logic :

  1. Get Work Centre (CRHD-ARBPL) and Plant (CRHD-WERKS) using OKBED-ARBID = CRHD-OBJID
  2. Derive Target Work Centre using Value Mapping: Work Centre A2D
  3. Pass the Target Work Centre Object ID (CRHD-OBJID)
4PF2, WP2KBEDSPLITSplit NumberS/4 HANAKBEDSPLITSplit NumberDirect Mapping
5PF2, WP2KBEDPERNRPersonnel NumberS/4 HANAKBEDPERNRPersonnel NumberValue Mapping: Employee Personnel
6PF2, WP2KBEZARBEIWorkS/4 HANAKBEZARBEIWorkDirect Mapping
7PF2, WP2KBEZARBEHUnit of WorkS/4 HANAKBEZARBEHUnit of WorkDirect Mapping
8PF2, WP2KBEZDAUNONormal DurationS/4 HANAKBEZDAUNONormal DurationDirect Mapping
9PF2, WP2KBEZDAUNENormal duration unitS/4 HANAKBEZDAUNENormal duration unitDirect Mapping


14. Work Order Header Long Text Transformation Rule (ECC)

Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1----S/4HANA STXHTDOBJECTTexts: Application objectDefault to "AUFK"
2PF2, WP2 

AUFK

AUFNR

Order NumberS/4HANA STXHTDNAMEName

Concatenate - 

Client number (SAP System where data is being migrated) + 
Target Order Number (Value Mapping: Work Order)

E.g Client number (e.g., '100') followed by the 12-digit work order number (e.g., '100000012345'), then TDNAME should be 10000000012345.

3
---S/4HANA STXH

TDID

Text IDDefault to 'KOPF'
4PF2, WP2STXHTDSPRASLanguage KeyS/4HANA STXHTDSPRASLanguage KeyDerive Language Key (T001W-SPRAS) from Table T001W where S4 ARBPL-WERK (Plant for Work Center) = T001W-WERKS

Note: Priority of Long Text to be given first to the Plant's default language followed by other language sorted by the language key.


15. Work Order Header Long Text Line Transformation Rule (ECC)

Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1----S/4HANA STXHTDOBJECTTexts: Application objectDefault to "AUFK"
2PF2, WP2 

AUFK

AUFNR

Order NumberS/4HANA STXHTDNAMEName

Concatenate - 

Client number (SAP System where data is being migrated) + 
Target Order Number (Value Mapping: Work Order)

E.g Client number (e.g., '100') followed by the 12-digit work order number (e.g., '100000012345'), then TDNAME should be 10000000012345.

3
---S/4HANA STXH

TDID

Text IDDefault to 'KOPF'
4PF2, WP2STXHTDSPRASLanguage KeyS/4HANA STXHTDSPRASLanguage KeyDerive Language Key (T001W-SPRAS) from Table T001W where S4 ARBPL-WERK (Plant for Work Center) = T001W-WERKS
5PF2, WP2STXLTDFORMATTag columnS/4HANA STXLTDFORMATTag columnDirect Mapping
6PF2, WP2STXLROWCOUNT

Row number

S/4HANA STXLROWCOUNT

Row number

Direct Mapping
7PF2, WP2STXLTXLINEText LineS/4HANA STXLTXLINEText LineDirect Mapping

 Note: Priority of Long Text to be given first to the Plant's default language followed by other language sorted by the language key.


16. Work Order Operation Long Text Transformation Rule (ECC)

Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1----S/4HANA STXHTDOBJECTTexts: Application objectDefault to "AUFK"
2PF2, WP2 

AFVC

AUFPL

Routing number of Operation in Order

S/4HANA STXHTDNAMEName

Concatenate - 

Client number (SAP System where data is being migrated) + 
Target Routing number of Operation in Order (Value Mapping: Work Order Operation) + Target General counter for order (Value Mapping: Work Order Operation)

E.g Client number (e.g., '100') followed by the 10-digit AUFPL value (1001403027,), and the 8-digit APLZL value (00000002), then TDNAME should be 100100140302700000002.

3PF2, WP2 

AFVC

APLZL

General counter for order
4
---S/4HANA STXH

TDID

Text IDDefault to 'AVOT'
5PF2, WP2STXHTDSPRASLanguage KeyS/4HANA STXHTDSPRASLanguage KeyDerive Language Key (T001W-SPRAS) from Table T001W where S4 ARBPL-WERK (Plant for Work Center) = T001W-WERKS

 Note: Priority of Long Text to be given first to the Plant's default language followed by other language sorted by the language key.


17. Work Order Header Long Text Line Transformation Rule (ECC)

Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1----S/4HANA STXHTDOBJECTTexts: Application objectDefault to "AUFK"
2PF2, WP2 

AFVC

AUFPL

Routing number of Operation in Order

S/4HANA STXHTDNAMEName

Concatenate - 

Client number (SAP System where data is being migrated) + 
Target Routing number of Operation in Order (Value Mapping: Work Order Operation) + Target General counter for order (Value Mapping: Work Order Operation)

E.g Client number (e.g., '100') followed by the 10-digit AUFPL value (1001403027,), and the 8-digit APLZL value (00000002), then TDNAME should be 100100140302700000002.

3PF2, WP2 

AFVC

APLZL

General counter for order
3
---S/4HANA STXH

TDID

Text IDDefault to 'KOPF'
4PF2, WP2STXHTDSPRASLanguage KeyS/4HANA STXHTDSPRASLanguage KeyDerive Language Key (T001W-SPRAS) from Table T001W where S4 ARBPL-WERK (Plant for Work Center) = T001W-WERKS
5PF2, WP2STXLTDFORMATTag columnS/4HANA STXLTDFORMATTag columnDirect Mapping
6PF2, WP2STXLROWCOUNT

Row number

S/4HANA STXLROWCOUNT

Row number

Direct Mapping
7PF2, WP2STXLTXLINEText LineS/4HANA STXLTXLINEText LineDirect Mapping

Note: Priority of Long Text to be given first to the Plant's default language followed by other language sorted by the language key.


18. Work Order Header Long Text Transformation Rule (DCT)

Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1----S/4HANA STXHTDOBJECTTexts: Application objectDefault to "AUFK"
2DCT

AUFK

zLegacyAUFNR

Legacy Order NumberS/4HANA STXHTDNAMEName

Concatenate - 

Client number (SAP System where data is being migrated) + 
Target Order Number (Value Mapping: Work Order)

E.g Client number (e.g., '100') followed by the 12-digit work order number (e.g., '100000012345'), then TDNAME should be 10000000012345.

3----S/4HANA STXH

TDID

Text IDDefault to 'KOPF'
4----S/4HANA STXHTDSPRASLanguage KeyDerive Language Key (T001W-SPRAS) from Table T001W where S4 ARBPL-WERK (Plant for Work Center) = T001W-WERKS


19. Work Order Header Long Text Line Transformation Rule (DCT)

Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1----S/4HANA STXHTDOBJECTTexts: Application objectDefault to "AUFK"
2DCT

AUFK

zLegacyAUFNR

Legacy Order NumberS/4HANA STXHTDNAMEName

Concatenate - 

Client number (SAP System where data is being migrated) + 
Target Order Number (Value Mapping: Work Order)

E.g Client number (e.g., '100') followed by the 12-digit work order number (e.g., '100000012345'), then TDNAME should be 10000000012345.

3----S/4HANA STXH

TDID

Text IDDefault to 'KOPF'
4----S/4HANASTXHTDSPRASLanguage KeyDerive Language Key (T001W-SPRAS) from Table T001W where S4 ARBPL-WERK (Plant for Work Center) = T001W-WERKS
5----S/4HANA STXLTDFORMATTag columnDefault to ""
6 ----STXLROWCOUNTRow NumberFor each 132-character string generated, create a separate target row and increment the row number by 1 in sequence until the complete text is split.
7DCTSTXLTDLINE_LCText Line (Local)S/4HANA STXLTXLINEText LineSplit the DCT long text into consecutive 132-character strings. For each 132-character string generated, create a separate target row and increment the row counter by 1 in sequence until the complete text is split.


20. Work Order Operation Long Text Transformation Rule (DCT)

Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1----S/4HANA STXHTDOBJECTTexts: Application objectDefault to "AUFK"
2DCT

AUFK

zLegacyAUFNR

Legacy Order NumberS/4HANA STXHTDNAMEName

Concatenate - 

Client number (SAP System where data is being migrated) + 
Target Routing number of Operation in Order (Value Mapping: Work Order Operation) + Target General counter for order (Value Mapping: Work Order Operation)

E.g Client number (e.g., '100') followed by the 10-digit AUFPL value (1001403027,), and the 8-digit APLZL value (00000002), then TDNAME should be 100100140302700000002.

DCT

AFVC

zLegacyVORNRLegacy Operation Number
3----S/4HANA STXH

TDID

Text IDDefault to 'AVOT'
4----S/4HANA STXHTDSPRASLanguage KeyDerive Language Key (T001W-SPRAS) from Table T001W where S4 ARBPL-WERK (Plant for Work Center) = T001W-WERKS


21. Work Order Operation Long Text Line Transformation Rule (DCT)

Rule #Source SystemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget Description

Transformation Logic

1----S/4HANA STXHTDOBJECTTexts: Application objectDefault to "AUFK"
2DCT

AUFK

zLegacyAUFNR

Legacy Order NumberS/4HANA STXHTDNAMEName

Concatenate - 

Client number (SAP System where data is being migrated) + 
Target Routing number of Operation in Order (Value Mapping: Work Order Operation) + Target General counter for order (Value Mapping: Work Order Operation)

E.g Client number (e.g., '100') followed by the 10-digit AUFPL value (1001403027,), and the 8-digit APLZL value (00000002), then TDNAME should be 100100140302700000002.

DCT

AFVC

zLegacyVORNRLegacy Operation Number
3----S/4HANA STXH

TDID

Text IDDefault to 'AVOT'
4----S/4HANA STXHTDSPRASLanguage KeyDerive Language Key (T001W-SPRAS) from Table T001W where S4 ARBPL-WERK (Plant for Work Center) = T001W-WERKS
5----S/4HANA STXLTDFORMATTag columnDefault to ""
6----S/4 HanaSTXLROWCOUNTRow NumberFor each 132-character string generated, create a separate target row and increment the row number by 1 in sequence until the complete text is split.
7DCTSTXLTDLINE_LCText Line (Local)S/4HANA STXLTXLINEText LineSplit the DCT long text into consecutive 132-character strings. For each 132-character string generated, create a separate target row and increment the row counter by 1 in sequence until the complete text is split.


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


Transformation Mapping

Mapping Table NameMapping Table Description
Control KeyLegacy to Target Work Order Operation Control Key
Employee PersonnelOld Employee to Employee Business Partner
EquipmentLegacy/Staging to New Equipment
Functional LocationList of relevant Asset Functional Locations slated for migration, including the Target Technical Object. This will also be used for Old to New Functional Location Mapping
GL AccountOld to New GL Account
Maintenance Activity TypeOld to new Maintenance activity types
Material GroupMATKL: Old Material Group to New Material Group
Material MasterMATNR: Old to New Material No.
NotificationOld to new Notification
PlantOld Plant to New Plant
Purchasing GroupEKGRP: Old Purchasing Group to New Purchasing Group
Purchasing Info Record NumberINFNR: Old Info Record number to New Info Record Number.
Purchasing OrganizationEKORG: Old Purchasing Organization to New Purchasing Organization
Storage LocationOld to New Storage Location
Vendor NumberLIFNR: Old Vendor Code to New Vendor Code
WBS Element NumberPOSID: Old WBS to new WBS mapping
Work Centre A2D (Old to New Mapping)Old to new Work Centre A2D
Work OrderOld to New Work Order
Work Order OperationOld to New Work Order Operation
System ConditionOld to New System Condition
Work Order TypeLegacy to Target Work Order Type

List of Transformation Mappings with additional details is maintained here: Transformation Mappings

Transformation Dependencies

List the steps that need to occur before transformation can commence
Item #Step DescriptionTeam Responsible
1Ensure DCT tables completenessSyWay Data Team
2Ensure all Transformation mappings are up to dateSyWay Data Team


Pre-Load Validation

Project Team

Completeness

TaskAction

Verify Record Count

SyWay A2D Data Team to verify that the total number of relevant records from the source systems and/or the  DCT is equal to the total number of records in the Preload and Load Sheets.


Accuracy

TaskAction

Conversion Accuracy

SyWay A2D 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 Data Owner/s to verify that the total number of relevant records  from the source systems and/or the  DCT  is equal to the total number of records in the Preload and Load Sheets.


Accuracy

TaskAction

Conversion Accuracy

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


Load

The load process includes:

  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

Note: A custom load program is required and is to be developed by the SyWay Development Team.

Load Run Sheet

Item #Step DescriptionTeam Responsible

1

Ensure Pre-load sign-offs are obtained.

SyWay Data team

2

Go to the load tool and select the correct load Program.

SyWay Data team

3

Proceed with Data load.

SyWay Data team

4

Validate few records loaded by accessing standard transactions

SyWay Data team

5

Generate the post load reports in the tool.

SyWay Data team

6

Log errors as defects, if any and address resolutions. Close defects.

SyWay Data team

7

Resolve defects by reupload and re-generate post load reports if necessary.

SyWay Data team

8

Business to validate the post load files as part of post-load validation, raise data defects or provide the post-load sign-off.

Business

9

Repeat steps 5 to 7 if necessary.

SyWay Data team


Load Phase and Dependencies

Configuration

Item #Configuration Item
1T001-Company Code
2T001L-Storage Location
3T001W-Plant
4T003O-Work Order Type
5T006-Unit of Measure
6T023-Material Group
7T024-Purchasing Group
8T024A-Planner Group
9T024E-Purchasing Organization
10T3531-Maintenance Activity Type
11T356-Priority
12T357-Plant Section
13T375M-System Condition
14T430-Control Key
15TCURC-Currency

Conversion Objects

Object #Preceding Object Conversion Approach

1030

Work Centre

1002

Equipment

1003

Functional Location

1026

WBS - CAPEX, OPEX, Statistical

1074

Cost Centre

3018

Vendor

2019

Material

1094

Purchase Info Records (Including Pricing Conditions)

1067

GL Account Operational CoA (incl. secondary CE)

9005

Notification

TBDHR Mini Master

Error Handling

Error TypeError DescriptionAction Taken

Invalid Data

Invalid Work Centre

Expedite whether the master data is changed in the system

Invalid Data

Invalid Equipment

Expedite whether the master data is changed in the system

Invalid Data

Invalid Functional Location

Expedite whether the master data is changed in the system

Invalid Data

Invalid WBS

Expedite whether the master data is changed in the system

Invalid Data

Invalid Cost Centre

Expedite whether the master data is changed in the system

Invalid Data

Invalid Vendor

Expedite whether the master data is changed in the system

Invalid Data

Invalid Material

Expedite whether the master data is changed in the system

Invalid Data

Invalid Purchase Info Records

Expedite whether the master data is changed in the system

Invalid Data

Invalid GL Account Operational CoA (incl. secondary CE)

Expedite whether the master data is changed in the system

Invalid Data

Invalid Notification

Expedite whether the master data is changed in the system

Invalid Data

Invalid Employee PersonnelExpedite whether the master data is changed in the system

Configuration

Invalid Company Code

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid Storage Location

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid  Plant

Engage Functional team to expedite and fix the error in the system

Configuration

 Invalid Work Order Type

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid Unit of Measure

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid Material Group

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid Purchasing Group

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid Planner Group

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid Purchasing Organization

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid Maintenance Activity Type

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid Priority

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid Plant Section

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid System Condition

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid Control Key

Engage Functional team to expedite and fix the error in the system

ConfigurationInvalid Currency

Engage Functional team to expedite and fix the error in the system


Post-Load Validation

Project Team

Completeness

TaskAction

Verify Count

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

Verify Logs

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


Accuracy

TaskAction

Conversion Accuracy

Verify that the Reference Functional Location data in target S/4 HANA were loaded correctly via dspMigrate post load reports or standard reports from S/4 HANA.


Business

Completeness

TaskAction

Verify Count

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


Accuracy

TaskAction

Conversion Accuracy

Verify that the Reference Functional Location data in target S/4 HANA were loaded correctly via dspMigrate post load reports or standard reports from S/4 HANA.


Key Assumptions

  • Data is in scope based on data design and any exception requested by business.
  • Data cleansing has met the required percentage threshold for the specified mock cycle and all preparation activities have been completed
  • No data enrichment is needed
  • Based on discussion with the business - the User Status in legacy will not be migrated over to S4
  • All Long Text will be migrated and defaulted to the language key of the plant
  • YA04 Order Type will not be migrated due to low volumes and handled by being closed in legacy as part of cleansing. Any Refurbishment order required would be created as new in S4. 
  • Notification missing for legacy open Work Orders will be migrated and assigned to the respective target Work Orders. The Notification for this scenario will be migrated with header information copied from the Target Work Orders
  • Settlement Rule is not in scope of migration for this CS
  • All outstanding reservations will be migrated (with outstanding quantity), PR to be recreated in S/4 for the outstanding quantity
  • Refurbishment orders using split valuation are not part of Mock 1 migration scope.

  • If Work Order has all three populated i.e Functional Location, Equipment and Assembly and if the Legacy Assembly is mapped to a Target Equipment (as per Value Mapping: Equipment) then this Equipment should be assigned on the Work Order.
  • Framework PO that are assigned to WO are not in scope
  • TECO WOs with Open POs with no reference object (Functional Location/ Equipment) will not be migrated. These will be cleansed.
  • Only one language keys exists for WO Header and Operation Long Text


See also

Change log

Change History
limit10

Workflow history

Workflow Report
parent@self
hideheadertrue
typeapprovals