1. Home
  2. Resources
  3. SAP Tables
  4. ERCH - Billing Doc. Data

SAP Table ERCH

Billing Doc. Data

ERCH (Billing Doc. Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ERCH to other SAP tables.

ERCH table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BELNR Number of a billing document E_BELNR CHAR 12 0
BUKRS Company Code BUKRS T001 CHAR 4 0
SPARTE Division SPARTE TSPA CHAR 2 0
GPARTNER Business Partner Number BU_PARTNER CHAR 10 0
VKONT Contract Account Number VKONT_KK CHAR 12 0
VERTRAG Contract VERTRAG CHAR 10 0
BEGABRPE Start of billing period BEGABRPE DATS 8 0
ENDABRPE End of billing period ENDABRPE DATS 8 0
ABRDATS Scheduled Billing Date ABRDATS DATS 8 0
ADATSOLL Scheduled meter reading date ADATSOLL DATS 8 0
PTERMTDAT End of billing period from schedule record of portion PTERMTDAT DATS 8 0
BELEGDAT Creation date of billing document BELEGDAT DATS 8 0
ABWVK Alternative contract account for collective bills ABWVK_KK CHAR 12 0
BELNRALT Number of previous document BELNRALT CHAR 12 0
STORNODAT Reversal date STORNODAT DATS 8 0
ABRVORG Billing Transaction ABRVORG CHAR 2 0
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 HVORG_KK TFKHVO CHAR 4 0
KOFIZ Account determination ID for IS-U contracts E_KOFIZ TE097 CHAR 2 0
PORTION Portion PORTION TE420 CHAR 8 0
FORMULAR Form Name TDFORM CHAR 16 0
SIMULATION Indicator: billing simulation SIMULATION CHAR 2 0
NULL No simulation
1 Simulation of billing for budget billing calculation
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 E_BELART TE093 CHAR 2 0
BERGRUND Reason for credit memo/backbilling BERGRUND CHAR 2 0
01 Credit memo
02 Backbilling
BEGNACH Start of backbilling period BEGNACH DATS 8 0
TOBRELEASD Indicator: document not released yet TOBRELEASD CHAR 1 0
NULL Field inactive
X Field active
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
KONZVER Franchise contract KONZVER CHAR 10 0
EROETIM Time of day billing document was created EROETIM CHAR 4 0
ERCHO_V ERCHO exists for ERCH ERCHO_V CHAR 1 0
NULL Field inactive
X Field active
ERCHZ_V ERCHZ exists for ERCH ERCHZ_V CHAR 1 0
NULL Field inactive
X Field active
ERCHU_V ERCHU exists for ERCH ERCHU_V CHAR 1 0
NULL Field inactive
X Field active
ERCHR_V ERCHR exists for ERCH ERCHR_V CHAR 1 0
NULL Field inactive
X Field active
ERCHC_V ERCHC exists for ERCH ERCHC_V CHAR 1 0
NULL Field inactive
X Field active
ERCHV_V ERCHV exists for ERCH ERCHV_V CHAR 1 0
NULL Field inactive
X Field active
ERCHT_V ERCHT exists for ERCH ERCHT_V CHAR 1 0
NULL Field inactive
X Field active
ERCHP_V ERCHP exists for ERCH ERCHP_V CHAR 1 0
NULL Field inactive
X Field active
ERCHE_V ERCHE Available for ERCH ERCHE_V CHAR 1 0
NULL Field inactive
X Field active
ABRVORG2 Billing Transaction that Triggered Period-End Billing ABRVORG2 CHAR 2 0
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)
ABLEINH Meter Reading Unit ABLEINHEIT CHAR 8 0
ENDPRIO Priority of Period-End Billing ENDPRIO CHAR 1 0
NULL Field inactive
X Field active
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
BEGRU Authorization Group BEGRU CHAR 4 0
LOEVM Deletion Indicator LOEVM CHAR 1 0
X Yes
NULL No
ABRDATSU Scheduled billing date for suppressed billing order ABRDATSU DATS 8 0
ABRVORGU Billing Transaction for a Suppressed Billing Order ABRVORGU CHAR 2 0
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)
N_INVSEP Only invoice document jointly with automatic document N_INVSEP CHAR 1 0
NULL Field inactive
X Field active
ABPOPBEL Budget billing plan ABPLANNR CHAR 12 0
MANBILLREL Manual Document Released for Invoicing MANBILLREL CHAR 1 0
NULL Field inactive
X Field active
BACKBI Type of backbilling BACKBI CHAR 1 0
0 No backbilling
1 Floating backbilling
2 Backbilling over the last x periods
PERENDBI Type of period-end billing PERENDBI CHAR 1 0
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 NUMPERBB INT1 3 0
BEGEND Start of period-end billing period BEGEND DATS 8 0
ENDOFBB Indicator: end of backbilling period ENDOFBB CHAR 1 0
NULL Field inactive
X Field active
ENDOFPEB Indicator: end of period-end billing period ENDOFPEB CHAR 1 0
NULL Field inactive
X Field active
NUMPERPEB Number of periods for period-end billing NUMPERPEB INT1 3 0
SC_BELNR_H Number of billing document in adjustment reversal SC_BELNR CHAR 12 0
SC_BELNR_N New billing document number in adjustment reversal SC_BEL_N CHAR 12 0
ZUORDDAA Allocation date for billing E_ZUORDDATABR DATS 8 0
BILLINGRUNNO Number of Billing Run BILLINGRUNNO CHAR 12 0
SIMRUNID Simulation Period ID SIMRUNID CHAR 8 0
KTOKLASSE Account class KTOKLASSE CHAR 4 0
ORIGDOC Origin of Billing Document ORIGDOC CHAR 2 0
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 NOCANC CHAR 1 0
NULL Field inactive
X Field active
ABSCHLPAN Adjust budget billing plan ABSCHLPAN CHAR 1 0
NULL Field inactive
X Field active
MEM_OPBEL Reversed invoicing document no. for new billing/invoicing MEM_OPBEL CHAR 12 0
MEM_BUDAT Posting Date in the Document MEM_BUDAT DATS 8 0
EXBILLDOCNO External document number EXBILLDOCNO CHAR 20 0
BCREASON Reason for Reversal BCREASON TE272 CHAR 2 0
NINVOICE Billing document without invoicing NINVOICE CHAR 1 0
NULL 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 NBILLREL CHAR 1 0
NULL Field inactive
X Field active
CORRECTION_DATE Date when the Error Was Detected ISU_CORRECTION_DATE DATS 8 0
BASDYPER Basic category of dynamic period control BASDYPER CHAR 2 0
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 ESTINBILL CHAR 2 0
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 ESTINBILLU CHAR 2 0
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
ESTINBILL_SAV Original Value from ESTINBILL ESTINBILL_SAV CHAR 2 0
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
ESTINBILL_USAV ESTINBILL_SAV of a Suppressed Billing Order ESTINBILL_USAV CHAR 2 0
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
ACTPERIOD Category of a period for current billing ACTPERIOD CHAR 4 0
ACTPERORG Original Category of a Current Period to be Billed ACTPERORG CHAR 4 0
EZAWE Incoming Payment Method EZAWE_KK CHAR 1 0
DAUBUCH Standing order DAUBUCH CHAR 1 0
NULL Do not set flag
X Set flag
FDGRP Planning Group FDGRP_KK CHAR 10 0
BILLING_PERIOD Billing Key Date (For Example January 2002) E_BILLING_PERIOD CHAR 10 0
OSB_GROUP On-Site Billing Group E_OSB_GROUP TE555 CHAR 3 0
BP_BILL Resulting Billing Period BP_BILL CHAR 1 0
NULL Standard
J Japanese
MAINDOCNO Billing Document Number of Primary Installation MAINDOCNO CHAR 12 0
INSTGRTYPE Grouping Type for Installation Group INSTGRTYPE CHAR 4 0
INSTROLE Role of an Installation Within the Installation Group INSTROLE CHAR 4 0
MDUSREQUESTID MDUS Request ID E_MDUSREQUESTID EMDUSDRQHEAD CHAR 22 0
ASBACH_REL Change to Assessment Basic Relevant ASBACH_REL CHAR 1 0
NULL Field inactive
X Field active

