DME files not getting stored in Appl Server .

[former_member196299]

Hi All ,

Please help me to solve this issue ..

My DME files is not getting stored in the application server directory created by me , rather it is getting stored in the

TEMP folder of the application server . How Can I store the DME output files in my application server , please let me know if I have missed any steps .

Regards,

Ranjita

[former_member196299]

Thank you all .

Regards,

Ranjita

[Former Member]

Hi Ranjita

I know it has been a long time but I am having a similar issue- when the file gets downloaded it is in the txt format and not in XML i followed as much as I could the above thread but may be i missed something -

where do you see the option to define the XML type in variant attributes- I cannot see it, could you please guide me ?

Thanks

[Former Member]

Hi,

Go to OBPM4 --> Select your PMW format --> in the right side, there will be an option to create variant.

In the variant creation screen, there is an option called "Output to File Medium". Tick that check box and give the file path.

Your DMEE output will be automatically moved to the specified folder.

Regards

Srini

[former_member196299]

Thanks Srini , what you said is correct , but this option is there only if the DMEE file type is " FILE " .

But my file type is " XML " , for which this option is not there in the variant screen but we can see this this in the variant attributes screen .

Regards,

Ranjita

Edited by: Ranjita Kar on Oct 12, 2009 12:50 PM

[Former Member]

Hi,

Go to OBPM4 --> Select your PMW format --> in the right side, there will be an option to create variant.

In the variant creation screen, there is an option called "Output to File Medium". Tick that check box and give the file path.

Your DMEE output will be automatically moved to the specified folder.

Regards

Srini

[Former Member]

Hi,

Are you using classic or PMW for the DME?. If it s PMW, in transaction code OBPM3, you can define the path in the event module option.

Thanks an Regards,

Anit

[former_member196299]

Hi Anit ,

I am using PMW for DME .

Please help me with further details .

Regards,

Ranjita

[Former Member]

Hi Ranjita,

What we have done here is, in OBPM3, we have an option to add event modules. We have used event 21 and with the help of an abaper, written a small program to specify the path as to where it has to be stored.

Thanks and Regards,

anit

[former_member196299]

Thanks for the info Anit .

Can I get some code snippet or link where I can understand the logic to write the adapter program .

Actually I understand that in the event program we need to use opendataset to write the file to the application server ,

but here, my internal table should contain what ?

, the whole XML structure should be filled to the itab ? Please show some light on this .

Thanks ,

Ranjita

[Former Member]

Hi,

FUNCTION YFI_PAYMEDIUM_DMEE_20_F2.

*"----

---

""Global Interface:

*" IMPORTING

*" VALUE(I_FPAYH) LIKE FPAYH STRUCTURE FPAYH

*" VALUE(I_FPAYHX) LIKE FPAYHX STRUCTURE FPAYHX

*" VALUE(I_FORMAT_PARAMS) LIKE FPM_SELPAR-PARAM

*" VALUE(I_FILENAME) LIKE REGUT-FSNAM

*" VALUE(I_XFILESYSTEM) TYPE DFILESYST

*" TABLES

*" T_FILE_OUTPUT STRUCTURE FPM_FILE

*" CHANGING

*" REFERENCE(C_FILENAME) LIKE REGUT-FSNAM

*"----

---

• put filename

DATA: Y_FILENAME TYPE REGUT-FSNAM,

T_FILENAME TYPE STANDARD TABLE OF REGUT-FSNAM WITH HEADER LINE,

• structures filled by application program

L_FPAYH TYPE FPAYH,

*structure for bank data

L_BANKDATA TYPE YFI_BANK_AD_DATA,

*date

W_DATE(10) TYPE C,

*counter

W_CHAR(3) TYPE N,

*dot

W_DOT(1) TYPE C VALUE '.',

W_LEN TYPE I,

W_POS TYPE I.

• fill strutures of payment documents

L_FPAYH = I_FPAYH.

• Get the Client code( Source Code )

• based on the Company code ,House Bank and Bank Id

SELECT SINGLE * FROM YFI_BANK_AD_DATA

INTO CORRESPONDING FIELDS OF L_BANKDATA

WHERE Z_BUKRS = L_FPAYH-ZBUKR AND

Z_BANK = L_FPAYH-HBKID AND Z_BANKID = L_FPAYH-HKTID.

*today's date

W_DATE = SY-DATUM.

*make file name as per bank

