Show TOC

 Outbound Delivery Item

 

This virtual data model provides the prerequisites for answering business questions about number of outbound deliveries as well as number, volume and weight of the outbound delivery order items and or outbound delivery items, which can be grouped by day, week and month to, for example, fine-tune the shift schedule, optimize and balance number of workers, or also request budget for equipment.

Structure

To support the analysis possibilities indicated above, this virtual data model consists of the following main query views:

  • Outbound Delivery Item Current Date Query (OutboundDeliveryItemCurrentDateQuery)

    It enables analysis of workload.

  • Outbound Delivery Item Current Time Query (OutboundDeliveryItemCurrentTimeQuery)

    It enables analysis during workload planning and execution monitoring.

  • Outbound Delivery Item Current Date GI Delay Query (OutboundDeliveryItemCurrentDateGIDelayQuery)

    It enables analysis during execution monitoring of average delay on post goods issue.

  • Outbound Delivery Item Query (OutboundDeliveryItemQuery)

    It enables analysis on static time interval longer than a day.

Business Objects

These views are primarily built on the following business objects:

  • Outbound Delivery Order Item

  • Outbound Delivery Item

  • Outbound Delivery Order Header

  • Business Partner/Location

  • Delivery Transportation Data

Measures and Attributes

For the main query views, Outbound Delivery Item Current Date Query (OutboundDeliveryItemCurrentDateQuery), Outbound Delivery Item Current Time Query (OutboundDeliveryItemCurrentTimeQuery) and Outbound Delivery Item Query (OutboundDeliveryItemQuery, the important measures are:

  • Item Gross Weight in Display Unit (ItemGrossWeightInDisplayUnit_E)

  • Item Net Weight in Display Unit (ItemNetWeightInDisplayUnit_E)

  • Item Volume in Display Unit (ItemVolumeInDisplayUnit_E)

  • Number of Outbound Delivery Orders (NumberOfOutboundDeliveryOrders)

  • Number of Outbound Delivery Order Items (NumberOfItems)

For the main query view, Outbound Delivery Item Current Date GI Delay Query (OutboundDeliveryItemCurrentDateGIDelayQuery), the important measures are:

  • Number of Outbound Delivery Orders (NumberOfOutboundDeliveryOrders)

  • Number of Outbound Delivery Order Items (NumberOfItems)

  • Average Goods Issue Delay in Minutes (AverageGoodsIssueDelayMinutes)

This virtual data model covers important attributes, such as, warehouse, warehouse process type and completion status.

Filters

The main query views all use the following variables:

  • Client

  • Warehouse

  • Completion Status

  • Warehouse Process Type

In addition to the above, the main query view, Outbound Delivery Item Current Time Query (OutboundDeliveryItemCurrentTimeQuery) uses the variable, Picking Status.

To specify a time interval on start date and time of goods issue, the main query views use the following input parameters:

  • For the Outbound Delivery Item Current Date Query view:

    • Time Zone (P_TimeZone)

    • Shift Start Time (P_ShiftStartTime)

    • Shift End Time (P_ShiftEndTime)

  • For the Outbound Delivery Item Current Time Query view:

    • Time Zone (P_TimeZone)

    • Shift Start Time (P_ShiftStartTime)

    • Minutes Before Shift Start Time (P_BeforeShiftStartTimeMinutes)

    • Minutes After Current Time (P_AfterCurrentTimeMinutes)

  • For the Outbound Delivery Item Current Date GI Delay Query view:

    • Time Zone (P_TimeZone)

    • Shift Start Time (P_ShiftStartTime)

    • Shift End Time (P_ShiftEndTime)

  • For the Outbound Delivery Item Query view:

    • Plnd GI Time Zone (P_PlannedGITimeZone)

    • Plnd GI Start Date (P_PlannedGIStartDate)

    • Plnd GI End Date (P_PlannedGIEndDate)

    • Plnd GI Start Time (P_PlannedGIStartTime)

    • Plnd GI End Time (P_PlannedGIEndTime)

Used Tables and Views

The views select data from, for example, the following tables:

  • /SCDL/DB_PROCI_O (Outbound Delivery Order Item)

  • /SCDL/DB_ADDMEAS (Additional Measures )

  • /SCDL/DB_BPLOC (Partner/Location)

  • /SCDL/DB_DATE (Date)

  • /SCDL/DB_DLVI_O (Outbound Delivery Item)

  • /SCDL/DB_PROCH_O (Outbound Delivery Order Header)

  • /SCDL/DB_STATUS (Status)

  • /SCDL/DB_TRANS (Transportation Data: Delivery)

Constraints

Currently, you select outbound delivery order items and or outbound delivery items with:

  • Item categories Standard Delivery Item (DLV) or Returns Item (RET)

  • Goods issue status not equal to Not Relevant (DGI <> ‘0’)

This represents a temporary built-in filter in all four main query views.

More Information

In the SAP HANA Studio Modeler, you can automatically generate a PDF document listing in detail the technical Virtual Data Model features. For more information about the auto documentation function, see Auto Documentation..

For more information about working with the views, see the Administrator’s Guide for SAP HANA Live 1.0 on the SAP Help Portal at http://help.sap.com/hbaInformation published on SAP site, under Start of the navigation path Master, Installation, Security, Configuration, and Operations Information Next navigation step Administrator’s Guide End of the navigation path.