VBDPRE SAP (Foreign Trade: Item Data for Billing View) Structure details
Description: Foreign Trade: Item Data for Billing View
Structure field list including key, data, relationships and ABAP select examples
VBDPRE is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Foreign Trade: Item Data for Billing View" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_VBDPRE TYPE VBDPRE.
The VBDPRE table consists of various fields, each holding specific information or linking keys about Foreign Trade: Item Data for Billing View data available in SAP. These include EXPOS (Internal item number for foreign trade data in MM and SD), STAWN (Commodity Code/Import Code Number for Foreign Trade), EXPRF (Export/Import Procedure for Foreign Trade), EXART (Business Transaction Type for Foreign Trade).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VBDPRE structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
EXNUM | Number of foreign trade data in MM and SD documents | EXNUM | CHAR | 10 | Assigned to domain | EXNUM | |||
EXPOS | Internal item number for foreign trade data in MM and SD | EXPOS | NUMC | 6 | EXPOS | ||||
STAWN | Commodity Code/Import Code Number for Foreign Trade | STAWN | CHAR | 17 | Assigned to domain | STAWN | |||
EXPRF | Export/Import Procedure for Foreign Trade | EXPRF | CHAR | 8 | Assigned to domain | EXPRF | |||
EXART | Business Transaction Type for Foreign Trade | EXART | CHAR | 2 | Assigned to domain | EXART | EXA | ||
HERKL | Country of origin of the material | HERKL | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
HERKR | Region of origin of material (non-preferential origin) | HERKR | CHAR | 3 | Assigned to domain | REGIO | |||
GRWRT | Statistical value for foreign trade | GRWRT | CURR | 13(2) | GRWRT | ||||
HERTI | Country Name | LANDX | CHAR | 15 | TEXT15 | ||||
HERTA | Departure country (country from which the goods are sent) | ALAND | CHAR | 3 | Assigned to domain | LAND1 | VAL | ||
STXT1 | Description of commodity code - First line | STXT1 | CHAR | 40 | CHAR40 | ||||
STXT2 | Description of commodity code - Second line | STXT2 | CHAR | 40 | CHAR40 | ||||
STXT3 | Description of commodity code - Third line | STXT3 | CHAR | 40 | CHAR40 | ||||
STXT4 | Description of commodity code - Fourth line | STXT4 | CHAR | 40 | CHAR40 | ||||
STXT5 | Description of commodity code - Fifth line | STXT5 | CHAR | 40 | CHAR40 | ||||
STXT6 | Description of commodity code - Sixth line | STXT6 | CHAR | 40 | CHAR40 | ||||
STXT7 | Description of commodity code - Seventh line | STXT7 | CHAR | 40 | CHAR40 | ||||
BEMAS | Supplementary unit | BEMEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PREFE | Preference indicator in export/import | PREFE | CHAR | 1 | PREFE | ||||
BOLNR | Bill of lading | BOLNR | CHAR | 35 | CHAR35 | ||||
TRATY | Means-of-Transport Type | TRATY | CHAR | 4 | Assigned to domain | TRATY | |||
TRAID | Means of Transport ID | TRAID | CHAR | 20 | TRAID | ||||
HERBL | State of manufacture | HERBL | CHAR | 2 | HERBL | ||||
BMGEW | Net Weight | NTGEW | QUAN | 13(3) | MENG13 | ||||
MOWNR | CAP: Number of CAP products list | MOWNR | CHAR | 12 | Assigned to domain | MOWNR | |||
GPNUM | Production statistics: PRODCOM number for foreign trade | GPNUM | CHAR | 9 | Assigned to domain | GPNUM | |||
CASNR | CAS number for pharmaceutical products in foreign trade | CASNR | CHAR | 15 | Assigned to domain | CASNR | |||
STEUC | Control code for consumption taxes in foreign trade | STEUC | CHAR | 16 | Assigned to domain | STEUC | |||
WZOLL | Customs val. in doc.currency in imp.procg for foreign trade | WZOLL | CURR | 13(2) | GRWRT | ||||
VERLD | Country of dispatch for Foreign Trade | VERLD | CHAR | 3 | Assigned to domain | LAND1 | |||
HANLD | Trading country for foreign trade | HANLD | CHAR | 3 | Assigned to domain | LAND1 | |||
TEXT1 | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
TEXT2 | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
TEXT3 | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
COKON | Customs quota code for import processing in foreign trade | COKON | CHAR | 6 | Assigned to domain | COKON | |||
COPHA | Pharmaceutical products code (Foreign Trade) | COPHA | CHAR | 6 | Assigned to domain | COPHA | |||
COADI | Anti-dumping code for import processing in foreign trade | COADI | CHAR | 6 | Assigned to domain | COADI | |||
PRONU | Invoice: Number of invoice document for import processing | PRONU | CHAR | 25 | PRONU | ||||
PRODA | Invoice: Date of invoice document for import processing | PRODA | DATS | 8 | DATUM | ||||
VORPA | Preliminary document: Document type for foreign trade procg | VORPA | CHAR | 10 | Assigned to domain | VORPA | |||
VORNU | Preliminary document: No. of preliminary doc.f.import procg | VORNU | CHAR | 25 | CHAR25 | ||||
VORDA | Preliminary document: Date of preliminary doc.f.import procg | VORDA | DATS | 8 | DATUM | ||||
BEHOE | Issuing authority for relevant Foreign Trade document | BEHOE | CHAR | 10 | Assigned to domain | BEHOE | |||
KENNU | Preliminary document: Customs office/ID number for import | KENNU | CHAR | 6 | CHAR06 | ||||
VOISO | Prelim. doc.: ISO code of ctry issuing the preliminary doc. | VOISO | CHAR | 2 | INTCA | ||||
PREFA | Preference: Preference type for foreign trade | PREFA | CHAR | 10 | Assigned to domain | PREFA | |||
PREFN | Preference: Official number of preference document - Import | PREFN | CHAR | 25 | CHAR25 | ||||
PREDU | Preference: Date of preference document for import procg | PREDU | DATS | 8 | DATUM | ||||
PRISO | Preference: ISO code of country issuing the preference doc. | PRISO | CHAR | 2 | INTCA | ||||
PRHOE | Issuing authority for relevant Foreign Trade document | BEHOE | CHAR | 10 | Assigned to domain | BEHOE | |||
PRUEL | Preference: Validity date of preference document for import | PRUEL | DATS | 8 | DATUM | ||||
NACAR | Verification documents: Type of certificate for import | NACAR | CHAR | 10 | Assigned to domain | NACAR | |||
NACNU | Verification docs: Official no. of verific. doc. - Import | NACNU | CHAR | 25 | CHAR25 | ||||
NACDA | Verification documents: Date of verif.doc. for import procg | NACDA | DATS | 8 | DATUM | ||||
NAISO | Verification doc: ISO code of ctry supplying verific.doc. | NAISO | CHAR | 2 | INTCA | ||||
NAHOE | Issuing authority for relevant Foreign Trade document | BEHOE | CHAR | 10 | Assigned to domain | BEHOE | |||
NAUEL | Verification docs: Validity date of verific.doc. for import | NAUEL | DATS | 8 | DATUM | ||||
NACA2 | Verification documents: Type of certificate for import | NACAR | CHAR | 10 | Assigned to domain | NACAR | |||
NACN2 | Verification docs: Official no. of verific. doc. - Import | NACNU | CHAR | 25 | CHAR25 | ||||
NACD2 | Verification documents: Date of verif.doc. for import procg | NACDA | DATS | 8 | DATUM | ||||
NAIS2 | Preference: ISO code of country issuing the preference doc. | PRISO | CHAR | 2 | INTCA | ||||
NAHO2 | Issuing authority for relevant Foreign Trade document | BEHOE | CHAR | 10 | Assigned to domain | BEHOE | |||
NAUE2 | Verification docs: Validity date of verific.doc. for import | NAUEL | DATS | 8 | DATUM | ||||
NACA3 | Verification documents: Type of certificate for import | NACAR | CHAR | 10 | Assigned to domain | NACAR | |||
NACN3 | Verification docs: Official no. of verific. doc. - Import | NACNU | CHAR | 25 | CHAR25 | ||||
NACD3 | Verification documents: Date of verif.doc. for import procg | NACDA | DATS | 8 | DATUM | ||||
NAIS3 | Verification doc: ISO code of ctry supplying verific.doc. | NAISO | CHAR | 2 | INTCA | ||||
NAHO3 | Issuing authority for relevant Foreign Trade document | BEHOE | CHAR | 10 | Assigned to domain | BEHOE | |||
NAUE3 | Verification docs: Validity date of verific.doc. for import | NAUEL | DATS | 8 | DATUM | ||||
NACA4 | Verification documents: Type of certificate for import | NACAR | CHAR | 10 | Assigned to domain | NACAR | |||
NACN4 | Verification docs: Official no. of verific. doc. - Import | NACNU | CHAR | 25 | CHAR25 | ||||
NACD4 | Verification documents: Date of verif.doc. for import procg | NACDA | DATS | 8 | DATUM | ||||
NAIS4 | Verification doc: ISO code of ctry supplying verific.doc. | NAISO | CHAR | 2 | INTCA | ||||
NAHO4 | Issuing authority for relevant Foreign Trade document | BEHOE | CHAR | 10 | Assigned to domain | BEHOE | |||
NAUE4 | Verification docs: Validity date of verific.doc. for import | NAUEL | DATS | 8 | DATUM | ||||
NACA5 | Verification documents: Type of certificate for import | NACAR | CHAR | 10 | Assigned to domain | NACAR | |||
NACN5 | Verification docs: Official no. of verific. doc. - Import | NACNU | CHAR | 25 | CHAR25 | ||||
NACD5 | Verification documents: Date of verif.doc. for import procg | NACDA | DATS | 8 | DATUM | ||||
NAIS5 | Verification doc: ISO code of ctry supplying verific.doc. | NAISO | CHAR | 2 | INTCA | ||||
NAHO5 | Issuing authority for relevant Foreign Trade document | BEHOE | CHAR | 10 | Assigned to domain | BEHOE | |||
NAUE5 | Verification docs: Validity date of verific.doc. for import | NAUEL | DATS | 8 | DATUM | ||||
EXDAR | Export document: Export document type for foreign trade | EXDAR | CHAR | 10 | Assigned to domain | VORPA | |||
EXDAA | Export document: Official number of export document | EXDAA | CHAR | 25 | CHAR25 | ||||
EXDAB | Export document: Valid-to number of export document | EXDAB | CHAR | 25 | CHAR25 | ||||
EXDTA | T document: Type of T document for foreign trade | EXDTA | CHAR | 10 | Assigned to domain | VORPA | |||
EXDT2 | T document: Official number of T document for foreign trade | EXDT2 | CHAR | 25 | CHAR25 | ||||
EXDTB | T doc.: Official no. for next page of T doc. f.foreign trade | EXDTB | CHAR | 25 | CHAR25 | ||||
EXDPA | Preference: Preference type for foreign trade | EXDPA | CHAR | 10 | Assigned to domain | PREFA | |||
EXPRE | Preference: Official number of preference document - Export | EXPRE | CHAR | 25 | CHAR25 | ||||
EXDT5 | CAP: Official number of T5 document for foreign trade | EXDT5 | CHAR | 25 | CHAR25 | ||||
COIMP | Code number for import processing in foreign trade | COIMP | CHAR | 17 | Assigned to domain | STAWN | COI | ||
GBNUM | Foreign Trade:Customs declaration list no. for Foreign Trade | GB_NR | CHAR | 20 | CHAR20 | ||||
REGNR | Registration number for import processing in foreign trade | RG_NR | CHAR | 20 | CHAR20 | ||||
PRENC | Exemption certificate: Indicator for legal control | PRENC | CHAR | 1 | PRENC | ||||
PRENO | Exemption certificate number for legal control | PRENN | CHAR | 8 | PRENN | ||||
PREND | Exemption certificate: Issue date of exemption certificate | PREND | DATS | 8 | PREND | ||||
WKREG | Region in which plant is located | WKREG | CHAR | 3 | Assigned to domain | REGIO | |||
IMPMA | Second unit of measurement | IMPMA | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
IMGEW | Net Weight | NTGEW | QUAN | 13(3) | MENG13 |
Key field | Non-key field |
How do I retrieve data from SAP structure VBDPRE using ABAP code?
As VBDPRE is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on VBDPRE as there is no data to select.How to access SAP table VBDPRE
Within an ECC or HANA version of SAP you can also view further information about VBDPRE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects