SAP ABAP Table IDEU_VAT (EU VAT Posting)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CA-GTF-CSC (Application Component) Country-Specific Objects
     ⤷ ID-FI (Package) International development: FI-GL/AP/AR

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	IDEU_VAT	Table Relationship Diagram
Short Description	EU VAT Posting

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	EBELN	☑	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
3	EBELP	☑	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
4	ZEKKN	☑	DZEKKN	NUM02	NUMC	2	0	Sequential Number of Account Assignment
5	IDDOCTYP	☑	IDDOCTYP	IDDOCTYP	CHAR	1	0	EU VAT Document Type
6	GJAHR	☑	MJAHR	GJAHR	NUMC	4	0	Year of material document
7	BELNR	☑	MBLNR	BELNR	CHAR	10	0	Number of Material Document
8	BUZEI	☑	MBLPO	MBLPO	NUMC	4	0	Item in material document
9	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
10	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
11	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
12	BPMNG	☐	MENGE_BPR	MENG13	QUAN	13	3	Quantity in purchase order price unit
13	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
14	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
15	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
16	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
17	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
18	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
19	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
20	LFGJA	☐	LFBJA	GJAHR	NUMC	4	0	Fiscal Year of a Reference Document
21	LFBNR	☐	LFBNR	BELNR	CHAR	10	0	Document number of a reference document
22	LFPOS	☐	LFPOS	MBLPO	NUMC	4	0	Item of a reference document
23	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
24	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
25	BKTXT	☐	BKTXT	TEXT25	CHAR	25	0	Document Header Text
26	KURSF	☐	KURSF	KURSF	DEC	9	5	Exchange rate
27	DPAMT	☐	DPAMT	WRBTR	CURR	11	2	Used down payment amount in document currency
28	VATDATE	☐	VATDATE	DATUM	DATS	8	0	Tax Reporting Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IDEU_VAT	CLIENT	T000	MANDT	KEY	1	CN
2	IDEU_VAT	EBELN	EKKO	EBELN	KEY	1	CN
3	IDEU_VAT	EBELP	EKPO	EBELP	KEY	1	CN
4	IDEU_VAT	WAERS	TCURC	WAERS	KEY	1	CN

History

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