FCMLCCS_EX_MAT_DDL

DDL: FCML_CCS_EX_MAT_V SQL: FCMLCCS_EX_MAT_V Type: view

Materials from MLDOC_CCS_EXTRACT

FCMLCCS_EX_MAT_DDL is a CDS View that provides data about "Materials from MLDOC_CCS_EXTRACT" in SAP S/4HANA. It reads from 2 data sources (mldocccs_extract, ckmlhd) and exposes 11 fields with key fields kalnr_mat, jahrper, elesmhk, element, curtp.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
mldocccs_extract ccs_ex from
ckmlhd hd inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FCMLCCS_EX_MAT_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
AbapCatalog.preserveKey true view
EndUserText.label Materials from MLDOC_CCS_EXTRACT view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY kalnr_mat
KEY jahrper mldocccs_extract jahrper
KEY elesmhk mldocccs_extract elesmhk
KEY element mldocccs_extract element
KEY curtp mldocccs_extract curtp
KEY rldnr mldocccs_extract rldnr
PRCDIF_FIX
fixasfcml_ccsvalvasPRCDIF_VAR
waers mldocccs_extract waers
PRCDIF_FIX_S
fixllasfcml_ccsvalv_sasPRCDIF_VAR_S 
@AbapCatalog.sqlViewName: 'FCMLCCS_EX_MAT_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
@AbapCatalog.preserveKey:true
@EndUserText.label: 'Materials from MLDOC_CCS_EXTRACT'
-- beginning inventory and ending inventory for activity types
-- from previous periods not needed, so JOIN with CKMLHD
define view FCMLCCS_EX_MAT_DDL
  as select from mldocccs_extract as ccs_ex
    inner join   ckmlhd           as hd on ccs_ex.kalnr = hd.kalnr
{
  key cast ( ccs_ex.kalnr as ck_kalnr preserving type )     as kalnr_mat,
  key ccs_ex.jahrper                                        as jahrper,
  key ccs_ex.elesmhk,
  key ccs_ex.element,
  key ccs_ex.curtp,
  key ccs_ex.rldnr,
      @Semantics.amount.currencyCode: 'waers'
      cast ( sum (ccs_ex.fix) as fcml_ccsvalf )             as PRCDIF_FIX,
      @Semantics.amount.currencyCode: 'waers'
      cast ( sum (ccs_ex.tot)  as fcml_ccsvalv )
        - cast (sum (ccs_ex.fix)   as fcml_ccsvalv )        as PRCDIF_VAR,
      @Semantics.currencyCode
      ccs_ex.waers,
      @Semantics.amount.currencyCode: 'waers'
      cast ( sum (ccs_ex.fixll) as fcml_ccsvalf_s )         as PRCDIF_FIX_S,
      @Semantics.amount.currencyCode: 'waers'
      cast ( sum (ccs_ex.totll)  as fcml_ccsvalv_s )
        - cast (sum (ccs_ex.fixll)   as fcml_ccsvalv_s )    as PRCDIF_VAR_S
}
group by
  ccs_ex.kalnr,
  ccs_ex.jahrper,
  ccs_ex.elesmhk,
  ccs_ex.element,
  ccs_ex.curtp,
  ccs_ex.rldnr,
  ccs_ex.waers
having
     sum(
       ccs_ex.fix
     ) <> 0
  or sum(
    ccs_ex.tot
  )    <> 0
  or sum(
    ccs_ex.fixll
  )    <> 0
  or sum(
    ccs_ex.totll
  )    <> 0
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CKMLHD",
"MLDOCCCS_EXTRACT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More