SAP ABAP Table JJVVV (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JJVVV	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	VNR	☑	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number
3	BEDNR	☑	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement
4	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
5	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
6	SPART	☑	SPART	SPART	CHAR	2	0	Division	TVTA
7	VERM	☐	VERM_MEDIA	GPNR	CHAR	10	0	IS-M: Media Sales Agent	JJVDB_MV_FK
8	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
9	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
10	KALSK	☐	JKALKSK	KALKSK	CHAR	2	0	IS-M: Sales Agent Det.Proc. (for Pricing Proc.Determination)	TJJ85
11	PERNR	☐	JJPERNR	JPERNR	CHAR	20	0	IS-M: Personnel Number
12	GPNR_ZE	☐	GPNR_ZE	GPNR	CHAR	10	0	IS-M/SD: Business Partner Alternative Payee	JGTGPNR
13	UEBERLART	☐	UEBERLZIEL	UEBERLZIEL	CHAR	1	0	IS-M: Transfer Destination
14	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
15	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
16	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
17	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
18	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
19	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
20	KURZTEXT	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
21	VTYP	☐	JVERMVTYP	JVERMVTYP	CHAR	1	0	IS-M: Contract Category for Media Sales Agent Contract
22	KTGRV	☐	KTGRV	KTGRV	CHAR	2	0	IS-M: Account Assignment Group for Sales Agent Contract	TJJAF
23	GUELTIGAB	☐	DATEVALFRM	DATUM	DATS	8	0	IS-M: "Valid From" Date
24	GUELTIGBIS	☐	DATEVALTO	DATUM	DATS	8	0	IS-M: "Valid To" Date
25	BEDART	☐	VMBEDART	JVMBEDART	CHAR	2	0	IS-M/AM: Requirement Type in Media Sales Agent Contract	TJJ73
26	PROSL_VB	☐	JPROVSCHL	PRSCHL	CHAR	5	0	IS-M/AM: Commission Key for Media Sales Agent	TJH23
27	XPROV	☐	XJPROVI	XFELD	CHAR	1	0	IS-M: Qualifies for Commission Indicator
28	XBONUS	☐	XBONUS1	XFELD	CHAR	1	0	IS-M: Indicator: Qualifies for Bonus 1
29	XBONUS2	☐	XBONUS2	XFELD	CHAR	1	0	IS-M: Indicates: Qualifies for Bonus 2
30	KURZTEXT_K	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
31	JVERMART	☐	JVERMART	JVERMART	CHAR	2	0	IS-M: Media Sales Agent Type: General/City/Special Agent	TJJ09
32	XSTDV	☐	JSTD_VERMV	XFELD	CHAR	1	0	IS-M: Standard Sales Agent Contract Indicator
33	POOLNR	☐	POOLNR	POOLNR	CHAR	6	0	IS-M: Media Sales Agent Pool	JJTPO
34	VGRUP	☐	JVGRUP	JVGRUP	CHAR	6	0	IS-M: Media Sales Agent Contract Grouping	TJJV1
35	XSTDBED	☐	JSTDBED	XFELD	CHAR	1	0	IS-M: Standard Requirement

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JJVVV	BEDART	TJJ73	BEDART	REF	1	CN
2	JJVVV	EKORG	T024E	EKORG	REF	1	CN
3	JJVVV	GPNR_ZE	JGTGPNR	GPNR	REF	1	CN
4	JJVVV	JVERMART	TJJ09	JVERMART	REF	1	CN
5	JJVVV	KALSK	TJJ85	KALSK	REF	1	CN
6	JJVVV	KTGRV	TJJAF	KTGRV	REF	C	CN
7	JJVVV	MANDT	T000	MANDT	KEY	1	CN
8	JJVVV	POOLNR	JJTPO	POOLNR	REF	C	CN
9	JJVVV	PROSL_VB	TJH23	PRSCHL
10	JJVVV	SPART	TVTA	SPART	KEY	1	CN
11	JJVVV	VERM	JJVDB_MV_FK	GPNR	REF	1	CN
12	JJVVV	VGRUP	TJJV1	VGRUP	REF	1	CN
13	JJVVV	VKBUR	TVBUR	VKBUR	REF	C	CN
14	JJVVV	VKORG	TVKO	VKORG	KEY	1	CN
15	JJVVV	VTWEG	TVKOV	VTWEG	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in