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

Compare with Current View Page History

« Previous Version 127 Next »

Purpose

The purpose of this document is to define the conversion approach to create Work Order 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 acts as a detailed instruction, outlining tasks, required resources, parts, and schedules, while tracking costs, technical history, and compliance. 

Legacy Plant Maintenance Work order is using a diverse range of formats across the different systems. As per SyWay design, EAM Maintenance Work order will be standardized.


Conversion Scope

The scope of this document covers the approach for converting active Work Order from Legacy Source Systems into S/4HANA.

A work order in SAP is a formal document that authorises and tracks maintenance, repair, or production tasks within an organisation, containing essential details for effective task management. It 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: Assignment of personnel, tools, and materials needed for task completion
  • Dates: Scheduled start and finish dates to manage timelines
  • Costing: Estimates for labour, materials, and other expenditures linked to budget accounts
  • Priority & Status: Indicates urgency and tracks progress (e.g., created, released, completed, closed)
  • Operations: Step-by-step instructions or tasks within the work order.


The data from legacy system includes:

  • All open Work Orders (AUFK-AUFNR) with System Status (JEST-STAT) = Created (CRTD) or Released (REL).
  • Work Orders (AUFK-AUFNR) with System Status (JEST-STAT) = Technically Completed (TECO) and an open Purchase Order (EKKN-EBELN) assigned that is not flagged as Final Invoice (EKPO-EREKZ = '') or Final Delivery (EKPO-ELIKZ = '')
  • Work Orders with Maintenance Plant (IFLOT-WERKS) existing in Value Mapping: Plant (Maintenance Plant = Yes).
  • Work Orders assigned to active legacy Functional Locations (IFLOT-TPLR) ** (System Status TJ02T-TXT04 <> INAC) or Equipment (EQUI-EQUNR)
  • Work Orders generated from Maintenance Plan with Basic Start Date (AFKO-GSTRP) <= Business Continuity Date
  • A. Work Orders with no open PO, with Basic Start Date (AFKO-GSTRP) later than OTH_Migration_Date Relevant Values A2D - Cutover Start Date Offset (12 months) prior of the Migration / "Go-Live" Date
    B. Work Orders with no open PO, with Basic End Date (AFKO-GLTRP) later than OTH_Migration_Date Relevant Values A2D - Cutover End Date Offset (2 Weeks) prior of the Migration / "Go-Live" Date
    C. Work Orders with open PO, regardless of Basic Start (AFKO-GSTRP)/ Finish Date (AFKO-GLTRP)

The data from legacy system excludes:

  1. Work Orders with System Status (JEST-STAT) = Technically Completed (TECO) that do not meet Inclusion Criteria #2
  2. Work Orders with System Status (JEST-STAT) = Deletion Flag (DLFL) status
  3. Work Orders with System Status (JEST-STAT) = Closed (CLSD) status
  4. Work Orders with System Status (JEST-STAT) = Not Completed/ Do Not Execute (NCMP) status
  5. Standing Work Orders
  6. Work Orders (AUFK-AUFNR) which are Sub-orders (AFKO-MAUFNR <> '')
  7. Work Orders with blank Basic End Date (AFKO-GLTRP)
  8. Work Orders with Order type maintained in Work Order Type Exclusion List (EXC-Work Order Type)
  9. Work Orders with 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 hereExtract 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

100,000

S/4HANA 

100,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. 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
AFIHANLZUANLZUSystem ConditionCHAR1ConditionalConditionalConditional
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. Order Partner

TableFieldData ElementField DescriptionData TypeLengthRequirement
YA01 (Reactive Maintenance)
Requirement
YA02 (Proactive Maintenance)
Requirement
YA03 (Project Order)
AUFKAUFNRAUFNROrder NumberCHAR12MandatoryMandatoryMandatory
IHPAPARVWPARVWPartner FunctionCHAR2ConditionalConditionalConditional
IHPAPARNRPARNRPartnerCHAR12ConditionalConditionalConditional


