SAP has three different types of tables: Pooled tables, direct tables, and clusters. Pooled tables pool together several smaller lists and lookups into one table. The format of the pooled tables is basically Cobol Record structure. SAP Pooled Table Viewer uses the SAP data dictionary to create Oracle views that allow easy querying of the SAP data. This makes it easier to integrate with SAP systems where you can use database connectivity and bypass the need for ABAP.
Hovitaga OpenSQL Editor is a powerful tool for SAP consultants, ABAP developers, and basis administrators that helps to work with the database of a SAP system. It provides an intuitive way to build ad-hoc reports and statistics with OpenSQL commands. Writing programs that access the database in any form becomes much easier since all commands accessing the database can be developed, tested, and analyzed with many user-friendly features.
Hovitaga Report Generator is an ABAP add-on that accelerates SAP reporting by significantly reducing development time. This is achieved with automatic ABAP code generation, which eliminates manual programming of code that is always part of every report but is always different. Depending on the generation settings, 200-1000+ lines of ABAP code can be generated in a few minutes.
Hibersap is a small framework that offers an abstraction layer on top of the SAP Java Connector (JCo). It maps Java classes to SAP function modules using Java Annotations and reduces the technical code to call a function in a SAP back-end system. Hibersap’s API is very similar to Hibernate, thus offering a familiar programming interface to developers of enterprise applications.
FACTORITY is a manufacturing execution system (MES). It provides the connection between the planning and the production level of production companies. FACTORITY supplies information at any time about the current production situation and so permits fast and appropriate responses to events. The result is effective and economically optimized solutions for process planning, process control, and process tracking.
Pool Table Viewer creates database views that allow access to pooled tables directly from Oracle. SAP stores lookup and reference tables in a format known as pooled tables. These keep the data stored in a COBOL/ABAP record format, and the data is not normally readable from Oracle directly. This viewer can be useful for integration software, where there would not be a requirement to write ABAP interface code to access the SAP data. This works with any SAP R3 system with an Oracle database backend.