SAP table BAPIFOREIGNTRADEHDR (BAPI Structure Foreign Trade Analog EIKP)

SAP table BAPIFOREIGNTRADEHDR has 2 primary key fields being MANDT,EXNUM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
EXNUM Number of foreign trade data in MM and SD documents CHAR 10 0 * EXNUM
ALAND Delivering country CHAR 3 0 * HLAND
EXPVZ Mode of Transport at the Border (Intrastat) CHAR 1 0 * EXPVZ
ZOLLA Customs Office: Office of Exit/Entry for Foreign Trade CHAR 6 0 * DZOLLS
ZOLLB Customs office: Office of destination for foreign trade CHAR 6 0 * DZOLLB
ZOLL1 Customs office: Customs office 1 for foreign trade CHAR 6 0 * DZOLL1
ZOLL2 Customs office: Customs office 2 for foreign trade CHAR 6 0 * DZOLL2
ZOLL3 Customs office: Customs office 3 for foreign trade CHAR 6 0 * DZOLL3
ZOLL4 Customs office: Customs office 4 for foreign trade CHAR 6 0 * DZOLL4
ZOLL5 Customs office: Customs office 5 for foreign trade CHAR 6 0 * DZOLL5
ZOLL6 Customs office: Customs office 6 for foreign trade CHAR 6 0 * DZOLL6
KZGBE Identifier for Means of Transport crossing the Border CHAR 30 0 KZGBE
KZABE Identification for the Means of Transport Inland CHAR 30 0 KZABE
STGBE Origin of Means of Transport when Crossing the Border CHAR 3 0 * STGBE
STABE Country of Origin of the Means of Transport at Departure CHAR 3 0 * STABE
CONTA ID: Goods cross border in a container CHAR 1 0 CONTA
0 Goods do not cross the border in a container
1 Goods cross the border in a container
GRWCU Currency of statistical values for foreign trade CUKY 5 0 * GRWCU
IEVER Domestic Mode of Transport for Foreign Trade CHAR 1 0 * IEVER
SEGAL Exclusion/Inclusion indicator for declara. to authorities CHAR 2 0 * SEGAL
WZOCU Currency of customs values for import procg in foreign trade CUKY 5 0 * WZOCU
PRONU Invoice: Number of invoice document for import processing CHAR 25 0 PRONU
PRODA Invoice: Date of invoice document for import processing DATS 8 0 PRODA
VORPA Type of Previous Document CHAR 10 0 * VORPA
VORDA Preliminary document: Date of preliminary doc.f.import procg DATS 8 0 VORDA
VORNU Number of Previous Document CHAR 25 0 VORNU
BEHOE Preliminary doc.: Issuing authority of relevant prelim.doc. CHAR 10 0 * VOHOE
KENNU Preliminary document: Customs office/ID number for import CHAR 6 0 KENNU
VOISO Prelim. doc.: ISO code of ctry issuing the preliminary doc. CHAR 2 0 VOISO
PREFPACOD Preference code for foreign trade (decl.to author., import) CHAR 3 0 * PREFPACOD
PREFA Preference: Preference type for foreign trade CHAR 10 0 * PREFA
PREFN Preference: Official number of preference document - Import CHAR 25 0 PREFN
PREDU Preference: Date of preference document for import procg DATS 8 0 PREDU
PRISO Preference: ISO code of country issuing the preference doc. CHAR 2 0 PRISO
PRHOE Preference: Issuing authoritiy for relevant preference doc. CHAR 10 0 * PRHOE
PRUEL Preference: Validity date of preference document for import DATS 8 0 PRUEL
NACAR Verification documents: Type of certificate for import CHAR 10 0 * NACAR
NACNU Verification docs: Official no. of verific. doc. - Import CHAR 25 0 NACNU
NACDA Verification documents: Date of verif.doc. for import procg DATS 8 0 NACDA
NAISO Verification doc: ISO code of ctry supplying verific.doc. CHAR 2 0 NAISO
NAHOE Verification documents: Issuing authority for relev. verif. CHAR 10 0 * NAHOE
NAUEL Verification docs: Validity date of verific.doc. for import DATS 8 0 NAUEL
TEXT1 Comments: Text for foreign trade processing CHAR 40 0 TXTFT
TEXT2 Comments: Text for foreign trade processing CHAR 40 0 TXTFT
TEXT3 Comments: Text for foreign trade processing CHAR 40 0 TXTFT
EXDAR Export document: Export document type for foreign trade CHAR 10 0 * EXDAR
EXDAA Export document: Official number of export document CHAR 25 0 EXDAA
EXDAB Export document: Valid-to number of export document CHAR 25 0 EXDAB
EXDTA T document: Type of T document for foreign trade CHAR 10 0 * EXDTA
EXDT2 T document: Official number of T document for foreign trade CHAR 25 0 EXDT2
EXDTB T doc.: Official no. for next page of T doc. f.foreign trade CHAR 25 0 EXDTB
EXDPA Preference: Preference type for foreign trade CHAR 10 0 * EXDPA
EXPRE Preference: Official number of preference document - Export CHAR 25 0 EXPRE
EXDT5 CAP: Official number of T5 document for foreign trade CHAR 25 0 EXDT5
LADEL Place of loading/unloading for foreign trade CHAR 40 0 LADEL
AUSFU Exporter for import processing in foreign trade CHAR 10 0 * AUSFU
EIOKW Status: Complete document data in foreign trade (user) CHAR 1 0 EIOKW
AUSOK Status: Document data in foreign trade complete (system) CHAR 1 0 AUSOK
LAZL1 Customs office: Country of customs office for foreign trade CHAR 3 0 * LAZLS
LAZL2 Customs office: Country of customs office for foreign trade CHAR 3 0 * LAZLS
LAZL3 Customs office: Country of customs office for foreign trade CHAR 3 0 * LAZLS
LAZL4 Customs office: Country of customs office for foreign trade CHAR 3 0 * LAZLS
LAZL5 Customs office: Country of customs office for foreign trade CHAR 3 0 * LAZLS
LAZL6 Customs office: Country of customs office for foreign trade CHAR 3 0 * LAZLS
AZOLL Customs office: Export customs office for foreign trade CHAR 6 0 * AZOLL
AHBAS Basis document category for foreign trade processing CHAR 3 0 AHBAS
1AH Receipt / Import: Foreign Trade document - Import
1BE Receipt/Import: Purchase Order Document
1LA Receipt/Import: Inbound Delivery
1LI Receipt/Import: Vendor Master
1WE Receipt/Import: Goods Receipt Document
2AH Dispatch / Export: Foreign Trade Document - Export
2FA Dispatch/Export: Billing Document
2KU Dispatch/Export: Customer Master
2LI Dispatch/Export: Outbound Delivery Document
2VA Dispatch/Export: Sales Document
REFNR Sales and Distribution Document Number CHAR 10 0 * VBELN
MABSD Selection Date for Periodic Declarations DATS 8 0 MABSD
BFMAR Foreign Trade: Type of means of transport CHAR 6 0 * BFMAR
CUDCL Customs declaration type for customs processing in FT CHAR 3 0 CUDCL