P_NodeClass

DDL: P_NODECLASS SQL: PNODECLASS Type: view BASIC
5 Fields 3 Data Sources

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.

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 Int class no.
ClassType /plmi/ppe_cus_gs klart Class Type
Class class User Group
Language spras Off. Language
ClassName kschl Tax Item Type

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_NodeClass.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PNODECLASS

CREATE VIEW P_NodeClass AS
SELECT
  klah.clint AS ClassInternalID,
  /plmi/ppe_cus_gs.klart AS ClassType,
  Class,
  spras AS Language,
  kschl AS ClassName
FROM klah
INNER JOIN /plmi/ppe_cus_gs ON /* join condition not captured in parsed metadata */
INNER JOIN swor ON /* join condition not captured in parsed metadata */
;

Learn More