I_ADM_LOGHIST

DDL: I_ADM_LOGHIST SQL: IADMLOGHIST Type: view

swwloghist

I_ADM_LOGHIST is a CDS View that provides data about "swwloghist" in SAP S/4HANA. It reads from 3 data sources (swwfbatext, swwloghist, I_BusinessUserBasic) and exposes 20 fields with key fields WiId, Method, MethEdate, MethEtime, LogCount. It has 1 association to related views.

3 data source(s) 20 fields

Data Sources (3)

SourceAliasJoin Type
swwfbatext meth_text left_outer
swwloghist swwloghist from
I_BusinessUserBasic User left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ADM_LOGHIST _parent _parent.entry_node_id = $projection.entry_parent_id

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName IADMLOGHIST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label swwloghist view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY WiId swwloghist wi_id
KEY Method swwloghist method
KEY MethEdate swwloghist meth_edate
KEY MethEtime swwloghist meth_etime
KEY LogCount swwloghist log_count
PersonFullNameendasAgent
chi_logkey
par_logkey
workarea swwloghist workarea
message swwloghist message
variable1 swwloghist variable1
variable2 swwloghist variable2
variable3 swwloghist variable3
variable4 swwloghist variable4
clientNULLasmeth_edate_time
log_count swwloghist log_count
meth_user swwloghist meth_user
msgtype swwloghist msgtype
fb_text swwfbatext fb_text
_parent _parent 
@AbapCatalog.sqlViewName: 'IADMLOGHIST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'swwloghist'
define view I_ADM_LOGHIST
  as select from    swwloghist
    left outer join swwfbatext as meth_text on  meth_text.fb_name  = swwloghist.method
                                            and meth_text.language = $session.system_language
    left outer join I_BusinessUserBasic as User on swwloghist.meth_user = User.UserID                                        
  association [0..*] to I_ADM_LOGHIST as _parent on _parent.entry_node_id = $projection.entry_parent_id
{
  key swwloghist.wi_id                                          as WiId,
  key swwloghist.method                                         as Method,
  key swwloghist.meth_edate                                     as MethEdate,
  key swwloghist.meth_etime                                     as MethEtime,
  key swwloghist.log_count                                      as LogCount,
      CONCAT(swwloghist.wi_id, bintohex(swwloghist.chi_logkey)) as entry_node_id,
      case when swwloghist.par_logkey != hextobin('00000000000000000000000000000000')
        then CONCAT(swwloghist.wi_id, bintohex(swwloghist.par_logkey))
        end                                                     as entry_parent_id,
      case when User.PersonFullName is null or User.PersonFullName is initial
       then swwloghist.meth_user
       else User.PersonFullName
       end                                   as Agent,
      bintohex(swwloghist.chi_logkey)                           as chi_logkey,
      bintohex(swwloghist.par_logkey)                           as par_logkey,
      swwloghist.workarea,
      swwloghist.message,
      swwloghist.variable1,
      swwloghist.variable2,
      swwloghist.variable3,
      swwloghist.variable4,
      DATS_TIMS_TO_TSTMP(swwloghist.meth_edate,swwloghist.meth_etime,
                     abap_system_timezone($session.client, 'NULL'),
                     $session.client,
                     'NULL')                                    as meth_edate_time,
      swwloghist.log_count,
      swwloghist.meth_user,
      swwloghist.msgtype,
      meth_text.fb_text,
      _parent
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSUSERBASIC",
"SWWFBATEXT",
"SWWLOGHIST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More