Interaction Record Data Model

[Former Member]

Can someone please give me the list of tables for the Interaction Record? Like Interaction Record data model. For example, all the tables including BP, products, description of the interaction record.

[Former Member]

Thank you for your help! Is there a interaction record table that contain the BP and product for that specific interaction record. I can find most of the information of the IC through CRMD_ORDERADM_H and CRMD_ORDERADM_I, but I still need the BP and product information that asscociated with the specific interaction record. I need to export a flat file to a database that we need to write reports on the interaction record information.

[BGarcia]

Hello Donna,

The product information associated to Interaction Record, you can find it in CRMD_ORDERADM_I table. Just insert your document GUID in field HEADER, and it will display all items of that document including the product GUID (PRODUCT field). Then you can check in COMM_PRODUCT, for master data information about any product. You can also consult CRMD_PRODUCT_I for more information about product items of your document.

The partner information it is a little more complex. View CRMV_LINKPARTNER will show you how to get it. It envolves two tables: CRMD_LINK and CRMD_PARTNER. With your document GUID, you must consult CRMD_LINK with attributes OBJTYPE_HI = '05' and OBJTYPE_SET = '07'. Then, with GUID_SET of that entry, you must indicate it in table CRMD_PARTNER at field GUID. Hit execute and it will display your partner information.

Kind regards.

Bruno

[BGarcia]

Hello Donna,

You can find all information about interaction records header and item information (as well other documents) at CRMD_ORDERADM_H and CRMD_ORDERADM_I tables respectivily.

You can see partner tables relationship with documents, by studying the view CRMV_LINKPARTNER.

The master data tables for business partners and products are BUT000 and COMM_PRODUCT.

Kind regards.

Bruno