C_ProjectNetworkVersForGraph

DDL: C_PROJECTNETWORKVERSFORGRAPH SQL: CNTWKVFORGRAPH Type: view CONSUMPTION

Project Network For Graph

C_ProjectNetworkVersForGraph is a Consumption CDS View that provides data about "Project Network For Graph" in SAP S/4HANA. It reads from 1 data source (I_ProjectNetworkVersBasicData) and exposes 11 fields with key fields ProjectNetwork, Version.

Data Sources (1)

SourceAliasJoin Type
I_ProjectNetworkVersBasicData I_ProjectNetworkVersBasicData from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CNTWKVFORGRAPH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
EndUserText.label Project Network For Graph view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ProjectNetwork ProjectNetwork Network
KEY Version Version XML Vers.
ProjectNetworkDescription ProjectNetworkDescription Network Name
OrderTypeName
ProjectNetworkType ProjectNetworkType Network Type
PlantName _Plant PlantName Plant Name
ScheduledBasicStartDate ScheduledBasicStartDate Sched. start
ScheduledBasicEndDate ScheduledBasicEndDate Sched. finish
IsMarkedForDeletion IsMarkedForDeletion Flagged for Deletion
Plant Plant Valuation Area
MRPController MRPController MRP Controller

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 C_ProjectNetworkVersForGraph.
-- 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: CNTWKVFORGRAPH

CREATE VIEW C_ProjectNetworkVersForGraph AS
SELECT
  ProjectNetwork,
  Version,
  ProjectNetworkDescription,
  cast ( _OrderType._Text[1:Language = $session.system_language].OrderTypeName as ps_s4_auarttext preserving type) AS OrderTypeName,
  ProjectNetworkType,
  _Plant.PlantName AS PlantName,
  ScheduledBasicStartDate,
  ScheduledBasicEndDate,
  IsMarkedForDeletion,
  Plant,
  MRPController
FROM I_ProjectNetworkVersBasicData
;