P_ActvPROJECTSWITHPROJCAT6

DDL: P_ACTVPROJECTSWITHPROJCAT6 SQL: PACTPRJENTPPR6 Type: view COMPOSITE
36 Fields 3 Data Sources

P_ActvPROJECTSWITHPROJCAT6 is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_PPM_ProjectSummaryTask, I_ProjectBasicData, I_WBSElementBasicData) and exposes 36 fields with key field ProjectInternalID.

Data Sources (3)

SourceAliasJoin Type
I_PPM_ProjectSummaryTask _ProjSummary inner
I_ProjectBasicData proj from
I_WBSElementBasicData WBS inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PACTPRJENTPPR6 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY ProjectInternalID I_ProjectBasicData ProjectInternalID Project Def.
ProjectExternalID I_ProjectBasicData ProjectExternalID Project def.
Project I_ProjectBasicData Project WBS Element
ProjectDescription I_ProjectBasicData ProjectDescription Project Name
ProjectProfileCode I_ProjectBasicData ProjectProfileCode Project Profile
CompanyCode I_ProjectBasicData CompanyCode Receiver Company Code
ControllingArea I_ProjectBasicData ControllingArea Controlling Area
FunctionalArea I_ProjectBasicData FunctionalArea Sendr Fctl Area
ProfitCenter I_ProjectBasicData ProfitCenter Profit Center
ProjectObject I_ProjectBasicData ProjectObject Object number
PlannedStartDate I_ProjectBasicData PlannedStartDate Latest Planned Start
PlannedEndDate I_ProjectBasicData PlannedEndDate Ltst Planned Finish
AvailabilityControlProfile I_ProjectBasicData AvailabilityControlProfile Budget Availability Control Profile
AvailabilityControlIsActive I_ProjectBasicData AvailabilityControlIsActive Budget Availability Control is Active
JointVenture I_ProjectBasicData JointVenture Joint venture
JointVentureCostRecoveryCode I_ProjectBasicData JointVentureCostRecoveryCode Recovery Ind.
JointVentureEquityType I_ProjectBasicData JointVentureEquityType Joint Venture Equity Type
JntVntrProjectType I_ProjectBasicData JntVntrProjectType JV Object Type
JntIntrstBillgClass I_ProjectBasicData JntIntrstBillgClass JIB/JIBE Class
JntIntrstBillgSubClass I_ProjectBasicData JntIntrstBillgSubClass JIB/JIBE SbClsA
Location I_ProjectBasicData Location Text
ProjectCurrency I_ProjectBasicData ProjectCurrency Project Currency
TaxJurisdiction I_ProjectBasicData TaxJurisdiction Tax Jurisdiction
_AvailabilityCtrlProfile I_ProjectBasicData _AvailabilityCtrlProfile
_CompanyCode I_ProjectBasicData _CompanyCode
_ControllingArea I_ProjectBasicData _ControllingArea
_ProfitCenter I_ProjectBasicData _ProfitCenter
_ProfitCenter2 I_ProjectBasicData _ProfitCenter2
_WBSElement I_ProjectBasicData _WBSElement
AvailyCtrlTimeRangeType _AvailabilityCtrlProfile AvailyCtrlTimeRangeType
BudgetCurrencyRole _AvailabilityCtrlProfile BudgetCurrencyRole
ProjectType I_WBSElementBasicData ProjectType Project Type
ProcessingStatus I_PPM_ProjectSummaryTask ProjectProcessingStatus
ProjectUUID I_PPM_ProjectSummaryTask ProjectUUID Project UUID
ProjectSummaryTaskUUID I_PPM_ProjectSummaryTask ProjectSummaryTaskUUID Entity GUID
ProjectCategory I_PPM_ProjectSummaryTask ProjectCategory Proj. Category

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_ActvPROJECTSWITHPROJCAT6.
-- 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: PACTPRJENTPPR6

CREATE VIEW P_ActvPROJECTSWITHPROJCAT6 AS
SELECT
  proj.ProjectInternalID AS ProjectInternalID,
  proj.ProjectExternalID AS ProjectExternalID,
  proj.Project AS Project,
  proj.ProjectDescription AS ProjectDescription,
  proj.ProjectProfileCode AS ProjectProfileCode,
  proj.CompanyCode AS CompanyCode,
  proj.ControllingArea AS ControllingArea,
  proj.FunctionalArea AS FunctionalArea,
  proj.ProfitCenter AS ProfitCenter,
  proj.ProjectObject AS ProjectObject,
  proj.PlannedStartDate AS PlannedStartDate,
  proj.PlannedEndDate AS PlannedEndDate,
  proj.AvailabilityControlProfile AS AvailabilityControlProfile,
  proj.AvailabilityControlIsActive AS AvailabilityControlIsActive,
  proj.JointVenture AS JointVenture,
  proj.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  proj.JointVentureEquityType AS JointVentureEquityType,
  proj.JntVntrProjectType AS JntVntrProjectType,
  proj.JntIntrstBillgClass AS JntIntrstBillgClass,
  proj.JntIntrstBillgSubClass AS JntIntrstBillgSubClass,
  proj.Location AS Location,
  proj.ProjectCurrency AS ProjectCurrency,
  proj.TaxJurisdiction AS TaxJurisdiction,
  proj._AvailabilityCtrlProfile AS _AvailabilityCtrlProfile,
  proj._CompanyCode AS _CompanyCode,
  proj._ControllingArea AS _ControllingArea,
  proj._ProfitCenter AS _ProfitCenter,
  proj._ProfitCenter2 AS _ProfitCenter2,
  proj._WBSElement AS _WBSElement,
  _AvailabilityCtrlProfile.AvailyCtrlTimeRangeType AS AvailyCtrlTimeRangeType,
  _AvailabilityCtrlProfile.BudgetCurrencyRole AS BudgetCurrencyRole,
  WBS.ProjectType AS ProjectType,
  _ProjSummary.ProjectProcessingStatus AS ProcessingStatus,
  _ProjSummary.ProjectUUID AS ProjectUUID,
  _ProjSummary.ProjectSummaryTaskUUID AS ProjectSummaryTaskUUID,
  _ProjSummary.ProjectCategory AS ProjectCategory
FROM I_ProjectBasicData AS proj
INNER JOIN I_PPM_ProjectSummaryTask AS _ProjSummary ON /* join condition not captured in parsed metadata */
INNER JOIN I_WBSElementBasicData AS WBS ON /* join condition not captured in parsed metadata */
;

Learn More