EIPO SAP (Foreign Trade: Export/Import: Item Data) Table details
Description: Foreign Trade: Export/Import: Item Data
Table field list including key, data, relationships and ABAP select examples
EIPO is a standard SAP Table which is used to store Foreign Trade: Export/Import: Item Data data and is available within R/3 SAP systems depending on the version and release level.
The EIPO table consists of various fields, each holding specific information or linking keys about Foreign Trade: Export/Import: Item Data data available in SAP. These include EXNUM (Number of foreign trade data in MM and SD documents), EXPOS (Internal item number for foreign trade data in MM and SD), STAWN (Commodity Code/Import Code Number for Foreign Trade), EXPRF (Export/Import Procedure 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. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP EIPO table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
EXNUM | Number of foreign trade data in MM and SD documents | EXNUM | CHAR | 10 | EIKP | EXNUM | |||
EXPOS | Internal item number for foreign trade data in MM and SD | EXPOS | NUMC | 6 | EXPOS | ||||
STAWN | Commodity Code/Import Code Number for Foreign Trade | STAWN | CHAR | 17 | T604 | STAWN | |||
EXPRF | Export/Import Procedure for Foreign Trade | EXPRF | CHAR | 8 | T616 | EXPRF | |||
EXART | Business Transaction Type for Foreign Trade | EXART | CHAR | 2 | T605 | EXART | EXA | ||
HERKL | Country of origin of the material | HERKL | CHAR | 3 | T005 | LAND1 | LND | ||
HERKR | Region of origin of material (non-preferential origin) | HERKR | CHAR | 3 | Assigned to domain | REGIO | |||
GRWRT | Statistical value for foreign trade | GRWRT | CURR | 13(2) | GRWRT | ||||
PREFPACOD | Preference code for foreign trade (decl.to author., import) | PREFPACOD | CHAR | 3 | T604C | PREFPACOD | |||
SEGAL | Exclusion/Inclusion indicator for declara. to authorities | SEGAL | CHAR | 2 | T609A | SEGAL | |||
MOWNR | CAP: Number of CAP products list | MOWNR | CHAR | 12 | T618M | MOWNR | |||
MOGRU | Common Agricultural Policy: CAP products group-Foreign Trade | MOGRU | CHAR | 6 | T618G | MOGRU | |||
GPNUM | Production statistics: PRODCOM number for foreign trade | GPNUM | CHAR | 9 | T609G | GPNUM | |||
CASNR | CAS number for pharmaceutical products in foreign trade | CASNR | CHAR | 15 | T610C | CASNR | |||
STEUC | Control code for consumption taxes in foreign trade | STEUC | CHAR | 16 | T604F | STEUC | |||
WZOLL | Customs val. in doc.currency in imp.procg for foreign trade | WZOLL | CURR | 13(2) | GRWRT | ||||
VERLD | Country of dispatch for Foreign Trade | VERLD | CHAR | 3 | T005 | LAND1 | |||
HANLD | Trading country for foreign trade | HANLD | CHAR | 3 | T005 | LAND1 | |||
TEXT1 | Comments: Text for foreign trade processing | TXTFT | CHAR | 40 | TEXT40 | ||||
TEXT2 | Comments: Text for foreign trade processing | TXTFT | CHAR | 40 | TEXT40 | ||||
TEXT3 | Comments: Text for foreign trade processing | TXTFT | CHAR | 40 | TEXT40 | ||||
COKON | Customs quota code for import processing in foreign trade | COKON | CHAR | 6 | T610K | COKON | |||
COPHA | Pharmaceutical products code (Foreign Trade) | COPHA | CHAR | 6 | T610D | COPHA | |||
COADI | Anti-dumping code for import processing in foreign trade | COADI | CHAR | 6 | T610A | COADI | |||
PRONU | Invoice: Number of invoice document for import processing | PRONU | CHAR | 25 | PRONU | ||||
PRODA | Invoice: Date of invoice document for import processing | PRODA | DATS | 8 | DATUM | ||||
VORPA | Preliminary document: Document type for foreign trade procg | VORPA | CHAR | 10 | T610VA | VORPA | |||
VORNU | Preliminary document: No. of preliminary doc.f.import procg | VORNU | CHAR | 25 | CHAR25 | ||||
VORDA | Preliminary document: Date of preliminary doc.f.import procg | VORDA | DATS | 8 | DATUM | ||||
BEHOE | Preliminary doc.: Issuing authority of relevant prelim.doc. | VOHOE | CHAR | 10 | T610O | BEHOE | |||
KENNU | Preliminary document: Customs office/ID number for import | KENNU | CHAR | 6 | CHAR06 | ||||
VOISO | Prelim. doc.: ISO code of ctry issuing the preliminary doc. | VOISO | CHAR | 2 | INTCA | ||||
PREFA | Preference: Preference type for foreign trade | PREFA | CHAR | 10 | T610PA | PREFA | |||
PREFN | Preference: Official number of preference document - Import | PREFN | CHAR | 25 | CHAR25 | ||||
PREDU | Preference: Date of preference document for import procg | PREDU | DATS | 8 | DATUM | ||||
PRISO | Preference: ISO code of country issuing the preference doc. | PRISO | CHAR | 2 | INTCA | ||||
PRHOE | Preference: Issuing authoritiy for relevant preference doc. | PRHOE | CHAR | 10 | T610O | BEHOE | |||
PRUEL | Preference: Validity date of preference document for import | PRUEL | DATS | 8 | DATUM | ||||
NACAR | Verification documents: Type of certificate for import | NACAR | CHAR | 10 | T610NA | NACAR | |||
NACNU | Verification docs: Official no. of verific. doc. - Import | NACNU | CHAR | 25 | CHAR25 | ||||
NACDA | Verification documents: Date of verif.doc. for import procg | NACDA | DATS | 8 | DATUM | ||||
NAISO | Verification doc: ISO code of ctry supplying verific.doc. | NAISO | CHAR | 2 | INTCA | ||||
NAHOE | Verification documents: Issuing authority for relev. verif. | NAHOE | CHAR | 10 | T610O | BEHOE | |||
NAUEL | Verification docs: Validity date of verific.doc. for import | NAUEL | DATS | 8 | DATUM | ||||
NACA2 | Verification documents: Type of certificate for import | NACAR | CHAR | 10 | T610NA | NACAR | |||
NACN2 | Verification docs: Official no. of verific. doc. - Import | NACNU | CHAR | 25 | CHAR25 | ||||
NACD2 | Verification documents: Date of verif.doc. for import procg | NACDA | DATS | 8 | DATUM | ||||
NAIS2 | Verification doc: ISO code of ctry supplying verific.doc. | NAISO | CHAR | 2 | INTCA | ||||
NAHO2 | Verification documents: Issuing authority for relev. verif. | NAHOE | CHAR | 10 | T610O | BEHOE | |||
NAUE2 | Verification docs: Validity date of verific.doc. for import | NAUEL | DATS | 8 | DATUM | ||||
NACA3 | Verification documents: Type of certificate for import | NACAR | CHAR | 10 | T610NA | NACAR | |||
NACN3 | Verification docs: Official no. of verific. doc. - Import | NACNU | CHAR | 25 | CHAR25 | ||||
NACD3 | Verification documents: Date of verif.doc. for import procg | NACDA | DATS | 8 | DATUM | ||||
NAIS3 | Verification doc: ISO code of ctry supplying verific.doc. | NAISO | CHAR | 2 | INTCA | ||||
NAHO3 | Verification documents: Issuing authority for relev. verif. | NAHOE | CHAR | 10 | T610O | BEHOE | |||
NAUE3 | Verification docs: Validity date of verific.doc. for import | NAUEL | DATS | 8 | DATUM | ||||
NACA4 | Verification documents: Type of certificate for import | NACAR | CHAR | 10 | T610NA | NACAR | |||
NACN4 | Verification docs: Official no. of verific. doc. - Import | NACNU | CHAR | 25 | CHAR25 | ||||
NACD4 | Verification documents: Date of verif.doc. for import procg | NACDA | DATS | 8 | DATUM | ||||
NAIS4 | Verification doc: ISO code of ctry supplying verific.doc. | NAISO | CHAR | 2 | INTCA | ||||
NAHO4 | Verification documents: Issuing authority for relev. verif. | NAHOE | CHAR | 10 | T610O | BEHOE | |||
NAUE4 | Verification docs: Validity date of verific.doc. for import | NAUEL | DATS | 8 | DATUM | ||||
NACA5 | Verification documents: Type of certificate for import | NACAR | CHAR | 10 | T610NA | NACAR | |||
NACN5 | Verification docs: Official no. of verific. doc. - Import | NACNU | CHAR | 25 | CHAR25 | ||||
NACD5 | Verification documents: Date of verif.doc. for import procg | NACDA | DATS | 8 | DATUM | ||||
NAIS5 | Verification doc: ISO code of ctry supplying verific.doc. | NAISO | CHAR | 2 | INTCA | ||||
NAHO5 | Verification documents: Issuing authority for relev. verif. | NAHOE | CHAR | 10 | T610O | BEHOE | |||
NAUE5 | Verification docs: Validity date of verific.doc. for import | NAUEL | DATS | 8 | DATUM | ||||
EXDAR | Export document: Export document type for foreign trade | EXDAR | CHAR | 10 | T610VA | VORPA | |||
EXDAA | Export document: Official number of export document | EXDAA | CHAR | 25 | CHAR25 | ||||
EXDAB | Export document: Valid-to number of export document | EXDAB | CHAR | 25 | CHAR25 | ||||
EXDTA | T document: Type of T document for foreign trade | EXDTA | CHAR | 10 | T610VA | VORPA | |||
EXDT2 | T document: Official number of T document for foreign trade | EXDT2 | CHAR | 25 | CHAR25 | ||||
EXDTB | T doc.: Official no. for next page of T doc. f.foreign trade | EXDTB | CHAR | 25 | CHAR25 | ||||
EXDPA | Preference: Preference type for foreign trade | EXDPA | CHAR | 10 | T610PA | PREFA | |||
EXPRE | Preference: Official number of preference document - Export | EXPRE | CHAR | 25 | CHAR25 | ||||
EXDT5 | CAP: Official number of T5 document for foreign trade | EXDT5 | CHAR | 25 | CHAR25 | ||||
AUSOK | Status: Document data in foreign trade complete (system) | AUSOK | CHAR | 1 | XFELD | ||||
COIMP | Code number for import processing in foreign trade | COIMP | CHAR | 17 | T604 | STAWN | COI | ||
HERSE | Manufacturer number for import processing in foreign trade | HERSE | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
COBLD | Import code no. in destination country for foreign trade | COBLD | CHAR | 17 | T604 | STAWN | |||
EIOKW | Status: Complete document data in foreign trade (user) | EIOKW | CHAR | 1 | EIOKW | ||||
EIOKA | EDI: Export/Import customs tariff number for foreign trade | EIOKA | CHAR | 1 | EIOKW | ||||
GBNUM | Foreign Trade:Customs declaration list no. for Foreign Trade | GB_NR | CHAR | 20 | CHAR20 | ||||
RGNNR | Registration number for import processing in foreign trade | RG_NR | CHAR | 20 | CHAR20 | ||||
PRENC | Exemption certificate: Indicator for legal control | PRENC | CHAR | 1 | PRENC | ||||
PRENO | Exemption certificate number for legal control | PRENN | CHAR | 8 | PRENN | ||||
PREND | Exemption certificate: Issue date of exemption certificate | PREND | DATS | 8 | PREND | ||||
KTNUM | Quota or Ceiling Number for Import Processing | KTPLN | CHAR | 10 | T610KP | KTPLN | |||
PLNUM | Quota or Ceiling Number for Import Processing | KTPLN | CHAR | 10 | T610KP | KTPLN | |||
POSAR | Item type | POSAR | CHAR | 1 | POSAR | ||||
PSTYV | Sales document item category | PSTYV | CHAR | 4 | Assigned to domain | PSTYV |
Key field | Non-key field |
How do I retrieve data from SAP table EIPO using ABAP code
The following ABAP code Example will allow you to do a basic selection on EIPO to SELECT all data from the tableDATA: WA_EIPO TYPE EIPO.
SELECT SINGLE *
FROM EIPO
INTO CORRESPONDING FIELDS OF WA_EIPO
WHERE...
How to access SAP table EIPO
Within an ECC or HANA version of SAP you can also view further information about EIPO and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects