Skip to Content
0

Why are recorded 128 entries for only one document in FQM_FLOW table?

Feb 28, 2017 at 03:25 PM

129

avatar image

Hi experts,

We are working on the New SAP Cash Management (SAP S/4HANA 1610) configuration and we realise that the table FQM_FLOW that is feeded from the operational data and is relevant for cash and liquidity reports is not correct.

The detected error is that when the table FQM_FLOW is updated with new records, these records are duplicated and the values for some items are multiplicated by 6. This error have as consecuence that all the cash management reporting (Fiori app reporting) values are incorrect.

For example:

It has been posted a Customer Invoice:

It’s executed table FQM_FLOW by filtering with parameter Invoice document: 1800000097

128 records have been entered in FQM_FLOW table:

The data for each line is related to the same Item ¨1¨, the invoice is recorded 128 times, but each line is created with a different source ID per line.

As addittional, from the Source Flow ID 001-81 to 001-96 the value of the Invoice 8000 EUR is multiplied by 6 = 48,000 EUR and is generated in negative balance.

So when the we execute for example Forecast reports are executed the value that is displayed for the customer invoice 1800000097 is the difference of the debit and credit balances from FQM_FLOW table.

FQM_FLOW table balance:

This error is detected especially for FI operations from source application ¨BSEGV-Partner for Financial Operations

Has the same thing happened to someone?

Someone have an idea of what could be incorrect when the data is saving in FQM_FLOW table?

Thanks in advance for your support!!!!

picture.jpg (67.5 kB)
picture.jpg (67.9 kB)
picture.jpg (526.7 kB)
picture.jpg (518.9 kB)
picture.jpg (498.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers