outbound delivery order cds query for sap smart business

How-To Guide

Document Version: 1.0 – 2018-12-04

CUSTOMER

Outbound Delivery Order CDS Query for SAP SmartBusiness in S/4HANA CloudWarehouse Management

2CUSTOMER© 2013 SAP AG or an SAP affiliate company. All rights reserved.

Outbound Delivery Order CDS Query for SAP Smart Business in S/4HANA CloudTypographic Conventions

Typographic Conventions

Type Style Description

Example Words or characters quoted from the screen. These include field names, screen titles,pushbuttons labels, menu names, menu paths, and menu options.Textual cross-references to other documents.

Example Emphasized words or expressions.

EXAMPLE Technical names of system objects. These include report names, program names,transaction codes, table names, and key concepts of a programming language when theyare surrounded by body text, for example, SELECT and INCLUDE.

Example Output on the screen. This includes file and directory names and their paths, messages,names of variables and parameters, source text, and names of installation, upgrade anddatabase tools.

Example Exact user entry. These are words or characters that you enter in the system exactly asthey appear in the documentation.

<Example> Variable user entry. Angle brackets indicate that you replace these words and characterswith appropriate entries to make entries in the system.

EXAMPLE Keys on the keyboard, for example, F2 or ENTER .

Outbound Delivery Order QueryDocument History

CUSTOMER© 2013 SAP AG or an SAP affiliate company. All rights reserved. 3

Document History

Version Date Change

1.0 <2018-12-04> First official release of this guide

4CUSTOMER© 2013 SAP AG or an SAP affiliate company. All rights reserved.

Outbound Delivery Order CDS Query for SAP Smart Business in S/4HANA CloudTable of Contents

Table of Contents

1 Business Scenario....................................................................................................................5

2 Background Information......................................................................................................... 6

3 Prerequisites ............................................................................................................................7

4 One Example with Step-by-Step Procedure ...........................................................................84.1 Create KPI and Report .......................................................................................................................... 8

4.1.1 Create Group ......................................................................................................................... 84.1.2 Create KPI.............................................................................................................................. 94.1.3 Create Report ....................................................................................................................... 114.1.4 Create Application ...............................................................................................................13

4.2 Publish Application to Business Catalog............................................................................................14

Business ScenarioCustomer Customer

© 2013 SAP AG or an SAP affiliate company. All rights reserved. 5

1 Business Scenario

In S/4HANA Cloud, Core Data Service (CDS) views of outbound delivery orders are delivered by standard. Onyour side, key users can configure the KPIs through SAP Smart Business based on these CDS views and assignthe KPIs to related end users.For more information about the configuration steps about configuring KPIs based on CDS views, see the helpdocument of the Manage KPIs and Reports app.

Release InformationIn S/4HANA Cloud 1902, two CDS views are released: C_EWM_OutbDelivOrdQ andC_EWM_OutbDelivOrdNoDateQ.

Differences Between Two Released ViewsThe major difference is that for CDS view C_EWM_OutbDelivOrdQ, you must enter the specific start/end date,but not for CDS view C_EWM_OutbDelivOrdNoDateQ. However, for CDS view C_EWM_OutbDelivOrdNoDateQ,you must specify the offset days. For example, if you set an offset day as '0', it means you show the outbounddelivery orders whose planned goods issue date is today. If you set an offset day as '-1', it means you show thecontent of yesterday.

KPIsThe following KPIs are supported in these two CDS views in S/4HANA:· Number of outbound delivery orders· Number of outbound delivery order items· Total gross weight of outbound delivery order items· Total Net Weight of outbound delivery order items· Total Volume of outbound delivery order items· Average Delay Time in Minutes

Dashboard of CDS ViewsWith the two CDS views, you can generate a dashboard by creating tiles via SAP Smart Business.And here is one example of one dashboard configured by these two CDS view:

https://help.sap.com/viewer/788fa4c7585e415187e347e904010cee/1811.500/en-US/c00cbf7fe8464663aee830fb6e7eec13.html

