C_SupDmndAllDocPlndOrdAssgQ

Query View for Planned Order Assignment Details | view: CSUPDMNDADPLNDAQ | Extraction: Not supported | Component: Order Allocation Run

Tables used: SCAL_TT_DATE, SCAL_TT_WEEK, ARUN_BDBS, ARUN_PREVIEW, ARUN_SDO_ALLDOC, PLAF, MARA, MARC, T001K, T001W

🔑 Keys (10)
💰 Amounts
∑ Quantities (2)
📅 Dates (2)
☰ Categorical (1)
Other (9)
🔗 Relations (13)

Column Name	Description
Material FK	Planning material
Plant FK	Planning Plant
Batch	Batch Number
StorageLocation	Storage location
SupplyNumber	null
SupplyItem	null
SupplyScheduleLine	null
ProductAvailabilityDate	Planned Order End Date
AssignedSupplyType	null
RequirementType	Requirement Type	Show values

Column Name	Description

Column Name	Description
📏 Base Unit of Measure (BaseUnit):
AssignedQuantityInBaseUnit	null
NormalAssignedQuantityInBsUnt	null

Column Name	Description
ProductAvailabilityDate	Planned Order End Date
RequestedDeliveryDate	Planned Order End Date

Column Name	Description
RequirementType	Requirement Type	Show values

Column Name	Description	Domain name
SupAssgmtSource	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
PurchasingGroup	Purchasing Group	EKGRP

Master Data Relations	Join Conditions
Base Unit of Measure Client Base Unit of Measure	`C_SUPDMNDALLDOCPLNDORDASSGQ.MANDT == T006.MANDT` `C_SUPDMNDALLDOCPLNDORDASSGQ.BASEUNIT == T006.MSEHI`
Company code Client Company Code	`C_SUPDMNDALLDOCPLNDORDASSGQ.MANDT == T001.MANDT` `C_SUPDMNDALLDOCPLNDORDASSGQ.COMPANYCODE == T001.BUKRS`
Cross-Plant Configurable Material Client Cross-Plant Configurable Material	`C_SUPDMNDALLDOCPLNDORDASSGQ.MANDT == MARA.MANDT` `C_SUPDMNDALLDOCPLNDORDASSGQ.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR`
Customer Number of Plant Client Customer Number of Plant	`C_SUPDMNDALLDOCPLNDORDASSGQ.MANDT == KNA1.MANDT` `C_SUPDMNDALLDOCPLNDORDASSGQ.CUSTOMER == KNA1.KUNNR`
Distribution channel for intercompany billing Client Distribution channel for intercompany billing	`C_SUPDMNDALLDOCPLNDORDASSGQ.MANDT == TVTW.MANDT` `C_SUPDMNDALLDOCPLNDORDASSGQ.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Division for intercompany billing Client Division for intercompany billing	`C_SUPDMNDALLDOCPLNDORDASSGQ.MANDT == TSPA.MANDT` `C_SUPDMNDALLDOCPLNDORDASSGQ.DIVISION == TSPA.SPART`
Material Client Planning material	`C_SUPDMNDALLDOCPLNDORDASSGQ.MANDT == MARA.MANDT` `C_SUPDMNDALLDOCPLNDORDASSGQ.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`C_SUPDMNDALLDOCPLNDORDASSGQ.MANDT == T023.MANDT` `C_SUPDMNDALLDOCPLNDORDASSGQ.MATERIALGROUP == T023.MATKL`
Material type Client Material type	`C_SUPDMNDALLDOCPLNDORDASSGQ.MANDT == T134.MANDT` `C_SUPDMNDALLDOCPLNDORDASSGQ.MATERIALTYPE == T134.MTART`
Plant Client Planning Plant	`C_SUPDMNDALLDOCPLNDORDASSGQ.MANDT == T001W.MANDT` `C_SUPDMNDALLDOCPLNDORDASSGQ.PLANT == T001W.WERKS`
Purchasing organization Purchasing organization Client	`C_SUPDMNDALLDOCPLNDORDASSGQ.PURCHASINGORGANIZATION == T024E.EKORG` `C_SUPDMNDALLDOCPLNDORDASSGQ.MANDT == T024E.MANDT`
Sales District Client Sales District	`C_SUPDMNDALLDOCPLNDORDASSGQ.MANDT == T171.MANDT` `C_SUPDMNDALLDOCPLNDORDASSGQ.SALESDISTRICT == T171.BZIRK`
Sales Organization for Intercompany Billing Client Sales Organization for Intercompany Billing	`C_SUPDMNDALLDOCPLNDORDASSGQ.MANDT == TVKO.MANDT` `C_SUPDMNDALLDOCPLNDORDASSGQ.SALESORGANIZATION == TVKO.VKORG`