Electronic bank statement

[Former Member]

Hi Experts,

In a scenario where the periodic statement from bank is not in any established formats like swift etc, how can it be modified to be uploadable in FF_5 ?. The statements are downloaded from bank portal in text or excel formats and now needs to be in an electronic bank statement format. Please provide your valuable suggestions

Thanks

Andy

[Former Member · Accepted solution]

Hi,

Try converting to Multi cash format using FEBC. There are standard formats. If your format does not come under these also, then the system will not accept your input file. The system does not support other formats.

May be you have to contact the bank or SAP for your own formats.

Regards,

Ravi

[Former Member · Accepted solution]

Hi Ravi,

Thanks for your post. As you mentioned FEBC works only with some pre-established formats. I guess the only open option is to use DMEE. Can somebody give some inputs as to how to make the statement recognisable by SAP using DMEE ??

Thanks,

Andy

[Former Member · Accepted solution]

Hello Andy,

I would suggest to create multicash conversion from your statemenets using note 36833(which can then be used via FF.5 later) or use manual bank statement entry using transaction FF67. There is no other way.

Best Regards

Ramesh

[shony_champakara · Accepted solution]

Hi Andy,

In DMEE for the tree type MCSH create a tree by copying SAP_EXAMPLE. This you should modify to map your file header and transaction info. Or alternatively you could do programming to convert the file to MULTICASH format. Then you could directly upload without any conversion in SAP.

Shony

[Former Member · Accepted solution]

Thanks Shony. That was very helpful.

I am now trying to buid up the tree . When I upload a file ,how system identify header and transactions ?. I tried with Assignmen t Rules in the root node. But this is also read as a field. So instead of output of a header and another transaction file ,all the records are read as header ( or transaction ..i don't know).

Please give your valuable suggestions.

Thanks,

Andy