SAP ABAP Table EIPOVB (Foreign Trade: Reference Structure for EIPO and Dynamic Part)

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	INTTAB	Structure
Structure	EIPOVB	Table Relationship Diagram
Short Description	Foreign Trade: Reference Structure for EIPO and Dynamic Part

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in