ERCH SAP (Billing Doc. Data) Table details

Dictionary Type: Table
Description: Billing Doc. Data




ABAP Code to SELECT data from ERCH
Related tables to ERCH
Access table ERCH




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
MANDTClient MANDTCLNT3T000MANDT
BELNRNumber of a billing document E_BELNRCHAR12ALPHAE_BELNRBELERCH
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
SPARTEDivision SPARTECHAR2TSPASPARTSPA
GPARTNERBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
VKONTContract Account Number VKONT_KKCHAR12Assigned to domainALPHAVKONT_KKKTOFKKVKP_F4
VERTRAGContract VERTRAGCHAR10Assigned to domainALPHAVERTRAGVTGEVER
BEGABRPEStart of billing period BEGABRPEDATS8DATUM
ENDABRPEEnd of billing period ENDABRPEDATS8DATUM
ABRDATSScheduled Billing Date ABRDATSDATS8DATUMABRDATS
ADATSOLLScheduled meter reading date ADATSOLLDATS8DATUMPLANDAT
PTERMTDATEnd of billing period from schedule record of portion PTERMTDATDATS8DATUM
BELEGDATCreation date of billing document BELEGDATDATS8DATUM
ABWVKAlternative contract account for collective bills ABWVK_KKCHAR12Assigned to domainALPHAVKONT_KK
BELNRALTNumber of previous document BELNRALTCHAR12ALPHAE_BELNR
STORNODATReversal date STORNODATDATS8DATUMSTD
ABRVORGBilling Transaction ABRVORGCHAR2ABRVORGABV
HVORGMain Transaction for Line Item HVORG_KKCHAR4TFKHVOHVORG_KK8HV
KOFIZAccount determination ID for IS-U contracts E_KOFIZCHAR2TE097E_KOFIZKMM
PORTIONPortion PORTIONCHAR8TE420PORTIONTPRE420
FORMULARForm Name TDFORMCHAR16TDFORM
SIMULATIONIndicator: billing simulation SIMULATIONCHAR2SIMULATIONSIY
BELEGARTDocument type E_BELARTCHAR2TE093E_BELARTBLA
BERGRUNDReason for credit memo/backbilling BERGRUNDCHAR2BERGRUND
BEGNACHStart of backbilling period BEGNACHDATS8DATUM
TOBRELEASDIndicator: document not released yet TOBRELEASDCHAR1KENNZX
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
KONZVERFranchise contract KONZVERCHAR10Assigned to domainALPHAKONZVERKZVEKONA
EROETIMTime of day billing document was created EROETIMCHAR4HH_MMHHMM
ERCHO_VERCHO exists for ERCH ERCHO_VCHAR1KENNZX
ERCHZ_VERCHZ exists for ERCH ERCHZ_VCHAR1KENNZX
ERCHU_VERCHU exists for ERCH ERCHU_VCHAR1KENNZX
ERCHR_VERCHR exists for ERCH ERCHR_VCHAR1KENNZX
ERCHC_VERCHC exists for ERCH ERCHC_VCHAR1KENNZX
ERCHV_VERCHV exists for ERCH ERCHV_VCHAR1KENNZX
ERCHT_VERCHT exists for ERCH ERCHT_VCHAR1KENNZX
ERCHP_VERCHP exists for ERCH ERCHP_VCHAR1KENNZX
ERCHE_VERCHE Available for ERCH ERCHE_VCHAR1KENNZX
ABRVORG2Billing Transaction that Triggered Period-End Billing ABRVORG2CHAR2ABRVORG
ABLEINHMeter Reading Unit ABLEINHEITCHAR8Assigned to domainABLEINHEITTAETE422A
ENDPRIOPriority of Period-End Billing ENDPRIOCHAR1KENNZX
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
BEGRUAuthorization Group BEGRUCHAR4BEGRU
LOEVMDeletion Indicator LOEVMCHAR1XFELD
ABRDATSUScheduled billing date for suppressed billing order ABRDATSUDATS8DATUM
ABRVORGUBilling Transaction for a Suppressed Billing Order ABRVORGUCHAR2ABRVORG
N_INVSEPOnly invoice document jointly with automatic document N_INVSEPCHAR1KENNZX
ABPOPBELBudget billing plan ABPLANNRCHAR12Assigned to domainALPHAOPBEL_KKOP1EABP
MANBILLRELManual Document Released for Invoicing MANBILLRELCHAR1KENNZX
BACKBIType of backbilling BACKBICHAR1BACKBI
PERENDBIType of period-end billing PERENDBICHAR1PERENDBI
NUMPERBBNumber of periods for backbilling NUMPERBBINT13NUMPERBB
BEGENDStart of period-end billing period BEGENDDATS8DATUM
ENDOFBBIndicator: end of backbilling period ENDOFBBCHAR1KENNZX
ENDOFPEBIndicator: end of period-end billing period ENDOFPEBCHAR1KENNZX
NUMPERPEBNumber of periods for period-end billing NUMPERPEBINT13NUMPERBB
SC_BELNR_HNumber of billing document in adjustment reversal SC_BELNRCHAR12ALPHAE_BELNRBELERCH
SC_BELNR_NNew billing document number in adjustment reversal SC_BEL_NCHAR12ALPHAE_BELNRBELERCH
ZUORDDAAAllocation date for billing E_ZUORDDATABRDATS8DATUM
BILLINGRUNNONumber of Billing Run BILLINGRUNNOCHAR12ALPHAE_BELNRABRLAUFNR
SIMRUNIDSimulation Period ID SIMRUNIDCHAR8Assigned to domainSIMRUNID
KTOKLASSEAccount class KTOKLASSECHAR4Assigned to domainKTOKLASSE
ORIGDOCOrigin of Billing Document ORIGDOCCHAR2ORIGDOC
NOCANCIndicator: do not execute billing reversal NOCANCCHAR1KENNZX
ABSCHLPANAdjust budget billing plan ABSCHLPANCHAR1KENNZX
MEM_OPBELReversed invoicing document no. for new billing/invoicing MEM_OPBELCHAR12ALPHAMEM_OPBEL
MEM_BUDATPosting Date in the Document MEM_BUDATDATS8DATUM
EXBILLDOCNOExternal document number EXBILLDOCNOCHAR20ALPHAEXBILLDOCNO
BCREASONReason for Reversal BCREASONCHAR2TE272BCREASONTE272_BCREASON_F4
NINVOICEBilling document without invoicing NINVOICECHAR1NINVOICE
NBILLRELNot relevant to billing NBILLRELCHAR1KENNZX
CORRECTION_DATEDate when the Error Was Detected ISU_CORRECTION_DATEDATS8DATE
BASDYPERBasic category of dynamic period control BASDYPERCHAR2ALPHABASDYPER
ESTINBILLMeter Reading Results are Estimated in Billing ESTINBILLCHAR2ESTINBILL
ESTINBILLUESTINBILL of a Suppressed Billing Order ESTINBILLUCHAR2ESTINBILL
ESTINBILL_SAVOriginal Value from ESTINBILL ESTINBILL_SAVCHAR2ESTINBILL
ESTINBILL_USAVESTINBILL_SAV of a Suppressed Billing Order ESTINBILL_USAVCHAR2ESTINBILL
ACTPERIODCategory of a period for current billing ACTPERIODCHAR4Assigned to domainALPHAACTPERIOD
ACTPERORGOriginal Category of a Current Period to be Billed ACTPERORGCHAR4Assigned to domainALPHAACTPERIOD
EZAWEIncoming Payment Method EZAWE_KKCHAR1CHAR1
DAUBUCHStanding order DAUBUCHCHAR1AS4FLAG
FDGRPPlanning Group FDGRP_KKCHAR10Assigned to domainALPHAFDGRPFFG
BILLING_PERIODBilling Key Date (For Example January 2002) E_BILLING_PERIODCHAR10E_BILLING_PERIOD
OSB_GROUPOn-Site Billing Group E_OSB_GROUPCHAR3TE555
BP_BILLResulting Billing Period BP_BILLCHAR1BP_BILL
MAINDOCNOBilling Document Number of Primary Installation MAINDOCNOCHAR12ALPHAE_BELNRBELERCH
INSTGRTYPEGrouping Type for Installation Group INSTGRTYPECHAR4Assigned to domainINSTGRTYPE
INSTROLERole of an Installation Within the Installation Group INSTROLECHAR4Assigned to domainINSTROLE
MDUSREQUESTIDMDUS Request ID E_MDUSREQUESTIDCHAR22EMDUSDRQHEADSYSUUID_22
ASBACH_RELChange to Assessment Basic Relevant ASBACH_RELCHAR1KENNZX

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!