C_SupDmndAllDocCnsmpnQuery

Query View for Planned Independent Requirement Consumption | view: CSUPDMNDADCONSQ | Extraction: Not supported | Component: Order Allocation Run
Column Name Description
PlndIndepRqmtPlan Requirements Plan
ProductAvailabilityDate Requested date
RequirementType null
RequirementDocumentNumber Purchasing requirement document
RequirementDocumentItem null
ProdAvailabilityCheckRqmtType Requirement Type for All Documents of Suppy Demand Overview Show values
RequestedDate Requested date
RequirementDate Material Staging/Availability Date
Column Name Description
Column Name Description
ARunConsumedQuantityInBsUnt null
Column Name Description
ProductAvailabilityDate Requested date
RequestedDate Requested date
RequirementDate Material Staging/Availability Date
RequestedDeliveryDate Requested date
Column Name Description
ProdAvailabilityCheckRqmtType Requirement Type for All Documents of Suppy Demand Overview Show values
Column Name Description Domain name
ARunDocumentItemUniqueID Unique Identification for Supply Assignment Document Item CHAR17
DocumentItemConcatenatedID Unique Identification for Supply Assignment Document Item CHAR17
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarMonthName Short Text for Fixed Values DDTEXT
CalendarWeek null
CalendarDay Calendar Day NUM2
Plant Plant WERKS
Material Material Number MATNR
StorageLocation Storage location LGORT
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • C_SUPDMNDALLDOCCNSMPNQUERY.COMPANYCODE == T001.BUKRS
  • C_SUPDMNDALLDOCCNSMPNQUERY.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • C_SUPDMNDALLDOCCNSMPNQUERY.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
  • C_SUPDMNDALLDOCCNSMPNQUERY.MANDT == MARA.MANDT
Customer Number of Plant
  • Client
  • Customer Number of Plant
  • C_SUPDMNDALLDOCCNSMPNQUERY.MANDT == KNA1.MANDT
  • C_SUPDMNDALLDOCCNSMPNQUERY.CUSTOMER == KNA1.KUNNR
Distribution channel for intercompany billing
  • Client
  • Distribution channel for intercompany billing
  • C_SUPDMNDALLDOCCNSMPNQUERY.MANDT == TVTW.MANDT
  • C_SUPDMNDALLDOCCNSMPNQUERY.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division for intercompany billing
  • Client
  • Division for intercompany billing
  • C_SUPDMNDALLDOCCNSMPNQUERY.MANDT == TSPA.MANDT
  • C_SUPDMNDALLDOCCNSMPNQUERY.DIVISION == TSPA.SPART
Material Group
  • Client
  • Material Group
  • C_SUPDMNDALLDOCCNSMPNQUERY.MANDT == T023.MANDT
  • C_SUPDMNDALLDOCCNSMPNQUERY.MATERIALGROUP == T023.MATKL
Material type
  • Client
  • Material type
  • C_SUPDMNDALLDOCCNSMPNQUERY.MANDT == T134.MANDT
  • C_SUPDMNDALLDOCCNSMPNQUERY.MATERIALTYPE == T134.MTART
Sales District
  • Client
  • Sales District
  • C_SUPDMNDALLDOCCNSMPNQUERY.MANDT == T171.MANDT
  • C_SUPDMNDALLDOCCNSMPNQUERY.SALESDISTRICT == T171.BZIRK
Sales Organization for Intercompany Billing
  • Client
  • Sales Organization for Intercompany Billing
  • C_SUPDMNDALLDOCCNSMPNQUERY.MANDT == TVKO.MANDT
  • C_SUPDMNDALLDOCCNSMPNQUERY.SALESORGANIZATION == TVKO.VKORG