Get CRM Case details from follow up task activity

[Former Member]

Hi all,

I have created a follow up task from a CRM Case.

Now, in the task, and thru code, I am trying to get the details of the "parent" CRM Case.

I tried thru some relations that I saw in the task in debug mode, but no luck.

Also, I tried with the Task GUID in the CRM_ORDER_READ, ubt I cannot get the Case details or GUID from there...

Any idea on how can I solve this?

Thanks and kind regards,

Guillermo

[Former Member]

Hi all,

Does anyone can help with this question please?

Thanks in advance.

Kind regards,

Guillermo

[robert_kunstelj]

Relationships are usualy writen in docflow. You can use function CRM_DOC_FLOW_READ_OB to read doc flow tables. I'm not sure how Case and Activity are linked, but linkes between sales transactions are definitely available throu this function. Check it out if it helps.

Regards.

[Former Member]

Hi, thanks for replying.

Yes, I thought the same. That's why I used the CRM_ORDER_READ to get the docflow. But I'm not getting any data with that.

Unfortunately I also don't get any data with CRM_DOC_FLOW_READ_OB FM. I also tried the *_DB one.

Any idea ?

Probably some missconfiguration?

Can I get the ingormation thru DB tables?

Thanks in advance.

Kind regards,

Guillermo

[robert_kunstelj]

You can try checking tables in se16 by using CRMCMG keywords.

[Former Member]

Hello again Robert,

I already checked those tables, but couldn't find any relation table.

I am kind of desperate about this.

Cannot belive how is not that intuitive to get it, as with some other Business Objects.

Any other idea?

Thanks in advance again,

Guillermo

[robert_kunstelj]

Try sing select statement from scmg_case_attr & crmd_cmg_case_at tables.

Also check the following blog: