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

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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Basis Components :: Documentation and Translation Tools :: Translation Tools
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TRMSTMA731Values of Settings for Screens in Transaction STMATranslation Tools
SQL:  selectupdate insert create

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

SELECT UNAME, SLANGUAGE, TLANGUAGE, EXP_DIREC, EXP_MODE, EXP_DDATE, EXP_ADJU, EXP_TEST, IMP_RELE, IMP_OVER, IMP_ENQU, IMP_TEST, IMP_APPL, IMP_EXCE, IMP_CSYST, IMP_CAPPL, IMP_CNODE, IMP_WULIM, IMP_DIREC, CP_INAPPL, CP_OUTAPPL, CP_APPL, CP_EXCE, CP_OVER, CP_ENQU, CP_TEST, OREO_REFRE, OREO_OFIL, OREO_WUL, OREO_PATT, OREO_ODB, OREO_DIREC, OCOR_LANGU, OCOR_CORR, OCOR_DISP, OCLE_DELE, OCLE_TEST, ODEL_DELE, ODEL_TEST, USER_DALL, USER_DSIN, UCUS_STAT, CTRI_LANG, CTRI_REST, CTRI_ABBR, CTRI_ENQU, CTRI_OVER, CTRI_GRA1, CTRI_GRA2, CTRI_GRA3, CTRI_GRA4, CTWI_REST, CTWI_ABBR, CTWI_ENQU, CTWI_OVER, CTWI_GRA1, CTWI_GRA2, CTWI_GRA3, CTWI_GRA4, WRK_PURPOS, WRK_STATUS, WRK_USER, WRKT_MARK, WRKS_SMODE, WRKS_SRANK, WRKS_STEXT, WRKS_TMODE, WRKS_TRANK, WRKS_TTEXT, WRKS_MARK, WRKT_PURP, CDATE, CTIME FROM TRMSTMA
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1UNAMEUser Namenvarchar120CHAR(N' ')NoUNAME Allow NULL? 
2SLANGUAGESource languagechar10LANG(N' ')No*SLANGUAGE Allow NULL? 
3TLANGUAGETarget languagechar10LANG(N' ')No*TLANGUAGE Allow NULL? 
4EXP_DIRECUnix File Input Pathnvarchar550CHAR(N' ')YesPATH01 Allow NULL? 
5EXP_MODESingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
6EXP_DDATEDatenvarchar80DATS(N'00000000')YesDATUM Allow NULL? 
7EXP_ADJUSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
8EXP_TESTSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
9IMP_RELESAP Releasenvarchar40CHAR(N' ')YesSAPRL Allow NULL? 
10IMP_OVERSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
11IMP_ENQUSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
12IMP_TESTSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
13IMP_APPLSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
14IMP_EXCESingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
15IMP_CSYSTSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
16IMP_CAPPLSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
17IMP_CNODESingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
18IMP_WULIMSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
19IMP_DIRECUnix File Input Pathnvarchar550CHAR(N' ')YesPATH01 Allow NULL? 
20CP_INAPPLApplication ID in Proposal Poolnvarchar20CHAR(N' ')YesTRMAPPLIC Allow NULL? 
21CP_OUTAPPLApplication ID in Proposal Poolnvarchar20CHAR(N' ')YesTRMAPPLIC Allow NULL? 
22CP_APPLSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
23CP_EXCESingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
24CP_OVERSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
25CP_ENQUSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
26CP_TESTSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
27OREO_REFRESingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
28OREO_OFILSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
29OREO_WULSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
30OREO_PATTSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
31OREO_ODBSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
32OREO_DIRECUnix File Input Pathnvarchar550CHAR(N' ')YesPATH01 Allow NULL? 
33OCOR_LANGUSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
34OCOR_CORRSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
35OCOR_DISPSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
36OCLE_DELESingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
37OCLE_TESTSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
38ODEL_DELESingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
39ODEL_TESTSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
40USER_DALLSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
41USER_DSINSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
42UCUS_STATSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
43CTRI_LANGSource languagechar10LANG(N' ')Yes*SLANGUAGE Allow NULL? 
44CTRI_RESTSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
45CTRI_ABBRSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
46CTRI_ENQUSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
47CTRI_OVERSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
48CTRI_GRA1Single-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
49CTRI_GRA2Single-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
50CTRI_GRA3Single-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
51CTRI_GRA4Single-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
52CTWI_RESTSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
53CTWI_ABBRSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
54CTWI_ENQUSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
55CTWI_OVERSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
56CTWI_GRA1Single-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
57CTWI_GRA2Single-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
58CTWI_GRA3Single-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
59CTWI_GRA4Single-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
60WRK_PURPOSPurpose of tracus runnvarchar100CHAR(N' ')YesTRACUSPP Allow NULL? 
61WRK_STATUSStatus of TRM processing run / TRM worklistnvarchar40CHAR(N' ')YesTRM_STATUS Allow NULL? 
62WRK_USERUser Namenvarchar120CHAR(N' ')YesSYUNAME Allow NULL? 
63WRKT_MARKSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
64WRKS_SMODESingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
65WRKS_SRANKRank in the hit listnvarchar50NUMC(N'00000')YesSRET_RANKV Allow NULL? 
66WRKS_STEXTText (80 Characters)nvarchar800CHAR(N' ')YesTEXT80 Allow NULL? 
67WRKS_TMODESingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
68WRKS_TRANKRank in the hit listnvarchar50NUMC(N'00000')YesSRET_RANKV Allow NULL? 
69WRKS_TTEXTText (80 Characters)nvarchar800CHAR(N' ')YesTEXT80 Allow NULL? 
70WRKS_MARKSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
71WRKT_PURPPurpose of tracus runnvarchar100CHAR(N' ')YesTRACUSPP Allow NULL? 
72CDATEDatenvarchar80DATS(N'00000000')YesDATUM Allow NULL? 
73CTIMETimenvarchar60TIMS(N'000000')YesUZEIT Allow NULL? 
NamePrimaryUniqueTypeColumns
TRMSTMA~0YesYesCLUSTEREDUNAME, SLANGUAGE, TLANGUAGE