SAP ABAP View JJVVTBB (IS-M/AM: Requirement Elements for the 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

View Type	D	Database View
Database View	JJVVTBB
Short Description	IS-M/AM: Requirement Elements for the Sales Area
Root table	JJTVT	Requirement - Sales Area Assignment (Media Sales Agent)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JJTVT	JJTVT
2	JJTBB

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JJTBB	MANDT	JL	EQ				0	0
2	JJTVT	MANDT	JR	EQ			AND	0	0
3	JJTBB	VNR	JL	EQ				0	0
4	JJTVT	VNR	JR	EQ			AND	0	0
5	JJTBB	BEDNR	JL	EQ				0	0
6	JJTVT	BEDNR	JR	EQ			AND	0	0
7	JJTBB	XLOEVM		EQ	' '		AND	0	0
8	JJTBB	XLOEKZ		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JJTVT	MANDT		☐	MANDT	☐	Client
2	VKORG	JJTVT	VKORG		☐	VKORG	☐	Sales Organization
3	VTWEG	JJTVT	VTWEG		☐	VTWEG	☐	Distribution Channel
4	SPART	JJTVT	SPART		☐	SPART	☐	Division
5	VNR	JJTVT	VNR		☐	JVMVVNR	☐	IS-M: Media Sales Agent Contract Number
6	BEDNR	JJTVT	BEDNR		☐	VM_BEDNR	☐	IS-M: Number of Media Sales Agent Contract Requirement
7	BESNREXT	JJTBB	BESNREXT		☐	JBESTNR_EX	☐	IS-M: Element Number in Media Agent Contract
8	ZUOFUNKT	JJTBB	ZUOFUNKT		☐	JZFKT	☐	IS-M: Assignment Function (Inclusive, Exclusive)
9	BELEINH	JJTBB	BELEINH		☐	BELEGEINH	☐	IS-M/AM: Booking Unit
10	INHK_TECH2	JJTBB	INHK_TECH2		☐	INHK_SOVER	☐	IS-M: Special Publication Content Component
11	INHK_KFM	JJTBB	INHK_KFM		☐	INHK_KFM	☐	IS-M: Business Content Component
12	AVMPOS_ART	JJTBB	AVMPOS_ART		☐	AVMPOS_ART	☐	IS-M: Order-Publishing-Media - Item Type
13	BRAN1	JJTBB	BRAN1		☐	BRAN_PAM	☐	IS-M: Industry Sector for Advertiser
14	KUKARR	JJTBB	KUKARR		☐	JKUKARR	☐	IS-M: Customer Profile
15	IN_GPNR	JJTBB	IN_GPNR		☐	INSERENT	☐	IS-M: Advertiser
16	AR_GPNR	JJTBB	AR_GPNR		☐	AGENTUR	☐	IS-M: Agency
17	BEZIRK_AG	JJTBB	BEZIRK_AG		☐	VERMBEZ_AG	☐	IS-M: Sales Agent Zone of the Agency
18	BEZIRK_IS	JJTBB	BEZIRK_IS		☐	VERMBEZ_IS	☐	IS-M: Sales Agent Zone of Advertiser
19	PRDHA	JJTBB	PRDHA		☐	J_PRODH	☐	IS-M/AM: Product Hierarchy
20	VTNR	JJTBB	VTNR		☐	ABS_VTNR	☐	IS-M: Contract Number
21	MATNR	JJTBB	MATNR		☐	MATNR_DIEN	☐	IS-M: Service material number
22	DIENTYP	JJTBB	DIENTYP		☐	DIENTYP	☐	IS-M: Service Type
23	FATBB1	JJTBB	FATBB1		☐	JJFATBB1	☐	IS-M: Free Attribute 1 Requirement Element
24	FATBB2	JJTBB	FATBB2		☐	JJFATBB2	☐	IS-M: Free Attribute 2 Requirement Element
25	FATBB3	JJTBB	FATBB3		☐	JJFATBB3	☐	IS-M: Free Attribute 3 Requirement Element
26	FATBB4	JJTBB	FATBB4		☐	JJFATBB4	☐	IS-M: Free Attribute 4 Requirement Element
27	FATBB5	JJTBB	FATBB5		☐	JJFATBB5	☐	IS-M: Free Attribute 5 Requirement Element
28	FATBB6	JJTBB	FATBB6		☐	JJFATBB6	☐	IS-M: Free Attribute 6 Requirement Element
29	FATBB7	JJTBB	FATBB7		☐	JJFATBB7	☐	IS-M: Free Attribute 7 Requirement Element
30	ABW_GUEAB	JJTBB	ABW_GUEAB		☐	DIFFDATEFR	☐	IS-M: "Valid-From" Date Within Higher-Level Validity Period
31	ABW_GUEBIS	JJTBB	ABW_GUEBIS		☐	DIFFDATETO	☐	IS-M: "Valid To" Date Within Higher Level Validity

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	20050224
SAP Release Created in