P_NodeClass

DDL: P_NODECLASS SQL: PNODECLASS Type: view BASIC

P_NodeClass is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (/plmi/ppe_cus_gs, klah, swor) and exposes 5 fields with key field ClassInternalID.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
/plmi/ppe_cus_gs /plmi/ppe_cus_gs inner
klah klah from
swor swor inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PNODECLASS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ClassInternalID klah clint
ClassType /plmi/ppe_cus_gs klart
Class class
Language spras
ClassName kschl 
@AbapCatalog.sqlViewName: 'PNODECLASS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.private: true
define view P_NodeClass
  as select from klah
    inner join /plmi/ppe_cus_gs on klah.mandt = /plmi/ppe_cus_gs.mandt 
                                and klah.klart = /plmi/ppe_cus_gs.klart
    inner join swor             on  klah.clint = swor.clint
                                and klpos      = '01'
{
  key klah.clint                 as ClassInternalID,
      /plmi/ppe_cus_gs.klart     as ClassType,
      class                      as Class,
      spras                      as Language,
      kschl                      as ClassName
}
where spras = $session.system_language  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"/PLMI/PPE_CUS_GS",
"KLAH",
"SWOR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More