P_GetParSemanticTagForProj

DDL: P_GETPARSEMANTICTAGFORPROJ SQL: PGTSEMTAFRPAR Type: view COMPOSITE Package: ODATA_PS_COS_PROJBDGT_DET
2 Fields 2 Data Sources 1 Associations

Get Semantic Tag for Project

P_GetParSemanticTagForProj is a Composite CDS View that provides data about "Get Semantic Tag for Project" in SAP S/4HANA. It reads from 2 data sources (I_AvailyCtrlProfileSemanticTag, I_ProjectBasicData) and exposes 2 fields with key field ProjectInternalID. It has 1 association to related views. Part of development package ODATA_PS_COS_PROJBDGT_DET.

Data Sources (2)

SourceAliasJoin Type
I_AvailyCtrlProfileSemanticTag _ParentTag left_outer
I_ProjectBasicData _ProjBasicData from

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_EnterpriseProject _ProjectSummary _ProjectSummary.ProjectInternalID = _ProjBasicData.ProjectInternalID

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PGTSEMTAFRPAR view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ProjectInternalID ProjectInternalID Project Def.
AvailabilityControlProfile I_ProjectBasicData AvailabilityControlProfile Budget Availability Control Profile

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_GetParSemanticTagForProj.
-- 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: PGTSEMTAFRPAR

CREATE VIEW P_GetParSemanticTagForProj AS
SELECT
  ProjectInternalID,
  _ProjBasicData.AvailabilityControlProfile AS AvailabilityControlProfile
FROM I_ProjectBasicData AS _ProjBasicData
LEFT OUTER JOIN I_AvailyCtrlProfileSemanticTag AS _ParentTag ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_EnterpriseProject AS _ProjectSummary ON _ProjectSummary.ProjectInternalID = _ProjBasicData.ProjectInternalID  -- association [0..1]
;

Learn More