SAP ABAP Table DBERCHZ8 (Document line items (rarely used fields, unimportant))

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	DBERCHZ8	Table Relationship Diagram
Short Description	Document line items (rarely used fields, unimportant)

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	*
2	BELNR	☑	E_BELNR	E_BELNR	CHAR	12	0	Number of a billing document
3	BELZEILE	☑	BELZEILE	LFDNR6	NUMC	6	0	Billing line item for billing documents
4	.INCLUDE	☐				0	0	Substructure of document line items, rarely used fields
5	LEUCHTNR	☐	LEUCHTNR	LEUCHTNR	CHAR	10	0	External lighting number
6	BETRART	☐	BETRART	BETRART	CHAR	4	0	Operation Type for Lighting Unit	TE497
7	SPGRUND	☐	SPGRUND	SPGRUND	CHAR	2	0	Disconnection reason
8	EIN05	☐	EINOPERAND	E_OPERAND	CHAR	10	0	Input operand	*
9	EIN06	☐	EINOPERAND	E_OPERAND	CHAR	10	0	Input operand	*
10	EIN07	☐	EINOPERAND	E_OPERAND	CHAR	10	0	Input operand	*
11	EIN08	☐	EINOPERAND	E_OPERAND	CHAR	10	0	Input operand	*
12	EIN09	☐	EINOPERAND	E_OPERAND	CHAR	10	0	Input operand	*
13	EIN10	☐	EINOPERAND	E_OPERAND	CHAR	10	0	Input operand	*
14	AUS03	☐	AUSOPERAND	E_OPERAND	CHAR	10	0	Output operand	*
15	AUS04	☐	AUSOPERAND	E_OPERAND	CHAR	10	0	Output operand	*
16	AUS05	☐	AUSOPERAND	E_OPERAND	CHAR	10	0	Output operand	*
17	MASS5	☐	E_MASS	MEINS	UNIT	3	0	Unit of Measurement	T006
18	MASS6	☐	E_MASS	MEINS	UNIT	3	0	Unit of Measurement	T006
19	SC_BELNR	☐	SC_BELNR	E_BELNR	CHAR	12	0	Number of billing document in adjustment reversal
20	SC_BELZEILE	☐	SC_BELZEILE	LFDNR6	NUMC	6	0	Billing line item for billing documents
21	REFBELZEILE	☐	REFBELZEILE	LFDNR6	NUMC	6	0	Reference billing line item for billing documents
22	SPERRUNG	☐	SPERRUNG	KENNZX	CHAR	1	0	Time slice is in a disconnection period
23	NETTOFRMD	☐	NETTOFRMD	WRTV7	CURR	13	2	Amount in foreign currency with +/- sign
24	WAERSF	☐	WAERSF	WAERS	CUKY	5	0	Currency key for amount	TCURC
25	UMRECHDAT	☐	UMRECHDAT	UMRECHDAT	DATS	8	0	Conversion Date for Foreign Currency Amount
26	UMRECHKURS	☐	UMRECHKURS	KURSF	DEC	9	5	Exchange rate btwn net amount and foreign currency amount
27	REFBELZONE	☐	REFBELZONE	LFDNR6	NUMC	6	0	Ref. billing line item for documents resulting from blocking
28	REFBILLDOCNO	☐	REFBILLDOCNO	E_BELNR	CHAR	12	0	Reference Document Number
29	FIRSTBELNR	☐	FIRSTBELNR	E_BELNR	CHAR	12	0	Billing Document Number of First Invoiced Document
30	TAXREL	☐	TAXREL	KENNZX	CHAR	1	0	Line Contains Tax Determination Quantity for Invoicing
31	TAXGROUP	☐	TAXGROUP	KENNZ4	CHAR	4	0	Categorize Amounts for Tax Determination
32	BILLTYPE	☐	EBILLTYPE	BILLTYPE_ID	CHAR	6	0	Waste Billing Category
33	OBJNR	☐	EOBJNR	EOBJNR	CHAR	10	0	Number of service frequency	*
34	ORDERNR	☐	EORDERNR	EORDERNR	CHAR	20	0	Internal Number for Identifying a Waste Disposal Order	*
35	LAUFNR	☐	LAUFNR	NUMC5	NUMC	5	0	Consecutive number of service frequency
36	ORDER_LAUFNR	☐	ORDER_LAUFNR	NUMC4	NUMC	4	0	Consecutive Number for Waste Disposal Order Item
37	GGVERTRAG	☐	E_GUARANTOR_CONTRACT	E_GUARANTOR_CONTRACT	CHAR	18	0	Guarantor Contract
38	OLD_BELNR	☐	E_BELNR	E_BELNR	CHAR	12	0	Number of a billing document
39	.INCLUDE	☐				0	0	Pre-/decimal places in rarely used ERCHZ fields
40	V_ZAHL5	☐	V_ZAHL	V_ZAHL	DEC	17	0	Pre-decimal places in a number
41	N_ZAHL5	☐	N_ZAHL	N_ZAHL	DEC	14	14	Decimal places in a number
42	V_ZAHL6	☐	V_ZAHL	V_ZAHL	DEC	17	0	Pre-decimal places in a number
43	N_ZAHL6	☐	N_ZAHL	N_ZAHL	DEC	14	14	Decimal places in a number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DBERCHZ8	BETRART	TE497	BETRART	KEY
2	DBERCHZ8	MASS5	T006	MSEHI	KEY
3	DBERCHZ8	MASS6	T006	MSEHI	KEY
4	DBERCHZ8	WAERSF	TCURC	WAERS

History

Last changed by/on	SAP	20050224
SAP Release Created in	462