SAP table T610VA (Foreign Trade: Preliminary Import Docs / Export Docs)

SAP table T610VA has 3 primary key fields being MANDT,LAND1,VORPA.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
LAND1 Country/Region Key CHAR 3 0 T005 LAND1
VORPA Type of Previous Document CHAR 10 0 VORPA
AHDMA Number of reminder days for communication in foreign trade DEC 3 0 AHDMA
FTPTY Foreign trade: Classification of foreign trade document CHAR 4 0 FTPTY
Not Specified
A Export document - General
AAAU Export document - Incomplete export declaration
AAAV Export document - Complete export declaration
E Refund on exports - Application
G Application for export/import license
GDE National Enhancement Sheet Germany (import/export license)
P Preference document - General
PATR Preference document - ATR
PEUR Preference document - EUR1
V Shipping document - General
VT1 Shipping document - T1 document
VT2 Shipping document - T2 document
VT2L Shipping document - T2L document
VT5 Shipping document - T5 document
GTSTR GTS-Relevance CHAR 1 0 /SAPSLL/GTSTR
Relevant for GTS-Integration
X Not relevant for GTS-Integration
PRDTC Previous Document Type Code CHAR 3 0 /SAPSLL/PRDTC
820 Despatch note model T
821 Despatch note model T1
822 Despatch note model T2

T610VA foreign key relationships

Table Field Check Table Check Field
0 T610VA LAND1 T005 Countries MANDT
0 T610VA LAND1 T005 Countries LAND1