C_ESJIBillingDocumentQuery

Billing Document | view: CESJIBILLINGDOCQ | Extraction: Not supported | Component: Integration of SAP SD with SAP Jam
Tables used: VBRK, VBPA, VBPA, TVFK, TVFKT, CVI_CUST_CT_LINK, BUT000, KNA1, TVZB, TVZBT, CVI_CUST_LINK, TINC, TINCT, CVI_VEND_LINK, TVBST
Column Name Description
BillingDocument Billing Document
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value in Document Currency
NetAmountInDisplayCurrency Net Value in Display Currency
Column Name Description
Column Name Description
CreationDate Date on which the record was created
LastChangeDate Last Changed On
BillingDocumentDate Billing Date
ExchangeRateDate Translation date
Column Name Description
SDDocumentCategory SD Document Category Show values
BillingDocumentCategory Billing Category Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
AccountingTransferStatus Status for Transfer to Accounting Show values
Column Name Description Domain name
ObjectType null
BillingDocumentTypeName Description TEXT40
CreatedByUser Name of Person Responsible for Creating the Object USNAM
PayerPartyName Name of Customer TEXT80
BillToPartyName Name of Customer TEXT80
IncotermsClassificationName Description TEXT30
CustomerPaymentTerms Terms of payment key ZTERM
CustomerPaymentTermsName Description of terms of payment TEXT30
DocumentReferenceID Reference Document Number XBLNR1
SoldToPartyName Name of Customer TEXT80
PurchaseOrderByCustomer Customer Reference BSTKD
AccountingTransferStatusDesc Short Text for Fixed Values DDTEXT
OverallSDProcessStatusDesc Status Description TEXT20
Master Data Relations Join Conditions
Billing Type
  • Client
  • Billing Type
  • C_ESJIBILLINGDOCUMENTQUERY.MANDT == TVFK.MANDT
  • C_ESJIBILLINGDOCUMENTQUERY.BILLINGDOCUMENTTYPE == TVFK.FKART
Customer - Document Customer
  • Client
  • Bill-to Party
  • C_ESJIBILLINGDOCUMENTQUERY.MANDT == KNA1.MANDT
  • C_ESJIBILLINGDOCUMENTQUERY.BILLTOPARTY == KNA1.KUNNR
Company Code
  • Company Code
  • Client
  • C_ESJIBILLINGDOCUMENTQUERY.COMPANYCODE == T001.BUKRS
  • C_ESJIBILLINGDOCUMENTQUERY.MANDT == T001.MANDT
Destination Country/Region
  • Client
  • Destination Country/Region
  • C_ESJIBILLINGDOCUMENTQUERY.MANDT == T005.MANDT
  • C_ESJIBILLINGDOCUMENTQUERY.COUNTRY == T005.LAND1
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • C_ESJIBILLINGDOCUMENTQUERY.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • C_ESJIBILLINGDOCUMENTQUERY.MANDT == TVKT.MANDT
Customer Group
  • Customer Group
  • Client
  • C_ESJIBILLINGDOCUMENTQUERY.CUSTOMERGROUP == T151.KDGRP
  • C_ESJIBILLINGDOCUMENTQUERY.MANDT == T151.MANDT
Customer Price Group
  • Customer Price Group
  • Client
  • C_ESJIBILLINGDOCUMENTQUERY.CUSTOMERPRICEGROUP == T188.KONDA
  • C_ESJIBILLINGDOCUMENTQUERY.MANDT == T188.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • C_ESJIBILLINGDOCUMENTQUERY.MANDT == TVTW.MANDT
  • C_ESJIBILLINGDOCUMENTQUERY.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_ESJIBILLINGDOCUMENTQUERY.MANDT == TSPA.MANDT
  • C_ESJIBILLINGDOCUMENTQUERY.DIVISION == TSPA.SPART
Dunning Area
  • Company Code
  • Client
  • Dunning Area
  • C_ESJIBILLINGDOCUMENTQUERY.COMPANYCODE == T047M.BUKRS
  • C_ESJIBILLINGDOCUMENTQUERY.MANDT == T047M.MANDT
  • C_ESJIBILLINGDOCUMENTQUERY.DUNNINGAREA == T047M.MABER
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • C_ESJIBILLINGDOCUMENTQUERY.MANDT == TCURV.MANDT
  • C_ESJIBILLINGDOCUMENTQUERY.EXCHANGERATETYPE == TCURV.KURST
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • C_ESJIBILLINGDOCUMENTQUERY.MANDT == TINC.MANDT
  • C_ESJIBILLINGDOCUMENTQUERY.INCOTERMSCLASSIFICATION == TINC.INCO1
Payer
  • Client
  • Payer
  • C_ESJIBILLINGDOCUMENTQUERY.MANDT == KNA1.MANDT
  • C_ESJIBILLINGDOCUMENTQUERY.PAYERPARTY == KNA1.KUNNR
Price List Type
  • Client
  • Price List Type
  • C_ESJIBILLINGDOCUMENTQUERY.MANDT == T189.MANDT
  • C_ESJIBILLINGDOCUMENTQUERY.PRICELISTTYPE == T189.PLTYP
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Destination Country/Region
  • C_ESJIBILLINGDOCUMENTQUERY.MANDT == T005S.MANDT
  • C_ESJIBILLINGDOCUMENTQUERY.REGION == T005S.BLAND
  • C_ESJIBILLINGDOCUMENTQUERY.COUNTRY == T005S.LAND1
Sales Organization
  • Client
  • Sales Organization
  • C_ESJIBILLINGDOCUMENTQUERY.MANDT == TVKO.MANDT
  • C_ESJIBILLINGDOCUMENTQUERY.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Client
  • Sold-to Party
  • C_ESJIBILLINGDOCUMENTQUERY.MANDT == KNA1.MANDT
  • C_ESJIBILLINGDOCUMENTQUERY.SOLDTOPARTY == KNA1.KUNNR
SD Document Currency
  • Client
  • SD Document Currency
  • C_ESJIBILLINGDOCUMENTQUERY.MANDT == TCURC.MANDT
  • C_ESJIBILLINGDOCUMENTQUERY.TRANSACTIONCURRENCY == TCURC.WAERS