6Customer Customer© 2013 SAP AG or an SAP affiliate company. All rights reserved.

Outbound Delivery Order CDS Query for SAP Smart Business in S/4HANA CloudBackground Information

2 Background Information

This document provides one example about how to configure KPIs via SAP Smart Business for outbound deliveryorder query CDS views. There is some explanation about the details of these two CDS views, for example, thebusiness meaning of the import parameters.

PrerequisitesCustomer Customer


3 Prerequisites

You must have the business role SAP_BR_ANALYTICS_SPECIALIST to configure the KPI tiles in the SAP Fiorilaunchpad.


Outbound Delivery Order CDS Query for SAP Smart Business in S/4HANA CloudOne Example with Step-by-Step Procedure

4 One Example with Step-by-Step Procedure

Before you start the following configurations using SAP Smart Business, you must know the type of KPI that youwant to configure and the type of CDS view that can satisfy your requirements. Besides, you must know how todisplay this KPI on the launchpad and the related drill-down formats for this KPI.This document provides an example about how to use CDS view C_EWM_OutbDelivOrdNoDateQ to configureKPIs for end users to check the number of outbound delivery items that are planned for goods issue today. In thisexample, the KPI is shown on the launchpad with the total number of outbound delivery items using drill-down ofplanned goods issue in hours.

4.1 Create KPI and Report

The key user performs the following configuration steps in this chapter using the Manage KPIs and Report app.

4.1.1 Create Group

To create a group, perform the following actions:1. Open the Manage KPIs and Report app.2. Choose the KPI button.3. Choose the Group tab.4. Choose the Add button.5. On the new screen, enter the title No. of ODO Items Example, and keep the value of proposed ID.

One Example with Step-by-Step ProcedureCustomer Customer


6. Click button Activate.For more information about creating groups, see Group in Smart Business.

4.1.2 Create KPI

This step is the key step for the KPI configuration in SAP Smart Business. In this step, select the CDS view andrelated measure, and enter the parameters for the view selection.

To do this, perform the following actions:1. Open the Manage KPIs and Report app.2. Choose the KPI button.3. Choose the KPIs tab.4. Choose the Add button and the group No. of ODO Items Example.

In the header area, enter the title of the new KPI No. of ODO Items KPI Example as the screenshotbelow.

5. On the same screen, in the Data Source Details area, choose the Define button to define a datasource.Enter the following data and choose OK button:

o CDS View: C_EWM_OUTBDELIVORDNODATEQo OData Service: use F4 for the value helpo Entity Set: use F4 for the value help

https://help.sap.com/viewer/788fa4c7585e415187e347e904010cee/1811.500/en-US/c00cbf7fe8464663aee830fb6e7eec13.html



6. On the same screen, maintain the input parameters:o Warehouse: <your warehouse>o Offset Day for Start Date: 0o Start Time: 00:00:00o Offset Day for End Date: 0o End Time: your shift start time e.g. 23:59:59o Picking Lead Time in Minutes: 60o Loading Lead Time in Minutes: 60o GI Lead Time in Minutes: 60o Weight Unit: KGo Volume Unit: M3

Noteo The offset day 0 means today.

By this offset day and start/end time, the system only displays the outbound delivery items whoseplanned goods issue is today.The parameters Picking Lead Time in Minutes, Loading Lead Time in Minutes and GI Lead Time inMinutes are used to calculate whether the related outbound delivery items are overdue in the future.For example, the current time is 9 a. m. and one outbound delivery item is planned to be goods issuedat 10 a.m. today. Plus, for this item, the picking lead time in minutes is 30; loading lead time inminutes is 40; and GI lead time in minutes is 50. For this outbound delivery item, the whole outboundprocess is not started yet.



If your warehouse starts to process this outbound delivery item now, it will take around 120 minutes tofinish whole outbound process that includes 30+40+50 minutes. This outbound delivery item will befinished at 11 a.m. Therefore, this item will be calculated as overdue item.These 3 parameters are only useful when you want to generate a KPI for the overdue outbounddelivery item. In this example KPI, these three parameters are not helpful. Therefore, even though youkeep these values, they don't have any effects on the KPI.

