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
9OVTG52Tax Definition
10OPOR386Purchase Order

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

84 columns | Print definition?ERP 6.0  | CREATED_TS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMFND/DSF10Data Staging Framework - Data Store10CREATED_TSCreation timestampdecimal150
2/SMFND/DSF11Data Staging Framework - Data Store Sgements8CREATED_TSCreation timestampdecimal150
3/SMFND/DSF20Data Staging Framework - Data Agent10CREATED_TSCreation timestampdecimal150
4/SMFND/DSF30Data Staging Framework - Scheduling14CREATED_TSCreation timestampdecimal150
5/SMFND/DSF40Data Staging Framework - Mapping - Tables - DS Population9CREATED_TSCreation timestampdecimal150
6/SMFND/DSF41Data Staging Framework - Mapping - Fields - DS Population8CREATED_TSCreation timestampdecimal150
7/SMFND/GS001Geospatial service definition22CREATED_TSCreation timestampdecimal150
8/SMFND/GS001AGeospatial service - Service Provider Attributes Meta Info22CREATED_TSCreation timestampdecimal150
9/SMFND/GS001VGeospatial service - Service Provider Attribute Values8CREATED_TSCreation timestampdecimal150
10/SMFND/GS002Geospatial service - object assignment12CREATED_TSCreation timestampdecimal150
11/SMFND/OID01_GSGeneral purpose SAP Object <-> GIS OBJECTID mapping table10CREATED_TSCreation timestampdecimal150
12/SYCLO/AP001Syclo Integration Framework Runtime Settings11CREATED_TSCreation timestampdecimal150
13/SYCLO/AP002Runtime overwrite for mobile app param, globals14CREATED_TSCreation timestampdecimal150
14/SYCLO/AUFNR_M1Syclo - Work Order Mobile Data Header8CREATED_TSCreation timestampdecimal150
15/SYCLO/CA000Syclo Mobile Application Release Info12CREATED_TSCreation timestampdecimal150
16/SYCLO/CA000AMobile application - Satellite Systems9CREATED_TSCreation timestampdecimal150
17/SYCLO/CA000PMobile application - parameters17CREATED_TSCreation timestampdecimal150
18/SYCLO/CA000SMobile application - mobile status settings13CREATED_TSCreation timestampdecimal150
19/SYCLO/CA000XCross application system setting - CONVEXIT Exclusion List10CREATED_TSCreation timestampdecimal150
20/SYCLO/CA001Cross application system settings11CREATED_TSCreation timestampdecimal150
21/SYCLO/CA002Generic exchange handler table settings22CREATED_TSCreation timestampdecimal150
22/SYCLO/CA002DxChange Object Data Segment Settings10CREATED_TSCreation timestampdecimal150
23/SYCLO/CA002FExchange Object Change Pointer Field Catalog9CREATED_TSCreation timestampdecimal150
24/SYCLO/CA002LExchange Object Associations12CREATED_TSCreation timestampdecimal150
25/SYCLO/CA003Data filter rule table11CREATED_TSCreation timestampdecimal150
26/SYCLO/CA003DMDO DOF Table Rule - Meta Data20CREATED_TSCreation timestampdecimal150
27/SYCLO/CA003MMDO DOF Table Rule - Value9CREATED_TSCreation timestampdecimal150
28/SYCLO/DF001Data Filter Object Definition6CREATED_TSCreation timestampdecimal150
29/SYCLO/DO001Data Object Class Handler Settings28CREATED_TSCreation timestampdecimal150
30/SYCLO/DO001CMobile data object - Composite Settings13CREATED_TSCreation timestampdecimal150
31/SYCLO/DO001EMobile data object - exchange object assignment9CREATED_TSCreation timestampdecimal150
32/SYCLO/DO001FData Object Handler Get Method Field Catalog11CREATED_TSCreation timestampdecimal150
33/SYCLO/DO001SSyclo MDO data staging settings19CREATED_TSCreation timestampdecimal150
34/SYCLO/DO001XMobile data object - proxy setting21CREATED_TSCreation timestampdecimal150
35/SYCLO/DO002BAPI Wrapper Data Object Assignment10CREATED_TSCreation timestampdecimal150
36/SYCLO/EFI01Syclo Exchange enhancement framework assignment8CREATED_TSCreation timestampdecimal150
37/SYCLO/MBL01Mobile device transaction object status12CREATED_TSCreation timestampdecimal150
38/SYCLO/MBL02Mobile transaction update history12CREATED_TSCreation timestampdecimal150
39/SYCLO/MDW00Syclo Middleware User Registry17CREATED_TSCreation timestampdecimal150
40/SYCLO/MDW00CMobile user communication info10CREATED_TSCreation timestampdecimal150
41/SYCLO/MDW00DMobile user client deployment status - last update10CREATED_TSCreation timestampdecimal150
42/SYCLO/MDW00RMobile user cross reference12CREATED_TSCreation timestampdecimal150
43/SYCLO/MDW01Syclo Middleware Session Registry11CREATED_TSCreation timestampdecimal150
44/SYCLO/MDW01RMiddleware session cross reference9CREATED_TSCreation timestampdecimal150
45/SYCLO/MDW05Syclo Middleware Server Data14CREATED_TSCreation timestampdecimal150
46/SYCLO/MSG01Syclo Mobile Data Unit Message Queue (Outbound)37CREATED_TSCreation timestampdecimal150
47/SYCLO/MSG02Syclo Mobile Data Unit Message Queue (Inbound)12CREATED_TSCreation timestampdecimal150
48/SYCLO/OT001Outbound trigger definition21CREATED_TSCreation timestampdecimal150
49/SYCLO/PSH00Push Scenario Definition42CREATED_TSCreation timestampdecimal150
50/SYCLO/PSH00OTPush scenario outbound trigger assignment8CREATED_TSCreation timestampdecimal150
51/SYCLO/PSH01Syclo Push Register28CREATED_TSCreation timestampdecimal150
52/SYCLO/PSH02Syclo Push Register - Instance items17CREATED_TSCreation timestampdecimal150
53/SYCLO/PSH03Push Instance Subscriber List6CREATED_TSCreation timestampdecimal150
54/SYCLO/PSH05User Push history19CREATED_TSCreation timestampdecimal150
55/SYCLO/PSH10Push framework: subscription queue27CREATED_TSCreation timestampdecimal150
56/SYCLO/SC001Syclo Security Check Profile14CREATED_TSCreation timestampdecimal150
57/SYCLO/STG00Syclo cluster data cache storage - header19CREATED_TSCreation timestampdecimal150
58/SYCLO/STG01Syclo cluster data cache storage - item13CREATED_TSCreation timestampdecimal150
59/SYCLO/STG02Syclo cluster data cache storage - data5CREATED_TSCreation timestampdecimal150
60/SYCLO/STG03Syclo cluster data cache storage - supplement parameters7CREATED_TSCreation timestampdecimal150
61/SYCLO/STG04Syclo cluster data cache storage - data structure meta data13CREATED_TSCreation timestampdecimal150
62/SYCLO/SUB01Subscription Agent Definition15CREATED_TSCreation timestampdecimal150
63/SYCLO/SYSLOG001System statistics - Middleware integration30CREATED_TSCreation timestampdecimal150
64/SYCLO/SYSTATS01System performance statistics - daily summary34CREATED_TSCreation timestampdecimal150
65/SYCLO/WB000DevTool: Client application definition header9CREATED_TSCreation timestampdecimal150
66/SYCLO/WB001DevTool: Mobile Screen Definition9CREATED_TSCreation timestampdecimal150
67/SYCLO/WB001FDevTool: Mobile Screen layout15CREATED_TSCreation timestampdecimal150
68/SYCLO/WB001VDevTool: Screen field value table12CREATED_TSCreation timestampdecimal150
69/SYCLO/WB002DevTool: object10CREATED_TSCreation timestampdecimal150
70/SYCLO/WB002ADevTool: Object attributes12CREATED_TSCreation timestampdecimal150
71/SYCLO/WB003DevTool: Mobile Screen Set11CREATED_TSCreation timestampdecimal150
72/SYCLO/WB003ADevTool: Client Screen Set Screen Assignment10CREATED_TSCreation timestampdecimal150
73/SYCLO/WB004DevTool: Action definition12CREATED_TSCreation timestampdecimal150
74/SYCLO/WB005DevTool: client data table10CREATED_TSCreation timestampdecimal150
75/SYCLO/WB005RDevTool: Data table entries10CREATED_TSCreation timestampdecimal150
76/SYCLO/WB006DevTool: Transaction definition header9CREATED_TSCreation timestampdecimal150
77/SYCLO/WB006ADevTool: Client transaction attributes12CREATED_TSCreation timestampdecimal150
78/SYCLO/WB007DevTool: Label table10CREATED_TSCreation timestampdecimal150
79FARR_D_FULFILLMTFulfillment Entries22CREATED_TSUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
80FARR_D_INVOICEInvoice Entries19CREATED_TSUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPBusiness Process Engine
81SWFXIBULKMONBPE: Monitoring Table for Bulks6CREATED_TSUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
82SWFXIDISPATCHBPM: Buffer for Inbound Messages20CREATED_TSUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
83SWFXIDISPMONIMonitoring BPE Inbound Processing18CREATED_TSUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
84SWFXILOGHistory of Processing a Message in BPE8CREATED_TSTime Stamp of Last Changedecimal217