I_SupDmndOvwTotalSupply

Basic View for Supply Overview | view: ISDOTOTALSUPPLY | TRAN | Extraction: Not supported | 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
💰 Amounts (2)
∑ Quantities (10)
📅 Dates (2)
☰ Categorical (4)
Other (43)
🔗 Relations (22)

Column Name	Description

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
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
AssignedSupplyType	ARun Stock Source	Show values
ItemIsRejectedBySupplier	Rejection Indicator	Show values
PurchasingDocumentCategory	Purchasing Document Category	Show values
SupAssgmtSource	Assignment Source	Show values

Column Name	Description	Domain name
Batch	null
SupplyNumber	null
SupplyItem	null
SupplyScheduleLine	null
StockSegment	Stock Segment	SGT_SRCA
AssignedSupplyTypeName	Short Text for Fixed Values	DDTEXT
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	BUKRS
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	NUM2
CalendarWeek	null
CalendarYear	Calendar Year	NUM4
CalendarMonthName	Short Text for Fixed Values	DDTEXT
PreviewFixedAssignedQtyInBsUnt	null
PreviewReservedAssgdQtyInBsUnt	null
PreviewOnHoldAssgdQtyInBsUnt	null
PreviewRdyForReleaseQtyInBsUnt	null
PreviewAssignedQuantityInBsUnt	null
SupAssgmtCategory	null
SupAssgmtCategoryName	Short Text for Fixed Values	DDTEXT
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 Purchase Order Unit of Measure Client	`I_SUPDMNDOVWTOTALSUPPLY.BASEUNIT == T006.MSEHI` `I_SUPDMNDOVWTOTALSUPPLY.MANDT == T006.MANDT`
Cross-Plant Configurable Material Cross-Plant Configurable Material Client	`I_SUPDMNDOVWTOTALSUPPLY.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR` `I_SUPDMNDOVWTOTALSUPPLY.MANDT == MARA.MANDT`
Customer Customer Customer Number of Plant Client	`I_SUPDMNDOVWTOTALSUPPLY.CUSTOMER == KNA1.KUNNR` `I_SUPDMNDOVWTOTALSUPPLY.PLANTCUSTOMER == KNA1.KUNNR` `I_SUPDMNDOVWTOTALSUPPLY.MANDT == KNA1.MANDT`
Distribution channel for intercompany billing Distribution channel for intercompany billing Client	`I_SUPDMNDOVWTOTALSUPPLY.DISTRIBUTIONCHANNEL == TVTW.VTWEG` `I_SUPDMNDOVWTOTALSUPPLY.MANDT == TVTW.MANDT`
Division for intercompany billing Client Division for intercompany billing	`I_SUPDMNDOVWTOTALSUPPLY.MANDT == TSPA.MANDT` `I_SUPDMNDOVWTOTALSUPPLY.DIVISION == TSPA.SPART`
Currency Key Currency Key Client	`I_SUPDMNDOVWTOTALSUPPLY.DOCUMENTCURRENCY == TCURC.WAERS` `I_SUPDMNDOVWTOTALSUPPLY.MANDT == TCURC.MANDT`
Material Number Material Number Client	`I_SUPDMNDOVWTOTALSUPPLY.MATERIAL == MARA.MATNR` `I_SUPDMNDOVWTOTALSUPPLY.MANDT == MARA.MANDT`
Material Group Client Material Group	`I_SUPDMNDOVWTOTALSUPPLY.MANDT == T023.MANDT` `I_SUPDMNDOVWTOTALSUPPLY.MATERIALGROUP == T023.MATKL`
Purchasing Document Type Purchasing Document Category Client Purchasing Document Type	`I_SUPDMNDOVWTOTALSUPPLY.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP` `I_SUPDMNDOVWTOTALSUPPLY.MANDT == T161.MANDT` `I_SUPDMNDOVWTOTALSUPPLY.ORDERTYPE == T161.BSART`
Plant Plant Client	`I_SUPDMNDOVWTOTALSUPPLY.PLANT == T001W.WERKS` `I_SUPDMNDOVWTOTALSUPPLY.MANDT == T001W.MANDT`
Customer Number of Plant Customer Customer Number of Plant Client	`I_SUPDMNDOVWTOTALSUPPLY.CUSTOMER == KNA1.KUNNR` `I_SUPDMNDOVWTOTALSUPPLY.PLANTCUSTOMER == KNA1.KUNNR` `I_SUPDMNDOVWTOTALSUPPLY.MANDT == KNA1.MANDT`
Supplier Number of Plant Client Supplier Number of Plant Vendor's account number	`I_SUPDMNDOVWTOTALSUPPLY.MANDT == LFA1.MANDT` `I_SUPDMNDOVWTOTALSUPPLY.PLANTSUPPLIER == LFA1.LIFNR` `I_SUPDMNDOVWTOTALSUPPLY.SUPPLIER == LFA1.LIFNR`
Purchasing Group Client Purchasing Group	`I_SUPDMNDOVWTOTALSUPPLY.MANDT == T024.MANDT` `I_SUPDMNDOVWTOTALSUPPLY.PURCHASINGGROUP == T024.EKGRP`
Reason for Ordering Reason for Ordering Client	`I_SUPDMNDOVWTOTALSUPPLY.PURCHASINGORDERREASON == TBSG.BSGRU` `I_SUPDMNDOVWTOTALSUPPLY.MANDT == TBSG.MANDT`
Sales District Sales District Client	`I_SUPDMNDOVWTOTALSUPPLY.SALESDISTRICT == T171.BZIRK` `I_SUPDMNDOVWTOTALSUPPLY.MANDT == T171.MANDT`
Sales Organization for Intercompany Billing Client Sales Organization for Intercompany Billing	`I_SUPDMNDOVWTOTALSUPPLY.MANDT == TVKO.MANDT` `I_SUPDMNDOVWTOTALSUPPLY.SALESORGANIZATION == TVKO.VKORG`
Shipping Instructions Client Shipping Instructions	`I_SUPDMNDOVWTOTALSUPPLY.MANDT == T027A.MANDT` `I_SUPDMNDOVWTOTALSUPPLY.SHIPPINGINSTRUCTION == T027A.EVERS`
Shipping Point / Receiving Point Client Shipping Point / Receiving Point	`I_SUPDMNDOVWTOTALSUPPLY.MANDT == TVST.MANDT` `I_SUPDMNDOVWTOTALSUPPLY.SHIPPINGPOINT == TVST.VSTEL`
Storage location Plant Client Storage location	`I_SUPDMNDOVWTOTALSUPPLY.PLANT == T001L.WERKS` `I_SUPDMNDOVWTOTALSUPPLY.MANDT == T001L.MANDT` `I_SUPDMNDOVWTOTALSUPPLY.STORAGELOCATION == T001L.LGORT`
Vendor's account number Client Supplier Number of Plant Vendor's account number	`I_SUPDMNDOVWTOTALSUPPLY.MANDT == LFA1.MANDT` `I_SUPDMNDOVWTOTALSUPPLY.PLANTSUPPLIER == LFA1.LIFNR` `I_SUPDMNDOVWTOTALSUPPLY.SUPPLIER == LFA1.LIFNR`
Supplying (issuing) plant in case of stock transport order Supplying (issuing) plant in case of stock transport order Client	`I_SUPDMNDOVWTOTALSUPPLY.SUPPLYINGPLANT == T001W.WERKS` `I_SUPDMNDOVWTOTALSUPPLY.MANDT == T001W.MANDT`