cancel
Showing results for 
Search instead for 
Did you mean: 

How to delete data in planning DSO with help of Sqlscript procedure

0 Kudos
193

Hello,

this is my first question here in SAP Community and I hope it will be successful for me.

My question is about the deletion of data in planning DSO with help of Sqlscript procedure in PAK.

We manipulate data in a planning DSO with a help of a planning function built on a sqlscript procedure.

In planning DSO we have necessary record which we want to delete. So in InTab parameter of sqlscript procedure relevant of our PF we get this record according our filter.

How can I delete this record in DSO with sqlscript procedure the same way as I can do this in ABAP runtime with help of parameter cl_rsplfr_controller=>n_delete_records = rs_c_true?

Another possible scenario - if I use the special characteristic as KYF to define that this record has to be deleted. What operand could I use to archive the deletion of this record by the sqlscript procedure?

Is it possible to made such deletion in the procedure with delta mode or only with after-image mode?

We are on BW on Hana 740 SP23 and DB Hana 2.0 SPS Rev37.03.

Thank you in advance.

Regards

Pavel

Accepted Solutions (0)

Answers (0)