JGTEUWV SAP (IS-M: Retailer) Table details
Dictionary Type: Table
Description: IS-M: Retailer
Description: IS-M: Retailer
Table field list including key, data, relationships and ABAP select examples
JGTEUWV is a standard SAP Table which is used to store IS-M: Retailer data and is available within R/3 SAP systems depending on the version and release level.
The JGTEUWV table consists of various fields, each holding specific information or linking keys about IS-M: Retailer data available in SAP. These include EWKUN (IS-M: Retailer), ERFUSER (Created By), ERFDATE (Created On), ERFTIME (Time Created).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP JGTEUWV table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
EWKUN | IS-M: Retailer | EWKUN | CHAR | 10 | JGTGPNR | ALPHA | GPNR | ||
ERFUSER | Created By | ERFUSER | CHAR | 12 | USNAM | ||||
ERFDATE | Created On | ERFDATE | DATS | 8 | DATUM | ||||
ERFTIME | Time Created | ERFTIME | TIMS | 6 | UZEIT | ||||
AENUSER | Last Changed By | AENUSER | CHAR | 12 | USNAM | ||||
AENDATE | Date of Last Change | AENDATE | DATS | 8 | DATUM | ||||
AENTIME | Time of Last Change | AENTIME | TIMS | 6 | UZEIT | ||||
XEUWLOE | IS-M: Deletion Indicator (Role-Specific) | XLOESCHKZ | CHAR | 1 | XFELD | ||||
ANZMIT | IS-M: Number of Retail Employees | ANZMIT | NUMC | 5 | JANZMA | ||||
EVKSTART | IS-M: Point of Sale Category | EVKSTART | CHAR | 2 | TJG17 | ALPHA | EVKSTART | ||
EVKSTBEZ | POS Type | EVKSTBEZ | CHAR | 4 | TJG19 | EVKSTBEZ | |||
SEASON | Season Indicator | ISMPOSSEASON | CHAR | 2 | TJGPOS01 | ISMPOSSEASON | |||
CHAINCODE | Retail Chain to Which POS Belongs | ISMPOSCHAINCODE | CHAR | 10 | TJGPOS06 | ISMPOSCHAINCODE | |||
CHAINCHANNEL | Distribution Channel of Retail Chain to Which POS Belongs | ISMPOSCHAINCHANNEL | CHAR | 10 | TJGPOS07 | ISMPOSCHAINCHANNEL | |||
CHAINID | ID of POS in Retail Chain | ISMPOSCHAINID | CHAR | 10 | ISMPOSCHAINID | ||||
SHOPINSHOP | IS-M: Shop in Shop Indicator | ISMSHOPINSHOP | CHAR | 1 | XFELD | ||||
SHOPINSHOP_AREA | POS Shelf Space - Shop-in-Shop | ISMPOSSHOPINSHOP_SPACE | CHAR | 2 | TJG21 | ALPHA | EVKFLAECHE | ||
SHOP_CATEGORY | Category of Main Business (Shop-in-Shop) | ISMPOSSHOPBEZ | CHAR | 4 | TJG19 | EVKSTBEZ | |||
EVKFLAECHE | IS-M: POS Area Key | EVKFLAECHE | CHAR | 2 | TJG21 | ALPHA | EVKFLAECHE | ||
ISMGEOKATEGORIE | Geography Category (Geographical Location) for Point of Sale | ISMGEOKATEGORIE | CHAR | 2 | TJGGEOCAT | ISMGEOKATEGORIE | |||
NO_OF_POS | Number of POS with Same Address | ISMPOSCOUNTER | INT2 | 5 | INT2 | ||||
NO_OF_SUPPLIERS | Number of Press Vendors for a Point of Sale | ISMPOSSUPPLIER | INT2 | 5 | INT2 | ||||
PRESS_SALESCAT | Type of Press Products | ISMPOSPRESSSALESCATEGORY | CHAR | 5 | TJGPOS05 | ISMPOSPRESSSALESCATEGORY | |||
PRESS_SALESVOL | Weekly Press Sales | ISMPOSPRESSSALESVOLUME | CHAR | 5 | TJGPOS09 | ISMPOSPRESSSALESVOLUME | |||
IUMSEINFL | Internal (Primary) Influencing Factor for POS Sales | IUMSEINFL | CHAR | 2 | TJGPOS02 | IUMSEINFL | |||
IUMSEINFL2 | Internal (Secondary) Influencing Factor for POS Sales | IUMSEINFL2 | CHAR | 2 | TJGPOS02 | IUMSEINFL | |||
IUMSEINFL3 | Internal (Tertiary) Influencing Factor for POS Sales | IUMSEINFL3 | CHAR | 2 | TJGPOS02 | IUMSEINFL | |||
EUMSEINFL | External Sales Influence at POS (Primary) | EUMSEINFL | CHAR | 2 | TJG25 | ALPHA | EUMSEINFL | ||
EUMSEINFL2 | External (Secondary) Influencing Factor for POS Sales | EUMSEINFL2 | CHAR | 2 | TJG25 | ALPHA | EUMSEINFL | ||
EUMSEINFL3 | External (Tertiary) Influencing Factor for POS Sales | EUMSEINFL3 | CHAR | 2 | TJG25 | ALPHA | EUMSEINFL | ||
EFREQUENZ | IS-M: POS Customer Frequency per Week | EFREQUENZ | CHAR | 1 | TJG27 | EFREQUENZ | |||
EFREQUENCE_ORIG | POS: Origin of Customer Frequency | ISMPOSEFREQUENZORIGIN | CHAR | 2 | TJGPOS04 | ISMPOSEFREQUENZORIGIN | |||
CASH_SCANNER | Scanner Cash Desk at Point of Sale | ISMCASHSCAN | CHAR | 1 | TJGPOS03 | ISMCASHSCAN | |||
SALES_COUNTER | Sales Counter at Point of Sale | ISMPOSSALESCOUNTER | CHAR | 1 | ISMPOSSALESCOUNTER | ||||
EBEDIENART | Service Type at Point of Sale | EBEDIENART | CHAR | 1 | TJG23 | EBEDIENART | |||
ISMNUMBERPOSTERS | Number of Advertising Spaces at Point of Sale | ISMNUMBERPOSTERS | INT2 | 5 | INT2 | ||||
ISMPLANCALENDER | Planning Calendar for Point of Sale | ISMPLANCALENDER | CHAR | 2 | TFACD | WFCID | |||
BUSINESSHOURS_ID | Business Hours ID (Default Number) | ISMPOSBUSINESSHOURSID | CHAR | 3 | TJGPOS08 | ISMPOSBUSINESSHOURSID | |||
OPEN_MOR_MO | Business Hours: Monday Mornings From | ISMPOSOPENMO1 | TIMS | 6 | UHRZT | ||||
CLOSE_MOR_MO | Business Hours: Monday Mornings To | ISMPOSCLOSEMO1 | TIMS | 6 | UHRZT | ||||
OPEN_AFT_MO | Business Hours: Monday Afternoons From | ISMPOSOPENMO2 | TIMS | 6 | UHRZT | ||||
CLOSE_AFT_MO | Business Hours: Monday Afternoons To | ISMPOSCLOSEMO2 | TIMS | 6 | UHRZT | ||||
OPEN_MOR_TU | Business Hours: Tuesday Mornings From | ISMPOSOPENTU1 | TIMS | 6 | UHRZT | ||||
CLOSE_MOR_TU | Business Hours: Tuesday Mornings To | ISMPOSCLOSETU1 | TIMS | 6 | UHRZT | ||||
OPEN_AFT_TU | Business Hours: Tuesday Afternoons From | ISMPOSOPENTU2 | TIMS | 6 | UHRZT | ||||
CLOSE_AFT_TU | Business Hours: Tuesday Afternoons To | ISMPOSCLOSETU2 | TIMS | 6 | UHRZT | ||||
OPEN_MOR_WE | Business Hours: Wednesday Mornings From | ISMPOSOPENWE1 | TIMS | 6 | UHRZT | ||||
CLOSE_MOR_WE | Business Hours: Wednesday Mornings To | ISMPOSCLOSEWE1 | TIMS | 6 | UHRZT | ||||
OPEN_AFT_WE | Business Hours: Wednesday Afternoons From | ISMPOSOPENWE2 | TIMS | 6 | UHRZT | ||||
CLOSE_AFT_WE | Business Hours: Wednesday Afternoons To | ISMPOSCLOSEWE2 | TIMS | 6 | UHRZT | ||||
OPEN_MOR_TH | Business Hours: Thursday Mornings From | ISMPOSOPENTH1 | TIMS | 6 | UHRZT | ||||
CLOSE_MOR_TH | Business Hours: Thursday Mornings To | ISMPOSCLOSETH1 | TIMS | 6 | UHRZT | ||||
OPEN_AFT_TH | Business Hours: Thursday Afternoons From | ISMPOSOPENTH2 | TIMS | 6 | UHRZT | ||||
CLOSE_AFT_TH | Business Hours: Thursday Afternoons To | ISMPOSCLOSETH2 | TIMS | 6 | UHRZT | ||||
OPEN_MOR_FR | Business Hours: Friday Mornings From | ISMPOSOPENFR1 | TIMS | 6 | UHRZT | ||||
CLOSE_MOR_FR | Business Hours: Friday Mornings To | ISMPOSCLOSEFR1 | TIMS | 6 | UHRZT | ||||
OPEN_AFT_FR | Business Hours: Friday Afternoons From | ISMPOSOPENFR2 | TIMS | 6 | UHRZT | ||||
CLOSE_AFT_FR | Business Hours: Friday Afternoons To | ISMPOSCLOSEFR2 | TIMS | 6 | UHRZT | ||||
OPEN_MOR_SA | Business Hours: Saturday Mornings From | ISMPOSOPENSA1 | TIMS | 6 | UHRZT | ||||
CLOSE_MOR_SA | Business Hours: Saturday Mornings To | ISMPOSCLOSESA1 | TIMS | 6 | UHRZT | ||||
OPEN_AFT_SA | Business Hours: Saturday Afternoons From | ISMPOSOPENSA2 | TIMS | 6 | UHRZT | ||||
CLOSE_AFT_SA | Business Hours: Saturday Afternoons To | ISMPOSCLOSESA2 | TIMS | 6 | UHRZT | ||||
OPEN_MOR_SU | Business Hours: Sunday Mornings From | ISMPOSOPENSU1 | TIMS | 6 | UHRZT | ||||
CLOSE_MOR_SU | Business Hours: Sunday Mornings To | ISMPOSCLOSESU1 | TIMS | 6 | UHRZT | ||||
OPEN_AFT_SU | Business Hours: Sunday Afternoons From | ISMPOSOPENSU2 | TIMS | 6 | UHRZT | ||||
CLOSE_AFT_SU | Business Hours: Sunday Afternoons To | ISMPOSCLOSESU2 | TIMS | 6 | UHRZT | ||||
OEFFZT | IS-M: Point of Sale Opening Time | OEFFZT | CHAR | 1 | TJG29 | OEFFZT | |||
SCHLZT | IS-M: POS Closing Time | SCHLZT | CHAR | 1 | TJG31 | ||||
OEFFMO | IS-M: Opening Type Monday | OEFFMO | CHAR | 1 | TJG33 | OEFFTG | |||
OEFFDI | IS-M: Opening Type Tuesday | OEFFDI | CHAR | 1 | TJG33 | OEFFTG | |||
OEFFMI | IS-M: Opening Type Wednesday | OEFFMI | CHAR | 1 | TJG33 | OEFFTG | |||
OEFFDO | IS-M: Opening Type Thursday | OEFFDO | CHAR | 1 | TJG33 | OEFFTG | |||
OEFFFR | IS-M: Opening Type Friday | OEFFFR | CHAR | 1 | TJG33 | OEFFTG | |||
OEFFSA | IS-M: Opening Type Saturday | OEFFSA | CHAR | 1 | TJG33 | OEFFTG | |||
OEFFSO | IS-M: Opening Type Sunday | OEFFSO | CHAR | 1 | TJG33 | OEFFTG | |||
XLOTTO | IS-M: Lottery Agent Indicator | XLOTTO | CHAR | 1 | XFELD | ||||
MBRSYS | IS-M: Automatic Payment System | MBRSYS | CHAR | 2 | TJG15 | ALPHA | MBRSYS | ||
BAGNR | IS-M: BAG Transaction Number | BAGNR | CHAR | 5 | TEXT5 | ||||
ISPCNR | IS-M: ISPC Number | ISPCNR | CHAR | 10 | TEXT10 | ||||
XISPCTEILN | IS-M: Indicator: Business Partner Is EDI Participant | XISPCTEILN | CHAR | 1 | XFELD | ||||
ISPCTEILN | IS-M: EDI Participant Number | ISPCTEILN | NUMC | 8 | NUM8 | ||||
ISPCART | IS-M: EDI Participant Type | ISPCART | NUMC | 1 | TJGR1 | JISPCART | |||
VDZNR | IS-M: VDZ Number | VDZNR | CHAR | 20 | VDZNR | ||||
RECALLCALENDER | Recall Calendar | ISM_RC_CALENDER | CHAR | 2 | TFACD | WFCID | |||
RC_ALLOWED_MO | Recall Allowed on Monday | ISM_RC_ALLOWED_MO | CHAR | 1 | XFELD | ||||
RC_ALLOWED_TU | Recall Allowed on Tuesday | ISM_RC_ALLOWED_TU | CHAR | 1 | XFELD | ||||
RC_ALLOWED_WD | Recall Allowed on Wednesday | ISM_RC_ALLOWED_WD | CHAR | 1 | XFELD | ||||
RC_ALLOWED_TH | Recall Allowed on Thursday | ISM_RC_ALLOWED_TH | CHAR | 1 | XFELD | ||||
RC_ALLOWED_FR | Recall Allowed on Friday | ISM_RC_ALLOWED_FR | CHAR | 1 | XFELD | ||||
RC_ALLOWED_SA | Recall Allowed on Saturday | ISM_RC_ALLOWED_SA | CHAR | 1 | XFELD | ||||
RC_ALLOWED_SU | Recall Allowed on Sunday | ISM_RC_ALLOWED_SU | CHAR | 1 | XFELD | ||||
RECALLGROUP | Recall Group | JKSDRECALLGROUP | CHAR | 4 | TJKSDCOLCUSTGRP | JKSDRECALLGROUP | |||
VERKGB | IS-M: Sales Region | VERKGB | CHAR | 50 | TEXT50 | ||||
VGEINW | IS-M: Population of Sales Area | VGEINW | NUMC | 10 | ANZPERS | ||||
XREMRECHT | IS-M: Right of Return | XREMRECHT | CHAR | 1 | XFELD | ||||
REMART | Return Type | REMART | CHAR | 1 | REMART | ||||
REMWEISE | Return Method | REMWEISE | CHAR | 1 | REMWEISE | ||||
REMSP | IS-M: Billing Block for Return Notification | REMSP | CHAR | 1 | XFELD | ||||
KOMMENT | IS-M: Comment 50 Characters in Length | KOMM50 | CHAR | 50 | TEXT50 | ||||
RETURNGPNR | IS-M: Retailer | EWKUN | CHAR | 10 | Assigned to domain | ALPHA | GPNR | ||
LAST_CHANGE | Time Stamp of Last Change for BI Delta Exchange | ISM_BI_DELTA_TIMESTAMP | DEC | 15 | TZNTSTMPS |
Key field | Non-key field |
How do I retrieve data from SAP table JGTEUWV using ABAP code
The following ABAP code Example will allow you to do a basic selection on JGTEUWV to SELECT all data from the tableDATA: WA_JGTEUWV TYPE JGTEUWV.
SELECT SINGLE *
FROM JGTEUWV
INTO CORRESPONDING FIELDS OF WA_JGTEUWV
WHERE...
How to access SAP table JGTEUWV
Within an ECC or HANA version of SAP you can also view further information about JGTEUWV and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects