VFCLM_BAM_AMD_CUR_REV

DDL: FCLM_BAM_AMDCUR_REV SQL: VFCLM_BAM_CURREV Type: view

VFCLM_BAM_AMD_CUR_REV is a CDS View in SAP S/4HANA. It reads from 2 data sources (VFCLM_BAM_DDL_AMD_CUR_F, fclm_bam_amd) and exposes 3 fields with key fields AccountID, revision.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
VFCLM_BAM_DDL_AMD_CUR_F filter inner
fclm_bam_amd header from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName VFCLM_BAM_CURREV view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY AccountID acc_id
KEY revision fclm_bam_amd revision
Currency fclm_bam_amd waers 
@AbapCatalog.sqlViewName: 'VFCLM_BAM_CURREV'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #A
@ClientHandling.algorithm: #SESSION_VARIABLE
define view VFCLM_BAM_AMD_CUR_REV
  as select from fclm_bam_amd            as header
    inner join   VFCLM_BAM_DDL_AMD_CUR_F as filter on  header.acc_id   = filter.AccountID
                                                   and header.revision = filter.revision
{
  key acc_id       as AccountID,
  key header.revision,
      header.waers as Currency
}
where
     header.status = '02'
  or header.status = '09'
  or header.status = '10'
  or header.status = '11'
  or header.status = '15';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"VFCLM_BAM_DDL_AMD_CUR_F",
"FCLM_BAM_AMD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More