HR Configuration for DME File

[Former Member]

Hi,

We need to generate DME file.Any inputs please ?

My client want to see DME File generated froM SAP.

Regards,

MVR

Please Read the forum Rules before posting the question

[sikindar_a · Accepted solution]

hope this helps

http://forums.sdn.sap.com/click.jspa?searchID=57624996&messageID=9520371

[Former Member]

Hi,

1. Check with customer what file format they use, check via transaction DMEE if this file format was preconfigured by SAP.

2. Assign DME file format to payment method via transaction FBZP.

3. Follow standard DME process: payroll > pre-DME program>DME program.

Cheers!

[Former Member]

Dear Semvladigo,

Thanks for your response. i did according to you. but not fully achieved my requirement. Could you elaborate your answer..--)

Via DMEE (DME Engine), i am getting few tree types. among those which one i need to select.

A little bit confusion while assigning file format to House bank as we have so many house bank under same company code.

What would be the return value for feature Feature DTAKT.

It would be helpful if you can provide some inputs

Regards,

MVR

[Former Member]

Hi MVR,

You have to find out with customer what are the requirements to Bank file. It may happen that different banks have different requirements to bank file. So ask to provide bank file template and find if it exists in DMEE. If it doesn't then you will have to create it.

Forget about feature DTAKT for the moment. You have to assign DME file directly to the payment method. Transaction FBZP table V_T042ZL.

Cheers!

[Former Member]

Hi Semvladigo,

I agree with you regarding on customer requirement of bank file. They may have different kind of format. According TO there format, later on we can create/change.

Actually, My client would like to see Standard format which has been provided by SAP (for country key IN).

Can you suggest which one i can assign/use in DMEE.

Regards,

[Former Member]

Hi Semvladigo/Sikinder/Mohan & Team

i am doing the process as said by mohan ( according to link thread which is posted by sikinder).

1) PC00_M40_CDTA

While running the above transaction, i am giving wage type /559 in additional data and rest iput value is only payroll area.

2)Once done, Next

i am running the transaction PC00_M40_FFOM (MT100 Format)

I am giving program rundate which has been generated based on earlier transaction, Paying company code, sending company code. Payment method T( I hope, in this only T, C, Cheque, D,Will consider in this program), House bank, account ID, AND output payment medium as 2.

3) Next, i am running the transaction FDTA and selecting the run date and executing, system generate one line item, later i am exporting in to notepad.

Please correct me in the above any thing wrong.

&

Dear Semvladigo,

You have to assign DME file directly to the payment method. Transaction FBZP table.

Right now, under My company code and Payment method T , Payment medium program as RPF0M100.could you say/how can i know which satndard format picking while transaction PC00_M40_FFOM

Regards,

MVR

Edited by: MVRmvr on Sep 29, 2010 12:21 PM

Edited by: MVRmvr on Sep 29, 2010 12:40 PM

[Former Member]

What you are doing is correct process and also check the DTAKT feature properly...return value is Housebank/account ID...check these bank details in table T012 and T012K.

Standard format is SWIFT MT100 and if you want to change your formate Output control and Alternative formate.

Mohan

[Former Member]

Hi Mohan.

Thanks for immediate responce.

Please give some clarification.

1) If it is the case, there is no much Assignments in SPRO.. Only we need to do assign payment method in company code,and feature DTAKT, if bank is OK with the standard format generated by SAP standard transactions.. Right.?

2) Weather I need to select /559 or needs to be blank. (i am asking in /470 point of view. and system read BT table ) in transaction PC00_M40_CDTA.

3) If bank is not adjust with SAP standard format, we need to have create a format, and the same needs to be assigned to under payment method T , payment medium.

Regards,

MVR

[Former Member]

1) If it is the case, there is no much Assignments in SPRO.. Only we need to do assign payment method in company code,and feature DTAKT, if bank is OK with the standard format generated by SAP standard transactions.. Right.?

Yes it is correct....but most of the banks having their own formates ....so they will prefer in that formate.

2) Weather I need to select /559 or needs to be blank. (i am asking in /470 point of view. and system read BT table ) in transaction PC00_M40_CDTA.

You have to select /559 WT only.

3) If bank is not adjust with SAP standard format, we need to have create a format, and the same needs to be assigned to under payment method T , payment medium.

If bank is not accepted then you have to customize the formate.You need ABAPer help and copy standard program and create as per requirement.

Mohan

[Former Member]

Hi Mohan

Thanks for your answer is very helpful. i hope, i am in right way according to your answer . ..)

Point no 3,

We can copy the standard program and modify as per bank format. We need to assign in the format in to payment method T and under redio buttion payment medium. right?

and the bank people are Ok with the standard format but asking for their payment mode which we need to define. How we can do. ?

Regards,

MVR

[Former Member]

Hi MVR,

You should make your mind about what tool you want to use:

1. DME (Payment medium workbench) or

2. Payment medium program

You can find what method is assigned to payment method under transaction and table that I specified in my previous post.

The topic started with DME, but now it migrates to payment medium program.

If you want to do payment medium program, you should ignore my previous messages.

Cheers!

[Former Member]

Dear Moderator,

Thanks for your suggestion.

Team, Please give your inputs.

Regards,

MVR

[harishtk1]

I would first look at the steps in the following portion of the img

Payroll> Data Medium Exchange

You would also need to deifne a location at the application server level where the text file will be downloaded.

you will have to establish a secure procedure by which the text file will be transmitted to the bank. One simple way is to use a ftp software but I am sure there are others more secure - your basis person may be able to help or your client may have a standard protocol to be used.

Hope this helps.