SAP ABAP Table EIPO (Foreign Trade: Export/Import: Item Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ VEI (Package) Application development R/3 foreign trade

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	EIPO	Table Relationship Diagram
Short Description	Foreign Trade: Export/Import: Item Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	EXNUM	☑	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	EIKP
3	EXPOS	☑	EXPOS	EXPOS	NUMC	6	0	Internal item number for foreign trade data in MM and SD
4	STAWN	☐	STAWN	STAWN	CHAR	17	0	Commodity Code/Import Code Number for Foreign Trade	T604
5	EXPRF	☐	EXPRF	EXPRF	CHAR	8	0	Export/Import Procedure for Foreign Trade	T616
6	EXART	☐	EXART	EXART	CHAR	2	0	Business Transaction Type for Foreign Trade	T605
7	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	T005
8	HERKR	☐	HERKR	REGIO	CHAR	3	0	Region of origin of material (non-preferential origin)	*
9	GRWRT	☐	GRWRT	GRWRT	CURR	13	2	Statistical value for foreign trade
10	PREFPACOD	☐	PREFPACOD	PREFPACOD	CHAR	3	0	Preference code for foreign trade (decl.to author., import)	T604C
11	SEGAL	☐	SEGAL	SEGAL	CHAR	2	0	Exclusion/Inclusion indicator for declara. to authorities	T609A
12	MOWNR	☐	MOWNR	MOWNR	CHAR	12	0	CAP: Number of CAP products list	T618M
13	MOGRU	☐	MOGRU	MOGRU	CHAR	6	0	Common Agricultural Policy: CAP products group-Foreign Trade	T618G
14	GPNUM	☐	GPNUM	GPNUM	CHAR	9	0	Production statistics: PRODCOM number for foreign trade	T609G
15	CASNR	☐	CASNR	CASNR	CHAR	15	0	CAS number for pharmaceutical products in foreign trade	T610C
16	STEUC	☐	STEUC	STEUC	CHAR	16	0	Control code for consumption taxes in foreign trade	T604F
17	WZOLL	☐	WZOLL	GRWRT	CURR	13	2	Customs val. in doc.currency in imp.procg for foreign trade
18	VERLD	☐	VERLD	LAND1	CHAR	3	0	Country of dispatch for Foreign Trade	T005
19	HANLD	☐	HANLD	LAND1	CHAR	3	0	Trading country for foreign trade	T005
20	TEXT1	☐	TXTFT	TEXT40	CHAR	40	0	Comments: Text for foreign trade processing
21	TEXT2	☐	TXTFT	TEXT40	CHAR	40	0	Comments: Text for foreign trade processing
22	TEXT3	☐	TXTFT	TEXT40	CHAR	40	0	Comments: Text for foreign trade processing
23	COKON	☐	COKON	COKON	CHAR	6	0	Customs quota code for import processing in foreign trade	T610K
24	COPHA	☐	COPHA	COPHA	CHAR	6	0	Pharmaceutical products code (Foreign Trade)	T610D
25	COADI	☐	COADI	COADI	CHAR	6	0	Anti-dumping code for import processing in foreign trade	T610A
26	PRONU	☐	PRONU	PRONU	CHAR	25	0	Invoice: Number of invoice document for import processing
27	PRODA	☐	PRODA	DATUM	DATS	8	0	Invoice: Date of invoice document for import processing
28	VORPA	☐	VORPA	VORPA	CHAR	10	0	Preliminary document: Document type for foreign trade procg	T610VA
29	VORNU	☐	VORNU	CHAR25	CHAR	25	0	Preliminary document: No. of preliminary doc.f.import procg
30	VORDA	☐	VORDA	DATUM	DATS	8	0	Preliminary document: Date of preliminary doc.f.import procg
31	BEHOE	☐	VOHOE	BEHOE	CHAR	10	0	Preliminary doc.: Issuing authority of relevant prelim.doc.	T610O
32	KENNU	☐	KENNU	CHAR06	CHAR	6	0	Preliminary document: Customs office/ID number for import
33	VOISO	☐	VOISO	INTCA	CHAR	2	0	Prelim. doc.: ISO code of ctry issuing the preliminary doc.
34	PREFA	☐	PREFA	PREFA	CHAR	10	0	Preference: Preference type for foreign trade	T610PA
35	PREFN	☐	PREFN	CHAR25	CHAR	25	0	Preference: Official number of preference document - Import
36	PREDU	☐	PREDU	DATUM	DATS	8	0	Preference: Date of preference document for import procg
37	PRISO	☐	PRISO	INTCA	CHAR	2	0	Preference: ISO code of country issuing the preference doc.
38	PRHOE	☐	PRHOE	BEHOE	CHAR	10	0	Preference: Issuing authoritiy for relevant preference doc.	T610O
39	PRUEL	☐	PRUEL	DATUM	DATS	8	0	Preference: Validity date of preference document for import
40	NACAR	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	T610NA
41	NACNU	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
42	NACDA	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
43	NAISO	☐	NAISO	INTCA	CHAR	2	0	Verification doc: ISO code of ctry supplying verific.doc.
44	NAHOE	☐	NAHOE	BEHOE	CHAR	10	0	Verification documents: Issuing authority for relev. verif.	T610O
45	NAUEL	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
46	NACA2	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	T610NA
47	NACN2	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
48	NACD2	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
49	NAIS2	☐	NAISO	INTCA	CHAR	2	0	Verification doc: ISO code of ctry supplying verific.doc.
50	NAHO2	☐	NAHOE	BEHOE	CHAR	10	0	Verification documents: Issuing authority for relev. verif.	T610O
51	NAUE2	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
52	NACA3	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	T610NA
53	NACN3	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
54	NACD3	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
55	NAIS3	☐	NAISO	INTCA	CHAR	2	0	Verification doc: ISO code of ctry supplying verific.doc.
56	NAHO3	☐	NAHOE	BEHOE	CHAR	10	0	Verification documents: Issuing authority for relev. verif.	T610O
57	NAUE3	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
58	NACA4	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	T610NA
59	NACN4	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
60	NACD4	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
61	NAIS4	☐	NAISO	INTCA	CHAR	2	0	Verification doc: ISO code of ctry supplying verific.doc.
62	NAHO4	☐	NAHOE	BEHOE	CHAR	10	0	Verification documents: Issuing authority for relev. verif.	T610O
63	NAUE4	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
64	NACA5	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	T610NA
65	NACN5	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
66	NACD5	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
67	NAIS5	☐	NAISO	INTCA	CHAR	2	0	Verification doc: ISO code of ctry supplying verific.doc.
68	NAHO5	☐	NAHOE	BEHOE	CHAR	10	0	Verification documents: Issuing authority for relev. verif.	T610O
69	NAUE5	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
70	EXDAR	☐	EXDAR	VORPA	CHAR	10	0	Export document: Export document type for foreign trade	T610VA
71	EXDAA	☐	EXDAA	CHAR25	CHAR	25	0	Export document: Official number of export document
72	EXDAB	☐	EXDAB	CHAR25	CHAR	25	0	Export document: Valid-to number of export document
73	EXDTA	☐	EXDTA	VORPA	CHAR	10	0	T document: Type of T document for foreign trade	T610VA
74	EXDT2	☐	EXDT2	CHAR25	CHAR	25	0	T document: Official number of T document for foreign trade
75	EXDTB	☐	EXDTB	CHAR25	CHAR	25	0	T doc.: Official no. for next page of T doc. f.foreign trade
76	EXDPA	☐	EXDPA	PREFA	CHAR	10	0	Preference: Preference type for foreign trade	T610PA
77	EXPRE	☐	EXPRE	CHAR25	CHAR	25	0	Preference: Official number of preference document - Export
78	EXDT5	☐	EXDT5	CHAR25	CHAR	25	0	CAP: Official number of T5 document for foreign trade
79	AUSOK	☐	AUSOK	XFELD	CHAR	1	0	Status: Document data in foreign trade complete (system)
80	COIMP	☐	COIMP	STAWN	CHAR	17	0	Code number for import processing in foreign trade	T604
81	HERSE	☐	HERSE	LIFNR	CHAR	10	0	Manufacturer number for import processing in foreign trade	LFA1
82	COBLD	☐	COBLD	STAWN	CHAR	17	0	Import code no. in destination country for foreign trade	T604
83	EIOKW	☐	EIOKW	EIOKW	CHAR	1	0	Status: Complete document data in foreign trade (user)
84	EIOKA	☐	EIOKA	EIOKW	CHAR	1	0	EDI: Export/Import customs tariff number for foreign trade
85	GBNUM	☐	GB_NR	CHAR20	CHAR	20	0	Foreign Trade:Customs declaration list no. for Foreign Trade
86	RGNNR	☐	RG_NR	CHAR20	CHAR	20	0	Registration number for import processing in foreign trade
87	PRENC	☐	PRENC	PRENC	CHAR	1	0	Exemption certificate: Indicator for legal control
88	PRENO	☐	PRENN	PRENN	CHAR	8	0	Exemption certificate number for legal control
89	PREND	☐	PREND	PREND	DATS	8	0	Exemption certificate: Issue date of exemption certificate
90	KTNUM	☐	KTPLN	KTPLN	CHAR	10	0	Quota or Ceiling Number for Import Processing	T610KP
91	PLNUM	☐	KTPLN	KTPLN	CHAR	10	0	Quota or Ceiling Number for Import Processing	T610KP
92	POSAR	☐	POSAR	POSAR	CHAR	1	0	Item type
93	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EIPO	BEHOE	T610O	BEHOE	REF	1	CN
2	EIPO	CASNR	T610C	CASNR	REF	1	CN
3	EIPO	COADI	T610A	COADI	REF	1	CN
4	EIPO	COBLD	T604	STAWN	REF	1	CN
5	EIPO	COIMP	T604	STAWN	REF	1	CN
6	EIPO	COKON	T610K	COKON	REF	1	CN
7	EIPO	COPHA	T610D	COPHA	REF	1	CN
8	EIPO	EXART	T605	EXART	REF	C	CN
9	EIPO	EXDAR	T610VA	VORPA	REF	1	CN
10	EIPO	EXDPA	T610PA	PREFA	REF	1	CN
11	EIPO	EXDTA	T610VA	VORPA	REF	1	CN
12	EIPO	EXNUM	EIKP	EXNUM	KEY	1	CN
13	EIPO	EXPRF	T616	EXPRF	REF	C	CN
14	EIPO	GPNUM	T609G	GPNUM	REF	1	CN
15	EIPO	HANLD	T005	LAND1	REF	1	CN
16	EIPO	HERKL	T005	LAND1	REF	C	CN
17	EIPO	HERSE	LFA1	LIFNR	REF	C	CN
18	EIPO	KTNUM	T610KP	KTPLN		1	CN
19	EIPO	MANDT	T000	MANDT	KEY	1	CN
20	EIPO	MOGRU	T618G	MOGRU	REF	1	CN
21	EIPO	MOWNR	T618M	MOWNR	REF	1	CN
22	EIPO	NACA2	T610NA	NACAR	REF	1	CN
23	EIPO	NACA3	T610NA	NACAR	REF	1	CN
24	EIPO	NACA4	T610NA	NACAR	REF	1	CN
25	EIPO	NACA5	T610NA	NACAR	REF	1	CN
26	EIPO	NACAR	T610NA	NACAR	REF	1	CN
27	EIPO	NAHO2	T610O	BEHOE	REF	1	CN
28	EIPO	NAHO3	T610O	BEHOE	REF	1	CN
29	EIPO	NAHO4	T610O	BEHOE	REF	1	CN
30	EIPO	NAHO5	T610O	BEHOE	REF	1	CN
31	EIPO	NAHOE	T610O	BEHOE	REF	1	CN
32	EIPO	PLNUM	T610KP	KTPLN		1	CN
33	EIPO	PREFA	T610PA	PREFA	REF	1	CN
34	EIPO	PREFPACOD	T604C	PREFPACOD	REF	1	CN
35	EIPO	PRHOE	T610O	BEHOE	REF	1	CN
36	EIPO	SEGAL	T609A	SEGAL	REF	1	CN
37	EIPO	STAWN	T604	STAWN	REF	1	CN
38	EIPO	STEUC	T604F	STEUC	REF	1	CN
39	EIPO	VERLD	T005	LAND1	REF	1	CN
40	EIPO	VORPA	T610VA	VORPA	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in