Payment Medium Format for US - ACH not available in DMEE transaction

[Former Member]

Hello Experts,

I have a requirement to create a custom payment medium format for US for bank transfer to a bank. The custom format should be created for US.

I checked for a standard US format available in the system. I could find ACH (Domestic payment transactions USA) is available in transaction OBPM1. But the issue is this format is not showing in the dropdown of format tree in the DMEE transaction.

Can you please let me know if i need to do any particular setting to get this Standard payment medium format of US in the dropdown of DMEE transaction?

I need this in the dropdown so that i can copy this format and modify as per my client requirement.

Appreciate your help!

Thanks,

Rupesh

[Former Member]

Thanks

[Former Member]

Hello Experts,

Can any one please reply me on this thread.

Thanks,

Rupesh

[Former Member]

Hi Rupesh

If you want to Customize ACH PMW format, you can try out using Sample Function Modules already present in the format. You just need to write user exit in appropriate places to get the requisite fields.

For every standard event module (say 00, 05, 30 etc), there is a corresponding place for maintaining sample function module (01, 06, 31 etc).

Contact your ABAPer he will help you achieve this in little time.

Regards

Srini

[Former Member]

Hi Srini,

I am an ABAPer. Can you please tell me in detail what are the corresponding places for maintaining sample function module (01, 06, 31 etc)? I know there are following event function modules attached to the ACH format for the respective events:-

FI_PAYMEDIUM_ACH_00

FI_PAYMEDIUM_ACH_05

FI_PAYMEDIUM_ACH_20

FI_PAYMEDIUM_ACH_30

FI_PAYMEDIUM_ACH_40

What are the appropriate places to write the user exit?

Also, Can we not do it by copying the ACH format and modifying it as per client requirement in the DMEE transaction. The only issue with this approach is ACH is not showing up in the dropdown in DMEE transaction. Can we do any setting to show it in the dropdown?

Thanks,

Rupesh

[Former Member]

Hi

I'm not an ABAPer... But from whatever I know, please check in the T Code OBPM3...

Select ACH, then click on Even Modules tab. Add New Entries and add the appropriate Sample Function Modules (01, 11, 21, 31, 41 etc). Click on Implementation Icon, there you can implement the user exit.

Regards

Srini

[Former Member]

Also check in this path for SAP documentation. They are very useful.

SPRO --> IMG --> Financial Accounting (New) --> Accounts Receivable/ Accounts Payable --> Business Transactions --> Outgoing Payments --> Automatic Outgoing Payments --> Payment Media --> Make settings for Payment medium formats from Payment medium workbench.

Let me know if you have any further doubts on this.

Regards

Srini

[Former Member]

Thanks Srini,

I need to explore these options like how effectively i can use this. I will surely seek your help in case of any doubts.

Thanks for your help.

Regards,

Rupesh

[Former Member]

Hi Srini,

As per your last reply:-

Please check in the T Code OBPM3...

Select ACH, then click on Even Modules tab. Add New Entries and add the appropriate Sample Function Modules (01, 11, 21, 31, 41 etc). Click on Implementation Icon, there you can implement the user exit.

I did this in transaction OBPM3 but I am not sure how i will go about modifying the existing format. I know i have to write ABAP code in the new event module enrties but i need to atleast see what the existing format is for standard ACH.

If you can please help me with the detailed steps of this solution.

Thanks,

Rupesh

[Former Member]

Hi

You can go through the existing code using OBPM1 T Code. Select ACH --> Click on Event Modules tab. You will have the code for the standard events 00, 05, 20, 30 etc. Function module names are FI_PAYMEDIUM_ACH_00, FI_PAYMEDIUM_ACH_05 etc.

Moreover, if you want to see how the file looks, check with your functional consultant to create a test case with ACH format and you can see the output using program SAPFPAYM.

Let me know if this helps.

Regards

Srini

[Former Member]

Hello Experts,

I could find one program RFFOUS_T (Payment Medium USA - Transfers/Bank Direct Debits in ACH Format) which is used for bank transfer for US using ACH format. When i read through the documentation of this program i could find the following user exits which can be implemented to modify the ACH format per client requirement:-

EXIT_RFFOEXIT_100 - Modification of file header records (DTAMUSFH)

EXIT_RFFOEXIT_101 - Modification of batch header records (DTAMUSBH)

