C_ESJIBillingDocumentItemQuery

Billing Document Item | view: CESJIBILGDOCITMQ | Extraction: Not supported | Component: Integration of SAP SD with SAP Jam
Tables used: VBRK, VBRP, MARA, MAKT
Column Name Description
BillingDocument FK Billing Document
BillingDocumentItem Billing Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
ItemNetAmountOfBillingDoc Net Value of Billing item in Document Currency
Column Name Description
📏 Sales unit (BillingQuantityUnit):
BillingQuantity Actual billed quantity
📏 Weight Unit (ItemWeightUnit):
ItemNetWeight Net weight
Column Name Description
Column Name Description
AccountingTransferStatus Status for Transfer to Accounting Show values
ReferenceSDDocumentCategory Reference Document Category Show values
SalesSDDocumentCategory Sales Document Category Show values
Column Name Description Domain name
ObjectType null
CreatedByUser Name of Person Responsible for Creating the Object USNAM
BillingDocumentItemText Material Description TEXT40
PurchaseOrderByCustomer Customer Reference BSTKD
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
AccountingTransferStatusDesc null
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_ESJIBILLINGDOCUMENTITEMQUERY.BASEUNIT == T006.MSEHI
  • C_ESJIBILLINGDOCUMENTITEMQUERY.MANDT == T006.MANDT
Billing Type
  • Client
  • Billing Type
  • C_ESJIBILLINGDOCUMENTITEMQUERY.MANDT == TVFK.MANDT
  • C_ESJIBILLINGDOCUMENTITEMQUERY.BILLINGDOCUMENTTYPE == TVFK.FKART
Sales unit
  • Client
  • Sales unit
  • C_ESJIBILLINGDOCUMENTITEMQUERY.MANDT == T006.MANDT
  • C_ESJIBILLINGDOCUMENTITEMQUERY.BILLINGQUANTITYUNIT == T006.MSEHI
Destination Country/Region of Sales Order
  • Client
  • Destination Country/Region of Sales Order
  • C_ESJIBILLINGDOCUMENTITEMQUERY.MANDT == T005.MANDT
  • C_ESJIBILLINGDOCUMENTITEMQUERY.BILLTOPARTYCOUNTRY == T005.LAND1
Region of Sales Order
  • Region of Sales Order
  • Client
  • Destination Country/Region of Sales Order
  • C_ESJIBILLINGDOCUMENTITEMQUERY.BILLTOPARTYREGION == T005S.BLAND
  • C_ESJIBILLINGDOCUMENTITEMQUERY.MANDT == T005S.MANDT
  • C_ESJIBILLINGDOCUMENTITEMQUERY.BILLTOPARTYCOUNTRY == T005S.LAND1
Division
  • Client
  • Division
  • C_ESJIBILLINGDOCUMENTITEMQUERY.MANDT == TSPA.MANDT
  • C_ESJIBILLINGDOCUMENTITEMQUERY.DIVISION == TSPA.SPART
Volume unit
  • Client
  • Volume unit
  • C_ESJIBILLINGDOCUMENTITEMQUERY.MANDT == T006.MANDT
  • C_ESJIBILLINGDOCUMENTITEMQUERY.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Client
  • Weight Unit
  • C_ESJIBILLINGDOCUMENTITEMQUERY.MANDT == T006.MANDT
  • C_ESJIBILLINGDOCUMENTITEMQUERY.ITEMWEIGHTUNIT == T006.MSEHI
Material Number
  • Client
  • Material Number
  • C_ESJIBILLINGDOCUMENTITEMQUERY.MANDT == MARA.MANDT
  • C_ESJIBILLINGDOCUMENTITEMQUERY.MATERIAL == MARA.MATNR
Division in Sales Order Header
  • Division in Sales Order Header
  • Client
  • C_ESJIBILLINGDOCUMENTITEMQUERY.ORGANIZATIONDIVISION == TSPA.SPART
  • C_ESJIBILLINGDOCUMENTITEMQUERY.MANDT == TSPA.MANDT
Sales Organization
  • Sales Organization
  • Client
  • C_ESJIBILLINGDOCUMENTITEMQUERY.SALESORGANIZATION == TVKO.VKORG
  • C_ESJIBILLINGDOCUMENTITEMQUERY.MANDT == TVKO.MANDT
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • C_ESJIBILLINGDOCUMENTITEMQUERY.MANDT == TVAU.MANDT
  • C_ESJIBILLINGDOCUMENTITEMQUERY.SDDOCUMENTREASON == TVAU.AUGRU