C_SupDmndAllDocPlndIndepRqmtQ

Query View for Planned Independent Requirement Details | view: CSUPDMNDADPIRQ | Extraction: Not supported | Component: Order Allocation Run
Column Name Description
RequirementDocumentNumber Requirements Plan
RequirementDocumentItem Item number of the SD document
RequestedDate Delivery/order finish date
ProductAvailabilityDate Delivery/order finish date
RequirementType null
Column Name Description
Column Name Description
RequestedRqmtQtyInBaseUnit Planned quantity
ConfirmedRqmtQtyInBaseUnit Planned quantity
DeliveredQuantityInBaseUnit null
ARunConsumedQuantityInBsUnt null
OpenDemandQuantity null
AssignedQuantityInBaseUnit null
NormalAssignedQuantityInBsUnt null
Column Name Description
RequestedDate Delivery/order finish date
ProductAvailabilityDate Delivery/order finish date
RequestedDeliveryDate Delivery/order finish 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
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
StorageLocation Storage location LGORT
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.MANDT == T006.MANDT
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.BASEUNIT == T006.MSEHI
Company code
  • Client
  • Company Code
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.MANDT == T001.MANDT
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.COMPANYCODE == T001.BUKRS
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.MANDT == MARA.MANDT
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Customer Number of Plant
  • Client
  • Customer Number of Plant
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.MANDT == KNA1.MANDT
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.CUSTOMER == KNA1.KUNNR
Distribution channel for intercompany billing
  • Client
  • Distribution channel for intercompany billing
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.MANDT == TVTW.MANDT
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division for intercompany billing
  • Client
  • Division for intercompany billing
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.MANDT == TSPA.MANDT
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.DIVISION == TSPA.SPART
Material Number
  • Client
  • Material Number
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.MANDT == MARA.MANDT
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.MANDT == T023.MANDT
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.MATERIALGROUP == T023.MATKL
Material type
  • Client
  • Material type
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.MANDT == T134.MANDT
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.MATERIALTYPE == T134.MTART
Plant
  • Client
  • Plant
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.MANDT == T001W.MANDT
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.PLANT == T001W.WERKS
Sales District
  • Client
  • Sales District
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.MANDT == T171.MANDT
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.SALESDISTRICT == T171.BZIRK
Sales Organization for Intercompany Billing
  • Client
  • Sales Organization for Intercompany Billing
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.MANDT == TVKO.MANDT
  • C_SUPDMNDALLDOCPLNDINDEPRQMTQ.SALESORGANIZATION == TVKO.VKORG