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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EIKP	ALAND	T005	LAND1	REF	1	CN
2	EIKP	AUSFU	LFA1	LIFNR	REF	C	CN
3	EIKP	AZOLL	T615	ZOLLA	REF	1	CN
4	EIKP	BEHOE	T610O	BEHOE	REF	1	CN
5	EIKP	BFMAR	T612B	BFMAR		1	CN
6	EIKP	EXDAR	T610VA	VORPA	REF	1	CN
7	EIKP	EXDPA	T610PA	PREFA	REF	1	CN
8	EIKP	EXDTA	T610VA	VORPA	REF	1	CN
9	EIKP	EXPVZ	T618	EXPVZ	REF	C	CN
10	EIKP	GRWCU	TCURC	WAERS	REF	C	CN
11	EIKP	IEVER	T618	EXPVZ	REF	1	CN
12	EIKP	LAZL1	T005	LAND1	REF	1	CN
13	EIKP	LAZL2	T005	LAND1	REF	1	CN
14	EIKP	LAZL3	T005	LAND1	REF	1	CN
15	EIKP	LAZL4	T005	LAND1	REF	1	CN
16	EIKP	LAZL5	T005	LAND1	REF	1	CN
17	EIKP	LAZL6	T005	LAND1	REF	1	CN
18	EIKP	MANDT	T000	MANDT	KEY	1	CN
19	EIKP	NACAR	T610NA	NACAR	REF	1	CN
20	EIKP	NAHOE	T610O	BEHOE	REF	1	CN
21	EIKP	PREFA	T610PA	PREFA	REF	1	CN
22	EIKP	PREFPACOD	T604C	PREFPACOD	REF	1	CN
23	EIKP	PRHOE	T610O	BEHOE	REF	1	CN
24	EIKP	SEGAL	T609A	SEGAL	REF	1	CN
25	EIKP	STABE	T005	LAND1	REF	C	CN
26	EIKP	STGBE	T005	LAND1	REF	C	CN
27	EIKP	VORPA	T610VA	VORPA	REF	1	CN
28	EIKP	WZOCU	TCURC	WAERS	REF	1	CN
29	EIKP	ZOLL1	T615	ZOLLA	REF	1	CN
30	EIKP	ZOLL2	T615	ZOLLA	REF	1	CN
31	EIKP	ZOLL3	T615	ZOLLA	REF	1	CN
32	EIKP	ZOLL4	T615	ZOLLA	REF	1	CN
33	EIKP	ZOLL5	T615	ZOLLA	REF	1	CN
34	EIKP	ZOLL6	T615	ZOLLA	REF	1	CN
35	EIKP	ZOLLA	T615	ZOLLA	REF	C	CN
36	EIKP	ZOLLB	T615	ZOLLA	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in