Fclm_V_House_Bank

@AbapCatalog.sqlViewName: 'CDS_FCLM_HS_BNK'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'CDS view for House Bank'
define view Fclm_V_House_Bank  as select from t012
 inner join t001 on t001.bukrs = t012.bukrs
left outer join t012d  on t012d.bukrs = t012.bukrs and
                          t012d.hbkid = t012.hbkid
left outer join bnka  on bnka.banks = t012.banks and
                         bnka.bankl = t012.bankl  {
        t012.bukrs as CompanyCode ,
        t012.hbkid as HouseBank,
        t012.banks as BankCountry,
        t012.bankl as BankInternalId,
        t012.telf1 as PhoneNumber1,
        t012.stcd1 as TaxID1,
        t012.name1 as ContactPersonName,
        t012.spras as Language,
        t012.bupla as BusinessPlace,
        t001.butxt as CompanyName,
        bnka.banka as BankName,
        bnka.provz as Region ,
        bnka.stras as StreetName,
        bnka.ort01 as CityName,
        bnka.brnch as Branch,
        bnka.swift as SWIFTCode,
        bnka.bgrup as BankGroup,
        bnka.bnklz as Bank,
        t012d.edipn as EDIPartner,
        t012d.edisn as EDISignatureType,
        t012d.dtbid as DataMediumExchangeBank,
        t012d.dtelz as DataMediumReceivingBank,
        t012d.dtkid as CustomerByHouseBank ,
        t012d.dtgko as BankControlKey  ,
        t012d.dtaws as DataExchangeInstruction,
        t012d.dtvta as ExecutionLeadDays,
        t012d.dtxbb as CentralBankReportIsRequired,
        t012d.dtlbe as RegionByCentralBank,
        t012d.dtxms as PaymentIsForwardedToCentralBk,
        t012d.dtgis as ChargeAccountCurrencyISOCode,
        t012d.dtgbk as ChargeAccount,
        t012d.dtglz as ChargeAccountBank,
        t012d.dtfin as OrderingCompanyByBank
      }

    
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"BNKA",
"T001",
"T012",
"T012D"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/