SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | JGTEUWV
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: SAP Media :: Master Data
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0JGTEUWV1021IS-M: RetailerMaster Data
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, EWKUN, ERFUSER, ERFDATE, ERFTIME, AENUSER, AENDATE, AENTIME, XEUWLOE, ANZMIT, EVKSTART, EVKSTBEZ, SEASON, CHAINCODE, CHAINCHANNEL, CHAINID, SHOPINSHOP, SHOPINSHOP_AREA, SHOP_CATEGORY, EVKFLAECHE, ISMGEOKATEGORIE, NO_OF_POS, NO_OF_SUPPLIERS, PRESS_SALESCAT, PRESS_SALESVOL, IUMSEINFL, IUMSEINFL2, IUMSEINFL3, EUMSEINFL, EUMSEINFL2, EUMSEINFL3, EFREQUENZ, EFREQUENCE_ORIG, CASH_SCANNER, SALES_COUNTER, EBEDIENART, ISMNUMBERPOSTERS, ISMPLANCALENDER, BUSINESSHOURS_ID, OPEN_MOR_MO, CLOSE_MOR_MO, OPEN_AFT_MO, CLOSE_AFT_MO, OPEN_MOR_TU, CLOSE_MOR_TU, OPEN_AFT_TU, CLOSE_AFT_TU, OPEN_MOR_WE, CLOSE_MOR_WE, OPEN_AFT_WE, CLOSE_AFT_WE, OPEN_MOR_TH, CLOSE_MOR_TH, OPEN_AFT_TH, CLOSE_AFT_TH, OPEN_MOR_FR, CLOSE_MOR_FR, OPEN_AFT_FR, CLOSE_AFT_FR, OPEN_MOR_SA, CLOSE_MOR_SA, OPEN_AFT_SA, CLOSE_AFT_SA, OPEN_MOR_SU, CLOSE_MOR_SU, OPEN_AFT_SU, CLOSE_AFT_SU, OEFFZT, SCHLZT, OEFFMO, OEFFDI, OEFFMI, OEFFDO, OEFFFR, OEFFSA, OEFFSO, XLOTTO, MBRSYS, BAGNR, ISPCNR, XISPCTEILN, ISPCTEILN, ISPCART, VDZNR, RECALLCALENDER, RC_ALLOWED_MO, RC_ALLOWED_TU, RC_ALLOWED_WD, RC_ALLOWED_TH, RC_ALLOWED_FR, RC_ALLOWED_SA, RC_ALLOWED_SU, RECALLGROUP, VERKGB, VGEINW, XREMRECHT, REMART, REMWEISE, REMSP, KOMMENT, RETURNGPNR, LAST_CHANGE FROM JGTEUWV
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2EWKUNIS-M: Retailernvarchar100CHAR(N' ')NoJGTGPNREWKUN Allow NULL? 
3ERFUSERCreated Bynvarchar120CHAR(N' ')YesERFUSER Allow NULL? 
4ERFDATECreated Onnvarchar80DATS(N'00000000')YesERFDATE Allow NULL? 
5ERFTIMETime Creatednvarchar60TIMS(N'000000')YesERFTIME Allow NULL? 
6AENUSERLast Changed Bynvarchar120CHAR(N' ')YesAENUSER Allow NULL? 
7AENDATEDate of Last Changenvarchar80DATS(N'00000000')YesAENDATE Allow NULL? 
8AENTIMETime of Last Changenvarchar60TIMS(N'000000')YesAENTIME Allow NULL? 
9XEUWLOEIS-M: Deletion Indicator (Role-Specific)char10CHAR(N' ')YesXLOESCHKZ Allow NULL? 
10ANZMITIS-M: Number of Retail Employeesnvarchar50NUMC(N'00000')YesANZMIT Allow NULL? 
11EVKSTARTIS-M: Point of Sale Categorynvarchar20CHAR(N' ')YesTJG17EVKSTART Allow NULL? 
12EVKSTBEZPOS Typenvarchar40CHAR(N' ')YesTJG19EVKSTBEZ Allow NULL? 
13SEASONSeason Indicatornvarchar20CHAR(N' ')YesTJGPOS01ISMPOSSEASON Allow NULL? 
14CHAINCODERetail Chain to Which POS Belongsnvarchar100CHAR(N' ')YesTJGPOS06ISMPOSCHAINCODE Allow NULL? 
15CHAINCHANNELDistribution Channel of Retail Chain to Which POS Belongsnvarchar100CHAR(N' ')YesTJGPOS07ISMPOSCHAINCHANNEL Allow NULL? 
16CHAINIDID of POS in Retail Chainnvarchar100CHAR(N' ')YesISMPOSCHAINID Allow NULL? 
17SHOPINSHOPIS-M: Shop in Shop Indicatorchar10CHAR(N' ')YesISMSHOPINSHOP Allow NULL? 
18SHOPINSHOP_AREAPOS Shelf Space - Shop-in-Shopnvarchar20CHAR(N' ')YesTJG21ISMPOSSHOPINSHOP_SPACE Allow NULL? 
19SHOP_CATEGORYCategory of Main Business (Shop-in-Shop)nvarchar40CHAR(N' ')YesTJG19ISMPOSSHOPBEZ Allow NULL? 
20EVKFLAECHEIS-M: POS Area Keynvarchar20CHAR(N' ')YesTJG21EVKFLAECHE Allow NULL? 
21ISMGEOKATEGORIEGeography Category (Geographical Location) for Point of Salenvarchar20CHAR(N' ')YesTJGGEOCATISMGEOKATEGORIE Allow NULL? 
22NO_OF_POSNumber of POS with Same Addresssmallint50INT2((0))YesISMPOSCOUNTER
23NO_OF_SUPPLIERSNumber of Press Vendors for a Point of Salesmallint50INT2((0))YesISMPOSSUPPLIER
24PRESS_SALESCATType of Press Productsnvarchar50CHAR(N' ')YesTJGPOS05ISMPOSPRESSSALESCATEGORY Allow NULL? 
25PRESS_SALESVOLWeekly Press Salesnvarchar50CHAR(N' ')YesTJGPOS09ISMPOSPRESSSALESVOLUME Allow NULL? 
26IUMSEINFLInternal (Primary) Influencing Factor for POS Salesnvarchar20CHAR(N' ')YesTJGPOS02IUMSEINFL Allow NULL? 
27IUMSEINFL2Internal (Secondary) Influencing Factor for POS Salesnvarchar20CHAR(N' ')YesTJGPOS02IUMSEINFL2 Allow NULL? 
28IUMSEINFL3Internal (Tertiary) Influencing Factor for POS Salesnvarchar20CHAR(N' ')YesTJGPOS02IUMSEINFL3 Allow NULL? 
29EUMSEINFLExternal Sales Influence at POS (Primary)nvarchar20CHAR(N' ')YesTJG25EUMSEINFL Allow NULL? 
30EUMSEINFL2External (Secondary) Influencing Factor for POS Salesnvarchar20CHAR(N' ')YesTJG25EUMSEINFL2 Allow NULL? 
31EUMSEINFL3External (Tertiary) Influencing Factor for POS Salesnvarchar20CHAR(N' ')YesTJG25EUMSEINFL3 Allow NULL? 
32EFREQUENZIS-M: POS Customer Frequency per Weekchar10CHAR(N' ')YesTJG27EFREQUENZ Allow NULL? 
33EFREQUENCE_ORIGPOS: Origin of Customer Frequencynvarchar20CHAR(N' ')YesTJGPOS04ISMPOSEFREQUENZORIGIN Allow NULL? 
34CASH_SCANNERScanner Cash Desk at Point of Salechar10CHAR(N' ')YesTJGPOS03ISMCASHSCAN Allow NULL? 
35SALES_COUNTERSales Counter at Point of Salechar10CHAR(N' ')YesISMPOSSALESCOUNTER Allow NULL? 
36EBEDIENARTService Type at Point of Salechar10CHAR(N' ')YesTJG23EBEDIENART Allow NULL? 
37ISMNUMBERPOSTERSNumber of Advertising Spaces at Point of Salesmallint50INT2((0))YesISMNUMBERPOSTERS
38ISMPLANCALENDERPlanning Calendar for Point of Salenvarchar20CHAR(N' ')YesTFACDISMPLANCALENDER Allow NULL? 
39BUSINESSHOURS_IDBusiness Hours ID (Default Number)nvarchar30CHAR(N' ')YesTJGPOS08ISMPOSBUSINESSHOURSID Allow NULL? 
40OPEN_MOR_MOBusiness Hours: Monday Mornings Fromnvarchar60TIMS(N'000000')YesISMPOSOPENMO1 Allow NULL? 
41CLOSE_MOR_MOBusiness Hours: Monday Mornings Tonvarchar60TIMS(N'000000')YesISMPOSCLOSEMO1 Allow NULL? 
42OPEN_AFT_MOBusiness Hours: Monday Afternoons Fromnvarchar60TIMS(N'000000')YesISMPOSOPENMO2 Allow NULL? 
43CLOSE_AFT_MOBusiness Hours: Monday Afternoons Tonvarchar60TIMS(N'000000')YesISMPOSCLOSEMO2 Allow NULL? 
44OPEN_MOR_TUBusiness Hours: Tuesday Mornings Fromnvarchar60TIMS(N'000000')YesISMPOSOPENTU1 Allow NULL? 
45CLOSE_MOR_TUBusiness Hours: Tuesday Mornings Tonvarchar60TIMS(N'000000')YesISMPOSCLOSETU1 Allow NULL? 
46OPEN_AFT_TUBusiness Hours: Tuesday Afternoons Fromnvarchar60TIMS(N'000000')YesISMPOSOPENTU2 Allow NULL? 
47CLOSE_AFT_TUBusiness Hours: Tuesday Afternoons Tonvarchar60TIMS(N'000000')YesISMPOSCLOSETU2 Allow NULL? 
48OPEN_MOR_WEBusiness Hours: Wednesday Mornings Fromnvarchar60TIMS(N'000000')YesISMPOSOPENWE1 Allow NULL? 
49CLOSE_MOR_WEBusiness Hours: Wednesday Mornings Tonvarchar60TIMS(N'000000')YesISMPOSCLOSEWE1 Allow NULL? 
50OPEN_AFT_WEBusiness Hours: Wednesday Afternoons Fromnvarchar60TIMS(N'000000')YesISMPOSOPENWE2 Allow NULL? 
51CLOSE_AFT_WEBusiness Hours: Wednesday Afternoons Tonvarchar60TIMS(N'000000')YesISMPOSCLOSEWE2 Allow NULL? 
52OPEN_MOR_THBusiness Hours: Thursday Mornings Fromnvarchar60TIMS(N'000000')YesISMPOSOPENTH1 Allow NULL? 
53CLOSE_MOR_THBusiness Hours: Thursday Mornings Tonvarchar60TIMS(N'000000')YesISMPOSCLOSETH1 Allow NULL? 
54OPEN_AFT_THBusiness Hours: Thursday Afternoons Fromnvarchar60TIMS(N'000000')YesISMPOSOPENTH2 Allow NULL? 
55CLOSE_AFT_THBusiness Hours: Thursday Afternoons Tonvarchar60TIMS(N'000000')YesISMPOSCLOSETH2 Allow NULL? 
56OPEN_MOR_FRBusiness Hours: Friday Mornings Fromnvarchar60TIMS(N'000000')YesISMPOSOPENFR1 Allow NULL? 
57CLOSE_MOR_FRBusiness Hours: Friday Mornings Tonvarchar60TIMS(N'000000')YesISMPOSCLOSEFR1 Allow NULL? 
58OPEN_AFT_FRBusiness Hours: Friday Afternoons Fromnvarchar60TIMS(N'000000')YesISMPOSOPENFR2 Allow NULL? 
59CLOSE_AFT_FRBusiness Hours: Friday Afternoons Tonvarchar60TIMS(N'000000')YesISMPOSCLOSEFR2 Allow NULL? 
60OPEN_MOR_SABusiness Hours: Saturday Mornings Fromnvarchar60TIMS(N'000000')YesISMPOSOPENSA1 Allow NULL? 
61CLOSE_MOR_SABusiness Hours: Saturday Mornings Tonvarchar60TIMS(N'000000')YesISMPOSCLOSESA1 Allow NULL? 
62OPEN_AFT_SABusiness Hours: Saturday Afternoons Fromnvarchar60TIMS(N'000000')YesISMPOSOPENSA2 Allow NULL? 
63CLOSE_AFT_SABusiness Hours: Saturday Afternoons Tonvarchar60TIMS(N'000000')YesISMPOSCLOSESA2 Allow NULL? 
64OPEN_MOR_SUBusiness Hours: Sunday Mornings Fromnvarchar60TIMS(N'000000')YesISMPOSOPENSU1 Allow NULL? 
65CLOSE_MOR_SUBusiness Hours: Sunday Mornings Tonvarchar60TIMS(N'000000')YesISMPOSCLOSESU1 Allow NULL? 
66OPEN_AFT_SUBusiness Hours: Sunday Afternoons Fromnvarchar60TIMS(N'000000')YesISMPOSOPENSU2 Allow NULL? 
67CLOSE_AFT_SUBusiness Hours: Sunday Afternoons Tonvarchar60TIMS(N'000000')YesISMPOSCLOSESU2 Allow NULL? 
68OEFFZTIS-M: Point of Sale Opening Timechar10CHAR(N' ')YesTJG29OEFFZT Allow NULL? 
69SCHLZTIS-M: POS Closing Timechar10CHAR(N' ')YesTJG31SCHLZT Allow NULL? 
70OEFFMOIS-M: Opening Type Mondaychar10CHAR(N' ')YesTJG33OEFFMO Allow NULL? 
71OEFFDIIS-M: Opening Type Tuesdaychar10CHAR(N' ')YesTJG33OEFFDI Allow NULL? 
72OEFFMIIS-M: Opening Type Wednesdaychar10CHAR(N' ')YesTJG33OEFFMI Allow NULL? 
73OEFFDOIS-M: Opening Type Thursdaychar10CHAR(N' ')YesTJG33OEFFDO Allow NULL? 
74OEFFFRIS-M: Opening Type Fridaychar10CHAR(N' ')YesTJG33OEFFFR Allow NULL? 
75OEFFSAIS-M: Opening Type Saturdaychar10CHAR(N' ')YesTJG33OEFFSA Allow NULL? 
76OEFFSOIS-M: Opening Type Sundaychar10CHAR(N' ')YesTJG33OEFFSO Allow NULL? 
77XLOTTOIS-M: Lottery Agent Indicatorchar10CHAR(N' ')YesXLOTTO Allow NULL? 
78MBRSYSIS-M: Automatic Payment Systemnvarchar20CHAR(N' ')YesTJG15MBRSYS Allow NULL? 
79BAGNRIS-M: BAG Transaction Numbernvarchar50CHAR(N' ')YesBAGNR Allow NULL? 
80ISPCNRIS-M: ISPC Numbernvarchar100CHAR(N' ')YesISPCNR Allow NULL? 
81XISPCTEILNIS-M: Indicator: Business Partner Is EDI Participantchar10CHAR(N' ')YesXISPCTEILN Allow NULL? 
82ISPCTEILNIS-M: EDI Participant Numbernvarchar80NUMC(N'00000000')YesISPCTEILN Allow NULL? 
83ISPCARTIS-M: EDI Participant Typechar10NUMC(N'0')YesTJGR1ISPCART Allow NULL? 
84VDZNRIS-M: VDZ Numbernvarchar200CHAR(N' ')YesVDZNR Allow NULL? 
85RECALLCALENDERRecall Calendarnvarchar20CHAR(N' ')YesTFACDISM_RC_CALENDER Allow NULL? 
86RC_ALLOWED_MORecall Allowed on Mondaychar10CHAR(N' ')YesISM_RC_ALLOWED_MO Allow NULL? 
87RC_ALLOWED_TURecall Allowed on Tuesdaychar10CHAR(N' ')YesISM_RC_ALLOWED_TU Allow NULL? 
88RC_ALLOWED_WDRecall Allowed on Wednesdaychar10CHAR(N' ')YesISM_RC_ALLOWED_WD Allow NULL? 
89RC_ALLOWED_THRecall Allowed on Thursdaychar10CHAR(N' ')YesISM_RC_ALLOWED_TH Allow NULL? 
90RC_ALLOWED_FRRecall Allowed on Fridaychar10CHAR(N' ')YesISM_RC_ALLOWED_FR Allow NULL? 
91RC_ALLOWED_SARecall Allowed on Saturdaychar10CHAR(N' ')YesISM_RC_ALLOWED_SA Allow NULL? 
92RC_ALLOWED_SURecall Allowed on Sundaychar10CHAR(N' ')YesISM_RC_ALLOWED_SU Allow NULL? 
93RECALLGROUPRecall Groupnvarchar40CHAR(N' ')YesTJKSDCOLCUSTGRPJKSDRECALLGROUP Allow NULL? 
94VERKGBIS-M: Sales Regionnvarchar500CHAR(N' ')YesVERKGB Allow NULL? 
95VGEINWIS-M: Population of Sales Areanvarchar100NUMC(N'0000000000')YesVGEINW Allow NULL? 
96XREMRECHTIS-M: Right of Returnchar10CHAR(N' ')YesXREMRECHT Allow NULL? 
97REMARTReturn Typechar10CHAR(N' ')YesREMART Allow NULL? 
98REMWEISEReturn Methodchar10CHAR(N' ')YesREMWEISE Allow NULL? 
99REMSPIS-M: Billing Block for Return Notificationchar10CHAR(N' ')YesREMSP Allow NULL? 
100KOMMENTIS-M: Comment 50 Characters in Lengthnvarchar500CHAR(N' ')YesKOMM50 Allow NULL? 
101RETURNGPNRIS-M: Retailernvarchar100CHAR(N' ')No*EWKUN Allow NULL? 
102LAST_CHANGETime Stamp of Last Change for BI Delta Exchangedecimal150DEC((0))YesISM_BI_DELTA_TIMESTAMP
NamePrimaryUniqueTypeColumns
JGTEUWV~0YesYesCLUSTEREDEWKUN, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy