With holding Tax Codes Upload

[Former Member]

Hi

I have upload the vendor master data without withholding tax codes through LSMW.

Now I want upload the withholding tax codes.

is it possible to upload through LSMW.

each vendor has 5 lines W.T.Codes. after completion one line item then what we have to do i mean (, or/ )

and how to prepare the excel shee or text t for upload the vendor master data.

Please give advise.

.

[Former Member · Accepted solution]

Thank you for giving the answer.

But let me know any gl account upload the only one line so no problem. here 5 line item after complete the every line item in one vendor. how to define line item is complete are we putting /(slash) or , (comma) in text format or excel sheet.

Regards,

Guna

[former_member213733 · Accepted solution]

Hi ,

In recording of FK02 you will have to record WHT for 1 time like - Vendor 'X' WHT Type C1 and WHT code C1 , tick on liable .

Save the recording .

Now in the file if a vendor has 5 tax codes then you will have to give 5 line items like this :

Vendor WHT Type WHT code Liable

1010 c1 c1 x

1010 c1 c2 x

1010 c1 c3 x

like this you will have to fill the file .

Regards ,

Dewang

[Former Member · Accepted solution]

Hi Guna,

In the Excel sheet you have different rows and wherever, the Vendor no. is changing system will understand it for a new item and a new entry. There is no comma or slash..

Regards,

SAPFICO

[Former Member]

Thanks u for all

[Former Member]

Hi,

Yes, you can upload Withholding tax data of Vendor master data through LSMW.

While recording for FK02, select Vendor, Company code and only the withholding tax check box and you will be taken directly to E/With holding tax screen..

For 5 line items, from your total records of upload check for that vendor who has the maximum lines for upload and then while recording record for those many lines..meaning if you record for just 2 lines, it will call for next record after uploading 2 lines, but if you record for maximum lines.. in your case 5 lines, then, even if you have 2 lines it can be uploaded with a recording of 5 lines.

I have used it myself in various Projects.. so it is tried and tested.

Regards,

SAPFICO