Table for checklist Detail Info

[Former Member]

Hello All,

After getting Checklist step as follow, how to find Table fields for Partner Function, Step status, trigger... within checklist step

CRMD_ORDERADM_H -> CRMD_ORDERADM_I -> CRMD_CHKLSTAZ

Thanks in advance.

PS. I'm going to do HANA Modeling with this case.

BR,

Mike

[Former Member]

Hi,

you can use FM 'CRM_ORDER_READ' to get these details, if you need more info about this let me know.

Unfortunately I don't know the tables either, would need them myself.

Ramona

[Former Member]

Hi,

     I try another way.

     In my system configuration, I found that

     Filter: CRMD_ORDERADM_I-OBJECT_TYPE = 'BUS2000199'  first, then

     CRMD_ORDERADM_I-HEADER = CRMD_ORDERADM_H-GUID

     Then

     CRMD_ORDERADM_I-GUID = CRMD_CHKLSTAZ-GUID

     Get Partner as follow, each checklist step may have more than 1 partner

     Filter: CRMD_LINK-OBJTYPE_SET = '07' first

     CRMD_LINK-GUID_HI = CRMD_ORDERADM_I-GUID

     CRMD_LINK-GUID_SET = CRMD_PARTNER-GUID

BR,

Mike

[Former Member]

Hi Mike,

great, thanks! That is indeed getting the partners of the checklist.

Did you manage to get the rest of the fields you need? The step status you could get from table CRM_JCDS with

     CRMD_CHKLSTAZ-GUID = CRM_JCDS-OBJNR and CRM_JCDS-INACT <> 'X'

there you'll get all the statuses history and you can sort them by date and remove duplicates:

     SORT <result_table> BY <id> udate utime DESCENDING.

     DELETE ADJACENT DUPLICATES FROM <result_table> COMPARING <id>.

You can also get the status from CRM_JEST, where

     CRMD_CHKLSTAZ-GUID = CRM_JEST-OBJNR and CRM_JEST-INACT <> 'X'

I think CRM_JEST can get tricky, I got some result with more active statuses, but maybe it was just some exception/error, I don't know. That's why I also suggested CRMD_JCDS.

Thanks and regards,

Ramona