Fclm_Bam_Doc_Chara

DDL: FCLM_BAM_DOC_CHARA SQL: VFCLMDCHARA Type: view Package: FCLM_BAM

Characteristics of Bank Account Document

Fclm_Bam_Doc_Chara is a CDS View that provides data about "Characteristics of Bank Account Document" in SAP S/4HANA. It reads from 3 data sources (klah, ksml, cabn) and exposes 8 fields with key fields mandt, clint, posnr, adzhl. Part of development package FCLM_BAM.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
klah a from
ksml b inner
cabn c inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName VFCLMDCHARA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Characteristics of Bank Account Document view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #B view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY mandt klah mandt
KEY clint ksml clint
KEY posnr ksml posnr
KEY adzhl ksml adzhl
class klah class
klart klah klart
imerk ksml imerk
atnam cabn atnam 
@AbapCatalog.sqlViewName: 'VFCLMDCHARA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Characteristics of Bank Account Document'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #B
define view Fclm_Bam_Doc_Chara as select from klah as a
inner join ksml as b on a.mandt = b.mandt and a.clint = b.clint
inner join cabn as c on a.mandt = c.mandt and b.imerk = c.atinn and b.adzhl = c.adzhl{
    key a.mandt,
    key b.clint,
    key b.posnr,
    key b.adzhl,
    a.class,
    a.klart,
    b.imerk,
    c.atnam
}

where a.class like 'SAP_FCLM%'

Learn More