JV_ACDOCA_JVSO1_SWITCH

@AbapCatalog.sqlViewName: 'CACDOCA_JVSO1_SW'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.dataMaintenance: #DISPLAY_ONLY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'ACDOCA-like view on JVSO1/ACDOCA'
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE ]
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #X
@ClientHandling.algorithm: #SESSION_VARIABLE

define view JV_ACDOCA_JVSO1_SWITCH

  as select from acdoca

  association [0..1] to jvaonacdocaactiv as act on act.id = 'START'

{
  key acdoca.rldnr,
  key acdoca.rbukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.docln,

      acdoca.buzei,

      acdoca.co_belnr,
      acdoca.co_buzei,

      acdoca.awref,
      acdoca.aworg,
      acdoca.awitem,
      acdoca.awtyp,
      acdoca.awsys,

      acdoca.prec_awref,
      acdoca.prec_aworg,
      acdoca.prec_awitem,
      acdoca.prec_awtyp,
      acdoca.prec_awsys,

      acdoca.src_awref,
      acdoca.src_aworg,
      acdoca.src_awitem,
      acdoca.src_awtyp,
      acdoca.src_awsys,

      acdoca.ryear,
      acdoca.poper,

      acdoca.budat,
      acdoca.bldat,
      acdoca.valut,

      acdoca.vorgn,
      acdoca.blart,

      acdoca.racct,
      acdoca.kokrs,
      acdoca.rbusa,

      acdoca.prctr,
      acdoca.segment,
      acdoca.rfarea,

      acdoca.vname,
      acdoca.egrup,
      acdoca.recid,
      acdoca.btype,
      acdoca.vptnr,
      acdoca.etype,
      acdoca.prodper,
      acdoca.billm,
      acdoca.pom,
      acdoca.jvactivity,
      acdoca.cbrunid,

      acdoca.accasty,

      acdoca.rcntr,
      acdoca.aufnr,
      acdoca.ps_psp_pnr,

      acdoca.nplnr,
      acdoca.nplnr_vorgn,

      acdoca.vornr,

      acdoca.anln1,
      acdoca.anln2,
      acdoca.anbwa,

      acdoca.mat_pspnr,
      acdoca.matnr,
      acdoca.lstar,
      acdoca.ebeln,
      acdoca.ebelp,

      acdoca.mwskz,
      acdoca.ktosl,
      acdoca.sgtxt,

      acdoca.kunnr,
      acdoca.lifnr,

      acdoca.rwcur,
      acdoca.rhcur,
      acdoca.rkcur,
      acdoca.rocur,
      acdoca.rvcur,
      acdoca.rbcur,
      acdoca.rccur,
      acdoca.rdcur,
      acdoca.recur,
      acdoca.rfcur,
      acdoca.rgcur,

      acdoca.drcrk,

      @Semantics.amount.currencyCode: 'rwcur'
      acdoca.wsl,
      @Semantics.amount.currencyCode: 'rhcur'
      acdoca.hsl,
      @Semantics.amount.currencyCode: 'rkcur'
      acdoca.ksl,
      @Semantics.amount.currencyCode: 'rocur'
      acdoca.osl,
      @Semantics.amount.currencyCode: 'rvcur'
      acdoca.vsl,
      @Semantics.amount.currencyCode: 'rbcur'
      acdoca.bsl,
      @Semantics.amount.currencyCode: 'rccur'
      acdoca.csl,
      @Semantics.amount.currencyCode: 'rdcur'
      acdoca.dsl,
      @Semantics.amount.currencyCode: 'recur'
      acdoca.esl,
      @Semantics.amount.currencyCode: 'rfcur'
      acdoca.fsl,
      @Semantics.amount.currencyCode: 'rgcur'
      acdoca.gsl,

      acdoca.msl,
      acdoca.runit,

      acdoca.usnam,

      acdoca.timestamp,

      //DOCNR value of the JVSO1 table

      cast( '          ' as belnr_d preserving type ) as jv_docnr

}

where
        act.id       is null
  or(
        act.id       =  'START'
    and acdoca.budat >= act.budat
  )


union


select from JV_ACDOCA_JVSO1 as jvacd

association [0..1] to jvaonacdocaactiv as act on act.id = 'START'

{
  key jvacd.rldnr,
  key jvacd.rbukrs,
  key jvacd.gjahr,
  key jvacd.belnr,
  key jvacd.docln,

      jvacd.buzei,

      jvacd.co_belnr,
      jvacd.co_buzei,

      jvacd.awref,
      jvacd.aworg,
      jvacd.awitem,
      jvacd.awtyp,
      jvacd.awsys,

      jvacd.prec_awref,
      jvacd.prec_aworg,
      jvacd.prec_awitem,
      jvacd.prec_awtyp,
      jvacd.prec_awsys,

      jvacd.src_awref,
      jvacd.src_aworg,
      jvacd.src_awitem,
      jvacd.src_awtyp,
      jvacd.src_awsys,

      jvacd.ryear,
      jvacd.poper,

      jvacd.budat,
      jvacd.bldat,
      jvacd.valut,

      jvacd.vorgn,
      jvacd.blart,

      jvacd.racct,
      jvacd.kokrs,
      jvacd.rbusa,

      jvacd.prctr,
      cast( '          ' as fb_segment preserving type )  as segment,
      cast( '                ' as fkber preserving type ) as rfarea,

      jvacd.vname,
      jvacd.egrup,
      jvacd.recid,
      jvacd.btype,
      jvacd.vptnr,
      jvacd.etype,
      jvacd.prodper,
      jvacd.billm,
      jvacd.pom,
      jvacd.jvactivity,
      jvacd.cbrunid,

      jvacd.accasty,

      jvacd.rcntr,
      jvacd.aufnr,
      jvacd.ps_psp_pnr,

      jvacd.nplnr,
      jvacd.nplnr_vorgn,

      jvacd.vornr,

      jvacd.anln1,
      jvacd.anln2,
      jvacd.anbwa,

      cast( '00000000' as mat_pspnr preserving type )     as mat_pspnr,
      jvacd.matnr,
      jvacd.lstar,
      jvacd.ebeln,
      jvacd.ebelp,

      jvacd.mwskz,
      jvacd.ktosl,
      jvacd.sgtxt,

      jvacd.kunnr,
      jvacd.lifnr,

      jvacd.rwcur,
      jvacd.rhcur,
      jvacd.rkcur,
      jvacd.rocur,
      jvacd.rvcur,
      jvacd.rbcur,
      jvacd.rccur,
      jvacd.rdcur,
      jvacd.recur,
      jvacd.rfcur,
      jvacd.rgcur,

      jvacd.drcrk,

      @Semantics.amount.currencyCode: 'rtcur'
      jvacd.wsl,
      @Semantics.amount.currencyCode: 'rhcur'
      jvacd.hsl,
      @Semantics.amount.currencyCode: 'rkcur'
      jvacd.ksl,
      @Semantics.amount.currencyCode: 'rocur'
      jvacd.osl,
      @Semantics.amount.currencyCode: 'rvcur'
      jvacd.vsl,
      @Semantics.amount.currencyCode: 'rbcur'
      jvacd.bsl,
      @Semantics.amount.currencyCode: 'rccur'
      jvacd.csl,
      @Semantics.amount.currencyCode: 'rdcur'
      jvacd.dsl,
      @Semantics.amount.currencyCode: 'recur'
      jvacd.esl,
      @Semantics.amount.currencyCode: 'rfcur'
      jvacd.fsl,
      @Semantics.amount.currencyCode: 'rgcur'
      jvacd.gsl,

      jvacd.msl,
      jvacd.runit,

      jvacd.usnam,

      jvacd.timestamp,

      //DOCNR value of the JVSO1 table

      jvacd.jv_docnr

}

where
      act.id      = 'START'
  and jvacd.budat < act.budat
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"JV_ACDOCA_JVSO1",
"ACDOCA",
"JVAONACDOCAACTIV"
],
"ASSOCIATED":
[
"JVAONACDOCAACTIV"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/