C_SupDmndOvwTotSupQuery

Query View for Total Supply | view: CSDOSUPPLYQUERY | 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, TVTWT, TSPAT, T023T, MAKT, T001W, T024E, T171T, TVKOT, 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 (2)
Other (48)
🔗 Relations (21)

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
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

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
SupAssgmtSource	Assignment Source
SupAssgmtSourceName	Short Text for Fixed Values
MaterialName	Material Description	TEXT40
MaterialGroupName	Product Group Description	TEXT20
DistributionChannelName	Distribution Channel Description	TEXT20
DivisionName	Division Description	TEXT20
SalesDistrictName	Name of the district	TEXT20
PlantName	Plant Name	TEXT30
CompanyCodeName	Name of Company Code or Company	TEXT25
PurchasingOrganizationName	Purchasing Organization Name	TEXT20

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