P_PREVIOUS365DAYS

DDL: P_PREVIOUS365DAYS SQL: PPREVIOUS365DAYS Type: view CONSUMPTION
7 Fields 1 Data Sources

P_PREVIOUS365DAYS is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (C_SglGregorianCalDateFunction) and exposes 7 fields.

Data Sources (1)

SourceAliasJoin Type
C_SglGregorianCalDateFunction C_SglGregorianCalDateFunction from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PPREVIOUS365DAYS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (7)

KeyFieldSource TableSource FieldDescription
DateFunction DateFunction Relative Date Function
DateFunctionDescription DateFunctionDescription
DateFunctionEndDate DateFunctionEndDate Date Func End Date
DateFunctionGranularity DateFunctionGranularity
DateFunctionName DateFunctionName
DateFunctionStartDate DateFunctionStartDate Date Func Start Date
DateFunctionType DateFunctionType

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_PREVIOUS365DAYS.
-- 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: PPREVIOUS365DAYS

CREATE VIEW P_PREVIOUS365DAYS AS
SELECT
  DateFunction,
  DateFunctionDescription,
  DateFunctionEndDate,
  DateFunctionGranularity,
  DateFunctionName,
  DateFunctionStartDate,
  DateFunctionType
FROM C_SglGregorianCalDateFunction
;

Learn More