SAP ABAP View JJVVTVB (IS-M/AM: Contract Requirements 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	JJVVTVB
Short Description	IS-M/AM: Contract Requirements 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	JJTVV
3	JJTVB

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JJTVV	MANDT	JL	EQ				0	0
2	JJTVT	MANDT	JR	EQ			AND	0	0
3	JJTVV	VNR	JL	EQ				0	0
4	JJTVT	VNR	JR	EQ			AND	0	0
5	JJTVB	MANDT	JL	EQ				0	0
6	JJTVT	MANDT	JR	EQ			AND	0	0
7	JJTVB	VNR	JL	EQ				0	0
8	JJTVT	VNR	JR	EQ			AND	0	0
9	JJTVB	BEDNR	JL	EQ				0	0
10	JJTVT	BEDNR	JR	EQ			AND	0	0
11	JJTVV	XLOESCHVM		EQ	' '		AND	0	0
12	JJTVV	XLOESCHKZ		EQ	' '		AND	0	0
13	JJTVB	XLOEVM		EQ	' '		AND	0	0
14	JJTVB	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	VTYP	JJTVV	VTYP		☐	JVERMVTYP	☐	IS-M: Contract Category for Media Sales Agent Contract
8	VERM	JJTVV	VERM		☐	VERM_MEDIA	☐	IS-M: Media Sales Agent
9	XSTDV	JJTVV	XSTDV		☐	JSTD_VERMV	☐	IS-M: Standard Sales Agent Contract Indicator
10	BO1SL	JJTVV	BO1SL		☐	JJBONSCHL1	☐	IS-M/AM: Bonus 1: Commission Key for Media Sales Agent
11	BO2SL	JJTVV	BO2SL		☐	JJBONSCHL2	☐	IS-M: Bonus 2: Commission Key for Media Sales Agent
12	WAERS	JJTVV	WAERS		☐	WAERS	☐	Currency Key
13	KURST	JJTVV	KURST		☐	KURST	☐	Exchange Rate Type
14	KTEXT_VV	JJTVV	KURZTEXT		☐	BEZEICHN15	☐	IS-M: Short Text
15	GUELTIGAB	JJTVB	GUELTIGAB		☐	DATEVALFRM	☐	IS-M: "Valid From" Date
16	GUELTIGBIS	JJTVB	GUELTIGBIS		☐	DATEVALTO	☐	IS-M: "Valid To" Date
17	BEDART	JJTVB	BEDART		☐	VMBEDART	☐	IS-M/AM: Requirement Type in Media Sales Agent Contract
18	BEDGR	JJTVB	BEDGR		☐	BEDGR	☐	IS-M: Media Sales Agent Requirement Group
19	XSTDBED	JJTVB	XSTDBED		☐	JSTDBED	☐	IS-M: Standard Requirement
20	PROSL	JJTVB	PROSL		☐	JPROVSCHL	☐	IS-M/AM: Commission Key for Media Sales Agent
21	XPROV	JJTVB	XPROV		☐	XJPROVI	☐	IS-M: Qualifies for Commission Indicator
22	XBONUS	JJTVB	XBONUS		☐	XBONUS1	☐	IS-M: Indicator: Qualifies for Bonus 1
23	XBONUS2	JJTVB	XBONUS2		☐	XBONUS2	☐	IS-M: Indicates: Qualifies for Bonus 2
24	XSTEIG	JJTVB	XSTEIG		☐	XJSTEIG	☐	IS-M: Can be Incremented Indicator
25	XBERICHT	JJTVB	XBERICHT		☐	XBESBERICH	☐	IS-M/AM: Report Required, Reference to Partner (Role)
26	XVORAUS	JJTVB	XVORAUS		☐	XJVORAUS	☐	IS-M: Payment Granted in Advance
27	JVERMART	JJTVB	JVERMART		☐	JVERMART	☐	IS-M: Media Sales Agent Type: General/City/Special Agent
28	KTEXT_VB	JJTVB	KURZTEXT		☐	BEZEICHN15	☐	IS-M: Short Text
29	LAST_BESNR	JJTVB	LAST_BESNR		☐	JBESTNR_EX	☐	IS-M: Element Number in Media Agent Contract

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