SAP ABAP View JGVDB_EWK (IS-M/SD: Retailer Without Sales Area)

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_EWK
Short Description	IS-M/SD: Retailer Without Sales Area
Root table	JGTGPNR	IS-M: Central Business Partner Table

Table

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

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	JGTEUWV	MANDT	JR	EQ			AND	0	0
3	JGTGPNR	GPNR	JL	EQ				0	0
4	JGTEUWV	EWKUN	JR	EQ			AND	0	0
5	JGTGPNR	XEUW		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	XEUW	JGTGPNR	XEUW		☐	XEUW	☐	IS-M: Retailer Indicator
27	XEUWLOEV	JGTGPNR	XEUWLOEV		☐	JXLV_EW	☐	IS-M: Deletion Flag for Retailer
28	XEUWLOEKZ	JGTGPNR	XEUWLOEKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
29	XEUWSPE	JGTGPNR	XEUWSPE		☐	XEWSPE	☐	IS-M/SD: Lock Indicator - Retailer
30	ERFUSER	JGTEUWV	ERFUSER		☐	ERFUSER	☐	Created By
31	ERFDATE	JGTEUWV	ERFDATE		☐	ERFDATE	☐	Created On
32	ERFTIME	JGTEUWV	ERFTIME		☐	ERFTIME	☐	Time Created
33	AENUSER	JGTEUWV	AENUSER		☐	AENUSER	☐	Last Changed By
34	AENDATE	JGTEUWV	AENDATE		☐	AENDATE	☐	Date of Last Change
35	AENTIME	JGTEUWV	AENTIME		☐	AENTIME	☐	Time of Last Change
36	XEUWLOE	JGTEUWV	XEUWLOE		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
37	VERKGB	JGTEUWV	VERKGB		☐	VERKGB	☐	IS-M: Sales Region
38	VGEINW	JGTEUWV	VGEINW		☐	VGEINW	☐	IS-M: Population of Sales Area
39	ANZMIT	JGTEUWV	ANZMIT		☐	ANZMIT	☐	IS-M: Number of Retail Employees
40	MBRSYS	JGTEUWV	MBRSYS		☐	MBRSYS	☐	IS-M: Automatic Payment System
41	EVKSTART	JGTEUWV	EVKSTART		☐	EVKSTART	☐	IS-M: Point of Sale Category
42	EVKSTBEZ	JGTEUWV	EVKSTBEZ		☐	EVKSTBEZ	☐	POS Type
43	XLOTTO	JGTEUWV	XLOTTO		☐	XLOTTO	☐	IS-M: Lottery Agent Indicator
44	EVKFLAECHE	JGTEUWV	EVKFLAECHE		☐	EVKFLAECHE	☐	IS-M: POS Area Key
45	EUMSEINFL	JGTEUWV	EUMSEINFL		☐	EUMSEINFL	☐	External Sales Influence at POS (Primary)
46	EBEDIENART	JGTEUWV	EBEDIENART		☐	EBEDIENART	☐	Service Type for Point of Sale
47	EFREQUENZ	JGTEUWV	EFREQUENZ		☐	EFREQUENZ	☐	IS-M: POS Customer Frequency per Week
48	BAGNR	JGTEUWV	BAGNR		☐	BAGNR	☐	IS-M: BAG Transaction Number
49	ISPCNR	JGTEUWV	ISPCNR		☐	ISPCNR	☐	IS-M: ISPC Number
50	VDZNR	JGTEUWV	VDZNR		☐	VDZNR	☐	IS-M: VDZ Number
51	OEFFZT	JGTEUWV	OEFFZT		☐	OEFFZT	☐	IS-M: Point of Sale Opening Time
52	SCHLZT	JGTEUWV	SCHLZT		☐	SCHLZT	☐	IS-M: POS Closing Time
53	OEFFMO	JGTEUWV	OEFFMO		☐	OEFFMO	☐	IS-M: Opening Type Monday
54	OEFFDI	JGTEUWV	OEFFDI		☐	OEFFDI	☐	IS-M: Opening Type Tuesday
55	OEFFMI	JGTEUWV	OEFFMI		☐	OEFFMI	☐	IS-M: Opening Type Wednesday
56	OEFFDO	JGTEUWV	OEFFDO		☐	OEFFDO	☐	IS-M: Opening Type Thursday
57	OEFFFR	JGTEUWV	OEFFFR		☐	OEFFFR	☐	IS-M: Opening Type Friday
58	OEFFSA	JGTEUWV	OEFFSA		☐	OEFFSA	☐	IS-M: Opening Type Saturday
59	OEFFSO	JGTEUWV	OEFFSO		☐	OEFFSO	☐	IS-M: Opening Type Sunday
60	XREMRECHT	JGTEUWV	XREMRECHT		☐	XREMRECHT	☐	IS-M: Right of Return
61	REMART	JGTEUWV	REMART		☐	REMART	☐	Return Type
62	REMWEISE	JGTEUWV	REMWEISE		☐	REMWEISE	☐	Return Method
63	REMSP	JGTEUWV	REMSP		☐	REMSP	☐	IS-M: Billing Block for Return Notification
64	KOMMENT	JGTEUWV	KOMMENT		☐	KOMM50	☐	IS-M: Comment 50 Characters in Length

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	20130529
SAP Release Created in