In this blog we will talk about how Third Party/Non-SAP systems can be integrated with SAP Central Finance.
As background of the topic it is known that Central Finance has the capability of Integrating SAP as well as Non-SAP (aka third party) systems which are transactional in nature and accounting documents from all systems can be replicated to SAP S/4HANA Central Finance.
For Integration of SAP ECC to S/4HANA Central Finance there is lot of content and expertise available however it is important to understand how Third Party systems can be integrated.
Due to legal restrictions SAP can not get into the database of any third party system. Extracting the data from third party system has to be the part of customer project. Once the data is extracted that needs to be loaded to the staging tables in SAP SLT to load and replicate data from a third-party system to a Central Finance system and then it can be sent to S/4HANA Target system.
SAP provides preconfigured content that loads the data from a simplified staging area. You use the staging area to connect various legacy systems that have different data models than a Central Finance system. Now let’s understand how to get those staging tables created. Also make a note that new Mass transfer ID is needed in SAL SLT for each system.
Create Program and Execute the program to generate the following database tables:
/1LT/CF_E_HEADER – document header table
/1LT/CF_E_ACCT - accounting items
/1LT/CF_E_DEBIT - debtor items
/1LT/CF_E_CREDIT - creditor items
/1LT/CF_E_PRDTAX - product tax items
/1LT/CF_E_WHTAX - withholding tax items
/1LT/CF_E_EXTENT - customer extension on header level
/1LT/CF_E_EXT_IT - customer extension on item level
Do these setting in the system
Create Predefined Load Object
Source Object: Project REPL_CFIN
Subproject REPL_CFIN_ST
Predefined Object CFIST_ACDOC_L
Target Object - Table Name: /1LT/CF_E_HEADER
Create Predefined Replication Object
Source Object: Project REPL_CFIN
Subproject REPL_CFIN_ST
Predefined Object CFIST_ACDOC_R
Target Object - Table Name: /1LT/CF_E_HEADER
To check FI documents posted from a third-party system to a Central Finance system, you can use the following reports:
Please read this SAP note carefully - 2610660 - SAP LT Replication Server for Central Finance - Third-Party System Integration 1709, FPS 2
As background of the topic it is known that Central Finance has the capability of Integrating SAP as well as Non-SAP (aka third party) systems which are transactional in nature and accounting documents from all systems can be replicated to SAP S/4HANA Central Finance.
For Integration of SAP ECC to S/4HANA Central Finance there is lot of content and expertise available however it is important to understand how Third Party systems can be integrated.
Due to legal restrictions SAP can not get into the database of any third party system. Extracting the data from third party system has to be the part of customer project. Once the data is extracted that needs to be loaded to the staging tables in SAP SLT to load and replicate data from a third-party system to a Central Finance system and then it can be sent to S/4HANA Target system.
SAP provides preconfigured content that loads the data from a simplified staging area. You use the staging area to connect various legacy systems that have different data models than a Central Finance system. Now let’s understand how to get those staging tables created. Also make a note that new Mass transfer ID is needed in SAL SLT for each system.
Create Program and Execute the program to generate the following database tables:
/1LT/CF_E_HEADER – document header table
/1LT/CF_E_ACCT - accounting items
/1LT/CF_E_DEBIT - debtor items
/1LT/CF_E_CREDIT - creditor items
/1LT/CF_E_PRDTAX - product tax items
/1LT/CF_E_WHTAX - withholding tax items
/1LT/CF_E_EXTENT - customer extension on header level
/1LT/CF_E_EXT_IT - customer extension on item level
Do these setting in the system
Create Predefined Load Object
Source Object: Project REPL_CFIN
Subproject REPL_CFIN_ST
Predefined Object CFIST_ACDOC_L
Target Object - Table Name: /1LT/CF_E_HEADER
Create Predefined Replication Object
Source Object: Project REPL_CFIN
Subproject REPL_CFIN_ST
Predefined Object CFIST_ACDOC_R
Target Object - Table Name: /1LT/CF_E_HEADER
To check FI documents posted from a third-party system to a Central Finance system, you can use the following reports:
- Comparison of FI Document Headers (transaction FINS_CFIN_DFV_FI_NUM)
- Comparison of FI Line Items (transaction FINS_CFIN_DFV_FI_DOC)
Please read this SAP note carefully - 2610660 - SAP LT Replication Server for Central Finance - Third-Party System Integration 1709, FPS 2
- SAP Managed Tags:
9 Comments
