P_Matval_Manage_Cost_Max_Pre

DDL: P_MATVAL_MANAGE_COST_MAX_PRE SQL: PMATVALMGMCOSTMP Type: view BASIC

P_Matval_Manage_Cost_Max_Pre is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (keko, mbew) and exposes 7 fields with key fields bzobj, kalnr, kalka, kadky, tvers.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
keko k from
mbew m inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMATVALMGMCOSTMP view
VDM.private true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY bzobj keko bzobj
KEY kalnr keko kalnr
KEY kalka keko kalka
KEY kadky keko kadky
KEY tvers keko tvers
KEY bwvar keko bwvar
KEY kkzma keko kkzma 
@AbapCatalog.sqlViewName: 'PMATVALMGMCOSTMP'
@VDM.private: true
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_Matval_Manage_Cost_Max_Pre
  as select from keko as k
    inner join   mbew as m on k.kalnr = m.kalnr
                           or k.kalnr = m.kaln1
{
  key k.bzobj,
  key k.kalnr,
  key k.kalka,
  key k.kadky,
  key k.tvers,
  key k.bwvar,
  key k.kkzma,

      concat( bdatj, poper )                    as keko_fiscyearper,
      concat( m.lfgja, concat( '0', m.lfmon ) ) as mbew_fiscyearper
}
where
       bzobj   = '0'
  and(
       feh_sta = 'FR'
    or feh_sta = 'FF'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"KEKO",
"MBEW"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More