P_IAMSUPPORTUSERLOG

CDS View

IAM: Support User Request Log (Private View)

P_IAMSUPPORTUSERLOG is a CDS View in S/4HANA. IAM: Support User Request Log (Private View). It contains 13 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 13 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_IAMSupportUserRequestLog view_entity from BASIC Support User Request Log

Fields (13)

KeyField CDS FieldsUsed in Views
KEY UUID CAMSupportUserRequestUUID 1
AbaBname CAMSuppAddedAuthorizationUser 1
AbaMode CAMSuppAddedAuthorizationMode 1
AccessCategory CAMSupportAccessCategory 1
AccessLevelID CAMSupportAccessLevel 1
Bname CAMSupportUser 1
IncidentID CAMSupportIncident 1
IncidentNumber CAMSupportIncidentTicketNumber 1
IncidentSystemNumber CAMSupportIncidentSystemNumber 1
IncidentSystemType CAMSupportIncidentSystem 1
IncidentYear CAMSupportIncidentTicketYear 1
RequestedAt CAMSuppUserValdtyStartDateTime 1
ValidTo CAMSuppUserValdtyEndDateTime 1 
@AbapCatalog.dataMaintenance: #DISPLAY_ONLY
@VDM.viewType: #BASIC
@VDM.private: true

define view entity P_IAMSUPPORTUSERLOG
  as select from aps_iam_a_susr
{
  key uuid                                  as UUID,
      requested_by                          as RequestedBy,
      requested_at                          as RequestedAt,
      request_id                            as RequestID,
      bname                                 as Bname,
      access_type                           as AccessType,
      access_level_id                       as AccessLevelID,
      aba_mode                              as AbaMode,
      aba_bname                             as AbaBname,
      incident_id                           as IncidentID,
      incident_src                          as IncidentSrc,
      incident_type                         as IncidentType,
      incident_system_type                  as IncidentSystemType,
      incident_system_number                as IncidentSystemNumber,
      incident_number                       as IncidentNumber,
      incident_year                         as IncidentYear,
      valid_to                              as ValidTo,
      cast ( case
        when access_type = 'ADM'   then 'OP' -- Operations
        when access_type = 'SUP'   and ( incident_type = 'SN_CS'  or incident_type = 'BCP_CUS' ) then 'CU' -- Customer Support
        when access_type = 'SUP'   and ( incident_type = 'SN_HCI' or incident_type = 'BCP_HCI' ) then 'HC' -- Health Check Support
        when access_type = 'LOCAL' then 'EM' -- Emergency Support
        when incident_type is initial then
          case -- Fallback for old logic if there is no incident_type
            when access_type = 'SUP'   and incident_src is initial then 'OT'
            when access_type = 'SUP'   and incident_src is not initial and incident_src <> '020' and incident_src <> 'spc' then 'CU'
            when access_type = 'SUP'   and incident_src is not initial and ( incident_src = '020' or incident_src = 'spc' ) then 'HC'
            else 'OT'
          end
        else 'OT' -- Other (SAP Internal Support)
      end as aps_iam_susr_access_category ) as AccessCategory
}

Learn More