C_SlsDocItemUnconfdQty

Sales Doc Item With Unconf. Quantity | view: CSLSDOCITEMSO06 | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, VBAK, VBAP, VBKD, VEDA, VBAP, VBEP, MARA, KNMT, MAKT, MARA, MVKE, TVSTT
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Unit of the Requested Quantity (RequestedQuantityUnit):
RequestedQuantity Requested Quantity
📏 Sales unit (OrderQuantityUnit):
ConfdDelivQtyInOrderQtyUnit Cumulative Confirmed Quantity in Sales Unit
Column Name Description
RequestedDeliveryDate Requested Delivery Date
Column Name Description
DeliveryStatus Delivery Status (Item) Show values
DeliveryConfirmationStatus Delivery Confirmation Status (Item) Show values
SDProcessStatus Overall Processing Status (Item) Show values
OrderRelatedBillingStatus Order-Related Billing Status (Item) Show values
Column Name Description Domain name
DueDays Next Action in Days DUE_DAYS
MaterialName Material Description TEXT40
Plant Plant (Own or External) WERKS
MaterialByCustomer Material Number Used by Customer IDNEX
SalesDocumentItemText Short text for sales order item TEXT40
ShippingPointName Description TEXT30
DeliveryConfStatusCriticality null
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Client
  • Product Number
  • Plant (Own or External)
  • C_SLSDOCITEMUNCONFDQTY.BATCH == MCHA.CHARG
  • C_SLSDOCITEMUNCONFDQTY.MANDT == MCHA.MANDT
  • C_SLSDOCITEMUNCONFDQTY.MATERIAL == MCHA.MATNR
  • C_SLSDOCITEMUNCONFDQTY.PLANT == MCHA.WERKS
Material: order item
  • Client
  • Product Number
  • C_SLSDOCITEMUNCONFDQTY.MANDT == MARA.MANDT
  • C_SLSDOCITEMUNCONFDQTY.MATERIAL == MARA.MATNR
Product Group
  • Client
  • Product Group
  • C_SLSDOCITEMUNCONFDQTY.MANDT == T023.MANDT
  • C_SLSDOCITEMUNCONFDQTY.MATERIALGROUP == T023.MATKL
Sales unit
  • Client
  • Sales unit
  • C_SLSDOCITEMUNCONFDQTY.MANDT == T006.MANDT
  • C_SLSDOCITEMUNCONFDQTY.ORDERQUANTITYUNIT == T006.MSEHI
Sales document item category
  • Client
  • Sales document item category
  • C_SLSDOCITEMUNCONFDQTY.MANDT == TVPT.MANDT
  • C_SLSDOCITEMUNCONFDQTY.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_SLSDOCITEMUNCONFDQTY.MANDT == TVST.MANDT
  • C_SLSDOCITEMUNCONFDQTY.SHIPPINGPOINT == TVST.VSTEL
Storage location
  • Client
  • Storage location
  • Plant (Own or External)
  • C_SLSDOCITEMUNCONFDQTY.MANDT == T001L.MANDT
  • C_SLSDOCITEMUNCONFDQTY.STORAGELOCATION == T001L.LGORT
  • C_SLSDOCITEMUNCONFDQTY.PLANT == T001L.WERKS
SD Document Currency
  • Client
  • SD Document Currency
  • C_SLSDOCITEMUNCONFDQTY.MANDT == TCURC.MANDT
  • C_SLSDOCITEMUNCONFDQTY.TRANSACTIONCURRENCY == TCURC.WAERS