ESH_N_BILLINGDOCUMENT

Anchor view -BILLINGDOCUMENT | view: ESH_L_BILLGDOC | TRAN | Extraction: Not supported | Component: Billing
Tables used: VBRK, VBRP, VBPA, VBPA, ADCP, ADRC, TVFK, TVFKT, CVI_CUST_CT_LINK, BUT000, T001, TKA02, KNA1, TVZB, TVZBT, CVI_CUST_LINK, MARA, MAKT, TVKO, TVKOT, CVI_VEND_LINK
Column Name Description
BILLINGDOCUMENT Billing Document
Column Name Description
💲 SD Document Currency (TRANSACTIONCURRENCY):
TOTALNETAMOUNT Net Value in Document Currency
TOTALTAXAMOUNT Tax Amount in Document Currency
Column Name Description
Column Name Description
BILLINGDOCUMENTDATE Billing Date
Column Name Description
BILLINGDOCUMENTISTEMPORARY IsDraft Indicator Show values
BILLINGISSUETYPE Billing Issue Type Show values
OVERALLBILLINGSTATUS SD Billing Status Show values
Column Name Description Domain name
BILLINGDOCUMENTITEMTEXT Short text for sales order item TEXT40
BILLINGDOCUMENTTYPENAME Description TEXT40
BILLINGISSUETYPENAME Short Text for Fixed Values DDTEXT
BILLTOPARTYNAME Name 1 TEXT40
PAYERPARTYNAME Name 1 TEXT40
SOLDTOPARTYNAME Name 1 TEXT40
COMPANYCODENAME Name of Company Code or Company TEXT25
CUSTOMERPAYMENTTERMS Terms of payment key ZTERM
CUSTOMERPAYMENTTERMSNAME Description of terms of payment TEXT30
DOCUMENTREFERENCEID Reference Document Number XBLNR1
MATERIALNAME Material Description TEXT40
OVERALLBILLINGSTATUSDESC Short Text for Fixed Values DDTEXT
SALESORGANIZATIONNAME Sales Organization Description TEXT20
Master Data Relations Join Conditions
Billing Type
  • Billing Type
  • Client
  • ESH_N_BILLINGDOCUMENT.BILLINGDOCUMENTTYPE == TVFK.FKART
  • ESH_N_BILLINGDOCUMENT.MANDT == TVFK.MANDT
Customer - Document Customer
  • Customer Number
  • Client
  • ESH_N_BILLINGDOCUMENT.BILLTOPARTY == KNA1.KUNNR
  • ESH_N_BILLINGDOCUMENT.MANDT == KNA1.MANDT
Company Code
  • Company Code
  • Client
  • ESH_N_BILLINGDOCUMENT.COMPANYCODE == T001.BUKRS
  • ESH_N_BILLINGDOCUMENT.MANDT == T001.MANDT
Material Number
  • Client
  • Material Number
  • ESH_N_BILLINGDOCUMENT.MANDT == MARA.MANDT
  • ESH_N_BILLINGDOCUMENT.MATERIAL == MARA.MATNR
Payer
  • Payer
  • Client
  • ESH_N_BILLINGDOCUMENT.PAYERPARTY == KNA1.KUNNR
  • ESH_N_BILLINGDOCUMENT.MANDT == KNA1.MANDT
Sales Organization
  • Sales Organization
  • Client
  • ESH_N_BILLINGDOCUMENT.SALESORGANIZATION == TVKO.VKORG
  • ESH_N_BILLINGDOCUMENT.MANDT == TVKO.MANDT
Sold-to Party
  • Client
  • Sold-to Party
  • ESH_N_BILLINGDOCUMENT.MANDT == KNA1.MANDT
  • ESH_N_BILLINGDOCUMENT.SOLDTOPARTY == KNA1.KUNNR
SD Document Currency
  • SD Document Currency
  • Client
  • ESH_N_BILLINGDOCUMENT.TRANSACTIONCURRENCY == TCURC.WAERS
  • ESH_N_BILLINGDOCUMENT.MANDT == TCURC.MANDT