SAP ABAP Table JJTVA (Incl/Exclusive Sales Agt Requirements for Entire Sales Area)

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	JJTVA	Table Relationship Diagram
Short Description	Incl/Exclusive Sales Agt Requirements for Entire Sales Area

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	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	XLOESCHKZ	☐	LOEKZ_ISP	XFELD	CHAR	1	0	Deletion Indicator for Master Data in Media Sales & Dist.
10	BEDART	☐	JJBEDARTZP	JVMBEDART	CHAR	2	0	IS-M: Requirement Type for Extra Commission Entitlement	TJJ73
11	BEDGR	☐	BEDGR	BEDGR	CHAR	2	0	IS-M: Media Sales Agent Requirement Group	TJJ77
12	PROSL	☐	JPROVSCHL	PRSCHL	CHAR	5	0	IS-M/AM: Commission Key for Media Sales Agent	TJH23
13	.INCLUDE	☐				0	0	IS-M: Short and Long Texts
14	KURZTEXT	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
15	LANGTEXT	☐	BEZEICHN50	TEXT50	CHAR	50	0	IS-M: Long Text
16	.INCLUDE	☐				0	0	IS-M/AM: Requirement Elements (Content)
17	ZUOFUNKT	☐	JZFKT	JZUORDFUNK	CHAR	1	0	IS-M: Assignment Function (Inclusive, Exclusive)
18	BELEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	JJTBE
19	INHK_TECH2	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	JJTIKO
20	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
21	AVMPOS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
22	BRAN1	☐	BRAN_PAM	BRACO	CHAR	10	0	IS-M: Industry Sector for Advertiser	TBRC
23	KUKARR	☐	JKUKARR	JKUKARR	CHAR	2	0	IS-M: Customer Profile	TJJ95
24	IN_GPNR	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JJVDB_MK_FK
25	AR_GPNR	☐	AGENTUR	GPNR	CHAR	10	0	IS-M: Agency	JGTGPNR
26	BEZIRK_AG	☐	VERMBEZ_AG	BEZIRK	CHAR	10	0	IS-M: Sales Agent Zone of the Agency	JVTBEZIRK
27	BEZIRK_IS	☐	VERMBEZ_IS	BEZIRK	CHAR	10	0	IS-M: Sales Agent Zone of Advertiser	JVTBEZIRK
28	PRDHA	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	JJT179
29	VTNR	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
30	MATNR	☐	MATNR_DIEN	MATNR_DIEN	CHAR	18	0	IS-M: Service material number	JJTDIEN
31	DIENTYP	☐	DIENTYP	DIENTYP	CHAR	4	0	IS-M: Service Type	TJH71
32	.INCLUDE	☐				0	0	IS-PAM: Requirement elements (dat part: cust.exist)
33	FATBB1	☐	JJFATBB1	JJFATBB1	CHAR	1	0	IS-M: Free Attribute 1 Requirement Element	TJJFA
34	FATBB2	☐	JJFATBB2	JJFATBB2	CHAR	1	0	IS-M: Free Attribute 2 Requirement Element	TJJFC
35	FATBB3	☐	JJFATBB3	JJFATBB3	CHAR	1	0	IS-M: Free Attribute 3 Requirement Element	TJJFE
36	FATBB4	☐	JJFATBB4	JJFATBB4	CHAR	2	0	IS-M: Free Attribute 4 Requirement Element	TJJFG
37	FATBB5	☐	JJFATBB5	JJFATBB5	CHAR	2	0	IS-M: Free Attribute 5 Requirement Element	TJJFI
38	FATBB6	☐	JJFATBB6	JJFATBB6	CHAR	4	0	IS-M: Free Attribute 6 Requirement Element	TJJFK
39	FATBB7	☐	JJFATBB7	JJFATBB7	CHAR	10	0	IS-M: Free Attribute 7 Requirement Element	TJJFM
40	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
41	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
42	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
43	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
44	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
45	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
46	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in