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).
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)
Currently, no reuse views are shipped.
There are no related virtual data models.