C_SupDmndTotPOQuery

Query View for Total Supply | view: CSDOSUPPOQRY | TRAN | Extraction: Not supported | Component: Order Allocation Run
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 Show values
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
Column Name Description
AssignedSupplyType ARun Stock Source Show values
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 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
PurchasingDocument null
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_SUPDMNDTOTPOQUERY.MANDT == T006.MANDT
  • C_SUPDMNDTOTPOQUERY.BASEUNIT == T006.MSEHI
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • C_SUPDMNDTOTPOQUERY.MANDT == MARA.MANDT
  • C_SUPDMNDTOTPOQUERY.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Customer
  • Client
  • Customer
  • C_SUPDMNDTOTPOQUERY.MANDT == KNA1.MANDT
  • C_SUPDMNDTOTPOQUERY.CUSTOMER == KNA1.KUNNR
Currency Key
  • Client
  • Currency Key
  • C_SUPDMNDTOTPOQUERY.MANDT == TCURC.MANDT
  • C_SUPDMNDTOTPOQUERY.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • C_SUPDMNDTOTPOQUERY.MANDT == MARA.MANDT
  • C_SUPDMNDTOTPOQUERY.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_SUPDMNDTOTPOQUERY.MANDT == T023.MANDT
  • C_SUPDMNDTOTPOQUERY.MATERIALGROUP == T023.MATKL
Purchasing Document Type
  • Purchasing Document Type
  • Client
  • Purchasing Document Category
  • C_SUPDMNDTOTPOQUERY.ORDERTYPE == T161.BSART
  • C_SUPDMNDTOTPOQUERY.MANDT == T161.MANDT
  • C_SUPDMNDTOTPOQUERY.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Plant
  • Client
  • Plant
  • C_SUPDMNDTOTPOQUERY.MANDT == T001W.MANDT
  • C_SUPDMNDTOTPOQUERY.PLANT == T001W.WERKS
Purchasing Group
  • Client
  • Purchasing Group
  • C_SUPDMNDTOTPOQUERY.MANDT == T024.MANDT
  • C_SUPDMNDTOTPOQUERY.PURCHASINGGROUP == T024.EKGRP
Reason for Ordering
  • Client
  • Reason for Ordering
  • C_SUPDMNDTOTPOQUERY.MANDT == TBSG.MANDT
  • C_SUPDMNDTOTPOQUERY.PURCHASINGORDERREASON == TBSG.BSGRU
Storage location
  • Client
  • Storage location
  • Plant
  • C_SUPDMNDTOTPOQUERY.MANDT == T001L.MANDT
  • C_SUPDMNDTOTPOQUERY.STORAGELOCATION == T001L.LGORT
  • C_SUPDMNDTOTPOQUERY.PLANT == T001L.WERKS
Vendor's account number
  • Vendor's account number
  • Client
  • C_SUPDMNDTOTPOQUERY.SUPPLIER == LFA1.LIFNR
  • C_SUPDMNDTOTPOQUERY.MANDT == LFA1.MANDT
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • C_SUPDMNDTOTPOQUERY.MANDT == T001W.MANDT
  • C_SUPDMNDTOTPOQUERY.SUPPLYINGPLANT == T001W.WERKS