SAP ABAP Table JJTVV (IS-M/AM: Media Sales Agent Contract)

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	TRANSP	Transparent table
Transparent table	JJTVV	Table Relationship Diagram
Short Description	IS-M/AM: Media Sales Agent Contract

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in