How to count Physical inventory by MI34 ?

714 Views

Hi,

I have created Physical inventory document by MI31. Now I want count it by MI34. In MI34 i got default logical file name 'MMIM_PHYSICAL_INVENTORY_DOCUMENTS

1. What I did was to create a text file phyinv34_38.txt (fixed width) with a structure following table BISEG -- (i used microsoft access for this) & the file format with Fix width like this :

amit12345678MI04 20091029 2009100000152 50

2. In transaction FILE for logical file MMIM_PHYSICAL_INVENTORY_DOCUMENTS, i made data format DAT and changed physical file to phyinv34_38.txt and assigned logical path LOCAL_TEMPORARY_FILES

3. I had upload the file /usr/sap/trans/data/<FILENAME> on server unix & excute the transaciton MI34 but I am not able to complete the BDC session, System pick up the blank filed as space & filled up with #,,

I have tried with the text delimited also but not succeessed & also tried with ASC format

Pl suggest where can I made mistake

Rgds

Nishit