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

36 columns | Print definition?ERP 6.0  | USER_GUID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SLOAP/USER_ROLESLOAS user and role data3USER_GUIDSLOAS: User GUIDvarbinary160
2/SLOAP/USR_PROFDelivery authorisation - profile assignment3USER_GUIDSLOAS: User GUIDvarbinary160
3/SMERP/STG_MM001Data staging - Material master plant view complex table4USER_GUIDUser GUIDnvarchar320
4/SMERP/STG_MM002Data staging - Material storage location view complex table4USER_GUIDUser GUIDnvarchar320
5/SMERP/STG_MM003Data staging - Material UoM view complex table4USER_GUIDUser GUIDnvarchar320
6/SMERP/STG_MM004Data staging - Material warehouse view complex table4USER_GUIDUser GUIDnvarchar320
7/SMERP/STG_MM005Data staging - Material batch view complex table4USER_GUIDUser GUIDnvarchar320
8/SMERP/STG_PM001Data staging - Equipment complex table4USER_GUIDUser GUIDnvarchar320
9/SMERP/STG_PM002Data staging - Functional Location complex table4USER_GUIDUser GUIDnvarchar320
10/SMERP/STG_PM003Data staging - Equipment List Set - Hdr - complex tab4USER_GUIDUser GUIDnvarchar320
11/SMERP/STG_PM004Data staging - Equipment list set - Measuring Points4USER_GUIDUser GUIDnvarchar320
12/SMERP/STG_PM005Data staging - Equipment LSet - DMS Doc. Obj - complex table4USER_GUIDUser GUIDnvarchar320
13/SMERP/STG_PM006Data staging - Equip List Set - Classifications - Cmplx Tab4USER_GUIDUser GUIDnvarchar320
14/SMERP/STG_PM007Data staging - Equip List Set - Char Values - complex table4USER_GUIDUser GUIDnvarchar320
15/SMERP/STG_PM008Data staging - Functional Loc. List Set - Hdr - complex tab4USER_GUIDUser GUIDnvarchar320
16/SMERP/STG_PM009Data staging - Func. Loc. List Set - Meas. Pts - cmplex tab4USER_GUIDUser GUIDnvarchar320
17/SMERP/STG_PM010Data staging - Func. Loc. LSet - DMS Doc. Obj - complex tab4USER_GUIDUser GUIDnvarchar320
18/SMERP/STG_PM011Data staging - Func Loc. LSet - Classifications - Cmplx Tab4USER_GUIDUser GUIDnvarchar320
19/SMERP/STG_PM012Data staging - Func Loc LSet - Char Values - complex table4USER_GUIDUser GUIDnvarchar320
20/SYCLO/AP001Syclo Integration Framework Runtime Settings3USER_GUIDUser GUIDnvarchar320
21/SYCLO/AP002Runtime overwrite for mobile app param, globals4USER_GUIDUser GUIDnvarchar320
22/SYCLO/MDW00Syclo Middleware User Registry2USER_GUIDUser GUIDnvarchar320
23/SYCLO/MDW00CMobile user communication info2USER_GUIDUser GUIDnvarchar320
24/SYCLO/MDW00DMobile user client deployment status - last update2USER_GUIDUser GUIDnvarchar320
25/SYCLO/MDW00RMobile user cross reference2USER_GUIDUser GUIDnvarchar320
26/SYCLO/MDW01Syclo Middleware Session Registry3USER_GUIDUser GUIDnvarchar320
27/SYCLO/MDW01RMiddleware session cross reference5USER_GUIDUser GUIDnvarchar320
28/SYCLO/MDW02Syclo Middleware Session Data Object Registry3USER_GUIDUser GUIDnvarchar320
29/SYCLO/MDW03Syclo Middleware Session Cross Reference Table3USER_GUIDUser GUIDnvarchar320
30/SYCLO/MSG01Syclo Mobile Data Unit Message Queue (Outbound)5USER_GUIDUser GUIDnvarchar320
31/SYCLO/MSG02Syclo Mobile Data Unit Message Queue (Inbound)5USER_GUIDUser GUIDnvarchar320
32/SYCLO/PSH02Syclo Push Register - Instance items6USER_GUIDUser GUIDnvarchar320
33/SYCLO/PSH03Push Instance Subscriber List3USER_GUIDUser GUIDnvarchar320
34/SYCLO/PSH05User Push history4USER_GUIDUser GUIDnvarchar320
35/SYCLO/SYSLOG001System statistics - Middleware integration8USER_GUIDUser GUIDnvarchar320
TOPCentral Part of Product Master
36COMM_PRWBIL_USERUser Settings for Interlinkages in the Product Workbench2USER_GUIDGUID: User Settingsvarbinary160