Tables for Multilevel Categorization selected in the Transactions

[Former Member]

Hello guys,

We are using CRM 2007 IC Web Client. I have set up Multilevel Categorization with 2 levels for Service Orders

Level 1: Motivo

Level 2: Central

When creating a Service Order, I choose both Level 1 and Level 2. And I want to know in which table I can find the both Levels I selected for each Service Order. I mean, I do not need the table with the categories (which I customized in the Rule Modeler)....I need the transactional table where I can find the Service Order ID and the Levels which were selected.

I performed a trace and I found a the table CRMD_SRV_SUBJECT. However it only shows me the Level 2 for each Service Order and this has some logic because if I check in the GUI (by using transaction CRMD_ORDER) the service order I created in the IC Web, it only shows me One Level and it corresponds to the Level 2.

I hope you can help me!

Many thanks in advance!

Pablo

[saumya_govil]

Hi Pablo,

Check the following table in order:

CRMD_LINK

CRMD_SRV_OSSET

CRMD_SRV_SUBJECT

Also check tables QPCT and QPGT for category textx.

Also check the following [link|; for further help.

Hope this helps!

Regards,

Saumya

[former_member187281]

Thanks Saumya ... still valid your answer.

[Former Member]

Hi Pablo

Here is a list of all Categorization tables:

CRMC_ERMS_CAT_HI (Hierarchy)

CRMC_ERMS_CAT_CT (Category Descriptions)

CRMC_ERMS_CAT_OK (Subject code mapping to Schema)

Other Schema Tables:

CRMC_ERMS_CAT_AA

CRMC_ERMS_CAT_AB

CRMC_ERMS_CAT_AD

CRMC_ERMS_CAT_AL

CRMC_ERMS_CAT_AS

CRMC_ERMS_CAT_AT

CRMC_ERMS_CAT_CA

CRMC_ERMS_CAT_CD

CRMC_ERMS_CAT_CL

CRMC_ERMS_CAT_DT

CRMC_ERMS_CAT_DV

CRMC_ERMS_CAT_IC

CRMC_ERMS_CAT_ID

CRMC_ERMS_CAT_IN

CRMC_ERMS_CAT_LB

CRMC_ERMS_CAT_LN

CRMC_ERMS_CAT_LT

CRMC_ERMS_CAT_PA

CRMC_ERMS_CAT_PT

CRMC_ERMS_CAT_QU

CRMC_ERMS_CAT_SC

CRMC_ERMS_CAT_SP

CRMC_ERMS_CAT_ST

Hope this helps

Rupesh

[Former Member]

Hello together, I have a very basic question. I found out, that it is possible to use multi-level categorization without assigning a catalog (subject profile)? If we have to use a catalog than the IC Manager needs IT department to create the catalog and subjet profiles first so he depends on certain release dates. If not he could create multi-level categorization by himself...so anyone knows here anything?

BR/

[Former Member]

Hi Pablo,

You answered the question yourself. Re-read your quote from the CR410 material.

You have to read the customising from the value stored in the service ticket to get the other levels. If you do a trace in the webclient you weill find that SAP does this as well.

Cheers

Andrew

[Former Member]

Hi Andrew, thanks for your reply!

Yes, I agree with you! The point is that I should tell the Abap guy the table from where to get those two levels (cause we need a development which depends on these data) And when I read the trace I found that the system only makes "Select" but it does not store the upper (first) level anywhere (although I found that the second level is stored in CRMD_SRV_SUBJECT table.

Would you please give me some more details? Because i do not know how to do what you mentioned me.

Many thanks in advance!

Pablo

[Former Member]

Hi Pablo,

The table CRMD_SRV_SUBJECT stores only the last level chosen on the UI in the service order. For example, if the last level you have chosen is level 3, then it would store the code for level 3.

I am not sure which version you using, but in CRM 2007 there are some classes, specific to the UI, with which you can determine all the four levels chosen.

I dont think there is any particular table which stores all the four levels. We have a similar requirement in our project and we solved it using the UI classes.

Regards,

Shwetha

[Former Member]

Hi Shwetha, thanks for your reply! I am using CRM 2007 IC Web Client. Would you please extend a bit more? How can I get those values?

Many thanks,

Pablo

[former_member217922]

Hi Shwetha,

I have a similiar requirement where I need determine all categorization levels from a service order for a development. Could you share which UI classes have you used?

Regards,

Heber Olivar

[Former Member]

hi there

go to transaction code se38

run program crm_order_read

under the subject structure, you will have your cat_id - this will contain the code for your last level selected.

using this code, you can get the parent of this code - which is the level above it. how do you do this? tale CRMC_ERMS_CAT_Hi contains all the parent for a give selected code: in this case your last level. use table CRMC_ERMS_CAT_CA to get the cat_guid for the cat_id in the subject structure.

[former_member187066]

Hi Pablo,

Please use below function module to get all levels of Categorization

SELECT SINGLE subject_profile

          FROM  crmc_activity_h             " fully buffered table

          INTO  lv_subject_profile

          WHERE process_type = 'Z010'.

IF sy-subrc = 0.

*         Get catalog, code group etc

   CALL FUNCTION 'CRM_SUBJECT_PROF_CODES_PROVIDE'

     EXPORTING

       i_subject_profile = lv_subject_profile

       i_langu           = sy-langu

     TABLES

       e_code_tab        = lt_codes

     EXCEPTIONS

       no_valid_entry    = 1

       no_entry          = 2

       OTHERS            = 3.

Regards

Abdul Rasheed

[Former Member]

Hello Rupesh and Saumya, many thanks for your quick replies.

However they do not solve my question.

Rupesh, those tables that you mentioned are useful to see what I customize in the Rule Modeler with the IC_MANAGER Business Role. I need the transactional table where I can find all the two Levels values that I selected for each Service Order.

Saumya, as I mentioned in the question posted, we have already been able to reach table CRMD_SRV_SUBJECT. The problem is that the table only shows me the LAST Level I chose in the IC Web when creating the Service Order. In our case Level 2 (as we only need 2 Levels).

I have just read in the CR410 manual and it says the following which is the cause why I only see the Level 2 in the CRMD_SRV_SUBJECT table:

"In the IC WebClient the categories can be selected to categorize a transaction. However the categories are only visible in the service ticket in the IC WebClient UI. They are not directly sotred in the service ticket. When the ticket is saved the Catalog/Code Group/ Code of the lowest selected category is stored on the database. The categories are linked via the hierarchy of the category modeler to the codes and thus to the ticket"

Any suggestions?

Many thanks for your help!

Pablo