Defining Catalogue Category

[former_member633158]

Hi.

We are interested to integrate our vendor online catalog to the EBP so that our users can directly go to their catalog and select the products then will be transferred back to the EBP.

There is no problem in that solution.

We have a small problem with the product category.

Say for example we have 3 different catalogues from 3 vendors(Catalogue A, Catalogue B, Catalogue C)

As per the basic business requirement we would like to point each catalogue to a different category by default(Catalogue A = Category A, Catalogue B = Category B, Catalogue C = Category C).

But our SRM Consultants says that this is not possible.

We can use only category as a default category for all the Catalogues we use.

However, they have suggested that in PPOMA_BBP , we need to enter the required category in the Extended Attributes of the user.

But I am not happy with the solution as i can see that this is a basic requirement of any business.

I cannot update every time 1000s of my users attributes.

Is this solution given by our consultants correct ? are do we have a place where we can configure the category per catalogue in the SRM.

These catalogue's are external vendor catalogues.

Many thanx for reading my long requirement.

Regards

erpman

[Former Member · Accepted solution]

Hi. What I have always recommended is that a custom table is built which can map UNSPSC code to product category.

Most suppliers will hold UNSPSC code in their own catalog, and will probably not mind adding it if you ask.

Then you can map to whatever product category you want using the custom table.

Then you can use BADI BBP_CATALOG_TRANSFER to pick up the UNSPSC code from the OCI value passed from the supplier and change the product category to whatever you want.

You could include catalog name in the custom table so that catalog A and UNSPSC A = product category A, but catalog B and UNSPSC A = Product category B.

Regards,

Dave.

[Former Member · Accepted solution]

This example uses a mapping table with just 3 fields (table name ZCATEGORY):

MANDT type MANDT

CATALOGID type (same as ls_item-catalogid)

CATEGORY type comt_category_id.

*-----------------------------------------------------------------------------
*sample implementation BBP_CATALOG_TRANSFER
*-----------------------------------------------------------------------------

*declarations
DATA:
   ls_item TYPE bbp_pds_sc_item_d,
   lv_category TYPE comt_category_id.

* initialisation
CLEAR:
  ls_item, lv_category.

* use the 'new' structures
ev_sc_structures_used = 'X'. 

* find the correct product category based on catalogue - only one category per supplier
LOOP AT et_sc_item_data INTO ls_item.
* select the category id
  SELECT SINGLE category FROM ZCATEGORY
                                          INTO lv_category
                                          WHERE catalogid EQ ls_item-catalogid.
  IF sy-subrc NE 0. "check if no entry found
   "do some error stuff or enter a default category.
  ELSE.
    MOVE lv_category TO ls_item-category_id.
    MODIFY et_sc_item_data FROM ls_item.
  ENDIF.
  CLEAR: ls_item, lv_category.
ENDLOOP.

[Tamas_SAP]

Hi,

in the BADI BBP_CATALOG_TRANSFER you can set correctly the field NEW_ITEM-MATGROUP, which will be mapped to Prod.Cat.

Best Regards,

Tamá

[Former Member]

Hi,

I suppose that the result is going to be a SC without product ID (only description/price,... you download from the catalog via OCI). In that case you could try to implement your logical in BBP_CATALOG_TRANSFER BADI I think you have there all you need

I hope this help you

BR