LOHUM_SIT_NOTIF

Transparent Table Application Table
15 Fields 1 CDS Views

Trigger Table for HU Situations

LOHUM_SIT_NOTIF is an SAP database table in S/4HANA. Trigger Table for HU Situations. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_HndlgUnitSituationTrigger view_entity from BASIC HU Situation Trigger

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY iot_event_uuid iot_event_uuid UUID of an IoT event
KEY iot_event_type iot_event_type IOT event type
KEY iot_event iot_event ID of an IoT event
hu_id exidv Handling Unit
warehouse /scwm/lgnum Warehouse No.
hu_handle lo_hu_hu_uuid_char32 UUID
creation_date erdat Created On
creation_time erzet Time
measured_value lohum_sensor_quantity Sensor Value
threshold_value lohum_sensor_quantity Sensor Value
sensor_unit lohum_sensor_quantity_unit Sensor Unit
sensor_iso_unit isocd_unit ISO Code
longitude snwd_long Longitude
latitude snwd_lat Latitude

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Trigger Table for HU Situations
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LOHUM_SIT_NOTIF (
    MANDT,            -- Client [mandt]
    IOT_EVENT_UUID,   -- UUID of an IoT event [iot_event_uuid]
    IOT_EVENT_TYPE,   -- IOT event type [iot_event_type]
    IOT_EVENT,        -- ID of an IoT event [iot_event]
    HU_ID,            -- Handling Unit [exidv]
    WAREHOUSE,        -- Warehouse No. [/scwm/lgnum]
    HU_HANDLE,        -- UUID [lo_hu_hu_uuid_char32]
    CREATION_DATE,    -- Created On [erdat]
    CREATION_TIME,    -- Time [erzet]
    MEASURED_VALUE,   -- Sensor Value [lohum_sensor_quantity]
    THRESHOLD_VALUE,  -- Sensor Value [lohum_sensor_quantity]
    SENSOR_UNIT,      -- Sensor Unit [lohum_sensor_quantity_unit]
    SENSOR_ISO_UNIT,  -- ISO Code [isocd_unit]
    LONGITUDE,        -- Longitude [snwd_long]
    LATITUDE,         -- Latitude [snwd_lat]
    PRIMARY KEY (MANDT, IOT_EVENT_UUID, IOT_EVENT_TYPE, IOT_EVENT)
);

Learn More