P_RblsItmForKeyDteRepPeriod

DDL: P_RBLSITMFORKEYDTEREPPERIOD SQL: PRBLSKDATPERIO Type: view COMPOSITE
4 Fields 1 Data Sources 1 Associations

P_RblsItmForKeyDteRepPeriod is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_FiscCalendarDateForCompCode) and exposes 4 fields with key fields CalendarDate, CompanyCode. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_FiscCalendarDateForCompCode FiscalPeriod from

Parameters (2)

NameTypeDefault
P_KeyDate bzdat
P_PeriodType fis_period_type

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CalendarDate _CalendarDate _CalendarDate.CalendarDate = $projection.CalendarDate

Annotations (7)

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

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CalendarDate I_FiscCalendarDateForCompCode CalendarDate Calendar Date
KEY CompanyCode I_FiscCalendarDateForCompCode CompanyCode Receiver Company Code
CalendarYearendasReportingYear
CalendarWeekendasReportingPeriod

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_RblsItmForKeyDteRepPeriod.
-- 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: PRBLSKDATPERIO
-- Parameters: P_KeyDate : bzdat, P_PeriodType : fis_period_type

CREATE VIEW P_RblsItmForKeyDteRepPeriod AS
SELECT
  FiscalPeriod.CalendarDate AS CalendarDate,
  FiscalPeriod.CompanyCode AS CompanyCode,
  case $parameters.P_PeriodType when 'F' then FiscalPeriod.FiscalYear when 'M' then _CalendarDate.CalendarYear when 'W' then _CalendarDate.CalendarYear end as ReportingYear AS CalendarYearendasReportingYear,
  case $parameters.P_PeriodType when 'F' then FiscalPeriod.FiscalPeriod when 'M' then cast(_CalendarDate.CalendarMonth as char3) when 'W' then _CalendarDate.CalendarWeek end as ReportingPeriod AS CalendarWeekendasReportingPeriod
FROM I_FiscCalendarDateForCompCode AS FiscalPeriod
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON _CalendarDate.CalendarDate = CalendarDate  -- association [0..1]
;

Learn More