SAP ABAP Table JJVVTVB (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JJVVTVB	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	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
3	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
4	SPART	☑	SPART	SPART	CHAR	2	0	Division	TVTA
5	VNR	☑	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
6	BEDNR	☑	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement	JJTVB
7	VTYP	☐	JVERMVTYP	JVERMVTYP	CHAR	1	0	IS-M: Contract Category for Media Sales Agent Contract
8	VERM	☐	VERM_MEDIA	GPNR	CHAR	10	0	IS-M: Media Sales Agent	JJVDB_MV_FK
9	XSTDV	☐	JSTD_VERMV	XFELD	CHAR	1	0	IS-M: Standard Sales Agent Contract Indicator
10	BO1SL	☐	JJBONSCHL1	PRSCHL	CHAR	5	0	IS-M/AM: Bonus 1: Commission Key for Media Sales Agent	TJH23
11	BO2SL	☐	JJBONSCHL2	PRSCHL	CHAR	5	0	IS-M: Bonus 2: Commission Key for Media Sales Agent	TJH23
12	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
13	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
14	KTEXT_VV	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
15	GUELTIGAB	☐	DATEVALFRM	DATUM	DATS	8	0	IS-M: "Valid From" Date
16	GUELTIGBIS	☐	DATEVALTO	DATUM	DATS	8	0	IS-M: "Valid To" Date
17	BEDART	☐	VMBEDART	JVMBEDART	CHAR	2	0	IS-M/AM: Requirement Type in Media Sales Agent Contract	TJJ73
18	BEDGR	☐	BEDGR	BEDGR	CHAR	2	0	IS-M: Media Sales Agent Requirement Group	TJJ77
19	XSTDBED	☐	JSTDBED	XFELD	CHAR	1	0	IS-M: Standard Requirement
20	PROSL	☐	JPROVSCHL	PRSCHL	CHAR	5	0	IS-M/AM: Commission Key for Media Sales Agent	TJH23
21	XPROV	☐	XJPROVI	XFELD	CHAR	1	0	IS-M: Qualifies for Commission Indicator
22	XBONUS	☐	XBONUS1	XFELD	CHAR	1	0	IS-M: Indicator: Qualifies for Bonus 1
23	XBONUS2	☐	XBONUS2	XFELD	CHAR	1	0	IS-M: Indicates: Qualifies for Bonus 2
24	XSTEIG	☐	XJSTEIG	XFELD	CHAR	1	0	IS-M: Can be Incremented Indicator
25	XBERICHT	☐	XBESBERICH	ISM_XBESBERICH	CHAR	1	0	IS-M/AM: Report Required, Reference to Partner (Role)
26	XVORAUS	☐	XJVORAUS	XFELD	CHAR	1	0	IS-M: Payment Granted in Advance
27	JVERMART	☐	JVERMART	JVERMART	CHAR	2	0	IS-M: Media Sales Agent Type: General/City/Special Agent	TJJ09
28	KTEXT_VB	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
29	LAST_BESNR	☐	JBESTNR_EX	JBESTNR_EX	NUMC	6	0	IS-M: Element Number in Media Agent Contract

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JJVVTVB	BEDART	TJJ73	BEDART	REF	1	CN
2	JJVVTVB	BEDGR	TJJ77	BEDGR	REF	1	CN
3	JJVVTVB	BEDNR	JJTVB	BEDNR	KEY	1	CN
4	JJVVTVB	BO1SL	TJH23	PRSCHL	REF	C	CN
5	JJVVTVB	BO2SL	TJH23	PRSCHL	REF	C	CN
6	JJVVTVB	JVERMART	TJJ09	JVERMART	REF	1	CN
7	JJVVTVB	KURST	TCURV	KURST
8	JJVVTVB	MANDT	T000	MANDT	KEY	1	CN
9	JJVVTVB	PROSL	TJH23	PRSCHL
10	JJVVTVB	SPART	TVTA	SPART	KEY	1	CN
11	JJVVTVB	VERM	JJVDB_MV_FK	GPNR	REF	1	CN
12	JJVVTVB	VKORG	TVKO	VKORG	KEY	1	CN
13	JJVVTVB	VNR	JJTVV	VNR	KEY	1	CN
14	JJVVTVB	VTWEG	TVKOV	VTWEG	KEY	1	CN
15	JJVVTVB	WAERS	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in