Question Re: COPY Standard Package - Customize to not clear data in Financial Management Q&A

COPY Standard Package - Customize to not clear data

Former Member — Thu, 22 Mar 2018 19:30:11 GMT

I'm using the Copy standard Package - but I need to change the "Target Mode" to "Clear Data", because I need the option to "Merge data values (Imports all records, leaving all remaining records in the destination intact)".

What I need to change?

PROMPT(RADIOBUTTON,%TARGETMODE%,"Handling of records",0,{"Copy records with match key","Copy by replacing data in same data region of Entity, Category, Time and Audit ID"},{"0","2"}) 'PROMPT(RADIOBUTTON,%RUNLOGIC%,"Select whether to run default logic for stored values after copying",0,{"Yes","No"},{"1","0"}) 'PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when importing data.",1,{"Yes, check for work status settings before importing","No, do not check work status settings"},{"1","0"}) PROMPT(COPYMOVE,%SELECTION%,%TOSELECTION%,"Select the members to COPY and where to",%DIMS%,0) INFO(%TEMPNO1%,%INCREASENO%) INFO(%ACTNO%,%INCREASENO%) INFO(%SELECTION_KEYDATE%,) TASK(/CPMB/CM_CONVERT,OUTPUTNO,%TEMPNO1%) TASK(/CPMB/CM_CONVERT,ACT_FILE_NO,%ACTNO%) TASK(/CPMB/CM_CONVERT,SAPPSET,%APPSET%) TASK(/CPMB/CM_CONVERT,SAPP,%APP%) TASK(/CPMB/CM_CONVERT,SELECTION,%SELECTION%) TASK(/CPMB/CM_CONVERT,TOSELECTION,%TOSELECTION%) TASK(/CPMB/CM_CONVERT,KEYDATE,%SELECTION_KEYDATE%) TASK(/CPMB/CLEAR_SOURCE_CUBE,CHECKLCK,%CHECKLCK%) TASK(/CPMB/CLEAR_SOURCE_CUBE,SELECTION,%TOSELECTION%) TASK(/CPMB/CLEAR_SOURCE_CUBE,KEYDATE,%SELECTION_KEYDATE%) TASK(/CPMB/CLEAR_SOURCE_CUBE,DUMPLOADMODE,3) TASK(/CPMB/APPEND_LOAD,PREPROCESSMODE,0) TASK(/CPMB/APPEND_LOAD,TARGETMODE,%TARGETMODE%) TASK(/CPMB/APPEND_LOAD,INPUTNO,%TEMPNO1%) TASK(/CPMB/APPEND_LOAD,ACT_FILE_NO,%ACTNO%) 'TASK(/CPMB/APPEND_LOAD,RUNLOGIC,%RUNLOGIC%) 'TASK(/CPMB/APPEND_LOAD,CHECKLCK,%CHECKLCK%) TASK(/CPMB/APPEND_LOAD,RUNLOGIC,0) TASK(/CPMB/APPEND_LOAD,CHECKLCK,1) TASK(/CPMB/APPEND_LOAD,KEYDATE,%SELECTION_KEYDATE%)

Re: COPY Standard Package - Customize to not clear data

former_member186338 — Thu, 22 Mar 2018 19:41:16 GMT

The week of strange questions 🙂

"I'm using the Copy standard Package - but I need to change the "Target Mode" to "Clear Data", because I need the option to "Merge data values (Imports all records, leaving all remaining records in the destination intact)"."

What do you want? Please explain in words!

P.S. "Copy records with match key" will copy records without clearing destination!

P.P.S. Read note: https://launchpad.support.sap.com/#/notes/2241115

Re: COPY Standard Package - Customize to not clear data

Former Member — Fri, 23 Mar 2018 21:49:29 GMT

I'm so sorry if I wasn't clear.

The data that I have are:

Account Version Customer Material Time Value

KSD90 ZRU CU_010141000010008476 02401002CE 2018.10 1,000.0000000-

KSD90 LE00 CU_010141000010008476 02401002CE 2018.10 350.0000000-

KSD90 ZRU CU_010141000010008476 02502001CE 2018.10 500.0000000-

I need to copy version LE00 for ZRU - but I have a data in ZRU version that I don't have in LE00, and I need to keep this data.

I ran the Copy standard package with the option: "Copy records with match key"

And it was clear the 1,000,00:

KSD90 LE00 02502001CE 350.0000000-

KSD90 ZRU 02502001CE 500.0000000-

KSD90 ZRU 02502001CE 150.0000000

KSD90 ZRU 02401002CE 1,000.0000000-

KSD90 ZRU 02401002CE 1,000.0000000

Re: COPY Standard Package - Customize to not clear data

former_member186338 — Sun, 25 Mar 2018 11:24:55 GMT

You have:

In LE00:

KSD90 LE00 CU_010141000010008476 02401002CE 2018.10 350.0000000-

in the target ZRU you have:

KSD90 ZRU  CU_010141000010008476 02401002CE 2018.10 1,000.0000000-

For sure 1,000.0000000- will be overwritten by 350.0000000-

What do you want? To append??? Not clear from your post!

Or may be you are talking about the case: https://archive.sap.com/discussions/thread/3724906

Re: COPY Standard Package - Customize to not clear data

Former Member — Mon, 26 Mar 2018 17:18:49 GMT

Vadim,

I have differents products:

In LE00

KSD90 LE00 02502001CE 350.0000000-

In ZRU

KSD90 ZRU 02502001CE 500.0000000-

KSD90 ZRU 02401002CE 1,000.0000000-

The 500 will be overwritten by 350, that's fine. But I need to keep the other line (other product) with 1,000.

According the case, you sent, I need to custom the process chain, but I dont know how.

Re: COPY Standard Package - Customize to not clear data

former_member186338 — Mon, 26 Mar 2018 19:03:13 GMT

To create a required chain you need to play with APPEND_LOAD parameters and remove CLEAR_SOURCE_CUBE step from the chain.

You will have to debug in abap class execution for APPEND_LOAD.

P.S. May be lucas.costa3 can help.

Re: COPY Standard Package - Customize to not clear data

lucas_costa3 — Mon, 26 Mar 2018 19:41:52 GMT

Not much help here.. loosing my juggling with BPC Standard.

Re: COPY Standard Package - Customize to not clear data

lucas_costa3 — Mon, 26 Mar 2018 19:42:57 GMT

The Copy records with match key theoretically would leave the 1000 (product 02401002CE) intact, replacing just the records with complete match key (all dimension members from source).

Unless your process chain is not reading the parameters from the DM package.

If you want to create a custom process, it's not a simple task, take a look at class CL_UJD_BPC_DUMP_LOAD

Re: COPY Standard Package - Customize to not clear data

former_member186338 — Mon, 26 Mar 2018 19:49:47 GMT

Another option that will definitely work is to use script ogic to copy data. The only disadvantage that you will not be able to use copymoveinput for multiple dimensions in one screen.

Re: COPY Standard Package - Customize to not clear data

Former Member — Tue, 27 Mar 2018 11:40:40 GMT

Vadim, thank you so much! I will work on that options.