SAP EIKPVB Foreign Trade: Reference Structure for EIKP and Dynamic Part Table data and field list

EIKPVB is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Foreign Trade: Reference Structure for EIKP and Dynamic Part" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_EIKPVB TYPE EIKPVB.

The EIKPVB table consists of various fields, each holding specific information or linking keys about Foreign Trade: Reference Structure for EIKP and Dynamic Part data available in SAP. These include MANDT (Client), EXNUM (Number of foreign trade data in MM and SD documents), ALAND (Delivering country), EXPVZ (Mode of Transport for Foreign Trade)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

EIKPVB structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP EIKPVB structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the EIKPVB table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
EXNUMNumber of foreign trade data in MM and SD documents EXNUMCHAR10Assigned to domainEXNUM
ALANDDelivering country HLANDCHAR3T005LAND1VAL
EXPVZMode of Transport for Foreign Trade EXPVZCHAR1T618EXPVZ
ZOLLACustoms Office: Office of Exit/Entry for Foreign Trade DZOLLSCHAR6T615ZOLLS
ZOLLBCustoms office: Office of destination for foreign trade DZOLLBCHAR6T615ZOLLS
ZOLL1Customs office: Customs office 1 for foreign trade DZOLL1CHAR6T615ZOLLS
ZOLL2Customs office: Customs office 2 for foreign trade DZOLL2CHAR6T615ZOLLS
ZOLL3Customs office: Customs office 3 for foreign trade DZOLL3CHAR6T615ZOLLS
ZOLL4Customs office: Customs office 4 for foreign trade DZOLL4CHAR6T615ZOLLS
ZOLL5Customs office: Customs office 5 for foreign trade DZOLL5CHAR6T615ZOLLS
ZOLL6Customs office: Customs office 6 for foreign trade DZOLL6CHAR6T615ZOLLS
KZGBEIndicator for means of transport crossing the border KZGBECHAR30KZGBEF
KZABEIndicator for the means of transport at departure KZABECHAR30KZABE
STGBEOrigin of Means of Transport when Crossing the Border STGBECHAR3T005LAND1LND
STABECountry of Origin of the Means of Transport at Departure STABECHAR3T005LAND1LND
CONTAID: Goods cross border in a container CONTACHAR1CONTA
GRWCUCurrency of statistical values for foreign trade GRWCUCUKY5TCURCWAERS
IEVERDomestic Mode of Transport for Foreign Trade IEVERCHAR1T618EXPVZ
SEGALExclusion/Inclusion indicator for declara. to authorities SEGALCHAR2T609ASEGAL
WZOCUCurrency of customs values for import procg in foreign trade WZOCUCUKY5TCURCWAERS
PRONUInvoice: Number of invoice document for import processing PRONUCHAR25PRONU
PRODAInvoice: Date of invoice document for import processing PRODADATS8DATUM
VORPAPreliminary document: Document type for foreign trade procg VORPACHAR10T610VAVORPA
VORDAPreliminary document: Date of preliminary doc.f.import procg VORDADATS8DATUM
VORNUPreliminary document: No. of preliminary doc.f.import procg VORNUCHAR25CHAR25
BEHOEPreliminary doc.: Issuing authority of relevant prelim.doc. VOHOECHAR10T610OBEHOE
KENNUPreliminary document: Customs office/ID number for import KENNUCHAR6CHAR06
VOISOPrelim. doc.: ISO code of ctry issuing the preliminary doc. VOISOCHAR2INTCA
PREFPACODPreference code for foreign trade (decl.to author., import) PREFPACODCHAR3T604CPREFPACOD
PREFAPreference: Preference type for foreign trade PREFACHAR10T610PAPREFA
PREFNPreference: Official number of preference document - Import PREFNCHAR25CHAR25
PREDUPreference: Date of preference document for import procg PREDUDATS8DATUM
PRISOPreference: ISO code of country issuing the preference doc. PRISOCHAR2INTCA
PRHOEPreference: Issuing authoritiy for relevant preference doc. PRHOECHAR10T610OBEHOE
PRUELPreference: Validity date of preference document for import PRUELDATS8DATUM
NACARVerification documents: Type of certificate for import NACARCHAR10T610NANACAR
NACNUVerification docs: Official no. of verific. doc. - Import NACNUCHAR25CHAR25
NACDAVerification documents: Date of verif.doc. for import procg NACDADATS8DATUM
NAISOVerification doc: ISO code of ctry supplying verific.doc. NAISOCHAR2INTCA
NAHOEVerification documents: Issuing authority for relev. verif. NAHOECHAR10T610OBEHOE
NAUELVerification docs: Validity date of verific.doc. for import NAUELDATS8DATUM
TEXT1Comments: Text for foreign trade processing TXTFTCHAR40TEXT40
TEXT2Comments: Text for foreign trade processing TXTFTCHAR40TEXT40
TEXT3Comments: Text for foreign trade processing TXTFTCHAR40TEXT40
EXDARExport document: Export document type for foreign trade EXDARCHAR10T610VAVORPA
EXDAAExport document: Official number of export document EXDAACHAR25CHAR25
EXDABExport document: Valid-to number of export document EXDABCHAR25CHAR25
EXDTAT document: Type of T document for foreign trade EXDTACHAR10T610VAVORPA
EXDT2T document: Official number of T document for foreign trade EXDT2CHAR25CHAR25
EXDTBT doc.: Official no. for next page of T doc. f.foreign trade EXDTBCHAR25CHAR25
EXDPAPreference: Preference type for foreign trade EXDPACHAR10T610PAPREFA
EXPREPreference: Official number of preference document - Export EXPRECHAR25CHAR25
EXDT5CAP: Official number of T5 document for foreign trade EXDT5CHAR25CHAR25
LADELPlace of loading/unloading for foreign trade LADELCHAR40LADEL
AUSFUExporter for import processing in foreign trade AUSFUCHAR10LFA1ALPHALIFNR
EIOKWStatus: Complete document data in foreign trade (user) EIOKWCHAR1EIOKW
AUSOKStatus: Document data in foreign trade complete (system) AUSOKCHAR1XFELD
LAZL1Customs office: Country of customs office for foreign trade LAZLSCHAR3T005LAND1LND
LAZL2Customs office: Country of customs office for foreign trade LAZLSCHAR3T005LAND1LND
LAZL3Customs office: Country of customs office for foreign trade LAZLSCHAR3T005LAND1LND
LAZL4Customs office: Country of customs office for foreign trade LAZLSCHAR3T005LAND1LND
LAZL5Customs office: Country of customs office for foreign trade LAZLSCHAR3T005LAND1LND
LAZL6Customs office: Country of customs office for foreign trade LAZLSCHAR3T005LAND1LND
AZOLLCustoms office: Export customs office for foreign trade AZOLLCHAR6T615ZOLLS
AHBASBasis document category for foreign trade processing AHBASCHAR3AHBAS
REFNRSales and Distribution Document Number VBELNCHAR10Assigned to domainALPHAVBELNAUN
MABSDSelection date for periodic declarations MABSDDATS8DATUM
BFMARForeign Trade: Type of means of transport BFMARCHAR6T612BBFMAR
CUDCLCustoms declaration type for customs processing in FT CUDCLCHAR3CUDCL
UPDKZUpdate indicator UPDKZ_DCHAR1UPDKZ

Key field Non-key field



How do I retrieve data from SAP structure EIKPVB using ABAP code?

As EIKPVB is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on EIKPVB as there is no data to select.

How to access SAP table EIKPVB

Within an ECC or HANA version of SAP you can also view further information about EIKPVB and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).