SAP table EIKP (Foreign Trade: Export/Import Header Data)

SAP table EIKP (Foreign Trade: Export/Import Header Data) stores header-level information related to foreign trade transactions, specifically for export and import processes. It includes key details such as document numbers, partner data, trade details, customs information, and logistical attributes that facilitate international trade compliance and reporting. This table is commonly used in conjunction with other related tables, such as EIPO, which stores item-level data for these transactions.

SAP table EIKP has 2 primary key fields being MANDT,EXNUM.

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

EIKP foreign key relationships

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