Vendor Master Report Required

[Former Member]

Dear Sir,

I have required a details of full vendor master data with complete Name, Address, PIN code, State, City, Excise No. , Range, Div. , Comm. VAT NO. ,VAT NO. PAN NO. and also required Service Tax No.

Please help us.

Nitin

[Prasoon]

Hi,

There is no direct report as of my knowledge. You may create a simple SQVI or SQ02 querry with LFA1 and J_1IMOVEND tables, which can provide you the complete information.

[Former Member]

Use Transaction SQVI and join the required fields from the table LFA1 , LFB1 and LFM1 .

[JL23]

in which of those 3 tables are all above mentioned fields?

[mangesh_p]

Please check Report - S_ALR_87012086 or J1ID, S_ALR_87012087 and MKVZ

[AseshKumar]

Hi Nitin,

Pls check in LFA1 Table.

Regards,

Asesh