FCMLDOC_EX_MAT_DDL

DDL: FCML_DOC_EX_MAT_V SQL: FCMLDOC_EX_MAT_V Type: view

Materials from MLDOC_EXTRACT

FCMLDOC_EX_MAT_DDL is a CDS View that provides data about "Materials from MLDOC_EXTRACT" in SAP S/4HANA. It reads from 2 data sources (mldoc_extract, ckmlhd) and exposes 8 fields with key fields kalnr_mat, jahrper, curtp, rldnr.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
mldoc_extract doc_ex from
ckmlhd hd inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FCMLDOC_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_EXTRACT view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY kalnr_mat
KEY jahrper mldoc_extract jahrper
KEY curtp mldoc_extract curtp
KEY rldnr mldoc_extract rldnr
lbkum
meins
salk3
waers mldoc_extract waers 
@AbapCatalog.sqlViewName: 'FCMLDOC_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_EXTRACT'
-- beginning inventory and ending inventory for activity types
-- from previous periods not needed
define view FCMLDOC_EX_MAT_DDL as select from mldoc_extract as doc_ex
                                  inner join ckmlhd        as hd
                                  on doc_ex.kalnr = hd.kalnr
{
  key cast ( doc_ex.kalnr as ck_kalnr preserving type )          as kalnr_mat,
  key doc_ex.jahrper                                             as jahrper,
  key doc_ex.curtp,
  key doc_ex.rldnr,
      @Semantics.quantity.unitOfMeasure : 'meins'
      cast ( sum (doc_ex.quant) as ck_lbkum )                    as lbkum,
      @Semantics.unitOfMeasure
      cast ( doc_ex.meins as meins preserving type )             as meins,
      @Semantics.amount.currencyCode: 'waers'
      cast ( sum (doc_ex.stval) as ck_salk3_1 )                  as salk3,
      @Semantics.currencyCode
      doc_ex.waers
}
group by
  doc_ex.curtp,
  doc_ex.rldnr,
  doc_ex.kalnr,
  jahrper,
  doc_ex.meins,
  doc_ex.waers
having
     sum(
       doc_ex.quant
     ) <> 0
  or sum(
    doc_ex.stval
  )    <> 0
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CKMLHD",
"MLDOC_EXTRACT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More