Skip to Content
avatar image
Former Member

BP number with its vendor number

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 29, 2015 at 10:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded