Importing IS-U Extracts into the Evaluation System 

Use

You use this business process to import the IS-U extract files from the productive system to the evaluation system for auditing.

During the execution of import programs, the data from the extract files is transferred to short tables in the evaluation system. These tables are not the same as the original extraction tables in the productive system.

The import of IS-U extracts to the evaluation system is a prerequisite for displaying and evaluating extracts in the evaluation system.

Prerequisites

The imported extracts in the evaluation system must be in CSV format.

Regardless of the release status of the productive system, the evaluation system must be at least SAP Utilities 4.71. This is because the programs for importing extracts to the evaluation system and the necessary display transactions are only delivered as of SAP Utilities 4.71.

If you have included customer-specific table fields in the extract file, you must adjust the predefined table definitions for import tables in the Data Dictionary (so that these fields can also by imported to the short tables).

Process Flow

The business process runs as follows:

...

       1.      Import business partner extract

The import program imports a file with the business partner extract (partner data) to table DFKKGP_SHORT. If an extract with the same name already exists in the database, you can overwrite the existing extract or you can just import the partners that do not yet exist in the database. The program reports the number of business partners that were imported incorrectly as well as those that were imported correctly.

       2.      Import customizing extract

The import program imports a file with the customizing extract (long text) to table DFKK_CUST_SHORT. If an extract with the same name already exists in the database, you can overwrite the existing extract or you can just import the Customizing entries that do not yet exist in the database. The program reports the number of Customizing entries that were imported incorrectly as well as those that were imported correctly.

       3.      Import FI-CA document extract and corresponding SD extract data

The import program imports a file with the document extract (condensed documents). If an extract with the same name already exists in the database, you can overwrite the existing extract or you can just import the documents that do not yet exist in the database. The program reports the number of documents that were imported incorrectly as well as those that were imported correctly.

       4.      Import print document extract

The program imports a file with the print document extracts (condensed documents). The program reports the number of documents that were imported incorrectly as well as those that were imported correctly.

       5.      Import billing document extract

The import program imports a file with the print document extracts (condensed documents).

The program reports the number of documents that were imported incorrectly as well as those that were imported correctly.

       6.      Import extract for simulated billing documents (unbilled revenue)

The import of data extracts for simulated billing documents takes place in the same way as for standard billing documents.

       7.      Display overview of document extracts

You can display an overview of all extracts imported to the evaluation system for the different extract categories. In this overview, you can execute other functions such as importing and exporting additional extracts as well as deleting data extracts.