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

Compare with Current View Page History

« Previous Version 27 Next »

Status

  Revision in Progress

Owner
Stakeholders

Purpose

The purpose of this document is to define the conversion approach to create Work Order in S/4 HANA.

Legacy Plant Maintenance Work order is using a diverse range of formats across the different systems. There are instances where the same Work order is duplicated within and/or across sources, with informal words. This results in data inconsistency. 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 authorizes and tracks maintenance, repair, or production tasks within an organization, containing essential details for effective task management.

Work orders in SAP serves as a crucial component of the Plant Maintenance (PM) module within the SAP ERP system. 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.

Work orders play a vital role in coordinating work activities, optimizing resource utilization, and ensuring compliance with regulatory standards and organizational policies. They are generated based on maintenance strategies, including preventive maintenance schedules and corrective maintenance requests. This helps organizations effectively manage their maintenance tasks and production processes.

The data from legacy system includes:

  1. Open Work Orders - Outstanding; In Process (Historical for Selected Equipment Type)

The data from legacy system excludes:

  1. Open Work Order older than 1 month (based on Creation Date)

    Exception:

    Orders with Technically Completed (TECO) status that have external services assigned – to be manually reviewed by the Business

  2. Open Priority Work Orders older than 2 weeks (based on Creation Date)
  3. Work order with user status DUPL or CANC


List of source systems and approximate number of records
SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2, WP2

An initial extract will be provided to business to evaluate.

Additional data/records may be required and these will be constructed via DCT.

Enrichment of in-scope data may be required and will be added via transformation rules (business/technical).

140,000

S/4HANA 

140,000

Additional Information

Multi-language Requirement

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

Document Management

Long text and DIR are not covered in this document as they are defined as another data object.

Legal Requirement

Not Applicable

Special Requirements




Target Design

The technical design of the target for this conversion approach.

  1. General Data (mandatory)
TableFieldData ElementField DescriptionData TypeLengthRequirement
AUFKAUFNR
Order Number

CHAR

12Mandatory
AUFKAUART
Order Type

CHAR

4Mandatory
AUFKKTEXT
DescriptionText40
STXHLONG_TEXT
Long TextTextunrestricted
AFVCPPRIO
PriorityText80
AUFKSDATE
Required Start DateDate


BASICSTART
Required Start TimeTime


FINISH_DATE
Required End DateDate


BASIC_FIN
Required End TimeTime


LACD_DATE
Final Due DateDate


FUNCT_LOC
Technical Object (Functional Location)Text80

EQUIPMENT
Technical Object (Equipment)Text80

ASSEMBLY
AssemblyText80

SYSTCOND
System ConditionText80

NOTIF_NO
Assigned NotificationText80

PMACTTYPE
Maintenance Activity TypeText80

MN_WK_CTR
Work CenterText80Mandatory

PLANT
Work Center PlantText80

PLANPLANT
Planning PlantText80Mandatory

PLANGROUP
PlangroupText80

LOC_WK_CTR
Production Work CenterText80

MAINTPLANT
Maintenance PlantText80

LOCATION
LocationText80

MAINTROOM
RoomText8

PLSECTN
Plant SectionText80

LOC_COMP_CODE
Company CodeText80

LOC_WBS_ELEM
WBS Element (Acc Assignment)Text80

COSTCENTER
Cost CenterText80

RESPCCTR
Responsible Cost CenterText80

WBS_ELEM
Planning WBS ElementText80

OBJECTCLASS
Object ClassText80

PROFIT_CTR
Profit CenterText80
     2. Phase Control
TableFieldData ElementField DescriptionData TypeLengthRequirement

ORDERID
Legacy Order NumberText80Mandatory

EAMBLOCKERCODE
Phase Control CodeText80Mandatory

CODEACTIVE
Set Automatically IndicatorText1

     3. Organizational Data - Partners

TableFieldData ElementField DescriptionData TypeLengthRequirement

ORDERID
Legacy Order NumberText80Mandatory

PARTN_ROLE
Partner FunctionText80Mandatory

PARTNER1
PartnerText80Mandatory

     4. Operation Data (mandatory)

TableFieldData ElementField DescriptionData TypeLengthRequirement

ORDERID
Legacy Order NumberText80Mandatory

ACTIVITY
Operation/ActivityText4Mandatory

SUB_ACTIVITY
SuboperationText4

DESCRIPTION
Operation DescriptionText40

LONG_TEXT
Long TextTextunrestricted

WORK_CNTR
Work CenterText80Mandatory

PLANT
Work Center PlantText80Mandatory

PERS_NO
Person ResponsibleText80

CONTROL_KEY
Control KeyText80Mandatory

PRICE
PriceNumber13

CURRENCY
CurrencyText80

COST_ELEMENT
Cost ElementText80

PURCH_ORG
Purchasing OrganizationText80

PUR_GROUP
Purchasing GroupText80

MATL_GROUP
Material GroupText80

SYSTCOND
System ConditionText80

ACTTYPE
Activity TypeText80

WORK_ACTIVITY
WorkNumber7

UNIT
Work UnitText80

CALC_KEY
Calculation KeyText80

DURATION_NORMAL
DurationNumber5

UNIT1
Duration UnitText80

EQUIPMENT
Technical Object (Equipment)Text80

FUNCT_LOC
Technical Object (Functional Location)Text80

PERCENT_OF_WORK
Work Percentage - %Number3

ASSEMBLY_LONG
AssemblyText80

NUMBER_OF_CAPACITIES1
Required CapacitiesNumber3

EXECUTION_STAGE
Execution StageText80

MAINTENANCE_ACTIVITY_TYPE1
Maintenance Activity TypeText80

QUANTITY1
Operation QuantityNumber13

BASE_UOM1
UnitText80

PRICE_UNIT
Price UnitNumber5

VENDOR_NO
VendorText80

AGREEMENT
AgreementText80

AGMT_ITEM
ItemNumber5

GR_RCPT
RecipientText12

TRACKINGNO
Tracking NumberText10

SORT_FLD
Sort TermText10

INFO_REC
Purchasing Info RecordText80

PREQ_NAME
Name of RequisitionerText12

UNLOAD_PT
Unloading PointText25

PLND_DELRY
Planned Delivery Time - DayNumber3

AVON
Note (Text ID - AVON)Textunrestricted

AVOD
Remark (Text ID - AVOD)Textunrestricted

AVOC
Comment (Text ID - AVOC)Textunrestricted

      5. Operation Data - Phase Control

TableFieldData ElementField DescriptionData TypeLengthRequirement

ORDERID
Legacy Order NumberText80Mandatory



Operation/ActivityText4Mandatory



SuboperationText4



Phase Control CodeText80Mandatory



Set Automatically IndicatorText1

     6. Operation Data - Materials

TableFieldData ElementField DescriptionData TypeLengthRequirement

ORDERID
Legacy Order NumberText80Mandatory

ACTIVITY
Operation NumberText4Mandatory

SUB_ACTIVITY
SuboperationText4

RES_ITEM
Item Number of ReservationNumber4Mandatory

MATERIAL
MaterialText80

MATL_DESC
DescriptionText40

LONG_TEXT
Long TextTextunrestricted

ITEM_CAT
Item CategoryText80

PRODUCT_TYPE
Product Type GroupText80

REQUIREMENT_QUANTITY
QuantityNumber13

REQUIREMENT_QUANTITY_UNIT
UnitText80

MRP_RELEVANT
Reservation/Purc. ReqText80

PLANT
PlantText80

REQ_DATE
Requirements DateDate


MANUAL_REQ_DATE
Manual Reqmt Date IndicatorText1

STGE_LOC
Storage LocationText80

BATCH
BatchText80

PRICE
PriceNumber15

PRICE_UNIT
Price UnitNumber5

CURRENCY
CurrencyText80

PURCH_ORG
Purchasing OrganizationText80

PUR_GROUP
Purchasing GroupText80

VENDOR_NO
SupplierText80

INFO_REC
Purchasing Info RecordText80

MATL_GROUP
Material GroupText80

GL_ACCOUNT
G/L AccountText80

GR_RCPT
Goods RecipientText12

UNLOAD_PT
Unloading PointText25

STARTDATE
Service Performance Start DateDate


PERFORMANCEPERIODSTARTTIME
Service Performance Start Time (UTC)Time


ENDDATE
Service Performance End DateDate


PERFORMANCEPERIODENDTIME
Service Performance End Time (UTC)Time


SERVICEDURATION
Duration of Lean ServiceNumber5

SERVICEDURATIONUNIT
Duration Unit for a Lean ServiceText80

EXPECTEDOVERALLLIMITAMOUNT
Expected ValueNumber13

OVERALLLIMITAMOUNT
Overall LimitNumber13

OPERATIONWORKCENTERALIGNMENT
Align with Work Center IndicatorText1

      7. Operation Data - Relationships

TableFieldData ElementField DescriptionData TypeLengthRequirement

ORDERID
Legacy Order NumberText80Mandatory

ACTIVITY
Legacy OperationText4Mandatory

ORDER_PREDECESSOR
Assigned OrderText80

OPERATION_PREDECESSOR
Assigned OperationText4Mandatory

NCHKZ
Successor IndicatorText1

RELATION_TYPE
Type of RelationshipText80Mandatory

