Ansicht
Dokumentation

RFLQ_UPLOAD_QR - Upload of Queries from Local File

RFUMSV00 - Advance Return for Tax on Sales/Purchases   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Purpose

Automatic creation of queries with data from a local file

Prerequisites

The local file from which the data is to be taken should be generated as follows: Execution of the report RFLQ_LISTQR (transaction: FLQLQR) in the sources system with generation of a standard list, optimization of column widths inactive. The list of queries generated in this way with conditions is saved locally as an unconverted text file with a '.TXT' ending.

The exact requirements for the field sequence and lengths can be found as a comment in the source text of the program at hand. If your file deviates from this, you need to copy this program into a separate program, and then the carryover from the flat line structure to the structured internal table is adapted there.

Features

Selection

On the selection screen, specify the name of the local file to be read at the top (complete path). Next a box appears in which you establish how queries are to be processed that already exist in the target system. You can choose between:

• Giving the old query priority and ignoring the new one.

• Keeping the header data from the old query (texts and liquidity item) and completing replacing the conditions.

• Completely updating the old query.

Furthermore you can restrict the program to queries that are only valid for a specific company code (authorization). Finally, there is the test run option: The local file is analyzed here and the result is only displayed; none of the data is changed.

Output

You receive a log, in which, similar to transaction FLQLQR, the erroneous and transferred queries and conditions are displayed.

Activities

The program checks the read data. Errors on the header level (origin indicator, company code, liquidity item) stop the query from being created. Errors in condition lines cause the associated condition not to be defined; in extreme cases queries end up being created without conditions. The errors are displayed in the log.

In case you have forgotten, the program tells you to initialize system tables in the target system that are needed to save the conditions using the program RFLQ_INITTBL. If you have included more fields for the conditions according to SAP Note 497118, you should check whether table FLQQR_FIELD has the same status in both systems.

BAL Application Log Documentation   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 2599 Date: 20240520 Time: 104119     sap01-206 ( 60 ms )