• IF L_FPAYH-HBKID cp 'HSP01*'.

IF L_FPAYH-HBKID cp 'HS*'.

• CONCATENATE '/data/fi/epay/hsp01_int/' '%' L_BANKDATA-Z_CLIENTC(4) W_DATE6(2) W_DATE4(2) w_date(4) L_FPAYH-LAUFI

• '.___' INTO Y_FILENAME.

CONCATENATE '/data/fi/epay/pearl2/' '%' L_BANKDATA-Z_CLIENTC(4) W_DATE6(2) W_DATE4(2) w_date(4) L_FPAYH-LAUFI

'.___' INTO Y_FILENAME.

• ELSE.

• CONCATENATE '/data/fi/epay/icp01/' '%' L_BANKDATA-Z_CLIENTC(4) W_DATE6(2) W_DATE4(2) W_DATE+2(2) '.___' INTO Y_FILENAME.

ENDIF.

*is there any entry for given key

SELECT COUNT( * ) FROM REGUT WHERE DWNAM LIKE Y_FILENAME .

*if none

IF SY-SUBRC <> 0.

*this wud be first file - remove % from file name

W_LEN = STRLEN( Y_FILENAME ) - 22.

Y_FILENAME = Y_FILENAME+22(W_LEN).

• IF L_FPAYH-HBKID cp 'HSP01*'.

IF L_FPAYH-HBKID cp 'HS*'.

• CONCATENATE '/data/fi/epay/hsp01_int/' Y_FILENAME INTO Y_FILENAME.

CONCATENATE '/data/fi/epay/pearl2/' Y_FILENAME INTO Y_FILENAME.

• ELSE.

• CONCATENATE '/data/fi/epay/icp01/' Y_FILENAME INTO Y_FILENAME.

ENDIF.

SPLIT Y_FILENAME AT W_DOT INTO Y_FILENAME W_CHAR.

W_CHAR = '001'.

*if yes

ELSE.

*existing file name

SELECT DWNAM FROM REGUT INTO TABLE T_FILENAME WHERE DWNAM LIKE Y_FILENAME

AND DWNAM NE SPACE.

*get file name with max counter

LOOP AT T_FILENAME.

Y_FILENAME = T_FILENAME.

DO.

SEARCH Y_FILENAME FOR '\'.

IF SY-FDPOS = 0.

EXIT.

ELSE.

W_POS = SY-FDPOS + 1.

W_LEN = STRLEN( Y_FILENAME ) - W_POS.

Y_FILENAME = Y_FILENAME+W_POS(W_LEN).

MODIFY T_FILENAME FROM Y_FILENAME .

ENDIF.

ENDDO.

ENDLOOP.

SORT T_FILENAME DESCENDING.

READ TABLE T_FILENAME INDEX 1.

Y_FILENAME = T_FILENAME.

*increment the counter by 1.

SPLIT Y_FILENAME AT W_DOT INTO Y_FILENAME W_CHAR.

TRY.

W_CHAR = W_CHAR + 1.

CATCH CX_SY_CONVERSION_NO_NUMBER.

*-- Make it first file

• W_CHAR = '001'.

ENDTRY.

ENDIF.

*put file name

CONCATENATE Y_FILENAME W_DOT w_char INTO Y_FILENAME.

*export to ABAP memory id will be used by filename node in header

EXPORT Y_FILENAME TO MEMORY ID 'Y_DMEE_FILENAME'.

• CONCATENATE '/data/fi/' y_filename INTO y_filename.

C_FILENAME = Y_FILENAME.

*} INSERT

ENDFUNCTION.

[former_member196299]

Hi Anit,

Thanks for the response and I am working on that logic .

In the mean while can you please tell me where we specify the path of the file to be downloaded ?

For example , if I want to download the payment run file to my local desktop then

I give this file name 'C:\Documents and Settings\rkar\Desktop' in the download file popup box , .

And I do this evetytime I download the file manualy .

My question is, is there any place in the settings where I can give this file path for once ?

Thanks for your helps .

Regards,

Ranjita

[Former Member]

Hi,

Any luck with the path? I am not sure if you can mention a path to download. You can check with an Abaper.

Thanks and Regards,

Anit

[former_member196299]

Hi Anit ,

That code was really helpful , and even I was able to place the file into the application server .

But when I try to open the file from the application server ( As I mentioned its a XML file ) , it doesnt come correctly, looks like there is some problem with the data . And it comes correct in the scenerio , when I run the payment program and manually try to save the file in the Application server .

