I_ProjectProfileCode

DDL: I_PROJECTPROFILECODE SQL: PROJ_PROF_CODE Type: view BASIC
2 Fields 1 Data Sources 1 Associations

Project Profile Code

I_ProjectProfileCode (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Project Profile Code · R&D Engineering

I_ProjectProfileCode is a Basic CDS View that provides data about "Project Profile Code" in SAP S/4HANA. It reads from 1 data source (tcj41) and exposes 2 fields with key field ProjectProfileCode. It has 1 association to related views.

SAP Help Documentation

CategoryProject
StatusReleased
Data Extraction TypeFull (physical deletions are possible in source tables)
Purpose
This CDS view provides the profile code for different project profiles. This CDS view provides the prerequisites for answering the following business questions: For Professional Services or financial related needs, what is the profile code associated with different project profiles?

Prerequisites
This CDS view provides a foreign key relationship in I_PROJECTDATA_2 and I_PROJECTBYINTERNALKEY for the project profile code.

Structure
Object types This view relates to the following SAP object types: Project

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessR&D Engineering
Application ComponentPS-ST
CapabilitiesData Source for Defining CDS Entities, Data Source in SQL Select, Data Source for Data Extraction, Association Target for Defining CDS Entities
PackageR&D Engineering for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the profile code for different project profiles.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>For Professional Services or financial related needs, what is the profile code associated with different project profiles?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
tcj41 tcj41 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ProjectProfileCodeText _Text $projection.ProjectProfileCode = _Text.ProjectProfileCode

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName PROJ_PROF_CODE view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey ProjectProfileCode view
EndUserText.label Project Profile Code view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.sapObjectNodeType.name ProjectProfileCode view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropagatedAnnotations true view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ProjectProfileCode profidproj Project Profile
_Text _Text

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 I_ProjectProfileCode.
-- 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: PROJ_PROF_CODE

CREATE VIEW I_ProjectProfileCode AS
SELECT
  profidproj AS ProjectProfileCode
FROM tcj41
LEFT OUTER JOIN I_ProjectProfileCodeText AS _Text ON ProjectProfileCode = _Text.ProjectProfileCode  -- association [0..*]
;

Learn More