P_LDCMP

@AbapCatalog.sqlViewName: 'PFILDCMP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE


define view P_LDCMP
  as select from finsc_ld_cmp 
{

  key finsc_ld_cmp.rldnr,
  key finsc_ld_cmp.bukrs,
    curtph   as CURTPH,
    curtpk   as CURTPK,
    curtpo   as CURTPO,
    curtpv   as CURTPV,
    curtpb   as CURTPB,
    curtpc   as CURTPC,
    curtpd   as CURTPD,
    curtpe   as CURTPE,
    curtpf   as CURTPF,
    curtpg   as CURTPG,
    periv    as periv,
    opvar    as opvar,
    acc_principle       as acc_principle,
    cast( case when functional_currency <> '  ' then functional_currency
                                                else curtph             
          end                                    
          as finsc_functional_curtype 
        ) as functional_currency

}