3. Operation Data

TableFieldData ElementField DescriptionData TypeLengthRequirement
YA01 (Reactive Maintenance)
Requirement
YA02 (Proactive Maintenance)
Requirement
YA03 (Project Order)
AFVCAUFNRAUFNROrder 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
AFVCEQUNREQUNREquipmentCHAR18ConditionalConditionalConditional
AFVCTPLNRTPLNRFunctional LocationCHAR30ConditionalConditionalConditional
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
EBANKONNRKONNRAgreementCHAR10ConditionalConditionalConditional
EBANKTPNRKTPNRItemCHAR5ConditionalConditionalConditional
AFVCWEMPFWEMPFRecipientCHAR12ConditionalConditionalConditional
AFVCBEDNRBEDNRTracking NumberCHAR10ConditionalConditionalConditional
AFVCSORTLSORTLSort TermCHAR10ConditionalConditionalConditional
AFVCINFNRINFNRPurchasing Info RecordCHAR10ConditionalConditionalConditional
AFVCAFNAMAFNAMName of RequisitionerCHAR12ConditionalConditionalConditional
AFVCABLADABLADUnloading PointCHAR25ConditionalConditionalConditional
AFVVPLIFZPLIFZPlanned Delivery Time - DayNUMC3ConditionalConditionalConditional


 4. Operation Materials

TableFieldData ElementField DescriptionData TypeLengthRequirement
YA01 (Reactive Maintenance)
Requirement
YA02 (Proactive Maintenance)
Requirement
YA03 (Project Order)
AFVCAUFNRAUFNROrder NumberCHAR12MandatoryMandatoryMandatory
AFVCVORNRVORNROperation NumberCHAR4MandatoryMandatoryMandatory
RESBPOSNRPOSNRItem Number of ReservationNUMC4MandatoryMandatoryMandatory
RESBMATNRMATNRMaterialCHAR18ConditionalConditionalConditional
RESBPOTX1POTX1DescriptionCHAR40SystemSystemSystem
RESBPOSTPPOSTPItem CategoryCHAR1MandatoryMandatoryMandatory
RESBBDMNGBDMNGRequirement QuantityNUMC13MandatoryMandatoryMandatory
RESBMEINSMEINSUnitCHAR3MandatoryMandatoryMandatory
RESBNO_DISPNO_DISPReservation Relevance / Generation of Purchase RequisitionCHAR1SystemSystemSystem
RESBWERKSWERKSPlantCHAR4ConditionalConditionalConditional
RESBBDTERBDTERRequirements DateDATS8ConditionalConditionalConditional
RESBLGORTLGORTStorage LocationCHAR4ConditionalConditionalConditional
RESBCHARGCHARGBatchCHAR10ConditionalConditionalConditional
RESBGPREISGPREISPriceNUMC15ConditionalConditionalConditional
RESBPEINHPEINHPrice UnitNUMC5ConditionalConditionalConditional
RESBWAERSWAERSCurrencyCHAR15ConditionalConditionalConditional
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
RESBOPERATIONWORK
CENTERALIGNMENT
OPERATIONWORK
CENTERALIGNMENT
Align with Work Center IndicatorCHAR1ConditionalConditionalConditional


5. Operation Relationships

TableFieldData ElementField DescriptionData TypeLengthRequirement
YA01 (Reactive Maintenance)
Requirement
YA02 (Proactive Maintenance)
Requirement
YA03 (Project Order)
AFVCAUFNRAUFNROrder NumberCHAR12MandatoryMandatoryMandatory
AFVCVORNRVORNROperationCHAR4ConditionalConditionalConditional
AFVCAUFNRAUFNRAssigned OrderCHAR12ConditionalConditionalConditional
AFVCVORNRVORNRAssigned OperationCHAR4ConditionalConditionalConditional
AFABVORNCVORNCSuccessor IndicatorCHAR1ConditionalConditionalConditional
AFABAOBARAOBARType of RelationshipCHAR2ConditionalConditionalConditional
AFABDAUERDAUERTime IntervalNUMC5ConditionalConditionalConditional
AFABZEINHZEINHUnitCHAR3ConditionalConditionalConditional
AFABPRZNTPRZNTTime Interval %NUMC3ConditionalConditionalConditional
AFABPROVGPROVGTime Interval KeyCHAR1ConditionalConditionalConditional
AFABKALIDKALIDFactory CalendarCHAR2ConditionalConditionalConditional
CRHDARBPLARBPLWork CenterCHAR8ConditionalConditionalConditional
CRHDWERKSWERKSPlantCHAR4ConditionalConditionalConditional


