0FC_BP_ITEMS - Open and clear item in BW

[abhimanyu_sharma]

I have implemented 0fc_bp_items in BW and storing the data in SAP standard DSO 0FC_DS05 (contains both open and clear items ) and 0FC_DS06 ( Stores open Items ) and 0FC_DS07 (Stores Clear items).

I would just like to know the scenario where a document number is open today and clear on the same day. How it will show in the reporting side?

I have created one Open item report( on posting date) on 0FC_DS06 and one clear item report (on clear Date) on on 0FC_DS07.

For example: If a document 100 is posted today with open amount as 100 pounds. So, the DSO 0FC_DS06 will have that entry. and the document closes at the same day, the clear dso 0FC_DS07 will have 100 pounds with clearing date. In that case my open Bex report should show 0 for the document 100

Please let me know how this scenario works here.

[former_member594685]

You can build a report on top of 0FC_DS05 which contains both open and cleared items.

You can use formula variable to convert open and close dates into key-figures. Then you can do the subtraction of these variables. (Closing date - Open date).

This will give you the number of days between opening date and closing date.

I hope I understood your question correct and my answer will help you.