ERCH foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ERCH BCREASON ERCH MANDT TE272 Reasons for Reversal MANDT
ERCH BCREASON ERCH BCREASON TE272 Reasons for Reversal BCREASON
ERCH BELEGART ERCH MANDT TE093 Document Types MANDT
ERCH BELEGART ERCH BELEGART TE093 Document Types BELEGART
ERCH BUKRS ERCH BUKRS T001 Company Codes BUKRS
ERCH BUKRS ERCH MANDT T001 Company Codes MANDT
ERCH HVORG ERCH MANDT TFKHVO Main transactions in contract accts receivable and payable MANDT
ERCH HVORG 'R' TFKHVO Main transactions in contract accts receivable and payable APPLK
ERCH HVORG ERCH HVORG TFKHVO Main transactions in contract accts receivable and payable HVORG
ERCH KOFIZ ERCH KOFIZ TE097 Account Determ. IDs KOFIZ
ERCH KOFIZ ERCH MANDT TE097 Account Determ. IDs MANDT
ERCH KOFIZ ERCH BUKRS TE097 Account Determ. IDs BUKRS
ERCH KOFIZ ERCH SPARTE TE097 Account Determ. IDs SPARTE
ERCH MANDT ERCH MANDT T000 Clients MANDT
ERCH MDUSREQUESTID ERCH MANDT EMDUSDRQHEAD Table of MDUS Request Data MANDT
ERCH MDUSREQUESTID ERCH MDUSREQUESTID EMDUSDRQHEAD Table of MDUS Request Data MDUSREQUESTID
ERCH OSB_GROUP ERCH MANDT TE555 On-Site Billing Billing Groups MANDT
ERCH OSB_GROUP ERCH OSB_GROUP TE555 On-Site Billing Billing Groups OSB_GROUP
ERCH PORTION ERCH MANDT TE420 Sch. Mast. Data: Portion MANDT
ERCH PORTION ERCH PORTION TE420 Sch. Mast. Data: Portion TERMSCHL
ERCH SPARTE ERCH MANDT TSPA Organizational Unit: Sales Divisions MANDT
ERCH SPARTE ERCH SPARTE TSPA Organizational Unit: Sales Divisions SPART