FF_5 Automation

[former_member705000]

Hi Expert,

I need some support in automating back statement upload through batch job. daily we receive multiple bank statement to upload in SAP, one of our user manually upload all the statement in morning. The challenge I am facing here is bank statement have date in there description so how can we make sap select each file & another thing is once the file if process it needs to move to archive folder. Do I need to take help of ABAPER in order to achieve both?

[cirlei_gv]

Hi,

For automatization you need BCM

The Bank Communication Management ES bundle provides enhanced straight-through processing of payments, which means that no manual intervention is needed to process payments using this system-all communication occurs on an application-to-application basis once the process is initiated in SAP Bank Communication Management.

Please, for more info see above

https://blogs.sap.com/2020/09/24/sap-end-to-end-payment-monitoring-on-bank-monitor-in-bcm/

https://wiki.scn.sap.com/wiki/display/ESpackages/Bank+Communication+Management

[bjansen]

From ERP enhancementpack 6 there is a businessfunction FIN_BL_EB_1.  This enables the "new" FEBAN layout as well as automatic import of bankstatements (make them available in AL11 with SFTP).

FEB_FILE_HANDLING is also included, you can configure the automatic import with this process:

https://help.sap.com/docs/SAP_ERP/6211bf1accac4f2e813e7f8e5fc19e99/1e44639767de4d13b6a28004e26c1efd....

[former_member773059]

Hi Ratheesh M. Y

can you elaborate what is required configuration in step no.4

Thanks

Venkatesh

[former_member618944]

Hi Gaurav,

For automation of above scenario the below steps would be helpful:

1. Ensure that the bank statement file to be uploaded through FF_5 is received on SAP system in AL11 path

2. Maintain the required EBS configuration and if required setup the On Account posting as well

3. Schedule a batch job which would check every few hours or depending on the frequency in which the bank statement file is received that, if the new bank statement file has been received in the specific AL11 path. If yes the batch job should use the bank statement file at AL11 to be processed through FF_5 and uploaded into the system.

If no, there is no upload that happens.

4. If the bank statement file is processed in AL11 path then maintain the required configuration such that post processing through FF_5 the bank statement file is moved to archive folder

Thanks and Regards,

Ratheesh M. Y.

[former_member618944]

Hi Gaurav,

If the above solution resolved the query or issue, do confirm on the same.

Thanks and Regards,

Ratheesh M. Y.

[DimasDaniel_GonzlezParra]

Es decir que debo hace un ampliaciòn despues del programa RFEBKA00(FF_5) para que con el modulo de funciones y una logica sobre tablas FEBEP y FEBKO me indique si el extracto se proceso y descargue los archivos en una carpeta de procesado o si da error en errores con siglas _p o _E?

[DimasDaniel_GonzlezParra]

Realizo un JOBS para cargar un extracto y me da error no se puede cargar el fichero, genero la misma variante manual me da los mensajes normales, y si los carga y contabiliza como hago para que se ejecute de forma correcta por JOBS?

[DimasDaniel_GonzlezParra]

Una consulta a que se refieren a trabajo por Lote? Ok Bath Imput

[DimasDaniel_GonzlezParra]

I have created JOBS to load from a multicash file and I get an error saying that batch input cannot be executed. What would be the parameters to load or steps to process from AL11, since the FM are UPLOAD and DOWNLOAD?