Determining vendor list from vendor and product category

[Former Member]

Experts,

We are on SRM 5.0.

Can you please suggest or let me know the tables/function module to find the vendor list that a vendor belongs to?

The scenario is: User is creating a SC, provides product category and manually types the vendor number. Now based on the product category and vendor provided by user, I wish to determine the vendor list that this vendor belongs to.

Can you suggest?

Thanks

[laurent_burtaire · Accepted solution]

Hello John,

there is no direct link between Vendor List and Vendors.

But with Category ID, use BBP_PD_AVL_GETLIST (importing parameter I_CATEGORY_ID) function module to get Vendor List.

Then, with BBP_PD_AVL_GETDETAIL function module, use Vendor List guid or Vendor List number to get items: each item corresponds to one Vendor.

Finally, check deleted and blocked Business Partners with BUT000 table.

Regards.

Laurent.

[Former Member · Accepted solution]

Hello Laurent,

Thanks for getting back.

I used BBP_PD_AVL_GETLIST (importing parameter I_CATEGORY_ID) function module to get Vendor List. Now my vendor list is in 'Not released' state. How can I capture this 'not released' state to avoid user from creating a SC with a vendor that belongs to such a vendor list?

Thanks

[laurent_burtaire · Accepted solution]

Hi,

check E_STATUS table.

Regards.

Laurent.

[Former Member]

Hi John,

You can differentiate the Vendor list by the  partner function "00000019".

Regards

Ashok