Patent ID: 7539672

Claim:
An apparatus to retrieve data directly from SAP database, the apparatus comprising: a processor; a memory coupled to the processor to execute instructions stored in the memory, the memory comprising an input module receiving a table business object comprising a query criteria, the query criteria selected from the a group consisting of a retrieve-all method for direct retrieval of the table business object and a data exists method to indicate a data exists status of data in the SAP database, the query criteria unsupported by a SAP business application programming interface (BAPI) of the SAP database; a table hierarchy module determining a table hierarchy associated with the table business object using hierarchal information stored in the table business object; a query builder module building a native SAP query based on the table hierarchy and the query criteria methods, the native SAP query built such that the native SAP query is compatible with an advanced business application programming (ABAP) application programming interface (API) of the SAP database; a query execution module executing the native SAP query directly on the SAP database using the ABAP API; and a response builder module returning results of the native SAP query.