PUR_IOT_NOTIF - Trigger for IoT Situations

Trigger for IoT Situations information is stored in SAP table PUR_IOT_NOTIF.
It is part of development package APPL_MM_PUR_IOT in software component MM-PUR-GF-SIT. This development package consists of objects that can be grouped under "Integration for Leonardo IoT".

Fields for table PUR_IOT_NOTIF

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
IOT_EVENT_UUIDUUID of an IoT eventXIOT_EVENT_UUIDCHAR72
IOT_EVENT_TYPEIOT event typeXIOT_EVENT_TYPECHAR60
IOT_EVENTId of an IoT eventXIOT_EVENTNUMC40
SALESORDERSales DocumentVBELN_VACHAR20
SALESORDERITEMSales Document ItemPOSNR_VANUMC12
SALESORDERITEMUNIQUEIDGUID in 'CHAR' Format in UppercaseGUID_32CHAR64
PURCHASEORDERPurchasing Document NumberEBELNCHAR20
PURCHASEORDERITEMItem Number of Purchasing DocumentEBELPNUMC10
PURCHASEORDERITEMUNIQUEIDConcatenation of EBELN and EBELPPURCHASINGDOCUMENTITEMUNIQUEIDCHAR30
CUSTOMERIDCustomer NumberKUNNRCHAR20
CUSTOMER_NAMEName 1 of organizationBU_NAMEOR1CHAR80
MATERIALMaterial NumberMATNRCHAR80
MATERIAL_DESCRIPTIONMaterial DescriptionIOT_MATERIAL_DESCRIPTIONCHAR80
DELIVERYDeliveryVBELN_VLCHAR20
DELIVERY_ITEMDelivery ItemPOSNR_VLNUMC12
HU_IDExternal Handling Unit IdentificationEXIDVCHAR40
ERDATDate on which the record was createdERDATDATS16
ERZETEntry timeERZETTIMS12
SENSORUNITUnit the IOT sensor measuresIOT_SENSOR_UNITUNIT6
ACTUALVALUEValue from SensorIOT_SENSOR_VALUECHAR20
THRESHOLDVALUESensor ThresholdIOT_SENSOR_THRESHOLDCHAR20
WAREHOUSEWarehouse Number/Warehouse Complex/SCWM/LGNUMCHAR8
STORAGE_LOCATIONStorage locationLGORT_DCHAR8
LONGITUDEEPM: LongitudeSNWD_LONGDEC8
LATITUDEEPM: LatitudeSNWD_LATDEC8
PLANTPlantWERKS_DCHAR8
HU_HANDLEGUID in 'CHAR' Format in UppercaseGUID_32CHAR64
RESPONSIBLEIoT Responsible for SituationIOT_RESPONSIBLECHAR60
THRESHOLD_DESCThreshold DescriptionIOT_SENSOR_THRESHOLD_DESCCHAR80
SITUATION_CATEGORYCustom Situation Category in IoTIOT_SITUATION_CATEGORYCHAR20
Privacy Policy