Replicating from third party system to SAP Central Finance

[nitin_gupta10]

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:

• 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

[former_member604608]

thanks for this post

[nitin_gupta10]

Appreciate

 

[former_member606203]

Hello,

we want to connect an Oracle database to the SLT, with a new MassID we choose "DB Connection" as source. Unfortunately the option "Create predefined Objects" is missing afterwards. We have observed notes 2610660, 2481900 and 2154420.

Many greetings
Mr. Baxxter

[former_member609756]

Hi Nitin,

Can we load data from SAP DS (BODS) directly into the staging table (/1LT/CF_E_HEADER, /1LT/CF_E_ACCT  etc.) of SLT?

If yes can you please give me some idea and if not how can we possibly add data into staging table if we have non-sap system as our source.

Can you help me on this asap.

Thanks in advance !!

[sriram_korlepara]

Hi Chaitanya Singh,

 

It would be great if you can let us know  the solution you got for your above mentioned problem?

 

Thanks

[former_member664961]

Managing third party replication is complex as we need to change the data objects. Once it reach SLT its easy and simple.

[sanjaysota]

One of Client use a number of billing systems in combination with core SAP.  They will often post batch transactions on aggregate into SAP, and so the underlying transactional information is only stored in these billing systems.  Someone raised the question on our call as to whether it’s possible for SAP DCR to be integrated with other third party systems, or can it only pull information together that is stored in SAP

Appreciate your early reply

[former_member789843]

Hi Nitin,

Very useful information as always.

I have one dought. You said that -

To check FI documents posted from a third-party system to  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)

As per my knowledge these reports uses a source RFC connection to compare the data from cfin to source system using RFC connection. If the source system is non sap then how does this work?

 

[abhishek_singh1404_195]

Hi Andrew,

Please refer SAP note 2932517.

Comparison reports (transaction FINS_CFIN_DFV_FI_NUM and FINS_CFIN_DFV_FI_DOC) are available starting from SAP S/4HANA 1709.

For non-SAP sources,  these reports only compare the external specific SAP AIF tables and the Central Finance data, with no connection to the third-party source system or the SLT system for comparison.

The following SAP AIF tables are compared with BKPF/ACDOCA:

• CFIN_EX_AIFROOT


• /AIF/STD_IDX_TBL


• CFIN_EX_AIFACCTI


• CFIN_EX_AIF_IDX