Show TOC

 SAP HANA Live for Event Management

 

This virtual data model provides measures and attributes for analyzing deliveries and their time dependencies and the overall reporting performance. It provides the prerequisites for answering the following business questions:

  • How many of my deliveries are delayed based on event proof of delivery (POD)? (sap.hba.em.DelayedCompletedDeliveriesQuery)

  • How many of my current deliveries that are in transit are delayed? (sap.hba.em.DelayedInTransitDeliveriesQuery)

  • What percentage of my transports are delayed? (sap.hba.em.DelayedDeliveriesPercentageQuery)

  • What is the average delay of deliveries that arrived with a delayed POD? (sap.hba.em.AverageCycleTimeOfDlydCmpltdDeliveriesQuery)

  • What is the typical cycle time of deliveries that arrived late at their destinations? (sap.hba.em.AverageCycleTimeQuery)

  • What are the common or standard average cycle times for my completed deliveries? (sap.hba.em.AverageCycleTimeQuery)

  • How good is my reporting compliance? (sap.hba.em.OnTimeReportingComplianceQuery)

  • How good is my reporting completeness? (sap.hba.em.ReportingCompletenessQuery)

This VDM is part of the SAP Event Management visibility scenario Deliveries in LTL_Shipment, (less than truck load delivery).

Structure

To support the reports listed above, the structure of this view hierarchy contains the following groupings of views:

  • Delays of Deliveries: delays of deliveries in transit or those that arrived at customer sites with an overdue proof of delivery (POD)

    This group of views consists of the following main query views:

    • Delayed Deliveries (POD) - (DelayedCompletedDeliveriesQuery)

    • Delayed Deliveries (Total) - (DelayedDeliveriesPercentageQuery)

    • Delayed Deliveries (in Transit) - (DelayedInTransitDeliveriesQuery)

    • Average Delay Time (POD) - (AverageDelayCompletedDeliveriesQuery)

  • Average Cycle Times: average cycle times (time between the actual event dates and times of: when picking begins, PICKBEG, and the last event POD)

    This group of views consists of the following main query views:

    • Avg. Cycle Time Delayed Deliveries POD - (AverageCycleTimeOfDlydCmpltdDeliveriesQuery)

    • Avg. Cycle Time of Deliveries - (AverageCycleTimeQuery)

  • Reporting: reporting compliance and completeness – what percentage of transports were reported and how accurate were those reports?

    This group of views consists of the following main query views:

    • Reporting Compliance (OnTimeReportingComplianceQuery)

    • Reporting Completeness (ReportingCompletenessQuery)

The structure of this view hierarchy consists of the following main reuse views, which you can find in package sap.hba.em:

  • AverageCycleTimeOfDelayedCompletedDeliveries.calculationview (Average Cycle Time Of Delayed Completed Deliveries)

  • AverageCycleTimeOfDlydCmpltdDeliveriesDetailQuery.calculationview (Average Cycle Time Of Delayed Completed Deliveries Detail Query)

  • AverageCycleTimeOfDlydCmpltdDeliveriesQuery.calculationview (Average Cycle Time Of Delayed Completed Deliveries Query)

  • AverageCycleTimeQuery.calculationview (Average Cycle Time Query)

  • AverageDelayCompletedDeliveries.calculationview (Average Delay Completed Deliveries)

  • AverageDelayCompletedDeliveriesDetailQuery.calculationview (Average Delay Completed Deliveries Detail Query)

  • AverageDelayCompletedDeliveriesQuery.calculationview (Average Delay Completed Deliveries Query)

  • DelayedCompletedDeliveries.calculationview (Delayed Completed Deliveries)

  • DelayedCompletedDeliveriesDetailQuery.calculationview (Delayed Completed Deliveries Detail Query)

  • DelayedCompletedDeliveriesQuery.calculationview (Number of delayed Deliveries (LTL_DELIV-scenario) that are completed)

  • DelayedDeliveriesPercentageDetailQuery.calculationview (Delayed Deliveries Percentage Detail Query)

  • DelayedDeliveriesPercentageQuery.calculationview (Delayed Deliveries Percentage Query)

  • DelayedInTransitDeliveries.calculationview (Delayed In Transit Deliveries)

  • DelayedInTransitDeliveriesDetailQuery.calculationview (Delayed In Transit Deliveries Detail Query)

  • DelayedInTransitDeliveriesQuery.calculationview (Delayed In Transit Deliveries Query)

  • EHControlParametersForDelivery.calculationview (EH Control Parameters For Delivery)

  • EHExpectedEventsForDelivery.calculationview (EH Expected Events For Delivery)

  • EHInfoParametersForDelivery.calculationview (EH Info Parameters For Delivery)

  • EventAndMessageStatusText.calculationview (Event And Message Status Text)

  • EventHandlerCycleTimeForDelivery.calculationview (Event Handler Cycle Time For Delivery)

  • EventHandlerHeaderForDelivery.calculationview (Event Handler Header For Delivery)

  • EventHandlerStatusForDelivery.calculationview (Event Handler Status For Delivery)

  • EventHandlerStatusText.calculationview (Event Handler Status Text)

  • EventHandlerTypeText.calculationview (Event Handler Type Text)

  • OnTimeReportingCompliance.calculationview (On Time Reporting Compliance)

  • OnTimeReportingComplianceQuery.calculationview (On Time Reporting Compliance Query)

  • ReportingCompleteness.calculationview (Reporting Completeness)

  • ReportingCompletenessQuery.calculationview (Reporting Completeness Query)