6. Order Object List

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


 7. Order Confirmation

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


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

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 = '')Order No, Order Type, PlantPF2, WP2
9005-004C1Open Work Order with Blank Order Operation DescriptionWork Order (AFKO-AUFNR) based on the relevancy criteria and Blank Operation Short Text (AFVC-LTXA1 = '')

Order No, Order Type, Plant, Description, Operation/ Activity No

PF2, WP2
9005-005C1Open Work Order Operation with Blank Control KeyWork Order (AFKO-AUFNR) based on the relevancy criteria and Blank Control Key (AFVC-STEUS = '')Order No, Order Type, Plant, Description, Operation/ Activity NoPF2, WP2
9005-006C2Open Orders with Deleted Maintenance PlansWork Order (AFKO-AUFNR) based on the relevancy criteria having Maintenance Plan assigned (AFIH-WARPL is not Blank) and assigned Maintenance Plan is deleted (MPLA-LVORM = 'X')Order No, Order Type, Plant, Description, Operation/ Activity NoPF2, WP2
9005-007C2Open Work Orders with unmapped Maintenance Revision

Work Order (AFKO-AUFNR) based on the relevancy criteria and Maintenance Revision (AFIH-REVNR) missing in Maintenance Planning Bucket mapping.

Note- Business to perform either of the below
a) removing the Revision from the WO, or
b) replanning the WO, or
c) creating a new revision for the WO

Order No, Order Type, Plant, Description, Maintenance RevisionPF2, WP2
9005-008C3Info 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) having Items that are not flagged as Final Invoice (EKPO-EREKZ = '') or Final Delivery (EKPO-ELIKZ = '')Order No, Order Type, Plant, Description, Purchase Order No, Purchase Order ItemPF2, WP2
9005-009C3Info Report: Open Work Orders with Outstanding ReservationWork 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)Order No, Order Type, Plant, Description, Reservation No, Material No, Required Quantity, Withdrawal QuantityPF2, WP2
9005-010C3Info Report: Work Order not in scope for migration (not relevant)Work Order (AFKO-AUFNR) based on the relevancy criteria (Exclusion)Order No, Order Type, Plant, DescriptionPF2, WP2
9005-011C3Info Report: Work Orders with Technically Completed (TECO) status that have external services assignedWork Order (AFKO-AUFNR) based on the relevancy criteria (Exclusion) and having Purchase Order (EKKN-AUFNR is not Blank) and Purchase Order (EKKN-EBELN) having Service Items (EKPO-PSTYP = '9') which are not deleted (EKPO-LOEKZ ='')Order No, Order Type, Plant, Description, Purchase Order, Purchase Order ItemPF2, WP2
9005-012C3Info 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-013C3Info Report: Open Work Orders without a Technical Object (Functional Location/ Equipment/ Assembly) assignedWork 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 ='')Order No, Order Type, Plant, DescriptionPF2, WP2
9005-014C3Info Report: Open Work Orders with blank Basic End DateWork Order (AFKO-AUFNR) based on the relevancy criteria with Basic End Date (AFKO-GLTRP) = '00000000'Order No, Order Type, Plant, Description, Basic Start Date, Basic End DatePF2, WP2
9005-015C3Info Report: Open Work Orders maintained as Sub OrdersWork Order (AFKO-AUFNR) based on the relevancy criteria for which Superior Order exists (AFKO-MAUFNR is not Blank)Order No, Order Type, Plant, DescriptionPF2, WP2

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:

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. Order Header Data Construction Rules

