SAP ABAP Table TXW_VEIAV (INTRASTAT Receipt/Dispatch)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FTW1 (Package) Data Retention Tool

Basic Data

Table Category	INTTAB	Structure
Structure	TXW_VEIAV	Table Relationship Diagram
Short Description	INTRASTAT Receipt/Dispatch

Delivery and Maintenance

Pool/cluster
Delivery Class
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	DATUMJAHR	☑	DATUMJAHR	GJAHR	NUMC	4	0	Reporting year of declaration to authorities
3	DATUMMONA	☑	DATUMMONA	MONAT	NUMC	2	0	Reporting month of declaration to authorities
4	ARRIVDEPA	☑	VEREI	VEREI	NUMC	1	0	Indicator: Goods direction for declarations to authorities
5	LFDNRVEIA	☑	LFDNR_VEIA	NUM07	NUMC	7	0	Sequential number for Intrastat declaration
6	USERNNAME	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
7	SATZERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
8	NUMMBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
9	VERKAUFOR	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
10	EIGENUINR	☐	EIGENUINR	STCEG	CHAR	20	0	ID number of trader
11	EIGENBLND	☐	EIGENBLND	HERBL	CHAR	2	0	Federal state of tax office
12	BELEGNUMR	☐	BELEGNUMR	VBELN	CHAR	10	0	Document number	*
13	HAUPTPOSI	☐	HAUPTPOSI	POSNR	NUMC	6	0	Item	*
14	MATERIALN	☐	MATNR_INTR	CHAR6	CHAR	6	0	Material Number
15	FAKTDATUM	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
16	VERSENDER	☐	VERSENDER	VERSENDER	CHAR	1	0	Importer HQ / Exporter HQ
17	BESTILAND	☐	BESTILAND	LAND1	CHAR	3	0	Country of destination of material	T005
18	BESTIREGI	☐	BESTIREGI	REGIO	CHAR	3	0	Destination region	T005S
19	LIEFERBED	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
20	ARTGESCHA	☐	EXART	EXART	CHAR	2	0	Business Transaction Type for Foreign Trade	T605
21	VERKEHRZW	☐	EXPVZ	EXPVZ	CHAR	1	0	Mode of Transport for Foreign Trade	T618
22	EINLADFGH	☐	DZOLLS	ZOLLS	CHAR	6	0	Customs Office: Office of Exit/Entry for Foreign Trade	T615
23	STATWAREN	☐	STAWN	STAWN	CHAR	17	0	Commodity Code/Import Code Number for Foreign Trade	T604
24	URSPRSLND	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	T005
25	URSPRSREG	☐	URSPRSREG	REGIO	CHAR	3	0	Region of origin	*
26	VERFAHREN	☐	EXPRF	EXPRF	CHAR	8	0	Export/Import Procedure for Foreign Trade	T616
27	EIGENMASS	☐	EIGENMASS	NUMC15	NUMC	15	0	Tare mass in kilograms
28	BESONMASS	☐	BESONMASS	NUMC15	NUMC	15	0	Supplementary unit
29	RECHNWERT	☐	RECHNWERT	NUMC15	NUMC	15	0	Invoice value
30	KUNDEUINR	☐	KUNDEUINR	STCEG	CHAR	20	0	Customer VAT registration number
31	LIEFRUINR	☐	LIEFRUINR	STCEG	CHAR	20	0	Vendor VAT registration number
32	GRENZWERT	☐	GRENZWERT	NUMC15	NUMC	15	0	Statistical value
33	SPANIENID	☐	INAUKZ	CHAR01	CHAR	1	0	Indicator: Domestic / Foreign
34	LIEFERWAE	☐	LIEFERWAE	WAERS	CUKY	5	0	Declarations to the authorities: Currency key of the vendor	TCURC
35	ZUSATZNUM	☐	INZNR	NUM03	NUMC	3	0	Foreign Trade: Additional no. for decl. to authorities
36	NLDBOCODE	☐	NLDBOCODE	NUM02	NUMC	2	0	BOE code (only relevant for The Netherlands)
37	EINKAUFOR	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
38	BELEGIDEN	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
39	RETOURCOD	☐	RETOURCOD	XFELD	CHAR	1	0	Returns ID for official declarations
40	GESAMANZA	☐	GESAMANZA	NUM05	NUMC	5	0	Total number of items in a declaration
41	NUMMWERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
42	WERKSLAND	☐	WERKSLAND	LAND1	CHAR	3	0	Declaration to authorities: Country of Plant	T005
43	THIERISCH	☐	THIERISCH	THIERISCH	CHAR	1	0	ID type for creating records
44	IFREMDWER	☐	IFREMDWER	NUMC15	NUMC	15	0	Invoice value in foreign currency
45	ISESSIONE	☐	ISESSIONE	ISESSIONE	CHAR	1	0	Indicator for normal business transactions and correction
46	IREFMONAT	☐	IREFMONAT	IREFMONAT	NUMC	2	0	Reference month for correction
47	IREFEJAHR	☐	IREFEJAHR	GJAHR	NUMC	4	0	Reference year for correction
48	ICORFORTZ	☐	ICORFORTZ	ICORFORTZ	CHAR	1	0	Plus/minus for value field in correction
49	IREFBELEG	☐	IREFBELEG	VBELN	CHAR	10	0	Reference document	*
50	IREFPOSIT	☐	IREFPOSIT	POSNR	NUMC	6	0	Reference item	*
51	IREFWERKS	☐	IREFWERKS	WERKS	CHAR	4	0	Reference plant	T001W
52	PREFPACOD	☐	PREFPACOD	PREFPACOD	CHAR	3	0	Preference code for foreign trade (decl.to author., import)	*
53	RECHNWEAK	☐	TXW_RECHNWEAK		CHAR	16	0	Invoice value
54	RECHNWEEH	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
55	GRENZWEAK	☐	TXW_GRENZWEAK		CHAR	16	0	Statistical value
56	GRENZWEEH	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
57	EIGENMAAK	☐	TXW_EIGENMAAK		CHAR	16	0	Tare mass
58	EIGENMAEH	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
59	BESONMAAK	☐	TXW_BESONMAAK		CHAR	16	0	Special unit of measure
60	BESONMAEH	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
61	IFREMDWAK	☐	TXW_IFREMDWAK		CHAR	16	0	Invoice value in foreign currency
62	IFREMDWEH	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
63	GENES	☐	GENES	GENES	CHAR	1	0	Data origin indicator for declarations to the authorities
64	P_LANDKEY	☐	P_LANDKEY	XFELD	CHAR	1	0	Country key
65	FLAGEUROC	☐	FTEUR	XFELD	CHAR	1	0	Declarations to the authorities: Ind. for decl. crcy = Euro
66	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
67	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
68	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
69	ORDPA	☐	ORDPA	CHAR10	CHAR	10	0	Classification Key for Periodic Declarations in For. Trade

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TXW_VEIAV	ARTGESCHA	T605	EXART
2	TXW_VEIAV	BESONMAEH	T006	MSEHI
3	TXW_VEIAV	BESTILAND	T005	LAND1
4	TXW_VEIAV	BESTIREGI	T005S	BLAND
5	TXW_VEIAV	EIGENMAEH	T006	MSEHI
6	TXW_VEIAV	EINKAUFOR	T024E	EKORG
7	TXW_VEIAV	EINLADFGH	T615	ZOLLA
8	TXW_VEIAV	GRENZWEEH	TCURC	WAERS
9	TXW_VEIAV	IFREMDWEH	TCURC	WAERS
10	TXW_VEIAV	IREFWERKS	T001W	WERKS
11	TXW_VEIAV	KUNNR	KNA1	KUNNR
12	TXW_VEIAV	LIEFERBED	TINC	INCO1
13	TXW_VEIAV	LIEFERWAE	TCURC	WAERS
14	TXW_VEIAV	LIFNR	LFA1	LIFNR
15	TXW_VEIAV	MANDT	T000	MANDT
16	TXW_VEIAV	MATNR	MARA	MATNR
17	TXW_VEIAV	NUMMBUKRS	T001	BUKRS
18	TXW_VEIAV	NUMMWERKS	T001W	WERKS
19	TXW_VEIAV	RECHNWEEH	TCURC	WAERS
20	TXW_VEIAV	STATWAREN	T604	STAWN
21	TXW_VEIAV	URSPRSLND	T005	LAND1
22	TXW_VEIAV	VERFAHREN	T616	EXPRF
23	TXW_VEIAV	VERKAUFOR	TVKO	VKORG
24	TXW_VEIAV	VERKEHRZW	T618	EXPVZ
25	TXW_VEIAV	WERKSLAND	T005	LAND1

History

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