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