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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

52 columns | Print definition?ERP 6.0  | SORT_ORDER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWBEP/I_SBO_PESB: OData Path Expression9SORT_ORDERNatural Numberint100
2/IWBEP/I_SBO_PRSB: OData Properties67SORT_ORDERService Builder: Node Positionint100
3/IWBEP/I_SBO_RHSB: OData Record Expression6SORT_ORDERNatural Numberint100
4/IWBEP/I_SBO_RMSB: OData Record Expression Mapping10SORT_ORDERNatural Numberint100
5/IWBEP/I_SBO_SESB: OData Simple Value9SORT_ORDERNatural Numberint100
6BBPC_CTR_MASS_OPMass change functions4SORT_ORDERSort Order for List of Contractsnvarchar10
7DOUI_ELEM_SORTDBOSC-CDL-UI: ALV Sort Field5SORT_ORDERint100
8ECCUST_TIPSeCATT - Tips and Tricks - Content6SORT_ORDEReCATT - Sort Index in Listsnvarchar40
9EHPRCC_REQVIEWRequirement Tab Assignments4SORT_ORDERSerial Numberint100
TOPABAP Authorization and Role Management
10AGR_HIERTable for Structure Information for Menu6SORT_ORDERCounter for Menu IDnvarchar80
11AGR_HIER2Menu structure information - Customer version of SAP roles6SORT_ORDERCounter for Menu IDnvarchar80
12AGR_HIER3Menu structure information - SAP version of SAP roles6SORT_ORDERCounter for Menu IDnvarchar80
13AGR_MINIMiniApps in Role3SORT_ORDERLevel in the menunvarchar20
14AGR_MINI2MiniApps in Role3SORT_ORDERLevel in the menunvarchar20
15AGR_MINITRole mini-appl texts4SORT_ORDERLevel in the menunvarchar20
16AGR_MINIT2Role mini-application texts4SORT_ORDERLevel in the menunvarchar20
17ROLE_INAKInactive roles buffer7SORT_ORDERCounter for Menu IDnvarchar80
TOPAppointment Calendar
18TSCTFGROUPAssignment of Application to Time Period Rule5SORT_ORDERSort Sequencenvarchar20
TOPCountry-Specific Objects
19DMEE_SORT_ABADMEE: Sort and Key Fields for Format4SORT_ORDERDMEE: sort sequencenvarchar30
TOPCross-Application Components
20AFQNAMESQueue Names6SORT_ORDERSort Sequence of Entriesnvarchar100
21CRMQNAMESQueue Name Management for CRM-QRFC Supply4SORT_ORDERSort Sequence of Entriesnvarchar100
TOPEnd User Technology
22RSZW_MINI_URLConversion: URLs for MiniApps2SORT_ORDERLevel in the menunvarchar20
TOPHierarchy Storage
23TTREV_ROLEVersion Management: Comparison Results7SORT_ORDERCounter for Menu IDnvarchar80
TOPHospital Structure
24HRPAD860PAD860 Additional Data4SORT_ORDERIS-H: Sort Field for Organizational Unitsnvarchar30
25HRPAD882PAD860 Additional Data3SORT_ORDERIS-H: Sort Field for Organizational Unitsnvarchar30
TOPIncident Recording
26EHHSSC_PER_ROLPerson Role Code4SORT_ORDERRole Order Indexsmallint50
TOPIntegration of FPM and Persistency Frameworks like BOPF
27/BOFU/IPBI_POWLFPOWL: Field Definition12SORT_ORDERSort Order for Columnnvarchar20
TOPLocalization
28DMEE_TREE_SORTDMEE: Sort and Key Fields for Format4SORT_ORDERDMEE: sort sequencenvarchar30
TOPOffice Suite Program
29/OSP/T_ALTRGFLDAlert - Regions - Fields8SORT_ORDERField Sort ordernvarchar30
30/OSP/T_RAUI_CSETOSP Chart Reports Settings Table8SORT_ORDERSort Ordernvarchar50
31/OSP/T_RAUI_RDCOSP Reports Data Change Events Table8SORT_ORDERSort Ordernvarchar50
32/OSP/T_RAUI_RMTOSP Report Mendocino Timepoints Table7SORT_ORDERSort Ordernvarchar50
33/OSP/T_RAUI_RTPOSP Reports System Timepoints Table8SORT_ORDERSort Ordernvarchar50
34/OSP/T_RAUI_SCHOSP Report Scheduling Table20SORT_ORDERSort Ordernvarchar50
TOPProcess Controls
35GRPCNWBCFDRFolders3SORT_ORDERSort Ordernvarchar20
36GRPCNWBCLINKLinks5SORT_ORDERSort Ordernvarchar20
37GRPCNWBCWCWork Centres3SORT_ORDERSort Ordernvarchar20
TOPProject Management
38DPR_SEARCH_HELPcProject Search Help Customizing7SORT_ORDERSort Numbernvarchar50
TOPQuantity optimizing
39WLC_PRESEL_CRITLoad Control/Ext. Paral. Proc.: Preselection Criteria4SORT_ORDERLoad Control/Ext. Paral. Proc.: Sort Sequencetinyint30
TOPSession Manager
40ADMI_BUFFCBuffer table10SORT_ORDERCounter for menu IDnvarchar50
41SMENAKTNEWNodes of the active company menu Session Manager11SORT_ORDERCounter for menu IDnvarchar50
42SMENCUSNEWFile Structure for Hierarchical Menu - Customer11SORT_ORDERCounter for menu IDnvarchar50
43SMENENTNEWFile Structure for Hierarchical Menu - Customer11SORT_ORDERCounter for menu IDnvarchar50
44SMENINTNEWInternet menu nodes of the Internet Session Manager11SORT_ORDERCounter for menu IDnvarchar50
45SMENMANUALFile Structure for Hierarchical Menu - Customer9SORT_ORDERCounter for menu IDnvarchar50
46SMENSAPNEWFile Structure for Hierarchical Menu - SAP11SORT_ORDERCounter for menu IDnvarchar50
47SMENUSEFLAFile for the User Menu11SORT_ORDERCounter for menu IDnvarchar50
48SMENUSELNGFile for the User Menu10SORT_ORDERCounter for menu IDnvarchar100
49SMENUSENEWFile for the User Menu11SORT_ORDERCounter for menu IDnvarchar50
50SMEN_BUFFCTable for Storing Favorites10SORT_ORDERCounter for menu IDnvarchar50
TOPSpecification 2
51ADSPC_CUSTRNMGRTransactions for Customizing for SPEC 20008SORT_ORDERNumber of the object idnvarchar50
TOPWorkplace Server
52W3DEVFAVMWP: Favorites for Mobile Terminals7SORT_ORDERCounter for menu IDnvarchar50