Clarification on DIP PRofile

[govind_tkrishnakumar]

Hi Experts,

We are trying to build a billing model as follows...pls let us know why we are getting this "No expenditure item error"

Objective  - the aim of the billing model is read actual costs that are posted to a WBS element in SAP FI through a GL account (that have corresponding cost elements mapped to it) and then create a DMR using DIP and Resource related billing.

Steps carried out

1)      created a DIP profile for Billing and Results Analysis and assigned a DMR type to it.

2)      Selected characteristics with the following items:

a)      Cost element

b)      Object number

c)       Period(SAP default)

d)      Transaction currency(SAP default)

e)      Unit of Measure (SAP default)

3)      Cost element is marked for material determination also.

4)      Set the source for cost as  - Actual cost line items

5)      Set the source for cost criteria with Cost element and maintained a SET for it.

6)      A single material called “SERVICE” was entered in the material determination window.

7)      Criteria for material determination was set based on Cost element and specified a SET there.

😎      Created a sales order and assigned the project to it under Account assignment.

9)      Actual costs are posted to the WBS element using direct FI entries in FB01. Cost GL accounts are used to pass the entry and they are all mapped to a cost element also.

The issue

When doing DP91 with the sales order number belonging to the project, system says   - “No Expenditure items found”. But I can see that there are actual costs posted to the GL and cost element for the project code (WBS element) and the entries are available in tables COBK and COEP with the CO document number.

The cost data also gets displayed in CJ74 – Project actual costs transaction.

So, what is missing here and why the system is not able to read the costs which really exist? Doesn’t the DIP profile and RRB functions in SAP support this model?

Thanks

Govind

[Former Member · Accepted solution]

Might be a silly question but i need to ask it. Have you assigned the DIP profile? If yes, where have you assigned it? To the sales order or in the project?

[govind_tkrishnakumar · Accepted solution]

Hi Gokul,

Thanks for your reply. Yes we have assigned to the sales order item.

Let us know if you have any suggestions.

Thanks

Govind

[Former Member · Accepted solution]

Hi Govind

you have to assign DIP to sales order item in Sales B tab as well as to project Profile in sales Pricing

check and revert back please

[govind_tkrishnakumar · Accepted solution]

Hi Vijay,

Thank you for the reply. The DIP we have created is not available for selection only under the Project tab. Kindly let us know what we have missed here.

Regards

Govind

[Former Member · Accepted solution]

Hi Govind Krishna

You have to Maintain DIP Profile in Project Profile  under Control Tab under Sales Pricing Subtab

hope this would answer your question

Please Check  and Revert Back

[MohanDesai]

Hi Govind,

Check whether Condition type EK01 is assigned or not in Pricing Condition. This will help in picking up the Actual Cost related to Project. Book some expense against WBS and then check Dp91 it should work.

Regards,

MRD