Vendor Details Needed

[Former Member]

Dear Experts,

For one of our development, we need vendor details such as vendor name and number.

will you please help me, in which tables i will get these details.

I have already checked these tables; VENMAP, BUT000, BUT001 AND BUT020.,but it is of no use.

Appreciate earlier and correct response.

Thanx & Rgds

SriRaM

[Former Member · Accepted solution]

Hi

<u>What is your detailed requirement ? Which SRM Version are you using ?</u>

<b>On what basis, do you want to find the Vendor number and name.</b>

<u>Based on the Vendor number stored in BUT000 table, you need to go to ADRC table to get the name and other address details.</u>

<u>Have you tried using the function modules below -></u>

BBP_PARTNER_ADDRESS_GET_COMPL

BBP_FIND_ORGADDRESS

BBP_FIND_PERSADDRESS

Do let me know.

Regards

- Atul

[Former Member · Accepted solution]

HI Atul,

Thanks for replying...

Presently we are working on SRM 5.0

It is a PCR development.

in this development, whenever user wants to see the details of SC , first it searches in database, then searches in Archive files.

our present requirment is that, we have to bring the vendor name and vendor number fields in Archiving Info structure. since these fields are not present in Standard AIS, we have created Z info structure and adding extra fields such as Price , qty, currency and approver etc.. etc..

i have checked the BUT000, i am unable to identify the vendor details.

please help me out to get the vendor fields ..

Thanks in advance

Regards

SRiraM

[yann_bouillut]

Hi,

Please read the following thread where solution was provided :

https://forums.sdn.sap.com/click.jspa?searchID=3686091&messageID=3130018

Kind regards,

Yann