0FC_BP_ITEMS open Item issue

[abhimanyu_sharma]

I have implemented the 0FC_BP_ITEMS in BW and storing open and clear Item in two different DSOs. Now i am facing issue in computing Open Item in BEx.

I have document number in DFKKOP table which is cleared on 25th April, 2018.

The same is not being captured in Open Item DSO as it is already been cleared and loaded to Clear DSO. How would I load the document in Open Item ?

Now, while running the report , we are getting mismatch in data. If I run the report till 22.12.2016, I am not getting this record as it is not present in Open Item Cube.

Ideally it should show in open Item.

Could you please help in this and how can i capture this record in Open Item DSO to get correct results ?

[john_hawk]

Hi There,

Consider taking a new approach.

Put both Open and Cleared DSO into a MutiProvider or Composite InfoProvider with a query with "Closed Amount" and "Open Amount".

Place a condition of the query results showing only those records with "Open Amount" > "Closed Amount".

Good luck!

John Hawk