Field NameField DescriptionRule
zLegacyAUFNRLegacy Order Number

Mandatory.

AUARTOrder Type

Mandatory.

Allowed values: 

YA01    Reactive Maintenance
YA02    Proactive Maintenance
YA03    Project Orders

KCHARDescription

Mandatory.

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

EQUNREquipment

Conditional.

Populate if the Asset being maintained is an Equipment

Value must exist in Equipment Mapping.

ILARTMaintenance Activity Type

Mandatory.

Needs to be selected from value list (T353I)

REVNRMaintenance Event Revision

Conditional.

Populate values if required from Maintenance Bucket - Maintenance Event DCT.

PROIDWBS Element (Acc Assignment)

Conditional.

  • Populate only for Project Work Orders 
  • Should exist in either WBS Element Number mapping or WBS DCT.

 

2. Order Operation Data Construction Rules

Field NameField DescriptionRule
AUFNRLegacy Order Number

Mandatory.

Key to link to Work Order

VORNRLegacy 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 meaningful description for the 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

STEUSControl Key

Mandatory.

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

Allowed values from T430 to be populated

SAKTOCost Element

Conditional.

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

Allowed values from CSKA to be populated

EKORGPurchasing Organisation

Conditional.

Populate Purchasing org responsible for procurement activities.

Allowed values from T024E to be populated

EKGRPPurchasing Group

Conditional.

Populate Buyer/group responsible for procurement.

Allowed values from T024 to be populated

MATKLMaterial Group

Conditional.

Populate Material Group for the required Materials/ Services. 

Allowed values from T023 to be populated

ANLZUSystem Condition

Conditional.

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

Allowed values from T357M to be populated

ARBEIWork

Mandatory.

Populate effort (e.g., labour hours) for the Operation (as per routing / order operation unit standards).

Numeric value only. Cannot be 0. 

INDETCalculation Key

Mandatory.

Allowed values: Select from the below list - 

Maintain manually
Calculate duration
Calculate work
Calculate number of capacities

ISTRUAssembly

Conditional.

Populate in information exists. 

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

Must start on
Cannot start before
Cannot start later
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 - 

Must finish on
Cannot finish before
Finish not later
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.

Allowed values from T006 to be populated

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 Value Mapping: Vendor Number 

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.


4. Order Materials Data Construction Rules  

Field NameField DescriptionRule
AUFNRLegacy Order Number

Mandatory.

Key to link to Work Order

VORNROperation Number

Mandatory.

Key to link to Work Order Operation

MATNRMaterial

Conditional

Populate with legacy Material number for the component line.

Value must exist in Value Mapping: Material Master

BDMNGQuantity

Conditional

Populate material quantity requested for the component line.

BDTERRequirements Date

Conditional

Populate component requirement date.

LGORTStorage Location

Conditional

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

Value must exist in Value Mapping: Storage Location

CHARGBatch

Conditional

Populate legacy batch if material is batch-managed. Otherwise, leave the field blank.

Value must exist in Value Mapping: Batch Class 023

GPREISPrice

Conditional

Populate price for the component/service line as applicable.

PEINHPrice Unit

Conditional

Number of units to which the price refers. 

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

Must be an integer value. Cannot be 0. 

EKORGPurchasing Organisation

Conditional.

Populate Purchasing org responsible for procurement activities.

Allowed values from T024E to be populated

EKGRPPurchasing Group

Conditional.

Populate Buyer/group responsible for procurement.

Allowed values from T024 to be populated

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 

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

Populate service performance start date where performance period is required.

ENDDATEService Performance End Date

Conditional

Populate service performance end date where required.

SERVICE
DURATION
Duration of Lean Service

Conditional

Populate duration value where applicable.

SERVICE
DURATIONUNIT
Duration Unit for a Lean Service

