CN41N and S_ALR_87013533 report not showing Production order planned cost

[Former Member]

Hi Experts,

I am having issue to get total planned production order values in my CN41N or S_ALR_87013533 cost report. I am facing 2 issues :

1. CN41N repoet does not show individual material cost planned in BOM.

2. CN41N report and S_ALR87013533 report does not show total value but only picking fixed value.

Example :

1. CN41N report :

Above screenshot shows no values in Project plan cost & Order cost column but it shows total cost as a lumpsum on top for project. I need to know how can i get material cost populated here for Project Valuated stock material?

2. S_ALR_87013533

This report shows Total Cost of BOM as 1 line under Material Procurement activity similar to CN41N report. Also Order value is picking from Fixed cost from planned order and total cost is added on top. How can i get Total cost picked from production order?

Is there any Setting in PS config which allow me to pick the detail production order plan cost in both report under planned cost.

Thanks in advance.

Ashish

[former_member195427 · Accepted solution]

Hi Ashish,

Please check in OPSV settings . Both the check boxes are ticked for PP order type or not.

Check mark these check boxes followed by CJEN run and check the report again.

Regards

Saurabh

[Former Member · Accepted solution]

Hi Saurabh,

Both are already ticked.Report shows total from production order however details for each item is not shown.

[former_member195427]

Hi Ashish,

Have you got any success on it?

Regards

Saurabh

[Former Member]

No, so far 😞

[Former Member]

Hi Ashish,

On the report output, click on icon "hierarchy" and then button expand all.

Next select column "Plan" and then click on one more icon "call up report" which prompts another window and select to display the line item reports. then you will see the line item details of planned cost.

Thanks,

Sudhakar

[Former Member]

Dear Sudhakar,

I tried the option you have mentioned for 'CN41" report however no result. Please have a look in the screen shared below.

I want to know if there is any way possible to get the detail values in actual value.

Regards

Ashish

[Former Member]

Hi Ashish,

Sorry for the confusion. the procedure described for S_ALR_87013533 which i missed to mention.

coming to your issue, production order cost line item details not showing up in any of the report. Go to CJI3 and key referenced WBS elements and change the layout and set the following columns. that will let you know how postings have been at the time of cosumption of materils.

Document date, object type, document number, business transactioon, partner object, copartner object name, origin object type, ref document number, reference document type, source object.

after that you can discuss with your FI team.

I guess you must be using account assignment P in your production orders. Then cost will be booked to WBS and so you will accumulated cost at WBS level. On the CJI3 screen selecting WBS elemnet line and go menu bar Environment >Accounting documents you will see the posting details.

In CN41, select the referenced WBS element and go to menu bar Goto>Structure overview>Cost overview so that you will see the individual details.

Try other cost element report S_ALR_87013542 to see the detailed actual costs with resepct to cost elements.

Thanks,

Sudhakar

[Former Member]

Hi Sudhakar,

I highly appreciate you reply to provide me the pointers

S_ALR_87013533 gives me production order wise cost but not the actual cost of material (raw mat/ consumables) consumed in production.

S_ALR_87013542 can not see (raw mat/ consumables)  cost by material consumed in production.

CJI3 report is useful which i have already considered as option however for my project CN41N report is the main report and i have a requirement if i can bring those details in CN41N.

Thanks for all the help.

Ashish

[Former Member]

Hi Experts,

Kindly suggest what is required to be done as this issue is not resolved yet.

Thanks a ton in advance

Ashish

[Former Member]

Hi All,

Kindly suggest if i am missing any config. I have checked this report many times and it does not reflect the details of plan & actual cost for each items but only lump sum.

Early response will be highly appreciated..

Thanks

Ashish

[former_member195427]

Hi Ashish,

I would like to invite Former Member ,

and to share their views on it.

Regards

Saurabh

[former_member195427]

Hi Ashish,

I doubt whether Item level reporting  in S_ALR... (hierarchy report) is possible or not because I haven't seen item level cost in them only the lump-sum cost because they are summarized at cost object level itself. Navigation path are there which we use to go into details of cost.

Please check the following links:

https://scn.sap.com/thread/1743833

(In the above thread,focus on  Mr. Mohamed Rafi comment.)

http://scn.sap.com/thread/3530080

http://scn.sap.com/thread/1311820

Display of plan cost., CN41N | ABAP, SAP, benX AG,&...

Just an additional pointer ,have a look on your costing variant and variation variant settings for material section.

Regards

Saurabh