I_ProjectPortfolioBucketBasic

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_ProjectPortfolioBucketBasic.
-- 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.

CREATE VIEW I_ProjectPortfolioBucketBasic AS
SELECT
  guid AS ProjectPortfolioBucketUUID,
  external_id AS ProjPortfolioBucketExternalID,
  portfolio_guid AS ProjectPortfolioUUID,
  parent_guid AS ParentObjectUUID,
  _Portfolio.ProjectPortfolioMasterLanguage AS ProjectPortfolioMasterLanguage,
  currency AS ProjPrtfloBcktFinCurrency,
  period_type AS ProjPrtfloBcktFinPlngPerdType,
  unit AS ProjPrtfloBucketCapacityUnit,
  changed_by AS LastChangedByUser,
  cast(changed_on as timestamp preserving type) AS LastChangeDateTime,
  release_status AS ProjPrtfloBucketReleaseStatus,
  begda_dem AS ProjPrtfloBcktCapPlngStartDate,
  endda_dem AS PrjPrtfloBcktCapPlngFinishDate,
  begda_fin AS ProjPrtfloBcktFinPlngStartDate,
  endda_fin AS PrjPrtfloBcktFinPlngFinishDate,
  cap_period_type AS ProjPrtfloBcktCapPlngPerdType,
  begda_co AS ProjPrtfloBcktTransfStartDate,
  endda_co AS ProjPrtfloBcktTransfFinishDate,
  _PortfolioLanguage.PrjPortfolioDefaultLanguage AS PrjPortfolioDefaultLanguage,
  _ProjectPortfolioData.CreatedByUser AS CreatedByUser,
  _ProjectPortfolioData.ProjectPortfolioCreatedOnDate AS ProjPrtfloBucketCreatedOnDate
FROM /rpm/bucket_d
LEFT OUTER JOIN I_ProjectPortfolioPlanningData AS _ProjectPortfolioData ON ProjectPortfolioBucketUUID = _ProjectPortfolioData.ProjectPortfolioPlanningUUID  -- association [1..1]
LEFT OUTER JOIN I_ProjectPortfolioBasic AS _Portfolio ON ProjectPortfolioUUID = _Portfolio.ProjectPortfolioUUID  -- association [1..1]
LEFT OUTER JOIN I_ProjectPortfolioLanguage AS _PortfolioLanguage ON _PortfolioLanguage.IsDefaultLanguage = 'X'  -- association [1..1]
;