DURATION_RELATION
Time IntervalNumber5

DURATION_RELATION_UNIT
UnitText80

PERCENT_OF_SUCCESSOR
Time Interval %Number3

DURATION_KEY
Time Interval KeyText80

FACTORY_CALENDAR
Factory CalendarText80

WORK_CNTR
Work CenterText80

PLANT
PlantText80

     8. Operation Data - PRT

TableFieldData ElementField DescriptionData TypeLengthRequirement

ORDERID
Legacy Order NumberText80Mandatory

ACTIVITY
Operation NumberText4Mandatory

ITEM_NO_OF_PRODUCTION_RESOURCE
PRT Item NumberNumber4Mandatory

DESCRIPTION
PRT Item TextText40

PRT_CATEGORY
CategoryText80Mandatory

PRT_PLANT
PlantText80

MATERIAL_LONG
Number (Material)Text80

MISCELLANEOUS
Number (Miscellaneous)Text80

STD_VALUE_FOR_PRT_QTY
QuantityNumber9Mandatory

PRT_USAGE_QUANTITY_SUM_UNIT
Quantity UnitText80

CTRL_KEY
Control KeyText80Mandatory

     9. Object List

TableFieldData ElementField DescriptionData TypeLengthRequirement

ORDERID
Legacy Order NumberText80Mandatory

COUNTER
CounterNumber10Mandatory

SORTFIELD
SortText20

FUNCT_LOC
Technical Object (Functional Location)Text80

EQUIPMENT
Technical Object (Equipment)Text80

SERMAT_LONG
MaterialText80

SERIALNO
Serial NumberText80

NOTIF_NO
NotificationText80

ASSEMBLY_LONG
AssemblyText80

ACTIVITY
Assignment to OperationsText4

SUB_ACTIVITY
Assignment to SuboperationsText4

      10. Costs

TableFieldData ElementField DescriptionData TypeLengthRequirement

ORDERID
Legacy Order NumberText80Mandatory

VALUE_CATEGORY
Cost CategoryText80Mandatory

COSTS_EST
Estimated CostsNumber15Mandatory

CURRENCY
CurrencyText80Mandatory

     11. Costs - Settlement Rules

TableFieldData ElementField DescriptionData TypeLengthRequirement

ORDERID
Legacy Order NumberText80Mandatory

EXTNR
Distribution Rule NumberNumber3Mandatory

COMP_CODE
Company CodeText80

ACTIVITY
Operation/ActivityText4

COSTCENTER
Settlement Receiver (Cost Center)Text80

ORDERID2
Settlement Receiver (Order)Text80

WBS_ELEMENT
Settlement Receiver (WBS Element)Text80

ASSET_NO
Settlement Receiver (Asset)Text80

SETTL_TYPE
Settlement TypeText80Mandatory

PERCENTAGE
Settlement Percentage Rate - %Number5Mandatory

  

Data Cleansing

IDCriticalityError Message/Report DescriptionRuleOutputSource System

9005-001

C1 

Invalid or Inactive Equipment or Functional Location linked to Work Order 

Work Order as per Relevancy Criteria assigned with an Equipment / Functional which does not belong below:
1. Equipment as per Relevancy Criteria
2. Functional Location as per Relevancy Criteria 

The criteria for this report includes all Work Orders with system status not CRTD and not TECO 

Equipment, Functional Location 

PF2, WP2 

9005-002

C1

Invalid or Inactive Activity Type linked to Work Order 

Work Order as per Relevancy Criteria assigned with an Activity Type which does not belong below:
1. Activity Type (FI) as per Relevancy Criteria 

Activity Type 

PF2, WP2 

9005-003

C1

Invalid or Inactive Business Partner (Employee Personnel) linked to Work Order 

Work Order as per Relevancy Criteria assigned with a Business Partner (Employee Personnel) which does not belong below:
1. Business Partner (Employee Personnel) as per Relevancy Criteria 

Business Partner (Employee) 

PF2, WP2 

9005-004

C1 

Invalid or Inactive Cost Centre linked to Work Order 

Work Order as per Relevancy Criteria assigned with a Cost Centre which does not belong below:
1. Cost Centre (FI) as per Relevancy Criteria 

Cost Centre 

PF2, WP2 

9005-005

C1 

Invalid or Inactive Maintenance Item linked to Work Order 

Work Order as per Relevancy Criteria assigned with a Maintenance Plan and Item which does not belong below:
1. Maintenance Plan and Item as per Relevancy Criteria 

Maintenance Item 

PF2, WP2 

9005-006

C1 

Invalid or Inactive Material linked to Work Order 

