SAP ABAP View JJVVAUS (IS-M: SELECT 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	D	Database View
Database View	JJVVAUS
Short Description	IS-M: SELECT 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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JJTVA	XLOESCHVM		EQ	' '		AND	0	0
2	JJTVA	XLOESCHKZ		EQ	' '		AND	0	0
3	JJTVA	ZUOFUNKT		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		☐	VKORG	☐	Sales Organization
3	VTWEG	JJTVA	VTWEG		☐	VTWEG	☐	Distribution Channel
4	SPART	JJTVA	SPART		☐	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	KURZTEXT	JJTVA	KURZTEXT		☐	BEZEICHN15	☐	IS-M: Short Text
9	ZUOFUNKT	JJTVA	ZUOFUNKT		☐	JZFKT	☐	IS-M: Assignment Function (Inclusive, Exclusive)
10	BELEINH	JJTVA	BELEINH		☐	BELEGEINH	☐	IS-M/AM: Booking Unit
11	INHK_TECH2	JJTVA	INHK_TECH2		☐	INHK_SOVER	☐	IS-M: Special Publication Content Component
12	INHK_KFM	JJTVA	INHK_KFM		☐	INHK_KFM	☐	IS-M: Business Content Component
13	AVMPOS_ART	JJTVA	AVMPOS_ART		☐	AVMPOS_ART	☐	IS-M: Order-Publishing-Media - Item Type
14	BRAN1	JJTVA	BRAN1		☐	BRAN_PAM	☐	IS-M: Industry Sector for Advertiser
15	KUKARR	JJTVA	KUKARR		☐	JKUKARR	☐	IS-M: Customer Profile
16	IN_GPNR	JJTVA	IN_GPNR		☐	INSERENT	☐	IS-M: Advertiser
17	AR_GPNR	JJTVA	AR_GPNR		☐	AGENTUR	☐	IS-M: Agency
18	BEZIRK_AG	JJTVA	BEZIRK_AG		☐	VERMBEZ_AG	☐	IS-M: Sales Agent Zone of the Agency
19	BEZIRK_IS	JJTVA	BEZIRK_IS		☐	VERMBEZ_IS	☐	IS-M: Sales Agent Zone of Advertiser
20	PRDHA	JJTVA	PRDHA		☐	J_PRODH	☐	IS-M/AM: Product Hierarchy
21	VTNR	JJTVA	VTNR		☐	ABS_VTNR	☐	IS-M: Contract Number
22	MATNR	JJTVA	MATNR		☐	MATNR_DIEN	☐	IS-M: Service material number
23	DIENTYP	JJTVA	DIENTYP		☐	DIENTYP	☐	IS-M: Service Type
24	FATBB1	JJTVA	FATBB1		☐	JJFATBB1	☐	IS-M: Free Attribute 1 Requirement Element
25	FATBB2	JJTVA	FATBB2		☐	JJFATBB2	☐	IS-M: Free Attribute 2 Requirement Element
26	FATBB3	JJTVA	FATBB3		☐	JJFATBB3	☐	IS-M: Free Attribute 3 Requirement Element
27	FATBB4	JJTVA	FATBB4		☐	JJFATBB4	☐	IS-M: Free Attribute 4 Requirement Element
28	FATBB5	JJTVA	FATBB5		☐	JJFATBB5	☐	IS-M: Free Attribute 5 Requirement Element
29	FATBB6	JJTVA	FATBB6		☐	JJFATBB6	☐	IS-M: Free Attribute 6 Requirement Element
30	FATBB7	JJTVA	FATBB7		☐	JJFATBB7	☐	IS-M: Free Attribute 7 Requirement Element

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	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in