SAP ABAP View JJVDB_MVK (IS-M/AM: Media Agent)

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	JJVDB_MVK
Short Description	IS-M/AM: Media Agent
Root table	JGTGPNR	IS-M: Central Business Partner Table

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JGTGPNR	JGTGPNR
2	LFA1

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	LFA1	MANDT	JL	EQ				0	0
2	JGTGPNR	MANDT	JR	EQ			AND	0	0
3	LFA1	LIFNR	JL	EQ				0	0
4	JGTGPNR	LIFNR	JR	EQ			AND	0	0
5	JGTGPNR	XMVERM		NE	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JGTGPNR	MANDT		☐	MANDT	☐	Client
2	GPNR	JGTGPNR	GPNR		☐	GPNR	☐	IS-M: Business Partner Key
3	XGPLOE	JGTGPNR	XGPLOE		☐	JXLV_GP	☐	IS-M: Deletion Flag for General Business Partner
4	XGPLOEKZ	JGTGPNR	XGPLOEKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
5	XGPSPE	JGTGPNR	XGPSPE		☐	XGPSPE	☐	IS-M/SD: Lock Indicator for General Business Partner
6	ERFTIME	JGTGPNR	ERFTIME		☐	ERFTIME	☐	Time Created
7	AENUSER	JGTGPNR	AENUSER		☐	AENUSER	☐	Last Changed By
8	AENDATE	JGTGPNR	AENDATE		☐	AENDATE	☐	Date of Last Change
9	AENTIME	JGTGPNR	AENTIME		☐	AENTIME	☐	Time of Last Change
10	JKTOKD	JGTGPNR	JKTOKD		☐	JKTOKD	☐	IS-M: Business Partner Account Group
11	MAILN	JGTGPNR	MAILN		☐	JMAILN	☐	IS-M: Mail Address
12	BERUFSL	JGTGPNR	BERUFSL		☐	BERUFSL	☐	IS-M: Occupation
13	GFORM	JGTGPNR	GFORM		☐	GFORM	☐	Legal status
14	JBRSCH	JGTGPNR	BRSCH		☐	BRSCH	☐	Industry key
15	BRAN1	JGTGPNR	BRAN1		☐	BRAN1_D	☐	Industry code 1
16	BRAN2	JGTGPNR	BRAN2		☐	BRAN2	☐	Industry code 2
17	BRAN3	JGTGPNR	BRAN3		☐	BRAN3	☐	Industry code 3
18	BRAN4	JGTGPNR	BRAN4		☐	BRAN4	☐	Industry code 4
19	BRAN5	JGTGPNR	BRAN5		☐	BRAN5	☐	Industry code 5
20	JGEBDAT	JGTGPNR	JGEBDAT		☐	JGEBDAT	☐	IS-M: Date of Birth of a Business Partner
21	GESCH	JGTGPNR	GESCH		☐	JGESCHL	☐	IS-M: Gender Key
22	JFAMST	JGTGPNR	JFAMST		☐	JFAMST	☐	IS-M: Business Partner's Marital Status
23	GPHERK	JGTGPNR	GPHERK		☐	GPHERK	☐	IS-M: Business Partner Origin
24	XNATUR	JGTGPNR	XNATUR		☐	XNATUR	☐	IS-M: Natural Person Indicator
25	XVERMSACH	JGTGPNR	XVERMSACH		☐	XVERMSACH	☐	IS-M: BP Authorized to Receive Gifts
26	XOHNE	JGTGPNR	XOHNE		☐	XCPDK	☐	Indicator: Is the account a one-time account?
27	XDEBI	JGTGPNR	XDEBI		☐	JXDEBI	☐	IS-M: Indicator: Customer Exists
28	KUNNR	JGTGPNR	KUNNR		☐	JKUNNR	☐	IS-M: Customer Number in Previous System
29	FKUNNR	JGTGPNR	FKUNNR		☐	JFKUNNR	☐	IS-M: Customer Number in Non-SAP System
30	XKREDI	JGTGPNR	XKREDI		☐	XKREDI	☐	IS-M: Indicator: Vendor Exists
31	LIFNR	JGTGPNR	LIFNR		☐	JLIFNR	☐	IS-M: Vendor Number in Previous System
32	FLIFNR	JGTGPNR	FLIFNR		☐	JFLIFNR	☐	IS-M: Vendor Number in Non-SAP System
33	XMITARB	JGTGPNR	XMITARB		☐	XMITARB	☐	IS-M: Employee Indicator
34	PERNR	JGTGPNR	PERNR		☐	JPERNR2	☐	IS-M: Personnel Number
35	XNOWERB	JGTGPNR	XNOWERB		☐	XNOWERB	☐	IS-M: No Advertising
36	XMVERM	JGTGPNR	XMVERM		☐	XMVERMITTL	☐	IS-M: Media Sales Agent Indicator
37	XMVERMLV	JGTGPNR	XMVERMLV		☐	XMVLV	☐	IS-M: Deletion Flag for Media Sales Agent
38	XMVERMLKZ	JGTGPNR	XMVERMLKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
39	XMVERMSP	JGTGPNR	XMVERMSP		☐	XMVSPE	☐	IS-M: Lock Indicator for Media Sales Agent
40	BON	JGTGPNR	BON		☐	JBONITAET	☐	IS-M: Creditworthiness Indicator
41	ERFDATE	JGTGPNR	ERFDATE		☐	ERFDATE	☐	Created On
42	ERFUSER	JGTGPNR	ERFUSER		☐	ERFUSER	☐	Created By
43	ANRED	LFA1	ANRED		☐	ANRED	☐	Title
44	BAHNS	LFA1	BAHNS		☐	BAHNS	☐	Train station
45	BBBNR	LFA1	BBBNR		☐	BBBNR	☐	International location number (part 1)
46	BBSNR	LFA1	BBSNR		☐	BBSNR	☐	International location number (Part 2)
47	BEGRU	LFA1	BEGRU		☐	BRGRU	☐	Authorization Group
48	BRSCH	LFA1	BRSCH		☐	BRSCH	☐	Industry key
49	BUBKZ	LFA1	BUBKZ		☐	BUBKZ	☐	Check digit for the international location number
50	DATLT	LFA1	DATLT		☐	DATLT	☐	Data communication line no.
51	DTAMS	LFA1	DTAMS		☐	DTAMS	☐	Report key for data medium exchange
52	DTAWS	LFA1	DTAWS		☐	DTAWS	☐	Instruction key for data medium exchange
53	ESRNR	LFA1	ESRNR		☐	ESRNR	☐	POR subscriber number
54	KONZS	LFA1	KONZS		☐	KONZS	☐	Group key
55	KTOKK	LFA1	KTOKK		☐	KTOKK	☐	Vendor account group
56	LAND1	LFA1	LAND1		☐	LAND1_GP	☐	Country Key
57	LNRZA	LFA1	LNRZA		☐	LNRZA	☐	Account Number of the Alternative Payee
58	LOEVM	LFA1	LOEVM		☐	LOEVM_X	☐	Central Deletion Flag for Master Record
59	SORTL	LFA1	SORTL		☐	SORTL	☐	Sort field
60	SPERR	LFA1	SPERR		☐	SPERB_X	☐	Central posting block
61	SPERM	LFA1	SPERM		☐	SPERM_X	☐	Centrally imposed purchasing block
62	SPRAS	LFA1	SPRAS		☐	SPRAS	☐	Language Key
63	STCD1	LFA1	STCD1		☐	STCD1	☐	Tax Number 1
64	STCD2	LFA1	STCD2		☐	STCD2	☐	Tax Number 2
65	STKZA	LFA1	STKZA		☐	STKZA	☐	Indicator: Business Partner Subject to Equalization Tax?
66	STKZU	LFA1	STKZU		☐	STKZU	☐	Liable for VAT
67	XCPDK	LFA1	XCPDK		☐	XCPDK	☐	Indicator: Is the account a one-time account?
68	XZEMP	LFA1	XZEMP		☐	XZEMP	☐	Indicator: Alternative payee in document allowed ?
69	VBUND	LFA1	VBUND		☐	RASSC	☐	Company ID of trading partner
70	FISKN	LFA1	FISKN		☐	FISKN_K	☐	Account number of the master record with fiscal address
71	STCEG	LFA1	STCEG		☐	STCEG	☐	VAT Registration Number
72	STKZN	LFA1	STKZN		☐	STKZN	☐	Natural Person
73	SPERQ	LFA1	SPERQ		☐	QSPERRFKT	☐	Function That Will Be Blocked
74	GP_DUB	JGTGPNR	GP_DUB		☐	JDUBIOS	☐	IS-M: Credit Query Indicator

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