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. 3 CDS views read from this table.

Used by 3 CDS view(s) 21 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
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
abwae abwae 1
bankn BankAccount,bankn 2
bkont bkont 1
bnkn2 bnkn2 1
bukrs bukrs 2
dtaai dtaai 1
fdgrp fdgrp 1
hbid1 hbid1 1
hbid2 hbid2 1
hbkid hbkid 2
hkid1 hkid1 1
hkid2 hkid2 1
hkont hkont 1
hktid hktid 2
mandt mandt 1
mindt mindt 1
refzl refzl 1
waers waers 1
wekon wekon 1
wikon wikon 1
wkkon wkkon 1 
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCLM_BAM_DISTINCT_HBA",
"FCLM_BAM_ACLINK2",
"FCLM_BAM_AMD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More