1. Home
  2. Resources
  3. SAP Tables
  4. EIKPVB - Foreign Trade: Reference Structure for EIKP and Dynamic Part

SAP Table EIKPVB

Foreign Trade: Reference Structure for EIKP and Dynamic Part

EIKPVB (Foreign Trade: Reference Structure for EIKP and Dynamic Part) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link EIKPVB to other SAP tables.

EIKPVB table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EXNUM Number of foreign trade data in MM and SD documents EXNUM CHAR 10 0
ALAND Delivering country HLAND T005 CHAR 3 0
EXPVZ Mode of Transport for Foreign Trade EXPVZ T618 CHAR 1 0
ZOLLA Customs Office: Office of Exit/Entry for Foreign Trade DZOLLS T615 CHAR 6 0
ZOLLB Customs office: Office of destination for foreign trade DZOLLB T615 CHAR 6 0
ZOLL1 Customs office: Customs office 1 for foreign trade DZOLL1 T615 CHAR 6 0
ZOLL2 Customs office: Customs office 2 for foreign trade DZOLL2 T615 CHAR 6 0
ZOLL3 Customs office: Customs office 3 for foreign trade DZOLL3 T615 CHAR 6 0
ZOLL4 Customs office: Customs office 4 for foreign trade DZOLL4 T615 CHAR 6 0
ZOLL5 Customs office: Customs office 5 for foreign trade DZOLL5 T615 CHAR 6 0
ZOLL6 Customs office: Customs office 6 for foreign trade DZOLL6 T615 CHAR 6 0
KZGBE Indicator for means of transport crossing the border KZGBE CHAR 30 0
KZABE Indicator for the means of transport at departure KZABE CHAR 30 0
STGBE Origin of Means of Transport when Crossing the Border STGBE T005 CHAR 3 0
STABE Country of Origin of the Means of Transport at Departure STABE T005 CHAR 3 0
CONTA ID: Goods cross border in a container CONTA CHAR 1 0
0 Goods do not cross the border in a container
1 Goods cross the border in a container
GRWCU Currency of statistical values for foreign trade GRWCU TCURC CUKY 5 0
IEVER Domestic Mode of Transport for Foreign Trade IEVER T618 CHAR 1 0
SEGAL Exclusion/Inclusion indicator for declara. to authorities SEGAL T609A CHAR 2 0
WZOCU Currency of customs values for import procg in foreign trade WZOCU TCURC CUKY 5 0
PRONU Invoice: Number of invoice document for import processing PRONU CHAR 25 0
PRODA Invoice: Date of invoice document for import processing PRODA DATS 8 0
VORPA Preliminary document: Document type for foreign trade procg VORPA T610VA CHAR 10 0
VORDA Preliminary document: Date of preliminary doc.f.import procg VORDA DATS 8 0
VORNU Preliminary document: No. of preliminary doc.f.import procg VORNU CHAR 25 0
BEHOE Preliminary doc.: Issuing authority of relevant prelim.doc. VOHOE T610O CHAR 10 0
KENNU Preliminary document: Customs office/ID number for import KENNU CHAR 6 0
VOISO Prelim. doc.: ISO code of ctry issuing the preliminary doc. VOISO CHAR 2 0
PREFPACOD Preference code for foreign trade (decl.to author., import) PREFPACOD T604C CHAR 3 0
PREFA Preference: Preference type for foreign trade PREFA T610PA CHAR 10 0
PREFN Preference: Official number of preference document - Import PREFN CHAR 25 0
PREDU Preference: Date of preference document for import procg PREDU DATS 8 0
PRISO Preference: ISO code of country issuing the preference doc. PRISO CHAR 2 0
PRHOE Preference: Issuing authoritiy for relevant preference doc. PRHOE T610O CHAR 10 0
PRUEL Preference: Validity date of preference document for import PRUEL DATS 8 0
NACAR Verification documents: Type of certificate for import NACAR T610NA CHAR 10 0
NACNU Verification docs: Official no. of verific. doc. - Import NACNU CHAR 25 0
NACDA Verification documents: Date of verif.doc. for import procg NACDA DATS 8 0
NAISO Verification doc: ISO code of ctry supplying verific.doc. NAISO CHAR 2 0
NAHOE Verification documents: Issuing authority for relev. verif. NAHOE T610O CHAR 10 0
NAUEL Verification docs: Validity date of verific.doc. for import NAUEL DATS 8 0
TEXT1 Comments: Text for foreign trade processing TXTFT CHAR 40 0
TEXT2 Comments: Text for foreign trade processing TXTFT CHAR 40 0
TEXT3 Comments: Text for foreign trade processing TXTFT CHAR 40 0
EXDAR Export document: Export document type for foreign trade EXDAR T610VA CHAR 10 0
EXDAA Export document: Official number of export document EXDAA CHAR 25 0
EXDAB Export document: Valid-to number of export document EXDAB CHAR 25 0
EXDTA T document: Type of T document for foreign trade EXDTA T610VA CHAR 10 0
EXDT2 T document: Official number of T document for foreign trade EXDT2 CHAR 25 0
EXDTB T doc.: Official no. for next page of T doc. f.foreign trade EXDTB CHAR 25 0
EXDPA Preference: Preference type for foreign trade EXDPA T610PA CHAR 10 0
EXPRE Preference: Official number of preference document - Export EXPRE CHAR 25 0
EXDT5 CAP: Official number of T5 document for foreign trade EXDT5 CHAR 25 0
LADEL Place of loading/unloading for foreign trade LADEL CHAR 40 0
AUSFU Exporter for import processing in foreign trade AUSFU LFA1 CHAR 10 0
EIOKW Status: Complete document data in foreign trade (user) EIOKW CHAR 1 0
AUSOK Status: Document data in foreign trade complete (system) AUSOK CHAR 1 0
X Yes
NULL No
LAZL1 Customs office: Country of customs office for foreign trade LAZLS T005 CHAR 3 0
LAZL2 Customs office: Country of customs office for foreign trade LAZLS T005 CHAR 3 0
LAZL3 Customs office: Country of customs office for foreign trade LAZLS T005 CHAR 3 0
LAZL4 Customs office: Country of customs office for foreign trade LAZLS T005 CHAR 3 0
LAZL5 Customs office: Country of customs office for foreign trade LAZLS T005 CHAR 3 0
LAZL6 Customs office: Country of customs office for foreign trade LAZLS T005 CHAR 3 0
AZOLL Customs office: Export customs office for foreign trade AZOLL T615 CHAR 6 0
AHBAS Basis document category for foreign trade processing AHBAS CHAR 3 0
1AH Receipt / Import: Foreign Trade document - Import
1LI Receipt/Import: Vendor Master
1BE Receipt/Import: Purchase Order Document
1LA Receipt/Import: Inbound Delivery
1WE Receipt/Import: Goods Receipt Document
2AH Dispatch / Export: Foreign Trade Document - Export
2KU Dispatch/Export: Customer Master
2VA Dispatch/Export: Sales Document
2LI Dispatch/Export: Outbound Delivery Document
2FA Dispatch/Export: Billing Document
REFNR Sales and Distribution Document Number VBELN CHAR 10 0
MABSD Selection date for periodic declarations MABSD DATS 8 0
BFMAR Foreign Trade: Type of means of transport BFMAR T612B CHAR 6 0
CUDCL Customs declaration type for customs processing in FT CUDCL CHAR 3 0
UPDKZ Update indicator UPDKZ_D CHAR 1 0

