Sap Ag

Sap Se

Ohad Navon

Orit Harel

Malkiel Hadari

Inbal Zilberman Kubovsky

Amiram Wingarten

Tamir Menahem

The present disclosure describes methods, systems, and computer program products for debugging structured query language (SQL) statements. One computer-implemented method includes receiving a request to fetch a debug execution plan considering different structured query language (SQL) execution optimization levels and including a mapping for a SQL statement, receiving a request to initialize a debugging process of the SQL statement, verifying received and attached filter criteria provided using a SQL debug channel, setting SQL statement breakpoints, triggering the SQL statement, transmitting a notification that a SQL process is attached to a debugger associated and ready for external execution control, providing state details and an intermediate result upon reaching a particular breakpoint associated with the SQL process, providing an ability to change the process state and influence the process, and providing a SQL final execution response after reaching the end of the execution of the triggered SQL statement.

Structured query language debugger

In a first general aspect, a computer program product tangibly embodied in an information carrier is described. The computer program product includes instructions that, when executed, perform operations for identifying a source or destination for stock. The operations include receiving an electronic request to determine a source or destination for stock, identifying, using a primary rule, a logistic area database object that represents a storage location at one of multiple levels of a hierarchy of storage locations. The logistic area database object is associated with a value that indicates an amount of stock that is associated with the storage location. The operations also include transmitting an identifier specifying the logistic area database object if the value indicates that associated storage location is available as a source or destination. The identifier is used to assign the storage location as the source or destination for the stock.

Source and destination determination system and method

Growing community of inventors

Kiryat Tivon, Israel

Ohad Navon