Network Qty is not imported in CPM workbook

[former_member132049]

Dear Experts,

I am trying to import the internal activity Qty ( total work hours) to CPM using standard Import method 0IMPORT_NWA_QTY.

In the import log, it shows Qty imported for a particular network activity, however I can't find anything in the CPM workbook.

any possible reason ?

Thanks

Ashis

[raymond_amalraj · Accepted solution]

Hi Ashis,

It should import qty if you have maintained activity type and work quantity in the network activity in PS. Please check.

[former_member132049 · Accepted solution]

Hi Raymond,

The requirement is to import only qty from PS Network to CPM workbook and then enrich with activity type in the planning workbook.

Only change in this case is, Customer is using a custom resource type ZACT instead of 0ACT.

So we have mapped the import method res type field with ZACT, which should work fine.

The strange thing is, we are getting success message of Qty imported for the particular activity, however nothing is inside the workbook.

It seems some issue in BW side but not sure.

[raymond_amalraj · Accepted solution]

Please check if this import method has really uploaded data into BW cube(/CPD/PFP_R01) by checking in listcube for this plan and structure element

[former_member132049 · Accepted solution]

I checked the cube and there is no entry exist for the particular network activity, even though I got a success message of import.

Any information, which FM/BAPI post this data ( from PS network ) to BW cube ?

Thanks

Ashis

[raymond_amalraj · Accepted solution]

You may check and debug class /cpd/cl_pfp_upward_transfer, method execute.

Or you may simulate Import via report /CPD/PFP_INITIATE_IMPORT run for financial plan and version.

[former_member132049 · Accepted solution]

Thanks a lot Raymond for your quick response.

[kenmelching · Accepted solution]

The Import methods will import the Key Figures specified in configuration (quantity in your case) and they will import the characteristics as well. The method will use the Resource Type you specify in configuration and it will determine the resource to match. Since you are not using 0ACT it looks like the ZACT resource is not being determined correctly. The log messages are written prior to completing the import or writing to the cube, sometimes they are misleading.

I have spent many hours debugging the import methods because we enhanced them to import the entire financial plan.

[kenmelching]

Use LISTCUBE to see if the data has been imported to the CPM financial plan cube.