SAP ABAP Table VBDPRE (Foreign Trade: Item Data for Billing View)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ VEI (Package) Application development R/3 foreign trade

Basic Data

Table Category	INTTAB	Structure
Structure	VBDPRE	Table Relationship Diagram
Short Description	Foreign Trade: Item Data for Billing View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	EXNUM	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	*
2	EXPOS	☐	EXPOS	EXPOS	NUMC	6	0	Internal item number for foreign trade data in MM and SD
3	STAWN	☐	STAWN	STAWN	CHAR	17	0	Commodity Code/Import Code Number for Foreign Trade	*
4	EXPRF	☐	EXPRF	EXPRF	CHAR	8	0	Export/Import Procedure for Foreign Trade	*
5	EXART	☐	EXART	EXART	CHAR	2	0	Business Transaction Type for Foreign Trade	*
6	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	*
7	HERKR	☐	HERKR	REGIO	CHAR	3	0	Region of origin of material (non-preferential origin)	*
8	GRWRT	☐	GRWRT	GRWRT	CURR	13	2	Statistical value for foreign trade
9	HERTI	☐	LANDX	TEXT15	CHAR	15	0	Country Name
10	HERTA	☐	ALAND	LAND1	CHAR	3	0	Departure country (country from which the goods are sent)	*
11	STXT1	☐	STXT1	CHAR40	CHAR	40	0	Description of commodity code - First line
12	STXT2	☐	STXT2	CHAR40	CHAR	40	0	Description of commodity code - Second line
13	STXT3	☐	STXT3	CHAR40	CHAR	40	0	Description of commodity code - Third line
14	STXT4	☐	STXT4	CHAR40	CHAR	40	0	Description of commodity code - Fourth line
15	STXT5	☐	STXT5	CHAR40	CHAR	40	0	Description of commodity code - Fifth line
16	STXT6	☐	STXT6	CHAR40	CHAR	40	0	Description of commodity code - Sixth line
17	STXT7	☐	STXT7	CHAR40	CHAR	40	0	Description of commodity code - Seventh line
18	BEMAS	☐	BEMEH	MEINS	UNIT	3	0	Supplementary unit	*
19	PREFE	☐	PREFE	PREFE	CHAR	1	0	Preference indicator in export/import
20	BOLNR	☐	BOLNR	CHAR35	CHAR	35	0	Bill of lading
21	TRATY	☐	TRATY	TRATY	CHAR	4	0	Means-of-Transport Type	*
22	TRAID	☐	TRAID	TRAID	CHAR	20	0	Means-of-transport ID
23	HERBL	☐	HERBL	HERBL	CHAR	2	0	State of manufacture
24	BMGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
25	MOWNR	☐	MOWNR	MOWNR	CHAR	12	0	CAP: Number of CAP products list	*
26	GPNUM	☐	GPNUM	GPNUM	CHAR	9	0	Production statistics: PRODCOM number for foreign trade	*
27	CASNR	☐	CASNR	CASNR	CHAR	15	0	CAS number for pharmaceutical products in foreign trade	*
28	STEUC	☐	STEUC	STEUC	CHAR	16	0	Control code for consumption taxes in foreign trade	*
29	WZOLL	☐	WZOLL	GRWRT	CURR	13	2	Customs val. in doc.currency in imp.procg for foreign trade
30	VERLD	☐	VERLD	LAND1	CHAR	3	0	Country of dispatch for Foreign Trade	*
31	HANLD	☐	HANLD	LAND1	CHAR	3	0	Trading country for foreign trade	*
32	TEXT1	☐	BEZEI40	TEXT40	CHAR	40	0	Description
33	TEXT2	☐	BEZEI40	TEXT40	CHAR	40	0	Description
34	TEXT3	☐	BEZEI40	TEXT40	CHAR	40	0	Description
35	COKON	☐	COKON	COKON	CHAR	6	0	Customs quota code for import processing in foreign trade	*
36	COPHA	☐	COPHA	COPHA	CHAR	6	0	Pharmaceutical products code (Foreign Trade)	*
37	COADI	☐	COADI	COADI	CHAR	6	0	Anti-dumping code for import processing in foreign trade	*
38	PRONU	☐	PRONU	PRONU	CHAR	25	0	Invoice: Number of invoice document for import processing
39	PRODA	☐	PRODA	DATUM	DATS	8	0	Invoice: Date of invoice document for import processing
40	VORPA	☐	VORPA	VORPA	CHAR	10	0	Preliminary document: Document type for foreign trade procg	*
41	VORNU	☐	VORNU	CHAR25	CHAR	25	0	Preliminary document: No. of preliminary doc.f.import procg
42	VORDA	☐	VORDA	DATUM	DATS	8	0	Preliminary document: Date of preliminary doc.f.import procg
43	BEHOE	☐	BEHOE	BEHOE	CHAR	10	0	Issuing authority for relevant Foreign Trade document	*
44	KENNU	☐	KENNU	CHAR06	CHAR	6	0	Preliminary document: Customs office/ID number for import
45	VOISO	☐	VOISO	INTCA	CHAR	2	0	Prelim. doc.: ISO code of ctry issuing the preliminary doc.
46	PREFA	☐	PREFA	PREFA	CHAR	10	0	Preference: Preference type for foreign trade	*
47	PREFN	☐	PREFN	CHAR25	CHAR	25	0	Preference: Official number of preference document - Import
48	PREDU	☐	PREDU	DATUM	DATS	8	0	Preference: Date of preference document for import procg
49	PRISO	☐	PRISO	INTCA	CHAR	2	0	Preference: ISO code of country issuing the preference doc.
50	PRHOE	☐	BEHOE	BEHOE	CHAR	10	0	Issuing authority for relevant Foreign Trade document	*
51	PRUEL	☐	PRUEL	DATUM	DATS	8	0	Preference: Validity date of preference document for import
52	NACAR	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	*
53	NACNU	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
54	NACDA	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
55	NAISO	☐	NAISO	INTCA	CHAR	2	0	Verification doc: ISO code of ctry supplying verific.doc.
56	NAHOE	☐	BEHOE	BEHOE	CHAR	10	0	Issuing authority for relevant Foreign Trade document	*
57	NAUEL	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
58	NACA2	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	*
59	NACN2	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
60	NACD2	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
61	NAIS2	☐	PRISO	INTCA	CHAR	2	0	Preference: ISO code of country issuing the preference doc.
62	NAHO2	☐	BEHOE	BEHOE	CHAR	10	0	Issuing authority for relevant Foreign Trade document	*
63	NAUE2	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
64	NACA3	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	*
65	NACN3	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
66	NACD3	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
67	NAIS3	☐	NAISO	INTCA	CHAR	2	0	Verification doc: ISO code of ctry supplying verific.doc.
68	NAHO3	☐	BEHOE	BEHOE	CHAR	10	0	Issuing authority for relevant Foreign Trade document	*
69	NAUE3	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
70	NACA4	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	*
71	NACN4	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
72	NACD4	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
73	NAIS4	☐	NAISO	INTCA	CHAR	2	0	Verification doc: ISO code of ctry supplying verific.doc.
74	NAHO4	☐	BEHOE	BEHOE	CHAR	10	0	Issuing authority for relevant Foreign Trade document	*
75	NAUE4	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
76	NACA5	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	*
77	NACN5	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
78	NACD5	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
79	NAIS5	☐	NAISO	INTCA	CHAR	2	0	Verification doc: ISO code of ctry supplying verific.doc.
80	NAHO5	☐	BEHOE	BEHOE	CHAR	10	0	Issuing authority for relevant Foreign Trade document	*
81	NAUE5	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
82	EXDAR	☐	EXDAR	VORPA	CHAR	10	0	Export document: Export document type for foreign trade	*
83	EXDAA	☐	EXDAA	CHAR25	CHAR	25	0	Export document: Official number of export document
84	EXDAB	☐	EXDAB	CHAR25	CHAR	25	0	Export document: Valid-to number of export document
85	EXDTA	☐	EXDTA	VORPA	CHAR	10	0	T document: Type of T document for foreign trade	*
86	EXDT2	☐	EXDT2	CHAR25	CHAR	25	0	T document: Official number of T document for foreign trade
87	EXDTB	☐	EXDTB	CHAR25	CHAR	25	0	T doc.: Official no. for next page of T doc. f.foreign trade
88	EXDPA	☐	EXDPA	PREFA	CHAR	10	0	Preference: Preference type for foreign trade	*
89	EXPRE	☐	EXPRE	CHAR25	CHAR	25	0	Preference: Official number of preference document - Export
90	EXDT5	☐	EXDT5	CHAR25	CHAR	25	0	CAP: Official number of T5 document for foreign trade
91	COIMP	☐	COIMP	STAWN	CHAR	17	0	Code number for import processing in foreign trade	*
92	GBNUM	☐	GB_NR	CHAR20	CHAR	20	0	Foreign Trade:Customs declaration list no. for Foreign Trade
93	REGNR	☐	RG_NR	CHAR20	CHAR	20	0	Registration number for import processing in foreign trade
94	PRENC	☐	PRENC	PRENC	CHAR	1	0	Exemption certificate: Indicator for legal control
95	PRENO	☐	PRENN	PRENN	CHAR	8	0	Exemption certificate number for legal control
96	PREND	☐	PREND	PREND	DATS	8	0	Exemption certificate: Issue date of exemption certificate
97	WKREG	☐	WKREG	REGIO	CHAR	3	0	Region in which plant is located	*
98	IMPMA	☐	IMPMA	MEINS	UNIT	3	0	Second unit of measurement	*
99	IMGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight

History

Last changed by/on	SAP	20110901
SAP Release Created in