Skip to Content
0
Former Member
Dec 08, 2008 at 05:19 AM

how to delete record in start routine

213 Views

Hello Experts,

I want to extract records only for 1 Distribution channel while loading data from PSA to ODS.

For this can I use following code in Update rules Start Routine?

delete DATA_PACKAGE where comm_structure-0DISTR_CHAN = 10 or

comm_structure-0DISTR_CHAN = 30.

With this all records for the given Distribution Channel will get deleted from PSA table? Because the same PSA is used to load data into cube WITHOUT ANY RESTRICTION OF DISTRIBUTION CHANNEL.

Regards,

Priyanka Joshi