Show TOC

 Inbound Delivery Item

 

This virtual data model provides the prerequisites for answering business questions about number of inbound deliveries as well as number, volume and weight of all inbound 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:

  • Inbound Delivery Item Current Date Query (InboundDeliveryItemCurrentDateQuery)

    It enables analysis of workload.

  • Overdue Arrival of Inbound Delivery (InbDelivItemOverdueArrivalQuery)

    It enables analysis of overdue inbound deliveries still in transit status and planned for delivery.

  • Outstanding Unloading of Inbound Delivery Item (InbDelivItemOutstandingUnloadingQuery)

    It enables analysis of inbound deliveries where all items have a goods receipt status not started and a timestamp of actual delivery.

  • Incomplete Goods Receipt of Inbound Delivery Item (InbDelivItemOustandingGRCompletionQuery)

    It enables analysis of inbound deliveries in which unloading has started while goods receipt status is not completed.

  • Incomplete Putaway Execution of Inbound Delivery Item (InbDelivItemOutstandingPtwyExecCompltnQuery)

    It enables analysis of inbound deliveries where all items have an actual goods receipt status completed with timestamp and, putaway status either not started or partially completed.

  • Average Wait Time in Yard of Inbound Deliveries (InbDelivItemCurDateAvgWaitingTimeInYardQuery)

    It enables analysis of idle time of delivery transport spent in yard after check-in and before earliest actual start of the goods receipt process. This means when, for example, the first pallet of an inbound delivery/truck has been unloaded and goods receipt has been posted.

  • Inbound Delivery Item Query (InboundDeliveryItemQuery)

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

Business Objects

These main query views are primarily built on the following business objects:

  • Inbound Delivery Item

  • Inbound Delivery Header

  • Business Partner/Location

  • Delivery Transportation Data

Measures and Attributes

For the main query view, Average Wait Time in Yard of Inbound Deliveries (InbDelivItemCurDateAvgWaitingTimeInYardQuery, the important measures are:

  • Average Yard Wait in Minutes

  • Number Of Inbound Deliveries

For all other main query views, the important measures are:

  • Item Net Weight in Display Unit (ItemNetWeightInDisplayUnit_E)

  • Item Gross Weight in Display Unit (ItemGrossWeightInDisplayUnit_E)

  • Item Volume in Display Unit (ItemVolumeInDisplayUnit_E)

  • Number of Inbound Deliveries (NumberOfInboundDeliveries)

  • Number of Inbound Delivery Items (NumberOfItems)

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

The main query view, Inbound Delivery Item Query, uses the following input parameters to specify a time interval on date and time of planned delivery.

  • Plnd Delivery Start Date (P_PlannedDeliveryStartDate)

  • Plnd Delivery End Date (P_PlannedDeliveryEndDate)

  • Plnd Delivery Start Time (P_PlannedDeliveryStartTime)

  • Plnd Delivery End Time (P_PlannedDeliveryEndTime)

  • Plnd Delivery Time Zone (P_PlannedDeliveryTimeZone)

The main query views, Inbound Delivery Item Current Date Query and Average Wait Time in Yard of Inbound Deliveries, use the following input parameters to restrict the planned and actual delivery date & time:

  • Time Zone (P_TimeZone)

  • Shift Start Time (P_ShiftStartTime)

  • Shift End Time (P_ShiftEndTime)

The main query views, Outstanding Unloading of Inbound Delivery Item, Incomplete Putaway Execution of Inbound Delivery Item, and Incomplete Goods Receipt of Inbound Delivery Item use the following input parameters to restrict the actual delivery date & time as well as actual goods receipt start date and time:

  • Time Zone (P_TimeZone)

  • Shift Start Time (P_ShiftStartTime)

  • Minutes Before Shift Start Time (P_BeforeShiftStartTimeMinutes)

  • Minutes Before Current Time (P_BeforeCurrentTimeMinutes)

The main query view, Overdue Arrival of Inbound Delivery, uses the following input parameters to restrict the planned delivery date and time:

  • Time Zone (P_TimeZone)

  • Shift Start Time (P_ShiftStartTime)

  • Minutes Before Shift Start Time (P_BeforeShiftStartTimeMinutes)

  • Minutes Before Current Time (P_BeforeCurrentTimeMinutes)

Used Tables and Views

The views of this virtual data model select data from, for example, the following tables:

  • /SCDL/DB_PROCH_I (Inbound Delivery Header)

  • /SCDL/DB_PROCI_I (Inbound Delivery Item)

  • /SCDL/DB_ADDMEAS (Additional Measures )

  • /SCDL/DB_BPLOC (Partner/Location)

  • /SCDL/DB_DATE (Date)

  • /SCDL/DB_STATUS (Status)

  • /SCDL/DB_TRANS (Transportation Data: Delivery)

Constraints

Currently, you select inbound delivery items with item category Standard Delivery Item (DLV), Pack Item (PAC) or Returns Item (RET). Refer to the section above on Filters.

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.