SAP ABAP Table RJJWA200 (IS-M/AM: Input/Display Fields for Sales Activity Maintenance)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***

Basic Data

Table Category	INTTAB	Structure
Structure	RJJWA200	Table Relationship Diagram
Short Description	IS-M/AM: Input/Display Fields for Sales Activity Maintenance

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	GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
2	TGPNR	☐	CAS_TGPNR	CHAR60	CHAR	60	0	IS-M: Business Partner Name
3	PARNR	☐	ISM_CNTCT_PRSN	BU_PARTNER	CHAR	10	0	IS-M: Contact Person	JJTAM
4	TPARNR	☐	CAS_TPARNR	CHAR60	CHAR	60	0	Details of contact person (incl.telephone number)
5	KTABG	☐	KTABG	KTABG	DATS	8	0	Start of sales activity (date)
6	KTAEN	☐	KTAEN	KTAEN	DATS	8	0	End of sales activity (date)
7	KTABT	☐	KTABT	KTABT	TIMS	6	0	Start of sales activity
8	KTAET	☐	KTAET	KTAET	TIMS	6	0	End of sales activity (time)
9	ISP_GVON	☐	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
10	ISP_GBIS	☐	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
11	KTEXT	☐	KTEXT_CAS	TEXT40	CHAR	40	0	Short text for a sales activity
12	KTAGR	☐	KTAGR	KTAGR	CHAR	3	0	Reason for sales activity	TVC2
13	KTAER	☐	KTAER	KTAER	CHAR	3	0	Outcome of sales activities	TVC1
14	KTAEB	☐	KTAEB	KTAEB	CHAR	3	0	Analysis of sales activity outcome	TVC4
15	KTAST	☐	KTAST	KTAST	CHAR	1	0	Status of sales activity	TVC3
16	KTAFK	☐	KTAFK	KTAAR	CHAR	4	0	Type of follow-up activity	TVKK
17	KTADA	☐	KTADA	KTADA	DATS	8	0	Date of follow-up sales activity
18	KTANR	☐	KTANR	KTANR	CHAR	10	0	Number of the Address List
19	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
20	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
21	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
22	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
23	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
24	ADRNR_GP	☐	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number	*
25	ADRNR_AP	☐	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number	*
26	LAND1_GP	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
27	LAND1_AP	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
28	ISP_VNR	☐	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	*
29	ISP_BEDNR	☐	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement	*
30	KTARE	☐	ISM_KTARE	PROGNAME	CHAR	40	0	IS-M/AM: Report for Sales Activities, Mailings etc	TRDIR
31	KTAVA	☐	KTAVA	VARIANT	CHAR	14	0	Variants for sales activities, mailing, etc...	*
32	VAR_TEXT	☐	RVART_VTXT	TEXT30	CHAR	30	0	Program variant short text
33	TXT_KONSE	☐	TXT_KONSE	FLAG	CHAR	1	0	Text entered in document
34	USERA	☐	CAS_USRSEL	USERNAME	CHAR	12	0	User who carried out the selection
35	SELDAT	☐	CAS_SELDAT	DATUM	DATS	8	0	Date on which the selection was last changed
36	ADRCNT	☐	CAS_ADRCNT	SYST_LONG	INT4	10	0	Number of selected addresses for direct mailing
37	KTA01	☐	KTA01	KTA01	CHAR	2	0	Sales activity description 01	TVCA
38	KTA02	☐	KTA02	KTA02	CHAR	2	0	Sales activity description 02	TVCB
39	KTA03	☐	KTA03	KTA03	CHAR	2	0	Sales activity description 03	TVCC
40	KTA04	☐	KTA04	KTA04	CHAR	2	0	Sales activity description 04	TVCD
41	KTA05	☐	KTA05	KTA05	CHAR	2	0	Sales activity description 05	TVCE
42	KTA06	☐	KTA06	KTA06	CHAR	3	0	Sales activity description 06	TVCF
43	KTA07	☐	KTA07	KTA07	CHAR	3	0	Sales activity description 07	TVCG
44	KTA08	☐	KTA08	KTA08	CHAR	3	0	Sales activity description 08	TVCH
45	KTA09	☐	KTA09	KTA09	CHAR	3	0	Sales activity description 09	TVCI
46	KTA10	☐	KTA10	KTA10	CHAR	3	0	Sales activity description 10	TVCJ
47	ISP_ASEL	☐	ADSELREP	PROGRAMM	CHAR	40	0	Name of the Address Selection Report	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJJWA200	GPNR	JGTGPNR	GPNR	KEY	1	CN
2	RJJWA200	KTA01	TVCA	KTA01	KEY	1	CN
3	RJJWA200	KTA02	TVCB	KTA02	KEY	1	CN
4	RJJWA200	KTA03	TVCC	KTA03	KEY	1	CN
5	RJJWA200	KTA04	TVCD	KTA04	KEY	1	CN
6	RJJWA200	KTA05	TVCE	KTA05	KEY	1	CN
7	RJJWA200	KTA06	TVCF	KTA06	KEY	1	CN
8	RJJWA200	KTA07	TVCG	KTA07	KEY	1	CN
9	RJJWA200	KTA08	TVCH	KTA08	KEY	1	CN
10	RJJWA200	KTA09	TVCI	KTA09	KEY	1	CN
11	RJJWA200	KTA10	TVCJ	KTA10	KEY	1	CN
12	RJJWA200	KTAEB	TVC4	KTAEB	KEY	1	CN
13	RJJWA200	KTAER	TVC1	KTAER	KEY	1	CN
14	RJJWA200	KTAFK	TVKK	KTAAR	KEY	1	CN
15	RJJWA200	KTAGR	TVC2	KTAGR	KEY	1	CN
16	RJJWA200	KTARE	TRDIR	NAME	REF	1	CN
17	RJJWA200	KTAST	TVC3	KTAST	KEY	1	CN
18	RJJWA200	PARNR	JJTAM	PARNR	KEY	1	CN
19	RJJWA200	SPART	TSPA	SPART	KEY	1	CN
20	RJJWA200	VKBUR	TVBUR	VKBUR	KEY	1	CN
21	RJJWA200	VKGRP	TVKGR	VKGRP	KEY	1	CN
22	RJJWA200	VKORG	TVKO	VKORG	KEY	1	CN
23	RJJWA200	VTWEG	TVTW	VTWEG	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in