SAP ABAP View JJVDB_MV_FK (IS-M/AM: External Key for Media Sales 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_MV_FK
Short Description	IS-M/AM: External Key for Media Sales Agent
Root table	JGTGPNR	IS-M: Central Business Partner Table

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JGTGPNR	XMVERM		NE	' '		AND	0	0
2	JGTGPNR	XMVERMLKZ		EQ	' '		AND	0	0
3	JGTGPNR	XGPLOEKZ		EQ	' '			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	ERFUSER	JGTGPNR	ERFUSER		☐	ERFUSER	☐	Created By
7	ERFDATE	JGTGPNR	ERFDATE		☐	ERFDATE	☐	Created On
8	ERFTIME	JGTGPNR	ERFTIME		☐	ERFTIME	☐	Time Created
9	AENUSER	JGTGPNR	AENUSER		☐	AENUSER	☐	Last Changed By
10	AENDATE	JGTGPNR	AENDATE		☐	AENDATE	☐	Date of Last Change
11	AENTIME	JGTGPNR	AENTIME		☐	AENTIME	☐	Time of Last Change
12	JKTOKD	JGTGPNR	JKTOKD		☐	JKTOKD	☐	IS-M: Business Partner Account Group
13	MAILN	JGTGPNR	MAILN		☐	JMAILN	☐	IS-M: Mail Address
14	BEGRU	JGTGPNR	BEGRU		☐	BRGRU	☐	Authorization Group
15	BERUFSL	JGTGPNR	BERUFSL		☐	BERUFSL	☐	IS-M: Occupation
16	GFORM	JGTGPNR	GFORM		☐	GFORM	☐	Legal status
17	BRSCH	JGTGPNR	BRSCH		☐	BRSCH	☐	Industry key
18	BRAN1	JGTGPNR	BRAN1		☐	BRAN1_D	☐	Industry code 1
19	BRAN2	JGTGPNR	BRAN2		☐	BRAN2	☐	Industry code 2
20	BRAN3	JGTGPNR	BRAN3		☐	BRAN3	☐	Industry code 3
21	BRAN4	JGTGPNR	BRAN4		☐	BRAN4	☐	Industry code 4
22	BRAN5	JGTGPNR	BRAN5		☐	BRAN5	☐	Industry code 5
23	JGEBDAT	JGTGPNR	JGEBDAT		☐	JGEBDAT	☐	IS-M: Date of Birth of a Business Partner
24	GESCH	JGTGPNR	GESCH		☐	JGESCHL	☐	IS-M: Gender Key
25	JFAMST	JGTGPNR	JFAMST		☐	JFAMST	☐	IS-M: Business Partner's Marital Status
26	GPHERK	JGTGPNR	GPHERK		☐	GPHERK	☐	IS-M: Business Partner Origin
27	XNATUR	JGTGPNR	XNATUR		☐	XNATUR	☐	IS-M: Natural Person Indicator
28	XVERMSACH	JGTGPNR	XVERMSACH		☐	XVERMSACH	☐	IS-M: BP Authorized to Receive Gifts
29	XOHNE	JGTGPNR	XOHNE		☐	XCPDK	☐	Indicator: Is the account a one-time account?
30	XDEBI	JGTGPNR	XDEBI		☐	JXDEBI	☐	IS-M: Indicator: Customer Exists
31	KUNNR	JGTGPNR	KUNNR		☐	JKUNNR	☐	IS-M: Customer Number in Previous System
32	FKUNNR	JGTGPNR	FKUNNR		☐	JFKUNNR	☐	IS-M: Customer Number in Non-SAP System
33	XKREDI	JGTGPNR	XKREDI		☐	XKREDI	☐	IS-M: Indicator: Vendor Exists
34	LIFNR	JGTGPNR	LIFNR		☐	JLIFNR	☐	IS-M: Vendor Number in Previous System
35	FLIFNR	JGTGPNR	FLIFNR		☐	JFLIFNR	☐	IS-M: Vendor Number in Non-SAP System
36	XMITARB	JGTGPNR	XMITARB		☐	XMITARB	☐	IS-M: Employee Indicator
37	PERNR	JGTGPNR	PERNR		☐	JPERNR2	☐	IS-M: Personnel Number
38	XNOWERB	JGTGPNR	XNOWERB		☐	XNOWERB	☐	IS-M: No Advertising
39	GPKLA1	JGTGPNR	GPKLA1		☐	GPKLA	☐	IS-M: BP Class (Not in Use Yet)
40	GPKLA2	JGTGPNR	GPKLA2		☐	GPKLA2	☐	IS-M: BP Class 2
41	GPKLA3	JGTGPNR	GPKLA3		☐	GPKLA3	☐	IS-M: BP Class 3
42	GPKLA4	JGTGPNR	GPKLA4		☐	GPKLA4	☐	IS-M: BP Class 4
43	GPKLA5	JGTGPNR	GPKLA5		☐	GPKLA5	☐	IS-M: BP Class 5
44	KATR1	JGTGPNR	KATR1		☐	KATR1	☐	Attribute 1
45	KATR2	JGTGPNR	KATR2		☐	KATR2	☐	Attribute 2
46	KATR3	JGTGPNR	KATR3		☐	KATR3	☐	Attribute 3
47	KATR4	JGTGPNR	KATR4		☐	KATR4	☐	Attribute 4
48	KATR5	JGTGPNR	KATR5		☐	KATR5	☐	Attribute 5
49	KATR6	JGTGPNR	KATR6		☐	KATR6	☐	Attribute 6
50	KATR7	JGTGPNR	KATR7		☐	KATR7	☐	Attribute 7
51	KATR8	JGTGPNR	KATR8		☐	KATR8	☐	Attribute 8
52	KATR9	JGTGPNR	KATR9		☐	KATR9	☐	Attribute 9
53	KATR10	JGTGPNR	KATR10		☐	KATR10	☐	Attribute 10
54	XVSRVGES	JGTGPNR	XVSRVGES		☐	XVSRVGES	☐	IS-M: Service Company Indicator
55	XVSGLOEV	JGTGPNR	XVSGLOEV		☐	JXLV_ZG	☐	IS-M: Deletion Flag for Service Company
56	XVSGLOEKZ	JGTGPNR	XVSGLOEKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
57	XVSGSPE	JGTGPNR	XVSGSPE		☐	XZGSPE	☐	IS-M/SD: Lock Indicator for Service Company
58	XZUST	JGTGPNR	XZUST		☐	XZUST	☐	IS-M: Carrier Indicator
59	XZUSTLOEV	JGTGPNR	XZUSTLOEV		☐	JXLV_ZU	☐	IS-M: Deletion Flag for Carrier
60	XZUSTLOEKZ	JGTGPNR	XZUSTLOEKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
61	XZUSSPE	JGTGPNR	XZUSSPE		☐	XZUSPE	☐	IS-M/SD: Lock Indicator for Carrier
62	XVERMPROV	JGTGPNR	XVERMPROV		☐	XVERMPROV	☐	IS-M: Sales Agent - Commission Recipient
63	XVERMPROVV	JGTGPNR	XVERMPROVV		☐	JXLV_PV	☐	IS-M: Deletion Flag for Sales Agent/Commission Recipient
64	XVERMPROKZ	JGTGPNR	XVERMPROKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
65	XVERSPE	JGTGPNR	XVERSPE		☐	XPVSPE	☐	IS-M/SD: Lock Indicator for Sales Agent/Commission Recipient
66	XVERB	JGTGPNR	XVERB		☐	XVERB	☐	IS-M: Association Indicator
67	XVEBLOEV	JGTGPNR	XVEBLOEV		☐	XLOESCH	☐	IS-M: Deletion Flag (Role-Specific)
68	XVEBSPE	JGTGPNR	XVEBSPE		☐	XSPERR	☐	IS-M: Lock Indicator (Role-Specific)
69	XINKASSO	JGTGPNR	XINKASSO		☐	XINKASSO	☐	IS-M: Field Collector Indicator
70	XINKLOEV	JGTGPNR	XINKLOEV		☐	JXLV_IK	☐	IS-M: Deletion Flag for Field Collector
71	XINKLOEKZ	JGTGPNR	XINKLOEKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
72	XINKSPE	JGTGPNR	XINKSPE		☐	XIKSPE	☐	IS-M/SD: Lock Indicator for Field Collector
73	XRECHER	JGTGPNR	XRECHER		☐	XRECHER	☐	IS-M: Researcher Indicator
74	XRECHLOEV	JGTGPNR	XRECHLOEV		☐	JXLV_RC	☐	IS-M: Deletion Flag for Researcher
75	XRECHLOEKZ	JGTGPNR	XRECHLOEKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
76	XRECHSPE	JGTGPNR	XRECHSPE		☐	XRCSPE	☐	IS-M/SD: Lock Indicator for Researcher
77	MAILNBETR	JGTGPNR	MAILNBETR		☐	JMAILNBETR	☐	IS-M: Mail Address of User in Charge
78	XKAHS	JGTGPNR	XKAHS		☐	XKAHS	☐	IS-M: Customer Pickup Point Indicator
79	XKAHLOEV	JGTGPNR	XKAHLOEV		☐	XLOESCH	☐	IS-M: Deletion Flag (Role-Specific)
80	XKAHSSPE	JGTGPNR	XKAHSSPE		☐	XSPERR	☐	IS-M: Lock Indicator (Role-Specific)
81	XSPEDI	JGTGPNR	XSPEDI		☐	XSPEDI	☐	IS-M: Forwarding Agent Indicator
82	XSPEDLOEV	JGTGPNR	XSPEDLOEV		☐	JXLV_SP	☐	IS-M: Deletion Flag for Forwarding Agent
83	XSPEDLOEKZ	JGTGPNR	XSPEDLOEKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
84	XSPESPE	JGTGPNR	XSPESPE		☐	XSPSPE	☐	IS-M/SD: Lock Indicator for Forwarding Agent
85	XVERTKUN	JGTGPNR	XVERTKUN		☐	XVERTKUN	☐	IS-M: Sales Customer Indicator
86	XVKUNLOEV	JGTGPNR	XVKUNLOEV		☐	JXLV_KU	☐	IS-M: Deletion Flag for Sales Customer
87	XVKUNLOEKZ	JGTGPNR	XVKUNLOEKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
88	XVKUNSPE	JGTGPNR	XVKUNSPE		☐	XKUSPE	☐	IS-M/SD: Lock Indicator for Sales Customer
89	XEUW	JGTGPNR	XEUW		☐	XEUW	☐	IS-M: Retailer Indicator
90	XEUWLOEV	JGTGPNR	XEUWLOEV		☐	JXLV_EW	☐	IS-M: Deletion Flag for Retailer
91	XEUWLOEKZ	JGTGPNR	XEUWLOEKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
92	XEUWSPE	JGTGPNR	XEUWSPE		☐	XEWSPE	☐	IS-M/SD: Lock Indicator - Retailer
93	XINTERN	JGTGPNR	XINTERN		☐	XINTERN	☐	IS-M: Internal Business Partner Indicator
94	XINTLOEV	JGTGPNR	XINTLOEV		☐	XLOESCH	☐	IS-M: Deletion Flag (Role-Specific)
95	AUFORG	JGTGPNR	AUFORG		☐	VKBUR	☐	Sales office
96	XINTSPE	JGTGPNR	XINTSPE		☐	XSPERR	☐	IS-M: Lock Indicator (Role-Specific)
97	XSOZIAL	JGTGPNR	XSOZIAL		☐	XSOZIAL	☐	IS-M: Social Facility Indicator
98	XSOZLOEV	JGTGPNR	XSOZLOEV		☐	XLOESCH	☐	IS-M: Deletion Flag (Role-Specific)
99	XSOZSPE	JGTGPNR	XSOZSPE		☐	XSPERR	☐	IS-M: Lock Indicator (Role-Specific)
100	XPOST	JGTGPNR	XPOST		☐	XPOST	☐	IS-M: Mail Depot Indicator
101	XPOSLOEV	JGTGPNR	XPOSLOEV		☐	JXLV_PO	☐	IS-M: Deletion Flag for Post
102	XPOSLOEKZ	JGTGPNR	XPOSLOEKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
103	XPOSSPE	JGTGPNR	XPOSSPE		☐	XPOSPE	☐	IS-M/SD: Lock Indicator - Post
104	XVERLAG	JGTGPNR	XVERLAG		☐	XVERLAG	☐	IS-M: Publisher Indicator
105	XVERLLOEV	JGTGPNR	XVERLLOEV		☐	XLOESCH	☐	IS-M: Deletion Flag (Role-Specific)
106	XVERLSPE	JGTGPNR	XVERLSPE		☐	XSPERR	☐	IS-M: Lock Indicator (Role-Specific)
107	XVERLEIG	JGTGPNR	XVERLEIG		☐	XVERLEIG	☐	IS-M: Indicator: Owned By Publisher
108	VERLVKORG	JGTGPNR	VERLVKORG		☐	VKORG	☐	Sales Organization
109	ISPCVERL	JGTGPNR	ISPCVERL		☐	ISPVERL	☐	IS-M: Publisher ISPC Number - Obsolete from Rel. 3.04
110	XMEDIAK	JGTGPNR	XMEDIAK		☐	XMEDIAK	☐	IS-M: Media customer
111	XMEDIAKLV	JGTGPNR	XMEDIAKLV		☐	XMKLV	☐	IS-M: Deletion Flag for Media Customer
112	XMEDIAKLKZ	JGTGPNR	XMEDIAKLKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
113	XMEDIAKSP	JGTGPNR	XMEDIAKSP		☐	XMKSPE	☐	IS-M: Lock Indicator for Media Customer
114	XINSER	JGTGPNR	XINSER		☐	XINSERENT	☐	IS-M: Selection Indicator for Advertiser
115	XINSERLV	JGTGPNR	XINSERLV		☐	XISLV	☐	IS-M: Advertiser Deletion Flag
116	XINSERLKZ	JGTGPNR	XINSERLKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
117	XINSERSP	JGTGPNR	XINSERSP		☐	XISSPE	☐	IS-M: Advertiser Lock Indicator
118	XMVERM	JGTGPNR	XMVERM		☐	XMVERMITTL	☐	IS-M: Media Sales Agent Indicator
119	XMVERMLV	JGTGPNR	XMVERMLV		☐	XMVLV	☐	IS-M: Deletion Flag for Media Sales Agent
120	XMVERMLKZ	JGTGPNR	XMVERMLKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
121	XMVERMSP	JGTGPNR	XMVERMSP		☐	XMVSPE	☐	IS-M: Lock Indicator for Media Sales Agent
122	XAGEN	JGTGPNR	XAGEN		☐	XAGENTUR	☐	IS-M: Agency Indicator
123	XAGENLV	JGTGPNR	XAGENLV		☐	XARLV	☐	IS-M: Agency Deletion Flag
124	XAGENLKZ	JGTGPNR	XAGENLKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
125	XAGENLSP	JGTGPNR	XAGENLSP		☐	XARSPE	☐	IS-M: Agency Lock Indicator
126	AGEN_ART	JGTGPNR	AGEN_ART		☐	XAGEN_KREA	☐	IS-M: Creative Boutique Indicator
127	AGEN_STR	JGTGPNR	AGEN_STR		☐	XAGEN_STR	☐	IS-M: Distribution Agency Indicator
128	AGEN_PLAN	JGTGPNR	AGEN_PLAN		☐	XAGEN_PLAN	☐	IS-M: Planning Agency Indicator
129	AGEN_GRU	JGTGPNR	AGEN_GRU		☐	AGEN_GRUP	☐	IS-M: Agency Type
130	XDUB	JGTGPNR	XDUB		☐	XDUBIOS	☐	IS-M: No Longer Used - Credit Query Indicator
131	GP_DUB	JGTGPNR	GP_DUB		☐	JDUBIOS	☐	IS-M: Credit Query Indicator
132	BON	JGTGPNR	BON		☐	JBONITAET	☐	IS-M: Creditworthiness Indicator
133	KLIM_EINZ	JGTGPNR	KLIM_EINZ		☐	JKLIMEINZ	☐	IS-M: Individual Credit Limit
134	KLIM_GES	JGTGPNR	KLIM_GES		☐	JKLIMGES	☐	IS-M: Total Credit Limit
135	KLIM_WAERS	JGTGPNR	KLIM_WAERS		☐	JWAERS	☐	IS-M: Currency Key
136	WBZKUNNR	JGTGPNR	WBZKUNNR		☐	JWBZKUNNR	☐	IS-M: WBZ, VDZ Number of WBZ Company
137	RECHZENTNR	JGTGPNR	RECHZENTNR		☐	JWBZRZNR	☐	IS-M: WBZ, Computer Center Number
138	JWBZKOMART	JGTGPNR	JWBZKOMART		☐	JWBZKOMART	☐	IS-M: Communication Type in WBZ Processing
139	XWBZFIRMA	JGTGPNR	XWBZFIRMA		☐	XWBZFIRMA	☐	IS-M: Business Partner Is WBZ Company
140	WBZZLSCH	JGTGPNR	WBZZLSCH		☐	WBZZLSCH	☐	Payment Method for Billing Documents to WBZ Company
141	REFBELEG	JGTGPNR	REFBELEG		☐	REMELD_ISP	☐	IS-M/SD: Reference Document in Legacy System
142	ADRNR	JGTGPNR	ADRNR		☐	JADRNR	☐	IS-M: Address Number
143	XISPCTEILN	JGTGPNR	XISPCTEILN		☐	XISPCTEILN	☐	IS-M: Indicator: Business Partner Is EDI Participant
144	ISPCTEILN	JGTGPNR	ISPCTEILN		☐	ISPCTEILN	☐	IS-M: EDI Participant Number
145	ISPCART	JGTGPNR	ISPCART		☐	ISPCART	☐	IS-M: EDI Participant Type

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