I_SupDmndOvwTotalSupplyCube

Total Supply Cube View | view: ISDOSUPPLYCUBE | TRAN | Extraction: Full only | Component: Order Allocation Run

Tables used: SCAL_TT_DATE, MATDOC, EKES, EKKO, EKPO, AFPO, EBAN, EKET, SCAL_TT_WEEK, T001, TKA02, MARA, MARC, MCHA, MARC, VBBE, MARA, MARC, PLAF, T001K, T001W, MARA, MARC, ARUN_BDBS, ARUN_PREVIEW

🔑 Keys (8)
💰 Amounts (2)
∑ Quantities (10)
📅 Dates (2)
☰ Categorical (3)
Other (39)
🔗 Relations (22)

Column Name	Description
Material FK	Material Number
Plant FK	Plant
StorageLocation FK	Storage location
Batch	null
SupplyNumber	null
SupplyItem	null
SupplyScheduleLine	null
AssignedSupplyType	ARun Stock Source

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

Column Name	Description
📏 Base Unit of Measure (SupAssgmtAggrgQtyUnit):
TotalQuantity	null
OpenSupplyQuantity	null
RoughGoodsReceiptQty	null
AssignedQuantityInBaseUnit	null
NormalAssignedQuantityInBsUnt	null
FixedQuantityInBaseUnit	null
SupAssgmtReservedQtyInBaseUnit	null
OnHoldQuantityInBaseUnit	null
ReadyForReleaseQtyInBaseUnit	null
InboundAssignedQuantityInBsUnt	null

Column Name	Description
SupplyDeliveryDate	null
RequestedDeliveryDate	null

Column Name	Description
ItemIsRejectedBySupplier	Rejection Indicator	Show values
PurchasingDocumentCategory	Purchasing Document Category	Show values
SupAssgmtSource	Assignment Source	Show values

Column Name	Description	Domain name
StockSegment	Stock Segment	SGT_SRCA
AssignedSupplyTypeName	Short Text for Fixed Values
RetailArticleColor	Characteristic Value for Colors of Variants	WRF_ATWRT
RetailArticleMainSize	Characteristic Value for Main Sizes of Variants	WRF_ATWRT
RetailArticleSecondSize	Characteristic Value for Second Size for Variants	WRF_ATWRT
ProductCharacteristic1	Characteristic Value 1	WRF_CHARSTC
ProductCharacteristic2	Characteristic Value 2	WRF_CHARSTC
ProductCharacteristic3	Characteristic Value 3	WRF_CHARSTC
CompanyCode	Company Code
NetPriceQuantity	Price unit	DEC5
PaymentTerms	Terms of payment key	ZTERM
PurchasingOrganization	Purchasing organization	EKORG
DeliveryDocument	null
ProductSeason	Season	RFM_SAISO
ProductSeasonYear	Season Year	FSH_CJAHR
ProductCollection	Fashion Collection	FSH_COLLECTION
ProductTheme	Fashion Theme	FSH_THEME
InventorySpecialStockType	Special Stock Indicator	SOBKZ
SalesOrder	null
SalesOrderItem	null
ItemQuantity	null
MfgOrderItemGoodsReceiptQty	null
MfgOrderItemActualDeviationQty	null
MfgOrderItemPlannedScrapQty	null
DeliveredQuantity	null
CalendarMonth	Calendar Month
CalendarWeek	null
CalendarYear	Calendar Year
CalendarMonthName	Short Text for Fixed Values
PreviewFixedAssignedQtyInBsUnt	null
PreviewReservedAssgdQtyInBsUnt	null
PreviewOnHoldAssgdQtyInBsUnt	null
PreviewRdyForReleaseQtyInBsUnt	null
PreviewAssignedQuantityInBsUnt	null
SupAssgmtCategory	null
SupAssgmtCategoryName	Short Text for Fixed Values
ShippingGroupRule	PSST Grouping Rule	RFM_PSST_RULE
ShippingGroupNumber	PSST Group	RFM_PSST_GROUP_ID
SupAssgmtSourceName	Short Text for Fixed Values	DDTEXT

