JGTEUWV SAP (IS-M: Retailer) Table details

Dictionary Type: Table
Description: IS-M: Retailer




ABAP Code to SELECT data from JGTEUWV
Related tables to JGTEUWV
Access table JGTEUWV




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
MANDTClient MANDTCLNT3T000MANDT
EWKUNIS-M: Retailer EWKUNCHAR10JGTGPNRALPHAGPNR
ERFUSERCreated By ERFUSERCHAR12USNAM
ERFDATECreated On ERFDATEDATS8DATUM
ERFTIMETime Created ERFTIMETIMS6UZEIT
AENUSERLast Changed By AENUSERCHAR12USNAM
AENDATEDate of Last Change AENDATEDATS8DATUM
AENTIMETime of Last Change AENTIMETIMS6UZEIT
XEUWLOEIS-M: Deletion Indicator (Role-Specific) XLOESCHKZCHAR1XFELD
ANZMITIS-M: Number of Retail Employees ANZMITNUMC5JANZMA
EVKSTARTIS-M: Point of Sale Category EVKSTARTCHAR2TJG17ALPHAEVKSTART
EVKSTBEZPOS Type EVKSTBEZCHAR4TJG19EVKSTBEZ
SEASONSeason Indicator ISMPOSSEASONCHAR2TJGPOS01ISMPOSSEASON
CHAINCODERetail Chain to Which POS Belongs ISMPOSCHAINCODECHAR10TJGPOS06ISMPOSCHAINCODE
CHAINCHANNELDistribution Channel of Retail Chain to Which POS Belongs ISMPOSCHAINCHANNELCHAR10TJGPOS07ISMPOSCHAINCHANNEL
CHAINIDID of POS in Retail Chain ISMPOSCHAINIDCHAR10ISMPOSCHAINID
SHOPINSHOPIS-M: Shop in Shop Indicator ISMSHOPINSHOPCHAR1XFELD
SHOPINSHOP_AREAPOS Shelf Space - Shop-in-Shop ISMPOSSHOPINSHOP_SPACECHAR2TJG21ALPHAEVKFLAECHE
SHOP_CATEGORYCategory of Main Business (Shop-in-Shop) ISMPOSSHOPBEZCHAR4TJG19EVKSTBEZ
EVKFLAECHEIS-M: POS Area Key EVKFLAECHECHAR2TJG21ALPHAEVKFLAECHE
ISMGEOKATEGORIEGeography Category (Geographical Location) for Point of Sale ISMGEOKATEGORIECHAR2TJGGEOCATISMGEOKATEGORIE
NO_OF_POSNumber of POS with Same Address ISMPOSCOUNTERINT25INT2
NO_OF_SUPPLIERSNumber of Press Vendors for a Point of Sale ISMPOSSUPPLIERINT25INT2
PRESS_SALESCATType of Press Products ISMPOSPRESSSALESCATEGORYCHAR5TJGPOS05ISMPOSPRESSSALESCATEGORY
PRESS_SALESVOLWeekly Press Sales ISMPOSPRESSSALESVOLUMECHAR5TJGPOS09ISMPOSPRESSSALESVOLUME
IUMSEINFLInternal (Primary) Influencing Factor for POS Sales IUMSEINFLCHAR2TJGPOS02IUMSEINFL
IUMSEINFL2Internal (Secondary) Influencing Factor for POS Sales IUMSEINFL2CHAR2TJGPOS02IUMSEINFL
IUMSEINFL3Internal (Tertiary) Influencing Factor for POS Sales IUMSEINFL3CHAR2TJGPOS02IUMSEINFL
EUMSEINFLExternal Sales Influence at POS (Primary) EUMSEINFLCHAR2TJG25ALPHAEUMSEINFL
EUMSEINFL2External (Secondary) Influencing Factor for POS Sales EUMSEINFL2CHAR2TJG25ALPHAEUMSEINFL
EUMSEINFL3External (Tertiary) Influencing Factor for POS Sales EUMSEINFL3CHAR2TJG25ALPHAEUMSEINFL
EFREQUENZIS-M: POS Customer Frequency per Week EFREQUENZCHAR1TJG27EFREQUENZ
EFREQUENCE_ORIGPOS: Origin of Customer Frequency ISMPOSEFREQUENZORIGINCHAR2TJGPOS04ISMPOSEFREQUENZORIGIN
CASH_SCANNERScanner Cash Desk at Point of Sale ISMCASHSCANCHAR1TJGPOS03ISMCASHSCAN
SALES_COUNTERSales Counter at Point of Sale ISMPOSSALESCOUNTERCHAR1ISMPOSSALESCOUNTER
EBEDIENARTService Type at Point of Sale EBEDIENARTCHAR1TJG23EBEDIENART
ISMNUMBERPOSTERSNumber of Advertising Spaces at Point of Sale ISMNUMBERPOSTERSINT25INT2
ISMPLANCALENDERPlanning Calendar for Point of Sale ISMPLANCALENDERCHAR2TFACDWFCID
BUSINESSHOURS_IDBusiness Hours ID (Default Number) ISMPOSBUSINESSHOURSIDCHAR3TJGPOS08ISMPOSBUSINESSHOURSID
OPEN_MOR_MOBusiness Hours: Monday Mornings From ISMPOSOPENMO1TIMS6UHRZT
CLOSE_MOR_MOBusiness Hours: Monday Mornings To ISMPOSCLOSEMO1TIMS6UHRZT
OPEN_AFT_MOBusiness Hours: Monday Afternoons From ISMPOSOPENMO2TIMS6UHRZT
CLOSE_AFT_MOBusiness Hours: Monday Afternoons To ISMPOSCLOSEMO2TIMS6UHRZT
OPEN_MOR_TUBusiness Hours: Tuesday Mornings From ISMPOSOPENTU1TIMS6UHRZT
CLOSE_MOR_TUBusiness Hours: Tuesday Mornings To ISMPOSCLOSETU1TIMS6UHRZT
OPEN_AFT_TUBusiness Hours: Tuesday Afternoons From ISMPOSOPENTU2TIMS6UHRZT
CLOSE_AFT_TUBusiness Hours: Tuesday Afternoons To ISMPOSCLOSETU2TIMS6UHRZT
OPEN_MOR_WEBusiness Hours: Wednesday Mornings From ISMPOSOPENWE1TIMS6UHRZT
CLOSE_MOR_WEBusiness Hours: Wednesday Mornings To ISMPOSCLOSEWE1TIMS6UHRZT
OPEN_AFT_WEBusiness Hours: Wednesday Afternoons From ISMPOSOPENWE2TIMS6UHRZT
CLOSE_AFT_WEBusiness Hours: Wednesday Afternoons To ISMPOSCLOSEWE2TIMS6UHRZT
OPEN_MOR_THBusiness Hours: Thursday Mornings From ISMPOSOPENTH1TIMS6UHRZT
CLOSE_MOR_THBusiness Hours: Thursday Mornings To ISMPOSCLOSETH1TIMS6UHRZT
OPEN_AFT_THBusiness Hours: Thursday Afternoons From ISMPOSOPENTH2TIMS6UHRZT
CLOSE_AFT_THBusiness Hours: Thursday Afternoons To ISMPOSCLOSETH2TIMS6UHRZT
OPEN_MOR_FRBusiness Hours: Friday Mornings From ISMPOSOPENFR1TIMS6UHRZT
CLOSE_MOR_FRBusiness Hours: Friday Mornings To ISMPOSCLOSEFR1TIMS6UHRZT
OPEN_AFT_FRBusiness Hours: Friday Afternoons From ISMPOSOPENFR2TIMS6UHRZT
CLOSE_AFT_FRBusiness Hours: Friday Afternoons To ISMPOSCLOSEFR2TIMS6UHRZT
OPEN_MOR_SABusiness Hours: Saturday Mornings From ISMPOSOPENSA1TIMS6UHRZT
CLOSE_MOR_SABusiness Hours: Saturday Mornings To ISMPOSCLOSESA1TIMS6UHRZT
OPEN_AFT_SABusiness Hours: Saturday Afternoons From ISMPOSOPENSA2TIMS6UHRZT
CLOSE_AFT_SABusiness Hours: Saturday Afternoons To ISMPOSCLOSESA2TIMS6UHRZT
OPEN_MOR_SUBusiness Hours: Sunday Mornings From ISMPOSOPENSU1TIMS6UHRZT
CLOSE_MOR_SUBusiness Hours: Sunday Mornings To ISMPOSCLOSESU1TIMS6UHRZT
OPEN_AFT_SUBusiness Hours: Sunday Afternoons From ISMPOSOPENSU2TIMS6UHRZT
CLOSE_AFT_SUBusiness Hours: Sunday Afternoons To ISMPOSCLOSESU2TIMS6UHRZT
OEFFZTIS-M: Point of Sale Opening Time OEFFZTCHAR1TJG29OEFFZT
SCHLZTIS-M: POS Closing Time SCHLZTCHAR1TJG31
OEFFMOIS-M: Opening Type Monday OEFFMOCHAR1TJG33OEFFTG
OEFFDIIS-M: Opening Type Tuesday OEFFDICHAR1TJG33OEFFTG
OEFFMIIS-M: Opening Type Wednesday OEFFMICHAR1TJG33OEFFTG
OEFFDOIS-M: Opening Type Thursday OEFFDOCHAR1TJG33OEFFTG
OEFFFRIS-M: Opening Type Friday OEFFFRCHAR1TJG33OEFFTG
OEFFSAIS-M: Opening Type Saturday OEFFSACHAR1TJG33OEFFTG
OEFFSOIS-M: Opening Type Sunday OEFFSOCHAR1TJG33OEFFTG
XLOTTOIS-M: Lottery Agent Indicator XLOTTOCHAR1XFELD
MBRSYSIS-M: Automatic Payment System MBRSYSCHAR2TJG15ALPHAMBRSYS
BAGNRIS-M: BAG Transaction Number BAGNRCHAR5TEXT5
ISPCNRIS-M: ISPC Number ISPCNRCHAR10TEXT10
XISPCTEILNIS-M: Indicator: Business Partner Is EDI Participant XISPCTEILNCHAR1XFELD
ISPCTEILNIS-M: EDI Participant Number ISPCTEILNNUMC8NUM8
ISPCARTIS-M: EDI Participant Type ISPCARTNUMC1TJGR1JISPCART
VDZNRIS-M: VDZ Number VDZNRCHAR20VDZNR
RECALLCALENDERRecall Calendar ISM_RC_CALENDERCHAR2TFACDWFCID
RC_ALLOWED_MORecall Allowed on Monday ISM_RC_ALLOWED_MOCHAR1XFELD
RC_ALLOWED_TURecall Allowed on Tuesday ISM_RC_ALLOWED_TUCHAR1XFELD
RC_ALLOWED_WDRecall Allowed on Wednesday ISM_RC_ALLOWED_WDCHAR1XFELD
RC_ALLOWED_THRecall Allowed on Thursday ISM_RC_ALLOWED_THCHAR1XFELD
RC_ALLOWED_FRRecall Allowed on Friday ISM_RC_ALLOWED_FRCHAR1XFELD
RC_ALLOWED_SARecall Allowed on Saturday ISM_RC_ALLOWED_SACHAR1XFELD
RC_ALLOWED_SURecall Allowed on Sunday ISM_RC_ALLOWED_SUCHAR1XFELD
RECALLGROUPRecall Group JKSDRECALLGROUPCHAR4TJKSDCOLCUSTGRPJKSDRECALLGROUP
VERKGBIS-M: Sales Region VERKGBCHAR50TEXT50
VGEINWIS-M: Population of Sales Area VGEINWNUMC10ANZPERS
XREMRECHTIS-M: Right of Return XREMRECHTCHAR1XFELD
REMARTReturn Type REMARTCHAR1REMART
REMWEISEReturn Method REMWEISECHAR1REMWEISE
REMSPIS-M: Billing Block for Return Notification REMSPCHAR1XFELD
KOMMENTIS-M: Comment 50 Characters in Length KOMM50CHAR50TEXT50
RETURNGPNRIS-M: Retailer EWKUNCHAR10Assigned to domainALPHAGPNR
LAST_CHANGETime Stamp of Last Change for BI Delta Exchange ISM_BI_DELTA_TIMESTAMPDEC15TZNTSTMPS

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!