SAP ABAP Table JJVVAUS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JJVVAUS	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	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	KURZTEXT	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
9	ZUOFUNKT	☐	JZFKT	JZUORDFUNK	CHAR	1	0	IS-M: Assignment Function (Inclusive, Exclusive)
10	BELEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	JJTBE
11	INHK_TECH2	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	JJTIKO
12	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
13	AVMPOS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
14	BRAN1	☐	BRAN_PAM	BRACO	CHAR	10	0	IS-M: Industry Sector for Advertiser	TBRC
15	KUKARR	☐	JKUKARR	JKUKARR	CHAR	2	0	IS-M: Customer Profile	TJJ95
16	IN_GPNR	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JJVDB_MK_FK
17	AR_GPNR	☐	AGENTUR	GPNR	CHAR	10	0	IS-M: Agency	JGTGPNR
18	BEZIRK_AG	☐	VERMBEZ_AG	BEZIRK	CHAR	10	0	IS-M: Sales Agent Zone of the Agency	JVTBEZIRK
19	BEZIRK_IS	☐	VERMBEZ_IS	BEZIRK	CHAR	10	0	IS-M: Sales Agent Zone of Advertiser	JVTBEZIRK
20	PRDHA	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	JJT179
21	VTNR	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
22	MATNR	☐	MATNR_DIEN	MATNR_DIEN	CHAR	18	0	IS-M: Service material number	JJTDIEN
23	DIENTYP	☐	DIENTYP	DIENTYP	CHAR	4	0	IS-M: Service Type	TJH71
24	FATBB1	☐	JJFATBB1	JJFATBB1	CHAR	1	0	IS-M: Free Attribute 1 Requirement Element	TJJFA
25	FATBB2	☐	JJFATBB2	JJFATBB2	CHAR	1	0	IS-M: Free Attribute 2 Requirement Element	TJJFC
26	FATBB3	☐	JJFATBB3	JJFATBB3	CHAR	1	0	IS-M: Free Attribute 3 Requirement Element	TJJFE
27	FATBB4	☐	JJFATBB4	JJFATBB4	CHAR	2	0	IS-M: Free Attribute 4 Requirement Element	TJJFG
28	FATBB5	☐	JJFATBB5	JJFATBB5	CHAR	2	0	IS-M: Free Attribute 5 Requirement Element	TJJFI
29	FATBB6	☐	JJFATBB6	JJFATBB6	CHAR	4	0	IS-M: Free Attribute 6 Requirement Element	TJJFK
30	FATBB7	☐	JJFATBB7	JJFATBB7	CHAR	10	0	IS-M: Free Attribute 7 Requirement Element	TJJFM

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in