SAP ABAP View JGVDB_PV (IS-M/SD: Database View for Role - Sales Agent/Comm.Recipient)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M-MD (Application Component) Master Data
     ⤷ JMDGEN (Package) Generic Master Data Media

Basic Data

View Type	D	Database View
Database View	JGVDB_PV
Short Description	IS-M/SD: Database View for Role - Sales Agent/Comm.Recipient
Root table	JGTGPNR	IS-M: Central Business Partner Table

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JGTGPNR	MANDT	JL	EQ				0	0
2	JGTVERM	MANDT	JR	EQ			AND	0	0
3	JGTGPNR	GPNR	JL	EQ				0	0
4	JGTVERM	VERMITTLER	JR	EQ			AND	0	0
5	JGTGPNR	XVERMPROV		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	JKTOKD	JGTGPNR	JKTOKD		☐	JKTOKD	☐	IS-M: Business Partner Account Group
7	MAILN	JGTGPNR	MAILN		☐	JMAILN	☐	IS-M: Mail Address
8	BERUFSL	JGTGPNR	BERUFSL		☐	BERUFSL	☐	IS-M: Occupation
9	JBRSCH	JGTGPNR	BRSCH		☐	BRSCH	☐	Industry key
10	JGEBDAT	JGTGPNR	JGEBDAT		☐	JGEBDAT	☐	IS-M: Date of Birth of a Business Partner
11	GESCH	JGTGPNR	GESCH		☐	JGESCHL	☐	IS-M: Gender Key
12	JFAMST	JGTGPNR	JFAMST		☐	JFAMST	☐	IS-M: Business Partner's Marital Status
13	GPHERK	JGTGPNR	GPHERK		☐	GPHERK	☐	IS-M: Business Partner Origin
14	XNATUR	JGTGPNR	XNATUR		☐	XNATUR	☐	IS-M: Natural Person Indicator
15	XVERMSACH	JGTGPNR	XVERMSACH		☐	XVERMSACH	☐	IS-M: BP Authorized to Receive Gifts
16	XOHNE	JGTGPNR	XOHNE		☐	XCPDK	☐	Indicator: Is the account a one-time account?
17	XDEBI	JGTGPNR	XDEBI		☐	JXDEBI	☐	IS-M: Indicator: Customer Exists
18	KUNNR	JGTGPNR	KUNNR		☐	JKUNNR	☐	IS-M: Customer Number in Previous System
19	FKUNNR	JGTGPNR	FKUNNR		☐	JFKUNNR	☐	IS-M: Customer Number in Non-SAP System
20	LIFNR	JGTGPNR	LIFNR		☐	JLIFNR	☐	IS-M: Vendor Number in Previous System
21	FLIFNR	JGTGPNR	FLIFNR		☐	JFLIFNR	☐	IS-M: Vendor Number in Non-SAP System
22	XMITARB	JGTGPNR	XMITARB		☐	XMITARB	☐	IS-M: Employee Indicator
23	PERNR	JGTGPNR	PERNR		☐	JPERNR2	☐	IS-M: Personnel Number
24	XNOWERB	JGTGPNR	XNOWERB		☐	XNOWERB	☐	IS-M: No Advertising
25	XVERMPROVV	JGTGPNR	XVERMPROVV		☐	JXLV_PV	☐	IS-M: Deletion Flag for Sales Agent/Commission Recipient
26	XVERMPROV	JGTGPNR	XVERMPROV		☐	XVERMPROV	☐	IS-M: Sales Agent - Commission Recipient
27	XVERMPROKZ	JGTGPNR	XVERMPROKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
28	XVERSPE	JGTGPNR	XVERSPE		☐	XPVSPE	☐	IS-M/SD: Lock Indicator for Sales Agent/Commission Recipient
29	ERFUSER	JGTVERM	ERFUSER		☐	ERFUSER	☐	Created By
30	ERFDATE	JGTVERM	ERFDATE		☐	ERFDATE	☐	Created On
31	ERFTIME	JGTVERM	ERFTIME		☐	ERFTIME	☐	Time Created
32	AENUSER	JGTVERM	AENUSER		☐	AENUSER	☐	Last Changed By
33	AENDATE	JGTVERM	AENDATE		☐	AENDATE	☐	Date of Last Change
34	AENTIME	JGTVERM	AENTIME		☐	AENTIME	☐	Time of Last Change
35	XVERLOE	JGTVERM	XVERLOE		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
36	VERTYP	JGTVERM	VERTYP		☐	VERTYP	☐	IS-M: Sales Agent Type
37	VERBER	JGTVERM	VERBER		☐	VERBER	☐	IS-M: Sales Consultant
38	XBUSPERRE	JGTVERM	XBUSPERRE		☐	XBUSPERRE	☐	IS-M: Settlement Posting Block
39	KAUTSATZ	JGTVERM	KAUTSATZ		☐	KAUTSATZ	☐	IS-M: Security Deposit Rate in Percent
40	KAUTKONTO	JGTVERM	KAUTKONTO		☐	KAUTKONTO	☐	IS-M: Security Deposit Account Number
41	MAXKAUT	JGTVERM	MAXKAUT		☐	MAXKAUT	☐	IS-M: Maximum Security Deposit Amount
42	WAERS	JGTVERM	WAERS		☐	WAERS	☐	Currency Key
43	KAUTZINS	JGTVERM	KAUTZINS		☐	KAUTZINS	☐	IS-M: Interest Rate for Security Deposit Account

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