Business Objects

These views are built on the following business objects:

  • Event Handler

  • Event Message

Measures and Attributes

Some important measures and attributes are:

  • Arrived Deliveries with Overdue or Delayed POD (DelayedCompletedDeliveriesQuery)

    • measure: TotalNumberOfDeliveries

    • attributes: DeliveryStatus, Delivery, ProofOfDeliveryLocation, EventStatusProofOfDelivery, EventMsgStatusProofOfDelivery, ProofOfDeliveryYear, ProofOfDeliveryQuarter, and ProofOfDeliveryMonth

  • Delayed Deliveries Percentage (In Transit and Arrived vs. All Deliveries) (DelayedCompletedDeliveriesQuery)

    • measure: DelayedDeliveriesPercentageQuery

    • attributes: DelayedDeliveriesPercent, TotalNumberOfDeliveries, TransportationStatus, and DeliveryStatus

  • In-Transit Deliveries with DELAY-Status or Overdue POD (DelayedInTransitDeliveriesQuery)

    • measure: TotalNumberOfDeliveries

    • attributes: DeliveryStatus, Delivery, EventStatusProofOfDelivery, EventMsgStatusProofOfDelivery, ProofOfDeliveryYear, ProofOfDeliveryQuarter, ProofOfDeliveryMonth, ShippingType, and ShipmentType

  • Average POD Delay for Arrived Deliveries (AverageDelayCompletedDeliveriesQuery)

    • measures: AverageDelayInHours, TotalNumberOfDeliveries

    • attributes: DeliveryStatus, Delivery, EventStatusProofOfDelivery, EventMsgStatusProofOfDelivery, ProofOfDeliveryYear, ProofOfDeliveryQuarter, and ProofOfDeliveryMonth

  • Average Cycle Time of Completed Deliveries with Delayed POD (AverageCycleTimeOfDlydCmpltdDeliveriesQuery)

    • measures: AverageCycleTimeInHours, NumberOfDlydCmpltdDeliveries, ShipmentCycleTimeInHours

    • attributes: DeliveryStatus, Delivery, ProofOfDeliveryYear, ProofOfDeliveryQuarter, ProofOfDeliveryMonth, PickingBeginLocation, ProofOfDeliveryLocation, PickingBeginCountry ProofOfDeliveryCountry, PickingBeginCity, and ProofOfDeliveryCity

  • Average Cycle Time of all Deliveries Completed (AverageCycleTimeQuery)

    • measures: AvgShipmentCycleTimeInHours, TotalNumberOfDeliveries, ShipmentCycleTimeInHours

    • attributes: Delivery, PickingBeginLocation, ProofOfDeliveryLocation, PickingBeginCountry, ProofOfDeliveryCountry, PickingBeginCity, and ProofOfDeliveryCity

  • On-Time Event Reporting Compliance (OnTimeReportingComplianceQuery)

    • measures: OnTimeEventMessagesInPercent, NumberOfExpectedEvents, NumberOfDelayedEventMessages

    • attributes: TransportationStatus, EventCode, EventMessageStatus, EventLocation, EventCountry, and CityName

  • Event Reporting Completeness (ReportingCompletenessQuery)

    • measures: ReportedEventsPercent, NumberOfExpectedEvents, NumberOfReportedEvents

    • attributes: TransportationStatus, EventCode, EventMessageStatus, EventLocation, EventCountry, and CityName

Filters

The views use the following central filter, valid for all views:

  • event handler type (EventHandlerType=LTL_DELIV)

Used Tables and Views

The views select data from the following tables:

  • /SAPTRX/EH_HDR (Event Handler Header Table)

  • /SAPTRX/EH_STAT (Event Handler Status Table)

  • /SAPTRX/EH_INFO (Event Handler Info Parameters Table)

  • /SAPTRX/EH_CNTRL (Event Handler Control Parameters Table)

  • /SAPTRX/EH_EXPEV (Event Handler Expected Events Table)

  • /SAPTRX/EHTYPET (Event Handler Types Text Table)

  • /SAPTRX/STCODET Event Handler Status Attribute Code Text Table()

  • DD07T (Texts for Domain Fixed Values)

Constraints

Currently, no reuse views are shipped.

Related Virtual Data Models

There are no related virtual data models.