SAP table ERCH (Billing Doc. Data)

SAP table ERCH has 2 primary key fields being MANDT,BELNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BELNR Billing Document Number CHAR 12 0 E_BELNR
BUKRS Company Code CHAR 4 0 T001 BUKRS
SPARTE Division CHAR 2 0 TSPA SPARTE
GPARTNER Business Partner Number CHAR 10 0 BU_PARTNER
VKONT Contract Account Number CHAR 12 0 VKONT_KK
VERTRAG Contract CHAR 10 0 VERTRAG
BEGABRPE Start of billing period DATS 8 0 BEGABRPE
ENDABRPE End of billing period DATS 8 0 ENDABRPE
ABRDATS Scheduled Billing Date DATS 8 0 ABRDATS
ADATSOLL Scheduled meter reading date DATS 8 0 ADATSOLL
PTERMTDAT End of billing period from schedule record of portion DATS 8 0 PTERMTDAT
BELEGDAT Creation Date of Billing Document DATS 8 0 BELEGDAT
ABWVK Alternative Contract Account for Collective Bills CHAR 12 0 ABWVK_KK
BELNRALT Number of previous document CHAR 12 0 BELNRALT
STORNODAT Reversal date DATS 8 0 STORNODAT
ABRVORG Billing Transaction CHAR 2 0 ABRVORG
01 Periodic Billing (01)
02 Interim Billing (02)
03 Final Billing for Move-Out (03)
04 Period-End Billing (04)
05 Service Territory Transfer (05)
06 Manual Credit Memo/Backbilling (06)
07 Contract Change (07)
08 Customer change (08)
HVORG Main Transaction for Line Item CHAR 4 0 TFKHVO HVORG_KK
KOFIZ Account determination ID for IS-U contracts CHAR 2 0 TE097 E_KOFIZ
PORTION Portion CHAR 8 0 TE420 PORTION
FORMULAR Form name CHAR 16 0 TDFORM
SIMULATION Indicator: billing simulation CHAR 2 0 SIMULATION
No simulation
1 Simulation of billing for budget billing calculation
10 Simulation with Alternative Rate Categories
2 Sim. of billing for extrapolation in unbilled rev. reporting
3 Simulation of billing without billing order
4 Simulation of billing with billing order
5 Simulation of billing for overall check
6 Billing Simulation with Billing Order from Billing
7 Simulation by Extraploation of Previous Document
8 Customer-Specific Simulation
9 Internal Simulation Without Order During Backbilling
BELEGART Document type CHAR 2 0 TE093 E_BELART
BERGRUND Reason for credit memo/backbilling CHAR 2 0 BERGRUND
01 Credit memo
02 Backbilling
BEGNACH Start of backbilling period DATS 8 0 BEGNACH
TOBRELEASD Indicator: document not released yet CHAR 1 0 TOBRELEASD
TXJCD Tax Jurisdiction CHAR 15 0 TXJCD
KONZVER Franchise contract CHAR 10 0 KONZVER
EROETIM Time of day billing document was created CHAR 4 0 EROETIM
ERCHO_V ERCHO exists for ERCH CHAR 1 0 ERCHO_V
ERCHZ_V ERCHZ exists for ERCH CHAR 1 0 ERCHZ_V
ERCHU_V ERCHU exists for ERCH CHAR 1 0 ERCHU_V
ERCHR_V ERCHR exists for ERCH CHAR 1 0 ERCHR_V
ERCHC_V ERCHC exists for ERCH CHAR 1 0 ERCHC_V
ERCHV_V ERCHV exists for ERCH CHAR 1 0 ERCHV_V
ERCHT_V ERCHT exists for ERCH CHAR 1 0 ERCHT_V
ERCHP_V ERCHP exists for ERCH CHAR 1 0 ERCHP_V
ERCHE_V ERCHE Available for ERCH CHAR 1 0 ERCHE_V
ABRVORG2 Billing Transaction that Triggered Period-End Billing CHAR 2 0 ABRVORG2
ABLEINH Meter Reading Unit CHAR 8 0 ABLEINHEIT
ENDPRIO Priority of Period-End Billing CHAR 1 0 ENDPRIO
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
BEGRU Authorization Group CHAR 4 0 BEGRU
LOEVM Deletion Indicator CHAR 1 0 LOEVM
ABRDATSU Scheduled billing date for suppressed billing order DATS 8 0 ABRDATSU
ABRVORGU Billing Transaction for a Suppressed Billing Order CHAR 2 0 ABRVORGU
N_INVSEP Only invoice document jointly with automatic document CHAR 1 0 N_INVSEP
ABPOPBEL Budget billing plan CHAR 12 0 ABPLANNR
MANBILLREL Manual Document Released for Invoicing CHAR 1 0 MANBILLREL
BACKBI Type of backbilling CHAR 1 0 BACKBI
0 No backbilling
1 Floating backbilling
2 Backbilling over the last x periods
PERENDBI Type of period-end billing CHAR 1 0 PERENDBI
0 No period-end billing
1 Period-end billing integrated with last periodic billing
2 Separate period-end billing
NUMPERBB Number of periods for backbilling INT1 3 0 NUMPERBB
BEGEND Start of period-end billing period DATS 8 0 BEGEND
ENDOFBB Indicator: end of backbilling period CHAR 1 0 ENDOFBB
ENDOFPEB Indicator: end of period-end billing period CHAR 1 0 ENDOFPEB
NUMPERPEB Number of periods for period-end billing INT1 3 0 NUMPERPEB
SC_BELNR_H Number of billing document in adjustment reversal CHAR 12 0 SC_BELNR
SC_BELNR_N New billing document number in adjustment reversal CHAR 12 0 SC_BEL_N
ZUORDDAA Allocation date for billing DATS 8 0 E_ZUORDDATABR
BILLINGRUNNO Number of Billing Run CHAR 12 0 BILLINGRUNNO
SIMRUNID Simulation Period ID CHAR 8 0 SIMRUNID
KTOKLASSE Account Class CHAR 4 0 KTOKLASSE
ORIGDOC Origin of Billing Document CHAR 2 0 ORIGDOC
01 Old document
02 Non-Reversable External Document
03 On-site document
04 External Deregulation Document Without Delete Function
05 External Deregulation Document with Delete Function
06 Bonus document from multiple contract billing
07 Document Without Invoicing Created By Migration
08 Reversable External Document
09 Document from Billing at Move-In
10 Old Doc. from Migration (Doc. Lines in Old Doc. Data Pool
11 Manual Document as Result of Correction to Old Document Line
12 Mass Simulation Document is Copy of Actual Document
NOCANC Indicator: do not execute billing reversal CHAR 1 0 NOCANC
ABSCHLPAN Adjust budget billing plan CHAR 1 0 ABSCHLPAN
MEM_OPBEL Reversed invoicing document no. for new billing/invoicing CHAR 12 0 MEM_OPBEL
MEM_BUDAT Posting Date in the Document DATS 8 0 MEM_BUDAT
EXBILLDOCNO External document number CHAR 20 0 EXBILLDOCNO
BCREASON Reason for Reversal CHAR 2 0 TE272 BCREASON
NINVOICE Billing document without invoicing CHAR 1 0 NINVOICE
Billing document that is used normally for invoicing
1 NOT invoiced due to customer/contract change or cancellation
2 NOT invoiced due to migration
3 NOT invoiced due to customer decision (EXIT_SAPLEABW_001)
4 NOT invoiced due to customer/contract change (final)
NBILLREL Not relevant to billing CHAR 1 0 NBILLREL
CORRECTION_DATE Date when the Error Was Detected DATS 8 0 ISU_CORRECTION_DATE
BASDYPER Basic category of dynamic period control CHAR 2 0 BASDYPER
01 Determination of Current Periods Via Meter Reading Results
02 Estimation of Meter Reading Results in Billing
ESTINBILL Meter Reading Results are Estimated in Billing CHAR 2 0 ESTINBILL
01 Billing Estimates Value from Meter Reading Unit
02 Billing Estimates Value Changed by Mass Report
03 Billing Estimates Value Changed by Individual Report
04 Billing Does Not Estimate Value Deleted by Individual Report
ESTINBILLU ESTINBILL of a Suppressed Billing Order CHAR 2 0 ESTINBILLU
ESTINBILL_SAV Original Value from ESTINBILL CHAR 2 0 ESTINBILL_SAV
ESTINBILL_USAV ESTINBILL_SAV of a Suppressed Billing Order CHAR 2 0 ESTINBILL_USAV
ACTPERIOD Category of a period for current billing CHAR 4 0 ACTPERIOD
ACTPERORG Original Category of a Current Period to be Billed CHAR 4 0 ACTPERORG
EZAWE Incoming Payment Method CHAR 1 0 EZAWE_KK
DAUBUCH Standing order CHAR 1 0 DAUBUCH
FDGRP Planning Group CHAR 10 0 FDGRP_KK
BILLING_PERIOD Billing Key Date (For Example January 2002) CHAR 10 0 E_BILLING_PERIOD
OSB_GROUP On-Site Billing Group CHAR 3 0 TE555 E_OSB_GROUP
BP_BILL Resulting Billing Period CHAR 1 0 BP_BILL
Standard
J Japanese
DUMMY_UTILBILLGDOC_INCL_EEW_TS Dummy for Extensibility of Utilities Billing Document CHAR 1 0 E_UTILSBILLINGDOC_INCL_EEW
MAINDOCNO Billing Document Number of Primary Installation CHAR 12 0 MAINDOCNO
INSTGRTYPE Grouping Type for Installation Group CHAR 4 0 INSTGRTYPE
INSTROLE Role of an Installation Within the Installation Group CHAR 4 0 INSTROLE
MDUSREQUESTID MDUS Request ID CHAR 22 0 EMDUSDRQHEAD E_MDUSREQUESTID
ASBACH_REL Change to Assessment Basic Relevant CHAR 1 0 ASBACH_REL
ISU2CI_CATEGORY Integration Category in Convergent Invoicing CHAR 4 0 TE482 ISU2CI_CATEGORY
COLOGRP_INST Colocation group for Installation CHAR 12 0 E_COLOGRP_INST
COLOGRP_INST_L Colocation group for Installation CHAR 12 0 E_COLOGRP_INST
COLOGRP_BP_TAX Colocation group for Business Partner CHAR 12 0 E_COLOGRP_BP

ERCH foreign key relationships

Table Field Check Table Check Field
0 ERCH BCREASON TE272 Reasons for Reversal MANDT
0 ERCH BCREASON TE272 Reasons for Reversal BCREASON
1 ERCH BELEGART TE093 Document Types MANDT
1 ERCH BELEGART TE093 Document Types BELEGART
0 ERCH BUKRS T001 Company Codes BUKRS
1 ERCH HVORG TFKHVO Main transactions in contract accts receivable and payable MANDT
1 ERCH HVORG TFKHVO Main transactions in contract accts receivable and payable HVORG
0 ERCH ISU2CI_CATEGORY TE482 Type of Integration with Convergent Invoicing MANDT
1 ERCH KOFIZ TE097 Account Determ. IDs MANDT
1 ERCH KOFIZ TE097 Account Determ. IDs BUKRS
1 ERCH KOFIZ TE097 Account Determ. IDs KOFIZ
0 ERCH MANDT T000 Clients MANDT
1 ERCH MDUSREQUESTID EMDUSDRQHEAD Table of MDUS Request Data MANDT
0 ERCH OSB_GROUP TE555 On-Site Billing Billing Groups MANDT
0 ERCH OSB_GROUP TE555 On-Site Billing Billing Groups OSB_GROUP
1 ERCH PORTION TE420 Sch. Mast. Data: Portion MANDT
0 ERCH SPARTE TSPA Organizational Unit: Sales Divisions MANDT
0 ERCH SPARTE TSPA Organizational Unit: Sales Divisions SPART