P_DISTINCTDATETOFISCALYEAR
P_DISTINCTDATETOFISCALYEAR is a CDS View in S/4HANA. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_StRpTrialBalanceItem1 | view | left_outer | COMPOSITE |
@AbapCatalog.sqlViewName: 'PDISTDATTOFY'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
define view P_DistinctDatetoFiscalYear
with parameters
P_FromPostingDate : fis_budat_from
as select distinct from I_Distinct_Postingdate{
key I_Distinct_Postingdate.FiscalYearVariant as fiscal_year_variant,
key I_Distinct_Postingdate.FiscalYear as fiscal_year,
I_Distinct_Postingdate.FiscalYearStartDate as fiscal_year_start_date,
I_Distinct_Postingdate.CalendarDate
//I_Distinct_Postingdate.FiscalPeriod
}
where I_Distinct_Postingdate.CalendarDate = $parameters.P_FromPostingDate