P_SchedProdnDispatchOrderDets

Schedule Production Orders Extended Details | view: PSCHPRODDISPDETS | Extraction: Not supported | Component: Capacity Evaluation
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
Column Name Description
OrderCategory Order Category Show values
Column Name Description Domain name
OrderCategoryName Short Text for Fixed Values DDTEXT
ProductName Product Description TEXT40
SchedldOrdStartDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
SchedldOrdEndDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ReceiptDate UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ProductionVersion Production Version VERID
OperationSetupGroup Setup group key RUEFASCHLU
OperationSetupGroupName Description of the setup group TEXT30
OperationSetupGroupCategory Setup group category RUEFAGRP
OperationSetupGroupCatName Description of the setup group category TEXT20
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_SCHEDPRODNDISPATCHORDERDETS.BASEUNIT == T006.MSEHI
  • P_SCHEDPRODNDISPATCHORDERDETS.MANDT == T006.MANDT
Order Number
  • Order Number
  • Order Number
  • Client
  • P_SCHEDPRODNDISPATCHORDERDETS.MANUFACTURINGORDER == AUFK.AUFNR
  • P_SCHEDPRODNDISPATCHORDERDETS.ORDERID == AUFK.AUFNR
  • P_SCHEDPRODNDISPATCHORDERDETS.MANDT == AUFK.MANDT
Material Number
  • Client
  • Material Number
  • P_SCHEDPRODNDISPATCHORDERDETS.MANDT == MARA.MANDT
  • P_SCHEDPRODNDISPATCHORDERDETS.MATERIAL == MARA.MATNR
Order Number
  • Order Number
  • Order Number
  • Client
  • P_SCHEDPRODNDISPATCHORDERDETS.MANUFACTURINGORDER == AUFK.AUFNR
  • P_SCHEDPRODNDISPATCHORDERDETS.ORDERID == AUFK.AUFNR
  • P_SCHEDPRODNDISPATCHORDERDETS.MANDT == AUFK.MANDT
Planned Order
  • Planned Order
  • Client
  • P_SCHEDPRODNDISPATCHORDERDETS.PLANNEDORDER == PLAF.PLNUM
  • P_SCHEDPRODNDISPATCHORDERDETS.MANDT == PLAF.MANDT
Plant
  • Plant
  • Client
  • P_SCHEDPRODNDISPATCHORDERDETS.PLANT == T001W.WERKS
  • P_SCHEDPRODNDISPATCHORDERDETS.MANDT == T001W.MANDT