R_HndlgUnitSituationTrigger

DDL: R_HNDLGUNITSITUATIONTRIGGER Type: view_entity BASIC
14 Fields 1 Data Sources

HU Situation Trigger

R_HndlgUnitSituationTrigger is a Basic CDS View that provides data about "HU Situation Trigger" in SAP S/4HANA. It reads from 1 data source (lohum_sit_notif) and exposes 14 fields with key fields IotEventUUID, IotEventType, IotEvent.

Data Sources (1)

SourceAliasJoin Type
lohum_sit_notif lohum_sit_notif from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label HU Situation Trigger view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY IotEventUUID iot_event_uuid UUID of an IoT event
KEY IotEventType iot_event_type IOT event type
KEY IotEvent iot_event ID of an IoT event
HandlingUnitExternalID hu_id Handling Unit
Warehouse warehouse Warehouse No.
HandlingUnitIDChar32 hu_handle UUID
SensorMeasuredQuantity measured_value Sensor Value
SensorThresholdQuantity threshold_value Threshold Value
UnitOfMeasureSAPCode sensor_unit Sensor Unit
UnitOfMeasureISOCode sensor_iso_unit ISO Code
Longitude longitude Longitude
Latitude latitude Latitude
LastChangeDate creation_date Time Stamp
LastChangeTime creation_time Time Stamp

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_HndlgUnitSituationTrigger.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_HndlgUnitSituationTrigger AS
SELECT
  iot_event_uuid AS IotEventUUID,
  iot_event_type AS IotEventType,
  iot_event AS IotEvent,
  hu_id AS HandlingUnitExternalID,
  Warehouse,
  hu_handle AS HandlingUnitIDChar32,
  measured_value AS SensorMeasuredQuantity,
  threshold_value AS SensorThresholdQuantity,
  sensor_unit AS UnitOfMeasureSAPCode,
  sensor_iso_unit AS UnitOfMeasureISOCode,
  Longitude,
  Latitude,
  creation_date AS LastChangeDate,
  creation_time AS LastChangeTime
FROM lohum_sit_notif
;

Learn More