Work Order as per Relevancy Criteria assigned with a Material which does not belong below:
1. Material Master (S2P) as per Relevancy Criteria 

Material 

PF2, WP2 

9005-007

C1 

Invalid or Inactive Notification linked to Work Order

Work Order as per Relevancy Criteria assigned with a Notification which does not belong below:
1. Notification as per Relevancy Criteria 

Notification 

PF2, WP2 

9005-008

C1 

Invalid or Inactive Production Resources & Tool linked to Work Order 

Work Order as per Relevancy Criteria assigned with a Production Resources & Tool which does not belong below:
1. Production Resources & Tool as per Relevancy Criteria 

Production Resources & Tool 

PF2, WP2 

9005-009

C1 

Invalid or Inactive Profit Centre linked to Work Order

Work Order as per Relevancy Criteria assigned with a Profit Centre which does not belong below:
1. Profit Centre (FI) as per Relevancy Criteria 

Profit Centre 

PF2, WP2 

9005-010

C1 

Invalid or Inactive Revision linked to Work Order 

Work Order as per Relevancy Criteria assigned with a Revision which does not belong below:
1. Revision as per Relevancy Criteria 

Revision 

PF2, WP2 

9005-011

C1 

Invalid or Inactive Standard Text linked to Work Order

Work Order as per Relevancy Criteria assigned with a Standard Text which does not belong below:
1. Standard Text as per Relevancy Criteria 

Standard Text 

PF2, WP2 

9005-012

C1 

Invalid or Inactive Task List linked to Work Order 

Work Order as per Relevancy Criteria assigned with a Task List which does not belong below:
1. Task List as per Relevancy Criteria 

Task List 

PF2, WP2 

9005-013

C1 

Invalid or Inactive WBS linked to Work Order 

Work Order as per Relevancy Criteria assigned with a WBS which does not belong below:
1. Work Breakdown Structure (PS) as per Relevancy Criteria 

Work Breakdown Structure 

PF2, WP2 

9005-014

C1 

Invalid or Inactive Work Centre linked to Work Order 

Work Order as per Relevancy Criteria assigned with a Work Centre which does not belong below:
1. Work Centre as per Relevancy Criteria 

Work Centre 

PF2, WP2 

9005-015

C1 

Invalid, Inactive or no Fixed Asset linked to Work Order 

Work Order as per Relevancy Criteria assigned with a Fixed Asset which does not belong below:
1. Fixed Asset (FI) as per Relevancy Criteria 

Fixed Asset 

PF2, WP2 

9005-016

C1 

Work Orders technically completed but with Open Commitments (POs not closed, Open reservations, Open PR) 

TBD 

Work Order, Status 

PF2, WP2 

9005-017

C2

Open Work Orders older than 1 month

Open Work Orders older than 12 months 

Creation Date, Status 

PF2, WP2 

9005-018

C2 

Open Priority Work Orders older than 2 weeks

Open Work Orders older than 3 months with Priority as follows:
0: Call in
1: Urgent (<=1 day)
2: Urgent (<=3 days) 

Creation Date, Status, Priority 

PF2, WP2 

9005-019

C1 

Notification Storage Location incorrect. 

Notificationas per Relevancy Criteria with Invalid Storage Location (T001L) 

Storage Location 

PF2, WP2 

9005-020

C1 Work Order Plant incorrect.Work Order as per Relevancy Criteria with Invalid Plant (T001W)PlantPF2, WP2 

9005-021

C1 

Work Order UOM Missing / incorrect. 

Work Order as per Relevancy Criteria with no UoM Assigned or Invalid UoM (T006) 

Unit of Measure 

PF2, WP2 

9005-022

C1 

Work Order Purchasing Groups incorrect. 

Work Order as per Relevancy Criteria with Invalid Purchasing Group (T024) 

Purchasing Group 

PF2, WP2 

9005-023

C1 

Work Order Purchasing Organization incorrect. 

Work Order as per Relevancy Criteria with Invalid Purchasing Organization (T024E) 

Purchasing Organization 

PF2, WP2 

9005-023

C2

Work Order Planning Plant and Maintenance Plant are not the same. 

Work Order as per Relevancy Criteria with Planning Plant <> Maintenance Plant 

Maintenance Plant, Planning Plant 

PF2, WP2 

9005-024

C2

Work Order Description contains Thai characters

Work Order Description contains Thai characters

Description

PF2, WP2 

For reference: SyWay_Cleansing and Historical Scope - A2D


Informal Words **

Group 1

Group 2

Group 3

Group 4

Group 5

*DNU

Delete

donot

Formerly

Old #

..

Deletion

DONT USE

From

Old[ ]

/

DELISTED

DON'T USE

Incorrect

PLEASE USE

?

Discontinued

Dup Use

Invalid

Pls Use

@

Disposable

DUPLICATE

New

Previously

^

DNU

-DUPLICATE

NOT ACTIVE

Replace

+

Do Not

DUPLICATION

not in use

Replaced

++

Do Not Re

Duplicidad

Not Used

RESERVED

£

Do Not Sell

Duplikat

NOT VALID

Retired

Defective

Do Not Use

Former

Obsolete

ZZDEL

Conversion Process

Conversion will involve both Source System Extraction as well as using DCT (Data Collection Template) - 

The high-level process for Source System Extraction is represented by the diagram below:

For sites that are not on SAP-PF2 and WP2 systems, collection will be done manually in the data collection template.

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


Data Privacy and Sensitivity


Extraction

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

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

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

Extraction Run Sheet

Req #Requirement DescriptionTeam Responsible
1Extract data from source system based on relevancy ruleSyWay Data Team
2Apply relevancy on extracted dataSyWay Data Team
3Google Sheet report pre-populated with PF2 and WP2 information to be generated based on relevancy criteria. SyWay 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 Work Order data with exception of some fields which require transformation as mentioned in the transformation rule.

Work Order DCT Rules

  1. AUFK - Work Order main table
Field NameField DescriptionRule
AUFNROrder Number


AUARTOrder Type


KTEXTDescription
LONG_TEXTLong Text
PPRIOPriority
SDATERequired Start Date
BASICSTARTRequired Start Time
FINISH_DATERequired End Date
BASIC_FINRequired End Time
LACD_DATEFinal Due Date
FUNCT_LOCTechnical Object (Functional Location)
EQUIPMENTTechnical Object (Equipment)
ASSEMBLYAssembly
SYSTCONDSystem Condition
NOTIF_NOAssigned Notification
PMACTTYPEMaintenance Activity Type
MN_WK_CTRWork Center
PLANTWork Center Plant
PLANPLANTPlanning Plant
PLANGROUPPlangroup
LOC_WK_CTRProduction Work Center
MAINTPLANTMaintenance Plant
LOCATIONLocation
MAINTROOMRoom
PLSECTNPlant Section
LOC_COMP_CODECompany Code
LOC_WBS_ELEMWBS Element (Acc Assignment)
COSTCENTERCost Center
RESPCCTRResponsible Cost Center
WBS_ELEMPlanning WBS Element
OBJECTCLASSObject Class
PROFIT_CTRProfit Center


       2. AFKO- Work Order header table