Conditional

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

Allowed values from T006 to be populated

COMMITMENTExpected Value

Conditional

Populate anticipated value for the Lean Service.

SUMLIMITOverall Limit

Conditional

Populate maximum expenditure value for the Lean Service. 


5. Operation Relationships Data Construction Rules  

Field NameField DescriptionRule
AUFNRLegacy Order Number (Successor)

Mandatory.

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

VORNRSuccessor Operation Number

Mandatory.

Populate with the successor operation number within the successor order.

AUFNRLegacy Order Number (Predecessor)Populate with the legacy predecessor order number to which the predecessor operation belongs.
VORNRPredecessor Operation Number

Mandatory.

Populate with the legacy predecessor operation number within the predecessor 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. 

Allowed values from T006 to be populated


6. Order Object List Data Construction Rules  

Field NameField DescriptionRule
AUFNRLegacy 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 mapping. 

EQUNREquipment

Conditional.

Populate with the legacy Equipment assigned to the order.

Value must exist in Equipment Mapping. 

MATNRMaterial

Conditional

Populate with the legacy Material assigned to the order.

Value must exist in Material Master Mapping. 

BAUTLAssembly

Conditional.

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


7. Order Confirmation Data Construction Rules  

Field NameField DescriptionRule
AUFNR

Legacy Order Number

Mandatory.

Key to link to Work Order

VORNR

Operation Number

Mandatory.

Key to link to Work Order Operation

ISMNWActual Work

Mandatory.

Populate the actual work quantity confirmed for the operation (e.g., labour hours).

AUERUFinal Confirmation

Conditional.

Populate ‘X’ when the operation is to be marked finally confirmed (no more confirmations expected). Else blank.

OFMNWRemaining work

Mandatory.

Populate remaining work still expected for the operation after this confirmation. If operation finally confirmed, set to 0 (or blank per design).

ISDDWork Start Date

Mandatory.

Populate the actual work start date for the confirmation.

ISDZWork Start Time

Mandatory.

Populate actual work start time for the confirmation.

IEDDWork Finish Date

Conditional.

Populate the actual work finish date for the confirmation.

IEDZWork Finish Time

Conditional.

Populate actual work finish time for the confirmation.


8. Order Long Text Line Data Construction Rules  

Field NameField DescriptionRule
AUFNR

Legacy Order Number

Mandatory.

Key to link to Work Order

ROWCOUNT

Row number

Mandatory.

Must be unique and ascending sequential number

TDSPRASLanguage Key

Mandatory.

Must be either one of the following: English(E) , French(F), Italian(I), Mandarin(1), Portuguese(including Brazilian Portuguese)(P), German(D) and Spanish(S)

TXLINE

Text Line

Conditional.

Free Text. Blanks are allowed


9. Order Operation Long Text Line Data Construction Rules 

Field NameField DescriptionRule
AUFNR

Legacy Order Number

Mandatory.

Key to link to Work Order

VORNR

Operation Number

Mandatory.

Key to link to Work Order Operation

ROWCOUNT

Row number

Mandatory.

Must be unique and ascending sequential number

TDSPRASLanguage Key

Mandatory.

Must be either one of the following: English(E) , French(F), Italian(I), Mandarin(1), Portuguese(including Brazilian Portuguese)(P), German(D) and Spanish(S)

TXLINE

Text Line

Conditional.

Free Text. Blanks are allowed

Extraction Dependencies

Item #Step DescriptionTeam Responsible

1

Ensure Syniti has the necessary connection and access to legacy servers 

SyWay A2D Data Team

2

Ensure that the necessary cleansing activities in legacy sources are complete 

SyWay A2D Data Team / Business 

3

Ensure that create, change and deletion of master data is freeze in legacy Production system 

Legacy IT 

4

Equipment and Functional Location Master Data need to be first with their respective relevancy rules applied before Work Order can be extracted 

SyWay A2D Data Team


Transformation

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

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

Transformation Run Sheet

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

