I_SupDmndAllDocRetsSupAssgC

Cube View for Returns from PO/STO Assignment Details | view: ISUPDMNDADRTSPAC | TRAN | Extraction: Not supported | Component: Order Allocation Run

Tables used: SCAL_TT_DATE, EKKO, EKPO, EKET, SCAL_TT_WEEK, ARUN_BDBS, ARUN_PREVIEW, ARUN_SDO_ALLDOC, MARA, MARC, T001K, T001W

🔑 Keys (7)
💰 Amounts (1)
∑ Quantities (2)
📅 Dates (3)
☰ Categorical
Other (7)
🔗 Relations (15)

Column Name	Description
RequirementDocumentNumber FK	Purchasing Document Number
RequirementDocumentItem	null
RequestedDate	Item delivery date
ProductAvailabilityDate	Item delivery date
RequirementType	null
AssignedSupplyType	ARun Stock Source
SupAssgmtSource	ARun Stock Source

Column Name	Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount	Net Price in Purchasing Document (in Document Currency)

Column Name	Description
📏 Base Unit of Measure (SupAssgmtAggrgQtyUnit):
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
PreviewAssignedQuantityInBsUnt	null
ARunTmpAssignedQuantityInBsUnt	null
CalendarYear	Calendar Year
CalendarMonth	Calendar Month
CalendarMonthName	Short Text for Fixed Values
CalendarWeek	null
CalendarDay	Calendar Day

Master Data Relations	Join Conditions
Purchase Order Unit of Measure Purchase Order Unit of Measure Client	`I_SUPDMNDALLDOCRETSSUPASSGC.BASEUNIT == T006.MSEHI` `I_SUPDMNDALLDOCRETSSUPASSGC.MANDT == T006.MANDT`
Company code Company Code Client	`I_SUPDMNDALLDOCRETSSUPASSGC.COMPANYCODE == T001.BUKRS` `I_SUPDMNDALLDOCRETSSUPASSGC.MANDT == T001.MANDT`
Cross-Plant Configurable Material Client Cross-Plant Configurable Material	`I_SUPDMNDALLDOCRETSSUPASSGC.MANDT == MARA.MANDT` `I_SUPDMNDALLDOCRETSSUPASSGC.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR`
Customer Number of Plant Client Customer Number of Plant	`I_SUPDMNDALLDOCRETSSUPASSGC.MANDT == KNA1.MANDT` `I_SUPDMNDALLDOCRETSSUPASSGC.CUSTOMER == KNA1.KUNNR`
Distribution channel for intercompany billing Distribution channel for intercompany billing Client	`I_SUPDMNDALLDOCRETSSUPASSGC.DISTRIBUTIONCHANNEL == TVTW.VTWEG` `I_SUPDMNDALLDOCRETSSUPASSGC.MANDT == TVTW.MANDT`
Division for intercompany billing Client Division for intercompany billing	`I_SUPDMNDALLDOCRETSSUPASSGC.MANDT == TSPA.MANDT` `I_SUPDMNDALLDOCRETSSUPASSGC.DIVISION == TSPA.SPART`
Currency Key Currency Key Client	`I_SUPDMNDALLDOCRETSSUPASSGC.DOCUMENTCURRENCY == TCURC.WAERS` `I_SUPDMNDALLDOCRETSSUPASSGC.MANDT == TCURC.MANDT`
Material Number Client Material Number	`I_SUPDMNDALLDOCRETSSUPASSGC.MANDT == MARA.MANDT` `I_SUPDMNDALLDOCRETSSUPASSGC.MATERIAL == MARA.MATNR`
Material Group Material Group Client	`I_SUPDMNDALLDOCRETSSUPASSGC.MATERIALGROUP == T023.MATKL` `I_SUPDMNDALLDOCRETSSUPASSGC.MANDT == T023.MANDT`
Material type Client Material type	`I_SUPDMNDALLDOCRETSSUPASSGC.MANDT == T134.MANDT` `I_SUPDMNDALLDOCRETSSUPASSGC.MATERIALTYPE == T134.MTART`
Plant Client Plant	`I_SUPDMNDALLDOCRETSSUPASSGC.MANDT == T001W.MANDT` `I_SUPDMNDALLDOCRETSSUPASSGC.PLANT == T001W.WERKS`
Sales District Client Sales District	`I_SUPDMNDALLDOCRETSSUPASSGC.MANDT == T171.MANDT` `I_SUPDMNDALLDOCRETSSUPASSGC.SALESDISTRICT == T171.BZIRK`
Sales Organization for Intercompany Billing Client Sales Organization for Intercompany Billing	`I_SUPDMNDALLDOCRETSSUPASSGC.MANDT == TVKO.MANDT` `I_SUPDMNDALLDOCRETSSUPASSGC.SALESORGANIZATION == TVKO.VKORG`
Storage location Client Storage location Plant	`I_SUPDMNDALLDOCRETSSUPASSGC.MANDT == T001L.MANDT` `I_SUPDMNDALLDOCRETSSUPASSGC.STORAGELOCATION == T001L.LGORT` `I_SUPDMNDALLDOCRETSSUPASSGC.PLANT == T001L.WERKS`