P_SCHOrderDets

Schedule production order details | view: PSCHORDERDETS | Extraction: Not supported | Component: Capacity Evaluation
Tables used: AFKOKBKOKBEDKBEZAFPOAFVCAFVUAFVVPLPOKAKOAUFKPLAFCRHD
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
SchedldOrdEndDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
SchedldOrdStartDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ProductionVersion Production Version VERID
OrderInternalID Order Internal ID AUFPL
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_SCHORDERDETS.BASEUNIT == T006.MSEHI
  • P_SCHORDERDETS.MANDT == T006.MANDT
Order Number
  • Order Number
  • Order Number
  • Client
  • P_SCHORDERDETS.MANUFACTURINGORDER == AUFK.AUFNR
  • P_SCHORDERDETS.ORDERID == AUFK.AUFNR
  • P_SCHORDERDETS.MANDT == AUFK.MANDT
Material Number
  • Material Number
  • Client
  • P_SCHORDERDETS.MATERIAL == MARA.MATNR
  • P_SCHORDERDETS.MANDT == MARA.MANDT
Setup group key
  • Setup group key
  • Setup group category
  • Client
  • Plant
  • P_SCHORDERDETS.OPERATIONSETUPGROUP == T425.RFSCH
  • P_SCHORDERDETS.OPERATIONSETUPGROUPCATEGORY == T425.RFGRP
  • P_SCHORDERDETS.MANDT == T425.MANDT
  • P_SCHORDERDETS.PLANT == T425.WERKS
Setup group category
  • Setup group category
  • Client
  • Plant
  • P_SCHORDERDETS.OPERATIONSETUPGROUPCATEGORY == T426.RFGRP
  • P_SCHORDERDETS.MANDT == T426.MANDT
  • P_SCHORDERDETS.PLANT == T426.WERKS
Order Number
  • Order Number
  • Order Number
  • Client
  • P_SCHORDERDETS.MANUFACTURINGORDER == AUFK.AUFNR
  • P_SCHORDERDETS.ORDERID == AUFK.AUFNR
  • P_SCHORDERDETS.MANDT == AUFK.MANDT
Planned Order
  • Client
  • Planned Order
  • P_SCHORDERDETS.MANDT == PLAF.MANDT
  • P_SCHORDERDETS.PLANNEDORDER == PLAF.PLNUM
Plant
  • Client
  • Plant
  • P_SCHORDERDETS.MANDT == T001W.MANDT
  • P_SCHORDERDETS.PLANT == T001W.WERKS