SAP ABAP View JGVDB_ZU (IS-M/SD: Database View for Carriers)

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_ZU
Short Description	IS-M/SD: Database View for Carriers
Root table	JGTGPNR	IS-M: Central Business Partner Table

Table

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

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	JGTZUST	MANDT	JR	EQ			AND	0	0
3	JGTGPNR	GPNR	JL	EQ				0	0
4	JGTZUST	ZUSTELLER	JR	EQ			AND	0	0
5	JGTGPNR	XZUST		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	LIFNR	JGTGPNR	LIFNR		☐	JLIFNR	☐	IS-M: Vendor Number in Previous System
20	FKUNNR	JGTGPNR	FKUNNR		☐	JFKUNNR	☐	IS-M: Customer Number in Non-SAP 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	XZUST	JGTGPNR	XZUST		☐	XZUST	☐	IS-M: Carrier Indicator
26	XZUSTLOEV	JGTGPNR	XZUSTLOEV		☐	JXLV_ZU	☐	IS-M: Deletion Flag for Carrier
27	XZUSTLOEKZ	JGTGPNR	XZUSTLOEKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
28	XZUSSPE	JGTGPNR	XZUSSPE		☐	XZUSPE	☐	IS-M/SD: Lock Indicator for Carrier
29	ERFUSER	JGTZUST	ERFUSER		☐	ERFUSER	☐	Created By
30	ERFDATE	JGTZUST	ERFDATE		☐	ERFDATE	☐	Created On
31	ERFTIME	JGTZUST	ERFTIME		☐	ERFTIME	☐	Time Created
32	AENUSER	JGTZUST	AENUSER		☐	AENUSER	☐	Last Changed By
33	AENDATE	JGTZUST	AENDATE		☐	AENDATE	☐	Date of Last Change
34	AENTIME	JGTZUST	AENTIME		☐	AENTIME	☐	Time of Last Change
35	XZUSLOE	JGTZUST	XZUSLOE		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
36	MAXUZEIT	JGTZUST	MAXUZEIT		☐	MAXUZEIT	☐	IS-M: Availability Limit
37	LOHNLIMIT	JGTZUST	LOHNLIMIT		☐	LOHNLIMIT	☐	IS-M: Total Wage Limit for Business Partner
38	WAERS	JGTZUST	WAERS		☐	WAERS	☐	Currency Key
39	ZUSTTYP	JGTZUST	ZUSTTYP		☐	JZUSTTYP	☐	IS-M: Carrier Type
40	JSTATUS	JGTZUST	JSTATUS		☐	JZUSTGRP	☐	IS-M/SD: Carrier Grouping
41	XTITELZUS	JGTZUST	XTITELZUS		☐	XTITELZUS	☐	IS-M: Title Carrier Indicator
42	XPROSPZUS	JGTZUST	XPROSPZUS		☐	XPROSPZUS	☐	IS-M: Ad Pre-Print Carrier
43	XPROSPVER	JGTZUST	XPROSPVER		☐	XPROSPVER	☐	IS-M: Ad Pre-Print Distributor
44	KURST	JGTZUST	KURST		☐	KURST	☐	Exchange Rate 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