1. Home
  2. Resources
  3. SAP Tables
  4. EIEI - Foreign Trade: Export/Import Communication Data

SAP Table EIEI

Foreign Trade: Export/Import Communication Data

EIEI (Foreign Trade: Export/Import Communication Data) 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 EIEI to other SAP tables.

EIEI 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 EIKP CHAR 10 0
EXPOS Internal item number for foreign trade data in MM and SD EXPOS EIPO NUMC 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
AHAPP Basis application for communication in foreign trade AHAPP CHAR 2 0
DE Communication: Printing - Export
EE Communication: EDI - Export
EI Communication: EDI - Import
ME Declarations to Authorities: EXTRASTAT
MI Declarations to Authorities: INTRASTAT
MJ Declarations to Authorities: NITI (Japan)
MK Declarations to Authorities: KOBRA
MS Declarations to Authorities: SED/AERP
MV Declarations to Authorities: VAR (Switzerland
KAPPL Application KAPPL T681A CHAR 2 0
KSCHL Output Type NA_KSCHL T685 CHAR 4 0
DOKNU Foreign Trade: Printing - Document Number DOKNU CHAR 25 0
REFNR Sales and Distribution Document Number VBELN CHAR 10 0
REFPS Item number of the SD document POSNR NUMC 6 0
NACAR Verification documents: Type of certificate for import NACAR T610NA CHAR 10 0
PREFA Preference: Preference type for foreign trade PREFA T610PA CHAR 10 0
VORPA Preliminary document: Document type for foreign trade procg VORPA T610VA CHAR 10 0
AHDMA Number of reminder days for communication in foreign trade AHDMA DEC 3 0
FTPTY Foreign trade: Classification of foreign trade document FTPTY CHAR 4 0
NULL 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
PEUR Preference document - EUR1
PATR Preference document - ATR
V Shipping document - General
VT1 Shipping document - T1 document
VT2 Shipping document - T2 document
VT2L Shipping document - T2L document
VT5 Shipping document - T5 document
BEHOE Issuing authority for relevant Foreign Trade document BEHOE T610O CHAR 10 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZET Entry time ERZET TIMS 6 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
MABJJ Reporting year of declaration to authorities DATUMJAHR NUMC 4 0
MABMM Reporting month of declaration to authorities DATUMMONA NUMC 2 0
MABWR Indicator: Goods direction for declarations to authorities VEREI NUMC 1 0
1 Receipt / Import
2 Dispatch / Export
MABNR Sequential number for Intrastat declaration LFDNR_VEIA NUMC 7 0
STADU Foreign Trade: Print Status for Foreign Trade Document STADU CHAR 2 0
NULL No problems with printing
01 Hardware / Other errors such as torn paper
BEHO2 Issuing authority for relevant Foreign Trade document BEHOE T610O CHAR 10 0
STAZ1 Customs status STAZ1 CHAR 1 0
X Yes
NULL No
STAZ2 Customs status STAZ1 CHAR 1 0
X Yes
NULL No
TZON1 Time Zone TZNZONE TTZZ CHAR 6 0
TSTM1 UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS DEC 15 0
TZON2 Time Zone TZNZONE TTZZ CHAR 6 0
TSTM2 UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS DEC 15 0

EIEI foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EIEI BEHO2 EIEI MANDT T610O Foreign Trade: Authorities MANDT
EIEI BEHO2 EIEI BEHO2 T610O Foreign Trade: Authorities BEHOE
EIEI BEHOE EIEI BEHOE T610O Foreign Trade: Authorities BEHOE
EIEI BEHOE EIEI MANDT T610O Foreign Trade: Authorities MANDT
EIEI EXNUM EIEI MANDT EIKP Foreign Trade: Export/Import Header Data MANDT
EIEI EXNUM EIEI EXNUM EIKP Foreign Trade: Export/Import Header Data EXNUM
EIEI EXPOS EIEI MANDT EIPO Foreign Trade: Export/Import: Item Data MANDT
EIEI EXPOS EIEI EXNUM EIPO Foreign Trade: Export/Import: Item Data EXNUM
EIEI EXPOS EIEI EXPOS EIPO Foreign Trade: Export/Import: Item Data EXPOS
EIEI KAPPL EIEI KAPPL T681A Conditions: Applications KAPPL
EIEI KSCHL EIEI KSCHL T685 Conditions: Types KSCHL
EIEI KSCHL EIEI MANDT T685 Conditions: Types MANDT
EIEI KSCHL 'B' T685 Conditions: Types KVEWE
EIEI KSCHL 'V3' T685 Conditions: Types KAPPL
EIEI MANDT EIEI MANDT T000 Clients MANDT
EIEI NACAR EIKP ALAND T610NA Import Processing: Verification Documents LAND1
EIEI NACAR EIEI NACAR T610NA Import Processing: Verification Documents NACAR
EIEI NACAR EIEI MANDT T610NA Import Processing: Verification Documents MANDT
EIEI PREFA EIEI MANDT T610PA Foreign Trade: Preference Type MANDT
EIEI PREFA EIKP ALAND T610PA Foreign Trade: Preference Type EILAN
EIEI PREFA EIEI PREFA T610PA Foreign Trade: Preference Type PREFA
EIEI TZON1 EIEI MANDT TTZZ Time zones CLIENT
EIEI TZON1 EIEI TZON1 TTZZ Time zones TZONE
EIEI TZON2 EIEI MANDT TTZZ Time zones CLIENT
EIEI TZON2 EIEI TZON2 TTZZ Time zones TZONE
EIEI VORPA EIEI VORPA T610VA Foreign Trade: Preliminary Import Docs / Export Docs VORPA
EIEI VORPA EIEI MANDT T610VA Foreign Trade: Preliminary Import Docs / Export Docs MANDT
EIEI VORPA EIKP ALAND T610VA Foreign Trade: Preliminary Import Docs / Export Docs LAND1