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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Without Description :: Without Description :: End User Technology
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0RSZELTPROP961Element properties (settings)End User Technology
SQL:  selectupdate insert create

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

SELECT ELTUID, OBJVERS, NOMULTTXT, SHOWFORMATS, SUMPOSIT, NOSTYLES, SIGNPRSNT, NOZERO, KEYDATEFLAG, KEYDATE, RFCSUPPORT, EQSUPPORT, ODATASUPPORT, HANASUPPORT, FLAT_LIST, ZEROPRSNT, ZEROSTRING, DOKUURL, BORURL, HIERROWS, HIERCOLS, HIERROWSLEVEL, HIERCOLSLEVEL, WEBQDENABLED, INPUTMODUS, INPUTABLEALL, ACTUALDATA, ACTUALDATAFLAG, ADDNLS, ADDNLSFLAG, CHAVL, NODE_IOBJNM, CUMUL, CUMUL_ORDER, CUMUL_ORDER_CRITERIA, PLEVEL, NOSUMS, IOBJPRSNT, STRT_LVL, HRY_ACTIVE, SPOC, HRY_NODE_POSIT, ALEAFNODSP, HIENM, HIENMFLAG, VERSION, VERSIONFLAG, DATETO, DATETOFLAG, THJT, MA_ACTIVE, MA_IOBJPRSNT, MA_POSIT, MA_S_OBJ, MA_S_TYP, MA_S_DIR, IS_EMPTY, MA_READ_MODE, HIER_DIS, INIVIEW_PRIO, NUM_SCALE, NUM_PREC, EMPHASIS, TCUR, TCURFLAG, CTTNM, SIGNINV, FORMULACOLLSN, HIDDEN, STRMEM_PLEVEL, STRMEM_CUMUL, STRMEM_LAGGR, NSUBR, PARENT, DRILLSTATE, CONSTSEL, STRMEM_NOZERO, LAGGR_DIR, INPUTABLE, LOCK, TCURDATEFLAG, TCURDATE, UOMNM, TUOMFLAG, TUOM, DRILLSTATE_EXEC, STRMEM_DIS, STRMEM_DISREF, S_TYP, S_OBJ, S_DIR, HS_TYP, HS_OBJ, HS_DIR, PROPVERS, SWITCHID FROM RSZELTPROP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1ELTUIDBW: Unequivocal ID in room and timenvarchar250CHAR(N' ')NoRSUNIIDX Allow NULL? 
2OBJVERSObject versionchar10CHAR(N' ')NoRSOBJVERS Allow NULL? 
3NOMULTTXTQuery: Suppression of Repitition Textschar10CHAR(N' ')YesRRXNOMULTTXT Allow NULL? 
4SHOWFORMATSQuery: Format displaychar10CHAR(N' ')YesRRXSHOWFORMATS Allow NULL? 
5SUMPOSITQuery: Position of the results rowchar10CHAR(N' ')YesRRXSUMPOSIT Allow NULL? 
6NOSTYLESQuery: Suppression of styles in the outputchar10CHAR(N' ')YesRRXNOSTYLES Allow NULL? 
7SIGNPRSNTQuery: +/- Sign Displaychar10CHAR(N' ')YesRRXSIGNPRSNT Allow NULL? 
8NOZEROQuery: Zero Suppression from 3.0Bchar10CHAR(N' ')YesRSZNOZERO Allow NULL? 
9KEYDATEFLAGFlag for 'typing' an entrychar10NUMC(N'0')YesRSZTYPEFLAG Allow NULL? 
10KEYDATEDim: Field for a Characteristic Value Shorter Than 60 Char.nvarchar600CHAR(N' ')YesRSCHAVL60 Allow NULL? 
11RFCSUPPORTQuery: RFC Publishing as VirtualProvider (yes/no)char10CHAR(N' ')YesRRXRFCSUPPORT Allow NULL? 
12EQSUPPORTQuery: RFC Publishing as VirtualProvider (yes/no)char10CHAR(N' ')YesRRXRFCSUPPORT Allow NULL? 
13ODATASUPPORTQuery: RFC Publishing as VirtualProvider (yes/no)char10CHAR(N' ')YesRRXRFCSUPPORT Allow NULL? 
14HANASUPPORTExternal SAP HANA view for BW objectchar10CHAR(N' ')YesRSMHANAMODEL Allow NULL? 
15FLAT_LISTBooleanchar10CHAR(N' ')YesRS_BOOL Allow NULL? 
16ZEROPRSNTQuery: Zero displaychar10NUMC(N'0')YesRSZZEROPRSNT Allow NULL? 
17ZEROSTRINGQuery: Zero String Displaynvarchar600CHAR(N' ')YesRSZZEROSTRING Allow NULL? 
18DOKUURLQuery: Display document linkschar10CHAR(N' ')YesRSZDOKUURL Allow NULL? 
19BORURLQuery: Display BOR URLchar10CHAR(N' ')YesRSZBORURL Allow NULL? 
20HIERROWSQuery: Universal display hierarchy in the rowschar10CHAR(N' ')YesRSZHIERROWS Allow NULL? 
21HIERCOLSQuery: Universal display hierarchy in the columnschar10CHAR(N' ')YesRZSHIERCOLS Allow NULL? 
22HIERROWSLEVELDim: Initial value for hierarchy level of the expansionnvarchar20NUMC(N'00')YesRRSTARTLVL Allow NULL? 
23HIERCOLSLEVELDim: Initial value for hierarchy level of the expansionnvarchar20NUMC(N'00')YesRRSTARTLVL Allow NULL? 
24WEBQDENABLEDQuery: May Be Edited with Web Query Designerchar10CHAR(N' ')YesRSZWEBQDENABLED Allow NULL? 
25INPUTMODUSMode of Input Processingchar10NUMC(N'0')YesRRINPUTMODUS Allow NULL? 
26INPUTABLEALLMake All Basic Indicators Ready for Inputchar10CHAR(N' ')YesRRINPUTBASIC Allow NULL? 
27ACTUALDATADim: Field for a Characteristic Value Shorter Than 60 Char.nvarchar600CHAR(N' ')YesRSCHAVL60 Allow NULL? 
28ACTUALDATAFLAGFlag for 'typing' an entrychar10NUMC(N'0')YesRSZTYPEFLAG Allow NULL? 
29ADDNLSDim: Field for a Characteristic Value Shorter Than 60 Char.nvarchar600CHAR(N' ')YesRSCHAVL60 Allow NULL? 
30ADDNLSFLAGFlag for 'typing' an entrychar10NUMC(N'0')YesRSZTYPEFLAG Allow NULL? 
31CHAVLDim: Field for a User-Defined Characteristic Valuenvarchar13330(N'')YesRSCHAVL Allow NULL? 
32NODE_IOBJNMInfoObjectnvarchar300CHAR(N' ')YesRSIOBJNM Allow NULL? 
33CUMULDim: Cumulatechar10CHAR(N' ')YesRRCUMUL Allow NULL? 
34CUMUL_ORDEROrder of CUMUL as Characteristicchar10CHAR(N' ')YesRRCUMUL_ORDER Allow NULL? 
35CUMUL_ORDER_CRITERIAOrder criteria of CUMUL as Characteristicchar10CHAR(N' ')YesRRCUMUL_ORDER_CRITERIA Allow NULL? 
36PLEVELDim: Standardizing typechar10CHAR(N' ')YesRRPLEVEL Allow NULL? 
37NOSUMSDim: Suppression of totals rowschar10CHAR(N' ')YesRRXNOSUMS Allow NULL? 
38IOBJPRSNTDisplay for Characteristics and Unitschar10CHAR(N' ')YesRSCHAPRSNT Allow NULL? 
39STRT_LVLDim: Initial value for hierarchy level of the expansionnvarchar20NUMC(N'00')YesRRSTARTLVL Allow NULL? 
40HRY_ACTIVEFlag: Entered hierarchy is active display hierarchychar10CHAR(N' ')YesRRXHRYACTIVE Allow NULL? 
41SPOCConditional Node Suppressionchar10CHAR(N' ')YesRRXSPOC Allow NULL? 
42HRY_NODE_POSITPositions of the nodes in reference to their leaveschar10CHAR(N' ')YesRRXHRYNODEPOSIT Allow NULL? 
43ALEAFNODSPDo Not Display Leaves for Inner-Nodes in the Querychar10CHAR(N' ')YesRSSHCRLEAFDSP Allow NULL? 
44HIENMHierarchy namenvarchar300CHAR(N' ')YesRSHIENM Allow NULL? 
45HIENMFLAGFlag for 'typing' an entrychar10NUMC(N'0')YesRSZTYPEFLAG Allow NULL? 
46VERSIONBW: Unequivocal ID in room and time (numbers and letters)nvarchar250CHAR(N' ')YesRSUNIIDC25 Allow NULL? 
47VERSIONFLAGFlag for 'typing' an entrychar10NUMC(N'0')YesRSZTYPEFLAG Allow NULL? 
48DATETOBW: Unequivocal ID in room and time (numbers and letters)nvarchar250CHAR(N' ')YesRSUNIIDC25 Allow NULL? 
49DATETOFLAGFlag for 'typing' an entrychar10NUMC(N'0')YesRSZTYPEFLAG Allow NULL? 
50THJTKey Date Derivation Typenvarchar100CHAR(N' ')YesRSRHIERTHJT Allow NULL? 
51MA_ACTIVEBooleanchar10CHAR(N' ')YesRS_BOOL Allow NULL? 
52MA_IOBJPRSNTDisplay for Characteristics and Unitschar10CHAR(N' ')YesRSCHAPRSNT Allow NULL? 
53MA_POSITLogical sequence (position)int100INT4((0))YesRSZPOSN Allow NULL? 
54MA_S_OBJCharacteristicnvarchar300CHAR(N' ')YesRSCHANM Allow NULL? 
55MA_S_TYPSort: (K)ey, (T)ext, (V)alue (H)ierarchychar10CHAR(N' ')YesRROSART Allow NULL? 
56MA_S_DIRSort directionchar10CHAR(N' ')YesRROSDIR Allow NULL? 
57IS_EMPTYDisplay Values Not Postedchar10CHAR(N' ')YesRREMPTY Allow NULL? 
58MA_READ_MODERead Mode(F4) for Master Data Read Serviceschar10CHAR(N' ')YesRSMD_RS_READ_MODE Allow NULL? 
59HIER_DISDisaggregation for Budgetingchar10CHAR(N' ')YesRSZHIERDIS Allow NULL? 
60INIVIEW_PRIORefresh Filter State with Query Settingschar10CHAR(N' ')YesRSZINIVIEWPRIO Allow NULL? 
61NUM_SCALEStrMember: Scaling factor of a numberchar10CHAR(N' ')YesRRSCALE Allow NULL? 
62NUM_PRECStrMember: Number of places after decimal point for outputchar10CHAR(N' ')YesRRPRECISION Allow NULL? 
63EMPHASISEmphasize Elementchar10CHAR(N' ')YesRSZEMPHASIS Allow NULL? 
64TCURBW: Unequivocal ID in room and time (numbers and letters)nvarchar250CHAR(N' ')YesRSUNIIDC25 Allow NULL? 
65TCURFLAGFlag for 'typing' an entrychar10NUMC(N'0')YesRSZTYPEFLAG Allow NULL? 
66CTTNMStrMember: Name of Currency Conversion Typenvarchar100CHAR(N' ')Yes*RRNUMBR Allow NULL? 
67SIGNINVStrMember: +/- sign changechar10CHAR(N' ')YesRSZSIGN Allow NULL? 
68FORMULACOLLSNStrMember: Establishing Prf. Analysis with formula collisionchar10CHAR(N' ')YesRSZCALCULATION Allow NULL? 
69HIDDENDo Not Display Elementchar10CHAR(N' ')YesRSZHIDDEN Allow NULL? 
70STRMEM_PLEVELDim: Standardizing typechar10CHAR(N' ')YesRRPLEVEL Allow NULL? 
71STRMEM_CUMULDim: Cumulatechar10CHAR(N' ')YesRRCUMUL Allow NULL? 
72STRMEM_LAGGRLocal Aggregationnvarchar20NUMC(N'00')YesRRLAGGR Allow NULL? 
73NSUBRBooleanchar10CHAR(N' ')YesRS_BOOL Allow NULL? 
74PARENTUUID in compressed formnvarchar250CHAR(N' ')YesSYSUUID_25 Allow NULL? 
75DRILLSTATEStatus of a hierarchy node with respect to tree structurechar10CHAR(N' ')YesRRXDRILLSTATE Allow NULL? 
76CONSTSELSelection independent of the drilldownchar10CHAR(N' ')YesRSZCONSTSEL Allow NULL? 
77STRMEM_NOZEROQuery: Suppress zeroschar10CHAR(N' ')YesRRNOZERO Allow NULL? 
78LAGGR_DIRAxis Descriptionchar10NUMC(N'0')YesRSZAXIS Allow NULL? 
79INPUTABLEElement is input-readychar10CHAR(N' ')YesRSZINPUTABLE Allow NULL? 
80LOCKElement is lock-relevantchar10CHAR(N' ')YesRSZLOCK Allow NULL? 
81TCURDATEFLAGFlag for 'typing' an entrychar10NUMC(N'0')YesRSZTYPEFLAG Allow NULL? 
82TCURDATEBW: Unequivocal ID in room and time (numbers and letters)nvarchar250CHAR(N' ')YesRSUNIIDC25 Allow NULL? 
83UOMNMName of Quantity Conversion Typenvarchar100CHAR(N' ')YesRSUOMNM Allow NULL? 
84TUOMFLAGFlag for 'typing' an entrychar10NUMC(N'0')YesRSZTYPEFLAG Allow NULL? 
85TUOMBW: Unequivocal ID in room and time (numbers and letters)nvarchar250CHAR(N' ')YesRSUNIIDC25 Allow NULL? 
86DRILLSTATE_EXECState of Hierarchy Node in Tree Structure (At Runtime)char10CHAR(N' ')YesRRXDRILLST_EXEC Allow NULL? 
87STRMEM_DISDisaggregation on Totalschar10CHAR(N' ')YesRSZDIS Allow NULL? 
88STRMEM_DISREFUUID Reference for Disaggregation on Totalsnvarchar250CHAR(N' ')YesRSZDISREF Allow NULL? 
89S_TYPSort: (K)ey, (T)ext, (V)alue (H)ierarchychar10CHAR(N' ')YesRROSART Allow NULL? 
90S_OBJCharacteristicnvarchar300CHAR(N' ')YesRSCHANM Allow NULL? 
91S_DIRSort directionchar10CHAR(N' ')YesRROSDIR Allow NULL? 
92HS_TYPSort: (K)ey, (T)ext, (V)alue (H)ierarchychar10CHAR(N' ')YesRROSART Allow NULL? 
93HS_OBJCharacteristicnvarchar300CHAR(N' ')YesRSCHANM Allow NULL? 
94HS_DIRSort directionchar10CHAR(N' ')YesRROSDIR Allow NULL? 
95PROPVERSVersion Information for Default Value of Propertieschar10CHAR(N' ')YesRSPROPVERS Allow NULL? 
96SWITCHIDID of Switch in Switch Frameworknvarchar300CHAR(N' ')Yes*SFW_SWITCHID Allow NULL? 
NamePrimaryUniqueTypeColumns
RSZELTPROP~0YesYesCLUSTEREDOBJVERS, ELTUID