SAP ABAP Table JGVDB_ZU (Generated Table for View JGVDB_ZU)

Basic Data

Table Category	VIEW	General view structure
General view structure	JGVDB_ZU	Table Relationship Diagram
Short Description	Generated Table for View JGVDB_ZU

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	GPNR	☑	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key
3	XGPLOE	☐	JXLV_GP	XFELD	CHAR	1	0	IS-M: Deletion Flag for General Business Partner
4	XGPLOEKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
5	XGPSPE	☐	XGPSPE	XFELD	CHAR	1	0	IS-M/SD: Lock Indicator for General Business Partner
6	JKTOKD	☐	JKTOKD	JKTOKD	CHAR	4	0	IS-M: Business Partner Account Group	TJG37
7	MAILN	☐	JMAILN	SO_OBJ_NAM	CHAR	12	0	IS-M: Mail Address
8	BERUFSL	☐	BERUFSL	BERUFSL	CHAR	8	0	IS-M: Occupation	TJG05
9	JBRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
10	JGEBDAT	☐	JGEBDAT	DATUM	DATS	8	0	IS-M: Date of Birth of a Business Partner
11	GESCH	☐	JGESCHL	JGESCHL	CHAR	1	0	IS-M: Gender Key
12	JFAMST	☐	JFAMST	JFAMST	CHAR	1	0	IS-M: Business Partner's Marital Status	TJG45
13	GPHERK	☐	GPHERK	GPHERK	CHAR	2	0	IS-M: Business Partner Origin	TJG41
14	XNATUR	☐	XNATUR	XFELD	CHAR	1	0	IS-M: Natural Person Indicator
15	XVERMSACH	☐	XVERMSACH	XFELD	CHAR	1	0	IS-M: BP Authorized to Receive Gifts
16	XOHNE	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
17	XDEBI	☐	JXDEBI	XFELD	CHAR	1	0	IS-M: Indicator: Customer Exists
18	KUNNR	☐	JKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Previous System	KNA1
19	LIFNR	☐	JLIFNR	LIFNR	CHAR	10	0	IS-M: Vendor Number in Previous System	LFA1
20	FKUNNR	☐	JFKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Non-SAP System
21	FLIFNR	☐	JFLIFNR	LIFNR	CHAR	10	0	IS-M: Vendor Number in Non-SAP System
22	XMITARB	☐	XMITARB	XFELD	CHAR	1	0	IS-M: Employee Indicator
23	PERNR	☐	JPERNR2	JPERNR	CHAR	20	0	IS-M: Personnel Number
24	XNOWERB	☐	XNOWERB	XFELD	CHAR	1	0	IS-M: No Advertising
25	XZUST	☐	XZUST	XFELD	CHAR	1	0	IS-M: Carrier Indicator
26	XZUSTLOEV	☐	JXLV_ZU	XFELD	CHAR	1	0	IS-M: Deletion Flag for Carrier
27	XZUSTLOEKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
28	XZUSSPE	☐	XZUSPE	XFELD	CHAR	1	0	IS-M/SD: Lock Indicator for Carrier
29	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
30	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
31	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
32	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
33	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
34	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
35	XZUSLOE	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
36	MAXUZEIT	☐	MAXUZEIT	UZEIT	TIMS	6	0	IS-M: Availability Limit
37	LOHNLIMIT	☐	LOHNLIMIT	ISPWV072	CURR	9	2	IS-M: Total Wage Limit for Business Partner
38	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
39	ZUSTTYP	☐	JZUSTTYP	JZUSTTYP	CHAR	1	0	IS-M: Carrier Type	TJG81
40	JSTATUS	☐	JZUSTGRP	JSTATUS	CHAR	2	0	IS-M/SD: Carrier Grouping	TJG35
41	XTITELZUS	☐	XTITELZUS	XFELD	CHAR	1	0	IS-M: Title Carrier Indicator
42	XPROSPZUS	☐	XPROSPZUS	XFELD	CHAR	1	0	IS-M: Ad Pre-Print Carrier
43	XPROSPVER	☐	XPROSPVER	XFELD	CHAR	1	0	IS-M: Ad Pre-Print Distributor
44	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JGVDB_ZU	BERUFSL	TJG05	BERUFSL	REF	C	CN
2	JGVDB_ZU	GPHERK	TJG41	GPHERK	REF	C	CN
3	JGVDB_ZU	JBRSCH	T016	BRSCH	REF	C	CN
4	JGVDB_ZU	JFAMST	TJG45	JFAMST	REF	C	CN
5	JGVDB_ZU	JKTOKD	TJG37	JKTOKD	KEY	1	CN
6	JGVDB_ZU	JSTATUS	TJG35	JSTATUS	REF	C	CN
7	JGVDB_ZU	KUNNR	KNA1	KUNNR	REF	C	1
8	JGVDB_ZU	KURST	TCURV	KURST	KEY	1	CN
9	JGVDB_ZU	LIFNR	LFA1	LIFNR	REF	C	1
10	JGVDB_ZU	MANDT	T000	MANDT	KEY	1	CN
11	JGVDB_ZU	WAERS	TCURC	WAERS	REF	C	CN
12	JGVDB_ZU	ZUSTTYP	TJG81	JZUSTTYP

History

Last changed by/on	SAP	20050224
SAP Release Created in