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 | Possible values | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||