cancel
Showing results for 
Search instead for 
Did you mean: 

Mass change of customer master data

Former Member
0 Kudos

Hi,

I would like to do a mass change of customer master data.

I need to remove the international VAT register number for local Polish customers, as we will use the local NIP number for these customers.

Which transaction code do I need to use?

Are there any things I should keep in mind?

Thank you.

Kind regards,

Linda

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

You haev a Transaction called MASS. Please check whether you have the authorization for the same. If you have then it is very much easy for you to maintain the same. If you dont have the MASS authorization then you have to create a LSMW and then make the change.

Steps:

1. Enter MASS

2. Object type - Select KNA1 (avaialble in the drop down) and execute

3. You should have an option "Customer master (VAT registration numbers general section) " with table KNAS. Execute

You will be able to choose those customers whom you want and make the changes.

Hope this should help you.

Former Member
0 Kudos

Great, thanks.

I have access to this transaction.

Kind regards,

Linda

Former Member
0 Kudos

Hi,

I have tried the MASS transaction it foreground in the test environment.

I have selected the tables KNA1 & KNB1 and the field KNA1-STCEG.

I have made a variant.

In the production environment, I would like to do it in background processing.

What is the easiest way to schedule it in background?

Thank you.

Kind regards,

Linda

Former Member
0 Kudos

After you have selected your crtieria e.g. Customer records, change field values etc. save as a Variant in MASS

Run transaction code MASS enter your Object type KNA1 and your varaint and then from top menu Select <b>Mass Maintenance-> Background Processing</b>

Hope this helps

Siva

Former Member
0 Kudos

Thanks. Indeed.

Kind regards,

Linda

Former Member
0 Kudos

Hi,

After the job run, not all VAT codes were removed.

For some customers it failed.

The error message in the log says: "no batch input data for screen SAPMSSY0 0120".

What does this mean?

Kind regards,

Linda

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Linda,

You can make a download from the customers from Polen with SE16 (table KNA1)to an EXCEL sheet. Create an simple LSMW for the upload.

When you know how LSMW is working this little change is fixed in 1 hour

Paul

Former Member
0 Kudos

Thank you, Paul.

I don't know how LSMW works.

Where can I find information about it?

Is there also a possibility with transaction XD99?

Kind regards,

Linda

Former Member
0 Kudos

Linda if you want to use MASS, you need to consider that it is used to make a mass change for a single value.

So an example of this is the Tax field you are refering to.

If you want all, or a range of customers to have the same value in the field then use MASS, if you want each customer to have a different value use LSMW.

Hope this helps.

Former Member
0 Kudos

Thank you, Marc,

Where can I find guidelines to use LSMW?

Kind regards,

Linda

Former Member
0 Kudos

Hi Linda,

try this link, it is for data migration but you can use it for XD02.

http://www.sap-img.com/general/lsmw-steps-for-data-migration.htm

Hope it helps.

A quick tip, apart from using SDN which is great, try using google.

Former Member
0 Kudos

ok, great. thanks.

I'll try that.

Kind regards,

Linda