PUR_IOT_NOTIF

Transparent Table Application Table
31 Fields 1 CDS Views

Trigger for IoT Situations

PUR_IOT_NOTIF is an SAP database table in S/4HANA. Trigger for IoT Situations. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_IotSituationTrigger view from BASIC Trigger for IOT based situations

Fields (31)

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
salesorder vbeln_va Sales Document
salesorderitem posnr_va Item
salesorderitemuniqueid guid_32 GUID 16
purchaseorder ebeln Purchasing Doc.
purchaseorderitem ebelp Item
purchaseorderitemuniqueid purchasingdocumentitemuniqueid Document Item
customerid kunnr Customer
customer_name bu_nameor1 Name 1
material matnr Material
material_description iot_material_description Material Description
delivery vbeln_vl Delivery
delivery_item posnr_vl Item
hu_id exidv Handling Unit
erdat erdat Created On
erzet erzet Time
sensorunit iot_sensor_unit Sensor Unit
actualvalue iot_sensor_value Sensor Value
thresholdvalue iot_sensor_threshold Sensor Threshold
warehouse /scwm/lgnum Warehouse No.
storage_location lgort_d Location
longitude snwd_long Longitude
latitude snwd_lat Latitude
plant werks_d Plant
hu_handle guid_32 GUID 16
responsible iot_responsible Responsible
threshold_desc iot_sensor_threshold_desc Threshold Desc.
situation_category iot_situation_category Situation Category

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 for IoT Situations
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PUR_IOT_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]
    SALESORDER,                 -- Sales Document [vbeln_va]
    SALESORDERITEM,             -- Item [posnr_va]
    SALESORDERITEMUNIQUEID,     -- GUID 16 [guid_32]
    PURCHASEORDER,              -- Purchasing Doc. [ebeln]
    PURCHASEORDERITEM,          -- Item [ebelp]
    PURCHASEORDERITEMUNIQUEID,  -- Document Item [purchasingdocumentitemuniqueid]
    CUSTOMERID,                 -- Customer [kunnr]
    CUSTOMER_NAME,              -- Name 1 [bu_nameor1]
    MATERIAL,                   -- Material [matnr]
    MATERIAL_DESCRIPTION,       -- Material Description [iot_material_description]
    DELIVERY,                   -- Delivery [vbeln_vl]
    DELIVERY_ITEM,              -- Item [posnr_vl]
    HU_ID,                      -- Handling Unit [exidv]
    ERDAT,                      -- Created On [erdat]
    ERZET,                      -- Time [erzet]
    SENSORUNIT,                 -- Sensor Unit [iot_sensor_unit]
    ACTUALVALUE,                -- Sensor Value [iot_sensor_value]
    THRESHOLDVALUE,             -- Sensor Threshold [iot_sensor_threshold]
    WAREHOUSE,                  -- Warehouse No. [/scwm/lgnum]
    STORAGE_LOCATION,           -- Location [lgort_d]
    LONGITUDE,                  -- Longitude [snwd_long]
    LATITUDE,                   -- Latitude [snwd_lat]
    PLANT,                      -- Plant [werks_d]
    HU_HANDLE,                  -- GUID 16 [guid_32]
    RESPONSIBLE,                -- Responsible [iot_responsible]
    THRESHOLD_DESC,             -- Threshold Desc. [iot_sensor_threshold_desc]
    SITUATION_CATEGORY,         -- Situation Category [iot_situation_category]
    PRIMARY KEY (MANDT, IOT_EVENT_UUID, IOT_EVENT_TYPE, IOT_EVENT)
);

Learn More