How to find the total value of PR?

[suresh_subramanian2]

Dear All,

I want to find the total value of PR(Purchase requisition) by plant wise.

The PRs created will have single line item or multiple line items.There is no specific field for net value of PR.

Though it is known that quantity should be multiplied with price by line item and the total must be summed up to get the total PR value,but how to figure out the total number of line items in PR ?

Is there any programmatic logic that can be made or any other means to find the the total value of PR?

Please suggest me for further proceedings for which I will be grateful.

Thanks and regards,

S.Suresh

[vijy_mukunthan · Accepted solution]

Hi Suresh

There is no way u can get the total directly. But need to write the logic inside the method and calculate the total of line items using the following FM's

BAPI_REQUISITION_GETITEMS

BAPI_REQUISITION_GETDETAIL

BAPI_PR_GETDETAIL

Try these FM and check the line items and write your own logic inside your method.

Regards

vijay

[suresh_subramanian2 · Accepted solution]

Dear Vijay,

Thanks for your reply.

The first and third function module fetches the line item price and quantity.

Thanks and regards,

S.Suresh