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...