Combine source columns as a new source column in FIM

[belgiumroland]

We have a situation where we need to import data from an accounting system into BFC and want to use FIM to do the job.

The accounting system produces a CSV file with a column containing the debit amounts and another one with the credit amounts.

We need to combine those two in a new column where those to columns are added.

Then when we map the source accounts to the destination accounts for BFC, for some accounts if the combined column amount is positive it must go to one account in BFC and if it's negative, it must go to another account.

How can we combine those two column into one so that we can then use that amount in our mapping table to direct the amount to the correct BFC acocunt?

[KatiNonhebel]

Hi,

Thank you for visiting SAP Community to get answers to your questions. I am here to help you to get the most out of it.

First of all, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members.

For example you :

• Can outline what steps you took to find answers (and why they weren't helpful)
• Can share screenshots of what you've seen/done
• Can use a descriptive subject line
• Should also make sure you're using all the appropriate tags, so the right experts can find your question

The more details you provide, the more likely it is that members will be able to assist you.

Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question -- but if that happens, you can leave more details in a comment).

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Good Luck

Kati - SAP Community Moderator

[belgiumroland]

Thanks Marc,

I was hoping that could be done in FIM.

Data Services it is going to be then.

This would give us a better solution in the end as we will have 3 input files for 3 companies. Data Services will allow us to combine all 3 files in one before importing to BFC reducing the steps our users will have to perform to get their data in BFC.

[phadke_manas]

Hi Roland,

Is the accounting system from which the csv file is generated, a non-SAP system? Otherwise you could have created a custom datasource in the ECC system which combined the debit and credit amount columns into one column. FIM can load data from this custom ECC datasource and then map the source accounts to the target BFC accounts depending on the sign (+ve or -ve).

Regards,

Manas

[Marc_Kuipers]

Hello Roland,

I am not sure this can be done in FIM, The solution may be to customize this job and use some of the Data Services functionality (e.g Transformations) to make this work

Marc