P_CommitmentItemSetNode

DDL: P_COMMITMENTITEMSETNODE SQL: PCISETNODE Type: view BASIC

P_CommitmentItemSetNode is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (setheader, setheadert) and exposes 5 fields with key field FinancialManagementArea.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
setheader header from
setheadert text left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCISETNODE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
VDM.private true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea
nodevalue setheader setname
nodetxt setheadert descript
descriptasnltxtendasNodeValueText
nodeid 
@AbapCatalog.sqlViewName: 'PCISETNODE'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.compiler.compareFilter:true
@VDM.viewType: #BASIC
@VDM.private:true
@AbapCatalog.preserveKey:true 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #A,
  sizeCategory: #S
}
define view P_CommitmentItemSetNode
  as select from    setheader            as header
    left outer join setheadert           as text               on  header.setclass = text.setclass
                                                               and header.subclass = text.subclass
                                                               and header.setname  = text.setname
                                                               and text.langu      = $session.system_language
{
  key cast(header.subclass as fikrs )                                                               as FinancialManagementArea,
      header.setname                                                                                as nodevalue,
      text.descript                                                                                 as nodetxt,
      case
      when text.descript is null or text.descript = '' then cast( header.setname as nltxt )
      else cast( concat( header.setname, concat('(',concat( text.descript, ')' ) ) ) as nltxt ) end as NodeValueText,
      cast( concat( concat(header.subclass,'/'),header.setname) as nodid )                          as nodeid

}
where
  header.setclass = '0311'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SETHEADER",
"SETHEADERT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More