I_PCF_ReleasedPCFNode

DDL: I_PCF_RELEASEDPCFNODE SQL: IPCFRELPCFNODE Type: view

I_PCF_ReleasedPCFNode is a CDS View in SAP S/4HANA. It reads from 1 data source (ARS_APIS_RELEASED_FOR_C1) and exposes 1 field with key field NodeName.

Data Sources (1)

SourceAliasJoin Type
ARS_APIS_RELEASED_FOR_C1 c1_release inner

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName IPCFRELPCFNODE view
AccessControl.authorizationCheck #NOT_ALLOWED view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY NodeName registry node_name
@AbapCatalog.sqlViewName: 'IPCFRELPCFNODE'
@AccessControl.authorizationCheck: #NOT_ALLOWED
define view I_PCF_ReleasedPCFNode
  as select distinct from pcf_w_node               as registry
    //inner join            pcf_c_node_scope         as scope      on scope.node_name = registry.node_name

    inner join            ARS_APIS_RELEASED_FOR_C1 as c1_release on  c1_release.tadir_object   = 'PCFN'
                                                                 and c1_release.tadir_obj_name = registry.node_name
{
  key registry.node_name as NodeName
}
where
      registry.version  = 'A'
  //and scope.scope_state = '3'

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