Skip to Content
0
Former Member
Jul 30, 2008 at 07:36 AM

Command Interface Report

17 Views

Hi Experts

I have one requirement to proceed for the following below by the managment.

need to create a u201Creportu201D to be executed in batch mode which will delete Command interface records from SAP.

There are two tables from which the data needs to be deleted:

1. ZINT_DATA

2. ZINT_MSGS

ZINT_DATA contains the actual data records from Command together with information about this data, e.g. processing status, date to which the data refers etc.

ZINT_MSGS contains messages which have been generated during the SAP processing of the data records.

Criteria for selecting records to be deleted are as follows:

1. ZINT_DATA

u2022 ZINT_DATA.CREATED_ON <= (Today u2013 30 Days)

u2022 ZINT_DATA.STATUS = u2018OKu2019

2. ZINT_MSGS

u2022 ZINT_MSGS.CREATED_ON <= (Today u2013 30 Days)

The report should log the number of records deleted from each table at End Of Run.

I would be thankful if anyone comment on how to create this report.

Regards

Piroz

Edited by: Piroz Eslam on Sep 19, 2008 8:36 AM