FCLM_BAM_AMD_FOR_DPP

DDL: FCLM_BAM_AMD_FOR_DPP SQL: VFCLMDPP Type: view

BAM AMD view for DPP

FCLM_BAM_AMD_FOR_DPP is a CDS View that provides data about "BAM AMD view for DPP" in SAP S/4HANA. It reads from 2 data sources (fclm_bam_amd, fclm_bam_rev) and exposes 8 fields.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
fclm_bam_amd header from
fclm_bam_rev rev left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName VFCLMDPP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label BAM AMD view for DPP view

Fields (8)

KeyFieldSource TableSource FieldDescription
acc_id fclm_bam_amd acc_id
revision fclm_bam_amd revision
acc_num fclm_bam_amd acc_num
bank_contact fclm_bam_amd bank_contact
rel_manager fclm_bam_amd rel_manager
status fclm_bam_amd status
rev_status fclm_bam_rev rev_status
deleted_flag fclm_bam_amd deleted_flag 
@AbapCatalog.sqlViewName: 'VFCLMDPP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'BAM AMD view for DPP'
define view FCLM_BAM_AMD_FOR_DPP
  as select from    fclm_bam_amd as header
    left outer join fclm_bam_rev as rev on  header.acc_id   = rev.acc_id
                                        and header.revision = rev.revision
{
  header.acc_id,
  header.revision,
  header.acc_num,
  header.bank_contact,
  header.rel_manager,
  header.status,
  rev.rev_status,
  header.deleted_flag
}
where
     header.bank_contact <> ''
  or header.rel_manager  <> '' 


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCLM_BAM_AMD",
"FCLM_BAM_REV"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More