MI34 - Sequential file C:\phyinv34_38 cannot be opened

[Former Member]

Hi SAP Gurus,

I want to use MI34 to enter count from file.

I read the SAP information about this tcode.

I created a file with the fields of BISEG.

I saved the original file (Excel) in txt (with tab).

I modified the logical path file to read the good file.

But, I've always this message.

Different threads about this problem but with no solution.

In test mode, we have no problem because we update a SAP table T159I.

Please, give me the good reason of this message.

Is is necessary to have all fields in the file from BISEG ?

And, of course, advices of the best practices of this tcode ...

I have the same message with MI39 ...

Thanks

Lionel MARTIN

[JL23 · Accepted solution]

make sure that you haven't open the file with a windows application.

[Former Member · Accepted solution]

Hi Jürgen,

Sorry, but the file is not opened with a windows application.

I have always this message.

what should be the file structure ?

With MIMD, I have the same problem about the file phyinvmde.

Why ?

Thanks

Lionel

[JL23]

Programm cannot read directly from C:\ drive of your PC.

MI34 tries to open an dataset on application server directory, usually /usr/sap/trans/data/phyinv34_38

in

http://help.sap.com/saphelp_45b/helpdata/en/34/55cad198482bc0e10000009b38f91f/content.htm

following is said:

The file must be accessible from the application server. You cannot use OPEN DATASET to process files on the current presentation server (whether PC or workstation). The function modules WS_DOWNLOAD and WS_UPLOAD exist for this purpose.

which means that you have to upload the data first to the application server.

I ve seen basic guys who had the SAP application server directory as a shared directory in their Windows explorer and just did drag and drop to move the file from local directory to application server.

[Former Member]

Hi,

you're right ! Thanks a lot for your answer. With MI34 or MI39, the file must read from SAP directory, not directly from C:/.

And to use correctly MI34/MI39, I suggest these steps :

- Create a file type txt from Excel with the exacly structure of BISEG.

Warning : it's necessary to have a good length for each fields (ex : nb of inventory doc is on 10 digits then if the doc is 100000048, you enter 0100000048, the material code is on 18 digits if internal codification, ...)

- Create a program to transfer file from C:/ to SAP directory (/usr/sap/trans/data/<FILENAME> by using FM GUI_UPLOAD for example.

- Launch MI34 or MI39 to create sessions.

That works !!

Thanks and regards,

Lionel