I_EntProjSimilarProjBscData

DDL: I_ENTPROJSIMILARPROJBSCDATA SQL: IEPSRPROJDATA Type: view COMPOSITE
25 Fields 3 Data Sources 1 Associations

Interface view for the Similar Projects

I_EntProjSimilarProjBscData is a Composite CDS View that provides data about "Interface view for the Similar Projects" in SAP S/4HANA. It reads from 3 data sources (I_EnterpriseProject, I_SingleResponsibleForProj, P_EntSimilarProjBscDataUnion) and exposes 25 fields with key fields ProjectUUID, SimilarProjectUUID. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
I_EnterpriseProject I_EnterpriseProject left_outer
I_SingleResponsibleForProj I_SingleResponsibleForProj left_outer
P_EntSimilarProjBscDataUnion P_EntSimilarProjBscDataUnion from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UserContactCard _UserContact I_SingleResponsibleForProj.BusinessPartnerUUID = _UserContact.BusinessPartnerUUID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IEPSRPROJDATA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Interface view for the Similar Projects view
UI.presentationVariant.sortOrder.by ObjectIndicator view
UI.presentationVariant.sortOrder.direction #ASC view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID P_EntSimilarProjBscDataUnion ProjectUUID Project UUID
KEY SimilarProjectUUID SimilarProjectUUID Entity GUID
ProjectInternalID P_EntSimilarProjBscDataUnion ProjectInternalID Project Def.
SimilarProjectInternalID SimilarProjectInternalID
Project P_EntSimilarProjBscDataUnion Project WBS Element
SimilarProject SimilarProject
ProjPredictedSimilarityValue ProjPredictedSimilarityValue
ProjectPredictedFactor ProjectPredictedFactor
PlannedStartDate P_EntSimilarProjBscDataUnion PlannedStartDate Latest Planned Start
PlannedEndDate P_EntSimilarProjBscDataUnion PlannedEndDate Ltst Planned Finish
SimilarProjectDescription SimilarProjectDescription
ActualAmountInGlobalCurrency ActualAmountInGlobalCurrency
PlanAmountInGlobalCurrency PlanAmountInGlobalCurrency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
ResponsibleCostCenter P_EntSimilarProjBscDataUnion ResponsibleCostCenter Responsible Cost Center
CompanyCode P_EntSimilarProjBscDataUnion CompanyCode Receiver Company Code
ControllingArea P_EntSimilarProjBscDataUnion ControllingArea Controlling Area
ProfitCenter P_EntSimilarProjBscDataUnion ProfitCenter Profit Center
FunctionalArea P_EntSimilarProjBscDataUnion FunctionalArea Sendr Fctl Area
PlannedDuration PlannedDuration
TeamMemberCount TeamMemberCount
ObjectIndicator ObjectIndicator
BusinessPartnerUUID I_SingleResponsibleForProj BusinessPartnerUUID UUID
BusinessPartnerFullName I_SingleResponsibleForProj BusinessPartnerFullName Broker Name
_UserContact _UserContact

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_EntProjSimilarProjBscData.
-- 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: IEPSRPROJDATA

CREATE VIEW I_EntProjSimilarProjBscData AS
SELECT
  P_EntSimilarProjBscDataUnion.ProjectUUID AS ProjectUUID,
  SimilarProjectUUID,
  P_EntSimilarProjBscDataUnion.ProjectInternalID AS ProjectInternalID,
  SimilarProjectInternalID,
  P_EntSimilarProjBscDataUnion.Project AS Project,
  SimilarProject,
  ProjPredictedSimilarityValue,
  ProjectPredictedFactor,
  P_EntSimilarProjBscDataUnion.PlannedStartDate AS PlannedStartDate,
  P_EntSimilarProjBscDataUnion.PlannedEndDate AS PlannedEndDate,
  SimilarProjectDescription,
  ActualAmountInGlobalCurrency,
  PlanAmountInGlobalCurrency,
  GlobalCurrency,
  P_EntSimilarProjBscDataUnion.ResponsibleCostCenter AS ResponsibleCostCenter,
  P_EntSimilarProjBscDataUnion.CompanyCode AS CompanyCode,
  P_EntSimilarProjBscDataUnion.ControllingArea AS ControllingArea,
  P_EntSimilarProjBscDataUnion.ProfitCenter AS ProfitCenter,
  P_EntSimilarProjBscDataUnion.FunctionalArea AS FunctionalArea,
  PlannedDuration,
  TeamMemberCount,
  ObjectIndicator,
  I_SingleResponsibleForProj.BusinessPartnerUUID AS BusinessPartnerUUID,
  I_SingleResponsibleForProj.BusinessPartnerFullName AS BusinessPartnerFullName
FROM P_EntSimilarProjBscDataUnion
LEFT OUTER JOIN I_EnterpriseProject ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SingleResponsibleForProj ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UserContactCard AS _UserContact ON I_SingleResponsibleForProj.BusinessPartnerUUID = _UserContact.BusinessPartnerUUID  -- association [0..1]
;

Learn More