SAP ABAP Table EIKPVB (Foreign Trade: Reference Structure for EIKP 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	EIKPVB	Table Relationship Diagram
Short Description	Foreign Trade: Reference Structure for EIKP 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 Header 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	*
4	ALAND	☐	HLAND	LAND1	CHAR	3	0	Delivering country	T005
5	EXPVZ	☐	EXPVZ	EXPVZ	CHAR	1	0	Mode of Transport for Foreign Trade	T618
6	ZOLLA	☐	DZOLLS	ZOLLS	CHAR	6	0	Customs Office: Office of Exit/Entry for Foreign Trade	T615
7	ZOLLB	☐	DZOLLB	ZOLLS	CHAR	6	0	Customs office: Office of destination for foreign trade	T615
8	ZOLL1	☐	DZOLL1	ZOLLS	CHAR	6	0	Customs office: Customs office 1 for foreign trade	T615
9	ZOLL2	☐	DZOLL2	ZOLLS	CHAR	6	0	Customs office: Customs office 2 for foreign trade	T615
10	ZOLL3	☐	DZOLL3	ZOLLS	CHAR	6	0	Customs office: Customs office 3 for foreign trade	T615
11	ZOLL4	☐	DZOLL4	ZOLLS	CHAR	6	0	Customs office: Customs office 4 for foreign trade	T615
12	ZOLL5	☐	DZOLL5	ZOLLS	CHAR	6	0	Customs office: Customs office 5 for foreign trade	T615
13	ZOLL6	☐	DZOLL6	ZOLLS	CHAR	6	0	Customs office: Customs office 6 for foreign trade	T615
14	KZGBE	☐	KZGBE	KZGBEF	CHAR	30	0	Indicator for means of transport crossing the border
15	KZABE	☐	KZABE	KZABE	CHAR	30	0	Indicator for the means of transport at departure
16	STGBE	☐	STGBE	LAND1	CHAR	3	0	Origin of Means of Transport when Crossing the Border	T005
17	STABE	☐	STABE	LAND1	CHAR	3	0	Country of Origin of the Means of Transport at Departure	T005
18	CONTA	☐	CONTA	CONTA	CHAR	1	0	ID: Goods cross border in a container
19	GRWCU	☐	GRWCU	WAERS	CUKY	5	0	Currency of statistical values for foreign trade	TCURC
20	IEVER	☐	IEVER	EXPVZ	CHAR	1	0	Domestic Mode of Transport for Foreign Trade	T618
21	SEGAL	☐	SEGAL	SEGAL	CHAR	2	0	Exclusion/Inclusion indicator for declara. to authorities	T609A
22	WZOCU	☐	WZOCU	WAERS	CUKY	5	0	Currency of customs values for import procg in foreign trade	TCURC
23	PRONU	☐	PRONU	PRONU	CHAR	25	0	Invoice: Number of invoice document for import processing
24	PRODA	☐	PRODA	DATUM	DATS	8	0	Invoice: Date of invoice document for import processing
25	VORPA	☐	VORPA	VORPA	CHAR	10	0	Preliminary document: Document type for foreign trade procg	T610VA
26	VORDA	☐	VORDA	DATUM	DATS	8	0	Preliminary document: Date of preliminary doc.f.import procg
27	VORNU	☐	VORNU	CHAR25	CHAR	25	0	Preliminary document: No. of preliminary doc.f.import procg
28	BEHOE	☐	VOHOE	BEHOE	CHAR	10	0	Preliminary doc.: Issuing authority of relevant prelim.doc.	T610O
29	KENNU	☐	KENNU	CHAR06	CHAR	6	0	Preliminary document: Customs office/ID number for import
30	VOISO	☐	VOISO	INTCA	CHAR	2	0	Prelim. doc.: ISO code of ctry issuing the preliminary doc.
31	PREFPACOD	☐	PREFPACOD	PREFPACOD	CHAR	3	0	Preference code for foreign trade (decl.to author., import)	T604C
32	PREFA	☐	PREFA	PREFA	CHAR	10	0	Preference: Preference type for foreign trade	T610PA
33	PREFN	☐	PREFN	CHAR25	CHAR	25	0	Preference: Official number of preference document - Import
34	PREDU	☐	PREDU	DATUM	DATS	8	0	Preference: Date of preference document for import procg
35	PRISO	☐	PRISO	INTCA	CHAR	2	0	Preference: ISO code of country issuing the preference doc.
36	PRHOE	☐	PRHOE	BEHOE	CHAR	10	0	Preference: Issuing authoritiy for relevant preference doc.	T610O
37	PRUEL	☐	PRUEL	DATUM	DATS	8	0	Preference: Validity date of preference document for import
38	NACAR	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	T610NA
39	NACNU	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
40	NACDA	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
41	NAISO	☐	NAISO	INTCA	CHAR	2	0	Verification doc: ISO code of ctry supplying verific.doc.
42	NAHOE	☐	NAHOE	BEHOE	CHAR	10	0	Verification documents: Issuing authority for relev. verif.	T610O
43	NAUEL	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
44	TEXT1	☐	TXTFT	TEXT40	CHAR	40	0	Comments: Text for foreign trade processing
45	TEXT2	☐	TXTFT	TEXT40	CHAR	40	0	Comments: Text for foreign trade processing
46	TEXT3	☐	TXTFT	TEXT40	CHAR	40	0	Comments: Text for foreign trade processing
47	EXDAR	☐	EXDAR	VORPA	CHAR	10	0	Export document: Export document type for foreign trade	T610VA
48	EXDAA	☐	EXDAA	CHAR25	CHAR	25	0	Export document: Official number of export document
49	EXDAB	☐	EXDAB	CHAR25	CHAR	25	0	Export document: Valid-to number of export document
50	EXDTA	☐	EXDTA	VORPA	CHAR	10	0	T document: Type of T document for foreign trade	T610VA
51	EXDT2	☐	EXDT2	CHAR25	CHAR	25	0	T document: Official number of T document for foreign trade
52	EXDTB	☐	EXDTB	CHAR25	CHAR	25	0	T doc.: Official no. for next page of T doc. f.foreign trade
53	EXDPA	☐	EXDPA	PREFA	CHAR	10	0	Preference: Preference type for foreign trade	T610PA
54	EXPRE	☐	EXPRE	CHAR25	CHAR	25	0	Preference: Official number of preference document - Export
55	EXDT5	☐	EXDT5	CHAR25	CHAR	25	0	CAP: Official number of T5 document for foreign trade
56	LADEL	☐	LADEL	LADEL	CHAR	40	0	Place of loading/unloading for foreign trade
57	AUSFU	☐	AUSFU	LIFNR	CHAR	10	0	Exporter for import processing in foreign trade	LFA1
58	EIOKW	☐	EIOKW	EIOKW	CHAR	1	0	Status: Complete document data in foreign trade (user)
59	AUSOK	☐	AUSOK	XFELD	CHAR	1	0	Status: Document data in foreign trade complete (system)
60	LAZL1	☐	LAZLS	LAND1	CHAR	3	0	Customs office: Country of customs office for foreign trade	T005
61	LAZL2	☐	LAZLS	LAND1	CHAR	3	0	Customs office: Country of customs office for foreign trade	T005
62	LAZL3	☐	LAZLS	LAND1	CHAR	3	0	Customs office: Country of customs office for foreign trade	T005
63	LAZL4	☐	LAZLS	LAND1	CHAR	3	0	Customs office: Country of customs office for foreign trade	T005
64	LAZL5	☐	LAZLS	LAND1	CHAR	3	0	Customs office: Country of customs office for foreign trade	T005
65	LAZL6	☐	LAZLS	LAND1	CHAR	3	0	Customs office: Country of customs office for foreign trade	T005
66	AZOLL	☐	AZOLL	ZOLLS	CHAR	6	0	Customs office: Export customs office for foreign trade	T615
67	AHBAS	☐	AHBAS	AHBAS	CHAR	3	0	Basis document category for foreign trade processing
68	REFNR	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
69	MABSD	☐	MABSD	DATUM	DATS	8	0	Selection date for periodic declarations
70	BFMAR	☐	BFMAR	BFMAR	CHAR	6	0	Foreign Trade: Type of means of transport	T612B
71	CUDCL	☐	CUDCL	CUDCL	CHAR	3	0	Customs declaration type for customs processing in FT
72	.INCLUDE	☐				0	0	Table for Update Indicators
73	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	EIKPVB	ALAND	T005	LAND1
2	EIKPVB	AUSFU	LFA1	LIFNR	REF	C	CN
3	EIKPVB	AZOLL	T615	ZOLLA	REF	1	CN
4	EIKPVB	BEHOE	T610O	BEHOE	REF	1	CN
5	EIKPVB	BFMAR	T612B	BFMAR		1	CN
6	EIKPVB	EXDAR	T610VA	VORPA	REF	1	CN
7	EIKPVB	EXDPA	T610PA	PREFA	REF	1	CN
8	EIKPVB	EXDTA	T610VA	VORPA	REF	1	CN
9	EIKPVB	EXPVZ	T618	EXPVZ
10	EIKPVB	GRWCU	TCURC	WAERS
11	EIKPVB	IEVER	T618	EXPVZ	REF	1	CN
12	EIKPVB	LAZL1	T005	LAND1	REF	1	CN
13	EIKPVB	LAZL2	T005	LAND1	REF	1	CN
14	EIKPVB	LAZL3	T005	LAND1	REF	1	CN
15	EIKPVB	LAZL4	T005	LAND1	REF	1	CN
16	EIKPVB	LAZL5	T005	LAND1	REF	1	CN
17	EIKPVB	LAZL6	T005	LAND1	REF	1	CN
18	EIKPVB	MANDT	T000	MANDT
19	EIKPVB	NACAR	T610NA	NACAR	REF	1	CN
20	EIKPVB	NAHOE	T610O	BEHOE	REF	1	CN
21	EIKPVB	PREFA	T610PA	PREFA	REF	1	CN
22	EIKPVB	PREFPACOD	T604C	PREFPACOD	REF	1	CN
23	EIKPVB	PRHOE	T610O	BEHOE	REF	1	CN
24	EIKPVB	SEGAL	T609A	SEGAL	REF	1	CN
25	EIKPVB	STABE	T005	LAND1
26	EIKPVB	STGBE	T005	LAND1
27	EIKPVB	VORPA	T610VA	VORPA	REF	1	CN
28	EIKPVB	WZOCU	TCURC	WAERS	REF	1	CN
29	EIKPVB	ZOLL1	T615	ZOLLA	REF	1	CN
30	EIKPVB	ZOLL2	T615	ZOLLA	REF	1	CN
31	EIKPVB	ZOLL3	T615	ZOLLA	REF	1	CN
32	EIKPVB	ZOLL4	T615	ZOLLA	REF	1	CN
33	EIKPVB	ZOLL5	T615	ZOLLA	REF	1	CN
34	EIKPVB	ZOLL6	T615	ZOLLA	REF	1	CN
35	EIKPVB	ZOLLA	T615	ZOLLA
36	EIKPVB	ZOLLB	T615	ZOLLA	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in