Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • May 01 at 02:49 PM

    I want to replace datasource by another field.

    Not possible!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 01 at 02:59 PM

    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 ?

    Add comment
    10|10000 characters needed characters exceeded

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

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • May 01 at 08:42 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded