AP - DME File creation Process

[Former Member]

We are in the new SAP Implementation. For this we have configured the F110 Automatic Payment Program.

We have now 3 Invoices ready for payment - one for Wire, Check & ACH

We want to create the DME files for ACH and Wire & Print the Check.

Would some one explain me the steps involved please?

Thanks a lot.

V

[Former Member · Accepted solution]

Vijaya,

In brief these are the steps. However, you will find these in themselves are just guiding points.

1. In the payment method for country configuration, you maintain the Payment medium for each payment method. For DME, you would have to use Payment medium workbench and specify the Format and the Format supplement. For ACH in US, the Format would be ACH and supplement would be CCD or CTX, etc.

2. Before assigning the payment medium you will have to maintain one specific for a DME file in the img node: Financial Accounting>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 Payment Medium Formats

3. Once you maintain the format key in step 2, you need to create the structure of the DME. You do that in transaction code DMEE. The structure would depend on how your banking institution wants it. Please create the structure for Tree type: PAYM - Data Medium Exchange for Payment Program

4. The assignment of the structure in 3 above with the payment medium in 2 above is done by a check box in step 2 called: Mapping using DME engine.

5. After this you need to maintain variant for program SAPFPAYM. Here you give the path where the DME file should be saved.

6. You need to figure out the way you would send the file to the bank.

I am sure you will have lot more questions.

Regards,

Vishal.

[Former Member · Accepted solution]

Thanks Vishal.

This is what I have understood, correct me if I have gone wrong

ABAP

1) Create the ACH File Structure specified by the Banker

2) Create the Variant for ACH called ACHVariant ( This will contain the info to pull the ACH record that needs to be sent to the Bank from the SAP Database and once retrieved where these records/file needs to be stored)

End user

1) Run the F110 for ACH Payments

2) Run the SAPFPAYM in SE38 with the Variant ACHVariant -

This will create the "ACH file for Bank Runid" in a specified location

3) Send the "ACH file for Bank Runid" to the bank

Thanks again

[Former Member · Accepted solution]

Vijaya,

SAPFPAYM - You don't have to run this separately. Once you configure your payment method properly, in the F110 screen 'Printout' tab, automatically the necessary programs will be populated. This is one of them.

All the other steps seems ok to me...

Please also refer to the SAP online documentation in this matter.

Regards,

Vishal.

[Former Member · Accepted solution]

Thanks a lot Vishal.

In the Printout /Data Medium tab

I see the following programs

RFFoAVIS

RFFOEDI

RFFOUS_C

What's the purpose of the above programs?

2) When we run with SAPFPAYM I hope I have to create a separate variant for ACH & Wire

If there are any step by step document can you point to for the above process?

Thank you Vishal.

[Former Member · Accepted solution]

Vijaya,

I will look into my documentation and reply to you tomorrow.

Regards,

Vishal.

[Former Member · Accepted solution]

Vishal and other Gurus,

What's the exact difference between

RFFOAVIS

RFFOEDI

RFFOUS_C

What's the purpose of the above programs & SAPFPAYM

When to use which programs? Please help me.

Thanks

V.

[Former Member · Accepted solution]

HI

RFFOAVIS - The program creates notifications for customers/vendors that their receivables and payables balance to zero.

RFFOEDI1 - This program generates the Intermediate Documents (IDoc) for payment orders made via EDI. In addition to the payment media, you can output the related advice notes, EDI accompanying sheets and payment summaries in a single program run.

RFFOUS_C - This program prints prenumbered check forms or non-prenumbered checks whose number is to be assigned from a predefined number range, and links the check number to SAP payment document number or the check number to the settlement result. In addition to the checks, you can print their payment advice notes and payment summaries in one program run.

SAPFPAYM - Generic payment medium program of Payment Medium Workbench (PMW) for the creation of payment media, like variant creation for ACH

Script printing cause the program defined to be run. since you might have maintained following settings Use transaction FBZP and go into your company code under the Paying Company Code. Click Fomrs and verify forms in both Form for the payment advice and EDI Accompaning sheet Form fields. If you are assigning forms here, in F110 you will get RFFOAVIS and RFFOEDI these programs

Reg

Vishnu

[Former Member · Accepted solution]

Vijaya,

Vishnu has nicely explained the purpose of the programs.

For your purposes, once you have the payment medium and the SAPFPAYM variant defined, you need to go to the following IMG node and assign the variant to the payment medium.

IMG path: Financial Accounting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/Assign Selection Variants

Transaction code: OBPM4

Assign the program variant created in the previous step to the Company code/House bank/ Account ID relationship

So overall the configuration would look something like this:

1. Payment medium - e.g. 'XYZ_Wires'

2. SAPFPAYM variant - e.g. 'XYZ_Wires'

3. Format tree (tcode DMEE) - e.g. 'XYZ_Wires'

4. Create/Assign Selection variants - For payment medium XYZ_Wires assign the selection variant XYZ_Wires for the combination of

Company code/House bank/ Account ID

5. Assign the payment medium from 1. in the FBZP - Payment method/country code.

This should take care of the DME generation. Of course assuming that all the other FBZP config is in place.

Regards,

Vishal.

[Former Member · Accepted solution]

Hi,

Could you please tell me what are the standard formats for Check and Wire under the Payment Medium Workbench for the country US

And how to create the Payment Medium file.

Creation of Payment Medium File in the transaction DMEE or OBPM1

Thank you in advance.

[former_member212156 · Accepted solution]

Hi,

My client also has a requirement to implement ACH CCD+ using Payment Medium Workbench for payments to vemdors.

Currently we have the check method and below procedure is followed:

1) Execute F110

2) A text file is created though a custom program ZFCHX: "Positive Pay File File: Check Extract Creation"

3) The file is uploaded to bank server

4) After some days, "check clearing.txt" file is downloaded from the bank. (BAI Format)

5) The downladed file is processed through transaction FF_5 "Bank Statement: Various Formats (SWIFT, MultiCash, BAI...)

(Clearing sub bank account with main bank account)

6) Then use transaction code FEBAN to process if anything didnt get posted.

ACH CCD+:

I have configured almost all of the settings ( i think so). In testing client, I made couple of invoices for 2 vendors, then executed F110 and was able to generate the DME file (txt format). For testing purpose, it was sent to the bank and was processed successfully. Now the bank has sent back a file. According to the bank, one file is "transaction journal".

Transaction Journal File:    L20TRNR

I have no clue what format are these. Whenever i open them it asks for the program and normally i am using notepad to open them. But once opened through notepad, the data looks messed up. So i dont know which program should i be using to open them. And its not a BAI format, multi cash etc. And it has the basic details like total payment, our bank details etc  The bank says there wont b any other file sent back.

After getting the file from the bank, i am stuck now. Dont know how to proceed further.

What to do with this file? Do we have to upload them ; if yes then how? Are these to be converted to some other format and then uploaded in SAP? Or should i be expecting some other file? Will there be any file for bank reconciliation (for clearing sub bank and main bank account). My main issue is running FF_5 and posting the clearing entries but I don't know how to do it with this file.

So i'll really appreciate if anyone can let me know ALL the steps to go further from here. I mean after receiving the files what steps need to be followed to finish the process. And if there is any configuration left, what is it. Any immediate help would be greatly appreciated.

Thanks.

[Former Member · Accepted solution]

Hi Vishal and others,

I want the DMEE file to repeat certain tags

that is the header does not need to be repeated but the other tags specifying the vendor /amount to be paid/vendor bank details etc need to be repeated.

That is

I want to pay more than one vendor in one payment run (F110) (.std. functionality.)

When i do this after assigning a DMEE tree created for MT101 format, for the second vendor, the whole file gets created again

that is the header is repeated twice etc.

this is not what is expected

What is required is  that header and footer come in once but the tags like tag 21 - vendor, 32B (amount and currency) etc come in more than once in one DMEE file.

how do i achieve this.

Regards,

Sangarsh

[Former Member · Accepted solution]

Hi Adeel,

I am in the process of implementing CCD+ format.

Can you please share the DMEE structure for the CCD+

Screen shots will b very helpful.

Thanks