I am not sure what could be the problem . If you have any clue then please let me know .

Thanks ,

Ranjita

[Former Member]

Hi Ranjita,

We too had the same problem. Check out the following notes and see if it needs to be applied -

1068649 - Sort field does not work if there are more than 1 tree.

You try to create a payment file using SAPFPAYM.And the payment run contains two DMEE trees(attached to two payment methods involved in the payment run).The generated file contains wrong information.This is because the sorting crieteria of the second DMEE tree involved in the payment run is ignored.

1150753 - Sections of Information missing in XML files

You use a DMEE Tree with category as XML to generate files.Some sections of the file are missing.

1144841 - SEPA file is incorrect

The SEPA-XML file is not displayed correctly or is identified as being incorrect.

1127552 - PMW-XML file in unicode system

The download using transaction FDTA in a Unicode system of an XML file that was saved on the file system does not deliver the correct results.

1296748 - same as above

Thanks and Regards,

Anit

[former_member196299]

Hi Anit ,

I am still waiting for a resolution of the problem I mentioned .

Kindly suggest some ideas as to resolve this issue .

Regards,

Ranjita

[Former Member]

Hi Ranjita,

Did you check the relevance of the notes I had mentioned earlier? These notes had helped me get proper XML data.

Thanks and Regards,

Anit

[Former Member]

Hi Anit,

Can you please let us know what setting we nee to make to get the F110 file in XML format?

Thanks In advance.

[Former Member]

Hi Ranjita,

Is your problem solved?

Hi SAP GIG,

For XML format, you have to use PMW for your payment methods. Use transaction code DMEE to create the XML format. The tree type - PAYM and give the a name to the Format tree. When you click on Create button, the system will ask if you want to create Flat file or XML. Select XML and proceed.

Search service market place for any notes that may be applicable apart from the one given in this thread as per your version requirement.

Thanks and Regards,

Anit

[former_member196299]

Hi Anit,

I am not able to resolve the issue , looks like the issue is with the data format .

I went through all the notes mentioned by you and I could find the note 1144841 to be useful .

This note speaks about changing the 'Code page 'value to 4110 , but I don't see this code page field anywhere in

OBPM3 transaction . I guess I might have to do it using a different event and a different FM .

I am too much confused here for further processing .

Actually till now I am able to download the file to the application server but the file content are placed in different lines( spaces are added to the data ), which is when read as the XML , it displays an error " data not maintained properly ". If I remove the spaces and make the whole document data as one line , the system opens the file properly .

This is the problem ..

Did you too come across the same problem ?

Thanks,

Ranjita

[Former Member]

Hi Ranjita,

In OBPM3, double click on the format tree you have created, you will find the option to enter Code Page. The problem we had was that the stored file in application server was not displaying the entire data. We solved the same by applying these notes.

Thanks and Regards,

anit

[former_member196299]

Anit,

In OBPM3 , when I double click on the paym format created by me ,

I dont see any place where we have the option to enter 'code page ' .

Regards,

Ranjita

[Former Member]

Hi Ranjita,

We are using ECC5 and I am able to see the option. Which version are you in? Suggest you search service market place for any note that needs to be applied.

If required, you can raise an OSS. SAP will definitely provide you with the right note.

Thanks and Regards,

Anit

[former_member196299]

You are correct Anit , I just checked the verson from when the code page is being introduced .

I am using 4,7 , and the code page concept have been used since release ECC 5 .

Thats why I am not able to see it .

I would look for a solution for this version .

And really thanks a lot for the guidance .

Regards,

Ranjita

[Former Member]

Hi Ranjita,

Glad to be of help. Please do update when you get a solution.

Thanks and Regards,

anit

[former_member196299]

Sure Anit .

Regards,

Ranjita

[former_member196299]

Hi Anit ,

In my findings for solving the problems , I could come to know that in the variants for the format tree , the field

" Output to file system ' should be checked , and these should be done in OBPM4.

But I am unable to see this field for XML Trees , but this is available for File type trees .

If you can share some information regarding this then it will be of help .

Regards,

Ranjita

[former_member196299]

Hi Anit,

Thanks a lot for all the help .

My problem got solved .Actually i was getting the complete data but not in proper format .

So in one of the evnt function modules I had to place the data correctly so that it should open properly as xml file .

which finally worked .

Regards,

Ranjita