SAP ABAP Table JJVVA (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	TVTW
4	SPART	☑	SPART	SPART	CHAR	2	0	Division	TSPA
5	VANR	☑	JVANR	JVANR	CHAR	5	0	IS-M: Extra commission/exclusion
6	GUELTIGAB	☐	DATEVALFRM	DATUM	DATS	8	0	IS-M: "Valid From" Date
7	GUELTIGBIS	☐	DATEVALTO	DATUM	DATS	8	0	IS-M: "Valid To" Date
8	XLOESCHVM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
9	KURZTEXT	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
10	ZUOFUNKT	☐	JZFKT	JZUORDFUNK	CHAR	1	0	IS-M: Assignment Function (Inclusive, Exclusive)
11	BELEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	JJTBE
12	INHK_TECH2	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	JJTIKO
13	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
14	AVMPOS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
15	BRAN1	☐	BRAN_PAM	BRACO	CHAR	10	0	IS-M: Industry Sector for Advertiser	TBRC
16	KUKARR	☐	JKUKARR	JKUKARR	CHAR	2	0	IS-M: Customer Profile	TJJ95
17	IN_GPNR	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JJVDB_MK_FK
18	AR_GPNR	☐	AGENTUR	GPNR	CHAR	10	0	IS-M: Agency	JGTGPNR
19	BEZIRK_AG	☐	VERMBEZ_AG	BEZIRK	CHAR	10	0	IS-M: Sales Agent Zone of the Agency	JVTBEZIRK
20	BEZIRK_IS	☐	VERMBEZ_IS	BEZIRK	CHAR	10	0	IS-M: Sales Agent Zone of Advertiser	JVTBEZIRK
21	PRDHA	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	JJT179
22	VTNR	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
23	MATNR	☐	MATNR_DIEN	MATNR_DIEN	CHAR	18	0	IS-M: Service material number	JJTDIEN
24	DIENTYP	☐	DIENTYP	DIENTYP	CHAR	4	0	IS-M: Service Type	TJH71
25	FATBB1	☐	JJFATBB1	JJFATBB1	CHAR	1	0	IS-M: Free Attribute 1 Requirement Element	TJJFA
26	FATBB2	☐	JJFATBB2	JJFATBB2	CHAR	1	0	IS-M: Free Attribute 2 Requirement Element	TJJFC
27	FATBB3	☐	JJFATBB3	JJFATBB3	CHAR	1	0	IS-M: Free Attribute 3 Requirement Element	TJJFE
28	FATBB4	☐	JJFATBB4	JJFATBB4	CHAR	2	0	IS-M: Free Attribute 4 Requirement Element	TJJFG
29	FATBB5	☐	JJFATBB5	JJFATBB5	CHAR	2	0	IS-M: Free Attribute 5 Requirement Element	TJJFI
30	FATBB6	☐	JJFATBB6	JJFATBB6	CHAR	4	0	IS-M: Free Attribute 6 Requirement Element	TJJFK
31	FATBB7	☐	JJFATBB7	JJFATBB7	CHAR	10	0	IS-M: Free Attribute 7 Requirement Element	TJJFM
32	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
33	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
34	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
35	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
36	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
37	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
38	VKORGT	☐	VTXTK	TEXT20	CHAR	20	0	Name
39	VTWEGT	☐	VTXTK	TEXT20	CHAR	20	0	Name
40	SPARTT	☐	VTXTK	TEXT20	CHAR	20	0	Name

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JJVVA	AR_GPNR	JGTGPNR	GPNR
2	JJVVA	AVMPOS_ART	TJH17	AVMPOS_ART
3	JJVVA	BELEINH	JJTBE	BELEINH
4	JJVVA	BEZIRK_AG	JVTBEZIRK	BEZIRK
5	JJVVA	BEZIRK_IS	JVTBEZIRK	BEZIRK
6	JJVVA	BRAN1	TBRC	BRACO
7	JJVVA	DIENTYP	TJH71	DIENTYP
8	JJVVA	FATBB1	TJJFA	FATBB1	REF	1	CN
9	JJVVA	FATBB2	TJJFC	FATBB2	REF	1	CN
10	JJVVA	FATBB3	TJJFE	FATBB3	REF	1	CN
11	JJVVA	FATBB4	TJJFG	FATBB4	REF	1	CN
12	JJVVA	FATBB5	TJJFI	FATBB5	REF	1	CN
13	JJVVA	FATBB6	TJJFK	FATBB6	REF	1	CN
14	JJVVA	FATBB7	TJJFM	FATBB7	REF	1	CN
15	JJVVA	INHK_KFM	JJTIKO	INHALTSKOM
16	JJVVA	INHK_TECH2	JJTIKO	INHALTSKOM
17	JJVVA	IN_GPNR	JJVDB_MK_FK	GPNR
18	JJVVA	KUKARR	TJJ95	KUKARR	REF	C	CN
19	JJVVA	MANDT	T000	MANDT	KEY	1	CN
20	JJVVA	MATNR	JJTDIEN	MATNR
21	JJVVA	PRDHA	JJT179	PRODH
22	JJVVA	SPART	TSPA	SPART	KEY	1	CN
23	JJVVA	VKORG	TVKO	VKORG	KEY	1	CN
24	JJVVA	VTNR	JHTVKO	VTNR
25	JJVVA	VTWEG	TVTW	VTWEG	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in