Master Data Relations	Join Conditions
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == T006.MANDT` `I_SUPDMNDOVWTOTALSUPPLYCUBE.BASEUNIT == T006.MSEHI`
Cross-Plant Configurable Material Cross-Plant Configurable Material Client	`I_SUPDMNDOVWTOTALSUPPLYCUBE.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR` `I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == MARA.MANDT`
Customer Client Customer Number of Plant Customer	`I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == KNA1.MANDT` `I_SUPDMNDOVWTOTALSUPPLYCUBE.PLANTCUSTOMER == KNA1.KUNNR` `I_SUPDMNDOVWTOTALSUPPLYCUBE.CUSTOMER == KNA1.KUNNR`
Distribution channel for intercompany billing Client Distribution channel for intercompany billing	`I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == TVTW.MANDT` `I_SUPDMNDOVWTOTALSUPPLYCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Division for intercompany billing Client Division for intercompany billing	`I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == TSPA.MANDT` `I_SUPDMNDOVWTOTALSUPPLYCUBE.DIVISION == TSPA.SPART`
Currency Key Client Currency Key	`I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == TCURC.MANDT` `I_SUPDMNDOVWTOTALSUPPLYCUBE.DOCUMENTCURRENCY == TCURC.WAERS`
Material Number Material Number Client	`I_SUPDMNDOVWTOTALSUPPLYCUBE.MATERIAL == MARA.MATNR` `I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == MARA.MANDT`
Material Group Client Material Group	`I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == T023.MANDT` `I_SUPDMNDOVWTOTALSUPPLYCUBE.MATERIALGROUP == T023.MATKL`
Purchasing Document Type Purchasing Document Type Purchasing Document Category Client	`I_SUPDMNDOVWTOTALSUPPLYCUBE.ORDERTYPE == T161.BSART` `I_SUPDMNDOVWTOTALSUPPLYCUBE.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP` `I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == T161.MANDT`
Plant Client Plant	`I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == T001W.MANDT` `I_SUPDMNDOVWTOTALSUPPLYCUBE.PLANT == T001W.WERKS`
Customer Number of Plant Client Customer Number of Plant Customer	`I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == KNA1.MANDT` `I_SUPDMNDOVWTOTALSUPPLYCUBE.PLANTCUSTOMER == KNA1.KUNNR` `I_SUPDMNDOVWTOTALSUPPLYCUBE.CUSTOMER == KNA1.KUNNR`
Supplier Number of Plant Supplier Number of Plant Vendor's account number Client	`I_SUPDMNDOVWTOTALSUPPLYCUBE.PLANTSUPPLIER == LFA1.LIFNR` `I_SUPDMNDOVWTOTALSUPPLYCUBE.SUPPLIER == LFA1.LIFNR` `I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == LFA1.MANDT`
Purchasing Group Purchasing Group Client	`I_SUPDMNDOVWTOTALSUPPLYCUBE.PURCHASINGGROUP == T024.EKGRP` `I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == T024.MANDT`
Reason for Ordering Client Reason for Ordering	`I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == TBSG.MANDT` `I_SUPDMNDOVWTOTALSUPPLYCUBE.PURCHASINGORDERREASON == TBSG.BSGRU`
Sales District Sales District Client	`I_SUPDMNDOVWTOTALSUPPLYCUBE.SALESDISTRICT == T171.BZIRK` `I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == T171.MANDT`
Sales Organization for Intercompany Billing Client Sales Organization for Intercompany Billing	`I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == TVKO.MANDT` `I_SUPDMNDOVWTOTALSUPPLYCUBE.SALESORGANIZATION == TVKO.VKORG`
Shipping Instructions Client Shipping Instructions	`I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == T027A.MANDT` `I_SUPDMNDOVWTOTALSUPPLYCUBE.SHIPPINGINSTRUCTION == T027A.EVERS`
Shipping Point / Receiving Point Shipping Point / Receiving Point Client	`I_SUPDMNDOVWTOTALSUPPLYCUBE.SHIPPINGPOINT == TVST.VSTEL` `I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == TVST.MANDT`
Storage location Storage location Client Plant	`I_SUPDMNDOVWTOTALSUPPLYCUBE.STORAGELOCATION == T001L.LGORT` `I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == T001L.MANDT` `I_SUPDMNDOVWTOTALSUPPLYCUBE.PLANT == T001L.WERKS`
Vendor's account number Supplier Number of Plant Vendor's account number Client	`I_SUPDMNDOVWTOTALSUPPLYCUBE.PLANTSUPPLIER == LFA1.LIFNR` `I_SUPDMNDOVWTOTALSUPPLYCUBE.SUPPLIER == LFA1.LIFNR` `I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == LFA1.MANDT`
Supplying (issuing) plant in case of stock transport order Supplying (issuing) plant in case of stock transport order Client	`I_SUPDMNDOVWTOTALSUPPLYCUBE.SUPPLYINGPLANT == T001W.WERKS` `I_SUPDMNDOVWTOTALSUPPLYCUBE.MANDT == T001W.MANDT`