SAP ABAP Table /BEV1/TSCONT_S (Telephone Sales: Structure for Sales activities)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ SD-SLS-PLL-OBS (Application Component) Remaining Beverage - Obsolete Objects
     ⤷ /BEV1/TS_OBSOLETE (Package) Telephone Sales - Obsolete Objects

Basic Data

Table Category	INTTAB	Structure
Structure	/BEV1/TSCONT_S	Table Relationship Diagram
Short Description	Telephone Sales: Structure for Sales activities

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	KTABG	☐	KTABG	KTABG	DATS	8	0	Start of sales activity (date)
2	/BEV1/TSANWBER	☐	/BEV1/TSABER___D	/BEV1/TSABER	CHAR	10	0	Application Area	/BEV1/TSABER
3	/BEV1/TSANWGRP	☐	/BEV1/TSAGRP___D	/BEV1/TSAGRP	CHAR	7	0	Application Group	/BEV1/TSAGRP
4	KTABT	☐	KTABT	KTABT	TIMS	6	0	Start of sales activity
5	KTAET	☐	KTAET	KTAET	TIMS	6	0	End of sales activity (time)
6	/BEV1/TSKTABT2	☐	/BEV1/TSKTABT2	TIME	TIMS	6	0	Sales Activity Start (Alternative)
7	/BEV1/TSKTAET2	☐	/BEV1/TSKTAET2	TIME	TIMS	6	0	End of Sales Activity (Alternative)
8	VBELN	☑	CAS_VBELN	VBELN	CHAR	10	0	SD document no. of a sales activity in sales support	VBUK
9	KTAST	☐	KTAST	KTAST	CHAR	1	0	Status of sales activity	TVC3
10	GBSTK	☐	GBSTK	STATV	CHAR	1	0	Overall processing status of document
11	VBELN_F	☐	CAS_VBELN	VBELN	CHAR	10	0	SD document no. of a sales activity in sales support	*
12	KTADA	☐	KTADA	KTADA	DATS	8	0	Date of follow-up sales activity
13	ZYKLUS	☐	/BEV1/TSYK____D	NUM03	NUMC	3	0	Phone Call Cycle
14	SAISON	☐	/BEV1/TSSAISON	/BEV1/TSSAISON	CHAR	5	0	Season Indicator	/BEV1/TSSAIDEF
15	KUNNR	☐	KUNDE_D	KUNDE	CHAR	10	0	Partner number (KUNNR, LIFNR, or PERNR)
16	NAME1_K	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
17	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
18	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
19	ORT01_K	☐	ORT01_GP	TEXT35	CHAR	35	0	City
20	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
21	TELF1_K	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
22	PARNR	☑	PARNR	PARNR	NUMC	10	0	Number of contact person	KNVK
23	NAME1_A	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
24	ORT01_A	☐	ORT01_GP	TEXT35	CHAR	35	0	City
25	TELF1_A	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
26	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
27	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
28	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
29	/BEV1/TSLIEBG	☐	/BEV1/TSLIEBG	DATUM	DATS	8	0	Delivery date
30	/BEV1/TSLIEBS	☐	/BEV1/TSLIEBS	DATUM	DATS	8	0	System-Calculated Delivery Date (without Correction)
31	/BEV1/TSLIEBF	☐	/BEV1/TSLIEBF	CHAR1	CHAR	1	0	Delivery Date Changed by User
32	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
33	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
34	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
35	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
36	AEZET	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
37	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
38	KTAAR	☐	KTAAR	KTAAR	CHAR	4	0	Sales Activity Type for Sales Support	TVKK
39	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
40	TRVOG	☐	TRVOG	TRVOG	CHAR	1	0	Transaction group
41	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
42	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
43	KTAEN	☐	KTAEN	KTAEN	DATS	8	0	End of sales activity (date)
44	KTAGR	☐	KTAGR	KTAGR	CHAR	3	0	Reason for sales activity	TVC2
45	KTAER	☐	KTAER	KTAER	CHAR	3	0	Outcome of sales activities	TVC1
46	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
47	PARVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	TPAR
48	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
49	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
50	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
51	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
52	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
53	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
54	ADRND	☐	ADRND	ADRNR	CHAR	10	0	Business address	*
55	ADRNP	☐	ADRNP	ADRNR	CHAR	10	0	Private address	*
56	ABTPA	☐	ABTEI_PA	ABTEI	CHAR	12	0	Contact person's department at customer
57	ABTNR	☐	ABTNR_PA	ABTNR	CHAR	4	0	Contact person department	TSAB
58	ANRED	☐	ANRED_AP	TEXT30	CHAR	30	0	Form of address for contact person (Mr, Mrs...etc)
59	PAFKT	☐	PAFKT	PAFKT	CHAR	2	0	Contact person function	TPFK
60	PAVIP	☐	PAVIP	PAVIP	CHAR	1	0	VIP Partner	TVIP
61	PARGE	☐	PARGE	GESCH	CHAR	1	0	Partner's gender
62	PARLA	☐	PARLA	SPRAS	LANG	1	0	Partner language	T002
63	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/BEV1/TSCONT_S	/BEV1/TSANWBER	/BEV1/TSABER	ANWBER	REF	1	CN
2	/BEV1/TSCONT_S	/BEV1/TSANWGRP	/BEV1/TSAGRP	ANWGRP	REF	1	CN
3	/BEV1/TSCONT_S	ABTNR	TSAB	ABTNR	REF	1	CN
4	/BEV1/TSCONT_S	KTAAR	TVKK	KTAAR	REF	1	CN
5	/BEV1/TSCONT_S	KTAER	TVC1	KTAER	REF	C	CN
6	/BEV1/TSCONT_S	KTAGR	TVC2	KTAGR	REF	C	CN
7	/BEV1/TSCONT_S	KTAST	TVC3	KTAST	REF	1	CN
8	/BEV1/TSCONT_S	PAFKT	TPFK	PAFKT	REF	1	CN
9	/BEV1/TSCONT_S	PARLA	T002	SPRAS	REF	C	CN
10	/BEV1/TSCONT_S	PARNR	KNVK	PARNR	REF	1	CN
11	/BEV1/TSCONT_S	PARVW	TPAR	PARVW	REF	1	CN
12	/BEV1/TSCONT_S	PAVIP	TVIP	PAVIP	REF	C	CN
13	/BEV1/TSCONT_S	SAISON	/BEV1/TSSAIDEF	SAISON	REF	C	CN
14	/BEV1/TSCONT_S	SPART	TSPA	SPART	REF	1	CN
15	/BEV1/TSCONT_S	VBELN	VBUK	VBELN	REF	1	CN
16	/BEV1/TSCONT_S	VKBUR	TVBUR	VKBUR	REF	C	CN
17	/BEV1/TSCONT_S	VKGRP	TVKGR	VKGRP	REF	C	CN
18	/BEV1/TSCONT_S	VKORG	TVKO	VKORG	REF	1	CN
19	/BEV1/TSCONT_S	VTWEG	TVTW	VTWEG	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	4602