Liquidity Forecast (tables FDSB, FDS2, FDM1)
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.
Thank you very much