SAP ABAP Table RJJVVVB (IS-M/AM: Structure for update JJTVT)

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	RJJVVVB	Table Relationship Diagram
Short Description	IS-M/AM: Structure for update JJTVT

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	.INCLUDE	☐				0	0	IS-M/AM: Media Sales Agent Contract
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	VNR	☐	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
4	.INCLUDE	☐				0	0	IS-PAM: Media agent contract (data part)
5	VTYP	☐	JVERMVTYP	JVERMVTYP	CHAR	1	0	IS-M: Contract Category for Media Sales Agent Contract
6	VERM	☐	VERM_MEDIA	GPNR	CHAR	10	0	IS-M: Media Sales Agent	JJVDB_MV_FK
7	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
8	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
9	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
10	XSTDV	☐	JSTD_VERMV	XFELD	CHAR	1	0	IS-M: Standard Sales Agent Contract Indicator
11	STD_PROSL	☐	JSTDPROSL	PRSCHL	CHAR	5	0	IS-M: Standard Commission Key	TJH23
12	POOLNR	☐	POOLNR	POOLNR	CHAR	6	0	IS-M: Media Sales Agent Pool	JJTPO
13	VGRUP	☐	JVGRUP	JVGRUP	CHAR	6	0	IS-M: Media Sales Agent Contract Grouping	TJJV1
14	KTGRV	☐	KTGRV	KTGRV	CHAR	2	0	IS-M: Account Assignment Group for Sales Agent Contract	TJJAF
15	BEZKP	☐	BEZKONDP	JBEZKOND	CHAR	2	0	Condition Reference For Sales Vol.Dependent Commission Det.	TJJ83
16	BEZKB1	☐	BEZKONDB1	JBEZKOND	CHAR	2	0	Condition Reference for Determining Sales Agent Bonus 1	TJJ83
17	BEZKB2	☐	BEZKONDB2	JBEZKOND	CHAR	2	0	Condition Reference for Determining Sales Agent Bonus 2	TJJ83
18	KALSK	☐	JKALKSK	KALKSK	CHAR	2	0	IS-M: Sales Agent Det.Proc. (for Pricing Proc.Determination)	TJJ85
19	PERNR	☐	JJPERNR	JPERNR	CHAR	20	0	IS-M: Personnel Number
20	ABRKP	☐	JABRKALVMP	WFCID	CHAR	2	0	IS-M: Commission Settlement Calendar for Media Sales Agent	TJJ81
21	ABRKB1	☐	JABRKALVMB	WFCID	CHAR	2	0	IS-M/AM: Bonus Settlement Calendar 1 for Media Sales Agent	TJJ81
22	ABRKB2	☐	JABRKALVM2	WFCID	CHAR	2	0	IS-M: Bonus Settlement Calendar 2 for Media Sales Agent	TJJ81
23	BO1SL	☐	JJBONSCHL1	PRSCHL	CHAR	5	0	IS-M/AM: Bonus 1: Commission Key for Media Sales Agent	TJH23
24	BO2SL	☐	JJBONSCHL2	PRSCHL	CHAR	5	0	IS-M: Bonus 2: Commission Key for Media Sales Agent	TJH23
25	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key	T052
26	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
27	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
28	GPNR_ZE	☐	GPNR_ZE	GPNR	CHAR	10	0	IS-M/SD: Business Partner Alternative Payee	JGTGPNR
29	TACLGP	☐	JTACLGPMV	JTACLGP	CHAR	1	0	Tax Classification for Media Sales Agent Business Partner	TJJ35
30	UEBERLART	☐	UEBERLZIEL	UEBERLZIEL	CHAR	1	0	IS-M: Transfer Destination
31	XLOESCHVM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
32	XLOESCHKZ	☐	LOEKZ_ISP	XFELD	CHAR	1	0	Deletion Indicator for Master Data in Media Sales & Dist.
33	.INCLUDE	☐				0	0	IS-M: Short and Long Texts
34	KURZTEXT	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
35	LANGTEXT	☐	BEZEICHN50	TEXT50	CHAR	50	0	IS-M: Long Text
36	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
37	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
38	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
39	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
40	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
41	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
42	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
43	LAST_BEDNR	☐	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement	*
44	DBCODE	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJJVVVB	ABRKB1	TJJ81	IDENT	REF	1	CN
2	RJJVVVB	ABRKB2	TJJ81	IDENT	REF	C	CN
3	RJJVVVB	ABRKP	TJJ81	IDENT
4	RJJVVVB	BEZKB1	TJJ83	BEZKOND	REF	1	CN
5	RJJVVVB	BEZKB2	TJJ83	BEZKOND	REF	C	CN
6	RJJVVVB	BEZKP	TJJ83	BEZKOND	REF	1	CN
7	RJJVVVB	BO1SL	TJH23	PRSCHL	REF	C	CN
8	RJJVVVB	BO2SL	TJH23	PRSCHL	REF	C	CN
9	RJJVVVB	EKORG	T024E	EKORG	REF	1	CN
10	RJJVVVB	GPNR_ZE	JGTGPNR	GPNR	REF	1	CN
11	RJJVVVB	KALSK	TJJ85	KALSK	REF	1	CN
12	RJJVVVB	KTGRV	TJJAF	KTGRV	REF	C	CN
13	RJJVVVB	KURST	TCURV	KURST
14	RJJVVVB	MANDT	T000	MANDT
15	RJJVVVB	POOLNR	JJTPO	POOLNR	REF	C	CN
16	RJJVVVB	STD_PROSL	TJH23	PRSCHL	REF	1	CN
17	RJJVVVB	TACLGP	TJJ35	TACLGP	REF	1	CN
18	RJJVVVB	VERM	JJVDB_MV_FK	GPNR	REF	1	CN
19	RJJVVVB	VGRUP	TJJV1	VGRUP	REF	1	CN
20	RJJVVVB	VKBUR	TVBUR	VKBUR	REF	C	CN
21	RJJVVVB	VKGRP	TVBVK	VKGRP	REF	1	CN
22	RJJVVVB	VNR	JJTVV	VNR
23	RJJVVVB	WAERS	TCURC	WAERS	REF	1	CN
24	RJJVVVB	ZTERM	T052	ZTERM	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in