SAP 凭证更改日志查询(表：cdpos cdhdr)

实例：查询SO “拒绝原因” 修改日志。 SO:2600000057

CDS如下

 

@AbapCatalog.sqlViewName: 'ZVRSD001_002'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'SO修改系统日志'
define view ZVRSD001_DDL_002
  as select from cdpos as a
    inner join   cdhdr as b on  a.mandant = b.mandant
                            and a.objectclas = b.objectclas
                            and a.objectid   = b.objectid
                            and a.changenr   = b.changenr
{
  a.mandant,
  a.objectid,
  a.tabkey, --MANDT+VBELN+POSNR
  a.fname,
  b.username,
  b.udate,
  b.utime
}
where
      a.tabname = 'VBAP'
  and a.chngind = 'U'
  and a.fname   = 'ABGRU'; 

注意点：每次修改都会产生日志记录，如果实际业务需要获取最新的一条修改日志，需要对日期和时间进行排序，然后筛选