How to modify the key of the CLEAR in process chain /CPMB/IMPORT_APPEND

[patrice_chartier]

hi,

Is there a way to modify the KEY fields defined in this PROMPT definition of the data manager package /CPMB/IMPORT_APPEND ? By default, the combination is entity/category/time/datasource, I want to replace datasource by another field.

This is the default script in data manager package "IMPORT_APPEND":

PROMPT(RADIOBUTTON,%CLEARDATA%,"Select the method for importing the data from the source file to the destination database",0,{"Merge data values (Imports all records, leaving all remaining records in the destination intact)","Replace && clear datavalues (Clears the data values for any existing records that mirror each entity/category/time/datasource combination defined in the source, then imports the source records)"},{"0","1"})

[former_member186338]

Before importing data you can run additional DM package: standard clear package or package with script logic to clear required scope (including selected accounts only)

Then import without clear.

[patrice_chartier]

I load data from a file using the datamanager package APPEND. There are many ENTITY and many ACCOUNTS in the file. Users also input ENTITY/ACCOUNTS in the same model using input-schedule (but different ACCOUNTS). When I load my file I need to replace all ENTITY/CATEGORY/TIME and ACCOUNTS data and I don't want to delete the other ACCOUNTS inputted by the users. The default combination of dimensions in the datamanager package APPEND for the CLEAR part is ENTITY/CATEGORY/TIME/DATASOURCE. So it deletes all the ACCOUNTS including the one from the users input-schedule.

[former_member186338]

Yes, this is the standard behavior and you can't change it.

[patrice_chartier]

In this post : https://archive.sap.com/discussions/thread/748632

they mentioned to add this command in the data manager package advance script:

TASK(LOAD AND PROCESS,SELECTIONFROMTASK,"ENTITY,DATASRC,TIME,CATEGORY")

it is not good ?

[former_member186338]

No, not a solution.

[former_member186338]

P.S. it's better to explain your business requirements in details!

[former_member186338]

I want to replace datasource by another field.

Not possible!