MASS CHANGE KNVP without counter option / overwriting existing data

[former_member788622]

Dear all,

How can I add multiple ship-to to multiple customers without using the counter and without overwritting the existing role?

For new values, the transaction MASS/XD99 is enough but once a partner role already exists you need to fill in the counter or else the existing values will be overwritten.

How can I skip the counter in this case? Or do I need to analyze first via KNVP table to see how many counters there are for each customer per ship-to? And then in XD99 create the new values with what the counter should be per customer (adding data via import data via buffer)?

Or can we create an LSMW with an own recording, based on the questions of multiple users here in the forum, I don't think that will work.

Who can help? Thank you in advance.

[former_member788622 · Accepted solution]

For the people interested, there is a solution. You can use LSMW and instead of creating a new recording, you can use the existing recordings of SAP (Standard BI programma). I would recommend to change a few settings because it takes you trough the general data of the customer/vendor before it submits the changes in the partner function.

[Lakshmipathi]

LSMW not required. Via MASS itself, you can upload KNVP data. For that, yes as you said, first you need to have a full existing data with Partner Counter and download to excel. With the same template, add whatever partner functions you want with the subsequent Partner Counter.

Once you complete the excel, in MASS, after selecting KNVP table, don't go to Fields tab; instead, click on "Import Data from File" and upload the excel. If you have not come across this functionality, have a look at this blog

[former_member788622]

Thank you for your response.

I need an LSMW, like I've already stated previously this will take too much time and work and there can easily mistakes been made.

I know how MASS works but I am trying to find another solution without making analyze in EXCEL from KNVP table for more than 10.000 customers. I know that WINSHUTTLE had one based on KNVP and you could easily add or delete customer roles.

WINSHUTTLE has the same settings as LSWM so can I build an LSWM without the counter to add different partner roles in the customer data?