Fclm_Bm_Hbank_Docu1

DDL: FCLM_BM_HBANK_DOCU1 SQL: VHBANK_DOCU1 Type: view

update change document for house bank

Fclm_Bm_Hbank_Docu1 is a CDS View that provides data about "update change document for house bank" in SAP S/4HANA. It reads from 3 data sources (cdhdr, cdpos, usr21) and exposes 24 fields with key fields objectclas, objectid, changenr.

3 data source(s) 24 fields

Data Sources (3)

SourceAliasJoin Type
cdhdr _HEADER from
cdpos _ITEM inner
usr21 usr21 left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName VHBANK_DOCU1 view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
EndUserText.label update change document for house bank view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY objectclas cdhdr objectclas
KEY objectid cdhdr objectid
KEY changenr cdhdr changenr
username username
techdesc usr21 techdesc
udate udate
utime utime
ChangeDate udate
ChangeTime utime
tcode tcode
planchngnr planchngnr
change_ind change_ind
tabname tabname
tabkey tabkey
fname fname
FieldName
value_new value_new
value_old value_old
ChangeType
Client
CompanyCode
HouseBankKey
BankCountry
BankInternalId 
@AbapCatalog.sqlViewName: 'VHBANK_DOCU1'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #ORGANIZATIONAL
@EndUserText.label: 'update change document for house bank'
define view Fclm_Bm_Hbank_Docu1
  as select from    cdhdr as _HEADER
    inner join      cdpos as _ITEM on  _HEADER.objectclas = _ITEM.objectclas
                                   and _HEADER.objectid   = _ITEM.objectid
                                   and _HEADER.changenr   = _ITEM.changenr
    left outer join usr21          on usr21.bname = _HEADER.username
{
  key _HEADER.objectclas,
  key _HEADER.objectid,
  key _HEADER.changenr,
      username,
      usr21.techdesc,
      udate,
      utime,
//      concat(concat(concat(concat(substring(udate,1,4) , '-' ), substring(udate,5,2)),'-'),substring(udate,7,2)) as ChangeDate,

//      concat(concat(concat(concat(substring(utime,1,2) , ':' ), substring(utime,3,2)),':'),substring(utime,5,2)) as ChangeTime,

      udate as ChangeDate,
      utime as ChangeTime,
      tcode,
      planchngnr,
      change_ind,
      tabname,
      tabkey,
      fname,
      cast('' as abap.char(30))                                                                                  as FieldName,
      value_new,
      value_old,
      cast('' as abap.char(15))                                                                                  as ChangeType,
      substring(_HEADER.objectid,1,3 )                                                                           as Client,
      substring(_HEADER.objectid,4,4 )                                                                           as CompanyCode,
      substring(_HEADER.objectid,8,5 )                                                                           as HouseBankKey,
      substring(_HEADER.objectid,13,3 )                                                                          as BankCountry,
      substring(_HEADER.objectid,16,15 )                                                                         as BankInternalId
}
where
      _HEADER.objectclas = 'FCLM_HOUSEBANK'
  and change_ind         = 'U'

Learn More