Field NameField DescriptionRule
AUFNROrder Number
GLTRPBasic finish date
GSTRPBasic Start Date
FTRMSScheduled release date
GLTRSScheduled finish
GSTRSScheduled start
GSTRIActual start date
GETRIConfirmed Order Finish Date
GLTRIActual finish date
FTRMIActual release date
FTRMPPlanned release date
RSNUMNumber of Reservation/Dependent Requirement
GASMGTotal scrap quantity in the order
GAMNGTotal order quantity
GMEINBase Unit of Measure
PLNBEZMaterial Number
PLNTYTask List Type
PLNNRKey for Task List Group
PLNAWApplication of the task list
PLNALGroup Counter
PVERWTask list usage
PLAUFDate for routing transfer
PLSVBTo lot size
PLNMETask list unit of measure
PLSVNFrom Lot Size
PDATVValid-From Date
PAENRChange Number
PLGRPResponsible planner group/department
LODIVLot size divisor
STLTYBOM category
STLBEZMaterial Number
STLSTBOM status
STLNRBill of material
SDATVValid-From Date
SBMNGBase quantity
SBMEHBase Unit of Measure
SAENRChange Number
STLALAlternative BOM
STLANBOM Usage
SLSVNFrom Lot Size
SLSBSTo Lot Size
AUFLDDate of BOM Explosion/Routing Transfer
DISPOMRP controller for the order
AUFPLRouting number of operations in the order
FEVORProduction Supervisor
FHORIScheduling Margin Key for Floats
TERKZScheduling type
REDKZReduction indicator for scheduling
APRIOOrder priority
NTZUESuperior network number
VORUESuperior activity
PROFIDNetwork profile
VORGZFloat before production (in days)
SICHZFloat after production (in days)
FREIZRelease period (in days)
UPTERIndicator: Change to Scheduled Dates
BEDIDID of the capacity requirements record
PRONRProject definition
ZAEHLInternal counter
MZAEHLInternal counter
ZKRIZCounter for additional criteria
PRUEFLOSInspection Lot Number
KLVARPCosting variant for planned costs
KLVARICosting variant for actual costs
RGEKZIndicator: Backflushing for order
PLARTBasis for scheduling
FLG_AOBIndicator: relationships
FLG_ARBEIIndicator: Default value work is relevant
GLTPPFinish date (forecast)
GSTPPForecast start date
GLTPSScheduled forecast finish
GSTPSScheduled forecast start
FTRPSScheduled release date (forecast)
RDKZPReduction indicator for scheduling (forecast)
TRKZPScheduling type (forecast)
RUECKCompletion confirmation number for the operation
RMZHLInternal counter
IGMNGYield confirmed from order confirmation
RATIDID of the capacity requirements record
GROIDID of the capacity requirements record
CUOBJConfiguration (internal object number)
GLUZSScheduled finish time
GSUZSScheduled Start (Time)
REVLVRevision Level
RSHTYObject types of the CIM resource
RSHIDObject ID of the resource
RSNTYObject types of the CIM resource
RSNIDObject ID of the resource
NAUTERMIndicator: Do not schedule automatically
NAUCOSTIndicator: Do not cost automatically
STUFELevel (in multi-level BOM explosions)
WEGXXPath (for multi-level BOM explosions)
VWEGXPath (for multi-level BOM explosions)
ARSNRNumber of Reservation/Dependent Requirement
ARSPSOrder Item Number
MAUFNRNumber of superior order
LKNOTLeft node in collective order
RKNOTRight node of a collective order
PRODNETIndicator: Order is part of collective order
IASMGScrap confirmed for order
ABARBConfirmation: Degree of processing
AUFNTNumber of superior network
AUFPTRouting number of operations in the order
APLZTGeneral counter for order
NO_DISPEffective for Materials Planning
CSPLITApportionment Structure
AENNRChange Number
CY_SEQNRSeq. number order
BREAKSIndicator: Scheduling allowing for breaks
VORGZ_TRMScheduled float before production in days
SICHZ_TRMScheduled float after production in days
TRMDTDate of the last scheduling
GLUZPBasic finish (time)
GSUZPBasic start time
GSUZIActual start time
GEUZIConfirmed order finish (time)
GLUPPForecast finish (time)
GSUPPForecast start (time)
GLUPSScheduled forecast finish time
GSUPSScheduled start time (Forecast)
CHSCHSearch procedure for batch determination
KAPT_VORGZFloat (bef. production) remaining after finite scheduling
KAPT_SICHZRemaining float after finite scheduling
LEAD_AUFNRLeading order in current processing
PNETSTARTDOutline start of collective network (date)
PNETSTARTTStart time of a collective order
PNETENDDOutline finish of collective order (date)
PNETENDTOutline finish time
KBEDInd: do not create capacity requirements
KKALKRIndicator: Components will not be costed
SFCPFProduction Scheduling Profile
RMNGATotal confirmed rework quantity
GSBTROverall commitment date
VFMNGCommitted quantity for order acc. to ATP check components
NOPCOSTDo not calculate planned costs for order
NETZKONTIndicator for the account assignment of a network(hdr/act.)
ATRKZRequest ID
OBJTYPEChange indicator
CH_PROCProcess that has lead to the change of an object
KAPVERSAVersion of Available Capacity
COLORDPROCCollective order with/without automatic goods movement
KZERBIndicator: Project summarization via master data charact.
CONF_KEYIdentical object
ST_ARBIDObject ID
VSNMR_VSales document version number
TERHWScheduling note from order scheduling
SPLSTATStatus of an order in a split hierarchy
COSTUPDCosts are updated
MAX_GAMNGMaximum Value of Total Order Quantity After Distribution
MES_ROUTINGIDKey of a Routing from an ME System
.INCLU--AP

ADPSPPM/PS Reference Element
RMANRSales and Distribution Document Number
POSNR_RMAItem number of the SD document
POSNV_RMAItem number of the SD document
CFB_MAXLZMaximum Storage Period
CFB_LZEIHUnit for maximum storage period
CFB_ADTDAYSAdditional Days
CFB_DATOFMDate of Manufacture
CFB_BBDPIBest-Before Date (BBD)/ Shelf Life Expiration Date (SLED)
OIHANTYPExcise Duty Handling Type
.INCLU--AP

MILL_RATIOFactor for Quantity-Based Settlement
.INCLU--AP

BMEINSBase Unit of Measure
BMENGEBase quantity
MILL_OC_ZUSKZCombination Indicator


       3. AFVC - Work Order operation table

