P_WrkCtrMntrOrderCalcFields

Calculate Order Operation Days and Seconds Fields | view: PMWCORDCACLF | Extraction: Not supported | Component: Gantt
Tables used: AFKO, KBKO, AFKO, KBED, KBEZ, AFKO, AFPO, JSTO, JEST, PPH_CFS_UTZ_ASG, AFVC, AFVU, AFVV, MARA, ADCP, ADRC, PLPO, TCA01, KAKO, AUFK, PLAF, T001W, MARA, CRTX, MKAL, CRHD, MKAL_AEND, MKAL_AEND
Column Name Description
OrderID FK Order Number
CapacityRequirementItem Capacity Requirement Item
CapacityRqmtItemCapacity Individual Capacity of a Capacity Requirement Item
OrderCategory Order Category Show values
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
OrderPlannedTotalQty Operation Total Quantity
Column Name Description
OperationLatestStartDate Latest Start Date
OperationLatestStartTime Latest Start Time
OperationLatestEndDate Latest End Date
OperationLatestEndTime Latest End Time
RequirementDate Basic finish date
Column Name Description
OrderCategory Order Category Show values
WorkCenterTypeCode Object types of the CIM resource Show values
OperationPlanningStatusCode Scheduling Status Show values
Column Name Description Domain name
RemCapReqOpSegProcgDurnInSecs null
RemCapReqOpSegProcgDurnInDays null
Operation Operation/Activity Number VORNR
MRPArea MRP Area BERID
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
WorkCenter Work Center ARBPL
WorkCenterText Work Center Text TEXT40
OrderInternalID Order Internal ID AUFPL
ProductionVersion Production Version VERID
ProductionLine Production Line for Repetitive Manufacturing ARBPL
IndustryType Application of the task list PLNAW
LtstSchedldExecStrtDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
LtstSchedldExecEndDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
RemCapReqOpSegSetupDurnInHours Remaining Capacity Requirements for Setup KAPBED
RemCapReqOpSegProcgDurnInHours Remaining Capacity Requirements for Processing KAPBED
RemCapReqOpSegTrdwnDurnInHours Remaining Capacity Requirements for Teardown KAPBED
PlantCurrentDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_WRKCTRMNTRORDERCALCFIELDS.BASEUNIT == T006.MSEHI
  • P_WRKCTRMNTRORDERCALCFIELDS.MANDT == T006.MANDT
Capacity Category
  • Capacity Category
  • Client
  • P_WRKCTRMNTRORDERCALCFIELDS.CAPACITYCATEGORYCODE == TC26.KAPAR
  • P_WRKCTRMNTRORDERCALCFIELDS.MANDT == TC26.MANDT
Capacity ID
  • Capacity ID
  • Client
  • P_WRKCTRMNTRORDERCALCFIELDS.CAPACITYINTERNALID == KAKO.KAPID
  • P_WRKCTRMNTRORDERCALCFIELDS.MANDT == KAKO.MANDT
Capacity Responsible Planner Group
  • Client
  • Capacity Responsible Planner Group
  • P_WRKCTRMNTRORDERCALCFIELDS.MANDT == TC27.MANDT
  • P_WRKCTRMNTRORDERCALCFIELDS.CAPACITYRESPONSIBLEPLANNER == TC27.PLANR
Order Number
  • Client
  • Order Number
  • Order Number
  • P_WRKCTRMNTRORDERCALCFIELDS.MANDT == AUFK.MANDT
  • P_WRKCTRMNTRORDERCALCFIELDS.ORDERID == AUFK.AUFNR
  • P_WRKCTRMNTRORDERCALCFIELDS.MANUFACTURINGORDER == AUFK.AUFNR
Product Number
  • Client
  • Product Number
  • P_WRKCTRMNTRORDERCALCFIELDS.MANDT == MARA.MANDT
  • P_WRKCTRMNTRORDERCALCFIELDS.MATERIAL == MARA.MATNR
MRP Controller Group
  • MRP Controller
  • Client
  • Plant
  • P_WRKCTRMNTRORDERCALCFIELDS.MRPCONTROLLER == T024D.DISPO
  • P_WRKCTRMNTRORDERCALCFIELDS.MANDT == T024D.MANDT
  • P_WRKCTRMNTRORDERCALCFIELDS.PLANT == T024D.WERKS
Setup group key
  • Client
  • Plant
  • Setup group category
  • Setup group key
  • P_WRKCTRMNTRORDERCALCFIELDS.MANDT == T425.MANDT
  • P_WRKCTRMNTRORDERCALCFIELDS.PLANT == T425.WERKS
  • P_WRKCTRMNTRORDERCALCFIELDS.OPERATIONSETUPGROUPCATEGORY == T425.RFGRP
  • P_WRKCTRMNTRORDERCALCFIELDS.OPERATIONSETUPGROUP == T425.RFSCH
Setup group category
  • Client
  • Plant
  • Setup group category
  • P_WRKCTRMNTRORDERCALCFIELDS.MANDT == T426.MANDT
  • P_WRKCTRMNTRORDERCALCFIELDS.PLANT == T426.WERKS
  • P_WRKCTRMNTRORDERCALCFIELDS.OPERATIONSETUPGROUPCATEGORY == T426.RFGRP
Setup Type Key
  • Client
  • Plant
  • Setup Type Key
  • P_WRKCTRMNTRORDERCALCFIELDS.MANDT == T428.MANDT
  • P_WRKCTRMNTRORDERCALCFIELDS.PLANT == T428.WERKS
  • P_WRKCTRMNTRORDERCALCFIELDS.OPERATIONSETUPTYPE == T428.RASCH
Order Number
  • Client
  • Order Number
  • Order Number
  • P_WRKCTRMNTRORDERCALCFIELDS.MANDT == AUFK.MANDT
  • P_WRKCTRMNTRORDERCALCFIELDS.ORDERID == AUFK.AUFNR
  • P_WRKCTRMNTRORDERCALCFIELDS.MANUFACTURINGORDER == AUFK.AUFNR
Planned Order
  • Client
  • Planned Order
  • P_WRKCTRMNTRORDERCALCFIELDS.MANDT == PLAF.MANDT
  • P_WRKCTRMNTRORDERCALCFIELDS.PLANNEDORDER == PLAF.PLNUM
Plant
  • Client
  • Plant
  • P_WRKCTRMNTRORDERCALCFIELDS.MANDT == T001W.MANDT
  • P_WRKCTRMNTRORDERCALCFIELDS.PLANT == T001W.WERKS
Work Center Category
  • Client
  • Work Center Category
  • P_WRKCTRMNTRORDERCALCFIELDS.MANDT == TC30.MANDT
  • P_WRKCTRMNTRORDERCALCFIELDS.WORKCENTERCATEGORYCODE == TC30.VERWE
Object ID of the resource
  • Client
  • ?
  • Object ID of the resource
  • P_WRKCTRMNTRORDERCALCFIELDS.MANDT == CRID.MANDT
  • P_WRKCTRMNTRORDERCALCFIELDS.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • P_WRKCTRMNTRORDERCALCFIELDS.WORKCENTERINTERNALID == CRID.OBJID
Other Relations | to Master Data Relations ↑ Join Conditions
Person Responsible for the Work Center
  • Client
  • Plant
  • Person Responsible for the Work Center
  • P_WRKCTRMNTRORDERCALCFIELDS.MANDT == TC24.MANDT
  • P_WRKCTRMNTRORDERCALCFIELDS.PLANT == TC24.WERKS
  • P_WRKCTRMNTRORDERCALCFIELDS.WORKCENTERRESPONSIBLE == TC24.VERAN