SAP ABAP Table VEXAV (EXTRASTAT / VAR Export/Import)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ VEI (Package) Application development R/3 foreign trade

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VEXAV	Table Relationship Diagram
Short Description	EXTRASTAT / VAR Export/Import

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	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_VEEA	NUM07	NUMC	7	0	Sequential no.for Extrastat declaration
6	NUMMBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
7	USERNNAME	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
8	SATZERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
9	VERKAUFOR	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
10	BELEGNUMR	☐	BELEGNUMR	VBELN	CHAR	10	0	Document number	*
11	HAUPTPOSI	☐	HAUPTPOSI	POSNR	NUMC	6	0	Item	*
12	MATERIALN	☐	EXMNR	EXMNR	CHAR	6	0	EXTRASTAT material no. for decl. to auth. for Foreign Trade
13	FIRMENNUM	☐	EXFNR	EXFNR	CHAR	7	0	Company no. EXTRASTAT for declar. to auth. for Foreign Trade
14	VERSENDER	☐	VERSENDER	VERSENDER	CHAR	1	0	Importer HQ / Exporter HQ
15	HANDELSLD	☐	HANDELSLD	LAND1	CHAR	3	0	Trading country	T005
16	BESTILAND	☐	BESTILAND	LAND1	CHAR	3	0	Country of destination of material	T005
17	CONTAINER	☐	CONTA	CONTA	CHAR	1	0	ID: Goods cross border in a container
18	STAATSZUG	☐	STGBE	LAND1	CHAR	3	0	Origin of Means of Transport when Crossing the Border	T005
19	ARTGESCHA	☐	EXART	EXART	CHAR	2	0	Business Transaction Type for Foreign Trade	T605
20	VERKEHRZW	☐	EXPVZ	EXPVZ	CHAR	1	0	Mode of Transport for Foreign Trade	T618
21	EINLADFGH	☐	DZOLLS	ZOLLS	CHAR	6	0	Customs Office: Office of Exit/Entry for Foreign Trade	T615
22	STATWAREN	☐	STAWN	STAWN	CHAR	17	0	Commodity Code/Import Code Number for Foreign Trade	T604
23	URSPRSLND	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	T005
24	URSPRSREG	☐	URSPRSREG	REGIO	CHAR	3	0	Region of origin	*
25	VERFAHREN	☐	EXPRF	EXPRF	CHAR	8	0	Export/Import Procedure for Foreign Trade	T616
26	EIGENMASS	☐	EIGENMASS	NUMC15	NUMC	15	0	Tare mass in kilograms
27	BESONMASS	☐	BESONMASS	NUMC15	NUMC	15	0	Supplementary unit
28	GRENZWERT	☐	GRENZWERT	NUMC15	NUMC	15	0	Statistical value
29	RECHNWERT	☐	RECHNWERT	NUMC15	NUMC	15	0	Invoice value
30	VERAMONAT	☐	VERAMONAT	CHAR01	CHAR	1	0	Processing month (Switzerland)
31	RUECKERST	☐	RUECKERST	RUECKERST	NUMC	1	0	Reimbursement code (Confederation Helvetica)
32	BEWIPFLIC	☐	BEWIPFLIC	BEWIPFLIC	NUMC	1	0	License requirement (CH only)
33	BEWINUMME	☐	BEWINUMME	BEWINUMME	NUMC	5	0	Approval number
34	RETOURCOD	☐	RETOURCOD	XFELD	CHAR	1	0	Returns ID for official declarations
35	POSTLEITZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
36	NUMMWERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
37	WERKSLAND	☐	WERKSLAND	LAND1	CHAR	3	0	Declaration to authorities: Country of Plant	T005
38	INLAIEVER	☐	IEVER	EXPVZ	CHAR	1	0	Domestic Mode of Transport for Foreign Trade	T618
39	LIEFERBED	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
40	BESTIREGI	☐	BESTIREGI	REGIO	CHAR	3	0	Destination region	*
41	VERSENDLD	☐	VERSENDLD	LAND1	CHAR	3	0	Country of dispatch	T005
42	EINKAUFOR	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
43	FAKTDATUM	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
44	PREFPACOD	☐	PREFPACOD	PREFPACOD	CHAR	3	0	Preference code for foreign trade (decl.to author., import)	T604C
45	THIERISCH	☐	THIERISCH	THIERISCH	CHAR	1	0	ID type for creating records
46	RECHNWEAK	☐	RECHNWEAK	WERTV8	CURR	15	2	Invoice value
47	RECHNWEEH	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
48	GRENZWEAK	☐	GRENZWEAK	WERTV7	CURR	13	2	Statistical value
49	GRENZWEEH	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
50	EIGENMAAK	☐	EIGENMAAK	MENG13	QUAN	13	3	Tare mass
51	EIGENMAEH	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
52	BESONMAAK	☐	BESONMAAK	MENG13	QUAN	13	3	Special unit of measure
53	BESONMAEH	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
54	IREFBELEG	☐	IREFBELEG	VBELN	CHAR	10	0	Reference document	*
55	IREFPOSIT	☐	IREFPOSIT	POSNR	NUMC	6	0	Reference item	*
56	IREFMONAT	☐	IREFMONAT	IREFMONAT	NUMC	2	0	Reference month for correction
57	IREFEJAHR	☐	IREFEJAHR	GJAHR	NUMC	4	0	Reference year for correction
58	BELEGIDEN	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
59	GENES	☐	GENES	GENES	CHAR	1	0	Data origin indicator for declarations to the authorities
60	P_LANDKEY	☐	P_LANDKEY	XFELD	CHAR	1	0	Country key
61	FLAGEUROC	☐	FTEUR	XFELD	CHAR	1	0	Declarations to the authorities: Ind. for decl. crcy = Euro
62	KUNDEUINR	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
63	EIGENUINR	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
64	WARENORTE	☐	BEZEI20	TEXT20	CHAR	20	0	Description
65	STAATSABG	☐	STABE	LAND1	CHAR	3	0	Country of Origin of the Means of Transport at Departure	T005
66	SPANIENID	☐	INAUKZ	CHAR01	CHAR	1	0	Indicator: Domestic / Foreign
67	PLISO	☐	FTPLISO	INTCA	CHAR	2	0	Periodic Declarations: ISO country code of business partner
68	DOMCODENR	☐	DOMCODE	CHAR1	CHAR	1	0	Overseas areas France (DoM)
69	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
70	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
71	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
72	ORDPA	☐	ORDPA	CHAR10	CHAR	10	0	Classification Key for Periodic Declarations in For. Trade
73	ISESSIONE	☐	ISESSIONE	ISESSIONE	CHAR	1	0	Indicator for normal business transactions and correction
74	CNTRYDECLN	☐	CODECL	LAND1	CHAR	3	0	Country of Export Declaration	T005
75	EUBELAND	☐	EUBELAND	LAND1	CHAR	3	0	EU Country of Departure/Destination	T005
76	INVOICECY	☐	INVOICECY	WAERS	CUKY	5	0	Invoice Currency	TCURC
77	ZOLLVERFA	☐	EXPRF	EXPRF	CHAR	8	0	Export/Import Procedure for Foreign Trade	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VEXAV	ARTGESCHA	T605	EXART		1	CN
2	VEXAV	BESONMAEH	T006	MSEHI	REF	1	CN
3	VEXAV	BESTILAND	T005	LAND1		1	CN
4	VEXAV	CNTRYDECLN	T005	LAND1	REF	1	CN
5	VEXAV	EIGENMAEH	T006	MSEHI	REF	1	CN
6	VEXAV	EINKAUFOR	T024E	EKORG		1	CN
7	VEXAV	EINLADFGH	T615	ZOLLA		1	CN
8	VEXAV	EUBELAND	T005	LAND1	REF	1	CN
9	VEXAV	GRENZWEEH	TCURC	WAERS	REF	1	CN
10	VEXAV	HANDELSLD	T005	LAND1		1	CN
11	VEXAV	INLAIEVER	T618	EXPVZ		1	CN
12	VEXAV	INVOICECY	TCURC	WAERS	REF	1	CN
13	VEXAV	KUNNR	KNA1	KUNNR	REF	1	CN
14	VEXAV	LIEFERBED	TINC	INCO1		1	CN
15	VEXAV	LIFNR	LFA1	LIFNR	REF	1	CN
16	VEXAV	MANDT	T000	MANDT	KEY	1	CN
17	VEXAV	MATNR	MARA	MATNR	REF	C	CN
18	VEXAV	NUMMBUKRS	T001	BUKRS		1	CN
19	VEXAV	NUMMWERKS	T001W	WERKS		1	CN
20	VEXAV	PREFPACOD	T604C	PREFPACOD		1	CN
21	VEXAV	RECHNWEEH	TCURC	WAERS	REF	1	CN
22	VEXAV	STAATSABG	T005	LAND1	REF	1	CN
23	VEXAV	STAATSZUG	T005	LAND1	REF	1	CN
24	VEXAV	STATWAREN	T604	STAWN		1	CN
25	VEXAV	URSPRSLND	T005	LAND1		1	CN
26	VEXAV	VERFAHREN	T616	EXPRF		1	CN
27	VEXAV	VERKAUFOR	TVKO	VKORG		1	CN
28	VEXAV	VERKEHRZW	T618	EXPVZ		1	CN
29	VEXAV	VERSENDLD	T005	LAND1		1	CN
30	VEXAV	WERKSLAND	T005	LAND1		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in