SAP ABAP Table VEKAC (KOBRA (C Record) Export)

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	TRANSP	Transparent table
Transparent table	VEKAC	Table Relationship Diagram
Short Description	KOBRA (C Record) Export

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	NUMMBUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	DATUMJAHR	☑	DATUMJAHR	GJAHR	NUMC	4	0	Reporting year of declaration to authorities
4	DATUMMONA	☑	DATUMMONA	MONAT	NUMC	2	0	Reporting month of declaration to authorities
5	ARRIVDEPA	☑	VEREI	VEREI	NUMC	1	0	Indicator: Goods direction for declarations to authorities
6	LAUFNRBSA	☑	LAUFNRBSA	NUMC5	NUMC	5	0	Sequential number of B record
7	POSINUMME	☑	POSINUMME	NUMC02	NUMC	2	0	Item number on tape
8	FIRMNUMME	☐	FIRMNUMME	CHAR7	CHAR	7	0	Company number assigned by authorities
9	STATWAREN	☐	STAWN	STAWN	CHAR	17	0	Commodity Code/Import Code Number for Foreign Trade	T604
10	GRENZWERT	☐	GRENZWERK	NUMC13	NUMC	13	0	Statistical value for Kobra declaration
11	WARENBEZE	☐	WARENBEZE	CHAR240	CHAR	240	0	Material description for Kobra declaration
12	URSPRSLND	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	*
13	URSPRSREG	☐	URSPRSREG	REGIO	CHAR	3	0	Region of origin	*
14	EIGENMASS	☐	EIGENMASK	NUMC09	NUMC	9	0	Tare mass in kilograms for Kobra
15	BESONMASS	☐	BESONMASK	CHAR16	CHAR	16	0	Supplementary units for Kobra
16	RECHNWERT	☐	RECHNWERT	NUMC15	NUMC	15	0	Invoice value
17	VERKAUFOR	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
18	BELEGNUMR	☐	BELEGNUMR	VBELN	CHAR	10	0	Document number	VBUK
19	HAUPTPOSI	☐	HAUPTPOSI	POSNR	NUMC	6	0	Item	VBUP
20	NUMMWERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
21	WERKSLAND	☐	WERKSLAND	LAND1	CHAR	3	0	Declaration to authorities: Country of Plant	*
22	RECHNWEAK	☐	RECHNWEAK	WERTV8	CURR	15	2	Invoice value
23	RECHNWEEH	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
24	GRENZWEAK	☐	GRENZWEAK	WERTV7	CURR	13	2	Statistical value
25	GRENZWEEH	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
26	EIGENMAAK	☐	EIGENMAAK	MENG13	QUAN	13	3	Tare mass
27	EIGENMAEH	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
28	BESONMAAK	☐	BESONMAAK	MENG13	QUAN	13	3	Special unit of measure
29	BESONMAEH	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
30	IREFBELEG	☐	IREFBELEG	VBELN	CHAR	10	0	Reference document	*
31	IREFPOSIT	☐	IREFPOSIT	POSNR	NUMC	6	0	Reference item	*
32	IREFMONAT	☐	IREFMONAT	IREFMONAT	NUMC	2	0	Reference month for correction
33	IREFEJAHR	☐	IREFEJAHR	GJAHR	NUMC	4	0	Reference year for correction
34	BELEGIDEN	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
35	ORDPA	☐	ORDPA	CHAR10	CHAR	10	0	Classification Key for Periodic Declarations in For. Trade
36	THIERISCH	☐	THIERISCH	THIERISCH	CHAR	1	0	ID type for creating records
37	ISESSIONE	☐	ISESSIONE	ISESSIONE	CHAR	1	0	Indicator for normal business transactions and correction

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VEKAC	BELEGNUMR	VBUK	VBELN	KEY	1	CN
2	VEKAC	BESONMAEH	T006	MSEHI	REF	1	CN
3	VEKAC	EIGENMAEH	T006	MSEHI	REF	1	CN
4	VEKAC	GRENZWEEH	TCURC	WAERS	REF	1	CN
5	VEKAC	HAUPTPOSI	VBUP	POSNR	KEY	1	CN
6	VEKAC	MANDT	T000	MANDT	KEY	1	CN
7	VEKAC	NUMMBUKRS	T001	BUKRS	KEY	1	CN
8	VEKAC	NUMMWERKS	T001W	WERKS	REF	1	CN
9	VEKAC	RECHNWEEH	TCURC	WAERS	REF	1	CN
10	VEKAC	STATWAREN	T604	STAWN	REF	1	CN
11	VEKAC	VERKAUFOR	TVKO	VKORG	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in