Specification to ABAP code converter

Details Specification to ABAP code converter Specification to ABAP code converter

1999-03-02

2004-08-03

Dam, Tuan (Department: 2122)

Data processing: software development, installation, and managem

Software program development tool

Code generation

C717S117000, C717S137000

Reexamination Certificate

active

06772409

ABSTRACT:

BACKGROUND OF THE INVENTION
The present invention relates to database processing in general and to generation of ABAP code in particular.
SAP R/3 system is an Enterprise Resource Management system used to manage various IT subsystems used to operate a company (e.g., manufacturing, sales and distribution, logistics) in an integrated fashion. A typical SAP R/3 installation requires extensive configuration to embed the specific business rules for the company using SAP R/3 into the system as well as produce the reports required by the company. Most of a generic SAP R/3 system as well as most of the configuration and reporting is written using the ABAP/4 language.
One approach to extracting data uses ETL (“Extraction, Transformation and Loading”) tools to convert a procedural specification into a procedural language to execute that specification. However, since the specification is a procedural specification, the user has to manually specify the optimal (most efficient and fastest) way of executing the specification.
SUMMARY OF THE INVENTION
According to one embodiment of the present invention, procedural language code is generated for extracting data from an operational system such as an SAP R/3 system, for transforming it and for loading it into a target system, such as a data warehouse. This is done by accepting a declarative specification and generating procedural language code to execute the declarative specification.
The data extraction process for extracting data from an SAP R/3 system accepts a declarative specification, in visual form or otherwise, and uses an optimizer to optimize the specification and generate an execution plan to perform the extractions and transformations specified in the declarative specification. The process then generates a procedural program in the ABAP language to perform the operation. This approach allows the user to focus on what needs to be done, while the system takes care of the most efficient way for how to do it. Figuring out the most efficient way for executing the specification is a complicated process and will take much effort if done manually by the user. This approach is particularly beneficial when the specification is revised, because the system can easily reoptimize the entire specification and produce a new optimal plan.
A further understanding of the nature and advantages of the inventions herein may be realized by reference to the remaining portions of the specification and the attached drawings.


REFERENCES:
patent: 5448740 (1995-09-01), Kiri et al.
patent: 5530848 (1996-06-01), Gilbert et al.
patent: 5758032 (1998-05-01), Sanders
patent: 5815713 (1998-09-01), Sanders
patent: 6148335 (2000-11-01), Haggard et al.
patent: 6192370 (2001-02-01), Primsch
patent: 0511437 (1991-04-01), None
patent: 602263 (1992-12-01), None
patent: 0737918 (1996-10-01), None
SAP R/3 Data Warehousing and Application Integration pp. 1-17.*
Enterprise Data Warehousing for Sap R/3 © 1998 pp. 1-17.*
Thomas Curran, “Technical Review: SAP's ABAP/s Development Workbench,”Object Manager, pp. 10-15 (Dec., 1994).
C. J. Date, “An Introduction to Database Systems, vol. 1, 5th Edition,” Addison-Wesley Publishing Company, pp. 455-488 (1990).

Affiliated with

Also associated with

Rating

Specification to ABAP code converter does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Specification to ABAP code converter, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Specification to ABAP code converter will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3316089