EXIT_RFFOEXIT_102 - Modification of CCD detail records (DTAMUSCCD)

EXIT_RFFOEXIT_103 - Modification of CTX detail records (DTAMUSCTX)

EXIT_RFFOEXIT_104 - Modification of addenda records (DTAUMSADD)

EXIT_RFFOEXIT_105 - Modification of batch control records (DTAMUSBC)

EXIT_RFFOEXIT_104 has a special function: Unlike the other 5 user exits, an internal table (T_DTAMUSADD) is transferre here and can be changed. In each of the other user exits, no more than one record can be changed. You can find further information on the individual user exits in the documentation of the relevant function module.

Your expert opinion is needed if this can be used successfully.

Thanks,

Rupesh

[Former Member]

Hi Rupesh

There are two things - Classic Payment Medium format and Payment Medium Workbench.

RFFOUS_T beongs to first type while ACH belongs to second type. However the format is same

It depends upon the business requirement which format you use - check with your functional consultant, he can guide you.

For instance, Bank Communication Management Module does not support Classic Payment Format, you have to use PMW.

The configuration for mapping Classic/ PMW format is through the T Code FBZP--> Payment Methods in Country.

Regards

Srini

[Former Member]

Thanks Srini!

As per my functional consultant RFFOUS_T is/will be obsolete. So we wont be using this approach (also as per your advice).

So I tried the option of using transaction OBPM3.

1) I selected ACH format and then clicked on Event modules ->New Entry. But when i try to insert the custom function module it gives me error "Entry ZFI_PAYMEDIUM_ACH_21 does not exist in TFDIR (check entry)". For e.g.I selected

Event Function Module Relations Standard Module

21 ZFI_PAYMEDIUM_ACH_21 ADDED FI_PAYMEDIUM_ACH_20

and it gave me above error.

2) To see the standard file output for ACH format using the payment medium program, i tried to run it for a variant provided by the functional consulant. But the issue is that it is not generating any file. I debugged the payment medium program for the said variant and tried changing the "Mapping using DME engine" flag to 'X' and got the following error:-

ACH format is not created for tree type 'PAYM'.

Do i need to select the checkbox "Mapping using DME engine" for the ACH format in transaction OBPM1.

Please help me with above two doubts. I have already rewarded point for your helpful answers.

Thanks,

Rupesh

[Former Member]

Few tips:

Say, th function module is called from the event module 20 viz. FI_PAYMEDIUM_ACH_20. We need to create a custom enhancement implementation say for example Z_ FI_PAYMEDIUM_SAMPLE_21 and write all the code in it.

We can either copy an existing sample module and write code, or implement custom exits in existing function modules.

Regarding your second point - first check if the payment method for which you are testing is assigned to ACH format under PMW (t code is FBZP--> Payment Method in Country). You need to Mark "mapping using DME Engine" only when you want the format to be picked using DMEE. Otherwise, it should not be ticked.

Moreover, when you tick this, you can view ACH format in DMEE under the format PAYM.

Let me know if you need any further clarifications.

Regards

Srini

[Former Member]

Hi Srini,

I tried assiging the custom event modules to the ACH format through transaction OBPM3. But when i run the payment medium program, the generated output file creates 2 records for all events which has both standard and custom event function module assigned to them. This is because two function modules for each event (viz 20, 21 ; 30,31 ; 40, 41) are getting called in the program and hence same two records in the output file for each of these events.

We need to have a way to suppress the standard event function modules of events( viz. 20, 30, 40) so that only custom event modules ( 21, 31 , 41) gets called.

I was thinking of copying ACH format in ZACH format and then assign the custom events to it. But i am not sure if this will work bcz even custom format ZACH will have those standard event modules.

Can you please tell me if i need to suppress it through config OR there is any other way to do it?

Thanks,

Rupesh

[Former Member]

Hi Rupesh

Frankly. I'm sorry. I cannot answer your question. It seems more technical and I have not much idea on it.

Regards

Srini

[Former Member]

Sure Srini,

I am getting on track to develop this interface. I ill keep you posted for any more ueries.

Thanks for your all help till.

Thanks,

Rupesh

[Former Member]

Thanks Sirnivas for your help on this......I have awarded more points to you on this.

Appreciate all your help.

Thanks,

Rupesh