C_SupDmndAllDocNonBatStkQ

Query View for Non Batch Stock Details | view: CSUPDMNDADNBSTKQ | Extraction: Not supported | Component: Order Allocation Run
Column Name Description
Material Material in Respect of Which Stock is Managed
Plant Plant
Batch Batch Number
StorageLocation Storage location
SupplyNumber null
SupplyItem null
SupplyScheduleLine null
ProductAvailabilityDate null
AssignedSupplyType null
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount null
Column Name Description
TotalQuantity null
UnrestrictedStkInStkUnit null
QualityInspectionStockQuantity null
TransferStockStorageLocQty null
TransferStockPlantQuantity null
StockInTransitQuantity null
BlockedStockQuantity null
RestrictedStockQuantity null
TiedEmptiesStockQuantity null
GoodsReceiptBlockedStockQty null
OpenSupplyQuantity null
AssignedQuantityInBaseUnit null
NormalAssignedQuantityInBsUnt null
Column Name Description
ProductAvailabilityDate null
RequestedDeliveryDate null
Column Name Description
Column Name Description Domain name
SupAssgmtSource null
PreviewAssignedQuantityInBsUnt null
ARunTmpAssignedQuantityInBsUnt null
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarMonthName Short Text for Fixed Values DDTEXT
CalendarWeek null
CalendarDay Calendar Day NUM2
PurchasingGroup Purchasing Group EKGRP
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • C_SUPDMNDALLDOCNONBATSTKQ.COMPANYCODE == T001.BUKRS
  • C_SUPDMNDALLDOCNONBATSTKQ.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • C_SUPDMNDALLDOCNONBATSTKQ.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
  • C_SUPDMNDALLDOCNONBATSTKQ.MANDT == MARA.MANDT
Customer Number of Plant
  • Customer Number of Plant
  • Client
  • C_SUPDMNDALLDOCNONBATSTKQ.CUSTOMER == KNA1.KUNNR
  • C_SUPDMNDALLDOCNONBATSTKQ.MANDT == KNA1.MANDT
Distribution channel for intercompany billing
  • Distribution channel for intercompany billing
  • Client
  • C_SUPDMNDALLDOCNONBATSTKQ.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_SUPDMNDALLDOCNONBATSTKQ.MANDT == TVTW.MANDT
Division for intercompany billing
  • Division for intercompany billing
  • Client
  • C_SUPDMNDALLDOCNONBATSTKQ.DIVISION == TSPA.SPART
  • C_SUPDMNDALLDOCNONBATSTKQ.MANDT == TSPA.MANDT
Currency Key
  • Client
  • Currency Key
  • C_SUPDMNDALLDOCNONBATSTKQ.MANDT == TCURC.MANDT
  • C_SUPDMNDALLDOCNONBATSTKQ.DOCUMENTCURRENCY == TCURC.WAERS
Material Group
  • Client
  • Material Group
  • C_SUPDMNDALLDOCNONBATSTKQ.MANDT == T023.MANDT
  • C_SUPDMNDALLDOCNONBATSTKQ.MATERIALGROUP == T023.MATKL
Material type
  • Client
  • Material type
  • C_SUPDMNDALLDOCNONBATSTKQ.MANDT == T134.MANDT
  • C_SUPDMNDALLDOCNONBATSTKQ.MATERIALTYPE == T134.MTART
Purchasing organization
  • Client
  • Purchasing organization
  • C_SUPDMNDALLDOCNONBATSTKQ.MANDT == T024E.MANDT
  • C_SUPDMNDALLDOCNONBATSTKQ.PURCHASINGORGANIZATION == T024E.EKORG
Sales District
  • Client
  • Sales District
  • C_SUPDMNDALLDOCNONBATSTKQ.MANDT == T171.MANDT
  • C_SUPDMNDALLDOCNONBATSTKQ.SALESDISTRICT == T171.BZIRK
Sales Organization for Intercompany Billing
  • Sales Organization for Intercompany Billing
  • Client
  • C_SUPDMNDALLDOCNONBATSTKQ.SALESORGANIZATION == TVKO.VKORG
  • C_SUPDMNDALLDOCNONBATSTKQ.MANDT == TVKO.MANDT