SAC and Maintenance Events

[DeannaMarch]

Hi all, 

I'm very new to SAP so please excuse me if i've posted this in the wrong area or I use the wrong terminology (my background is SQL and .Net amongst other things).

My company needs me to look into creating a series of dashboards for them using SAC.  The problem I keep facing is locating the pieces of data I require to present on the dashboard.  Two specific examples are:

1. I need to be able to show Maintenance Orders and their Maintenance Event assignment (from Planning Buckets) - we want to ensure compliance.  While I can retrieve the maintenance order and operation details just fine, I have not been able to locate a data source that will give me the Event they have been allocated to.  In the "Find Maintenance Orders and Operations" app that information is readily available.

2. I need to be able to show which Maintenance Orders belong to which Planner Group.  Now while I can get hold of the Planner Group code, I actually want the Planner Group name.  I can't for the life of me identify where I can retrieve this information!

Might anybody be able to point me in the right direction?  I'm going around in circles and it is very trial and error.

We are using the S4 HANA Public Cloud edition.

[Chris1973]

Hi DeannaMarch

You are welcome to SAP. Hope this information is still relevant for you.

Since you are on S/4HANA Public Cloud, you can leverage the released CDS views (data sources) and the SAP-delivered SAP Analytics Cloud (SAC) integration content to get the fields you need.

1. Maintenance Orders with Maintenance Event assignment

• The app Find Maintenance Orders and Operations is based on the released CDS view I_MaintenanceOrderOperation and related views.
• The Event assignment (from Planning Buckets) is available in I_MaintenanceEventAssignment and linked via order/operation keys.
• For SAC, you can either:
• Use these released CDS views directly in a custom analytical data set (via Custom CDS Views app), or
• Consume the pre-delivered Analytics API (OData): API_MAINTENANCEORDER_0001 (Maintenance Order API) and join it with the event assignment view.

1. Planner Group Name instead of Code

• The Planner Group code is in I_MaintenanceOrder.
• To get the Planner Group name, you need to join with I_WorkCenterPersonResponsible or I_ResourcePlannerGroup (released CDS views that provide description texts).
• This can be modelled in a Custom CDS View (association between order à planner group à description) and then exposed to SAC.

Here is how to proceed in Public Cloud:

1. Use the View Browser app to search for released CDS views:
• Search terms: MaintenanceOrder, PlannerGroup, MaintenanceEvent.
2. Create a Custom CDS View (join the required sources).
3. Expose it as an Analytical Data Source → then connect SAC to it.

The following references will provide further details

Released CDS Views for Analytics (Public Cloud)

Custom CDS Views App

I am happy to help if you have further questions.

Best regards

Chris

[Egbert_de_Jong]

@Chris1973 - we have a weird case of a workorder we can not assign to a planningbucket/maintenance event. althought the planning plants are exactly the same it keeps on throwing up errors. You know the rootcause or even more important - solution for that? we already looked at WO header & FLOC and all seems fine. thanks in advance! 

[Chris1973]

Hi @Egbert_de_Jong 

considering this is a new question. I suggest raising a new one in the community. so you can be adequately supported.

Best regards

Chris

[Egbert_de_Jong]

@Chris1973 fair point - we already found the rootcause for our issue btw. When not adding a maintenance event code (enter through) SAP4HANA Public cloud automatically adds the first row in the event table 0000001 in our case. that event was already assigned to a different planning bucket with a different plant and with that causing conflicts. creating/assigning duplicate values should not be possible in first place in my view. also field should be mantatory. but maybe we are missing something in our config and the standard is fine