vendor master list custom table with Bank account and Tax number extraction to excel

[Former Member]

HI all,

I am trying to download my vendor master list in a custom table with vendor address, contacts, email, contact person phone number, Bank account and tax number. But i am not getting the desired result. Kindly assist.

[ankurch]

Hi Mustapha,

You can try with Standard report "MKVZ" to get all these information!

Thanks,

[diana_dai]

The address number of a vendor can be found in LFA1 table, field ADRNR. Then the address detailed data can be selected in table ADRC, searched with the address number found from LFA1 table.

Best regards,

Diana