SAP ABAP Table JGVDB_EWK (Generated Table for View)

Basic Data

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

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	GESCH	☐	JGESCHL	JGESCHL	CHAR	1	0	IS-M: Gender Key
7	JFAMST	☐	JFAMST	JFAMST	CHAR	1	0	IS-M: Business Partner's Marital Status	TJG45
8	GPHERK	☐	GPHERK	GPHERK	CHAR	2	0	IS-M: Business Partner Origin	TJG41
9	XNATUR	☐	XNATUR	XFELD	CHAR	1	0	IS-M: Natural Person Indicator
10	JKTOKD	☐	JKTOKD	JKTOKD	CHAR	4	0	IS-M: Business Partner Account Group	TJG37
11	MAILN	☐	JMAILN	SO_OBJ_NAM	CHAR	12	0	IS-M: Mail Address
12	BERUFSL	☐	BERUFSL	BERUFSL	CHAR	8	0	IS-M: Occupation	TJG05
13	JBRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
14	JGEBDAT	☐	JGEBDAT	DATUM	DATS	8	0	IS-M: Date of Birth of a Business Partner
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	FKUNNR	☐	JFKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Non-SAP System	*
20	XKREDI	☐	XKREDI	XFELD	CHAR	1	0	IS-M: Indicator: Vendor Exists
21	LIFNR	☐	JLIFNR	LIFNR	CHAR	10	0	IS-M: Vendor Number in Previous System	LFA1
22	FLIFNR	☐	JFLIFNR	LIFNR	CHAR	10	0	IS-M: Vendor Number in Non-SAP System	*
23	XMITARB	☐	XMITARB	XFELD	CHAR	1	0	IS-M: Employee Indicator
24	PERNR	☐	JPERNR2	JPERNR	CHAR	20	0	IS-M: Personnel Number
25	XNOWERB	☐	XNOWERB	XFELD	CHAR	1	0	IS-M: No Advertising
26	XEUW	☐	XEUW	XFELD	CHAR	1	0	IS-M: Retailer Indicator
27	XEUWLOEV	☐	JXLV_EW	XFELD	CHAR	1	0	IS-M: Deletion Flag for Retailer
28	XEUWLOEKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
29	XEUWSPE	☐	XEWSPE	XFELD	CHAR	1	0	IS-M/SD: Lock Indicator - Retailer
30	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
31	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
32	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
33	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
34	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
35	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
36	XEUWLOE	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
37	VERKGB	☐	VERKGB	TEXT50	CHAR	50	0	IS-M: Sales Region
38	VGEINW	☐	VGEINW	ANZPERS	NUMC	10	0	IS-M: Population of Sales Area
39	ANZMIT	☐	ANZMIT	JANZMA	NUMC	5	0	IS-M: Number of Retail Employees
40	MBRSYS	☐	MBRSYS	MBRSYS	CHAR	2	0	IS-M: Automatic Payment System	TJG15
41	EVKSTART	☐	EVKSTART	EVKSTART	CHAR	2	0	IS-M: Point of Sale Category	TJG17
42	EVKSTBEZ	☐	EVKSTBEZ	EVKSTBEZ	CHAR	4	0	POS Type	TJG19
43	XLOTTO	☐	XLOTTO	XFELD	CHAR	1	0	IS-M: Lottery Agent Indicator
44	EVKFLAECHE	☐	EVKFLAECHE	EVKFLAECHE	CHAR	2	0	IS-M: POS Area Key	TJG21
45	EUMSEINFL	☐	EUMSEINFL	EUMSEINFL	CHAR	2	0	External Sales Influence at POS (Primary)	TJG25
46	EBEDIENART	☐	EBEDIENART	EBEDIENART	CHAR	1	0	Service Type for Point of Sale	TJG23
47	EFREQUENZ	☐	EFREQUENZ	EFREQUENZ	CHAR	1	0	IS-M: POS Customer Frequency per Week	TJG27
48	BAGNR	☐	BAGNR	TEXT5	CHAR	5	0	IS-M: BAG Transaction Number
49	ISPCNR	☐	ISPCNR	TEXT10	CHAR	10	0	IS-M: ISPC Number
50	VDZNR	☐	VDZNR	VDZNR	CHAR	20	0	IS-M: VDZ Number
51	OEFFZT	☐	OEFFZT	OEFFZT	CHAR	1	0	IS-M: Point of Sale Opening Time	TJG29
52	SCHLZT	☐	SCHLZT		CHAR	1	0	IS-M: POS Closing Time	TJG31
53	OEFFMO	☐	OEFFMO	OEFFTG	CHAR	1	0	IS-M: Opening Type Monday	TJG33
54	OEFFDI	☐	OEFFDI	OEFFTG	CHAR	1	0	IS-M: Opening Type Tuesday	TJG33
55	OEFFMI	☐	OEFFMI	OEFFTG	CHAR	1	0	IS-M: Opening Type Wednesday	TJG33
56	OEFFDO	☐	OEFFDO	OEFFTG	CHAR	1	0	IS-M: Opening Type Thursday	TJG33
57	OEFFFR	☐	OEFFFR	OEFFTG	CHAR	1	0	IS-M: Opening Type Friday	TJG33
58	OEFFSA	☐	OEFFSA	OEFFTG	CHAR	1	0	IS-M: Opening Type Saturday	TJG33
59	OEFFSO	☐	OEFFSO	OEFFTG	CHAR	1	0	IS-M: Opening Type Sunday	TJG33
60	XREMRECHT	☐	XREMRECHT	XFELD	CHAR	1	0	IS-M: Right of Return
61	REMART	☐	REMART	REMART	CHAR	1	0	Return Type
62	REMWEISE	☐	REMWEISE	REMWEISE	CHAR	1	0	Return Method
63	REMSP	☐	REMSP	XFELD	CHAR	1	0	IS-M: Billing Block for Return Notification
64	KOMMENT	☐	KOMM50	TEXT50	CHAR	50	0	IS-M: Comment 50 Characters in Length

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JGVDB_EWK	BERUFSL	TJG05	BERUFSL	REF	C	CN
2	JGVDB_EWK	EBEDIENART	TJG23	EBEDIENART	REF	C	CN
3	JGVDB_EWK	EFREQUENZ	TJG27	EFREQUENZ	REF	C	CN
4	JGVDB_EWK	EUMSEINFL	TJG25	EUMSEINFL	REF	C	CN
5	JGVDB_EWK	EVKFLAECHE	TJG21	EVKFLAECHE	REF	C	CN
6	JGVDB_EWK	EVKSTART	TJG17	EVKSTART	REF	C	CN
7	JGVDB_EWK	EVKSTBEZ	TJG19	EVKSTBEZ	REF	C	CN
8	JGVDB_EWK	GPHERK	TJG41	GPHERK	REF	C	CN
9	JGVDB_EWK	JBRSCH	T016	BRSCH	REF	C	CN
10	JGVDB_EWK	JFAMST	TJG45	JFAMST	REF	C	CN
11	JGVDB_EWK	JKTOKD	TJG37	JKTOKD	KEY	1	CN
12	JGVDB_EWK	KUNNR	KNA1	KUNNR	REF	C	1
13	JGVDB_EWK	LIFNR	LFA1	LIFNR	REF	C	1
14	JGVDB_EWK	MANDT	T000	MANDT	KEY	1	CN
15	JGVDB_EWK	MBRSYS	TJG15	MBRSYS	REF	C	CN
16	JGVDB_EWK	OEFFDI	TJG33	OEFFTG	REF	C	CN
17	JGVDB_EWK	OEFFDO	TJG33	OEFFTG	REF	C	CN
18	JGVDB_EWK	OEFFFR	TJG33	OEFFTG	REF	C	CN
19	JGVDB_EWK	OEFFMI	TJG33	OEFFTG	REF	C	CN
20	JGVDB_EWK	OEFFMO	TJG33	OEFFTG	REF	C	CN
21	JGVDB_EWK	OEFFSA	TJG33	OEFFTG	REF	C	CN
22	JGVDB_EWK	OEFFSO	TJG33	OEFFTG	REF	C	CN
23	JGVDB_EWK	OEFFZT	TJG29	OEFFZT	REF	C	CN
24	JGVDB_EWK	SCHLZT	TJG31	SCHLZT	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in