FGL_LIB_P_DOC_HEADER

@AbapCatalog.sqlViewName: 'FILIBPDOCH'
@EndUserText.label: 'Parked Items: Document Header'

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
--@AbapCatalog.preserveKey:true

@AccessControl.authorizationCheck:#NOT_REQUIRED
@AccessControl.personalData.blocking:#NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #L,
  dataClass: #MIXED
}
define view FGL_LIB_P_DOC_HEADER
  as select from    bkpf
    inner join      t001                on t001.bukrs = bkpf.bukrs
    left outer join FINS_T001A as t001a on t001a.bukrs = bkpf.bukrs
{
  key bkpf.belnr,
  key bkpf.bukrs,
  key bkpf.gjahr,

      bkpf.waers             as currkey_0d,
      bkpf.hwaer             as currkey_10,

      cast(
        case
          when  t001a.curtp = '11' then bkpf.hwae2
          when  t001a.curtp2 = '11' then bkpf.hwae3
          else  ''
        end
      as fagl_currkey_11 )
        as currkey_11,

      cast(
        case
          when  t001a.curtp = '12' then bkpf.hwae2
          when  t001a.curtp2 = '12' then bkpf.hwae3
          else  ''
        end
      as fagl_currkey_12 )
        as currkey_12,

      cast(
        case
          when  t001a.curtp = '30' then bkpf.hwae2
          when  t001a.curtp2 = '30' then bkpf.hwae3
          else  ''
        end
      as fagl_currkey_30 )
        as currkey_30,

      cast(
        case
          when  t001a.curtp = '31' then bkpf.hwae2
          when  t001a.curtp2 = '31' then bkpf.hwae3
          else  ''
        end
      as fagl_currkey_31 )
        as currkey_31,

      cast(
        case
          when  t001a.curtp = '32' then bkpf.hwae2
          when  t001a.curtp2 = '32' then bkpf.hwae3
          else  ''
        end
      as fagl_currkey_32 )
        as currkey_32,

      cast(
        case
          when  t001a.curtp = '40' then bkpf.hwae2
          when  t001a.curtp2 = '40' then bkpf.hwae3
          else  ''
        end
      as fagl_currkey_40 )
        as currkey_40,

      cast(
        case
          when  t001a.curtp = '50' then bkpf.hwae2
          when  t001a.curtp2 = '50' then bkpf.hwae3
          else  ''
        end
      as fagl_currkey_50 )
        as currkey_50,

      cast(
        case
          when  t001a.curtp = '60' then bkpf.hwae2
          when  t001a.curtp2 = '60' then bkpf.hwae3
          else  ''
        end
      as fagl_currkey_11)
        as currkey_60,

      //fiscal year period

      cast(
        concat(concat(bkpf.gjahr, '0'), bkpf.monat)
      as rsfiscper )
        as fiscper,

      // fields from T001A

      t001a.curtp             as curtp,
      t001a.curtp2            as curtp2,

      // fields from bkpf

      bkpf.adisc,
      bkpf.aedat,
      bkpf.arcid,
      bkpf.ausbk,
      bkpf.awkey,
      bkpf.aworg_rev,
      bkpf.awref_rev,
      bkpf.awsys,
      bkpf.awtyp,
      bkpf.basw2,
      bkpf.basw3,
      bkpf.belnr_sender,
      bkpf.bktxt,
      bkpf.blart,
      bkpf.bldat,
      bkpf.brnch,
      bkpf.bstat,
      bkpf.budat,
      bkpf.bukrs_sender,
      bkpf.bvorg,
      bkpf.cash_alloc,
      bkpf.co_alebn,
      bkpf.co_belnr_sender,
      bkpf.co_refbt,
      bkpf.co_valdt,
      bkpf.co_vrgng,
      bkpf.cpudt,
      bkpf.cputm,
      bkpf.ctxkrs,
      bkpf.curt2,
      bkpf.curt3,
      bkpf.dbblg,
      bkpf.doccat,
      bkpf.dokid,
      bkpf.duefl,
      bkpf.fikrs,
      bkpf.follow_on,
      @Semantics.amount.currencyCode: 'CURRKEY_0D'
      bkpf.frath,
      bkpf.gjahr_sender,
      bkpf.glbtgrp,
      bkpf.glvor,
      bkpf.grpid,
      bkpf.hwae2,
      bkpf.hwae3,
      bkpf.hwaer,
      bkpf.iblar,
      bkpf.intsubid,
      bkpf.kokrs_sender,
      bkpf.kur2x,
      bkpf.kur3x,
      bkpf.kurs2,
      bkpf.kurs3,
      bkpf.kursf,
      bkpf.kurst,
      bkpf.kursx,
      bkpf.kuty2,
      bkpf.kuty3,
      bkpf.kzkrs,
      bkpf.kzwrs,
      bkpf.ldgrp,
      bkpf.logsystem_sender,
      bkpf.lotkz,
      bkpf.monat,
      bkpf.numpg,
      bkpf.ppdat,
      bkpf.ppnam,
      bkpf.pptcod,
      bkpf.pptme,
      bkpf.propmano,
      bkpf.reindat,
      bkpf.reprocessing_status_code,
      bkpf.resubmission,
      bkpf.rldnr,
      bkpf.stblg,
      bkpf.stgrd,
      bkpf.stjah,
      bkpf.stodt,
      bkpf.subset,
      bkpf.tcode,
      bkpf.txkrs,
      bkpf.umrd2,
      bkpf.umrd3,
      bkpf.upddt,
      bkpf.usnam,
      bkpf.vatdate,
      bkpf.wwert,
      bkpf.xblnr,
      bkpf.xblnr_alt,
      bkpf.xmca,
      bkpf.xmwst,
      bkpf.xnetb,
      bkpf.xref1_hd,
      bkpf.xref2_hd,
      bkpf.xreorg,
      bkpf.xreversal,
      bkpf.xreversed,
      bkpf.xreversing,
      bkpf.xrueb,
      bkpf.xsnet,
      bkpf.xsplit,
      bkpf.xstov,
      bkpf.xusvr,
      bkpf.xwvof,

      // fields from T001

      t001.ktopl              as ktopl
}

where bkpf.bstat = 'V'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINS_T001A",
"BKPF",
"T001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/