C_SlsDocItemBillingBlkd

Sales Doc Item Billing Blocked | view: CSLSDOCITEMSO04 | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, LIKP, LIPS, VBAK, FPLT, VBAK, VBAP, VBKD, VEDA, VBAP, VBEP, JEST, JSTO, MARA, KNMT, MAKT, MARA, MVKE, TVSTT, TJ07, TJ31
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
CtrlgObjStatusIsBillingBlkd User Status Invoicing Blocked Show values
DeliveryStatus Delivery 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
CustomerPaymentTerms Terms of payment key ZTERM
ShippingPointName Description TEXT30
ItmBillgBlockReasonCriticality null
CtrlgObjStsIsBillgBlkdCritlty null
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Product Number
  • Plant (Own or External)
  • Client
  • C_SLSDOCITEMBILLINGBLKD.BATCH == MCHA.CHARG
  • C_SLSDOCITEMBILLINGBLKD.MATERIAL == MCHA.MATNR
  • C_SLSDOCITEMBILLINGBLKD.PLANT == MCHA.WERKS
  • C_SLSDOCITEMBILLINGBLKD.MANDT == MCHA.MANDT
Billing Block for Item
  • Billing Block for Item
  • Client
  • C_SLSDOCITEMBILLINGBLKD.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • C_SLSDOCITEMBILLINGBLKD.MANDT == TVFS.MANDT
Material: order item
  • Product Number
  • Client
  • C_SLSDOCITEMBILLINGBLKD.MATERIAL == MARA.MATNR
  • C_SLSDOCITEMBILLINGBLKD.MANDT == MARA.MANDT
Product Group
  • Product Group
  • Client
  • C_SLSDOCITEMBILLINGBLKD.MATERIALGROUP == T023.MATKL
  • C_SLSDOCITEMBILLINGBLKD.MANDT == T023.MANDT
Sales unit
  • Client
  • Sales unit
  • C_SLSDOCITEMBILLINGBLKD.MANDT == T006.MANDT
  • C_SLSDOCITEMBILLINGBLKD.ORDERQUANTITYUNIT == T006.MSEHI
Sales document item category
  • Client
  • Sales document item category
  • C_SLSDOCITEMBILLINGBLKD.MANDT == TVPT.MANDT
  • C_SLSDOCITEMBILLINGBLKD.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • C_SLSDOCITEMBILLINGBLKD.SHIPPINGPOINT == TVST.VSTEL
  • C_SLSDOCITEMBILLINGBLKD.MANDT == TVST.MANDT
Storage location
  • Storage location
  • Plant (Own or External)
  • Client
  • C_SLSDOCITEMBILLINGBLKD.STORAGELOCATION == T001L.LGORT
  • C_SLSDOCITEMBILLINGBLKD.PLANT == T001L.WERKS
  • C_SLSDOCITEMBILLINGBLKD.MANDT == T001L.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • C_SLSDOCITEMBILLINGBLKD.MANDT == TCURC.MANDT
  • C_SLSDOCITEMBILLINGBLKD.TRANSACTIONCURRENCY == TCURC.WAERS