Automating FF_5 to run at background

[Former Member]

Hi Experts ,

Every day we recieve a statement file and a line item file from our bank .

One of our staff from shared service banking manually saves the files on desktop and then links them to FF_5 to upload .

However business has a requirement to automate the process with bank sending the file to AL11 folder and FF_5 picking it up from there .

Want to know if that is possible .

Kind Regards

Anirban

[former_member194797 · Accepted solution]

Hi,

we are doing the same with MT940 format.

If you are able to save the file in the applicatiion server filesystem, the job may run in background:

use program RFEBKA00;

parameters:

in file specification: "Workstation upload" uncchecked

in Output controls: "Execute as background job" checked.

The job with containing program RFEBKA00 ends quickly and another job called "RFEBKA00-EXTRAIT ELECTR" in french, is automaticaly launched. In english I suppose the job is called "RFEBKA00-EL BANK STATEMENT"                .

[Former Member · Accepted solution]

Hello,

i have to run the transaction FF_5 in background but the "statement file" name is always changing, is there a way to have a dynamic variable of the statement file depending on the date of the uploaded file instead of a fix name? and if it is possible how to do it?

Thanks

[former_member194797 · Accepted solution]

Hi Hassan,

this thread was closed. You opened another thread and it's a good idea ! I answered in this other thread.

Henri

[Former Member · Accepted solution]

Hi Henri,

It sounds like the process you explained a user runs tcode ff_5 and then selects "Execute as background job"? Or do you have a daily job that runs and picks up the file to be processed?

The reason I ask is we are automating this process and need to determine if 1) a daily batch job should pick up the file from chase and run daily, or 2) if a user should login and execute ff_5 and upload daily.

If your process follows number 1 above, is your file just named the same each time so the variant can pick it up?

Thanks,

Daniel

[Former Member]

Hi Henri,

I read your responses that you give Anirban.

I´m starting to set up automatic FF.5 but the problem is that we will receive more than 100 files per day (different banks accounts)

To upload the file I´m working with an ABAP. But I don´t know how to treat the error cases. How we can get a log or how we can identify when a file was processed with error?

Thank you so much for your help

Martin

[former_member194797]

Hi Martin,

in the first step of my process, I'm checking the files for the common errors: duplicate statements, unknown bank accounts, etc. When a file seems ok, it is concatenated to the workfile and the original file is renamed (.OLD). So after the process if I have error messages I check them:

- new bank accounts are customized in the system, and there is a rerun

- duplicate files are rejected...

I have currently no time for giving more details.

best regards,

Henri

[Former Member]

Hi Henri,

Thanks for your quickly response!

Maybe I don´t correctly expressed. When I said that I don´t know how to treat I mean that:  How can I get logs of each file that was processed with error. How can I get that log? Because I only see on Spool but do you must know that I will have more than 100 files per day and I need a fast way to know what files ended with error

Thank you so much for your help

Martin

[former_member194797]

Hi Anirban,

did you try my solution ? please give some feedback.

[Former Member]

Hi Henri ,

I will try your and Araiz solution both . However I am waiting from change manager approval . Thanks a lot for your inputs though .

Kind Regards

Anirban

[Former Member]

Hi Henri ,

I will try your and Araiz solution both . However I am waiting from change manager approval . Thanks a lot for your inputs though .

Kind Regards

Anirban

[former_member436737]

Dear Anirban,

In this case you should proceed as follows in transaction FF_5:

1) deselect the checkbox 'Workstation upload' and

2) enter correct path in the field 'Statement File'.

3) Select execute as background job

If you want to run the program in background you must provide a path

from the application server, where the program can take the file and

upload the data to populate the internal tables and fields.

You can schedule the program RFEBKA00 as job using transaction SM36, as

a periodic job.

Check if this works in your case:

Create a job (i.e RFEBKA00_SAP_TEST) for the program RFEBKA00

with a variant X. This job should trigger the following one:

Create a new job (i.e. RFEBKA00_SAP_TEST2) for the program RFEBBU00 to carry out the postings.

Hope this helps,

Best regards,

AZ

[Former Member]

Hi,

I have an doubt here. When we are uploading bank statement to SAP System. Here any entries will be generated or not. If generated, tell me the entry also.

Thanks,

venkat

[former_member193513]

Hi venkat

When we upload the bank statement file entries will get posted

say for example when customer is cleared u ll pass the entry as bank( inflow)debit and customer account credit

when you upload statement the bank account will get debited and  bank (inflow) sub account will get credited

Regards

Prasad