I_SalesOrderItemBillingBlkd

SOFM Sales Order Item Billing Blocked | view: ISLSORDITEMSO04 | 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, CVI_CUST_CT_LINK, BUT000, KNA1, CVI_CUST_LINK, T001W, CVI_VEND_LINK, TJ07, TJ31

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities (2)
📅 Dates
☰ Categorical (1)
Other (12)
🔗 Relations (15)

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
Plant	Plant (Own or External)	WERKS
PlantName	Plant Name	TEXT30
SalesOrderItemText	Short text for sales order item	TEXT40
IncotermsTransferLocation	Incoterms (Part 2)	INCO2
IncotermsLocation1	Incoterms Location 1	INCO_L
IncotermsLocation2	Incoterms Location 2	INCO_L
CustomerPaymentTerms	Terms of payment key	ZTERM
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 Client Sales Organization Distribution Channel	`I_SALESORDERITEMBILLINGBLKD.MANDT == TVKOV.MANDT` `I_SALESORDERITEMBILLINGBLKD.SALESORGANIZATION == TVKOV.VKORG` `I_SALESORDERITEMBILLINGBLKD.DISTRIBUTIONCHANNEL == TVKOV.VTWEG`
Incoterms (Part 1) Client Incoterms (Part 1)	`I_SALESORDERITEMBILLINGBLKD.MANDT == TINC.MANDT` `I_SALESORDERITEMBILLINGBLKD.INCOTERMSCLASSIFICATION == TINC.INCO1`
Incoterms Version Client Incoterms Version	`I_SALESORDERITEMBILLINGBLKD.MANDT == TINCV.MANDT` `I_SALESORDERITEMBILLINGBLKD.INCOTERMSVERSION == TINCV.INCOV`
Billing Block for Item Client Billing Block for Item	`I_SALESORDERITEMBILLINGBLKD.MANDT == TVFS.MANDT` `I_SALESORDERITEMBILLINGBLKD.ITEMBILLINGBLOCKREASON == TVFS.FAKSP`
Material: order item Client Material Number	`I_SALESORDERITEMBILLINGBLKD.MANDT == MARA.MANDT` `I_SALESORDERITEMBILLINGBLKD.MATERIAL == MARA.MATNR`
Sales unit Client Sales unit	`I_SALESORDERITEMBILLINGBLKD.MANDT == T006.MANDT` `I_SALESORDERITEMBILLINGBLKD.ORDERQUANTITYUNIT == T006.MSEHI`
Division in order header Client Sales Organization Division Distribution Channel	`I_SALESORDERITEMBILLINGBLKD.MANDT == TVTA.MANDT` `I_SALESORDERITEMBILLINGBLKD.SALESORGANIZATION == TVTA.VKORG` `I_SALESORDERITEMBILLINGBLKD.ORGANIZATIONDIVISION == TVTA.SPART` `I_SALESORDERITEMBILLINGBLKD.DISTRIBUTIONCHANNEL == TVTA.VTWEG`
Route Client Route	`I_SALESORDERITEMBILLINGBLKD.MANDT == TVRO.MANDT` `I_SALESORDERITEMBILLINGBLKD.ROUTE == TVRO.ROUTE`
Sales document item category Client Sales document item category	`I_SALESORDERITEMBILLINGBLKD.MANDT == TVPT.MANDT` `I_SALESORDERITEMBILLINGBLKD.SALESORDERITEMCATEGORY == TVPT.PSTYV`
Order type in order header Client Sales Document Type	`I_SALESORDERITEMBILLINGBLKD.MANDT == TVAK.MANDT` `I_SALESORDERITEMBILLINGBLKD.SALESORDERTYPE == TVAK.AUART`
Sales organization in order header Client Sales Organization	`I_SALESORDERITEMBILLINGBLKD.MANDT == TVKO.MANDT` `I_SALESORDERITEMBILLINGBLKD.SALESORGANIZATION == TVKO.VKORG`
Shipping Point / Receiving Point Client Shipping Point / Receiving Point	`I_SALESORDERITEMBILLINGBLKD.MANDT == TVST.MANDT` `I_SALESORDERITEMBILLINGBLKD.SHIPPINGPOINT == TVST.VSTEL`
Target Quantity UoM Client Target Quantity UoM	`I_SALESORDERITEMBILLINGBLKD.MANDT == T006.MANDT` `I_SALESORDERITEMBILLINGBLKD.TARGETQUANTITYUNIT == T006.MSEHI`
SD Document Currency Client SD Document Currency	`I_SALESORDERITEMBILLINGBLKD.MANDT == TCURC.MANDT` `I_SALESORDERITEMBILLINGBLKD.TRANSACTIONCURRENCY == TCURC.WAERS`