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

Mass uploading of payment terms field in customer master

Hi,

We need to update the payment terms field with a default value. The total customer master records to be updated are around 96,000( ninty six thousand).

which is better MASSD or LSMW?

regards

Pamela

Add a comment
10|10000 characters needed characters exceeded

Related questions

8 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 26, 2013 at 01:19 AM

    Hi,

    1.if you want to change all customers into one certain payment terms, MASS is ok, if change customers into different payment term, use LSMW.

    2.if huge of customer, please use LSMW because sometime we will meet error during update and LSMW you can restart from the last one you updated successfully.

    Thanks

    Liu jian

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 25, 2013 at 07:02 PM

    Hi

    This can be done in XD99. If there is standard Tcode for this then why to go for lengthy process like LSMW? LSMW is for when you cant do that with MASS or XD99. Try this with XD99 and update.

    Thank$

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 26, 2013 at 04:53 AM

    Hi,

    Hope Payment terms vary from customer to customer and also as per the sales area

    as suggested by Members you can Follow either of them but XD99 is perfect

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 01, 2013 at 11:11 PM

    Hi,

    Please use the T.Codes MASS or XD99 for uploading payment terms in Customer master records.

    Regards,

    Krishna.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 02, 2013 at 09:05 AM

    HI Pamela,

    You can use both Transaction. You can try XD99 and use KNB1-ZTERM field.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 02, 2013 at 02:45 PM

    Hello Pamela,

    Pamela Pilch wrote:

    Hi,

    We need to update the payment terms field with a default value. The total customer master records to be updated are around 96,000( ninty six thousand).

    which is better MASSD or LSMW?

    regards

    Pamela

    My recommendations goes for LSMW since the set of the Customer Master record which needed to be updated is huge and SAP has provided better error management process through LSMW...

    Thanks,

    Sarthak

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 03, 2013 at 04:36 AM

    Hello Pamela,

    If you comfortable with LSMW, i would suggest to go with LSMW.

    If in the future similar requirement comes it would be easy.

    XD99 is also ok,using XD99 you will need to do little bit of MS excel work

    you need to set filter in the excel based on the Payment term.then copy the customer in XD99 having similar payment terms

    Just for your information

    Tcode XD99

    Object would be KNA1

    Click on the field and then search for KNB1-ZTERM if you want to change the company code payment terms

    If sales area data payment needs to changed then search for KNVV-ZTERM .

    execute

    then enter the values in the customer field

    upon you requirement select the company code or sales area

    execute

    in the new values on the top enter you payment term that needs to be applied

    and the carry out mass change by clicking on the mass change icon

    I would prefer to do LSMW as these will be useful in future and it is very quick to prepare, if the requirement comes again.

    Thanks and Regards

    Amit L

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 03, 2013 at 04:58 AM

    Hi

    If you are much comfortable with LSMW process and then I suggest to go with LSMW.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.