1. Home
  2. Resources
  3. SAP Tables
  4. VBDPRE - Foreign Trade: Item Data for Billing View

SAP Table VBDPRE

Foreign Trade: Item Data for Billing View

VBDPRE (Foreign Trade: Item Data for Billing View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VBDPRE to other SAP tables.

VBDPRE table fields

Field Data element Checktable Datatype Length Decimals
EXNUM Number of foreign trade data in MM and SD documents EXNUM CHAR 10 0
EXPOS Internal item number for foreign trade data in MM and SD EXPOS NUMC 6 0
STAWN Commodity Code/Import Code Number for Foreign Trade STAWN CHAR 17 0
EXPRF Export/Import Procedure for Foreign Trade EXPRF CHAR 8 0
EXART Business Transaction Type for Foreign Trade EXART CHAR 2 0
HERKL Country of origin of the material HERKL CHAR 3 0
HERKR Region of origin of material (non-preferential origin) HERKR CHAR 3 0
GRWRT Statistical value for foreign trade GRWRT CURR 13 2
HERTI Country Name LANDX CHAR 15 0
HERTA Departure country (country from which the goods are sent) ALAND CHAR 3 0
STXT1 Description of commodity code - First line STXT1 CHAR 40 0
STXT2 Description of commodity code - Second line STXT2 CHAR 40 0
STXT3 Description of commodity code - Third line STXT3 CHAR 40 0
STXT4 Description of commodity code - Fourth line STXT4 CHAR 40 0
STXT5 Description of commodity code - Fifth line STXT5 CHAR 40 0
STXT6 Description of commodity code - Sixth line STXT6 CHAR 40 0
STXT7 Description of commodity code - Seventh line STXT7 CHAR 40 0
BEMAS Supplementary unit BEMEH UNIT 3 0
PREFE Preference indicator in export/import PREFE CHAR 1 0
A Not checked
B Checked - price influenced
C Generally allowed
D Generally not allowed
E Authorized for preference: set manually
F Not authorized for preference: component of mixed origins
BOLNR Bill of lading BOLNR CHAR 35 0
TRATY Means-of-Transport Type TRATY CHAR 4 0
TRAID Means of Transport ID TRAID CHAR 20 0
HERBL State of manufacture HERBL CHAR 2 0
BMGEW Net Weight NTGEW QUAN 13 3
MOWNR CAP: Number of CAP products list MOWNR CHAR 12 0
GPNUM Production statistics: PRODCOM number for foreign trade GPNUM CHAR 9 0
CASNR CAS number for pharmaceutical products in foreign trade CASNR CHAR 15 0
STEUC Control code for consumption taxes in foreign trade STEUC CHAR 16 0
WZOLL Customs val. in doc.currency in imp.procg for foreign trade WZOLL CURR 13 2
VERLD Country of dispatch for Foreign Trade VERLD CHAR 3 0
HANLD Trading country for foreign trade HANLD CHAR 3 0
TEXT1 Description BEZEI40 CHAR 40 0
TEXT2 Description BEZEI40 CHAR 40 0
TEXT3 Description BEZEI40 CHAR 40 0
COKON Customs quota code for import processing in foreign trade COKON CHAR 6 0
COPHA Pharmaceutical products code (Foreign Trade) COPHA CHAR 6 0
COADI Anti-dumping code for import processing in foreign trade COADI CHAR 6 0
PRONU Invoice: Number of invoice document for import processing PRONU CHAR 25 0
PRODA Invoice: Date of invoice document for import processing PRODA DATS 8 0
VORPA Preliminary document: Document type for foreign trade procg VORPA CHAR 10 0
VORNU Preliminary document: No. of preliminary doc.f.import procg VORNU CHAR 25 0
VORDA Preliminary document: Date of preliminary doc.f.import procg VORDA DATS 8 0
BEHOE Issuing authority for relevant Foreign Trade document BEHOE CHAR 10 0
KENNU Preliminary document: Customs office/ID number for import KENNU CHAR 6 0
VOISO Prelim. doc.: ISO code of ctry issuing the preliminary doc. VOISO CHAR 2 0
PREFA Preference: Preference type for foreign trade PREFA CHAR 10 0
PREFN Preference: Official number of preference document - Import PREFN CHAR 25 0
PREDU Preference: Date of preference document for import procg PREDU DATS 8 0
PRISO Preference: ISO code of country issuing the preference doc. PRISO CHAR 2 0
PRHOE Issuing authority for relevant Foreign Trade document BEHOE CHAR 10 0
PRUEL Preference: Validity date of preference document for import PRUEL DATS 8 0
NACAR Verification documents: Type of certificate for import NACAR CHAR 10 0
NACNU Verification docs: Official no. of verific. doc. - Import NACNU CHAR 25 0
NACDA Verification documents: Date of verif.doc. for import procg NACDA DATS 8 0
NAISO Verification doc: ISO code of ctry supplying verific.doc. NAISO CHAR 2 0
NAHOE Issuing authority for relevant Foreign Trade document BEHOE CHAR 10 0
NAUEL Verification docs: Validity date of verific.doc. for import NAUEL DATS 8 0
NACA2 Verification documents: Type of certificate for import NACAR CHAR 10 0
NACN2 Verification docs: Official no. of verific. doc. - Import NACNU CHAR 25 0
NACD2 Verification documents: Date of verif.doc. for import procg NACDA DATS 8 0
NAIS2 Preference: ISO code of country issuing the preference doc. PRISO CHAR 2 0
NAHO2 Issuing authority for relevant Foreign Trade document BEHOE CHAR 10 0
NAUE2 Verification docs: Validity date of verific.doc. for import NAUEL DATS 8 0
NACA3 Verification documents: Type of certificate for import NACAR CHAR 10 0
NACN3 Verification docs: Official no. of verific. doc. - Import NACNU CHAR 25 0
NACD3 Verification documents: Date of verif.doc. for import procg NACDA DATS 8 0
NAIS3 Verification doc: ISO code of ctry supplying verific.doc. NAISO CHAR 2 0
NAHO3 Issuing authority for relevant Foreign Trade document BEHOE CHAR 10 0
NAUE3 Verification docs: Validity date of verific.doc. for import NAUEL DATS 8 0
NACA4 Verification documents: Type of certificate for import NACAR CHAR 10 0
NACN4 Verification docs: Official no. of verific. doc. - Import NACNU CHAR 25 0
NACD4 Verification documents: Date of verif.doc. for import procg NACDA DATS 8 0
NAIS4 Verification doc: ISO code of ctry supplying verific.doc. NAISO CHAR 2 0
NAHO4 Issuing authority for relevant Foreign Trade document BEHOE CHAR 10 0
NAUE4 Verification docs: Validity date of verific.doc. for import NAUEL DATS 8 0
NACA5 Verification documents: Type of certificate for import NACAR CHAR 10 0
NACN5 Verification docs: Official no. of verific. doc. - Import NACNU CHAR 25 0
NACD5 Verification documents: Date of verif.doc. for import procg NACDA DATS 8 0
NAIS5 Verification doc: ISO code of ctry supplying verific.doc. NAISO CHAR 2 0
NAHO5 Issuing authority for relevant Foreign Trade document BEHOE CHAR 10 0
NAUE5 Verification docs: Validity date of verific.doc. for import NAUEL DATS 8 0
EXDAR Export document: Export document type for foreign trade EXDAR CHAR 10 0
EXDAA Export document: Official number of export document EXDAA CHAR 25 0
EXDAB Export document: Valid-to number of export document EXDAB CHAR 25 0
EXDTA T document: Type of T document for foreign trade EXDTA CHAR 10 0
EXDT2 T document: Official number of T document for foreign trade EXDT2 CHAR 25 0
EXDTB T doc.: Official no. for next page of T doc. f.foreign trade EXDTB CHAR 25 0
EXDPA Preference: Preference type for foreign trade EXDPA CHAR 10 0
EXPRE Preference: Official number of preference document - Export EXPRE CHAR 25 0
EXDT5 CAP: Official number of T5 document for foreign trade EXDT5 CHAR 25 0
COIMP Code number for import processing in foreign trade COIMP CHAR 17 0
GBNUM Foreign Trade:Customs declaration list no. for Foreign Trade GB_NR CHAR 20 0
REGNR Registration number for import processing in foreign trade RG_NR CHAR 20 0
PRENC Exemption certificate: Indicator for legal control PRENC CHAR 1 0
NULL Not Relevant
A Applied for
B Accepted
C Request Rejected
PRENO Exemption certificate number for legal control PRENN CHAR 8 0
PREND Exemption certificate: Issue date of exemption certificate PREND DATS 8 0
WKREG Region in which plant is located WKREG CHAR 3 0
IMPMA Second unit of measurement IMPMA UNIT 3 0
IMGEW Net Weight NTGEW QUAN 13 3