EIPO

Foreign Trade: Export/Import: Item Data | #itemdata | Component: Cross-Application Components

🔑 Keys (3)
💰 Amounts (2)
∑ Quantities
📅 Dates (15)
☰ Categorical (3)
Other (32)
🔗 Relations (40)

Column Name	Description
MANDT FK	Client
EXNUM FK	Number of foreign trade data in MM and SD documents
EXPOS	Internal item number for foreign trade data in MM and SD

Column Name	Description
💲 Currency of statistical values for foreign trade (EIKP.GRWCU):
GRWRT	Statistical value for foreign trade
💲 Currency of customs values for import procg in foreign trade (EIKP.WZOCU):
WZOLL	Customs val. in doc.currency in imp.procg for foreign trade

Column Name	Description

Column Name	Description
PRODA	Invoice: Date of invoice document for import processing
VORDA	Preliminary document: Date of preliminary doc.f.import procg
PREDU	Preference: Date of preference document for import procg
PRUEL	Preference: Validity date of preference document for import
NACDA	Verification documents: Date of verif.doc. for import procg
NAUEL	Verification docs: Validity date of verific.doc. for import
NACD2	Verification documents: Date of verif.doc. for import procg
NAUE2	Verification docs: Validity date of verific.doc. for import
NACD3	Verification documents: Date of verif.doc. for import procg
NAUE3	Verification docs: Validity date of verific.doc. for import
NACD4	Verification documents: Date of verif.doc. for import procg
NAUE4	Verification docs: Validity date of verific.doc. for import
NACD5	Verification documents: Date of verif.doc. for import procg
NAUE5	Verification docs: Validity date of verific.doc. for import
PREND	Exemption certificate: Issue date of exemption certificate

Column Name	Description
AUSOK	Status: Document data in foreign trade complete (system)	Show values
PRENC	Exemption certificate: Indicator for legal control	Show values
POSAR	Item Type	Show values

Column Name	Description	Domain name
HERKR	Region of Origin of Material (Non-Preferential Origin)	REGIO
TEXT1	Comments: Text for foreign trade processing	TEXT40
TEXT2	Comments: Text for foreign trade processing	TEXT40
TEXT3	Comments: Text for foreign trade processing	TEXT40
PRONU	Invoice: Number of invoice document for import processing	PRONU
VORNU	Number of Previous Document	CHAR25
KENNU	Preliminary document: Customs office/ID number for import	CHAR06
VOISO	Prelim. doc.: ISO code of ctry issuing the preliminary doc.	INTCA
PREFN	Preference: Official number of preference document - Import	CHAR25
PRISO	Preference: ISO code of country issuing the preference doc.	INTCA
NACNU	Verification docs: Official no. of verific. doc. - Import	CHAR25
NAISO	Verification doc: ISO code of ctry supplying verific.doc.	INTCA
NACN2	Verification docs: Official no. of verific. doc. - Import	CHAR25
NAIS2	Verification doc: ISO code of ctry supplying verific.doc.	INTCA
NACN3	Verification docs: Official no. of verific. doc. - Import	CHAR25
NAIS3	Verification doc: ISO code of ctry supplying verific.doc.	INTCA
NACN4	Verification docs: Official no. of verific. doc. - Import	CHAR25
NAIS4	Verification doc: ISO code of ctry supplying verific.doc.	INTCA
NACN5	Verification docs: Official no. of verific. doc. - Import	CHAR25
NAIS5	Verification doc: ISO code of ctry supplying verific.doc.	INTCA
EXDAA	Export document: Official number of export document	CHAR25
EXDAB	Export document: Valid-to number of export document	CHAR25
EXDT2	T document: Official number of T document for foreign trade	CHAR25
EXDTB	T doc.: Official no. for next page of T doc. f.foreign trade	CHAR25
EXPRE	Preference: Official number of preference document - Export	CHAR25
EXDT5	CAP: Official number of T5 document for foreign trade	CHAR25
EIOKW	Status: Complete document data in foreign trade (user)	EIOKW
EIOKA	EDI: Export/Import customs tariff number for foreign trade	EIOKW
GBNUM	Foreign Trade:Customs declaration list no. for Foreign Trade	CHAR20
RGNNR	Registration number for import processing in foreign trade	CHAR20
PRENO	Exemption certificate number for legal control	PRENN
PSTYV	Sales document item category	PSTYV

