C_SupDmndAllDocSTOQry

Query View for Stock Transport Order Details | view: CSUPDMNDADSTOQ | Extraction: Not supported | Component: Order Allocation Run
Column Name Description
RequirementDocumentNumber FK Purchasing Document Number
RequirementDocumentItem null
RequestedDate Material Staging/Availability Date
ProductAvailabilityDate Material Staging/Availability Date
RequirementType null
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
RequestedRqmtQtyInBaseUnit null
ConfirmedRqmtQtyInBaseUnit null
DeliveredQuantityInBaseUnit null
OpenDemandQuantity null
AssignedQuantityInBaseUnit null
NormalAssignedQuantityInBsUnt null
Column Name Description
RequestedDate Material Staging/Availability Date
ProductAvailabilityDate Material Staging/Availability Date
RequestedDeliveryDate null
Column Name Description
Column Name Description Domain name
ARunDocumentItemUniqueID Unique Identification for Supply Assignment Document Item CHAR17
DocumentItemConcatenatedID Unique Identification for Supply Assignment Document Item CHAR17
PreviewAssignedQuantityInBsUnt null
ARunTmpAssignedQuantityInBsUnt null
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarMonthName Short Text for Fixed Values DDTEXT
CalendarWeek null
CalendarDay Calendar Day NUM2
SalesOrganization null
DistributionChannel null
Division null
SalesDistrict null
Customer null
CompanyCode null
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_SUPDMNDALLDOCSTOQRY.MANDT == T006.MANDT
  • C_SUPDMNDALLDOCSTOQRY.BASEUNIT == T006.MSEHI
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • C_SUPDMNDALLDOCSTOQRY.MANDT == MARA.MANDT
  • C_SUPDMNDALLDOCSTOQRY.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Currency Key
  • Currency Key
  • Client
  • C_SUPDMNDALLDOCSTOQRY.DOCUMENTCURRENCY == TCURC.WAERS
  • C_SUPDMNDALLDOCSTOQRY.MANDT == TCURC.MANDT
Material Number
  • Client
  • Material Number
  • C_SUPDMNDALLDOCSTOQRY.MANDT == MARA.MANDT
  • C_SUPDMNDALLDOCSTOQRY.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_SUPDMNDALLDOCSTOQRY.MANDT == T023.MANDT
  • C_SUPDMNDALLDOCSTOQRY.MATERIALGROUP == T023.MATKL
Material type
  • Material type
  • Client
  • C_SUPDMNDALLDOCSTOQRY.MATERIALTYPE == T134.MTART
  • C_SUPDMNDALLDOCSTOQRY.MANDT == T134.MANDT
Supplying (issuing) plant in case of stock transport order
  • Supplying (issuing) plant in case of stock transport order
  • Client
  • C_SUPDMNDALLDOCSTOQRY.PLANT == T001W.WERKS
  • C_SUPDMNDALLDOCSTOQRY.MANDT == T001W.MANDT
Storage location
  • ?
  • Client
  • Storage location
  • C_SUPDMNDALLDOCSTOQRY.[column in domain "WERKS_D"] == T001L.WERKS
  • C_SUPDMNDALLDOCSTOQRY.MANDT == T001L.MANDT
  • C_SUPDMNDALLDOCSTOQRY.STORAGELOCATION == T001L.LGORT