MI39 for subcontract stock pysical inventory supplier number not populated to screen

[szhanden]

Hi gurus,

I'm trying to use the SAP stanadard function to upload physical inventory result in batch. I consulted this post:

https://blogs.sap.com/2013/01/01/inventory-count-entry-by-batch-input-method-with-transaction-mi34-m...

and I was able to create the physical inventory document with counting result using cg3z and mi39 correctly. But it's only for unrestricteed used stock. When I tried to use it for subcontract stock (special stock type O), it went wrong.

I didn't do the T159I testing. I used text file directly. Though in the post Jurgen said EXCEL is not a legacy system I still used it to create my file. I use the EXCEL function like this to add the spaces needed:

=C14&REPT(" ",C$13-LEN(C14))

And then I concatenate those fields together like this:

=CONCATENATE(B31,C31,D31,E31,F31,G31,H31,I31,J31,K31,L31,M31,N31,O31,P31,Q31,R31,S31,T31,U31,V31,W31,X31,Y31,Z31,AA31,AB31,AC31,AD31)

Then I got the text file I needed by copying that cell directly to a text file:

MY_MI39 MI09 D501 202307022023070220230703202307032023 1 1000 EA 100000 A-010050

File for unrestricted used stock

Anyway, this file worked fine. The physical inventory document was generated with counting result. As you can see it's for unrestricted stock inventory.

Then I tried it for subcontract stock.

MY_MI39 MI09 O D501 202307022023070220230703202307032023 1 EA 100000 A-010050 100106

Subcontract stock

And this time the system the system pomptedd an error message when I run in foreground:

Error message

The only difference between the above two files are:

Special stock indicator: spaces to O

storage location: 1000 to spaces

vendor number: spaces to 100106

I tried to move the vendor number to customer field and it didn't work. It seems that the system was matching the fields to wrong screen fields. After a lot of testing, I started to believe it's an SAP bug...

The excel file I used:

Excel file

And in SAP AL11 I can see the file like this:

I really appreciate any kind of help. Thank you!

MH

[szhanden]

Hi all,

I got the reason.

It’s a bug for s/4 hana. When the system converts the data from uploaded file to a batch input session, it uses different length of material numbers for items with special stock “O” (18 digit) and items without a special stock indicator (40 digits). That’s why it kept prompting that the customer number doesn’t exist on the screen. I modified my file, removed the extra 22 spaces after material number and it worked.

Hope someday SAP can fix this issue. Anyway, I can perform the transaction now.

MH