SAP Central Finance – EC-PCA Postings (load & replication)
SAP Central Finance replicates EC-PCA postings from source system to Central system as FI postings. Below postings are replicated. this is applicable for Classic GL systems
- EC-PCA manual posting: 9KE0, 1KEL
- Periodic posting for allocation: 3KE5, 4KE5
Initial Load transfers the following and it can be executed once per company code:
- PCA balances posted prior to the start period of ongoing replication that you defined in the activity Define Start of Transfer of EC-PCA Postings.
- PCA documents which are posted for periods from the start period of ongoing replication to the activation timestamp that you defined in the activity Activate Transfer of EC-PCA Postings.
Execute transaction – FINS_CFIN_PCA_LOAD in central system.
- When this is done the initial load program (transaction: FINS_CFIN_PCA_LOAD) in the Central Finance system, a timestamp of the current time is written into the Central Finance generic settings table (CFIN_CTRL). Meanwhile, the source system is triggered to write EC-PCA documents and balances into the Central Finance tables (CFIN_ACCHD, CFIN_ACCIT, CFIN_ACCCR).
- The changes in the Central Finance tables further trigger the SLT transfer. In this way, the EC-PCA data is transferred from source systems to the Central Finance system using SLT.
- The transferred EC-PCA data in the Central Finance system is posted after business mapping and AIF checks have been carried out.
(source – sap.com)
Once a company code is activated for EC-PCA ongoing replication, the corresponding EC-PCA postings will be continuously replicated from the source system to the Central Finance system automatically.
- EC-PCA is active.
- Check the Active Indicator in transaction 0KE5 (EC-PCA: Controlling Area Settings) in source system.
- Line items and online transfer are set to active in view V_TKA00PCA (EC-PCA: Control Parameters for Actual Postings) in source system.
Settings in Source system
Settings in Central System
- Document type – This is the document type assigned to the FI posting that is created from the EC-PCA posting.
- G/L account – If a replicated EC-PCA does not balance to zero, an additional line item has to be created for the posting in the Central Finance system.
- Profit center – If a replicated EC-PCA does not balance to zero, an additional line item has to be created for the posting in the Central Finance system.
EC-PCA Simulation tool
This tool enables to simulate the process of ongoing replication and the initial load of EC-PCA internal postings before starting the actual replication. It also carries out both a data mapping check and a posting logic check, just like in real replication. No actual posting is carried out during the simulation.
- The simulation runs in the same configuration environment as the actual transfer (ongoing replication and initial load), and no extra configuration is needed.
- In the Central Finance system, a new AIF interface (PCA_DOC_SM) is used to separate the simulation results from results of the real ongoing replication and initial load. Refer note 2873997 for installation of AIF interface
The simulation tool runs in the Central Finance system. It first retrieves the data from the source system and then checks the transferred data based on the same checks as those carried out during the actual replication of EC-PCA postings. The selected data will be transferred to the Central Finance system via SLT, and you can go to AIF to check the detailed results.
Two ways of simulation are supported: general simulation and initial load simulation
- General simulation: PCA documents are retrieved from GLPCA of the source system. This simulation can be used to check the system environment before the ongoing replication.
- Initial load simulation: The system simulates the process of the initial load, and the same data as the real initial load will be handled. This simulation can only be executed after ongoing replication has been activated.
Two checks are carried out for the transferred documents in AIF:
- Check the data based on the configuration in MDG mapping and value mapping.
- Check the posting logic as in real document posting.
Transaction – FINS_CFIN_PCA_SIMU
Execute Initial Load
Transaction Code – FINS_CFIN_PCA_LOAD in central system. When this is completed the log table CFIN_CTRL will be updated with timestamp and company code
Sequence of Initial Load
EC-PCA Initial Load should be executed after all other loads like Cost Objects, Projects/WBS, Finance and Controlling loads are executed.
When the load is executed the transaction type in staging table in CO-PCA
EC-PCA Count Comparison Report
You can use this report to check whether all data has been posted successfully by comparing the quantity of source data with the data transferred to Central Finance via the ongoing replication or the initial load.
Initial Load Comparison
- The system compares the counts of PCA documents or balances you select in the source system with those successfully transferred to Central Finance via the initial load.
- You can see the fiscal year, posting period, and transfer status of specific documents but not the document number of unsuccessfully transferred documents because, for the initial load, most data comes from balances, for which no unique key can be used in the source system to identify the corresponding document in the Central Finance system.
Ongoing Replication Comparison
- The system compares the counts of selected source PCA documents with those replicated to Central Finance via ongoing replication.
- You can display the details of documents to see the fiscal year, posting period, and transfer status of specific documents as well as the document number of unsuccessfully transferred documents.
Transaction – FINS_CFIN_DFV_PCA_CN
EC-PCA Balance Comparison Report
- This report displays the debit amount, credit amount and balance in both the source system and the Central Finance system for specified G/L account, posting period and company code. You can use this report to compare the balances for selected G/L accounts in the source system with the corresponding balances in the Central Finance system.
- No currency exchange is needed for the comparison because the balances sum up the transaction amounts which are in the consistent currency between the source system and the Central Finance system.
Hope it gives some detail and help you with EC-PCA postings in your Central Finance Project
Keep learning and sharing..