Table Linking Activities with Activity Journal

[former_member196521]

Hello All,

I need to know the table link between the activity number and the details like material code, material description which is stored in the activity journal of the transaction type.

Kind Regards

Atul

[Former Member]

Hi,

Not sure what you mean but you can check the following tables :

CRMD_ORDERADM_H (Header for documents)

CRMD_ORDERADM_I (Items for documents)

CRMD_ACTIVITY_H (Activity header)

CRMD_ACTIVITY_I (Activity items)

Regards,

Benoît

[former_member196521]

Hi Benoit,

Thanks for the prompt reply, I have a transaction type where I have configured activity journals, in the activity journal I have entered my material no, I need to get the table link between my activity number and the material no.

I am attaching a screen shot for your reference, the first screen shot pertains to attaching the product code in the activity journal assignment block

The second screen shot pertains to entering the material code

I need to know the table link between the activity number and the product id, the above tables which you gave do not store the product details, hence please advice further.

Kind Regards

Atul

[Former Member]

Hello,

Then use report CRM_ORDER_READ to read your activity and see where is the data you need, then you should find the table (or you can ask)

Benoît

[former_member196521]

Hi Benoit,

Thanks for the prompt reply, appreciate the same, I did check the report CRM_ORDER_READ, however could not find the table link, could you please advice further with screen shots.

Kind Regards

Atul

[Former Member]

Hello,

Did you find the data in the result of the report ? Tell me where...

[former_member196521]

Hi Benoit,

The answer to your query is no, I could not find the link to activity journals in the report mentioned by you.

Kind Regards

Atul

[former_member196521]

Hi Benoit,

Found the table link to the same

In table CRMD_ORDERADM_h pass the activity no you will get the guid no

Pass this Guid No in the table CRMD_ORDERADM_I field header, you will get the product details from the field ordered_prod

For getting the qty following needs to be done

After passing the guid in the CRMD_ORDERADM_I field, header, you will get guid no from the guid field

Pass this Guid no in the table crmd_product_i, field guid , the qty will be fetched from the field process_qty_num

Kind Regards

Atul