SAP ABAP Table VBKA_MAILING (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VBKA_MAILING	Table Relationship Diagram
Short Description	Generated Table for 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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	VBELN	☑	CAS_VBELN	VBELN	CHAR	10	0	SD document no. of a sales activity in sales support	VBUK
3	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
4	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
5	KTAAR	☐	KTAAR	KTAAR	CHAR	4	0	Sales Activity Type for Sales Support	TVKK
6	TRVOG	☐	TRVOG	TRVOG	CHAR	1	0	Transaction group
7	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
8	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
9	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
10	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
11	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
12	KTABG	☐	KTABG	KTABG	DATS	8	0	Start of sales activity (date)
13	KTAEN	☐	KTAEN	KTAEN	DATS	8	0	End of sales activity (date)
14	KTAGR	☐	KTAGR	KTAGR	CHAR	3	0	Reason for sales activity	TVC2
15	KTAST	☐	KTAST	KTAST	CHAR	1	0	Status of sales activity	TVC3
16	KTAER	☐	KTAER	KTAER	CHAR	3	0	Outcome of sales activities	TVC1
17	KTAEB	☐	KTAEB	KTAEB	CHAR	3	0	Analysis of sales activity outcome	TVC7
18	KTEXT	☐	KTEXT_CAS	TEXT40	CHAR	40	0	Short text for a sales activity
19	KTAAR_CLASS	☐	KTAAR_CLASS	KTAAR_CLASS	CHAR	1	0	CAS: Classify sales activity types

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VBKA_MAILING	KTAAR	TVKK	KTAAR	REF	1	CN
2	VBKA_MAILING	KTAEB	TVC7	KATEB	REF	C	CN
3	VBKA_MAILING	KTAER	TVC1	KTAER	REF	C	CN
4	VBKA_MAILING	KTAGR	TVC2	KTAGR	REF	C	CN
5	VBKA_MAILING	KTAST	TVC3	KTAST	REF	C	CN
6	VBKA_MAILING	MANDT	T000	MANDT	KEY	1	CN
7	VBKA_MAILING	SPART	TVTA	SPART	REF	1	CN
8	VBKA_MAILING	VBELN	VBUK	VBELN	KEY	1	C
9	VBKA_MAILING	VKBUR	TVKBZ	VKBUR	REF	C	CN
10	VBKA_MAILING	VKGRP	TVBVK	VKGRP	REF	C	CN
11	VBKA_MAILING	VKORG	TVKO	VKORG	REF	1	CN
12	VBKA_MAILING	VTWEG	TVKOV	VTWEG	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in