How to add material no and vendor no details in Project Actual cost report

[Former Member]

Hi experts,

Please advise. I want develop a report same in bq/bi as CJI3 report, But I have to add material no. and vendor no. details. I have check PS datasources but requirement is not matching with existing objects. I am having BE 3.5 version.

Please advise

Thank you

[former_member202718]

Hi Taniya,

You to have to enhance the DS in ECC and replicate the DS in BW.

Write the logic to populate the required Objects in CMOD...check with the PS Functional Consultant for the Logic and Tables for LookUp.

rgds

SVU

[Former Member]

Thank you SVU.

I am using 0CO_OM_NWA2. datasource for creating report. Haing fields

1.Project Defination.

2.Costelement

3.Material

4.Vendor

5.WBS Element

6.Job No.

7.Business Transaction.

8.Controlling Area.

9. Network Activity

With above fields I have to display Actual cost & Quantity for each project.

please advice.

[Former Member]

The problem is that the 0CO_OM_NWA2 only shows "balance" values.

You need to créate a huge enhance DS to do that, get from some table the documetn detail, go to BSEG or FAGLFLEXA table to get the material/vendor detail, etc etc.

Maybe is easier to take the 0FI_GL_14 and take only the document types/cost objects related to PS movements.

Regards!