ACH File Creation

[Former Member]

Hi SAP Experts,

I am trying to create a ACH -Nacha file for bank. Format of the file is like as below

Header record

batch header

   detail record

  batch control record

header control record

If any one implement for the US banks for ACH file, please suggest me. I know there is Rffous_T program but don't know where to give header and batch information with various specification given from the bank.

Thanks

Tangudu Ravi

[former_member219942 · Accepted solution]

Hi Ravi,

For ACH you need to perform couple of steps:

1. 1.     Assign “RFFOUS_T” program in FBZP under Payment Methods in Country Tab for ACH relevant payment method   (APXY).

1. 2.     Create ACH Variant in OBPM4

               SPRO-- SAP Customizing impl Guide-- Financial Accounting ( New) -- Accounts Receivable and Accounts Payable-- Business                                    Transactions- - Outgoing Payments -- Automatic outgoing Payments-- Payment Media --Make settings for Payment Medium Formats from                  Payment Medium Workbench -- Create and Assign Selection Variant)

1. 3.     If you are looking for customize 7th Record then Implement USER Exit “RFFOX104”

               And in F110 variant select Additional record check box.

1. 4.     Assign company number in house bank configuration.

• If you don't want 7th customize record then you can use CCD and PPD payment method  format, instead of RFFOUS_T program in FBZP you need to Assign Format as ACH and Format Supplement as CCD and PPD.

• In this case you need to configure(SPRO--SAP Customizing impl Guide-- Financial Accounting ( New) -- Accounts Receivable and Accounts Payable-- Business Transactions-- Outgoing Payments -- Automatic outgoing Payments-- Payment Media --Make settings for Payment Medium Formats from Payment Medium Workbench -- Create and Assign Selection Variant) OBPM1, OBPM2, OBPM3 and OBPM4. No Need to change any configuration in OBPM1, OBPM2, OBPM3, just need to assign ACH Batch Header and company identification as company number(Whatever you assigned in House bank configuration)

• Create and Assign APP(F110) Variant under Program “RFFOAVIS_FPAYM”

    System will create automatically Header record, batch header,detail record,batch control record,header control record.

     Thanks & Regards

      RK

[Former Member · Accepted solution]

Hi RK,

Thanks for the reply. I have one more question. In EXIT_RFFOEXIT_103, I want to change a field CTX13 DTADUSCTX but in the DTAMUSCTX in the user exit EXIT_RFFOEXIT_103 does not have the field CTX13. Can you please let me know how to change that field with a constant value.

Thanks

Ravi

[Former Member · Accepted solution]

Declaration Must be as below for non existing field in the userexit EXIT_RFFOEXIT_103 for ACH

field-symbols: <CTX13> type DTAUSCTX-CTX13.

constants: c_value(8) type c value '99999999'.

  assign ('(RFFOUS_T)DTAUSCTX-CTX13') to <CTX13> .

    move c_value to <CTX13>.

[SuhaSaha]

Hello Ravi,

IMO since the program RFFOUS_T generates the payment file in ACH format so you would not have to worry about it. FYI, the payment file for the payment program is generated in the include RFFORIU4.

If the bank wants the data is some custom format, then you can use the DME engine(TCode - DMEE) to create the payment file format. The DMEE is coupled with the new payment medium workbench.

BR,

Suhas

[Former Member]

Hi Ravi,

We did that from scratch at my company.  It wasn't too difficult.  The UI logic selected a group of records from REGUH based on criteria and passed them to a custom FM, which created and saved the file.  Obviously I don't have the space or the will to go into detail about what the application logic would look like, but if I had to design it again, I'd put the application logic in a custom class with the following API and UI layer:

DATA: gt_reguh    TYPE TABLE OF REGUH,

      go_ach_util TYPE REF TO zcl_ach_file_builder.

SELECT ...

  FROM REGUH

  INTO gt_reguh ...

* The object constructor would build the file

* and store the lines in an object attribute

CREATE OBJECT go_ach_util EXPORTING gt_reguh.

* Show the user the file before they save it.

* An ALV will probably be fine.

CALL METHOD go_ach_util->preview

  IMPORTING

    action = g_action.

* Possibly call a file save dialog to prompt user

* for file path.

IF g_action = 'SAVE'.

  CALL METHOD go_ach_util->save

    EXPORTING

      path = l_path_to_your_folder.

ENDIF.

Hopefully this helps.  I wish you the best.