Description
Delete the data which should be set up again from the Cash Managementand Forecast tables FDT1, FDSB and FDSR. Table FDT1 can be completely deleted if you run the report withoutmaking any selection options. In FDSB (bank account totals record table) and FDSR (customer andvendor totals record table), you may only delete the records which willsubsequently be set up again and not the records which result from FI,MM or SD postings, payment advices or memo records. Via the cashposition and the liquidity forecast, you can determine on what levelthe update for foreign exchange, money market and derivatives has takenplace and then delete these records. In order to do this you have towrite a small program which contains for example, the instructionDELETE FROM FDSB WHERE BUKRS = '0001' AND EBENE = 'TS' (see Note156239). When you call up the cash position/liquidity forecast, you enter agroup which contains all levels and all relevant accounts or planninggroups. (If you use the same levels for securities transactions and plannedsecurities movements, you cannot restrict deletion of tables FDSB andFDSR to securities transactions only - you delete the records for theplanned movements too. In this event, it is best if you also deletetable FDW1 in full and then access program RFFDWP00 again.) Start the program (in the background, if you have large amounts ofdata). Check the job log to see if the program was terminated. Check the spool log for possible errors. Check whether updates were terminated. If errors occurred, you have to delete the records which have alreadybeen updated from Cash Management and Forecast and then repeat the run. If no errors occurred during the run, you can check whether the datawas transferred to Cash Management and Forecast by viewing the cashposition and the liquidity forecast. |