SAP Table IPRCORDOPALLOPS (Generated Table for View)

SAP table IPRCORDOPALLOPS has 4 primary key fields being MANDT,ORDERINTERNALBILLOFOPERATIONS,ORDEROPERATIONINTERNALID,ORDERINTBILLOFOPERATIONSITEM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
ORDERINTERNALBILLOFOPERATIONS Order Internal ID NUMC 10 0 PPH_AUFPL
ORDEROPERATIONINTERNALID Internal Identifier of an Operation or Activity NUMC 8 0 OPERATIONINTERNALID
ORDERINTBILLOFOPERATIONSITEM Internal Identifier of an Operation or Activity NUMC 8 0 OPERATIONINTERNALID
PROCESSORDER Manufacturing Order ID CHAR 12 0 MANUFACTURINGORDER
OPERATIONTEXT Text field, length 4 CHAR 4 0 TEXT4
MANUFACTURINGORDERSEQUENCE Manufacturing Order Sequence CHAR 6 0 MANUFACTURINGORDERSEQUENCE
MANUFACTURINGORDERCATEGORY Manufacturing Order Category NUMC 2 0 MANUFACTURINGORDERCATEGORY
10 Production Order
40 Process Order
MANUFACTURINGORDERTYPE Manufacturing Order Type CHAR 4 0 T003O MANUFACTURINGORDERTYPE
PRODUCTIONPLANT Production Plant CHAR 4 0 T001W PWWRK
PRODUCTIONSUPERVISOR Production Supervisor CHAR 3 0 T024F PPH_FEVOR
MRPCONTROLLER MRP Controller CHAR 3 0 T024D PPH_DISPO
TOTNMBROFPROCORDOPCONFDPHASES INT1 3 0
TOTNMBROFPROCORDOPPHASES INT1 3 0
PROCORDOPPROGRESSPERCENT NUMC 3 0
NMBROFINTERRUPTEDPROCORDPHASES INT1 3 0
OPERATIONISINTERRUPTED CHAR 1 0
PROCORDOPSTATUSCODE NUMC 2 0
WORKCENTERINTERNALID Work Center Internal ID NUMC 8 0 CRID PPH_ARBID
WORKCENTER Work Center CHAR 8 0 PPH_ARBPL
WORKCENTERTEXT Work Center Text CHAR 40 0 WORKCENTERTEXT
OPERATIONUNIT Operation Unit of Measure UNIT 3 0 T006 OPERATIONUNIT
OPPLANNEDTOTALQUANTITY Operation Total Quantity QUAN 13 3 MGVRG
MATERIAL Material Number for Order CHAR 40 0 MARA CO_MATNR
MATERIALNAME Material Description CHAR 40 0 MAKTX
PROCORDOPSCHEDLDSTARTDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
PROCORDOPSCHEDLDENDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
PROCORDOPACTUALSTARTDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
PROCORDOPACTUALENDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
PLANNEDACTUALSTARTDATEDVTNDURN DEC 16 0
PLANNEDCURRENTSTRTDATEDVTNDURN DEC 16 0
PLANNEDACTUALENDDATEDVTNDURN DEC 16 0
PLANNEDCURRENTENDDATEDVTNDURN DEC 16 0
OPERATIONISCONFIRMED CHAR 1 0
OPERATIONEXECUTIONSTARTISLATE Indicator: Execution Start is Late CHAR 1 0 EXECUTIONSTARTISLATE
OPERATIONEXECUTIONENDISLATE Indicator: Execution End is Late CHAR 1 0 EXECUTIONENDISLATE
PROCORDOPCOMPAVAILYSTATUSCODE NUMC 2 0
PROCORDOPQLTYISSSTATUSCODE NUMC 2 0
MFGORDEROPERATIONISPHASE Indicator: Phase CHAR 1 0 PHFLG

IPRCORDOPALLOPS foreign key relationships

Table Field Check Table Check Field
0 IPRCORDOPALLOPS MANDT T000 Clients MANDT
1 IPRCORDOPALLOPS MANUFACTURINGORDERTYPE T003O Order Types AUART
0 IPRCORDOPALLOPS MATERIAL MARA General Material Data MATNR
1 IPRCORDOPALLOPS MRPCONTROLLER T024D MRP Controllers MANDT
1 IPRCORDOPALLOPS MRPCONTROLLER T024D MRP Controllers WERKS
1 IPRCORDOPALLOPS MRPCONTROLLER T024D MRP Controllers DISPO
0 IPRCORDOPALLOPS PRODUCTIONPLANT T001W Plants/Branches MANDT
0 IPRCORDOPALLOPS PRODUCTIONPLANT T001W Plants/Branches WERKS
1 IPRCORDOPALLOPS PRODUCTIONSUPERVISOR T024F Production scheduler WERKS
0 IPRCORDOPALLOPS WORKCENTERINTERNALID CRID CIM Resource - Entities MANDT
0 IPRCORDOPALLOPS WORKCENTERINTERNALID CRID CIM Resource - Entities OBJID