The EIKP table in SAP ERP or S/4HANA stores Foreign Trade: Export/Import Header Data data. There are total 70 fields in EIKP table. The Foreign Trade: Export/Import Header Data table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of EIKP table. It is in Reuse Package for SCR 1 (QRT_RU_SCR_000001) ABAP package and is part of the Cross-Application Components (CA) module.
SAP EIKP Table Fields
Following is the list of fields that are available in SAP EIKP table. The primary key fields of the table are MANDT (Client), EXNUM (Number of foreign trade data in MM and SD documents).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| EXNUM | Number of foreign trade data in MM and SD documents | EXNUM | CHAR (10) | |
| ALAND | Delivering country | HLAND | T005 | CHAR (3) |
| EXPVZ | Mode of Transport at the Border (Intrastat) | EXPVZ | T618 | CHAR (1) |
| ZOLLA | Customs Office: Office of Exit/Entry for Foreign Trade | DZOLLS | T615 | CHAR (6) |
| ZOLLB | Customs office: Office of destination for foreign trade | DZOLLB | T615 | CHAR (6) |
| ZOLL1 | Customs office: Customs office 1 for foreign trade | DZOLL1 | T615 | CHAR (6) |
| ZOLL2 | Customs office: Customs office 2 for foreign trade | DZOLL2 | T615 | CHAR (6) |
| ZOLL3 | Customs office: Customs office 3 for foreign trade | DZOLL3 | T615 | CHAR (6) |
| ZOLL4 | Customs office: Customs office 4 for foreign trade | DZOLL4 | T615 | CHAR (6) |
| ZOLL5 | Customs office: Customs office 5 for foreign trade | DZOLL5 | T615 | CHAR (6) |
| ZOLL6 | Customs office: Customs office 6 for foreign trade | DZOLL6 | T615 | CHAR (6) |
| KZGBE | Identifier for Means of Transport crossing the Border | KZGBE | CHAR (30) | |
| KZABE | Identification for the Means of Transport Inland | KZABE | CHAR (30) | |
| STGBE | Origin of Means of Transport when Crossing the Border | STGBE | T005 | CHAR (3) |
| STABE | Country of Origin of the Means of Transport at Departure | STABE | T005 | CHAR (3) |
| CONTA | ID: Goods cross border in a container | CONTA | CHAR (1) | |
| GRWCU | Currency of statistical values for foreign trade | GRWCU | TCURC | CUKY (5) |
| IEVER | Domestic Mode of Transport for Foreign Trade | IEVER | T618 | CHAR (1) |
| SEGAL | Exclusion/Inclusion indicator for declara. to authorities | SEGAL | T609A | CHAR (2) |
| WZOCU | Currency of customs values for import procg in foreign trade | WZOCU | TCURC | CUKY (5) |
| PRONU | Invoice: Number of invoice document for import processing | PRONU | CHAR (25) | |
| PRODA | Invoice: Date of invoice document for import processing | PRODA | DATS (8) | |
| VORPA | Type of Previous Document | VORPA | T610VA | CHAR (10) |
| VORDA | Preliminary document: Date of preliminary doc.f.import procg | VORDA | DATS (8) | |
| VORNU | Number of Previous Document | VORNU | CHAR (25) | |
| BEHOE | Preliminary doc.: Issuing authority of relevant prelim.doc. | VOHOE | T610O | CHAR (10) |
| KENNU | Preliminary document: Customs office/ID number for import | KENNU | CHAR (6) | |
| VOISO | Prelim. doc.: ISO code of ctry issuing the preliminary doc. | VOISO | CHAR (2) | |
| PREFPACOD | Preference code for foreign trade (decl.to author., import) | PREFPACOD | T604C | CHAR (3) |
| PREFA | Preference: Preference type for foreign trade | PREFA | T610PA | CHAR (10) |
| PREFN | Preference: Official number of preference document – Import | PREFN | CHAR (25) | |
| PREDU | Preference: Date of preference document for import procg | PREDU | DATS (8) | |
| PRISO | Preference: ISO code of country issuing the preference doc. | PRISO | CHAR (2) | |
| PRHOE | Preference: Issuing authoritiy for relevant preference doc. | PRHOE | T610O | CHAR (10) |
| PRUEL | Preference: Validity date of preference document for import | PRUEL | DATS (8) | |
| NACAR | Verification documents: Type of certificate for import | NACAR | T610NA | CHAR (10) |
| NACNU | Verification docs: Official no. of verific. doc. – Import | NACNU | CHAR (25) | |
| NACDA | Verification documents: Date of verif.doc. for import procg | NACDA | DATS (8) | |
| NAISO | Verification doc: ISO code of ctry supplying verific.doc. | NAISO | CHAR (2) | |
| NAHOE | Verification documents: Issuing authority for relev. verif. | NAHOE | T610O | CHAR (10) |
| NAUEL | Verification docs: Validity date of verific.doc. for import | NAUEL | DATS (8) | |
| TEXT1 | Comments: Text for foreign trade processing | TXTFT | CHAR (40) | |
| TEXT2 | Comments: Text for foreign trade processing | TXTFT | CHAR (40) | |
| TEXT3 | Comments: Text for foreign trade processing | TXTFT | CHAR (40) | |
| EXDAR | Export document: Export document type for foreign trade | EXDAR | T610VA | CHAR (10) |
| EXDAA | Export document: Official number of export document | EXDAA | CHAR (25) | |
| EXDAB | Export document: Valid-to number of export document | EXDAB | CHAR (25) | |
| EXDTA | T document: Type of T document for foreign trade | EXDTA | T610VA | CHAR (10) |
| EXDT2 | T document: Official number of T document for foreign trade | EXDT2 | CHAR (25) | |
| EXDTB | T doc.: Official no. for next page of T doc. f.foreign trade | EXDTB | CHAR (25) | |
| EXDPA | Preference: Preference type for foreign trade | EXDPA | T610PA | CHAR (10) |
| EXPRE | Preference: Official number of preference document – Export | EXPRE | CHAR (25) | |
| EXDT5 | CAP: Official number of T5 document for foreign trade | EXDT5 | CHAR (25) | |
| LADEL | Place of loading/unloading for foreign trade | LADEL | CHAR (40) | |
| AUSFU | Exporter for import processing in foreign trade | AUSFU | LFA1 | CHAR (10) |
| EIOKW | Status: Complete document data in foreign trade (user) | EIOKW | CHAR (1) | |
| AUSOK | Status: Document data in foreign trade complete (system) | AUSOK | CHAR (1) | |
| LAZL1 | Customs office: Country of customs office for foreign trade | LAZLS | T005 | CHAR (3) |
| LAZL2 | Customs office: Country of customs office for foreign trade | LAZLS | T005 | CHAR (3) |
| LAZL3 | Customs office: Country of customs office for foreign trade | LAZLS | T005 | CHAR (3) |
| LAZL4 | Customs office: Country of customs office for foreign trade | LAZLS | T005 | CHAR (3) |
| LAZL5 | Customs office: Country of customs office for foreign trade | LAZLS | T005 | CHAR (3) |
| LAZL6 | Customs office: Country of customs office for foreign trade | LAZLS | T005 | CHAR (3) |
| AZOLL | Customs office: Export customs office for foreign trade | AZOLL | T615 | CHAR (6) |
| AHBAS | Basis document category for foreign trade processing | AHBAS | CHAR (3) | |
| REFNR | Sales and Distribution Document Number | VBELN | * | CHAR (10) |
| MABSD | Selection Date for Periodic Declarations | MABSD | DATS (8) | |
| BFMAR | Foreign Trade: Type of means of transport | BFMAR | T612B | CHAR (6) |
| CUDCL | Customs declaration type for customs processing in FT | CUDCL | CHAR (3) |
