SAP ABAP Table JGTEUWV (IS-M: Retailer)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M-MD (Application Component) Master Data
     ⤷ JMDGEN (Package) Generic Master Data Media

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JGTEUWV	Table Relationship Diagram
Short Description	IS-M: Retailer

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	EWKUN	☑	EWKUN	GPNR	CHAR	10	0	IS-M: Retailer	JGTGPNR
3	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
4	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
5	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
6	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
7	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
8	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
9	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
10	XEUWLOE	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
11	.INCLUDE	☐				0	0	IS-M: Retail Data Fields for BP
12	VERKGB	☐	VERKGB	TEXT50	CHAR	50	0	IS-M: Sales Region
13	VGEINW	☐	VGEINW	ANZPERS	NUMC	10	0	IS-M: Population of Sales Area
14	ANZMIT	☐	ANZMIT	JANZMA	NUMC	5	0	IS-M: Number of Retail Employees
15	MBRSYS	☐	MBRSYS	MBRSYS	CHAR	2	0	IS-M: Automatic Payment System	TJG15
16	EVKSTART	☐	EVKSTART	EVKSTART	CHAR	2	0	IS-M: Point of Sale Category	TJG17
17	EVKSTBEZ	☐	EVKSTBEZ	EVKSTBEZ	CHAR	4	0	POS Type	TJG19
18	XLOTTO	☐	XLOTTO	XFELD	CHAR	1	0	IS-M: Lottery Agent Indicator
19	EVKFLAECHE	☐	EVKFLAECHE	EVKFLAECHE	CHAR	2	0	IS-M: POS Area Key	TJG21
20	EUMSEINFL	☐	EUMSEINFL	EUMSEINFL	CHAR	2	0	External Sales Influence at POS (Primary)	TJG25
21	EBEDIENART	☐	EBEDIENART	EBEDIENART	CHAR	1	0	Service Type for Point of Sale	TJG23
22	EFREQUENZ	☐	EFREQUENZ	EFREQUENZ	CHAR	1	0	IS-M: POS Customer Frequency per Week	TJG27
23	BAGNR	☐	BAGNR	TEXT5	CHAR	5	0	IS-M: BAG Transaction Number
24	ISPCNR	☐	ISPCNR	TEXT10	CHAR	10	0	IS-M: ISPC Number
25	VDZNR	☐	VDZNR	VDZNR	CHAR	20	0	IS-M: VDZ Number
26	OEFFZT	☐	OEFFZT	OEFFZT	CHAR	1	0	IS-M: Point of Sale Opening Time	TJG29
27	SCHLZT	☐	SCHLZT		CHAR	1	0	IS-M: POS Closing Time	TJG31
28	OEFFMO	☐	OEFFMO	OEFFTG	CHAR	1	0	IS-M: Opening Type Monday	TJG33
29	OEFFDI	☐	OEFFDI	OEFFTG	CHAR	1	0	IS-M: Opening Type Tuesday	TJG33
30	OEFFMI	☐	OEFFMI	OEFFTG	CHAR	1	0	IS-M: Opening Type Wednesday	TJG33
31	OEFFDO	☐	OEFFDO	OEFFTG	CHAR	1	0	IS-M: Opening Type Thursday	TJG33
32	OEFFFR	☐	OEFFFR	OEFFTG	CHAR	1	0	IS-M: Opening Type Friday	TJG33
33	OEFFSA	☐	OEFFSA	OEFFTG	CHAR	1	0	IS-M: Opening Type Saturday	TJG33
34	OEFFSO	☐	OEFFSO	OEFFTG	CHAR	1	0	IS-M: Opening Type Sunday	TJG33
35	XREMRECHT	☐	XREMRECHT	XFELD	CHAR	1	0	IS-M: Right of Return
36	REMART	☐	REMART	REMART	CHAR	1	0	Return Type
37	REMWEISE	☐	REMWEISE	REMWEISE	CHAR	1	0	Return Method
38	REMSP	☐	REMSP	XFELD	CHAR	1	0	IS-M: Billing Block for Return Notification
39	XISPCTEILN	☐	XISPCTEILN	XFELD	CHAR	1	0	IS-M: Indicator: Business Partner Is EDI Participant
40	ISPCTEILN	☐	ISPCTEILN	NUM8	NUMC	8	0	IS-M: EDI Participant Number
41	ISPCART	☐	ISPCART	JISPCART	NUMC	1	0	IS-M: EDI Participant Type	TJGR1
42	ISMGEOKATEGORIE	☐	ISMGEOKATEGORIE	ISMGEOKATEGORIE	CHAR	2	0	Geography Category (Geographical Location) for Point of Sale	TJGGEOCAT
43	ISMNUMBERPOSTERS	☐	ISMNUMBERPOSTERS	INT2	INT2	5	0	Advertising Space Available
44	ISMPLANCALENDER	☐	ISMPLANCALENDER	WFCID	CHAR	2	0	Planning Calendar	TFACD
45	KOMMENT	☐	KOMM50	TEXT50	CHAR	50	0	IS-M: Comment 50 Characters in Length
46	RETURNGPNR	☐	EWKUN	GPNR	CHAR	10	0	IS-M: Retailer	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JGTEUWV	EBEDIENART	TJG23	EBEDIENART	REF	C	CN
2	JGTEUWV	EFREQUENZ	TJG27	EFREQUENZ	REF	C	CN
3	JGTEUWV	EUMSEINFL	TJG25	EUMSEINFL	REF	C	CN
4	JGTEUWV	EVKFLAECHE	TJG21	EVKFLAECHE	REF	C	CN
5	JGTEUWV	EVKSTART	TJG17	EVKSTART	REF	C	CN
6	JGTEUWV	EVKSTBEZ	TJG19	EVKSTBEZ	REF	C	CN
7	JGTEUWV	EWKUN	JGTGPNR	GPNR	KEY	1	C
8	JGTEUWV	ISMGEOKATEGORIE	TJGGEOCAT	ISMGEOKATEGORIE	KEY
9	JGTEUWV	ISMPLANCALENDER	TFACD	IDENT	KEY	1	CN
10	JGTEUWV	ISPCART	TJGR1	ISPCART
11	JGTEUWV	MANDT	T000	MANDT	KEY	1	CN
12	JGTEUWV	MBRSYS	TJG15	MBRSYS	REF	C	CN
13	JGTEUWV	OEFFDI	TJG33	OEFFTG	REF	C	CN
14	JGTEUWV	OEFFDO	TJG33	OEFFTG	REF	C	CN
15	JGTEUWV	OEFFFR	TJG33	OEFFTG	REF	C	CN
16	JGTEUWV	OEFFMI	TJG33	OEFFTG	REF	C	CN
17	JGTEUWV	OEFFMO	TJG33	OEFFTG	REF	C	CN
18	JGTEUWV	OEFFSA	TJG33	OEFFTG	REF	C	CN
19	JGTEUWV	OEFFSO	TJG33	OEFFTG	REF	C	CN
20	JGTEUWV	OEFFZT	TJG29	OEFFZT	REF	C	CN
21	JGTEUWV	SCHLZT	TJG31	SCHLZT	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in