Skip to Content
avatar image
Former Member

Switching of account based on source value

Hi,

I am trying to load data to SAP BPC using a CSV file and want to map a source account to BPC account based on the source value.

For example :

If amount of Account1 in csv file is +ve it should be mapped to AccountA in BPC

If amount of Account1 in csv file is -ve it should be mapped to AccountB in BPC.

Can anyone help to achieve this?

Thanks in advance.

Regards,

Krishnan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 11, 2017 at 05:44 AM

    Just read my answer here: https://answers.sap.com/questions/240890/bpc-101-loading-transaction-data-into-different-ac.html

    Another option is to process text file using VBA.

    Add comment
    10|10000 characters needed characters exceeded