Skip to Content
0

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

May 01 at 01:30 PM

42

avatar image
Former Member

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"})

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Vadim Kalinin May 01 at 02:49 PM
0

I want to replace datasource by another field.

Not possible!

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 01 at 02:59 PM
0

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 ?

Show 2 Share
10 |10000 characters needed characters left characters exceeded

No, not a solution.

0

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

0
avatar image
Former Member May 01 at 06:20 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Vadim Kalinin May 01 at 08:42 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded