fincs_md_version_node

DDL: FINCS_MD_VERSION_NODE Type: view_entity

fincs_md_version_node is a CDS View in SAP S/4HANA. It reads from 2 data sources (tf200, tf200) and exposes 2 fields with key field node. It has 1 association to related views.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
tf200 _main from
tf200 _ref left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..1] fincs_md_version_node _Parent $projection.parent = _Parent.node

Annotations (4)

NameValueLevelField
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY node tf200 rvers
_Parent _Parent 
@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #B,
  sizeCategory: #S
}
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view entity fincs_md_version_node
  as select from    tf200 as _main

    left outer join tf200 as _ref on _main.rvers = _ref.ref_version

  association [0..1] to fincs_md_version_node as _Parent on $projection.parent = _Parent.node

{

  key   _main.rvers as node,

        case
         when _ref.ref_version is null
           then ''
           else _ref.rvers
         end        as parent,

        _Parent

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TF200"
],
"ASSOCIATED":
[
"FINCS_MD_VERSION_NODE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More