ERCH SAP (Billing Doc. Data) Table details
Dictionary Type: Table
Description: Billing Doc. Data
Description: Billing Doc. Data
Table field list including key, data, relationships and ABAP select examples
ERCH is a standard SAP Table which is used to store Billing Doc. Data data and is available within R/3 SAP systems depending on the version and release level.
The ERCH table consists of various fields, each holding specific information or linking keys about Billing Doc. Data data available in SAP. These include BELNR (Number of a billing document), BUKRS (Company Code), SPARTE (Division), GPARTNER (Business Partner Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP ERCH table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BELNR | Number of a billing document | E_BELNR | CHAR | 12 | ALPHA | E_BELNR | BEL | ERCH | |
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
SPARTE | Division | SPARTE | CHAR | 2 | TSPA | SPART | SPA | ||
GPARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | KTO | FKKVKP_F4 |
VERTRAG | Contract | VERTRAG | CHAR | 10 | Assigned to domain | ALPHA | VERTRAG | VTG | EVER |
BEGABRPE | Start of billing period | BEGABRPE | DATS | 8 | DATUM | ||||
ENDABRPE | End of billing period | ENDABRPE | DATS | 8 | DATUM | ||||
ABRDATS | Scheduled Billing Date | ABRDATS | DATS | 8 | DATUM | ABRDATS | |||
ADATSOLL | Scheduled meter reading date | ADATSOLL | DATS | 8 | DATUM | PLANDAT | |||
PTERMTDAT | End of billing period from schedule record of portion | PTERMTDAT | DATS | 8 | DATUM | ||||
BELEGDAT | Creation date of billing document | BELEGDAT | DATS | 8 | DATUM | ||||
ABWVK | Alternative contract account for collective bills | ABWVK_KK | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | ||
BELNRALT | Number of previous document | BELNRALT | CHAR | 12 | ALPHA | E_BELNR | |||
STORNODAT | Reversal date | STORNODAT | DATS | 8 | DATUM | STD | |||
ABRVORG | Billing Transaction | ABRVORG | CHAR | 2 | ABRVORG | ABV | |||
HVORG | Main Transaction for Line Item | HVORG_KK | CHAR | 4 | TFKHVO | HVORG_KK | 8HV | ||
KOFIZ | Account determination ID for IS-U contracts | E_KOFIZ | CHAR | 2 | TE097 | E_KOFIZ | KMM | ||
PORTION | Portion | PORTION | CHAR | 8 | TE420 | PORTION | TPR | E420 | |
FORMULAR | Form Name | TDFORM | CHAR | 16 | TDFORM | ||||
SIMULATION | Indicator: billing simulation | SIMULATION | CHAR | 2 | SIMULATION | SIY | |||
BELEGART | Document type | E_BELART | CHAR | 2 | TE093 | E_BELART | BLA | ||
BERGRUND | Reason for credit memo/backbilling | BERGRUND | CHAR | 2 | BERGRUND | ||||
BEGNACH | Start of backbilling period | BEGNACH | DATS | 8 | DATUM | ||||
TOBRELEASD | Indicator: document not released yet | TOBRELEASD | CHAR | 1 | KENNZX | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
KONZVER | Franchise contract | KONZVER | CHAR | 10 | Assigned to domain | ALPHA | KONZVER | KZV | EKONA |
EROETIM | Time of day billing document was created | EROETIM | CHAR | 4 | HH_MM | HHMM | |||
ERCHO_V | ERCHO exists for ERCH | ERCHO_V | CHAR | 1 | KENNZX | ||||
ERCHZ_V | ERCHZ exists for ERCH | ERCHZ_V | CHAR | 1 | KENNZX | ||||
ERCHU_V | ERCHU exists for ERCH | ERCHU_V | CHAR | 1 | KENNZX | ||||
ERCHR_V | ERCHR exists for ERCH | ERCHR_V | CHAR | 1 | KENNZX | ||||
ERCHC_V | ERCHC exists for ERCH | ERCHC_V | CHAR | 1 | KENNZX | ||||
ERCHV_V | ERCHV exists for ERCH | ERCHV_V | CHAR | 1 | KENNZX | ||||
ERCHT_V | ERCHT exists for ERCH | ERCHT_V | CHAR | 1 | KENNZX | ||||
ERCHP_V | ERCHP exists for ERCH | ERCHP_V | CHAR | 1 | KENNZX | ||||
ERCHE_V | ERCHE Available for ERCH | ERCHE_V | CHAR | 1 | KENNZX | ||||
ABRVORG2 | Billing Transaction that Triggered Period-End Billing | ABRVORG2 | CHAR | 2 | ABRVORG | ||||
ABLEINH | Meter Reading Unit | ABLEINHEIT | CHAR | 8 | Assigned to domain | ABLEINHEIT | TAE | TE422A | |
ENDPRIO | Priority of Period-End Billing | ENDPRIO | CHAR | 1 | KENNZX | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
BEGRU | Authorization Group | BEGRU | CHAR | 4 | BEGRU | ||||
LOEVM | Deletion Indicator | LOEVM | CHAR | 1 | XFELD | ||||
ABRDATSU | Scheduled billing date for suppressed billing order | ABRDATSU | DATS | 8 | DATUM | ||||
ABRVORGU | Billing Transaction for a Suppressed Billing Order | ABRVORGU | CHAR | 2 | ABRVORG | ||||
N_INVSEP | Only invoice document jointly with automatic document | N_INVSEP | CHAR | 1 | KENNZX | ||||
ABPOPBEL | Budget billing plan | ABPLANNR | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | OP1 | EABP |
MANBILLREL | Manual Document Released for Invoicing | MANBILLREL | CHAR | 1 | KENNZX | ||||
BACKBI | Type of backbilling | BACKBI | CHAR | 1 | BACKBI | ||||
PERENDBI | Type of period-end billing | PERENDBI | CHAR | 1 | PERENDBI | ||||
NUMPERBB | Number of periods for backbilling | NUMPERBB | INT1 | 3 | NUMPERBB | ||||
BEGEND | Start of period-end billing period | BEGEND | DATS | 8 | DATUM | ||||
ENDOFBB | Indicator: end of backbilling period | ENDOFBB | CHAR | 1 | KENNZX | ||||
ENDOFPEB | Indicator: end of period-end billing period | ENDOFPEB | CHAR | 1 | KENNZX | ||||
NUMPERPEB | Number of periods for period-end billing | NUMPERPEB | INT1 | 3 | NUMPERBB | ||||
SC_BELNR_H | Number of billing document in adjustment reversal | SC_BELNR | CHAR | 12 | ALPHA | E_BELNR | BEL | ERCH | |
SC_BELNR_N | New billing document number in adjustment reversal | SC_BEL_N | CHAR | 12 | ALPHA | E_BELNR | BEL | ERCH | |
ZUORDDAA | Allocation date for billing | E_ZUORDDATABR | DATS | 8 | DATUM | ||||
BILLINGRUNNO | Number of Billing Run | BILLINGRUNNO | CHAR | 12 | ALPHA | E_BELNR | ABRLAUFNR | ||
SIMRUNID | Simulation Period ID | SIMRUNID | CHAR | 8 | Assigned to domain | SIMRUNID | |||
KTOKLASSE | Account class | KTOKLASSE | CHAR | 4 | Assigned to domain | KTOKLASSE | |||
ORIGDOC | Origin of Billing Document | ORIGDOC | CHAR | 2 | ORIGDOC | ||||
NOCANC | Indicator: do not execute billing reversal | NOCANC | CHAR | 1 | KENNZX | ||||
ABSCHLPAN | Adjust budget billing plan | ABSCHLPAN | CHAR | 1 | KENNZX | ||||
MEM_OPBEL | Reversed invoicing document no. for new billing/invoicing | MEM_OPBEL | CHAR | 12 | ALPHA | MEM_OPBEL | |||
MEM_BUDAT | Posting Date in the Document | MEM_BUDAT | DATS | 8 | DATUM | ||||
EXBILLDOCNO | External document number | EXBILLDOCNO | CHAR | 20 | ALPHA | EXBILLDOCNO | |||
BCREASON | Reason for Reversal | BCREASON | CHAR | 2 | TE272 | BCREASON | TE272_BCREASON_F4 | ||
NINVOICE | Billing document without invoicing | NINVOICE | CHAR | 1 | NINVOICE | ||||
NBILLREL | Not relevant to billing | NBILLREL | CHAR | 1 | KENNZX | ||||
CORRECTION_DATE | Date when the Error Was Detected | ISU_CORRECTION_DATE | DATS | 8 | DATE | ||||
BASDYPER | Basic category of dynamic period control | BASDYPER | CHAR | 2 | ALPHA | BASDYPER | |||
ESTINBILL | Meter Reading Results are Estimated in Billing | ESTINBILL | CHAR | 2 | ESTINBILL | ||||
ESTINBILLU | ESTINBILL of a Suppressed Billing Order | ESTINBILLU | CHAR | 2 | ESTINBILL | ||||
ESTINBILL_SAV | Original Value from ESTINBILL | ESTINBILL_SAV | CHAR | 2 | ESTINBILL | ||||
ESTINBILL_USAV | ESTINBILL_SAV of a Suppressed Billing Order | ESTINBILL_USAV | CHAR | 2 | ESTINBILL | ||||
ACTPERIOD | Category of a period for current billing | ACTPERIOD | CHAR | 4 | Assigned to domain | ALPHA | ACTPERIOD | ||
ACTPERORG | Original Category of a Current Period to be Billed | ACTPERORG | CHAR | 4 | Assigned to domain | ALPHA | ACTPERIOD | ||
EZAWE | Incoming Payment Method | EZAWE_KK | CHAR | 1 | CHAR1 | ||||
DAUBUCH | Standing order | DAUBUCH | CHAR | 1 | AS4FLAG | ||||
FDGRP | Planning Group | FDGRP_KK | CHAR | 10 | Assigned to domain | ALPHA | FDGRP | FFG | |
BILLING_PERIOD | Billing Key Date (For Example January 2002) | E_BILLING_PERIOD | CHAR | 10 | E_BILLING_PERIOD | ||||
OSB_GROUP | On-Site Billing Group | E_OSB_GROUP | CHAR | 3 | TE555 | ||||
BP_BILL | Resulting Billing Period | BP_BILL | CHAR | 1 | BP_BILL | ||||
MAINDOCNO | Billing Document Number of Primary Installation | MAINDOCNO | CHAR | 12 | ALPHA | E_BELNR | BEL | ERCH | |
INSTGRTYPE | Grouping Type for Installation Group | INSTGRTYPE | CHAR | 4 | Assigned to domain | INSTGRTYPE | |||
INSTROLE | Role of an Installation Within the Installation Group | INSTROLE | CHAR | 4 | Assigned to domain | INSTROLE | |||
MDUSREQUESTID | MDUS Request ID | E_MDUSREQUESTID | CHAR | 22 | EMDUSDRQHEAD | SYSUUID_22 | |||
ASBACH_REL | Change to Assessment Basic Relevant | ASBACH_REL | CHAR | 1 | KENNZX |
Key field | Non-key field |
How do I retrieve data from SAP table ERCH using ABAP code
The following ABAP code Example will allow you to do a basic selection on ERCH to SELECT all data from the tableDATA: WA_ERCH TYPE ERCH.
SELECT SINGLE *
FROM ERCH
INTO CORRESPONDING FIELDS OF WA_ERCH
WHERE...
How to access SAP table ERCH
Within an ECC or HANA version of SAP you can also view further information about ERCH and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects