Skip to Content
0

Switching of account based on source value

Jul 11, 2017 at 02:08 AM

26

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Jul 11, 2017 at 05:44 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded