FMLV_F4_ML

DDL: FMLV_F4_ML SQL: FMLVF4ML Type: view

Select ML relevant currencies

FMLV_F4_ML is a CDS View that provides data about "Select ML relevant currencies" in SAP S/4HANA. It reads from 2 data sources (fmlv_curtp_ml, t001k) and exposes 6 fields with key field rbukrs.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
fmlv_curtp_ml c from
t001k k inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FMLVF4ML view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
EndUserText.label Select ML relevant currencies view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY rbukrs fmlv_curtp_ml rbukrs
bwkey t001k bwkey
curtp fmlv_curtp_ml ext_curtype
waers fmlv_curtp_ml waers
rldnr fmlv_curtp_ml rldnr
rcolumn fmlv_curtp_ml rcolumn 
@AbapCatalog.sqlViewName: 'FMLVF4ML'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
//@AbapCatalog.buffering:{

//  status: #ACTIVE,

//  type: #FULL

//}

@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
  usageType: {
    serviceQuality: #C,
    sizeCategory: #S,
    dataClass: #CUSTOMIZING
  }
}
@EndUserText.label: 'Select ML relevant currencies'

// Field FMLT_CURTP_ML-RLDNR has already been marked as key-field, due to upcoming development of parallel accounting.

// But in OP2009 this feature is not yet in effect.

// Hence, add following pseudo comment to suppress warning that key definitions of DB table and CDS view differ

/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] }*/

define view FMLV_F4_ML
  as

  select from fmlv_curtp_ml as c
  inner join t001k as k on k.bukrs = c.rbukrs  

{
  key c.rbukrs  as rbukrs,
  //key c.curtp   as curtp,

      k.bwkey as bwkey,
      c.ext_curtype   as curtp,
      c.waers   as waers,
      c.rldnr   as rldnr,
      c.rcolumn as rcolumn
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FMLV_CURTP_ML",
"T001K"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More