cancel
Showing results for 
Search instead for 
Did you mean: 

SRM Master data - Punchout catalogue category mapping to SRM Category

Former Member
0 Kudos

Hi ,

How to map the Punchout catalogue category to SRM Category?

Thanks & Regards,

Rameshwar.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

hi Rameshwar,

BBP_CATALOG_TRANSFER   
ZBBP_CATALOG_TRANS

Method
Implemented:
 
ENRICH_ITEM_DATA

Programming Logic

Need to create a Z table which contains the mappings and reference this in the Badi coding

  1. Get data from Table ‘YZWEBID_OCI’ on the basis of Catalog ID
    (IS_ADMIN_DATA-CATALOGID)
  2. If data is found then pass ‘LS_WEBID_OCI-ZOCIFLD’ for further
    processing
  3. If data is found not then check for the data maintained ( YZWEBID
    =  ‘*’ in  ‘YZWEBID_OCI’ )  for further processing.
  4. Get Data from ‘ZUPC_MAT’ which will have the UNSPSC code mapped to
    Material Group.
  5. Get the field data from ‘WA_CATALOG_CONTENT’ field which is mapped in
    the table ‘ZWEBID_OCI’.
  6. If UNSPSC code is BLANK then Error message  is raised for
    Validation.
  7. Get the Product Category ID for the UNSPSC code filtering from table
    ‘YZUPC_MAT’ with the following Logic.
  8. Get Category GUID from ‘COMM_CATEGORY’ on the basis of
    Category Fetched from above logic and pass it to ENRICHED_ITEM_DATA-CATEGORY

Custom table as below :


 

Material Group


 

 

UNSPSC


 

 

Logic


 

 

14


 

 

14111701


 

 
  1. Mat.gr. '14' is only mapped if the UNSPSC exactly matches '14111701'
 

 

27


 

 

2711150*


 

 
  1. Mat.gr. '27' is mapped for any UNSPSC between 27111500 and 27111509,
      unless there is a more specified mapping available.
 

 

32


 

 

321016*


 

 
  1. Mat.gr. '32' is mapped for any UNSPSC between 32101600 and 32101699,
      unless there is a more specified mapping available.
 

 

39


 

 

39111*


 

 
  1. Mat.gr. '39' is mapped for any UNSPSC between 39111000 and 39111999,
      unless there is a more specified mapping available.
 

 

40


 

 

4010*


 

 
  1. Mat.gr. '40' is mapped for any UNSPSC between 40100000 and 40109999,
      unless there is a more specified mapping available.
 

 

41


 

 

411*


 

 
  1. Mat.gr. '41' is mapped for any UNSPSC between 41100000 and 41199999,
      unless there is a more specified mapping available.
 

 

42


 

 

42*


 

 
  1. Mat.gr. '42' is mapped for any UNSPSC between 42000000 and 42999999,
      unless there is a more specified mapping available.
 

 

43


 

 

4*


 

 
  1. Mat.gr. '43' is mapped for any UNSPSC between 40000000 and 49999999,
      unless there is a more specified mapping available.
 

 

22


 

 

*


 

 
  1. Mat.gr. '22' is mapped for any UNSPSC that does not have a more specified
      mapping available.
 

Thanks and regards,

Krishna

jason_boggans
Active Contributor
0 Kudos

Hi,

SRM allows for external category mapping if you are using the predefined category types like UNSPSC etc, you can load these schemas to the system and use the customizing to map the external categories to internal ones, alternatively you can simply use the Badi BBP_CATALOG_TRANSFER to map the category passed from the catalog to the SRM system successfully, for this you should create a Z table which contains the mappings and reference this in the Badi coding, you should also make sure you clean the table et_messages of the error related to category mapping in the Badi to ensure the value of the category is not replaced again after Badi is exited.

Regards,

Jason

Former Member
0 Kudos

Hi Rameshwar,

We have a custom development done for handling such scenario-

Let me explain what are we handling and how?

The material group coming from Puchout catalog/ catalog provider may not exists in SRM as it does not exists in ERP. So it is not replicated and not available in SRM.

To handle such material group mismatch, we map the catalog provided material group to the material group which could be mapped from ERP with the help of central purchasing.

This mapping is maintained in the below customized table based on Catalog id and Logical system.

Product cat is coming from CATALOG and Category is in SRM to which it is mapped.

Let me tell you about the program -

If you need coding logic, I would share. However, this is the logic we use to get the mapping done.

Hope this information helps you.

Thanks

From RBEI,

Snehal