P_Distinct_Postingdate

DDL: P_DISTINCT_POSTINGDATE SQL: PFIDISTPOSTDATE Type: view BASIC

P_Distinct_Postingdate is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (P_FiscalCalendarDate, P_FiscalYearPeriod) and exposes 2 fields with key field fiscal_year.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
P_FiscalCalendarDate P_FiscalCalendarDate inner
P_FiscalYearPeriod P_FiscalYearPeriod from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PFIDISTPOSTDATE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.preserveKey true view
Metadata.ignorePropagatedAnnotations true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY fiscal_year P_FiscalYearPeriod fiscal_year
FiscalPeriodDate 
@AbapCatalog.sqlViewName: 'PFIDISTPOSTDATE'
@AbapCatalog.compiler.compareFilter: true
//@EndUserText.label: 'Distinct Posting Date'

@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.preserveKey:true
@Metadata.ignorePropagatedAnnotations: true 
//define view P_Distinct_Postingdate as select from finsc_ld_cmp

//inner join P_FiscalCalendarDate on finsc_ld_cmp.periv = P_FiscalCalendarDate.fiscal_year_variant

//{

//  key cast( finsc_ld_cmp.bukrs as FIS_BUKRS) as bukrs,

//  key cast( finsc_ld_cmp.rldnr as FIS_RLDNR) as rldnr,

//  key P_FiscalCalendarDate.fiscal_year,

//  

//  P_FiscalCalendarDate.fiscal_period,

//  P_FiscalCalendarDate.calendar_date,

//  P_FiscalCalendarDate.fiscal_year_period,

//  P_FiscalCalendarDate.fiscal_year_start_date

//  

//}

define view P_Distinct_Postingdate as select from P_FiscalYearPeriod 
inner join P_FiscalCalendarDate on P_FiscalYearPeriod.fiscal_year_variant = P_FiscalCalendarDate.fiscal_year_variant 
                               and P_FiscalYearPeriod.fiscal_year = P_FiscalCalendarDate.fiscal_year 
                               and ( P_FiscalYearPeriod.fiscal_period_start_date <= P_FiscalCalendarDate.calendar_date  and
                                     P_FiscalYearPeriod.fiscal_period_end_date >= P_FiscalCalendarDate.calendar_date   )                             


{
  key P_FiscalYearPeriod.fiscal_year_variant,  
  key P_FiscalYearPeriod.fiscal_year,
  
  key P_FiscalYearPeriod.fiscal_period,
  key P_FiscalCalendarDate.calendar_date,

  P_FiscalYearPeriod.is_special_period,
  P_FiscalYearPeriod.fiscal_year_period,
  P_FiscalCalendarDate.fiscal_year_start_date,
  P_FiscalCalendarDate.fiscal_year_end_date,
  
  cast( concat( P_FiscalCalendarDate.calendar_date, P_FiscalYearPeriod.fiscal_period ) as fis_fiscalperiod_date) as FiscalPeriodDate,
  
  P_FiscalYearPeriod.fiscal_period_end_date
    
}     
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_FISCALCALENDARDATE",
"P_FISCALYEARPERIOD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More