Field NameField DescriptionRule
AUFPLRouting number of operations in the order
APLZLGeneral counter for order
PLNFLSequence
PLNKNNumber of the task list node
PLNALGroup Counter
PLNTYTask List Type
VINTVIncrement between referenced operations
PLNNRKey for Task List Group
ZAEHLInternal counter
VORNROperation/Activity Number
STEUSControl key
ARBIDObject ID of the resource
PDESTPrinter for shop papers
WERKSPlant
KTSCHStandard text key
LTXA1Operation short text
LTXA2Second line of the description
TXTSPLanguage Key
VPLTYType of the referenced task list
VPLNRGroup of the referenced task list
VPLALGroup counter of the referenced task list
VPLFLReferenced sequence in routing
VGWTSStandard value key
LAR01Activity Type
LAR02Activity Type
LAR03Activity Type
LAR04Activity Type
LAR05Activity Type
LAR06Activity Type
ZERMAType of standard value calculation
ZGDATDate when the standard value was calculated
ZCODEReference number for standard value code
ZULNRBasis for standard value calculation
LOANZNumber of Time Tickets
LOARTWage Type
RSANZNumber of confirmation slips
QUALFSuitability
ANZMANumber of employees
RFGRPSetup group category
RFSCHSetup group key
RASCHSetup Type Key
AUFAKScrap factor
LOGRPWage group
UEMUSRequired overlapping
UEKANOptional overlapping
FLIESIndicator: continuous flow production
SPMUSRequired splitting
SPLIMMaximum number of splits
ABLIPKZIndicator: simultaneous teardown and wait
RSTRAReduction strategy per operation/activity
SUMNRNode number of the superior operation
SORTLSort Term for Non-Stock Info Records
LIFNRAccount Number of Vendor or Creditor
PREISPrice
PEINHPrice Unit
SAKTOCost Element
WAERSCurrency Key
INFNRNumber of Purchasing Info Record
ESOKZPurchasing info record category
EKORGPurchasing Organization
EKGRPPurchasing group for external processing
KZLGFIndicator: fixed lot external processing
KZWRTFIndicator: Fixed price for external processing
MATKLMaterial Group
DDEHNIndicator: flexible duration
ANZZLNumber of capacities required
PRZNTWork percentage
MLSTNUsage
PPRIOPriority
BUKRSCompany Code
ANFKORequesting cost center
ANFKOKRSControlling area of the requesting cost center
INDETKey for calculation
LARNTActivity Type
PRKSTCosts in the activity
APLFLSequence
RUECKCompletion confirmation number for the operation
RMZHLConfirmation counter
PROJNWork breakdown structure element (WBS element)
OBJNRObject number
SPANZActual number of splits
BEDIDID of the capacity requirements record
BEDZLInternal counter
BANFNPurchase requisition number
BNFPOItem number of the purchase requisition in the order
LEK01Indicator: No remaining activity expected
LEK02Indicator: No remaining activity expected
LEK03Indicator: No remaining activity expected
LEK04Indicator: No remaining activity expected
LEK05Indicator: No remaining activity expected
LEK06Indicator: No remaining activity expected
SELKZSelection indicator for costing line items
KALIDFactory Calendar
FRSPEarliest possible activity / Latest possible activity
STDKNNode of operation within reference operation set
ANLZUSyst.Condition
ISTRUAssembly
ISTTYBOM category
ISTNRBill of material
ISTKNBOM item node number
ISTPOInternal counter
IUPOZSubitem Number
EBORTInstallation Point for Subitem
VERTLDistr.cap.reqmts (plant maint.,process order, network)
LEKNWIndicator: No Remaining Work Expected
NPRIOPriority
PVZKNGeneral counter for order
PHFLGIndicator: Phase
PHSEQControl Recipe Destination
KNOBJNumber of Object with Assigned Dependencies
ERFSICHTRecording View
QPPKTABSFlow Variants for Inspection Point Completion
OTYPEObject Type
OBJEKTIDObject ID
QLKAPARCapacity category
RSTUFReduction level which reduces operation lead time
NPTXTKYInternal text number (12-character)
SUBSYSSubsystem Identifier for QM Subsystem Interface
PSPNRStandard WBS element
PACKNOPackage number
TXJCDTax Jurisdiction
SCOPEObject Class
GSBERBusiness Area
PRCTRProfit Center
NO_DISPEffective for Materials Planning
QKZPRZEITInterval = Time (Time-Related)
QKZZTMG1Quantity Confirmation for Each Partial Lot
QKZPRMENGCreation Cycle = Quantity (Quantity-Reference)
QKZPRFREIInterval Without Reference to Time or Quantity
KZFEATIndicator Is Not Used Currently
QKZTLSBESTOperation with Stock-Related Partial Lot Assignment
AENNRChange Number
CUOBJ_ARBConfiguration (internal object number)
EVGEWAggregation weight for POC (PS progress)
ARBIIActual operating resources object identification
WERKIActual plant
CY_SEQNRVSequence number operation
KAPT_PUFFROperation floats after finite scheduling (in seconds)
EBELNPurchasing Document Number
EBELPItem Number of Purchasing Document
WEMPFGoods Recipient/Ship-To Party
ABLADUnloading Point
CLASFInd.: Take Activity Into Account for Project Summarization
FRUNVIndicator: External procurement data incomplete
ZSCHLOverhead key
KALSMCosting Sheet
SCHED_ENDInd.: Purchase requisition at activity finish date
NETZKONTIndicator for the account assignment of a network(hdr/act.)
OWAERObject currency for network activity
AFNAMName of Requisitioner/Requester
BEDNRRequirement Tracking Number
KZFIXIndicator: Purchasing info record data are fixed
PERNRPersonnel number
FRDLBIndicator: Externally processed op. with subcontracting
QPARTInspection Type
LOEKZDeletion flag
WKURSExchange Rate
PROD_ACTIndicator: Activity is a production activity
FPLNRBilling plan number / invoicing plan number
OBJTYPEChange indicator
CH_PROCProcess that has lead to the change of an object
KLVARCosting Variant
KALNRCost Estimate Number for Cost Est. w/o Qty Structure
FORDNFramework Order
FORDPItem of framework order
MAT_PRKSTMaterial planning in networks: primary costs
PRZ01Business Process
RFPNTReference point for BOM transfer
FUNC_AREAFunctional Area
TECHSParameter Variant/Standard Variant
ADPSPReference Element PM/PS
RFIPPNTReference Point for Relationship Between iPPE and PS
MES_OPERIDKey of an Operation from an ME System
MES_STEPIDKey of a Step in a Routing (SAP ME)
.INCLU--AP

