Query - CRM Activities

[Former Member]

Hi Experts,

We're trying to create a query, but we cannot bring the field Reason about CRM Activities (Contact - BUS2000126) - we want that to come besides other Contact fields and informations as 'direction'; 'partner'; transaction number, description,. but the problem is that it does not make part of table 'CRMD_ORDERADM_H' and 'CRMD_ACTIVITY_H'.

We have still found table 'QPCD' (Reason) that have this information but we were not able to bring information related to fields 'CODE'; 'CODEGRUPPE' and 'KATALOGART'.

We already tried with CRMD_SRV_SUBJECT alongwith tables QPCT, CRMC_CODEMAPMSA and also CRMD_ACTIVITY_H, but the with no query results about Join.

Would that be a problem that we don't have the right table or it's realted to the join type that must exist between these tables? Hope anyone can give us a direction on this...

Best Regards,

Fábio