C_WrkCtrMntrOperationRelation

Relationship between Operations | view: CWRKCTROPRLTN | Extraction: Not supported | Component: Gantt
Column Name Description
SimulationSessionID Simulation Session ID
OrderID FK Order Number
CapacityRequirementItem Capacity Requirement Item
CapacityRqmtItemCapacity Individual Capacity of a Capacity Requirement Item
OrderCategory Order Category Show values
ManufacturingOrderSequence Manufacturing Order Sequence
OrderOperationRowID Capacity Planning: Identifier for shapes in Gantt Chart.
MfgOrderSequenceBrnchOperation null
MfgOrderSequenceRetOperation null
OrderOperationInternalID General counter for order
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity null
Column Name Description
OperationLatestStartDate Latest Start Date
OperationLatestStartTime Latest Start Time
OperationLatestEndDate Latest End Date
OperationLatestEndTime Latest End Time
Column Name Description
OrderCategory Order Category Show values
WrkCtrOrderIsRelevant Checkbox Show values
OrderStatusCode Order types based on order statuses Show values
OrderPlanningStatusCode Planning Order Status Show values
OperationPlanningStatusCode Scheduling Status Show values
Column Name Description Domain name
OrderCategoryName Short Text for Fixed Values DDTEXT
Operation Operation/Activity Number VORNR
ProductDescription Product Description TEXT40
ProductionVersion Source of Supply VERID
NumberOfSOS Number of Source of Supply PPH_CFS_SCH_NUMBER_OF_SOS
MRPArea MRP Area BERID
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
WorkCenter Work Center ARBPL
WorkCenterText Work Center Text TEXT40
MainWorkCenter Work Center ARBPL
SchedldOrdStartDteTme Latest Start Datetime TZNTSTMPS
SchedldOrdEndDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ReceiptDate Receipt Date TZNTSTMPS
CapacityCategoryName Description of a Capacity Category TEXT20
LtstSchedldExecStrtDteTme Latest Start Datetime TZNTSTMPS
OrderOperationStartDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
LtstSchedldExecEndDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
OrderOperationEndDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ProductionLine Production Line for Repetitive Manufacturing ARBPL
OrderIsChangedInSimulation null
StatusName Short Text for Fixed Values DDTEXT
SchedulingStatusText Short Text for Fixed Values DDTEXT
PredecessorOrderOperationRowID Capacity Planning: Identifier for shapes in Gantt Chart. CHAR21
SuccessorOrderOperationRowID Capacity Planning: Identifier for shapes in Gantt Chart. CHAR21
OrderOperationRelationshipType null
RequirementDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
UnitOfMeasure_E External Unit of Measurement in Commercial Format (3-Char.) MSEH3
RemainingCapReqExecutionDurn Required Capacity in Float PPH_CFS_SCH_REQUIRED_CAP_FLTP
OrderStartDateTime null
OrderEndDateTime null
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_WRKCTRMNTROPERATIONRELATION.MANDT == T006.MANDT
  • C_WRKCTRMNTROPERATIONRELATION.BASEUNIT == T006.MSEHI
Capacity Category
  • Client
  • Capacity Category
  • C_WRKCTRMNTROPERATIONRELATION.MANDT == TC26.MANDT
  • C_WRKCTRMNTROPERATIONRELATION.CAPACITYCATEGORYCODE == TC26.KAPAR
Capacity ID
  • Client
  • Capacity ID
  • C_WRKCTRMNTROPERATIONRELATION.MANDT == KAKO.MANDT
  • C_WRKCTRMNTROPERATIONRELATION.CAPACITYINTERNALID == KAKO.KAPID
Capacity Responsible Planner Group
  • Client
  • Capacity Responsible Planner Group
  • C_WRKCTRMNTROPERATIONRELATION.MANDT == TC27.MANDT
  • C_WRKCTRMNTROPERATIONRELATION.CAPACITYRESPONSIBLEPLANNER == TC27.PLANR
Sequence Category C_WRKCTRMNTROPERATIONRELATION.MFGORDERSEQUENCECATEGORY == TCA07.FLGAT
MRP Controller Group
  • Client
  • Plant
  • MRP Controller
  • C_WRKCTRMNTROPERATIONRELATION.MANDT == T024D.MANDT
  • C_WRKCTRMNTROPERATIONRELATION.PLANT == T024D.WERKS
  • C_WRKCTRMNTROPERATIONRELATION.MRPCONTROLLER == T024D.DISPO
Order Number
  • Client
  • Order Number
  • C_WRKCTRMNTROPERATIONRELATION.MANDT == AUFK.MANDT
  • C_WRKCTRMNTROPERATIONRELATION.ORDERID == AUFK.AUFNR
Plant
  • Client
  • Plant
  • C_WRKCTRMNTROPERATIONRELATION.MANDT == T001W.MANDT
  • C_WRKCTRMNTROPERATIONRELATION.PLANT == T001W.WERKS
Product Number
  • Client
  • Product Number
  • C_WRKCTRMNTROPERATIONRELATION.MANDT == MARA.MANDT
  • C_WRKCTRMNTROPERATIONRELATION.PRODUCT == MARA.MATNR
Material Group
  • Client
  • Product Group
  • C_WRKCTRMNTROPERATIONRELATION.MANDT == T023.MANDT
  • C_WRKCTRMNTROPERATIONRELATION.PRODUCTGROUP == T023.MATKL
Object ID of the resource
  • Client
  • Object ID of the resource
  • ?
  • C_WRKCTRMNTROPERATIONRELATION.MANDT == CRID.MANDT
  • C_WRKCTRMNTROPERATIONRELATION.WORKCENTERINTERNALID == CRID.OBJID
  • C_WRKCTRMNTROPERATIONRELATION.[column in domain "CR_OBJTY"] == CRID.OBJTY
Other Relations | to Master Data Relations ↑ Join Conditions
Person Responsible for the Work Center
  • Client
  • Plant
  • Person Responsible for the Work Center
  • C_WRKCTRMNTROPERATIONRELATION.MANDT == TC24.MANDT
  • C_WRKCTRMNTROPERATIONRELATION.PLANT == TC24.WERKS
  • C_WRKCTRMNTROPERATIONRELATION.WORKCENTERRESPONSIBLE == TC24.VERAN