EIPO SAP table for – Foreign Trade: Export/Import: Item Data

Here we would like to draw your attention to EIPO table in SAP. As we know it is being mainly used with the SAP SD-FT (Foreign Trade in SD) component which is coming under SD module (Sales & Distribution). EIPO is a SAP standard transparent table used for storing Foreign Trade: Export/Import: Item Data related data in SAP. It comes under the package VEI.

SAP EIPO table

Table EIPO technical data

TableEIPO
Data storingForeign Trade: Export/Import: Item Data
ModuleSD
ComponentSD-FT
SAP PackageVEI
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP EIPO Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in EIPO table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • SEGAL
    Its data type is C (Character String) with field length 2
  • MOGRU : Common Agricultural Policy: CAP products group-Foreign Trade
    Its data type is C (Character String) with field length 6
  • CASNR : CAS number for pharmaceutical products in foreign trade
    Its data type is C (Character String) with field length 15
  • WZOLL
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • HANLD
    Its data type is C (Character String) with field length 3
  • TEXT2
    Its data type is C (Character String) with field length 40
  • COKON : Customs quota code for import processing in foreign trade
    Its data type is C (Character String) with field length 6
  • COADI : Anti-dumping code for import processing in foreign trade
    Its data type is C (Character String) with field length 6
  • VORPA
    Its data type is C (Character String) with field length 10
  • VORNU
    Its data type is C (Character String) with field length 25
  • EXPOS
    Its a key field. Its data type is N (Character String with Digits Only) with field length 6
  • BEHOE
    Its data type is C (Character String) with field length 10
  • VOISO
    Its data type is C (Character String) with field length 2
  • PREFN
    Its data type is C (Character String) with field length 25
  • PRISO
    Its data type is C (Character String) with field length 2
  • NACAR
    Its data type is C (Character String) with field length 10
  • NACDA
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • NAHOE
    Its data type is C (Character String) with field length 10
  • NACA2
    Its data type is C (Character String) with field length 10
  • NACN2
    Its data type is C (Character String) with field length 25
  • NAIS2
    Its data type is C (Character String) with field length 2
  • EXPRF : Export/Import Procedure for Foreign Trade
    Its data type is C (Character String) with field length 8
  • NAUE2
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • NACN3
    Its data type is C (Character String) with field length 25
  • NAIS3
    Its data type is C (Character String) with field length 2
  • NAUE3
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • NACN4
    Its data type is C (Character String) with field length 25
  • NAIS4
    Its data type is C (Character String) with field length 2
  • NAUE4
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • NACN5
    Its data type is C (Character String) with field length 25
  • NAIS5
    Its data type is C (Character String) with field length 2
  • NAUE5
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • HERKL : Country of origin of the material
    Its data type is C (Character String) with field length 3
  • EXDAA
    Its data type is C (Character String) with field length 25
  • EXDTA
    Its data type is C (Character String) with field length 10
  • EXDTB
    Its data type is C (Character String) with field length 25
  • EXPRE
    Its data type is C (Character String) with field length 25
  • AUSOK
    Its data type is C (Character String) with field length 1
  • HERSE : Manufacturer number for import processing in foreign trade
    Its data type is C (Character String) with field length 10
  • EIOKW
    Its data type is C (Character String) with field length 1
  • GBNUM
    Its data type is C (Character String) with field length 20
  • PRENC
    Its data type is C (Character String) with field length 1
  • PREND
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • GRWRT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • PLNUM : Quota or Ceiling Number for Import Processing
    Its data type is C (Character String) with field length 10
  • PSTYV
    Its data type is C (Character String) with field length 4