P_CompanyCodeFiscalDetail

DDL: P_COMPANYCODEFISCALDETAIL Type: view_entity CONSUMPTION Package: FKK_ID_GR_REP

CC Fiscal yr details

P_CompanyCodeFiscalDetail is a Consumption CDS View that provides data about "CC Fiscal yr details" in SAP S/4HANA. It reads from 2 data sources (I_CompanyCode, I_FiscalCalendarDtePrevPeriods) and exposes 7 fields with key fields CompanyCode, FiscalYearVariant, FiscalPeriod, FiscalYear. Part of development package FKK_ID_GR_REP.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_CompanyCode _DataSource1 from
I_FiscalCalendarDtePrevPeriods _DataSource2 inner

Parameters (2)

NameTypeDefault
P_ToPostingDate fis_budat_to
P_CompanyCode fis_bukrs

Annotations (6)

NameValueLevelField
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
VDM.private true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode
KEY FiscalYearVariant I_CompanyCode FiscalYearVariant
KEY FiscalPeriod
KEY FiscalYear I_FiscalCalendarDtePrevPeriods FiscalYear
FiscalYearStartDate I_FiscalCalendarDtePrevPeriods FiscalYearStartDate
FiscalYearEndDate I_FiscalCalendarDtePrevPeriods FiscalYearEndDate
PreviousFiscalYearEndDate I_FiscalCalendarDtePrevPeriods PreviousFiscalYearEndDate 
@VDM.viewType: #CONSUMPTION
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #S,
  dataClass: #MASTER
}
@VDM.private:true
define view entity P_CompanyCodeFiscalDetail
  with parameters
    P_ToPostingDate : fis_budat_to,
    P_CompanyCode   : fis_bukrs

  as select from I_CompanyCode                  as _DataSource1
    inner join   I_FiscalCalendarDtePrevPeriods as _DataSource2 on _DataSource1.FiscalYearVariant = _DataSource2.FiscalYearVariant

{
  key _DataSource1.CompanyCode,
  key _DataSource1.FiscalYearVariant,
  key '001' as FiscalPeriod,
  key _DataSource2.FiscalYear,
      _DataSource2.FiscalYearStartDate,
      _DataSource2.FiscalYearEndDate,
      _DataSource2.PreviousFiscalYearEndDate
}
where
      _DataSource1.CompanyCode  = $parameters.P_CompanyCode
  and _DataSource2.CalendarDate = $parameters.P_ToPostingDate
group by
  _DataSource1.CompanyCode,
  _DataSource1.FiscalYearVariant,
  _DataSource2.FiscalPeriod,
  _DataSource2.FiscalYear,
  _DataSource2.FiscalYearStartDate,
  _DataSource2.FiscalYearEndDate,
  _DataSource2.PreviousFiscalYearEndDate

Learn More