How to link a dispute case and its log?

[Former Member]

Hello Experts,

We need to identify a link between a dispute case and it's

log in order to report information from table SRMPROTOCOL (log table).

Specifically, we are trying to link table SCMG_T_CASE_ATTR (dispute case table) & field

CASE_GUID with table SRMPROTOCOL & field POID_ID. It is not clear how

these tables are linked. Is there another table I can use to obtain

this link?

Any help will be greatly appreciated!

Thanks,

Sal

[Former Member]

Hi,

We can use the BAPI 'BAPI_CASE_READLOG" for reading the log information related to a Dispute Case.

The import parameters for this FM are

GUID = This is the Case GUID

START_DATE = This is the start date from which we need to read the log entries, Optional parameter

END_DATE = This is the end date to which we need to read the log entries, Optional parameter

MAX_ENTRIES = This is the max number of log entries to be read, Optional parameter

We can get the log entries from the table parameter of the FM LOG_ENTRIES.

Hope this helps you !!!

Regards,

Ganga

[Former Member]

Thanks Ganga, this FM will work for us.

[Former Member]

Hi, the solution is good especially when looking for log data for a single case record.

The issue however comes when doing the same query for +- 100 000 case records, like I have in my requirement, it actually times out. What I've figured out is that BAPI_CASE_READLOG eventually reads table SRMPROTOCOL and the missing link I have right now is to link tables SRMPROTOCOL and SCMG_T_CASE_ATTR.

Any advice?

[Rodolpho_Lopes]

Sorry for bumping this up, but maybe it could help somebody else that don't have developer access.

To link SMCG_T_CASE_ATTR and SRMPROTOCOL you need to get the field SCMG_T_CASE_ATTR-EXT_KEY and link with the number inside the brackets at the end of of the field SRMPROTOCOL-DISPLAY_NAME.