Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Liquidity Forecast (tables FDSB, FDS2, FDM1)

Hi Gurus,

I have a question re: these tables.

I understand that all SD data (sales order is created) are populated in FDS1/FDS2 tables, and MM data (purchase order is created) are populated in FDM1 table.

My question is, if an invoice is already created for the SD or for the MM document, the amount of the invoice would be then populated in the FDSB/FDSR table. correct?

If this is the case, does this mean that there would be duplicates in the SD/MM (FDS2/FDM1) table and the FI table (FDSB)? If this is the case, then how would I be able to get an accurate forecast if both amounts (e.g. Sales Order and Invoice) will appear in both tables (FDS2 and FDSB)? As per client requirement, I have to take into consideration all SD and MM and FI documents in the generation of the report.

Kindly advise.

Thank you very much

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question