SAP ABAP View JJVDB_IS (IS-M/AM: Advertiser Business Partner Role View)

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_IS
Short Description	IS-M/AM: Advertiser Business Partner Role View
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	XINSER		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	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	BERUFSL	JGTGPNR	BERUFSL		☐	BERUFSL	☐	IS-M: Occupation
15	GFORM	JGTGPNR	GFORM		☐	GFORM	☐	Legal status
16	BRSCH	JGTGPNR	BRSCH		☐	BRSCH	☐	Industry key
17	BRAN1	JGTGPNR	BRAN1		☐	BRAN1_D	☐	Industry code 1
18	BRAN2	JGTGPNR	BRAN2		☐	BRAN2	☐	Industry code 2
19	BRAN3	JGTGPNR	BRAN3		☐	BRAN3	☐	Industry code 3
20	BRAN4	JGTGPNR	BRAN4		☐	BRAN4	☐	Industry code 4
21	BRAN5	JGTGPNR	BRAN5		☐	BRAN5	☐	Industry code 5
22	JGEBDAT	JGTGPNR	JGEBDAT		☐	JGEBDAT	☐	IS-M: Date of Birth of a Business Partner
23	GESCH	JGTGPNR	GESCH		☐	JGESCHL	☐	IS-M: Gender Key
24	JFAMST	JGTGPNR	JFAMST		☐	JFAMST	☐	IS-M: Business Partner's Marital Status
25	GPHERK	JGTGPNR	GPHERK		☐	GPHERK	☐	IS-M: Business Partner Origin
26	XNATUR	JGTGPNR	XNATUR		☐	XNATUR	☐	IS-M: Natural Person Indicator
27	XVERMSACH	JGTGPNR	XVERMSACH		☐	XVERMSACH	☐	IS-M: BP Authorized to Receive Gifts
28	XOHNE	JGTGPNR	XOHNE		☐	XCPDK	☐	Indicator: Is the account a one-time account?
29	XDEBI	JGTGPNR	XDEBI		☐	JXDEBI	☐	IS-M: Indicator: Customer Exists
30	KUNNR	JGTGPNR	KUNNR		☐	JKUNNR	☐	IS-M: Customer Number in Previous System
31	FKUNNR	JGTGPNR	FKUNNR		☐	JFKUNNR	☐	IS-M: Customer Number in Non-SAP System
32	XKREDI	JGTGPNR	XKREDI		☐	XKREDI	☐	IS-M: Indicator: Vendor Exists
33	LIFNR	JGTGPNR	LIFNR		☐	JLIFNR	☐	IS-M: Vendor Number in Previous System
34	FLIFNR	JGTGPNR	FLIFNR		☐	JFLIFNR	☐	IS-M: Vendor Number in Non-SAP System
35	XMITARB	JGTGPNR	XMITARB		☐	XMITARB	☐	IS-M: Employee Indicator
36	PERNR	JGTGPNR	PERNR		☐	JPERNR2	☐	IS-M: Personnel Number
37	XNOWERB	JGTGPNR	XNOWERB		☐	XNOWERB	☐	IS-M: No Advertising
38	GPKLA1	JGTGPNR	GPKLA1		☐	GPKLA	☐	IS-M: BP Class (Not in Use Yet)
39	GPKLA2	JGTGPNR	GPKLA2		☐	GPKLA2	☐	IS-M: BP Class 2
40	GPKLA3	JGTGPNR	GPKLA3		☐	GPKLA3	☐	IS-M: BP Class 3
41	GPKLA4	JGTGPNR	GPKLA4		☐	GPKLA4	☐	IS-M: BP Class 4
42	GPKLA5	JGTGPNR	GPKLA5		☐	GPKLA5	☐	IS-M: BP Class 5
43	KATR1	JGTGPNR	KATR1		☐	KATR1	☐	Attribute 1
44	KATR2	JGTGPNR	KATR2		☐	KATR2	☐	Attribute 2
45	KATR3	JGTGPNR	KATR3		☐	KATR3	☐	Attribute 3
46	KATR4	JGTGPNR	KATR4		☐	KATR4	☐	Attribute 4
47	KATR5	JGTGPNR	KATR5		☐	KATR5	☐	Attribute 5
48	KATR6	JGTGPNR	KATR6		☐	KATR6	☐	Attribute 6
49	KATR7	JGTGPNR	KATR7		☐	KATR7	☐	Attribute 7
50	KATR8	JGTGPNR	KATR8		☐	KATR8	☐	Attribute 8
51	KATR9	JGTGPNR	KATR9		☐	KATR9	☐	Attribute 9
52	KATR10	JGTGPNR	KATR10		☐	KATR10	☐	Attribute 10
53	XINSER	JGTGPNR	XINSER		☐	XINSERENT	☐	IS-M: Selection Indicator for Advertiser
54	XINSERLV	JGTGPNR	XINSERLV		☐	XISLV	☐	IS-M: Advertiser Deletion Flag
55	XINSERLKZ	JGTGPNR	XINSERLKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
56	XINSERSP	JGTGPNR	XINSERSP		☐	XISSPE	☐	IS-M: Advertiser Lock Indicator
57	BON	JGTGPNR	BON		☐	JBONITAET	☐	IS-M: Creditworthiness Indicator
58	KLIM_EINZ	JGTGPNR	KLIM_EINZ		☐	JKLIMEINZ	☐	IS-M: Individual Credit Limit
59	KLIM_GES	JGTGPNR	KLIM_GES		☐	JKLIMGES	☐	IS-M: Total Credit Limit
60	KLIM_WAERS	JGTGPNR	KLIM_WAERS		☐	JWAERS	☐	IS-M: Currency Key
61	ISPCVERL	JGTGPNR	ISPCVERL		☐	ISPVERL	☐	IS-M: Publisher ISPC Number - Obsolete from Rel. 3.04
62	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	20050224
SAP Release Created in