Extracting data from SAP can be done in a variety of ways. Most common methods include the use of a custom built report or program that was created for a specific requirement. Although this SAP extraction method allows for quick access to data in the SAP system, it does not provide any flexibility to the end user if the requirements change. An alternative option is to use the in-built tools that SAP provides out of the box (e.g. ABAP query). These tools are not geared towards the end-user and most require extensive training and additional authorizations before they can be put to good use.

Quadrate's R/3 extraction solution for SAP data provides a simple and easy to use method for performing ad-hoc queries against an SAP system without any programming expertise. Qubed allows the creation of complex data queries across multiple tables and all SAP tables, both standard and custom tables are available to the user. Data can be extracted into end-user friendly formats such as Excel and Access.

Qubed is a powerful SAP reporting application that allows end-users to generate enterprise reports for employees, customers and business partners. Qubed enables developers and end users alike to create, distribute and maintain content-rich SAP reports rapidly and easily. The extensive report writing functionality allows users to create complex business reports in minutes, and reports may be exported in several formats including Excel, TIFF, PDF and HTML. The report writer enables the creation of calculated columns, subtotals, grouping of data and insertion of graphics.

Why Qubed for SAP


RedReduces costly IT resources requirements
Cost for SAP client license to satisfy seasional demand is high
ERP2's flexible licensing module help

Time & Cost to develop custom Program is too high
The time required to create a custom ABAP program that uploads data into SAP can be quite substantial. It begins with the business user writing up the requirements, then passing them onto the developer who will create and test the program. The business user then tests the program in the development environment, relaying any changes back to the developer. This back and forth continues until both are satisfied. Once this is complete, the code is migrated to the QA environment and the testing process begins again. Changes will result in testing again in the development environment and re-migrating to QA. Once the testing is complete in both environments, the program can be moved to production. Depending on how often production migrations are done, this can take several days to occur.

Mass data update through SAP user interface demands for excessive screens navigation
It is common to navigate through multiple SAP screens to complete a single transaction. The time taken will become significant when there are large volume of data update involve. With ERP2, there is the advantageous of using simple copy-and-paste to reproduce business transactions with similar paramters that makes data entry much faster



Key Features


Simple 3 Steps Process
The procedure to upload Excel or Access files into SAP is a simple three step process designed for even the most inexperienced of end-users. The user records the transaction by executing it from within ERP^(2). Once the recording is complete an Excel or Access file is automatically created for the user to add the data to upload. The final and simplest step in the process is to return to ERP^(2) and select the file to upload the data.








Automatic Load File Generation
While navigating between SAP's transaction screens, ERP^(2) does automatic mapping between spreadsheets/databases to fields automatically and a load file will be generated for mass data upload.

 

Error Handling

Simple to understand error handling separates the records that failed, facilitating quick corrections and upload procedures. User can take advantage of the step-through function where graphical view of every screens that Quadrate goes through to upload data will be displayed for diagnosis purpose.



 

 

Report Generation
Report can be generated as printer output or HTML file for audit purpose. Summary report displayed an overall success and error rate for each transaction and ROI summary in form of time saved by Quadrate's ERP2.

Respects SAP Security
No need to setup additional security and ensures users can only upload data that they could have done manually.

Data Validation
Ensures that data being uploaded into SAP is in the correct format so as to prevent errors even before uploading into SAP.

Additional Application Security
Allows the restriction of certain tasks in the application even if the user has sufficient SAP authorizations.

Broad Transaction Support
Allows uploads of data into SAP in all SAP functional areas as well as custom transactions.

Flexible Licensing & Pricing
Lets you choose from a licensing model that suits your individual requirements.

Transaction Stringing
Strings multiple transactions together that can be executed in one step rather than many.