OPAL/Miner - Features

Introduction

OPAL/Miner was written to provide a simple and efficient means to easily access and download SAP data directly to your PC or server in a number of file formats. It is based on a SAP standard RFC call which utilises the built-in security of the SAP system. This software does not provide back door entry to SAP data, does not contain functionality to update any data on the SAP system, and does not generate any ABAP code.

You can quickly and easily download data from any SAP table (R/3 or BW) relating to any SAP module. For example, Basis consultants can download and analyse transport information from tables E070, E071, and E07T. ABAP consultants can immediately access data in the TADIR and TRDIR tables. SD consultants can download data from tables KNA1 and VBAP. FI consultants can download data from table BSEG or the multitude of CO-PA tables. If so inclined, BW consultants can even download fact tables or any other associated BW tables including the underlying tables for ODS and InfoCube objects. ANY SAP R/3 OR BW TABLE CAN BE DOWNLOADED! There is no limit other than your own authorisation level within SAP.

The scheduled batch download feature will allow the download of any number of tables overnight and have them ready for use by your user community the next morning. This feature is the ideal solution for establishing a data warehouse and keeping it updated.

The bottom line is that time is money.Do not waste valuable external consultant, contractor, or in-house programmer time by not having the right tool to access and analyse your SAP data. OPAL/Miner will provide a return on your investment within hours.

Features

no data reformatting required as is the case with running SE16 and 'right-click' -> download' or 'save to local file' methods. The data is ready to use immediately without the tedious task of reformatting. access to any SAP table dependent on authorisation level (requires a SAP logon). no custom SAP interfaces are needed ... just install on your PC and get at your data immediately. no ABAP code is generated on the SAP side. up to 255 individual fields can be selected for download without any record length restrictions. ability to enter complex record selection criteria. dynamic date functions available within selection criteria. functionality to include external user defined functions in selection criteria. download to an external delimited file with choice of delimiter (tab, comma, none, user-defined). option to include field name and/or field description in first two rows of external download file. download to an MS Access table created 'on the fly'. The data is then available to a multitude of MS Office applications. save download specifications for later recall and execution. download specifications can be viewed, printed, deleted, or renamed. specifications may be exported/imported to allow sharing. utility functions that allow viewing and deleting tables downloaded to MS Access. timed or immediate batch download of multiple SAP tables. download to any ODBC compliant database. download to a native Excel spreadsheet. configuration options for external file and spreadsheet download file path and file extension. housekeeping functions for the Support and Container databases. execute an external application with optional command line parameters before and/or after a table download. supports Asian and other double-byte character sets.

 

System Requirements

512Mb RAM Minimum 1024Mb combined RAM and page file size Microsoft Windows NT, 2000, XP MS Access 2000, MS Access 2002, MS Access 2003, or MS Access 2007 SAPGUI interface to a SAP system