EIKPVB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EIKPVB ALAND EIKPVB MANDT T005 Countries MANDT
EIKPVB ALAND EIKPVB ALAND T005 Countries LAND1
EIKPVB AUSFU EIKPVB MANDT LFA1 Vendor Master (General Section) MANDT
EIKPVB AUSFU EIKPVB AUSFU LFA1 Vendor Master (General Section) LIFNR
EIKPVB AZOLL EIKPVB ALAND T615 Foreign Trade: Customs Offices LAND1
EIKPVB AZOLL EIKPVB AZOLL T615 Foreign Trade: Customs Offices ZOLLA
EIKPVB AZOLL EIKPVB MANDT T615 Foreign Trade: Customs Offices MANDT
EIKPVB BEHOE EIKPVB MANDT T610O Foreign Trade: Authorities MANDT
EIKPVB BEHOE EIKPVB BEHOE T610O Foreign Trade: Authorities BEHOE
EIKPVB BFMAR EIKPVB MANDT T612B FT/Customs: Electr. Procedure: Type of means of transport MANDT
EIKPVB BFMAR EIKPVB ALAND T612B FT/Customs: Electr. Procedure: Type of means of transport EILAN
EIKPVB BFMAR EIKPVB BFMAR T612B FT/Customs: Electr. Procedure: Type of means of transport BFMAR
EIKPVB EXDAR EIKPVB EXDAR T610VA Foreign Trade: Preliminary Import Docs / Export Docs VORPA
EIKPVB EXDAR EIKPVB MANDT T610VA Foreign Trade: Preliminary Import Docs / Export Docs MANDT
EIKPVB EXDAR EIKPVB ALAND T610VA Foreign Trade: Preliminary Import Docs / Export Docs LAND1
EIKPVB EXDPA EIKPVB MANDT T610PA Foreign Trade: Preference Type MANDT
EIKPVB EXDPA EIKPVB ALAND T610PA Foreign Trade: Preference Type EILAN
EIKPVB EXDPA EIKPVB EXDPA T610PA Foreign Trade: Preference Type PREFA
EIKPVB EXDTA EIKPVB MANDT T610VA Foreign Trade: Preliminary Import Docs / Export Docs MANDT
EIKPVB EXDTA EIKPVB ALAND T610VA Foreign Trade: Preliminary Import Docs / Export Docs LAND1
EIKPVB EXDTA EIKPVB EXDTA T610VA Foreign Trade: Preliminary Import Docs / Export Docs VORPA
EIKPVB EXPVZ EIKPVB MANDT T618 Foreign Trade: Modes of Transport MANDT
EIKPVB EXPVZ EIKPVB ALAND T618 Foreign Trade: Modes of Transport LAND1
EIKPVB EXPVZ EIKPVB EXPVZ T618 Foreign Trade: Modes of Transport EXPVZ
EIKPVB GRWCU EIKPVB MANDT TCURC Currency Codes MANDT
EIKPVB GRWCU EIKPVB GRWCU TCURC Currency Codes WAERS
EIKPVB IEVER EIKPVB MANDT T618 Foreign Trade: Modes of Transport MANDT
EIKPVB IEVER EIKPVB ALAND T618 Foreign Trade: Modes of Transport LAND1
EIKPVB IEVER EIKPVB IEVER T618 Foreign Trade: Modes of Transport EXPVZ
EIKPVB LAZL1 EIKPVB LAZL1 T005 Countries LAND1
EIKPVB LAZL1 EIKPVB MANDT T005 Countries MANDT
EIKPVB LAZL2 EIKPVB MANDT T005 Countries MANDT
EIKPVB LAZL2 EIKPVB LAZL2 T005 Countries LAND1
EIKPVB LAZL3 EIKPVB MANDT T005 Countries MANDT
EIKPVB LAZL3 EIKPVB LAZL3 T005 Countries LAND1
EIKPVB LAZL4 EIKPVB MANDT T005 Countries MANDT
EIKPVB LAZL4 EIKPVB LAZL4 T005 Countries LAND1
EIKPVB LAZL5 EIKPVB MANDT T005 Countries MANDT
EIKPVB LAZL5 EIKPVB LAZL5 T005 Countries LAND1
EIKPVB LAZL6 EIKPVB LAZL6 T005 Countries LAND1
EIKPVB LAZL6 EIKPVB MANDT T005 Countries MANDT
EIKPVB MANDT EIKPVB MANDT T000 Clients MANDT
EIKPVB NACAR EIKPVB ALAND T610NA Import Processing: Verification Documents LAND1
EIKPVB NACAR EIKPVB NACAR T610NA Import Processing: Verification Documents NACAR
EIKPVB NACAR EIKPVB MANDT T610NA Import Processing: Verification Documents MANDT
EIKPVB NAHOE EIKPVB NAHOE T610O Foreign Trade: Authorities BEHOE
EIKPVB NAHOE EIKPVB MANDT T610O Foreign Trade: Authorities MANDT
EIKPVB PREFA EIKPVB MANDT T610PA Foreign Trade: Preference Type MANDT
EIKPVB PREFA EIKPVB ALAND T610PA Foreign Trade: Preference Type EILAN
EIKPVB PREFA EIKPVB PREFA T610PA Foreign Trade: Preference Type PREFA
EIKPVB PREFPACOD EIKPVB ALAND T604C Preference: Preference Procedure Code LAND1
EIKPVB PREFPACOD EIKPVB PREFPACOD T604C Preference: Preference Procedure Code PREFPACOD
EIKPVB PREFPACOD EIKPVB MANDT T604C Preference: Preference Procedure Code MANDT
EIKPVB PRHOE EIKPVB MANDT T610O Foreign Trade: Authorities MANDT
EIKPVB PRHOE EIKPVB PRHOE T610O Foreign Trade: Authorities BEHOE
EIKPVB SEGAL EIKPVB MANDT T609A Foreign Trade: Declarations to Authorities - Exclusion Ind. MANDT
EIKPVB SEGAL EIKPVB SEGAL T609A Foreign Trade: Declarations to Authorities - Exclusion Ind. SEGAL
EIKPVB STABE EIKPVB MANDT T005 Countries MANDT
EIKPVB STABE EIKPVB STABE T005 Countries LAND1
EIKPVB STGBE EIKPVB MANDT T005 Countries MANDT
EIKPVB STGBE EIKPVB STGBE T005 Countries LAND1
EIKPVB VORPA EIKPVB ALAND T610VA Foreign Trade: Preliminary Import Docs / Export Docs LAND1
EIKPVB VORPA EIKPVB VORPA T610VA Foreign Trade: Preliminary Import Docs / Export Docs VORPA
EIKPVB VORPA EIKPVB MANDT T610VA Foreign Trade: Preliminary Import Docs / Export Docs MANDT
EIKPVB WZOCU EIKPVB MANDT TCURC Currency Codes MANDT
EIKPVB WZOCU EIKPVB WZOCU TCURC Currency Codes WAERS
EIKPVB ZOLL1 EIKPVB MANDT T615 Foreign Trade: Customs Offices MANDT
EIKPVB ZOLL1 EIKPVB LAZL1 T615 Foreign Trade: Customs Offices LAND1
EIKPVB ZOLL1 EIKPVB ZOLL1 T615 Foreign Trade: Customs Offices ZOLLA
EIKPVB ZOLL2 EIKPVB MANDT T615 Foreign Trade: Customs Offices MANDT
EIKPVB ZOLL2 EIKPVB LAZL2 T615 Foreign Trade: Customs Offices LAND1
EIKPVB ZOLL2 EIKPVB ZOLL2 T615 Foreign Trade: Customs Offices ZOLLA
EIKPVB ZOLL3 EIKPVB ZOLL3 T615 Foreign Trade: Customs Offices ZOLLA
EIKPVB ZOLL3 EIKPVB MANDT T615 Foreign Trade: Customs Offices MANDT
EIKPVB ZOLL3 EIKPVB LAZL3 T615 Foreign Trade: Customs Offices LAND1
EIKPVB ZOLL4 EIKPVB MANDT T615 Foreign Trade: Customs Offices MANDT
EIKPVB ZOLL4 EIKPVB LAZL4 T615 Foreign Trade: Customs Offices LAND1
EIKPVB ZOLL4 EIKPVB ZOLL4 T615 Foreign Trade: Customs Offices ZOLLA
EIKPVB ZOLL5 EIKPVB ZOLL5 T615 Foreign Trade: Customs Offices ZOLLA
EIKPVB ZOLL5 EIKPVB MANDT T615 Foreign Trade: Customs Offices MANDT
EIKPVB ZOLL5 EIKPVB LAZL5 T615 Foreign Trade: Customs Offices LAND1
EIKPVB ZOLL6 EIKPVB MANDT T615 Foreign Trade: Customs Offices MANDT
EIKPVB ZOLL6 EIKPVB LAZL6 T615 Foreign Trade: Customs Offices LAND1
EIKPVB ZOLL6 EIKPVB ZOLL6 T615 Foreign Trade: Customs Offices ZOLLA
EIKPVB ZOLLA EIKPVB ALAND T615 Foreign Trade: Customs Offices LAND1
EIKPVB ZOLLA EIKPVB ZOLLA T615 Foreign Trade: Customs Offices ZOLLA
EIKPVB ZOLLA EIKPVB MANDT T615 Foreign Trade: Customs Offices MANDT
EIKPVB ZOLLB EIKPVB MANDT T615 Foreign Trade: Customs Offices MANDT
EIKPVB ZOLLB KUWEV LAND1 T615 Foreign Trade: Customs Offices LAND1
EIKPVB ZOLLB EIKPVB ZOLLB T615 Foreign Trade: Customs Offices ZOLLA