SAP ABAP Table DBERCHZ3 (Individual line items (amount and price 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	DBERCHZ3	Table Relationship Diagram
Short Description	Individual line items (amount and price 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	*
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, amounts and prices
5	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
6	ERMWSKZ	☐	ERMWSKZ	ERMWSKZ	CHAR	2	0	Indicator: Tax Determination Code	*
7	NETTOBTR	☐	NETTOBTR	WRTV7	CURR	13	2	Net amount of billing line item
8	TWAERS	☐	TWAERS	WAERS	CUKY	5	0	Transaction Currency	TCURC
9	PREISTUF	☐	PREISTUF	PREISTUF	CHAR	10	0	Price level	TE471
10	PREISTYP	☐	PREISTYP	PREISTYP	CHAR	1	0	Price category
11	PREIS	☐	E_PREIS	E_PREIS	CHAR	10	0	Price	*
12	PREISZUS	☐	PREISZUS	KENNZ4	CHAR	4	0	Indicator: Price Summary
13	VONZONE	☐	VONZONE	E_ZONE	NUMC	10	0	From-block
14	BISZONE	☐	BISZONE	E_ZONE	NUMC	10	0	To-block
15	ZONENNR	☐	E_ZONENNR	E_ZONENNR	NUMC	3	0	Number of price block or price scale
16	PREISBTR	☐	PRSBTR	PRSBTR	DEC	17	8	Price amount
17	MNGBASIS	☐	MENGENBAS	MENGENBAS	DEC	9	2	Long quantity base for amount
18	PREIGKL	☐	PREIGKL	PREIGKL	CHAR	10	0	Price adjustment clause	*
19	URPREIS	☐	URPREIS	PRSBTR	DEC	17	8	Base price to which the price adjustment clause relates
20	PREIADD	☐	PREIADD	PRSBTR	DEC	17	8	Price to be added for price adjustment
21	PREIFAKT	☐	PREIFAKT	PREIFAKT	DEC	12	7	Price adjustment factor
22	OPMULT	☐	OPMULT	KENZX	CHAR	1	0	Addition first
23	TXDAT_KK	☐	TXDAT_KK	DATUM	DATS	8	0	Decisive Date for Calculating Taxes
24	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
25	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
26	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
27	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
28	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
29	PAOBJNR_S	☐	RKEOBJNR_S	RKEOBJNR	NUMC	10	0	Profitability Segment No. for CO-PA Post. Acc. to Cons. Mth
30	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
31	APERIODIC	☐	APERIODIC	KENNZX	CHAR	1	0	Non-Periodic Posting
32	GROSSGROUP	☐	GROSSGROUP	GROSSGROUP	CHAR	4	0	Gross group
33	BRUTTOZEILE	☐	BRUTTOZEILE	KENNZX	CHAR	1	0	Blling line item is a gross line item
34	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
35	LINE_CLASS	☐	LINE_CLASS	LINE_CLASS	CHAR	4	0	Classification Criteria for Billing Line
36	PREISART	☐	E_PREISART	E_PREISART	CHAR	1	0	Price type
37	.INCLUDE	☐				0	0	Predecimal/Decimal Places of Amount Fields in ERCHZ
38	V_NETTOBTR_L	☐	V_NETTOBTR_L	V_NETTOBTR_L	DEC	17	0	Predecimal Places of Long Nett Amount
39	N_NETTOBTR_L	☐	N_NETTOBTR_L	N_NETTOBTR_L	DEC	14	14	Decimal Places for Long Nett Amount

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DBERCHZ3	AUFNR	AUFK	AUFNR
2	DBERCHZ3	GSBER	TGSB	GSBER
3	DBERCHZ3	KOSTL	CSKS	KOSTL
4	DBERCHZ3	PRCTR	CEPC	PRCTR
5	DBERCHZ3	PREISTUF	TE471	PREISTUF	KEY
6	DBERCHZ3	PS_PSP_PNR	PRPS	PSPNR
7	DBERCHZ3	TWAERS	TCURC	WAERS	KEY

History

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