Replace the Values in LSMW

[Former Member]

Hello All,

Good Day!

I have created a LSMW to update Vendor Master Data with Withholding Tax. But by mistake for some Vendors Withholding Tax Codes were mainatined wrong and later it was realized to correct those entries. Now in that Withhodling Tax Line, Withholding Tax Type is OK, but COde is not OK, rest all fields are OK. There are around 200 entries and I want to correct only Tax Code fields for a particular Withholding Tax Type, can this be possible to create a LSMW and replace those Codes for that particular Withholding Tax Type?

Or is there any table in which I can maintain the values?

Many Thanks for your replies...

Regards,

Pritesh Lodha

[Former Member · Accepted solution]

Hello All,

Good Day!

The problem is solved, I have executed the transaction MASS and provided the Object Type as LFA1 Vendor Master Change and then selected Withholidng Table Line and executed. Then I have entered the details in Tab Data Records to be Changed and executed. Then I have provided the new and old value with restrictions and did MASS update.

I have tried with LSMW but was uable to create the rule.

Many Thanks,

Regards,

Pritesh Lodha

[Former Member]

Before assigning values you can create some rule in LSMW according to your requirement..

[Former Member]

Hello Rajiv,

Good Day!

Can you please elaborate, as where I can create the Rule?

Many Thanks,

Pritesh Lodha