SAP ME Database | Resource Status Log Vs. Resource Time Log | Differences

[former_member826251]

Dear SAP ME Community,

In SAP ME database we can find two different tables

• RESOURCE_STATUS_LOG
• RESOURCE_TIME_LOG

both seem to log the resource status events. Unfortunately, some resource statuses are only stored in the RESOURCE_STATUS_LOG and some only in the RESOURCE_TIME_LOG database table.

For that reason, we have following questions.

1) What are the differences of both tables? (from conceptional perspective)

2) When will be a resource status be insert/ stored in

a. RESOURCE_STATUS_LOG

b. RESOURCE_TIME_LOG

3) Which table should be used to analyses resource status “unscheduled down”?

4) Which data table is the source in the ME OEE POD?

Thank you for your support

Best regards

[sergiy_katerinich]

Hi!

RTL was in the old implementation. Later SAPME was enhanced for OEE - this is how RSL appeared in the system.

Potentially, there could be non-OEE related (old) functionalities which write to RTL but not to RSL.

But for OEE-related functionalities, all necessary information is expected to be retrieved from (and previously written to) RSL table.

RTL and RTM are mainly designed for the old Resource Utilization Report and Time-Based Component Traceability.

Regards,

Sergiy