SAP table EIZO (FT: Exp/Imp ident. of goods, pres. of goods for cust.declar.)
SAP table EIZO has 5 primary key fields being MANDT,EXNUM,EXPOS,QUACU,LAUNR.
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
EIKP
EXNUM
EXPOS
Internal item number for foreign trade data in MM and SD
NUMC
6
0
EIPO
EXPOS
QUACU
Qualifier customs declaration for Foreign Trade processing
CHAR
5
0
QUACU
Possible values
CUAWB
Airway Bill
CUBLD
Bill of Lading
CUCNT
Container
CUENT
ID number
CUINV
Invoice
CUMAS
Weight / Mass of shipment
CUPAC
Packages
LAUNR
Sequential number for legal control
NUMC
5
0
LAUNR
VORPA
Type of Previous Document
CHAR
10
0
T610VA
VORPA
CUENT
Type of Goods Identity Seal in Foreign Trade/Customs
CHAR
5
0
T612N
CUENT
CUPAR
Package type for electr. procedures in Foreign Trade
CHAR
4
0
T612P
CUPAR
CUSNU
No. for customs declaration for customs processing in FT
CHAR
50
0
CUSNU
CUSDA
Date for customs declaration for customs processing in FT
DATS
8
0
CUSDA
CUTXT
Customs description for customs processing in Foreign Trade
CHAR
60
0
CUTXT
CUSAZ
Number for customs processing in Foreign Trade
DEC
4
0
CUSAZ
CUNTG
Net weight
QUAN
15
3
NTGEW_15
CUBRG
Gross weight
QUAN
15
3
BRGEW_15
CUGWE
Weight Unit
UNIT
3
0
T006
GEWEI
EIZO foreign key relationships
Table
Field
Check Table
Check Field
0 EIZO
CUENT
T612N
FT/Customs: Electr. procedures: Type of identity of goods
MANDT
0 EIZO
CUENT
T612N
FT/Customs: Electr. procedures: Type of identity of goods
EILAN
1 EIZO
CUGWE
T006
Units of Measurement
MANDT
0 EIZO
CUPAR
T612P
FT/Customs: Electr. Procedure: Type of Shipping Unit
MANDT
0 EIZO
CUPAR
T612P
FT/Customs: Electr. Procedure: Type of Shipping Unit
EILAN
0 EIZO
CUPAR
T612P
FT/Customs: Electr. Procedure: Type of Shipping Unit
CUPAR
1 EIZO
EXNUM
EIKP
Foreign Trade: Export/Import Header Data
EXNUM
0 EIZO
EXPOS
EIPO
Foreign Trade: Export/Import: Item Data
EXNUM
0 EIZO
EXPOS
EIPO
Foreign Trade: Export/Import: Item Data
EXPOS
1 EIZO
MANDT
T000
Clients
MANDT
0 EIZO
VORPA
T610VA
Foreign Trade: Preliminary Import Docs / Export Docs
LAND1
0 EIZO
VORPA
T610VA
Foreign Trade: Preliminary Import Docs / Export Docs
VORPA