Hi Experts,
For the document number 2675862 ( Partial clearing document) , we are getting revenue as -175.53 (GL Account – 530060) and Vat as -30.80 ( for GL Account – 264070 ) in BEX report.
But when checked in table DFKKOPK , revenue is -87.77 and Vat is -15.40. The amount is getting doubled in BEx.
The reason for this :
From data source ( 0FC_BP_ITEMS) we are getting 2 records with same document number and contract account but different sub-line items ( OPUPZ). So when it is showing up the Bex, the amount gets doubled because we are looking up on DFKKOPK only based on OPBEL. Hence, in cube both the records are showing up same values in Revenue and VAT.
Is there any way we can fix this?
DFKKOPK

DFKKOP:

Cube and BEx data :
