VBKA

Sales Activities | #transactional | Component: Sales Activities

🔑 Keys (2)
💰 Amounts
∑ Quantities
📅 Dates (9)
☰ Categorical (9)
Other (16)
🔗 Relations (23)

Column Name	Description
MANDT FK	Client
VBELN	SD document no. of a sales activity in sales support

Column Name	Description

Column Name	Description

Column Name	Description
ERDAT	Date on which the record was created
ERZET	Entry time
AEDAT	Last Changed On
AEZET	Time last change was made
KTABG	Start of sales activity (date)
KTAEN	End of sales activity (date)
KTABT	Start of sales activity
KTAET	End of sales activity (time)
KTADA	Date of follow-up sales activity

Column Name	Description
VBTYP	SD Document Category	Show values
TRVOG	Transaction Group	Show values
VBKLT	SD document indicator	Show values
GBSTK	Overall Processing Status (Header/All Items)	Show values
TXT_KONSE	Text entered in document	Show values
STR_HAS_PRI	Flag: Street has priority over PO box	Show values
DIRECTION	Direction of sales activity: Inbound / outbound	Show values
KTAAR_CLASS	CAS: Classify sales activity types	Show values
KALE	Maintain appointments in calendar	Show values

Column Name	Description	Domain name
ERNAM	Name of Person Responsible for Creating the Object	USNAM
AENAM	Name of Person Who Changed Object	USNAM
KTARE	not used	CHAR8
KTAVA	not used	CHAR14
KTANR	Number of the Address List	KTANR
ADRNR	Addresses: Address number of company address	CADRNR
KTARA	Description of where sales activity took place	KTARA
VGBEL	Document number of the reference document	VBELN
KTEXT	Short text for a sales activity	TEXT40
SUBMI	Collective Number	CHAR10
VBKLA	Original system with release and transaction control	CHAR9
KUNNR	Partner number (KUNNR, LIFNR, or PERNR)	KUNDE
JOBCOUNT	Job ID	TEXT8
STAFO	Update Group for statistics update	STAFO
KTEXT_MC	Short Text for a Sales Activity in Uppercase Letters	TEXT40U
KTEXT_MC_LANGU	Language Key for Short Text	SPRAS

Master Data Relations \| to Other Relations ↓	Join Conditions
Sales activity description 01 Sales activity description 01 Client	`VBKA.KTA01 == TVCA.KTA01` `VBKA.MANDT == TVCA.MANDT`
Sales activity description 02	`VBKA.MANDT == TVCB.MANDT` `VBKA.KTA02 == TVCB.KTA02`
Sales activity description 03	`VBKA.MANDT == TVCC.MANDT` `VBKA.KTA03 == TVCC.KTA03`
Sales activity description 04 Sales activity description 04 Client	`VBKA.KTA04 == TVCD.KTA04` `VBKA.MANDT == TVCD.MANDT`
Sales activity description 05 Sales activity description 05 Client	`VBKA.KTA05 == TVCE.KTA05` `VBKA.MANDT == TVCE.MANDT`
Sales activity description 06	`VBKA.MANDT == TVCF.MANDT` `VBKA.KTA06 == TVCF.KTA06`
Sales activity description 07 Sales activity description 07 Client	`VBKA.KTA07 == TVCG.KTA07` `VBKA.MANDT == TVCG.MANDT`
Sales activity description 08 Sales activity description 08 Client	`VBKA.KTA08 == TVCH.KTA08` `VBKA.MANDT == TVCH.MANDT`
Sales activity description 09 Sales activity description 09 Client	`VBKA.KTA09 == TVCI.KTA09` `VBKA.MANDT == TVCI.MANDT`
Sales activity description 10	`VBKA.MANDT == TVCJ.MANDT` `VBKA.KTA10 == TVCJ.KTA10`
Sales Activity Type for Sales Support	`VBKA.MANDT == TVKK.MANDT` `VBKA.KTAAR == TVKK.KTAAR`
Outcome of sales activities	`VBKA.MANDT == TVC1.MANDT` `VBKA.KTAER == TVC1.KTAER`
Type of follow-up activity	`VBKA.MANDT == TVKK.MANDT` `VBKA.KTAFK == TVKK.KTAAR`
Reason for sales activity Reason for sales activity Client	`VBKA.KTAGR == TVC2.KTAGR` `VBKA.MANDT == TVC2.MANDT`
Status of sales activity	`VBKA.MANDT == TVC3.MANDT` `VBKA.KTAST == TVC3.KTAST`
Client	`VBKA.MANDT == T000.MANDT`
Partner Function Partner Function Client	`VBKA.PARVW == TPAR.PARVW` `VBKA.MANDT == TPAR.MANDT`
Division - Sales Activity Sales Organization Distribution Channel Division Client	`VBKA.VKORG == TVTA.VKORG` `VBKA.VTWEG == TVTA.VTWEG` `VBKA.SPART == TVTA.SPART` `VBKA.MANDT == TVTA.MANDT`
Sales group Sales group Sales office	`VBKA.MANDT == TVBVK.MANDT` `VBKA.VKGRP == TVBVK.VKGRP` `VBKA.VKBUR == TVBVK.VKBUR`
Sales Organization	`VBKA.MANDT == TVKO.MANDT` `VBKA.VKORG == TVKO.VKORG`
Distribution Channel - Sales Activity Header Sales Organization Client Distribution Channel	`VBKA.VKORG == TVKOV.VKORG` `VBKA.MANDT == TVKOV.MANDT` `VBKA.VTWEG == TVKOV.VTWEG`

Other Relations \| to Master Data Relations ↑	Join Conditions
Analysis of sales activity outcome Analysis of sales activity outcome Outcome of sales activities	`VBKA.MANDT == TVC7.MANDT` `VBKA.KTAEB == TVC7.KATEB` `VBKA.KTAER == TVC7.KTAER`
Sales office Sales Organization Client Distribution Channel Division Sales office	`VBKA.VKORG == TVKBZ.VKORG` `VBKA.MANDT == TVKBZ.MANDT` `VBKA.VTWEG == TVKBZ.VTWEG` `VBKA.SPART == TVKBZ.SPART` `VBKA.VKBUR == TVKBZ.VKBUR`