SAP ABAP View JJVVA (IS-M: Cross-Sales-Area Exclusion Requirement)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***

Basic Data

View Type	C	Maintenance View
Maintenance View	JJVVA
Short Description	IS-M: Cross-Sales-Area Exclusion Requirement
Root table	JJTVA	Incl/Exclusive Sales Agt Requirements for Entire Sales Area

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JJTVA	JJTVA
2	TVKO	JJTVA	VKORG	E
3	TVKOT	TVKO	VKORG	I
4	TVTW	JJTVA	VTWEG	E
5	TVTWT	TVTW	VTWEG	I
6	TSPA	JJTVA	SPART	E
7	TSPAT	TSPA	SPART	I

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JJTVA	ZUOFUNKT		EQ	'-'		AND	0	0
2	JJTVA	XLOESCHKZ		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JJTVA	MANDT		☐	MANDT	☐	Client
2	VKORG	JJTVA	VKORG	S	☐	VKORG	☐	Sales Organization
3	VTWEG	JJTVA	VTWEG	S	☐	VTWEG	☐	Distribution Channel
4	SPART	JJTVA	SPART	S	☐	SPART	☐	Division
5	VANR	JJTVA	VANR		☐	JVANR	☐	IS-M: Extra commission/exclusion
6	GUELTIGAB	JJTVA	GUELTIGAB		☐	DATEVALFRM	☐	IS-M: "Valid From" Date
7	GUELTIGBIS	JJTVA	GUELTIGBIS		☐	DATEVALTO	☐	IS-M: "Valid To" Date
8	XLOESCHVM	JJTVA	XLOESCHVM		☐	LOEVM_ISP	☐	Deletion Flag for Master Data in Media Sales & Distribution
9	KURZTEXT	JJTVA	KURZTEXT		☐	BEZEICHN15	☐	IS-M: Short Text
10	ZUOFUNKT	JJTVA	ZUOFUNKT	H	☐	JZFKT	☐	IS-M: Assignment Function (Inclusive, Exclusive)
11	BELEINH	JJTVA	BELEINH		☐	BELEGEINH	☐	IS-M/AM: Booking Unit
12	INHK_TECH2	JJTVA	INHK_TECH2		☐	INHK_SOVER	☐	IS-M: Special Publication Content Component
13	INHK_KFM	JJTVA	INHK_KFM		☐	INHK_KFM	☐	IS-M: Business Content Component
14	AVMPOS_ART	JJTVA	AVMPOS_ART		☐	AVMPOS_ART	☐	IS-M: Order-Publishing-Media - Item Type
15	BRAN1	JJTVA	BRAN1		☐	BRAN_PAM	☐	IS-M: Industry Sector for Advertiser
16	KUKARR	JJTVA	KUKARR		☐	JKUKARR	☐	IS-M: Customer Profile
17	IN_GPNR	JJTVA	IN_GPNR		☐	INSERENT	☐	IS-M: Advertiser
18	AR_GPNR	JJTVA	AR_GPNR		☐	AGENTUR	☐	IS-M: Agency
19	BEZIRK_AG	JJTVA	BEZIRK_AG		☐	VERMBEZ_AG	☐	IS-M: Sales Agent Zone of the Agency
20	BEZIRK_IS	JJTVA	BEZIRK_IS		☐	VERMBEZ_IS	☐	IS-M: Sales Agent Zone of Advertiser
21	PRDHA	JJTVA	PRDHA		☐	J_PRODH	☐	IS-M/AM: Product Hierarchy
22	VTNR	JJTVA	VTNR		☐	ABS_VTNR	☐	IS-M: Contract Number
23	MATNR	JJTVA	MATNR		☐	MATNR_DIEN	☐	IS-M: Service material number
24	DIENTYP	JJTVA	DIENTYP		☐	DIENTYP	☐	IS-M: Service Type
25	FATBB1	JJTVA	FATBB1		☐	JJFATBB1	☐	IS-M: Free Attribute 1 Requirement Element
26	FATBB2	JJTVA	FATBB2		☐	JJFATBB2	☐	IS-M: Free Attribute 2 Requirement Element
27	FATBB3	JJTVA	FATBB3		☐	JJFATBB3	☐	IS-M: Free Attribute 3 Requirement Element
28	FATBB4	JJTVA	FATBB4		☐	JJFATBB4	☐	IS-M: Free Attribute 4 Requirement Element
29	FATBB5	JJTVA	FATBB5		☐	JJFATBB5	☐	IS-M: Free Attribute 5 Requirement Element
30	FATBB6	JJTVA	FATBB6		☐	JJFATBB6	☐	IS-M: Free Attribute 6 Requirement Element
31	FATBB7	JJTVA	FATBB7		☐	JJFATBB7	☐	IS-M: Free Attribute 7 Requirement Element
32	ERFUSER	JJTVA	ERFUSER		☐	ERFUSER	☐	Created By
33	ERFDATE	JJTVA	ERFDATE		☐	ERFDATE	☐	Created On
34	ERFTIME	JJTVA	ERFTIME		☐	ERFTIME	☐	Time Created
35	AENUSER	JJTVA	AENUSER		☐	AENUSER	☐	Last Changed By
36	AENDATE	JJTVA	AENDATE		☐	AENDATE	☐	Date of Last Change
37	AENTIME	JJTVA	AENTIME		☐	AENTIME	☐	Time of Last Change
38	VKORGT	TVKOT	VTEXT		☐	VTXTK	☐	Name
39	VTWEGT	TVTWT	VTEXT		☐	VTXTK	☐	Name
40	SPARTT	TSPAT	VTEXT		☐	VTXTK	☐	Name

Maintenance Status

Access

☐   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☑   read, change, delete and insert

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

History

Last changed by/on	SAP	20130529
SAP Release Created in