Abstract: A system and method for generating a report by a reporting tool of the Systems Applications and Products (SAP) online financial software. An SAP-readable Aspect file is generated and transmitted to the SAP system where the Aspect file may be queried for generating the report. The Aspect file may be generated by a non-SAP bridge program that utilizes a dataset which may be in a SAP or a non-SAP format. Processing the dataset to generate the Aspect file may include data filtration based on selection rules, and may additionally include rolling up the data of the dataset. Two or more of such datasets may be collectively used to form corresponding Aspect files for generating a report based on a query that relates to the corresponding Aspect files. The Aspect file may include procurement data such as purchase order data and invoice data.

Abstract: A method and system for updating and deleting records in a tableset T of a family having M tables (M≧1). A set S of N source files (N≧1) are embodied in fileset SA at time tA and in fileset SB at time tB. S is logically associated with T. The family has a common family key KF across the M tables and across the N source files. A Delta program generates a dataset D having non-redundant family keyvalues embodying KF. Each non-redundant family keyvalue is drawn from selected Update or Delete records of SB relative to SA. For Updates, a Trigger program generates fileset &Dgr;S from records of SB having a family key in D, and a Bridge program generates fileset &Dgr;T that includes &Dgr;S data in a form compatible with T. A Load program updates and deletes records in T based on the non-redundant family keyvalues.

Abstract: A method and system for updating and deleting records in a tableset T of a family having M tables (M≧1). A set S of N source files (N≧1) are embodied in fileset SA at time tA and in fileset SB at time tB. S is logically associated with T. The family has a common family key KF across the M tables and across the N source files. A Delta program generates a dataset D having non-redundant family keyvalues embodying KF. Each non-redundant family keyvalue is drawn from selected Update or Delete records of SB relative to SA. For Updates, a Trigger program generates fileset &Dgr;S from records of SB having a family key in D, and a Bridge program generates fileset &Dgr;T that includes &Dgr;S data in a form compatible with T. A Load program updates and deletes records in T based on the non-redundant family keyvalues.

Abstract: A system and method for generating a report by a reporting tool of the Systems Applications and Products (SAP) online financial software. An SAP-readable Aspect file is generated and transmitted to the SAP system where the Aspect file may be queried for generating the report. The Aspect file may be generated by a non-SAP bridge program that utilizes a dataset which may be in a SAP or a non-SAP format. Processing the dataset to generate the Aspect file may include data filtration based on selection rules, and may additionally include rolling up the data of the dataset. Two or more of such datasets may be collectively used to form corresponding Aspect files for generating a report based on a query that relates to the corresponding Aspect files. The Aspect file may include procurement data such as purchase order data and invoice data.