/CUM/CUGUIDUUID in X form (binary)
.INCLU--AP

/ISDFPS/OBJNRObject number
.INCLU--AP

AFVC_STATUSStatus Combination
.INCLU--AP

MILL_OC_AUFNR_MONumber of Combined Order
.INCLU--AP

WTY_INDWarranty indicator
TPLNRFunctional Location
EQUNREquipment Number
.INCLU--AP

CPD_UPDATTime Stamp


       4. AFIH - Work Order maintenance order header

Field NameField DescriptionRule
AUFNROrder Number
ARTPRPriority Type
PRIOKPriority
EQUNREquipment Number
BAUTLAssembly
ILOANLocation and account assignment for technical object
ILOAIILOA Individual
ANLZUSyst.Condition
IWERKMaintenance Planning Plant
INGPRPlanner Group for Customer Service and Plant Maintenance
APGRPResponsible planner group/department
PM_OBJTYObject Type of CIM Resources for Work Center
GEWRKObject ID of the Work Center
KUNUMCustomer Number
ANINGName of Person Reponsible for System
GAUZTPlanned downtime in hours
GAUEHUnit for Breakdown Duration
ANLBDDate until which the system is available
ANLVDDate from which the system is available
ANLBZTime until which the system is available
ANLVZTime from Which System is Available
INSPKName of Person Responsible for Technical Inspection
DATANDate of Technical Inspection
WARPLMaintenance Plan
ABNUMMaintenance Plan Call Number
WAPOSMaintenance item
LAUFNOrder number
OBKNRObject list number
REVNRRevision for Plant Maintenance and Customer Service
ADDATPM Order: Reference Date
ADUHRTime of Reference Date
IPHASMaintenance Processing Phase
ILARTMaintenance activity type
QMNUMNotification No
HISDAPM request: History date
AKKNZOrder Category Indicator Plant Maintenance
PLKNZMaintenance order planning indicator
SERIALNRSerial Number
SERMATMaterial Number
DEVICEIDAdditional Device Data
SCREENTYScenario or Subscreen Category
ADPSPReference Element PM/PS
RSUPGUpgrade Order Indicator
.INCLU--AP

/ISDFPS/OBJNRObject number
/ISDFPS/MEQUIMaster Equipment
.INCLU--AP

UIIUnique Item Identifier
.INCLU--AP

ORCODPM/CS Order Code Indicating Rotable Process
PRMANCMC: Priority Manually Changed
PRVALPriority for PM/CS Orders
TWTDECMC: Use Minimum or Standard TWT from PP Matrix
MSTCKSingle-Character Indicator


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

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.
  • All data cleansing and preparation has been completed.
  • Only valid Legacy outstanding Work Orders that have been supplied by the CIT in the Identified List of Work Order will be converted
  • All Work Orders will be forward scheduled and outstanding (not TECO), as the cut off day for Work Orders will be seven days prior to the Legacy system close date, and be valid “work” (i.e. not used as a PO generation point for items such as travel, payment reminders, etc).


See also

Change log

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