o The parameter Weight Unit is only used when an end user chooses the value measure Total GrossWeight of ODO Items or Total Net Weight of ODO Items.

o The parameter Volume Unit is only used when an end user chooses the value measure Total Volumeof ODO Items.

o You can choose the Adapt Filter button to add more filters as input parameter.For example, if the KPI is number of unfinished outbound delivery item, you can add completionstatus into the filter and assign value Not Equal to 9 - Complete.

7. On the same screen, in Semantics area, select the value measure Number of ODO Items.

NoteThis measure determines how to measure the results of the CDS query. For CDS viewC_EWM_OUTBDELIVORDNODATEQ, different measures are available for use.

8. Choose the Activate button.

4.1.3 Create Report

You can use this step to configure the drill-down page of the KPI. If you don't need the drill-down of the KPI, or youwant to navigate to other Fiori views from Smart Business KPI Tile, you can skip this step.In the following example, you create one drill-down chart view for the KPI No. of Outbound Delivery Items:

1. Open the Manage KPIs and Report app.2. Choose the Report button.3. Choose the Add button and Generic Drilldown button.4. Select the KPI No. of ODO Items KPI Example.5. Choose the Configuration tab, and the Add View button.



6. In Add View popup, enter By Planned GI Hour, keep the value of view ID, and select the view typeChart. Then, choose the Add button.

7. Choose the Settings button. On the popup window, select the Column Chart and select dimensionPlanned GI Start Hour in Whse TmZn.

8. Choose the Activate button.



4.1.4 Create Application

In this step, you create an application using the KPI and define its UI format.You perform the following actions:

1. Open the Manage KPIs and Report app.2. Choose the KPI button.3. Choose the KPIs tab.4. Choose the KPI No. of ODO Item KPI Example.5. Choose Visualize tab and Add Tile button.6. Select the numeric tile and enter all the mandatory fields.

Here the tile and subtitle will display in the launchpad. For more details about other fields like SematicObject, see Create an Application.

7. Choose the Save button.

https://help.sap.com/viewer/788fa4c7585e415187e347e904010cee/1811.500/en-US/d077433113684c3fa3fbf882252bb12a.html



4.2 Publish Application to Business Catalog

In this step, you publish the KPI to the business catalog of the end users. Then, the end users can find this KPI tilein their own launchpad.To do this, perform the following actions:

1. Open the Custom Catalog Extensions app.2. Choose the application No. of Outbound Delivery Items that you created in previous step and choose

the Add button.3. Choose the business catalog for the new tile and choose the OK button.4. Choose the new added business catalog and choose the Publish button.

Now, you have finished all configuration steps. And the new tile is available for the related end users who areassigned to the business catalog.End users can add this tile to the Home via App Finder on the Fiori launchpad. And the new tile on the UI looks likebelow:

Inside the tile, the drill-down looks like the screenshot shown below:

www.sap.com/contactsap

Material Number

© 2013 SAP AG or an SAP affiliate company. All rights reserved.No part of this publication may be reproduced or transmitted in anyform or for any purpose without the express permission of SAP AG.The information contained herein may be changed without priornotice.Some software products marketed by SAP AG and its distributorscontain proprietary software components of other softwarevendors.National product specifications may vary.These materials are provided by SAP AG and its affiliatedcompanies (“SAP Group”) for informational purposes only, withoutrepresentation or warranty of any kind, and SAP Group shall not beliable for errors or omissions with respect to the materials. The onlywarranties for SAP Group products and services are those that areset forth in the express warranty statements accompanying suchproducts and services, if any. Nothing herein should be construed asconstituting an additional warranty.SAP and other SAP products and services mentioned herein as wellas their respective logos are trademarks or registered trademarks ofSAP AG in Germany and other countries. Please seewww.sap.com/corporate-en/legal/copyright/index.epx#trademarkfor additional trademark information and notices.

http://www.sap.com/corporate-en/legal/copyright/index.epx#trademark

outbound delivery order cds query for sap smart business

Documents