FCML_REP_V

CDS View

CDS View with structure of table FCML_REP

FCML_REP_V is a CDS View in S/4HANA. CDS View with structure of table FCML_REP. It contains 14 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 14 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FCML_REP_ALL_DDL view from CDS View struct. FCML_REP (Peiodic/AVR)
FCML_REP_AVR_DDL view union_all CDS View struct.of table FCML_REP f. AVR

Fields (14)

KeyField CDS FieldsUsed in Views
KEY bdatj BDATJ 1
KEY bvalt bvalt 1
KEY categ CATEG 1
KEY curtp curtp 2
KEY kalnr_mat kalnr_mat 1
KEY kalnr_pmat KALNR_PMAT 1
KEY poper poper 1
KEY process process 1
KEY psart psart 1
KEY ptyp PTYP 1
KEY rldnr rldnr 2
KEY run_act RUN_ACT 1
KEY run_appl RUN_APPL 1
meins meins 1 
@AbapCatalog.sqlViewName: 'FCML_REP_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 with structure of table FCML_REP'
define view Fcml_Rep_Ddl
  as select from mldoc as doc
{
  key cast( doc.kalnr   as ck_kalnr         preserving type )   as kalnr_mat,
  key cast( substring(doc.jahrper, 5, 3) as poper)              as poper,
  key cast( substring(doc.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( doc.categ   as ckml_categ       preserving type )   as CATEG,
  key cast( doc.ptyp    as ck_ptyp_bvalt    preserving type )   as PTYP,
  key cast( doc.posart  as ck_psart         preserving type )   as PSART,
  key cast( doc.pkalnr  as ck_kalnr         preserving type )   as KALNR_PMAT,
  key cast( doc.bvalt   as ckml_alprocnr    preserving type )   as bvalt,
  key cast( doc.process as ckml_f_procnr    preserving type )   as process,
  key doc.curtp,
  key doc.rldnr,
      @Semantics.quantity.unitOfMeasure : 'meins'
      case doc.categ
        when 'EB' then
         cast (0 as ck_lbkum  )
        else
        cast ( sum(doc.quant) as ck_lbkum  )
      end                                                       as lbkum,
      @Semantics.unitOfMeasure
      cast ( doc.meins as meins             preserving type )   as meins,
      @Semantics.amount.currencyCode: 'waers'
      case doc.categ
        when 'EB' then
          0 - cast ( sum(doc.stval) as ck_salk3_1 )
        else
          cast ( sum(doc.stval) as ck_salk3_1 )
      end                                                       as salk3,
      @Semantics.amount.currencyCode: 'waers'
      case doc.categ
        when 'EB' then
          0 - cast ( sum (doc.prd) as ckml_estprd )
        else
          cast ( sum (doc.prd) as ckml_estprd )
      end                                                       as estprd,
      @Semantics.amount.currencyCode: 'waers'
      case doc.categ
        when 'EB' then
          0 - cast ( sum (doc.kdm) as ckml_estkdm )
        else
        cast ( sum (doc.kdm) as ckml_estkdm )
      end                                                       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
      doc.waers
}
where
  doc.runref =    ''     or  -- note 3345290
  doc.runref like 'ACT%'
group by
  doc.runref,
  doc.curtp,
  doc.rldnr,
  doc.kalnr,
  doc.jahrper,
  doc.categ,
  doc.ptyp,
  doc.posart,
  doc.bvalt,
  doc.process,
  doc.pkalnr,
  doc.meins,
  doc.waers

union all select from fcml_rep_ab_eb_v
{
  kalnr_mat,
  poper,
  bdatj,
  run_act,
  run_appl,
  categ,
  ptyp,
  psart,
  kalnr_pmat,
  bvalt,
  process,
  curtp,
  rldnr,
  @Semantics.quantity.unitOfMeasure : 'meins'
  cast ( lbkum as ck_lbkum ) as lbkum,
  @Semantics.unitOfMeasure
  meins,
  @Semantics.amount.currencyCode: 'waers'
  salk3,
  @Semantics.amount.currencyCode: 'waers'
  estprd,
  @Semantics.amount.currencyCode: 'waers'
  estkdm,
  @Semantics.amount.currencyCode: 'waers'
  mstprd,
  @Semantics.amount.currencyCode: 'waers'
  mstkdm,
  @Semantics.currencyCode
  waers
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MLDOC",
"FCML_REP_AB_EB_V"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More