SAP ABAP View JJVVV (IS-M/AM: DB View of Sales Agent Contract)

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	JJVVV
Short Description	IS-M/AM: DB View of Sales Agent Contract
Root table	JJTVV	IS-M/AM: Media Sales Agent Contract

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JJTVV	JJTVV
2	JJTVB
3	JJTVT

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	JJTVB	MANDT	JR	EQ			AND	0	0
3	JJTVV	VNR	JL	EQ				0	0
4	JJTVB	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				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JJTVV	MANDT		☐	MANDT	☐	Client
2	VNR	JJTVV	VNR		☐	JVMVVNR	☐	IS-M: Media Sales Agent Contract Number
3	BEDNR	JJTVB	BEDNR		☐	VM_BEDNR	☐	IS-M: Number of Media Sales Agent Contract Requirement
4	VKORG	JJTVT	VKORG		☐	VKORG	☐	Sales Organization
5	VTWEG	JJTVT	VTWEG		☐	VTWEG	☐	Distribution Channel
6	SPART	JJTVT	SPART		☐	SPART	☐	Division
7	VERM	JJTVV	VERM		☐	VERM_MEDIA	☐	IS-M: Media Sales Agent
8	EKORG	JJTVV	EKORG		☐	EKORG	☐	Purchasing organization
9	VKBUR	JJTVV	VKBUR		☐	VKBUR	☐	Sales office
10	KALSK	JJTVV	KALSK		☐	JKALKSK	☐	IS-M: Sales Agent Det.Proc. (for Pricing Proc.Determination)
11	PERNR	JJTVV	PERNR		☐	JJPERNR	☐	IS-M: Personnel Number
12	GPNR_ZE	JJTVV	GPNR_ZE		☐	GPNR_ZE	☐	IS-M/SD: Business Partner Alternative Payee
13	UEBERLART	JJTVV	UEBERLART		☐	UEBERLZIEL	☐	IS-M: Transfer Destination
14	ERFUSER	JJTVV	ERFUSER		☐	ERFUSER	☐	Created By
15	ERFDATE	JJTVV	ERFDATE		☐	ERFDATE	☐	Created On
16	ERFTIME	JJTVV	ERFTIME		☐	ERFTIME	☐	Time Created
17	AENUSER	JJTVV	AENUSER		☐	AENUSER	☐	Last Changed By
18	AENDATE	JJTVV	AENDATE		☐	AENDATE	☐	Date of Last Change
19	AENTIME	JJTVV	AENTIME		☐	AENTIME	☐	Time of Last Change
20	KURZTEXT	JJTVV	KURZTEXT		☐	BEZEICHN15	☐	IS-M: Short Text
21	VTYP	JJTVV	VTYP		☐	JVERMVTYP	☐	IS-M: Contract Category for Media Sales Agent Contract
22	KTGRV	JJTVV	KTGRV		☐	KTGRV	☐	IS-M: Account Assignment Group for Sales Agent Contract
23	GUELTIGAB	JJTVB	GUELTIGAB		☐	DATEVALFRM	☐	IS-M: "Valid From" Date
24	GUELTIGBIS	JJTVB	GUELTIGBIS		☐	DATEVALTO	☐	IS-M: "Valid To" Date
25	BEDART	JJTVB	BEDART		☐	VMBEDART	☐	IS-M/AM: Requirement Type in Media Sales Agent Contract
26	PROSL_VB	JJTVB	PROSL		☐	JPROVSCHL	☐	IS-M/AM: Commission Key for Media Sales Agent
27	XPROV	JJTVB	XPROV		☐	XJPROVI	☐	IS-M: Qualifies for Commission Indicator
28	XBONUS	JJTVB	XBONUS		☐	XBONUS1	☐	IS-M: Indicator: Qualifies for Bonus 1
29	XBONUS2	JJTVB	XBONUS2		☐	XBONUS2	☐	IS-M: Indicates: Qualifies for Bonus 2
30	KURZTEXT_K	JJTVB	KURZTEXT		☐	BEZEICHN15	☐	IS-M: Short Text
31	JVERMART	JJTVB	JVERMART		☐	JVERMART	☐	IS-M: Media Sales Agent Type: General/City/Special Agent
32	XSTDV	JJTVV	XSTDV		☐	JSTD_VERMV	☐	IS-M: Standard Sales Agent Contract Indicator
33	POOLNR	JJTVV	POOLNR		☐	POOLNR	☐	IS-M: Media Sales Agent Pool
34	VGRUP	JJTVV	VGRUP		☐	JVGRUP	☐	IS-M: Media Sales Agent Contract Grouping
35	XSTDBED	JJTVB	XSTDBED		☐	JSTDBED	☐	IS-M: Standard Requirement

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