topic Re: Electronic Bank Statement Upload using Tcode FF_5 in Application Development and Automation Discussions

Electronic Bank Statement Upload using Tcode FF_5

Former Member — Fri, 30 Oct 2009 15:07:53 GMT

Hi All,

I am using FF_5 transaction code to upload electronic bank statements.

I am using the below selection criteria:

Elect. bank statement format: BAI Format

Imported the file from Presentation sever.

While uploading I am getting below error:

Acct 4121747943: Statement 00001 already exists. entry ignored

When I debug the issue I found the below:

1) Program gets data from table FBEKO. Sorts it by descending AZDAT (Satement date).

Now program reads the first record data from the internal table of FBEKO.

If the table has records like:

statement date: statement Number

01/10/2009 0001

01/09/2009 0002

now the program reads the first records that is:

01/10/2009 0001

And increases the statement number by 1. It would be now 0002.

Now it tries to insert the records, where it finds the already exists.

Thats the reason it is giving error.

So I removed the data using the program RFEBKA96 .

Now I have changed the date in the file 01/10/2009. (File has more than one entry. All the entries have the same date).

For the first records it did not give any error. But for the next records it is giving the same error.

Could you please help me how to updload?

Thanks and Regards,

Shravan G.

Re: Electronic Bank Statement Upload using Tcode FF_5

mvoros — Mon, 02 Nov 2009 01:01:40 GMT

Hi,

each statement should have unique identifier to avoid multiple uploads. Your statements have been already uploaded to SAP therefore you get error Statement 00001 already exists. entry ignored. So the problem is in your data. Every statement needs to have an unique number.

Cheers

Re: Electronic Bank Statement Upload using Tcode FF_5

Former Member — Wed, 04 Nov 2009 14:16:38 GMT

Statement number is generating in SAP, I am not giving statement number in the file.

So here when I upload I am getting this error.

Re: Electronic Bank Statement Upload using Tcode FF_5

Former Member — Sat, 07 Nov 2009 18:39:16 GMT

This issue is solved by raising OSS notes

Re: Electronic Bank Statement Upload using Tcode FF_5

Former Member — Mon, 09 Nov 2009 13:25:59 GMT

This problem has been solved by raising OSS

Re: Electronic Bank Statement Upload using Tcode FF_5

Former Member — Wed, 27 Oct 2010 15:02:39 GMT

Hello Shravan, can you please provide the oss note for this issue.

Thanks

Re: Electronic Bank Statement Upload using Tcode FF_5

Former Member — Wed, 21 Aug 2013 22:02:23 GMT

What was the note number?