Good Movement set maximum rows for pasting from excel

[TedJ]

So I have 2000+ Material IDs / rows and want to perform mass transfer. When I open MIGO / Goods Movement there are only like 14 rows that I can paste into. I know if I decrease my resolution I can increase that number but only to a certain point. Is there a setting in S4 that I can update to allow mass paste of cells. Or is there another work around that someone knows of.

TIA.

Ted / Boston new to S4

[jagdeepsingh83 · Accepted solution]

Tia 

is it one-time activity or a regular activity -- One time then i would not recommend doing any development and just completing goods movements with some manual effort, but if it is a regular activity then it requires some development so that it can support such business process - means the ability to upload your excel to the system and process the goods movements as it is not possible for users to do these many goods movements.

Connect with your IT team - if it is regular activity --even if this needs to be done once a month--ask them to develop the solution for you-it could be an LSMW -- or T-code using the GOODS movement BAPI to perform the goods movements.

[TedJ · Accepted solution]

Thank You, yeah reducing the res to 25% I can fit a few more rows. This is a one time thing since we're doing a correction from our legacy data inventory that was placed in the wrong location.

[Dominik_Tylczynski]

Hello @TedJ 

Why don't you use a simple LSMW scenario with BAPI_GOODSMVT_CREATE for that? In my opinion that is the easiest and fastest solution.

Best regards

Dominik Tylczynski

[TedJ]

Dom, I'm just a user and not part of the DEV team. I've heard of LSMW but unsure of how to perform as a User and not IT / DEV team.

[Dominik_Tylczynski]

Hello @TedJ 

I understand. However I can't help you much more as SAP doesn't really provides to end users tools to mass post goods movements. In my opinion LSMW is the best tool for the job. Maybe you could work with your DEV/IT team to prepare such a LSMW scenario for you?

I used a similar approach and implemented LSMW scenarios for end users. They were quite happy with them and got proficient with them after a brief training.

Best regards

Dominik Tylczynski