Insert delete or update entry in Custom table from KONV entry changed

[Former Member]

Hi All,

I have custom table ZKONV with only few required columns and should have same number of records as KONV has at any point in time.

KONV is a cluster table so its not readable from ORACLE level. So ZKONV is created. But I dont know how to keep these both tables in sync.

I need to perform insert delete or update entry in Custom table if insert delete or update happens on cluster table KONV from any transactions.

As KONV is a cluster table and does not have changed time stamp I am not able to know the number of records changed in perticulat time period.

Thanks,

[vinod_vemuru2]

Hi,

Hard way is to have a small program which would DELETE data from Ztable, select from KONV and UPDATE again. This can be scheduled as a daily batch job.

By the way, why you want to read the data at ORACLE level? would NATIVE SQL statements help here?

Thanks,

Vinod.

[Former Member]

Thanks for reply,

There is a Outside SAP system which needs to read KONV data to feed into their system, but as KONV is cluster table they are not able to read it from ORACLE level.

To solve this we are thinking to create a transparent Z-table and will fill it with KONV and catch Update, delete or Insert statement and do same on ZKONv.

Is this possible some how? by some database event or something....

[vinod_vemuru2]

Hi,

How about creating RFC FM and ask the other system to call? Select query can be written in the FM with appropriate inputs to reduce the execution time.

Thanks,

Vinod.

[Former Member]

The problem here is, external system wants to avoid RFC calls.

and in KONV we dont have changed date and time so could not find the records updated in particular time frame.

[vinod_vemuru2]

Hi,

In that case only option is to have your custom table updated with periodic batch job.

Even if you have creation date/time in KONV, it is not possible to get deleted records from this table. Hope i am clear.

Thanks,

Vinod.

[Former Member]

hi,

Write a Abap Program and Update Regular interval of time in Background

this forum link will help you.

Thanks

Rajashiva.R

[Former Member]

1. As per the above comments schedule a custom program in background which updates ztable based on changes in KONV

2.Identify the process through which KONV is changed.IF any BO is thr for the process , On triggering BO u can run the report.

3.In KONV table technical settings , there is one option log data changes - u can enable it with key and based on the log u can update custom table .which will avoid periodic checks from the KONV table.