C_SalesOrderItemBillingBlkdQ

SOFM Sales Order Item Billing Blocked Query | view: CSLSORDITEMSO04Q | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, LIKP, LIPS, VBKD, VEDA, VBAK, FPLT, VBAK, VBAP, VBKD, VEDA, VBAP, VBEP, JEST, JSTO, VBPA, VBPA, TVFS, TVFST, CVI_CUST_CT_LINK, BUT000, KNA1, TVZB, TVZBT, CVI_CUST_LINK, TINC, TINCT, TINCV, TINCVT, T001W, TVRO, TVROT, TVAP, TVAPT, TVST, TVSTT, CVI_VEND_LINK, TJ07, TJ31
Column Name Description
SalesOrder FK Sales Order
SalesOrderItem Sales Order Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Sales unit (OrderQuantityUnit):
OrderQuantity Cumulative order quantity in sales units
📏 Target Quantity UoM (TargetQuantityUnit):
TargetQuantity Target Quantity in Sales Units
Column Name Description
Column Name Description
CtrlgObjStatusIsBillingBlkd User Status Invoicing Blocked Show values
Column Name Description Domain name
DueDays Next Action in Days DUE_DAYS
SalesOrderItemCategoryName Description TEXT20
ProductionPlant Plant (Own or External) WERKS
PlantName Plant Name TEXT30
SalesOrderItemText Short text for sales order item TEXT40
ShippingPointName Description TEXT30
IncotermsClassificationName Description TEXT30
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
IncotermsVersionName Description TEXT30
RouteName Route Description TEXT40
BillingBlockReasonDescription Billing Block Description TEXT20
CustomerPaymentTerms Terms of payment key ZTERM
CustomerPaymentTermsName Description of terms of payment TEXT30
ShipToParty Ship-to Party KUNNR
ShipToPartyName Name of Ship-to Party TEXT80
BillToParty Bill-to Party KUNNR
BillToPartyName Name of Bill-to Party TEXT80
Master Data Relations Join Conditions
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • C_SALESORDERITEMBILLINGBLKDQ.SALESORGANIZATION == TVKOV.VKORG
  • C_SALESORDERITEMBILLINGBLKDQ.MANDT == TVKOV.MANDT
  • C_SALESORDERITEMBILLINGBLKDQ.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_SALESORDERITEMBILLINGBLKDQ.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_SALESORDERITEMBILLINGBLKDQ.MANDT == TINC.MANDT
Incoterms Version
  • Client
  • Incoterms Version
  • C_SALESORDERITEMBILLINGBLKDQ.MANDT == TINCV.MANDT
  • C_SALESORDERITEMBILLINGBLKDQ.INCOTERMSVERSION == TINCV.INCOV
Billing Block for Item
  • Client
  • Billing Block for Item
  • C_SALESORDERITEMBILLINGBLKDQ.MANDT == TVFS.MANDT
  • C_SALESORDERITEMBILLINGBLKDQ.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
Material: order item
  • Material Number
  • Client
  • C_SALESORDERITEMBILLINGBLKDQ.MATERIAL == MARA.MATNR
  • C_SALESORDERITEMBILLINGBLKDQ.MANDT == MARA.MANDT
Sales unit
  • Sales unit
  • Client
  • C_SALESORDERITEMBILLINGBLKDQ.ORDERQUANTITYUNIT == T006.MSEHI
  • C_SALESORDERITEMBILLINGBLKDQ.MANDT == T006.MANDT
Division in order header
  • Division
  • Sales Organization
  • Client
  • Distribution Channel
  • C_SALESORDERITEMBILLINGBLKDQ.ORGANIZATIONDIVISION == TVTA.SPART
  • C_SALESORDERITEMBILLINGBLKDQ.SALESORGANIZATION == TVTA.VKORG
  • C_SALESORDERITEMBILLINGBLKDQ.MANDT == TVTA.MANDT
  • C_SALESORDERITEMBILLINGBLKDQ.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Route
  • Client
  • Route
  • C_SALESORDERITEMBILLINGBLKDQ.MANDT == TVRO.MANDT
  • C_SALESORDERITEMBILLINGBLKDQ.ROUTE == TVRO.ROUTE
Sales document item category
  • Client
  • Sales document item category
  • C_SALESORDERITEMBILLINGBLKDQ.MANDT == TVPT.MANDT
  • C_SALESORDERITEMBILLINGBLKDQ.SALESORDERITEMCATEGORY == TVPT.PSTYV
Order type in order header
  • Sales Document Type
  • Client
  • C_SALESORDERITEMBILLINGBLKDQ.SALESORDERTYPE == TVAK.AUART
  • C_SALESORDERITEMBILLINGBLKDQ.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • C_SALESORDERITEMBILLINGBLKDQ.SALESORGANIZATION == TVKO.VKORG
  • C_SALESORDERITEMBILLINGBLKDQ.MANDT == TVKO.MANDT
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_SALESORDERITEMBILLINGBLKDQ.MANDT == TVST.MANDT
  • C_SALESORDERITEMBILLINGBLKDQ.SHIPPINGPOINT == TVST.VSTEL
Target Quantity UoM
  • Client
  • Target Quantity UoM
  • C_SALESORDERITEMBILLINGBLKDQ.MANDT == T006.MANDT
  • C_SALESORDERITEMBILLINGBLKDQ.TARGETQUANTITYUNIT == T006.MSEHI
SD Document Currency
  • Client
  • SD Document Currency
  • C_SALESORDERITEMBILLINGBLKDQ.MANDT == TCURC.MANDT
  • C_SALESORDERITEMBILLINGBLKDQ.TRANSACTIONCURRENCY == TCURC.WAERS