Generate Load Files

SyWay A2D Data Team


Transformation Rules

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








2








3








4








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

Transformation Mapping

Mapping Table NameMapping Table Description

IFLOT

Functional Locations

T003O

Order Type & Priority

TQ80

Notification Type

EQUI

Equipment

CRHD

Work Centres

CSKU

Cost Centre

xtTPLNR

Xref for functional location. Fields: zLegacyTPLNR, TPLNR

xtEQUNR

Xref for equipment number. Fields: zLegacyEQUNR, EQUNR

xtARBPL

Xref for Work Centre. Fields: zLegacyARBPL, ARBPL

Purchase Order Number

EBELN_PURCH: Old Purchase Order number to New Purchase Order number

Transformation Dependencies

List the steps that need to occur before transformation can commence
Item #Step DescriptionTeam Responsible
1Ensure DCT tables completenessSyWay A2D Data Team
2Value Mappings are according to the latest design - <List of Value Mappings>SyWay A2D 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 legacy systems and DCTs (if any) is equal to the total number of records in the Preload and Load Sheets.

Verify Data Integrity

SyWay A2D Data Team to verify that the total number of Operations per Work Oder header extracted from legacy systems and DCTs (if any) should be equal to the total number of operations identified 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 legacy systems and DCTs (if any) is equal to the total number of records in the Preload and Load Sheets.


Accuracy

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


Load

The load process includes:

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

Load Run Sheet

Item #Step DescriptionTeam Responsible
1

Obtain DCT Sign-off from Business

SyWay A2D Data Team

2Syniti will provide load fileSyniti
3Go to <Load Tool>SyWay A2D Data Team/Syniti
4Load 3 records for Work Order for function (IW31) to validate if data is loaded successfully without errorsSyWay A2D Data Team/Syniti
5Proceed with full load if step 4 is validatedSyWay A2D Data Team/Syniti
6Validate few records loaded by accessing standard transactions from S/4HNA E.g. IW39SyWay A2D Data Team/Syniti
7Generate post load report if step 6 is validatedSyWay A2D Data Team/Syniti


Load Phase and Dependencies

Configuration

Item #Configuration Item
1

Order Type

Conversion Objects

Object #Preceding Object Conversion Approach

9003

Revision

1030

Work Centre

1002

Equipment

1003

Functional Location

1026

WBS - CAPEX, OPEX, Statistical

1074

Cost Centre

1073

Profit Centre

3018

Vendor

2019

Material

1010

Assembly

1094

Purchase Info Records (Including Pricing Conditions)

1067

GL Account Operational CoA (incl. secondary CE)

Error Handling

Error TypeError DescriptionAction Taken

Invalid Data

Invalid data (Based on master data)

Expedite whether the master data is available in the system

Invalid Data

Invalid data (Based on non master data)

Review and analyses the errors. Take necessary action to correct the data if possible.

Configuration

Invalid Order Type

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


See also

Change log

Version Published Changed By Comment
CURRENT (v. 127) Apr 29, 2026 13:34 ERGUIZA-ext, Pinky Love
v. 357 Apr 29, 2026 10:38 ERGUIZA-ext, Pinky Love
v. 356 Apr 29, 2026 10:32 ERGUIZA-ext, Pinky Love
v. 355 Apr 29, 2026 10:29 ERGUIZA-ext, Pinky Love
v. 354 Apr 29, 2026 05:58 ERGUIZA-ext, Pinky Love
v. 353 Apr 27, 2026 08:22 ERGUIZA-ext, Pinky Love
v. 352 Apr 27, 2026 08:19 ERGUIZA-ext, Pinky Love
v. 351 Apr 27, 2026 08:19 ERGUIZA-ext, Pinky Love
v. 350 Apr 27, 2026 08:18 ERGUIZA-ext, Pinky Love
v. 349 Apr 27, 2026 08:16 ERGUIZA-ext, Pinky Love

Go to Page History

Workflow history

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

  • No labels