Ansicht
Dokumentation

RFVD_MAINTAIN_VDBIW_DATA - Maintenance of Shadow Table (VDBIW_DATA) of BW Extractor in CML

PERFORM Short Reference   PERFORM Short Reference  
This documentation is copyright by SAP AG.

Purpose

You use this report to reset the shadow table (VDBIW_DATA) of the loan extractor. You can also use it to delete loans or individual records from the shadow table.

Integration

In the Delete All Entries screen you can delete individual records or a quantity of data records from the shadow table of the BW extractor. The system determines the relevant data records and deletes them from the shadow table based on the selection criteria you enter. You can restrict the time of the selection and the deletion using the parameters Current Date and Time.

In the Only Delete Data Records screen you can delete individual records or a quantity of data records from the shadow table of the BW extractor. The system determines the relevant data records and deletes them from the shadow table based on the selection criteria you enter. You can restrict the time of the selection and the deletion using the parameters Current Date and Time.

In the Only Delete Administration Recordsscreen you can delete individual records or a quantity of data records from the shadow table of the BW extractor. The system determines the relevant data recordsand deletes them from the shadow table based on the selection criteria you enter. You can restrict the time of the selection and the deletion using the parameters Current Date and Time.

In Reset mode the report deletes the entries from the last request in the shadow table of the BW extractor that belong to the company code and product type or types selected. The system removes the entries that have a time stamp that is after the time stamp of the last request. Entries for which the deletion indicator has been set and that have a time stamp after the time stamp of the penultimate request are revived, meaning the deletion indicator is removed. The system then deletes the corresponding time stamp of the last request from the time stamp table. The contract number parameter does not have a function in the Reset mode.

In the Reorganization mode, the system deletes all of the data records with a set deletion indicator in the shadow table. You need to execute the Reorganization after every successful extraction. After the reorganization you can no longer reset the table. Only the Infosource selection parameters are relevant in the Reorganization mode.

Prerequisites

Features

Selection

Deletion: Deletion mode for individual loans or records

Reset: Resetting the shadow table by a request.

Infosource: Entries of the Infosource that are to be deleted

Company code: Company code

Contract number: Loan contract (ignored in Reset mode)

Date: Date from which the entries are to be deleted or to which the table is to be reset.

Time: Time from which the entries are to be deleted

Time Zone: The time zone to which the date and time refer. Warning: The date and time are converted to GMT for the creation of a time stamp. The time zone controls the generation.

Test run: If you set the test run indicator the database operations are not executed.

Standard Variants

Output

Activities

Example

General Material Data   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

Length: 3628 Date: 20240520 Time: 114111     sap01-206 ( 78 ms )