SAP ABAP Table ERCH (Billing Doc. Data)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-BI (Application Component) Contract Billing
     ⤷ EE20 (Package) IS-U: Billing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ERCH	Table Relationship Diagram
Short Description	Billing Doc. Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BELNR	☑	E_BELNR	E_BELNR	CHAR	12	0	Number of a billing document
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TSPA
5	GPARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
6	VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	*
7	VERTRAG	☐	VERTRAG	VERTRAG	CHAR	10	0	Contract	*
8	BEGABRPE	☐	BEGABRPE	DATUM	DATS	8	0	Start of billing period
9	ENDABRPE	☐	ENDABRPE	DATUM	DATS	8	0	End of billing period
10	ABRDATS	☐	ABRDATS	DATUM	DATS	8	0	Scheduled Billing Date
11	ADATSOLL	☐	ADATSOLL	DATUM	DATS	8	0	Scheduled meter reading date
12	PTERMTDAT	☐	PTERMTDAT	DATUM	DATS	8	0	End of billing period from schedule record of portion
13	BELEGDAT	☐	BELEGDAT	DATUM	DATS	8	0	Creation date of billing document
14	ABWVK	☐	ABWVK_KK	VKONT_KK	CHAR	12	0	Alternative contract account for collective bills	*
15	BELNRALT	☐	BELNRALT	E_BELNR	CHAR	12	0	Number of previous document
16	STORNODAT	☐	STORNODAT	DATUM	DATS	8	0	Reversal date
17	ABRVORG	☐	ABRVORG	ABRVORG	CHAR	2	0	Billing Transaction
18	HVORG	☐	HVORG_KK	HVORG_KK	CHAR	4	0	Main Transaction for Line Item	TFKHVO
19	KOFIZ	☐	E_KOFIZ	E_KOFIZ	CHAR	2	0	Account determination ID for IS-U contracts	TE097
20	PORTION	☐	PORTION	PORTION	CHAR	8	0	Portion	TE420
21	FORMULAR	☐	TDFORM	TDFORM	CHAR	16	0	Form name
22	SIMULATION	☐	SIMULATION	SIMULATION	CHAR	2	0	Indicator: billing simulation
23	BELEGART	☐	E_BELART	E_BELART	CHAR	2	0	Document type	TE093
24	BERGRUND	☐	BERGRUND	BERGRUND	CHAR	2	0	Reason for credit memo/backbilling
25	BEGNACH	☐	BEGNACH	DATUM	DATS	8	0	Start of backbilling period
26	TOBRELEASD	☐	TOBRELEASD	KENNZX	CHAR	1	0	Indicator: document not released yet
27	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
28	KONZVER	☐	KONZVER	KONZVER	CHAR	10	0	Franchise contract	*
29	EROETIM	☐	EROETIM	HHMM	CHAR	4	0	Time of day billing document was created
30	ERCHO_V	☐	ERCHO_V	KENNZX	CHAR	1	0	ERCHO exists for ERCH
31	ERCHZ_V	☐	ERCHZ_V	KENNZX	CHAR	1	0	ERCHZ exists for ERCH
32	ERCHU_V	☐	ERCHU_V	KENNZX	CHAR	1	0	ERCHU exists for ERCH
33	ERCHR_V	☐	ERCHR_V	KENNZX	CHAR	1	0	ERCHR exists for ERCH
34	ERCHC_V	☐	ERCHC_V	KENNZX	CHAR	1	0	ERCHC exists for ERCH
35	ERCHV_V	☐	ERCHV_V	KENNZX	CHAR	1	0	ERCHV exists for ERCH
36	ERCHT_V	☐	ERCHT_V	KENNZX	CHAR	1	0	ERCHT exists for ERCH
37	ERCHP_V	☐	ERCHP_V	KENNZX	CHAR	1	0	ERCHP exists for ERCH
38	ABRVORG2	☐	ABRVORG2	ABRVORG	CHAR	2	0	Billing Transaction that Triggered Period-End Billing
39	ABLEINH	☐	ABLEINHEIT	ABLEINHEIT	CHAR	8	0	Meter reading unit	*
40	ENDPRIO	☐	ENDPRIO	KENNZX	CHAR	1	0	Priority of Period-End Billing
41	.INCLUDE	☐				0	0	Creation and Change Data (Author, Group and Deletion Flag)
42	.INCLUDE	☐				0	0	Creation and Change Data
43	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
44	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
45	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
46	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
47	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
48	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
49	ABRDATSU	☐	ABRDATSU	DATUM	DATS	8	0	Scheduled billing date for suppressed billing order
50	ABRVORGU	☐	ABRVORGU	ABRVORG	CHAR	2	0	Billing Transaction for a Suppressed Billing Order
51	N_INVSEP	☐	N_INVSEP	KENNZX	CHAR	1	0	Only invoice document jointly with automatic document
52	ABPOPBEL	☐	ABPLANNR	OPBEL_KK	CHAR	12	0	Budget billing plan	*
53	MANBILLREL	☐	MANBILLREL	KENNZX	CHAR	1	0	Manual Document Released for Invoicing
54	BACKBI	☐	BACKBI	BACKBI	CHAR	1	0	Type of backbilling
55	PERENDBI	☐	PERENDBI	PERENDBI	CHAR	1	0	Type of period-end billing
56	NUMPERBB	☐	NUMPERBB	NUMPERBB	INT1	3	0	Number of periods for backbilling
57	BEGEND	☐	BEGEND	DATUM	DATS	8	0	Start of period-end billing period
58	ENDOFBB	☐	ENDOFBB	KENNZX	CHAR	1	0	Indicator: end of backbilling period
59	ENDOFPEB	☐	ENDOFPEB	KENNZX	CHAR	1	0	Indicator: end of period-end billing period
60	NUMPERPEB	☐	NUMPERPEB	NUMPERBB	INT1	3	0	Number of periods for period-end billing
61	SC_BELNR_H	☐	SC_BELNR	E_BELNR	CHAR	12	0	Number of billing document in adjustment reversal
62	SC_BELNR_N	☐	SC_BEL_N	E_BELNR	CHAR	12	0	New billing document number in adjustment reversal
63	ZUORDDAA	☐	E_ZUORDDATABR	DATUM	DATS	8	0	Allocation date for billing
64	BILLINGRUNNO	☐	BILLINGRUNNO	E_BELNR	CHAR	12	0	Number of Billing Run
65	SIMRUNID	☐	SIMRUNID	SIMRUNID	CHAR	8	0	Simulation Period ID	*
66	KTOKLASSE	☐	KTOKLASSE	KTOKLASSE	CHAR	4	0	Account class	*
67	ORIGDOC	☐	ORIGDOC	ORIGDOC	CHAR	2	0	Origin of Billing Document
68	NOCANC	☐	NOCANC	KENNZX	CHAR	1	0	Indicator: do not execute billing reversal
69	ABSCHLPAN	☐	ABSCHLPAN	KENNZX	CHAR	1	0	Adjust budget billing plan
70	MEM_OPBEL	☐	MEM_OPBEL	MEM_OPBEL	CHAR	12	0	Reversed invoicing document no. for new billing/invoicing
71	MEM_BUDAT	☐	MEM_BUDAT	DATUM	DATS	8	0	Posting Date in the Document
72	EXBILLDOCNO	☐	EXBILLDOCNO	EXBILLDOCNO	CHAR	20	0	External document number
73	BCREASON	☐	BCREASON	BCREASON	CHAR	2	0	Reason for Reversal	TE272
74	NINVOICE	☐	NINVOICE	NINVOICE	CHAR	1	0	Billing document without invoicing
75	NBILLREL	☐	NBILLREL	KENNZX	CHAR	1	0	Not relevant to billing
76	CORRECTION_DATE	☐	ISU_CORRECTION_DATE	DATE	DATS	8	0	Date when the Error Was Detected
77	BASDYPER	☐	BASDYPER	BASDYPER	CHAR	2	0	Basic category of dynamic period control
78	ESTINBILL	☐	ESTINBILL	ESTINBILL	CHAR	2	0	Meter Reading Results are Estimated in Billing
79	ESTINBILLU	☐	ESTINBILLU	ESTINBILL	CHAR	2	0	ESTINBILL of a Suppressed Billing Order
80	ESTINBILL_SAV	☐	ESTINBILL_SAV	ESTINBILL	CHAR	2	0	Original Value from ESTINBILL
81	ESTINBILL_USAV	☐	ESTINBILL_USAV	ESTINBILL	CHAR	2	0	ESTINBILL_SAV of a Suppressed Billing Order
82	ACTPERIOD	☐	ACTPERIOD	ACTPERIOD	CHAR	4	0	Category of a period for current billing	*
83	ACTPERORG	☐	ACTPERORG	ACTPERIOD	CHAR	4	0	Original Category of a Current Period to be Billed	*
84	EZAWE	☐	EZAWE_KK	CHAR1	CHAR	1	0	Incoming Payment Method
85	DAUBUCH	☐	DAUBUCH	AS4FLAG	CHAR	1	0	Standing order
86	FDGRP	☐	FDGRP_KK	FDGRP	CHAR	10	0	Planning Group	*
87	BILLING_PERIOD	☐	E_BILLING_PERIOD	E_BILLING_PERIOD	CHAR	10	0	Billing Key Date (For Example January 2002)
88	OSB_GROUP	☐	E_OSB_GROUP		CHAR	3	0	On-Site Billing Group	TE555
89	.INCLUDE	☐				0	0	Special ERCH Fields for JBP (Japanese Billing Period)
90	BP_BILL	☐	BP_BILL	BP_BILL	CHAR	1	0	Resulting Billing Period
91	.INCLUDE	☐				0	0
92	MAINDOCNO	☐	MAINDOCNO	E_BELNR	CHAR	12	0	Billing Document Number of Primary Installation
93	INSTGRTYPE	☐	INSTGRTYPE	INSTGRTYPE	CHAR	4	0	Grouping Type for Installation Group	*
94	INSTROLE	☐	INSTROLE	INSTROLE	CHAR	4	0	Role of an Installation Within the Installation Group	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ERCH	BCREASON	TE272	BCREASON	REF	1	CN
2	ERCH	BELEGART	TE093	BELEGART	KEY
3	ERCH	BUKRS	T001	BUKRS	KEY
4	ERCH	HVORG	TFKHVO	HVORG	KEY
5	ERCH	KOFIZ	TE097	KOFIZ	KEY
6	ERCH	MANDT	T000	MANDT
7	ERCH	OSB_GROUP	TE555	OSB_GROUP
8	ERCH	PORTION	TE420	TERMSCHL	KEY
9	ERCH	SPARTE	TSPA	SPART	KEY

History

Last changed by/on	SAP	20110901
SAP Release Created in