C_SupDmndAllDocStkTransptReqnQ

Query View for Stock Transport Requisition Details | view: CSUPDMNDADSTRQ | Extraction: Not supported | Component: Order Allocation Run
Column Name Description
RequirementDocumentNumber Purchase Requisition Number
RequirementDocumentItem null
RequestedDate Item delivery date
ProductAvailabilityDate Item delivery date
RequirementType null
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Price in Purchase Requisition
Column Name Description
RequestedRqmtQtyInBaseUnit null
ConfirmedRqmtQtyInBaseUnit null
OpenDemandQuantity null
AssignedQuantityInBaseUnit null
NormalAssignedQuantityInBsUnt null
Column Name Description
RequestedDate Item delivery date
ProductAvailabilityDate Item delivery date
RequestedDeliveryDate Item delivery date
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
DeliveredQuantityInBaseUnit null
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
Plant Supplying (issuing) plant in case of stock transport order WERKS
Customer null
CompanyCode null
Master Data Relations Join Conditions
Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • Client
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.BASEUNIT == T006.MSEHI
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.MANDT == T006.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.MANDT == MARA.MANDT
Distribution channel for intercompany billing
  • Distribution channel for intercompany billing
  • Client
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.MANDT == TVTW.MANDT
Division for intercompany billing
  • Division for intercompany billing
  • Client
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.DIVISION == TSPA.SPART
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.MANDT == TSPA.MANDT
Currency Key
  • Client
  • Currency Key
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.MANDT == TCURC.MANDT
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Material Number
  • Client
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.MATERIAL == MARA.MATNR
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.MATERIALGROUP == T023.MATKL
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.MANDT == T023.MANDT
Material type
  • Material type
  • Client
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.MATERIALTYPE == T134.MTART
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.MANDT == T134.MANDT
Sales District
  • Sales District
  • Client
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.SALESDISTRICT == T171.BZIRK
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.MANDT == T171.MANDT
Sales Organization for Intercompany Billing
  • Sales Organization for Intercompany Billing
  • Client
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.SALESORGANIZATION == TVKO.VKORG
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.MANDT == TVKO.MANDT
Storage location
  • Storage location
  • Client
  • ?
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.STORAGELOCATION == T001L.LGORT
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.MANDT == T001L.MANDT
  • C_SUPDMNDALLDOCSTKTRANSPTREQNQ.[column in domain "WERKS_D"] == T001L.WERKS