BP number with its vendor number

[former_member515641]

How to create a report for BP number to get its vendor number?

[amarendar · Accepted solution]

Hi Asif,

This I achieved using below tables.

Table: 1. BUT000

           2. CVI_VEND_LINK

You need to write a query using above mentioned tables, in the table BUT000, there is field PARTNER GUID, this field should be linked to PARTNER_GUID field of CVI_VEND_LINK table.

Before writing the query, do a test.

1. Execute table BUT000, enter your BP number, from this table note down the Partner Guid number.

2. Pass this Partner Guid number in CVI_VEND_LINK table, you will get your Vendor code.

For Customer, you can use the same process, but use table CVI_CUST_LINK table.

Regards,

Amar

[former_member515641 · Accepted solution]

Hi Amar,

Thank you, it worked.

[former_member817881 · Accepted solution]

Hi Amar,

Can you please post code.it will be really helpful

[silvanacpv · Accepted solution]

Thank you.

It works.

Clear and useful.