FCLM_BAM_T012K_BASE

CDS View

Base view for V_T012K_BAM_DDL

FCLM_BAM_T012K_BASE is a CDS View in S/4HANA. Base view for V_T012K_BAM_DDL. It contains 21 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 21 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
FCLM_BAM_T012K view_entity from T012K Compatibility View V2
I_JointVentureCashCallFDP view left_outer COMPOSITE CDS View for Cash Call OCF
SHSM_T012K view from CDS View replacing T012K in search help
V_T012k_DDL view from T012K Compatibility View

Fields (21)

KeyField CDS FieldsUsed in Views
KEY bukrs bukrs 3
KEY hbkid hbkid 3
KEY hktid hktid 3
abwae abwae 2
bankn BankAccount,bankn 3
bkont bkont 2
bnkn2 bnkn2 2
dtaai dtaai 2
fdgrp fdgrp 2
hbid1 hbid1 2
hbid2 hbid2 2
hkid1 hkid1 2
hkid2 hkid2 2
hkont hkont 2
mandt mandt 1
mindt mindt 2
refzl refzl 2
waers waers 2
wekon wekon 2
wikon wikon 2
wkkon wkkon 2 
@AbapCatalog.sqlViewName: 'V_T012K_BASE'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.serviceQuality: 'C'
@ObjectModel.usageType.sizeCategory: 'M'
@ObjectModel.usageType.dataClass: 'MASTER'
@EndUserText.label: 'Base view for V_T012K_BAM_DDL'
define view FCLM_BAM_T012K_BASE
  as select from FCLM_BAM_DISTINCT_HBA as distinct_hba
    inner join   fclm_bam_aclink2      as hba on  hba.acc_id    = distinct_hba.acc_id
                                              and hba.valid_to  = distinct_hba.valid_to
                                              and hba.bukrs     = distinct_hba.bukrs
                                              and hba.hbkid     = distinct_hba.hbkid
                                              and hba.hktid     = distinct_hba.hktid
                                              and hba.is_reused = ''
                                              and hba.herku     = ''
                                              and hba.revision  = '0000'
    inner join   fclm_bam_amd          as acc on  acc.acc_id   = hba.acc_id
                                              and acc.revision = '0000'
{
  hba.mandt,
  distinct_hba.bukrs,
  distinct_hba.hbkid,
  distinct_hba.hktid,
  hba.bankn,
  acc.control_key as bkont,
  @Semantics.currencyCode
  acc.waers,
  hba.refzl,
  hba.dtaai,
  hba.bnkn2,
  hba.fdgrp,
  @Semantics.currencyCode
  hba.abwae,
  hba.hkont,
  hba.wekon,
  hba.mindt,
  hba.hbid1,
  hba.hkid1,
  hba.hbid2,
  hba.hkid2,
  hba.wkkon,
  hba.wikon,
  acc.status
}

Learn More