SAP ABAP View JGVDB_ZG (IS-M/SD: Business Partner Role - Service Company)

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_ZG
Short Description	IS-M/SD: Business Partner Role - Service Company
Root table	JGTGPNR	IS-M: Central Business Partner Table

Table

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

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	JGTVSG	MANDT	JR	EQ			AND	0	0
3	JGTGPNR	GPNR	JL	EQ				0	0
4	JGTVSG	VERSERVGES	JR	EQ			AND	0	0
5	LFA1	MANDT	JL	EQ				0	0
6	JGTGPNR	MANDT	JR	EQ			AND	0	0
7	LFA1	LIFNR	JL	EQ				0	0
8	JGTGPNR	LIFNR	JR	EQ			AND	0	0
9	JGTGPNR	XVSRVGES		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	GESCH	JGTGPNR	GESCH		☐	JGESCHL	☐	IS-M: Gender Key
7	JFAMST	JGTGPNR	JFAMST		☐	JFAMST	☐	IS-M: Business Partner's Marital Status
8	GPHERK	JGTGPNR	GPHERK		☐	GPHERK	☐	IS-M: Business Partner Origin
9	XNATUR	JGTGPNR	XNATUR		☐	XNATUR	☐	IS-M: Natural Person Indicator
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	JBRSCH	JGTGPNR	BRSCH		☐	BRSCH	☐	Industry key
14	JGEBDAT	JGTGPNR	JGEBDAT		☐	JGEBDAT	☐	IS-M: Date of Birth of a Business Partner
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	XKREDI	JGTGPNR	XKREDI		☐	XKREDI	☐	IS-M: Indicator: Vendor Exists
21	LIFNR	JGTGPNR	LIFNR		☐	JLIFNR	☐	IS-M: Vendor Number in Previous System
22	FLIFNR	JGTGPNR	FLIFNR		☐	JFLIFNR	☐	IS-M: Vendor Number in Non-SAP System
23	XMITARB	JGTGPNR	XMITARB		☐	XMITARB	☐	IS-M: Employee Indicator
24	PERNR	JGTGPNR	PERNR		☐	JPERNR2	☐	IS-M: Personnel Number
25	XNOWERB	JGTGPNR	XNOWERB		☐	XNOWERB	☐	IS-M: No Advertising
26	XVSRVGES	JGTGPNR	XVSRVGES		☐	XVSRVGES	☐	IS-M: Service Company Indicator
27	XVSGLOEV	JGTGPNR	XVSGLOEV		☐	JXLV_ZG	☐	IS-M: Deletion Flag for Service Company
28	XVSGLOEKZ	JGTGPNR	XVSGLOEKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
29	XVSGSPE	JGTGPNR	XVSGSPE		☐	XZGSPE	☐	IS-M/SD: Lock Indicator for Service Company
30	ERFUSER	JGTVSG	ERFUSER		☐	ERFUSER	☐	Created By
31	ERFDATE	JGTVSG	ERFDATE		☐	ERFDATE	☐	Created On
32	ERFTIME	JGTVSG	ERFTIME		☐	ERFTIME	☐	Time Created
33	AENUSER	JGTVSG	AENUSER		☐	AENUSER	☐	Last Changed By
34	AENDATE	JGTVSG	AENDATE		☐	AENDATE	☐	Date of Last Change
35	AENTIME	JGTVSG	AENTIME		☐	AENTIME	☐	Time of Last Change
36	XZUGLOE	JGTVSG	XZUGLOE		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
37	ANZZUST	JGTVSG	ANZZUST		☐	ANZZUST	☐	IS-M: Number of Carriers
38	ANZAUSD	JGTVSG	ANZAUSD		☐	ANZAUSD	☐	IS-M: Number of Employees in External Sales Force
39	WEGSTRECKE	JGTVSG	WEGSTRECKE		☐	WEGSTRECKE	☐	IS-M: Estimated Path Length
40	LEINS	JGTVSG	LEINS		☐	LEINS	☐	IS-M: Metric Unit of Measurement (Length)
41	BUKRS	JGTVSG	BUKRS		☐	JBUKRS	☐	IS-M: Company Code for Service Company
42	XSERVZUST	JGTVSG	XSERVZUST		☐	XSERVZUST	☐	IS-M: Service Company in Home Delivery Role
43	XSERVRECH	JGTVSG	XSERVRECH		☐	XSERVRECH	☐	IS-M: Service Company in Research Role
44	XSERVVERM	JGTVSG	XSERVVERM		☐	XSERVVERM	☐	IS-M: Service Company in Sales Agent Role
45	XSERVINK	JGTVSG	XSERVINK		☐	XSERVINK	☐	IS-M: Service Company in Collection Role
46	JZUGEHOER	JGTVSG	JZUGEHOER		☐	JZUGEHOER	☐	IS-M: Membership Status Own/Co-Administered/Third Party
47	JFEIERTKAL	JGTVSG	JFEIERTKAL		☐	JFEIKAL	☐	IS-M: Public Holiday Calendar
48	BAHNS	LFA1	BAHNS		☐	BAHNS	☐	Train station
49	BBBNR	LFA1	BBBNR		☐	BBBNR	☐	International location number (part 1)
50	BBSNR	LFA1	BBSNR		☐	BBSNR	☐	International location number (Part 2)
51	BEGRU	LFA1	BEGRU		☐	BRGRU	☐	Authorization Group
52	BRSCH	LFA1	BRSCH		☐	BRSCH	☐	Industry key
53	BUBKZ	LFA1	BUBKZ		☐	BUBKZ	☐	Check digit for the international location number
54	DATLT	LFA1	DATLT		☐	DATLT	☐	Data communication line no.
55	DTAMS	LFA1	DTAMS		☐	DTAMS	☐	Report key for data medium exchange
56	DTAWS	LFA1	DTAWS		☐	DTAWS	☐	Instruction key for data medium exchange
57	ESRNR	LFA1	ESRNR		☐	ESRNR	☐	POR subscriber number
58	KONZS	LFA1	KONZS		☐	KONZS	☐	Group key
59	KTOKK	LFA1	KTOKK		☐	KTOKK	☐	Vendor account group
60	KUNNR_LFA1	LFA1	KUNNR		☐	KUNNR	☐	Customer Number
61	LAND1	LFA1	LAND1		☐	LAND1_GP	☐	Country Key
62	LNRZA	LFA1	LNRZA		☐	LNRZA	☐	Account Number of the Alternative Payee
63	LOEVM	LFA1	LOEVM		☐	LOEVM_X	☐	Central Deletion Flag for Master Record
64	SORTL	LFA1	SORTL		☐	SORTL	☐	Sort field
65	SPERR	LFA1	SPERR		☐	SPERB_X	☐	Central posting block
66	SPERM	LFA1	SPERM		☐	SPERM_X	☐	Centrally imposed purchasing block
67	SPRAS	LFA1	SPRAS		☐	SPRAS	☐	Language Key
68	STCD1	LFA1	STCD1		☐	STCD1	☐	Tax Number 1
69	STCD2	LFA1	STCD2		☐	STCD2	☐	Tax Number 2
70	STKZA	LFA1	STKZA		☐	STKZA	☐	Indicator: Business Partner Subject to Equalization Tax?
71	STKZU	LFA1	STKZU		☐	STKZU	☐	Liable for VAT
72	XCPDK	LFA1	XCPDK		☐	XCPDK	☐	Indicator: Is the account a one-time account?
73	XZEMP	LFA1	XZEMP		☐	XZEMP	☐	Indicator: Alternative payee in document allowed ?
74	VBUND	LFA1	VBUND		☐	RASSC	☐	Company ID of trading partner
75	FISKN	LFA1	FISKN		☐	FISKN_K	☐	Account number of the master record with fiscal address
76	STCEG	LFA1	STCEG		☐	STCEG	☐	VAT Registration Number
77	STKZN	LFA1	STKZN		☐	STKZN	☐	Natural Person
78	SPERQ	LFA1	SPERQ		☐	QSPERRFKT	☐	Function That Will Be Blocked

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