P_Calendar
Calendar
P_Calendar is a Composite CDS View that provides data about "Calendar" in SAP S/4HANA. It reads from 1 data source (I_CalendarDate) and exposes 5 fields. Part of development package CRMS4_ANALYTICS_COMMON.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_CalendarDate | I_CalendarDate | from |
Annotations (6)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.private | true | view |
Fields (5)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| FirstDayOfYearDate | ||||
| CalendarDate | CalendarDate | |||
| YearMonth | YearMonth | |||
| YearQuarter | YearQuarter | |||
| YearDay | YearDay |
@AccessControl: {
authorizationCheck: #NOT_REQUIRED,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
//@EndUserText.label: 'Service Contract Days'
@ObjectModel: {
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #B,
sizeCategory: #XXL
}
}
@VDM: {
viewType: #COMPOSITE,
private:true
}
define view entity P_Calendar
as select from I_CalendarDate
{
cast(concat(CalendarYear, '0101') as abap.dats(8)) as FirstDayOfYearDate,
CalendarDate,
YearMonth,
YearQuarter,
// cast(concat('00',cast(CalendarWeek as abap.char( 4 ))) as abap.numc( 4 )) as CalendarWeek,
// cast(concat('00',(cast( cast(CalendarWeek as int4) + 52 as abap.char(12 )))) as abap.numc( 4 )) as EndDateWeek,
YearDay
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA