SAP ABAP Table DBERDL (Print Document Line Items)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-IN (Application Component) Invoicing
     ⤷ EE22 (Package) IS-U: Bill Printout

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DBERDL	Table Relationship Diagram
Short Description	Print Document Line Items

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	PRINTDOC	☑	E_PRINTDOC	E_PRINTDOC	CHAR	12	0	Number of print document	*
3	PRINTDOCLINE	☑	BELZEILE	LFDNR6	NUMC	6	0	Billing line item for billing documents
4	REFDOCSOURCE	☐	ISU_REFDOCSOURCE	ISU_REFDOCSOURCE	CHAR	1	0	Origin of source document
5	REFDOCSOURCEKEYA	☐	ISU_REFDOCSOURCEKEYA		CHAR	20	0	Main key of source document
6	REFDOCSOURCEKEYB	☐	ISU_REFDOCSOURCEKEYB		CHAR	6	0	Service key of source document
7	BELZART	☐	BELZART	BELZART	CHAR	6	0	Line Item Type	TE835
8	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
9	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TSPA
10	KTOSL	☐	KTOSL	CHAR3	CHAR	3	0	Transaction Key
11	VERTRAG	☐	VERTRAG	VERTRAG	CHAR	10	0	Contract	*
12	BUCHREL	☐	BUCHREL	KENNZX	CHAR	1	0	Billing Line Item Relevant to Posting
13	BRUTTOZEILE	☐	BRUTTOZEILE	KENNZX	CHAR	1	0	Blling line item is a gross line item
14	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
15	APERIODIC	☐	APERIODIC	KENNZX	CHAR	1	0	Non-Periodic Posting
16	XTOTAL_AMNT	☐	XTOTAL_AMNT	E_XTOTAL_AMNT	CHAR	1	0	Consider Items in Bill Sum Total
17	NETTOBTR	☐	NETTOBTR	WRTV7	CURR	13	2	Net amount of billing line item
18	BETRW	☐	BETRW_KK	WRTV7	CURR	13	2	Amount in Transaction Currency with +/- Sign
19	AUGBW	☐	AUGBW_KK	WRTV7	CURR	13	2	Clearing Amount in Transaction Currency (With +/- Sign)
20	SBASW	☐	SBASW_KK	WRTV7	CURR	13	2	Amount Subject to Tax in Transaction Currency (Tax Base Amt)
21	SBETW	☐	SBETW_KK	WRTV7	CURR	13	2	Tax Amount in Transaction Currency with +/- Sign
22	SKTOW	☐	SKTOW_KK	WRTV7	CURR	13	2	Cash discount amount in transaction currency with +/- sign
23	TWAERS	☐	TWAERS	WAERS	CUKY	5	0	Transaction Currency	TCURC
24	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
25	ERMWSKZ	☐	ERMWSKZ	ERMWSKZ	CHAR	2	0	Indicator: Tax Determination Code	*
26	STPRZ	☐	STEUERSATZ	CHAR8	CHAR	8	0	Tax rate in output format
27	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
28	TXDAT_KK	☐	TXDAT_KK	DATUM	DATS	8	0	Decisive Date for Calculating Taxes
29	HVORG	☐	HVORG_KK	HVORG_KK	CHAR	4	0	Main Transaction for Line Item	TFKHVO
30	TVORG	☐	TVORG_KK	TVORG_KK	CHAR	4	0	Subtransaction for Document Item	TFKTVO
31	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
32	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
33	FAEDN	☐	FAEDN_KK	DATUM	DATS	8	0	Due date for net payment
34	FAEDS	☐	FAEDS_KK	DATUM	DATS	8	0	Due Date for Cash Discount
35	SKTPZ	☐	SKTPZ_KK	PRZ23	DEC	5	3	Cash discount rate
36	ABPOPBEL	☐	ABPLANNR	OPBEL_KK	CHAR	12	0	Budget billing plan	*
37	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
38	CA_OPBEL	☐	OPBEL_KK	OPBEL_KK	CHAR	12	0	Number of Contract Accts Rec. & Payable Doc.	*
39	LINESORT	☐	LINESORT	LINESORT	CHAR	4	0	Presorting of billing line items in billing schema	*
40	AB	☐	ABZEITSCH	DATUM	DATS	8	0	Date from which time slice is valid
41	BIS	☐	BISZEITSCH	DATUM	DATS	8	0	Date at Which a Time Slice Expires
42	TAXRATE_INTERNAL	☐	STPRZ_KK	STPRZ_KK	NUMC	6	0	Tax rate
43	.INCLUDE	☐				0	0
44	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DBERDL	BELZART	TE835	BELZART	KEY
2	DBERDL	HVORG	TFKHVO	HVORG
3	DBERDL	SPARTE	TSPA	SPART
4	DBERDL	TVORG	TFKTVO	TVORG
5	DBERDL	TWAERS	TCURC	WAERS	KEY

History

Last changed by/on	SAP	20130529
SAP Release Created in