SAP ABAP View JGVDB_EW (IS-M/SD: Business Partner Role - Retailer)

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

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JGTGPNR	JGTGPNR
2	KNA1
3	KNVV
4	JGTEUWV

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	KNA1	MANDT	JL	EQ				0	0
2	JGTGPNR	MANDT	JR	EQ			AND	0	0
3	KNA1	KUNNR	JL	EQ				0	0
4	JGTGPNR	KUNNR	JR	EQ			AND	0	0
5	KNA1	MANDT	JL	EQ				0	0
6	KNVV	MANDT	JR	EQ			AND	0	0
7	KNA1	KUNNR	JL	EQ				0	0
8	KNVV	KUNNR	JR	EQ			AND	0	0
9	JGTGPNR	MANDT	JL	EQ				0	0
10	JGTEUWV	MANDT	JR	EQ			AND	0	0
11	JGTGPNR	GPNR	JL	EQ				0	0
12	JGTEUWV	EWKUN	JR	EQ			AND	0	0
13	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	VKORG	KNVV	VKORG		☐	VKORG	☐	Sales Organization
4	VTWEG	KNVV	VTWEG		☐	VTWEG	☐	Distribution Channel
5	SPART	KNVV	SPART		☐	SPART	☐	Division
6	XGPLOE	JGTGPNR	XGPLOE		☐	JXLV_GP	☐	IS-M: Deletion Flag for General Business Partner
7	XGPLOEKZ	JGTGPNR	XGPLOEKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
8	XGPSPE	JGTGPNR	XGPSPE		☐	XGPSPE	☐	IS-M/SD: Lock Indicator for General Business Partner
9	GESCH	JGTGPNR	GESCH		☐	JGESCHL	☐	IS-M: Gender Key
10	JFAMST	JGTGPNR	JFAMST		☐	JFAMST	☐	IS-M: Business Partner's Marital Status
11	GPHERK	JGTGPNR	GPHERK		☐	GPHERK	☐	IS-M: Business Partner Origin
12	XNATUR	JGTGPNR	XNATUR		☐	XNATUR	☐	IS-M: Natural Person Indicator
13	JKTOKD	JGTGPNR	JKTOKD		☐	JKTOKD	☐	IS-M: Business Partner Account Group
14	MAILN	JGTGPNR	MAILN		☐	JMAILN	☐	IS-M: Mail Address
15	BERUFSL	JGTGPNR	BERUFSL		☐	BERUFSL	☐	IS-M: Occupation
16	JBRSCH	JGTGPNR	BRSCH		☐	BRSCH	☐	Industry key
17	JGEBDAT	JGTGPNR	JGEBDAT		☐	JGEBDAT	☐	IS-M: Date of Birth of a Business Partner
18	XVERMSACH	JGTGPNR	XVERMSACH		☐	XVERMSACH	☐	IS-M: BP Authorized to Receive Gifts
19	XOHNE	JGTGPNR	XOHNE		☐	XCPDK	☐	Indicator: Is the account a one-time account?
20	XDEBI	JGTGPNR	XDEBI		☐	JXDEBI	☐	IS-M: Indicator: Customer Exists
21	KUNNR	JGTGPNR	KUNNR		☐	JKUNNR	☐	IS-M: Customer Number in Previous System
22	FKUNNR	JGTGPNR	FKUNNR		☐	JFKUNNR	☐	IS-M: Customer Number in Non-SAP System
23	XKREDI	JGTGPNR	XKREDI		☐	XKREDI	☐	IS-M: Indicator: Vendor Exists
24	LIFNR	JGTGPNR	LIFNR		☐	JLIFNR	☐	IS-M: Vendor Number in Previous System
25	FLIFNR	JGTGPNR	FLIFNR		☐	JFLIFNR	☐	IS-M: Vendor Number in Non-SAP System
26	XMITARB	JGTGPNR	XMITARB		☐	XMITARB	☐	IS-M: Employee Indicator
27	PERNR	JGTGPNR	PERNR		☐	JPERNR2	☐	IS-M: Personnel Number
28	XNOWERB	JGTGPNR	XNOWERB		☐	XNOWERB	☐	IS-M: No Advertising
29	XEUW	JGTGPNR	XEUW		☐	XEUW	☐	IS-M: Retailer Indicator
30	XEUWLOEV	JGTGPNR	XEUWLOEV		☐	JXLV_EW	☐	IS-M: Deletion Flag for Retailer
31	XEUWLOEKZ	JGTGPNR	XEUWLOEKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
32	XEUWSPE	JGTGPNR	XEUWSPE		☐	XEWSPE	☐	IS-M/SD: Lock Indicator - Retailer
33	AUFSD	KNA1	AUFSD		☐	AUFSD_X	☐	Central order block for customer
34	BAHNE	KNA1	BAHNE		☐	BAHNE	☐	Express train station
35	BAHNS	KNA1	BAHNS		☐	BAHNS	☐	Train station
36	BBBNR	KNA1	BBBNR		☐	BBBNR	☐	International location number (part 1)
37	BBSNR	KNA1	BBSNR		☐	BBSNR	☐	International location number (Part 2)
38	BEGRU	KNA1	BEGRU		☐	BRGRU	☐	Authorization Group
39	BRSCH	KNA1	BRSCH		☐	BRSCH	☐	Industry key
40	BUBKZ	KNA1	BUBKZ		☐	BUBKZ	☐	Check digit for the international location number
41	DATLT	KNA1	DATLT		☐	DATLT	☐	Data communication line no.
42	EXABL	KNA1	EXABL		☐	EXABL	☐	Indicator: Unloading points exist
43	FAKSD	KNA1	FAKSD		☐	FAKSD_X	☐	Central billing block for customer
44	KNAZK	KNA1	KNAZK		☐	KNAZK	☐	Working Time Calendar
45	FISKN	KNA1	FISKN		☐	FISKN_D	☐	Account number of the master record with the fiscal address
46	KNRZA	KNA1	KNRZA		☐	KNRZA	☐	Account number of an alternative payer
47	KONZS	KNA1	KONZS		☐	KONZS	☐	Group key
48	KUKLA	KNA1	KUKLA		☐	KUKLA	☐	Customer classification
49	KTOKD	KNA1	KTOKD		☐	KTOKD	☐	Customer Account Group
50	LAND1	KNA1	LAND1		☐	LAND1_GP	☐	Country Key
51	LIFNR_KNA1	KNA1	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
52	LIFSD	KNA1	LIFSD		☐	LIFSD_X	☐	Central delivery block for the customer
53	LOCCO	KNA1	LOCCO		☐	LOCCO	☐	City Coordinates
54	LOEVM	KNA1	LOEVM		☐	LOEVM_X	☐	Central Deletion Flag for Master Record
55	NIELS	KNA1	NIELS		☐	NIELS	☐	Nielsen ID
56	COUNC	KNA1	COUNC		☐	COUNC	☐	County Code
57	CITYC	KNA1	CITYC		☐	CITYC	☐	City Code
58	RPMKR	KNA1	RPMKR		☐	RPMKR	☐	Regional market
59	SORTL	KNA1	SORTL		☐	SORTL	☐	Sort field
60	SPERR	KNA1	SPERR		☐	SPERB_X	☐	Central posting block
61	SPRAS	KNA1	SPRAS		☐	SPRAS	☐	Language Key
62	STCD1	KNA1	STCD1		☐	STCD1	☐	Tax Number 1
63	STCD2	KNA1	STCD2		☐	STCD2	☐	Tax Number 2
64	STKZA	KNA1	STKZA		☐	STKZA	☐	Indicator: Business Partner Subject to Equalization Tax?
65	STKZU	KNA1	STKZU		☐	STKZU	☐	Liable for VAT
66	LZONE	KNA1	LZONE		☐	LZONE	☐	Transportation zone to or from which the goods are delivered
67	XCPDK	KNA1	XCPDK		☐	XCPDK	☐	Indicator: Is the account a one-time account?
68	XZEMP	KNA1	XZEMP		☐	XREGU	☐	Indicator: Is an alternative payer allowed in document?
69	VBUND	KNA1	VBUND		☐	RASSC	☐	Company ID of trading partner
70	STCEG	KNA1	STCEG		☐	STCEG	☐	VAT Registration Number
71	DEAR1	KNA1	DEAR1		☐	DEAR1	☐	Indicator: Competitor
72	DEAR2	KNA1	DEAR2		☐	DEAR2	☐	Indicator: Sales partner
73	DEAR3	KNA1	DEAR3		☐	DEAR3	☐	Indicator: Sales prospect
74	DEAR4	KNA1	DEAR4		☐	DEAR4	☐	Indicator for customer type 4
75	DEAR5	KNA1	DEAR5		☐	DEAR5	☐	ID for default sold-to party
76	GFORM	KNA1	GFORM		☐	GFORM	☐	Legal status
77	BRAN1	KNA1	BRAN1		☐	BRAN1_D	☐	Industry code 1
78	BRAN2	KNA1	BRAN2		☐	BRAN2	☐	Industry code 2
79	BRAN3	KNA1	BRAN3		☐	BRAN3	☐	Industry code 3
80	BRAN4	KNA1	BRAN4		☐	BRAN4	☐	Industry code 4
81	BRAN5	KNA1	BRAN5		☐	BRAN5	☐	Industry code 5
82	EKONT	KNA1	EKONT		☐	EKONT	☐	Initial contact
83	UMSAT	KNA1	UMSAT		☐	UMSAT	☐	Annual sales
84	UMJAH	KNA1	UMJAH		☐	UMJAH	☐	Year For Which Sales are Given
85	UWAER	KNA1	UWAER		☐	UWAER	☐	Currency of Sales Volume
86	JMZAH	KNA1	JMZAH		☐	JMZAH	☐	Yearly number of employees
87	JMJAH	KNA1	JMJAH		☐	JMJAH	☐	Year for which the number of employees is given
88	KATR1	KNA1	KATR1		☐	KATR1	☐	Attribute 1
89	KATR2	KNA1	KATR2		☐	KATR2	☐	Attribute 2
90	KATR3	KNA1	KATR3		☐	KATR3	☐	Attribute 3
91	KATR4	KNA1	KATR4		☐	KATR4	☐	Attribute 4
92	KATR5	KNA1	KATR5		☐	KATR5	☐	Attribute 5
93	KATR6	KNA1	KATR6		☐	KATR6	☐	Attribute 6
94	KATR7	KNA1	KATR7		☐	KATR7	☐	Attribute 7
95	KATR8	KNA1	KATR8		☐	KATR8	☐	Attribute 8
96	KATR9	KNA1	KATR9		☐	KATR9	☐	Attribute 9
97	KATR10	KNA1	KATR10		☐	KATR10	☐	Attribute 10
98	STKZN	KNA1	STKZN		☐	STKZN	☐	Natural Person
99	UMSA1	KNA1	UMSA1		☐	UMSA1	☐	Annual sales
100	TXJCD	KNA1	TXJCD		☐	TXJCD	☐	Tax Jurisdiction
101	ERNAM	KNVV	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
102	ERDAT	KNVV	ERDAT		☐	ERDAT	☐	Date on which the record was created
103	BEGRU_KNVV	KNVV	BEGRU		☐	BEGRU	☐	Authorization Group
104	LOEVM_KNVV	KNVV	LOEVM		☐	LOEVM_V	☐	Deletion flag for customer (sales level)
105	VERSG	KNVV	VERSG		☐	STGKU	☐	Customer Statistics Group
106	AUFSD_KNVV	KNVV	AUFSD		☐	AUFSD_V	☐	Customer order block (sales area)
107	KALKS	KNVV	KALKS		☐	KALKS	☐	Pricing procedure assigned to this customer
108	KDGRP	KNVV	KDGRP		☐	KDGRP	☐	Customer group
109	BZIRK	KNVV	BZIRK		☐	BZIRK	☐	Sales district
110	KONDA	KNVV	KONDA		☐	KONDA	☐	Price Group (Customer)
111	PLTYP	KNVV	PLTYP		☐	PLTYP	☐	Price list type
112	AWAHR	KNVV	AWAHR		☐	AWAHR	☐	Order probability of the item
113	INCO1	KNVV	INCO1		☐	INCO1	☐	Incoterms (part 1)
114	INCO2	KNVV	INCO2		☐	INCO2	☐	Incoterms (part 2)
115	LIFSD_KNVV	KNVV	LIFSD		☐	LIFSD_V	☐	Customer delivery block (sales area)
116	AUTLF	KNVV	AUTLF		☐	AUTLF	☐	Complete delivery defined for each sales order?
117	ANTLF	KNVV	ANTLF		☐	ANTLF	☐	Maximum number of partial deliveries allowed per item
118	KZTLF	KNVV	KZTLF		☐	KZTLF	☐	Partial delivery at item level
119	KZAZU	KNVV	KZAZU		☐	KZAZU_D	☐	Order combination indicator
120	CHSPL	KNVV	CHSPL		☐	CHSPL	☐	Batch split allowed
121	LPRIO	KNVV	LPRIO		☐	LPRIO	☐	Delivery priority
122	EIKTO	KNVV	EIKTO		☐	EIKTO	☐	Shipper's (Our) Account Number at the Customer or Vendor
123	VSBED	KNVV	VSBED		☐	VSBED	☐	Shipping conditions
124	FAKSD_KNVV	KNVV	FAKSD		☐	FAKSD_V	☐	Billing block for customer (sales and distribution)
125	MRNKZ	KNVV	MRNKZ		☐	MRNKZ	☐	Manual invoice maintenance
126	PERFK	KNVV	PERFK		☐	PERFK	☐	Invoice dates (calendar identification)
127	PERRL	KNVV	PERRL		☐	PERRL	☐	Invoice list schedule (calendar identification)
128	KVAKZ	KNVV	KVAKZ		☐	KVAKZ	☐	Cost estimate indicator (inactive)
129	KVAWT	KNVV	KVAWT		☐	KVAWT	☐	Value limit for cost estimate (inactive)
130	WAERS	KNVV	WAERS		☐	WAERS_V02D	☐	Currency
131	KLABC	KNVV	KLABC		☐	KLABC	☐	Customer classification (ABC analysis)
132	KTGRD	KNVV	KTGRD		☐	KTGRD	☐	Account assignment group for this customer
133	ZTERM	KNVV	ZTERM		☐	DZTERM	☐	Terms of payment key
134	VWERK	KNVV	VWERK		☐	DWERK_EXT	☐	Delivering Plant (Own or External)
135	VKGRP	KNVV	VKGRP		☐	VKGRP	☐	Sales group
136	VKBUR	KNVV	VKBUR		☐	VKBUR	☐	Sales office
137	VSORT	KNVV	VSORT		☐	VSORT	☐	Item proposal
138	KVGR1	KNVV	KVGR1		☐	KVGR1	☐	Customer group 1
139	KVGR2	KNVV	KVGR2		☐	KVGR2	☐	Customer group 2
140	KVGR3	KNVV	KVGR3		☐	KVGR3	☐	Customer group 3
141	KVGR4	KNVV	KVGR4		☐	KVGR4	☐	Customer group 4
142	KVGR5	KNVV	KVGR5		☐	KVGR5	☐	Customer group 5
143	KURST	KNVV	KURST		☐	KURST	☐	Exchange Rate Type
144	ERFUSER	JGTEUWV	ERFUSER		☐	ERFUSER	☐	Created By
145	ERFDATE	JGTEUWV	ERFDATE		☐	ERFDATE	☐	Created On
146	ERFTIME	JGTEUWV	ERFTIME		☐	ERFTIME	☐	Time Created
147	AENUSER	JGTEUWV	AENUSER		☐	AENUSER	☐	Last Changed By
148	AENDATE	JGTEUWV	AENDATE		☐	AENDATE	☐	Date of Last Change
149	AENTIME	JGTEUWV	AENTIME		☐	AENTIME	☐	Time of Last Change
150	XEUWLOE	JGTEUWV	XEUWLOE		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
151	VERKGB	JGTEUWV	VERKGB		☐	VERKGB	☐	IS-M: Sales Region
152	VGEINW	JGTEUWV	VGEINW		☐	VGEINW	☐	IS-M: Population of Sales Area
153	ANZMIT	JGTEUWV	ANZMIT		☐	ANZMIT	☐	IS-M: Number of Retail Employees
154	MBRSYS	JGTEUWV	MBRSYS		☐	MBRSYS	☐	IS-M: Automatic Payment System
155	EVKSTART	JGTEUWV	EVKSTART		☐	EVKSTART	☐	IS-M: Point of Sale Category
156	EVKSTBEZ	JGTEUWV	EVKSTBEZ		☐	EVKSTBEZ	☐	POS Type
157	XLOTTO	JGTEUWV	XLOTTO		☐	XLOTTO	☐	IS-M: Lottery Agent Indicator
158	EVKFLAECHE	JGTEUWV	EVKFLAECHE		☐	EVKFLAECHE	☐	IS-M: POS Area Key
159	EUMSEINFL	JGTEUWV	EUMSEINFL		☐	EUMSEINFL	☐	External Sales Influence at POS (Primary)
160	EBEDIENART	JGTEUWV	EBEDIENART		☐	EBEDIENART	☐	Service Type for Point of Sale
161	EFREQUENZ	JGTEUWV	EFREQUENZ		☐	EFREQUENZ	☐	IS-M: POS Customer Frequency per Week
162	BAGNR	JGTEUWV	BAGNR		☐	BAGNR	☐	IS-M: BAG Transaction Number
163	ISPCNR	JGTEUWV	ISPCNR		☐	ISPCNR	☐	IS-M: ISPC Number
164	VDZNR	JGTEUWV	VDZNR		☐	VDZNR	☐	IS-M: VDZ Number
165	OEFFZT	JGTEUWV	OEFFZT		☐	OEFFZT	☐	IS-M: Point of Sale Opening Time
166	SCHLZT	JGTEUWV	SCHLZT		☐	SCHLZT	☐	IS-M: POS Closing Time
167	OEFFMO	JGTEUWV	OEFFMO		☐	OEFFMO	☐	IS-M: Opening Type Monday
168	OEFFDI	JGTEUWV	OEFFDI		☐	OEFFDI	☐	IS-M: Opening Type Tuesday
169	OEFFMI	JGTEUWV	OEFFMI		☐	OEFFMI	☐	IS-M: Opening Type Wednesday
170	OEFFDO	JGTEUWV	OEFFDO		☐	OEFFDO	☐	IS-M: Opening Type Thursday
171	OEFFFR	JGTEUWV	OEFFFR		☐	OEFFFR	☐	IS-M: Opening Type Friday
172	OEFFSA	JGTEUWV	OEFFSA		☐	OEFFSA	☐	IS-M: Opening Type Saturday
173	OEFFSO	JGTEUWV	OEFFSO		☐	OEFFSO	☐	IS-M: Opening Type Sunday
174	XREMRECHT	JGTEUWV	XREMRECHT		☐	XREMRECHT	☐	IS-M: Right of Return
175	REMART	JGTEUWV	REMART		☐	REMART	☐	Return Type
176	REMWEISE	JGTEUWV	REMWEISE		☐	REMWEISE	☐	Return Method
177	REMSP	JGTEUWV	REMSP		☐	REMSP	☐	IS-M: Billing Block for Return Notification
178	KOMMENT	JGTEUWV	KOMMENT		☐	KOMM50	☐	IS-M: Comment 50 Characters in Length
179	REGIO	KNA1	REGIO		☐	REGIO	☐	Region (State, Province, County)

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