Skip to Content
author's profile photo Former Member
Former Member

Mass change of customer master data

Posted on Aug 30, 2007 at 08:03 AM 4.6k Views

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

FIN (Finance)
Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2007 at 08:20 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Aug 31, 2007 at 12:42 PM

      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

  • author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2007 at 08:11 AM

    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

    Add comment
    10|10000 characters needed characters exceeded