Outbound Delivery Order Query

You can use this feature to perform the warehouse outbound operational analysis to determine the number, volume, and weight of the outbound delivery order items.

Technical Name

C_EWM_OutbDelivOrdQ

View Type

Consumption

Release Status

Released

Purpose

This CDS view provides the prerequisites for answering the following business questions:

  • How many open outbound delivery order items are there for picking?

  • How many open outbound delivery order items are there for different activity areas?

  • How many outbound delivery order items have been shipped on each transportation route?

  • What is the weight or volume of the outbound delivery order items to be loaded?
  • How long has the good issue of the outbound delivery order items been delayed?
  • Which top three customers are most affected by the delayed goods issue?

  • How many open outbound delivery order items are there where the goods issue is overdue?
  • How many outbound delivery order items are blocked in picking for different document types?

  • How are the open outbound delivery order items spread according to the planned goods issue time?

Prerequisites

  • You have authorization to access certain plants.
  • You have written redundant header and item data for inbound deliveries and outbound delivery orders in Customizing for Extended Warehouse Management under Start of the navigation pathBusiness Add-Ins (BAdIs) for Extended Warehouse Management Next navigation step Cross-Process Settings Next navigation step Delivery - Warehouse Request Next navigation step BAdI: Writing Redundant Header and Item Data for DeliveriesEnd of the navigation path.

  • For the outbound delivery orders that you created before the system upgrade, you have used the Redundant Header and Item Data for Outbound Delivery Order (/SCDL/ODO_CDS_RED_UPD) report to write redundant header and item data of those outbound delivery orders into the databases.

Structure

Business Objects
  • Outbound Delivery Order Item

  • Outbound Delivery Item

  • Outbound Delivery Order Header

  • Business Partner/Location

  • Delivery Transportation Data

Main input parameters

The main input parameters for this view are as follows:

  • P_Language

    This parameter specifies the system language. The default value is the logon language.

  • P_WarehouseNumber

    This parameter specifies the warehouse number.

  • P_PlannedGIStartDate

    This parameter specifies the start date of the planned goods issue.

  • P_PlannedGIStartTime

    This parameter specifies the starte time of the planned goods issue. The default value is 000000.

  • P_PlannedGIEndDate

    This parameter specifies the end date of the planned goods issue.

  • P_PlannedGIEndTime

    This parameter specifies the end time of the planned goods issue. The default value is 235959.

Measures and attributes

Some important measures and attributes are as follows:

  • Measures:
    • AverageGoodsIssueDelayMinutes

      This measure calculates the average delayed time of goods issue for outbound delivery order items.

  • Attributes:
    • WrhsTmznPlndGIStrtDateTime

      This attribute displays the planned goods issue time or date of outbound delivery order items.

    • WrhsTmznActlGIStrtDateTime

      This attribute displays the actual goods issue time or date of outbound delivery order items.

    • IsOverdue

      This attribute tells whether the goods issue of outbound delivery order items is overdue or not.

Constraints

You select outbound delivery order items with the following characteristics:

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

• Goods issue status is not Not Relevant