Master Data Relations	Join Conditions
Check Authorities	`EIPO.MANDT == T610O.MANDT` `EIPO.BEHOE == T610O.BEHOE`
Check CAS Number CAS number for pharmaceutical products in foreign trade ? Client	`EIPO.CASNR == T610C.CASNR` `EIPO.[column in domain "EILAN"] == T610C.LAND1` `EIPO.MANDT == T610C.MANDT`
Check: Anti-dumping Code Anti-dumping code for import processing in foreign trade ?	`EIPO.MANDT == T610A.MANDT` `EIPO.COADI == T610A.COADI` `EIPO.[column in domain "EILAN"] == T610A.EILAN`
Check Code Number for Import in Country of Destination ? Import code no. in destination country for foreign trade Client	`EIPO.[column in domain "LAND1"] == T604.LAND1` `EIPO.COBLD == T604.STAWN` `EIPO.MANDT == T604.MANDT`
Check Code Number ? Code number for import processing in foreign trade Client	`EIPO.[column in domain "LAND1"] == T604.LAND1` `EIPO.COIMP == T604.STAWN` `EIPO.MANDT == T604.MANDT`
Check: Customs Quota Code Customs quota code for import processing in foreign trade Client ?	`EIPO.COKON == T610K.COKON` `EIPO.MANDT == T610K.MANDT` `EIPO.[column in domain "EILAN"] == T610K.EILAN`
Check: Code for Pharmaceutical Products Pharmaceutical products code (Foreign Trade) Client ?	`EIPO.COPHA == T610D.COPHA` `EIPO.MANDT == T610D.MANDT` `EIPO.[column in domain "EILAN"] == T610D.EILAN`
Business Transaction Type ? Client Business Transaction Type	`EIPO.[column in domain "/ECRS/RPCTY"] == T605.LAND1` `EIPO.MANDT == T605.MANDT` `EIPO.EXART == T605.EXART`
Check Type of Export ? Client Export document: Export document type for foreign trade	`EIPO.[column in domain "LAND1"] == T610VA.LAND1` `EIPO.MANDT == T610VA.MANDT` `EIPO.EXDAR == T610VA.VORPA`
Check Type of Preference ? Client Preference: Preference type for foreign trade	`EIPO.[column in domain "EILAN"] == T610PA.EILAN` `EIPO.MANDT == T610PA.MANDT` `EIPO.EXDPA == T610PA.PREFA`
Check Type of T Document ? Client T document: Type of T document for foreign trade	`EIPO.[column in domain "LAND1"] == T610VA.LAND1` `EIPO.MANDT == T610VA.MANDT` `EIPO.EXDTA == T610VA.VORPA`
Procedure ? Procedure Client	`EIPO.[column in domain "/ECRS/RPCTY"] == T616.LAND1` `EIPO.EXPRF == T616.EXPRF` `EIPO.MANDT == T616.MANDT`
Check: PRODCOM Number ? Client Production statistics: PRODCOM number for foreign trade	`EIPO.[column in domain "LAND1"] == T609G.LAND1` `EIPO.MANDT == T609G.MANDT` `EIPO.GPNUM == T609G.GPNUM`
Check Trading Country Trading country for foreign trade Client	`EIPO.HANLD == T005.LAND1` `EIPO.MANDT == T005.MANDT`
Country/Region of Origin of Material (Non-Preferential Ori.) Country/Region of Origin of Material (Non-Preferential Ori.) Client	`EIPO.HERKL == T005.LAND1` `EIPO.MANDT == T005.MANDT`
Foreign Trade: Manufacturer for Anti-dumping	`EIPO.MANDT == LFA1.MANDT` `EIPO.HERSE == LFA1.LIFNR`
Foreign Key Check: Customs Quota Number ? ? Quota or Ceiling Number for Import Processing Client	`EIPO.[column in domain "KTPLV"] == T610KP.KTPLV` `EIPO.[column in domain "EILAN"] == T610KP.EILAN` `EIPO.KTNUM == T610KP.KTPLN` `EIPO.MANDT == T610KP.MANDT`
Client	`EIPO.MANDT == T000.MANDT`
Check EU Market Products Group Number Common Agricultural Policy: CAP products group-Foreign Trade ?	`EIPO.MANDT == T618G.MANDT` `EIPO.MOGRU == T618G.MOGRU` `EIPO.[column in domain "LAND1"] == T618G.LAND1`
Check EU Market Products List Number CAP: Number of CAP products list Client ?	`EIPO.MOWNR == T618M.MOWNR` `EIPO.MANDT == T618M.MANDT` `EIPO.[column in domain "LAND1"] == T618M.LAND1`
Check Verification Document Verification documents: Type of certificate for import Client ?	`EIPO.NACA2 == T610NA.NACAR` `EIPO.MANDT == T610NA.MANDT` `EIPO.[column in domain "LAND1"] == T610NA.LAND1`
Check Verification Documents Verification documents: Type of certificate for import Client ?	`EIPO.NACA3 == T610NA.NACAR` `EIPO.MANDT == T610NA.MANDT` `EIPO.[column in domain "LAND1"] == T610NA.LAND1`
Check Verification Documents Verification documents: Type of certificate for import Client ?	`EIPO.NACA4 == T610NA.NACAR` `EIPO.MANDT == T610NA.MANDT` `EIPO.[column in domain "LAND1"] == T610NA.LAND1`
Check Verification Documents Verification documents: Type of certificate for import Client ?	`EIPO.NACA5 == T610NA.NACAR` `EIPO.MANDT == T610NA.MANDT` `EIPO.[column in domain "LAND1"] == T610NA.LAND1`
Check Verification Documents Verification documents: Type of certificate for import Client ?	`EIPO.NACAR == T610NA.NACAR` `EIPO.MANDT == T610NA.MANDT` `EIPO.[column in domain "LAND1"] == T610NA.LAND1`
Check Authorities	`EIPO.MANDT == T610O.MANDT` `EIPO.NAHO2 == T610O.BEHOE`
Check Authorities	`EIPO.MANDT == T610O.MANDT` `EIPO.NAHO3 == T610O.BEHOE`
Check Authorities	`EIPO.MANDT == T610O.MANDT` `EIPO.NAHO4 == T610O.BEHOE`
Check Authorities	`EIPO.MANDT == T610O.MANDT` `EIPO.NAHO5 == T610O.BEHOE`
Check Authorities	`EIPO.MANDT == T610O.MANDT` `EIPO.NAHOE == T610O.BEHOE`
Foreign Key Check: Customs Ceiling Number ? ? Quota or Ceiling Number for Import Processing Client	`EIPO.[column in domain "KTPLV"] == T610KP.KTPLV` `EIPO.[column in domain "EILAN"] == T610KP.EILAN` `EIPO.PLNUM == T610KP.KTPLN` `EIPO.MANDT == T610KP.MANDT`
Check preference ? Client Preference: Preference type for foreign trade	`EIPO.[column in domain "EILAN"] == T610PA.EILAN` `EIPO.MANDT == T610PA.MANDT` `EIPO.PREFA == T610PA.PREFA`
Foreign Key Preference Code ? Preference code for foreign trade (decl.to author., import)	`EIPO.MANDT == T604C.MANDT` `EIPO.[column in domain "LAND1"] == T604C.LAND1` `EIPO.PREFPACOD == T604C.PREFPACOD`
Check Authorities	`EIPO.MANDT == T610O.MANDT` `EIPO.PRHOE == T610O.BEHOE`
Check Exclusion Indicator for Declarations to Authorities Exclusion/Inclusion indicator for declara. to authorities Client	`EIPO.SEGAL == T609A.SEGAL` `EIPO.MANDT == T609A.MANDT`
Check Commodity Code ? Commodity Code Client	`EIPO.[column in domain "LAND1"] == T604.LAND1` `EIPO.STAWN == T604.STAWN` `EIPO.MANDT == T604.MANDT`
Check: Control Code Control code for consumption taxes in foreign trade Client ?	`EIPO.STEUC == T604F.STEUC` `EIPO.MANDT == T604F.MANDT` `EIPO.[column in domain "LAND1"] == T604F.LAND1`
Check Country of Dispatch Country of dispatch for Foreign Trade Client	`EIPO.VERLD == T005.LAND1` `EIPO.MANDT == T005.MANDT`
Check Preliminary Paper ? Client Type of Previous Document	`EIPO.[column in domain "LAND1"] == T610VA.LAND1` `EIPO.MANDT == T610VA.MANDT` `EIPO.VORPA == T610VA.VORPA`