how to map Vendor or Custom Schemas to Client_Product_Categories in SRM

[Chaitanya_Kumar]

HI Experts,

Could you please help me in one of my development. Currently i am working on SRM7.2 and also i am new to SRM. Could you tell me how to mapping of_Vendor or Custom Schemas to Client_Product_Categories..

  Each vendor catalog within the CatalogVendor portal decides which product category standard they will support.  Most will use the UNSPSC standard.  Client uses the product category and external material group field to categorize their purchases.  The product categories/external material group combination at Client is unique to the company and therefore it is required that the system map the vendor product categories to the Client product categories/external material group combination at the time that catalog items are brought into the SRM shopping cart. 

For this Functional people asked me to implement BBP_CATALOG_TRANSFER BADI and they created one custom Z table with fields ZSCHEMA,Material group , Catalog Material Group and External Material group fields.

Could you please explain me regarding the logic and code..

Thanks in advance..

Regards,

Kumar

[former_member216093 · Accepted solution]

Hi Kumar,

UNSPSC are the standard product categories which will be supplied to you by any vendor and these need to be mapped to client specific product categories.

Note: My assumption is that your client hasn't got the vendor specific product categories in SRM which they don't want to mix. This is fair assumption for any system.

In this case, create a Z table mapping all UNSPSC categories to client specific product categories available within SRM system. You can use all categories (local & replicated) for this mapping.

Once this table is complete, implement BBP_CATALOG_TRANSFER BADI. This will be called when user is creating the shopping cart using vendor catalog (or punchout) and with the help of this table you can change the vendor's UNSPSC category into client specific product category.

Don't forget to create transaction for this Z table so that business can maintain this Z table going further. Also, business can just give vendors the UNSPSC version they are using currently so that vendor send the catalog with that version.

Note: Please don't forget to award points as appropriate.

Regards,

Ravi

[Former Member · Accepted solution]

I would like to ask a quick question about this.  I believe I understand what is said here.  Create a ztable with 3 columns 1. schema 2. catalog product category 3. SRM product category.

Do we need to add vendor # as well?  Also if a punchout catalog supplier isn't using a schema then we would just need to leave that column blank correct?

Thanks,

Jeff