Fcml_Rep_Ddl

DDL: FCML_REP_V SQL: FCML_REP_V Type: view Package: FCML4H_DISPLAY

CDS View with structure of table FCML_REP

Fcml_Rep_Ddl is a CDS View that provides data about "CDS View with structure of table FCML_REP" in SAP S/4HANA. It reads from 2 data sources (mldoc, fcml_rep_ab_eb_v) and exposes 36 fields with key fields kalnr_mat, poper, BDATJ, RUN_ACT, RUN_APPL. Part of development package FCML4H_DISPLAY.

2 data source(s) 36 fields

Data Sources (2)

SourceAliasJoin Type
mldoc doc from
fcml_rep_ab_eb_v fcml_rep_ab_eb_v union_all

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FCML_REP_V view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #AUTOMATED view
EndUserText.label CDS View with structure of table FCML_REP view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY kalnr_mat
KEY poper
KEY BDATJ
KEY RUN_ACT
KEY RUN_APPL
KEY CATEG
KEY PTYP
KEY PSART
KEY KALNR_PMAT
KEY bvalt
KEY process
KEY curtp mldoc curtp
KEY rldnr mldoc rldnr
meins
mstprd
mstkdm
poper poper
bdatj bdatj
run_act run_act
run_appl run_appl
categ categ
ptyp ptyp
psart psart
kalnr_pmat kalnr_pmat
bvalt bvalt
process process
curtp curtp
rldnr rldnr
lbkum
meins meins
salk3 salk3
estprd estprd
estkdm estkdm
mstprd mstprd
mstkdm mstkdm
waers waers 
@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 = ''
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
}

Learn More