Interaction Record

[Former Member]

Hi,

I wanted to understand how Interaction records are stored in the CRM Database.

Which functions modules I can use to retrieve the interaction record based on certain parameters like :

1. Purchase Order Number

2. Case Number

3. Contact Number etc.

You appreciate if anyone can help me here.

Regards,

AP

[Former Member]

Hi.

Use program CRM_ORDER_READ to get all the informations assigned to your interaction record.

Regards,

Susana Messias

[Former Member]

You need to know what document type you are using for the interaction record. We use a copy of the S1 which has header and line item details.

It is going to be a transaction, so the header table CRMD_ORDERADM_H is a good starting place.

you may want to look at logical db CRMLDB_SERVICE_MON used in SQ02 to create infosets for reporting.