FCML_REP_AB_EB_V

@AbapCatalog.sqlViewName: 'FCML_REP_AB_EB_V'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #AUTOMATED
@EndUserText.label: 'CDS View struct FCML_REP, Beg./End.Inv.'
define view Fcml_Rep_AB_EB_Ddl
  as select from fcml_act_perds_v as periods
  association [1..*] to FCMLDOC_EX_MAT_DDL as _mlextr on _mlextr.jahrper < periods.jahrper
{
  key       _mlextr.kalnr_mat,
  key       cast ( substring(periods.jahrper, 5, 3) as poper)           as poper,
  key       cast ( substring(periods.jahrper, 1, 4) as bdatj)           as BDATJ,
  key       cast ( '        '     as ckml_run_type    preserving type ) as RUN_ACT,
  key       cast ( '    '         as ckml_run_appl    preserving type ) as RUN_APPL,
  key       cast ( 'AB'           as ckml_categ       preserving type ) as CATEG,
  key       cast ( '    '         as ck_ptyp_bvalt    preserving type ) as PTYP,
  key       cast ( '  '           as ck_psart         preserving type ) as PSART,
  key       cast ( '000000000000' as ck_kalnr         preserving type ) as KALNR_PMAT,
  key       cast ( '000000000000' as ckml_alprocnr    preserving type ) as bvalt,
  key       cast ( '000000000000' as ckml_f_procnr    preserving type ) as process,
  key       _mlextr.curtp,
  key       _mlextr.rldnr,
            @Semantics.quantity.unitOfMeasure : 'meins'
            sum (_mlextr.lbkum)                                         as lbkum,
            @Semantics.unitOfMeasure
            _mlextr.meins,
            @Semantics.amount.currencyCode: 'waers'
            sum (_mlextr.salk3)                                         as salk3,
            @Semantics.amount.currencyCode: 'waers'
            cast ( 0 as ckml_estprd )                                   as estprd,
            @Semantics.amount.currencyCode: 'waers'
            cast ( 0 as ckml_estkdm )                                   as estkdm,
            @Semantics.amount.currencyCode: 'waers'
            cast ( 0 as ckml_mstprd )                                   as mstprd,
            @Semantics.amount.currencyCode: 'waers'
            cast ( 0 as ckml_mstkdm )                                   as mstkdm,
            @Semantics.currencyCode
            _mlextr.waers
}
group by
  _mlextr.kalnr_mat,
  jahrper,
  _mlextr.curtp,
  _mlextr.rldnr,
  _mlextr.meins,
  _mlextr.waers
having
     sum(
       _mlextr.lbkum
     ) <> 0
  or sum(
    _mlextr.salk3
  )    <> 0

union all select from fcml_act_perds_v as periods
association [1..*] to FCMLDOC_EX_MAT_DDL as _mlextr on _mlextr.jahrper <= periods.jahrper
{
  key       _mlextr.kalnr_mat,
  key       cast ( substring(periods.jahrper, 5, 3) as poper)           as poper,
  key       cast ( substring(periods.jahrper, 1, 4) as bdatj)           as BDATJ,
  key       cast ( '        '     as ckml_run_type    preserving type ) as RUN_ACT,
  key       cast ( '    '         as ckml_run_appl    preserving type ) as RUN_APPL,
  key       cast ( 'EB'           as ckml_categ       preserving type ) as CATEG,
  key       cast ( '    '         as ck_ptyp_bvalt    preserving type ) as PTYP,
  key       cast ( '  '           as ck_psart         preserving type ) as PSART,
  key       cast ( '000000000000' as ck_kalnr         preserving type ) as KALNR_PMAT,
  key       cast ( '000000000000' as ckml_alprocnr    preserving type ) as bvalt,
  key       cast ( '000000000000' as ckml_f_procnr    preserving type ) as process,
  key       _mlextr.curtp,
  key       _mlextr.rldnr,
            @Semantics.quantity.unitOfMeasure : 'meins'
            sum (_mlextr.lbkum)                                         as lbkum,
            @Semantics.unitOfMeasure
            _mlextr.meins,
            @Semantics.amount.currencyCode: 'waers'
            sum (_mlextr.salk3)                                         as salk3,
            @Semantics.amount.currencyCode: 'waers'
            cast ( 0 as ckml_estprd )                                   as estprd,
            @Semantics.amount.currencyCode: 'waers'
            cast ( 0 as ckml_estkdm )                                   as estkdm,
            @Semantics.amount.currencyCode: 'waers'
            cast ( 0 as ckml_mstprd )                                   as mstprd,
            @Semantics.amount.currencyCode: 'waers'
            cast ( 0 as ckml_mstkdm )                                   as mstkdm,
            @Semantics.currencyCode
            _mlextr.waers
}
group by
  _mlextr.curtp,
  _mlextr.rldnr,
  _mlextr.kalnr_mat,
  jahrper,
  _mlextr.meins,
  _mlextr.waers
having
     sum(
       _mlextr.lbkum
     ) <> 0
  or sum(
    _mlextr.salk3
  )    <> 0