SAP PAPM - WRITE FUNCTION

[former_member672444]

Dear experts,

When I use the "Write Function" to write on ADSO, none of the options is enough for what I am looking for.

I have a process and I execute it by selecting Company / Period. In the ADSO I want to persist and keep the data of each execution (society / period) and if there is a change, replace it without losing the historical data.

1.- Delete / Insert: First delete all data found in the ADSO and insert the new one. I lose the historical data.

2.- Modify: It works partially. When there is a change and that change is not only of the ratio, also a characteristic changes (Example: Business changes from N1 to N2) it keeps the record with N1 and adds the new one with N2.

3.- Insert: Duplicate the data if I run multiple times

Anyone know how can I solve this point?

Thanks for your help

[JustineAngeles · Accepted solution]

writer.pngHello,

let me answer your query

in theory for a writer there are three options as you already mentioned above.

• INSERT will perform purely an append. if a specific characteristic combination is already visible and a new entry is to come in then it will be aggregated to the existing entry. Characteristics will be grouped, Keyfigures will be summed-up
• MODIFY will purely adjust or modify the keyfigures of specific characteristic combination. in your example this is not the right type to use, why? because you were actually trying to modify a characteristic (N1 to N2). this is not possible. if you want to do that you have to add a line for N1 to offset the value (make it zero) or to cancel out the entry then add N2 record.
• DELETE AND INSERT starting SP08, the functionality got enhanced to get an option to instead of deleting everything, you can actually choose just a specific characteristic to be considered for deletion before new data will be inserted. kindly check attached example.

Also as i mentioned this is part of SP08 so if your system is older than SP08, you will need to implement a note. below is the note that is responsible for this new feature. 🙂

SAP note 2875466 - FS-PER Rel 3.0 SP08 - Write to BW with planning, apply selection condition

i hope this helps.

regards,

Justine

[rksuvarna1 · Accepted solution]

Thanks Justine. DELETE AND INSERT feature released as part SP08 is very useful, looking for this feature for quite sometime

[former_member672444]

thank you very much Justine.

Right now working with the SP06 and I had not noticed that note.

Regards,

Alejandro

[JustineAngeles]

Hi Alejandro,

welcome.

just let me know if you need anything else. i am encouraging you to always create a new thread for queries you have so we can help other consultants too in case they encourter something similar. 🙂

regards,

Justine