I_PMRPBucket

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_PMRPBucket.
-- 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_PMRPBucket AS
SELECT
  reference_id AS PMRPReferencePlan,
  bucket_id AS BucketInternalID,
  first_day_date AS PMRPBucketStartDate,
  last_day_date AS PMRPBucketEndDate,
  bucket_year AS PMRPBucketYear,
  bucket_period AS PMRPBucketPeriod,
  bucket_category AS PMRPBucketCategory
FROM pmrp_bucket_def
LEFT OUTER JOIN I_PMRPBucketCategory AS _PMRPBucketCategory ON PMRPBucketCategory = _PMRPBucketCategory.PMRPBucketCategory  -- association [1..1]
LEFT OUTER JOIN I_CalendarMonth AS _CalendarMonth ON PMRPBucketPeriod = _CalendarMonth.CalendarMonth  -- association [0..1]
LEFT OUTER JOIN I_CalendarYear AS _CalendarYear ON PMRPBucketYear = _CalendarYear.CalendarYear  -- association [0..1]
;