I’ll discuss the actions and procedures necessary to erase the Initial Load in this blog post. Amazed as to why deletion? Avoid becoming. We could need to have a requirement to delete Initial load during test phases, which is a fairly regular practise. What happens if some procedures for improvements that were meant to work well under initial load fail during testing? You will respond that while not always, those can be tested during near-time replication.
Although they have the same goal—pulling data from the source and putting it in S/4HANA—technically, initial load and real-time replication operate quite differently in Central Finance. As a result, anything related to initial load needs to be evaluated during initial load runs.
Therefore, you have TWO alternatives if something goes wrong with the initial load or the test findings are unsuccessful:
- Refreshing your test system will clean the client.
- Delete the submitted data and the initial load
Option one is simple, but it needs assistance from the support team and might also require some expense and additional effort. Option two only involves the functional team, and they can remove the initial load. So what are the procedures and needs:
The Central Finance System’s Activities
Load deletion of FI documents
Select Delete Initial Load Data under CFINIMG.
Alternatively, launch the RFINS CFIN CLEAR INIT LOAD programme in SE38.
You can initiate the deletion of first load data in this section. This data was generated during the initial load’s posting process.
- If you just wish to erase this data for a specific initial load group or for a different logical system and business code, choose delete.
- If you want to remove all data that has already been created during the posting step of the first load for all logical system and company code combinations or initial load groups, choose Delete All.
- Don’t forget to look at the tables below:
- Table of transfers – CFIN ACCHD
- Line Item Transfer Table – CFIN ACCIT
This will remove the FI Initial Load, but what about the partial postings that have already been completed and posted in table ACDOCA? You must delete those, of course, since you intend to run the initial load in its entirety again, and if the duplicate postings are still present in the database.
Using the transaction FINS CFIN DOC DELETE, you can delete any submitted documents (Central Finance: Deletion of FI Documents).
Deletion CO Documents Load
Reset CO Initial Load using this transaction: FINS CFIN CO DOCS IL RESET.
The Central Finance system needs to erase any documents that have previously been submitted.
Use this transaction to remove the already-posted CO documents – FINS CFIN CO DOC DEL – CO
Cost of deleting an object load
To remove the AUFK load and produced data, take the procedures following.
- CFIN CO MAPPING DEL – Remove CO orders from database AUFK OK05 and Internal Orders from table AUFK OK
- Reset order number ranges using KONK
- Reset number ranges for CO papers with KANK
The AIF communications that are still being processed and the AIF logs need to be removed after this process.
/n/AIF/PERS DEL transaction
Select a timeframe and message status, as well as an interface. Any status of an AIF message may be deleted with this transaction. Delete all AIF Messages in a certain interface to perform a full reset. Running the report in the background is advised, depending on how many messages are intended to be erased.
The S/4HANA Central Finance system will be cleaned up as a result of all these actions. You still have to remove the logs from the source system, therefore the work is not finished. The new initial load won’t begin if those aren’t deleted because the log table already contains data.
It is necessary to remove the entry from Program – RCFIN DEL MIG. Make sure you delete the correct entry because it contains all the entries you might not want to remove (other initial loads)
If RFC connections are properly configured using Transaction – FINS CFIN DEL SRC, this activity can also be carried out from S/4HANA systems.
After finishing all of these tasks, you should consider the cause of the first load deletion. It could be incorrect data, a problem with custom objects, or something else based on the design.
When you are prepared again, you can begin the initial load using the same procedure, order, and procedures as you did the last time.
Cheers to reading!