Skip to Content

Combine source columns as a new source column in FIM

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?

Add a comment
10|10000 characters needed characters exceeded

  • 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

Related questions

3 Answers

  • Posted on Jul 24, 2020 at 02:43 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 24, 2020 at 12:48 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 07, 2020 at 12:46 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.