VFCLM_BAM_DDL_AMD_WTTHDESP2

@AbapCatalog.sqlViewName: 'VFCLM_BAM_AMDDP2'
@EndUserText.label: 'Bank Account Master Data with Description (no parameter)'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #D
@ClientHandling.algorithm: #SESSION_VARIABLE 
define view VFCLM_BAM_DDL_AMD_WTTHDESP2
  as select distinct from VFCLM_BAM_DDL_AMD             as header
    left outer join       t002                          as t002                          on(
                               header.Status    =  t002.laspez
                               or header.Status <> t002.laspez
                             )
    left outer join       I_Bank                        as bank                          on  header.BankCountry = bank.BankCountry
                                                                                         and header.BankKey     = bank.BankInternalID
    left outer join       tcurt                         as curr_desp                     on  header.Currency = curr_desp.waers
                                                                                         and curr_desp.spras = t002.spras
    left outer join       fclm_bam_amd_t                as account_text                  on  header.AccountID          =  account_text.acc_id
                                                                                         and account_text.revision = '0000'
                                                                                         and account_text.deleted_flag <> 'X'
                                                                                         and account_text.langu        =  t002.spras
    left outer join       VFCLM_BAM_DDL_ACCOUNTSTATUS   as domaintxt                     on  header.Status        = domaintxt.domvalue_l
                                                                                         and domaintxt.ddlanguage = t002.spras
    left outer join       fclm_bam_ac_typt              as acctyptxt                     on  header.AccountType = acctyptxt.acc_type_id
                                                                                         and acctyptxt.langu    = t002.spras
    left outer join       t005t                         as countries                     on  header.BankCountry = countries.land1
                                                                                         and countries.spras    = t002.spras
    left outer join       fagl_segmt                    as fagl_segmt                    on  header.Segment   = fagl_segmt.segment
                                                                                         and fagl_segmt.langu = t002.spras
    left outer join       tgsbt                         as tgsbt                         on  header.BusinessArea = tgsbt.gsber
                                                                                         and tgsbt.spras         = t002.spras
    left outer join       fclm_bam_bsimp_t              as bsimport                      on  header.EoDImort = bsimport.import_type
                                                                                         and bsimport.langu  = t002.spras
  //  left outer join fclm_bam_bsimp_t as bsimport2

  //    on header.IntradayImport = bsimport2.import_type

  //    and bsimport2.langu = t002.spras

    left outer join       VFCLM_BAM_DDL_ACCNUMTXT       as VFCLM_BAM_DDL_ACCNUMTXT       on  header.AccountNumber               = VFCLM_BAM_DDL_ACCNUMTXT.domvalue_l
                                                                                         and VFCLM_BAM_DDL_ACCNUMTXT.ddlanguage = t002.spras
    left outer join       VFCLM_BAM_DDL_ACCOUNTINAPPROC as VFCLM_BAM_DDL_ACCOUNTINAPPROC on  header.AccountID                               = VFCLM_BAM_DDL_ACCOUNTINAPPROC.acc_id
                                                                                         and (
                                                                                            VFCLM_BAM_DDL_ACCOUNTINAPPROC.request_status    = '01'
                                                                                            or VFCLM_BAM_DDL_ACCOUNTINAPPROC.request_status = '02'
                                                                                          )
                                                                                         and VFCLM_BAM_DDL_ACCOUNTINAPPROC.request_process  = ''
{
  key header.AccountID           as AccountID,
      t002.spras                 as Language,

      header.BankCountry         as BankCountry,
      header.BankKey             as BankKey,
      bank.BankName              as Banka,
      bank.SWIFTCode             as Swift,
      bank.Bank                  as BankNumber,

      header.AccountNumber       as AccountNumber,
      header.AccountType         as AccountType,
      header.ValidFrom           as ValidFrom,
      header.ValidTo             as ValidTo,
      header.IBAN                as IBAN,

      account_text.description   as Description,
      header.Status              as Status,

      header.CompanyCode         as CompanyCode,
      header.ProfitCenter        as ProfitCenter,
      header.BusinessArea        as BusinessArea,
      header.Segment             as Segment,
      header.AccountHolder       as AccountHolder,
      header.BankContact         as BankContact,
      header.RelationshipManager as RelationshipManager,
      header.CompanyContact      as CompanyContact,
      header.AccountSupervisor   as AccountSupervisor,
      header.EoDImort            as EoDImort,
      header.IntradayImport      as IntradayImport,
      header.BankStatementUpload as BankStatementUpload,
      header.CashToleranceGroup  as CashToleranceGroup,
      header.IntradayIsReconciled as IntradayIsReconciled,

      header.CreatedAtDate,
      header.CreatedAtTime,
      header.CreatedBy,
      header.OpenedAtDate,
      header.OpenedAtTime,
      header.OpenedBy,
      header.ChangedAtDate,
      header.ChangedAtTime,
      header.ChangedBy,
      header.ClosedAtDate,
      header.ClosedAtTime,
      header.ClosedBy,

      header.ImportingChannel    as ImportingChannel,
      header.CutOffDomestic      as CutOffDomestic,
      header.CutOffCrossBorder   as CutOffCrossBorder,
      header.PlannedClosingDate  as PlannedClosingDate,
      header.UploadBSFlag        as UploadBSFlag,

      header.Currency            as Currency,
      header.CompanyCodeDesp     as CompanyCodeDesp,


      // House bank account

      header.HouseBankCompanyCode,
      header.HouseBankCompanyCodeDesp,
      header.abwae,
      header.bankn,
      header.bnkn2,
      header.dtaai,
      header.fdgrp,
      header.hbid1,
      header.hbid2,
      header.hbkid,
      header.hkid1,
      header.hkid2,
      // header.hkont,

      header.hktid,
      header.mindt,
      header.refzl,
      header.wekon,
      header.wikon,
      header.wkkon,

      //     cast(( case

      //        when header.addi_gl is not null and header.addi_gl <> '' then header.addi_gl

      //        else header.hkont

      //      end  ) as hkont) as hkont,


      header.hkont,
      //      header.addi_gl,


      case
        when VFCLM_BAM_DDL_ACCOUNTINAPPROC.request_id is not null then 'X'
        else ''
      end                        as InApprovalProcess,

      // Display purpose columns

      acctyptxt.acc_type_desc    as AccountTypeDesp,
      domaintxt.ddtext           as StatusDesp,
      curr_desp.ktext            as CurrencyDesp,
      tgsbt.gtext                as BusinessAreaDesp,
      fagl_segmt.name            as SegmentDesp,
      bsimport.import_type_desc  as EoDImportDesp,
      //bsimport2.import_type_desc as IntradayImportDesp,

      countries.landx            as BankCountryDesp,
      case header.AccountNumber
      when '' then VFCLM_BAM_DDL_ACCNUMTXT.ddtext
      else header.AccountNumber
      end                        as AccountNumberDesp,

      // Extension

      $extension.*
};  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BANK",
"VFCLM_BAM_DDL_ACCNUMTXT",
"VFCLM_BAM_DDL_ACCOUNTINAPPROC",
"VFCLM_BAM_DDL_ACCOUNTSTATUS",
"VFCLM_BAM_DDL_AMD",
"FAGL_SEGMT",
"FCLM_BAM_AC_TYPT",
"FCLM_BAM_AMD_T",
"FCLM_BAM_BSIMP_T",
"T002",
"T005T",
"TCURT",
"TGSBT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/