P_ProjFiscalTRSPCLPerd

DDL: P_PROJFISCALTRSPCLPERD SQL: PPCLCSTRNGE1 Type: view COMPOSITE

P_ProjFiscalTRSPCLPerd is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_CompanyCode, I_ControllingArea, I_FiscalCalendarDate) and exposes 6 fields with key fields Project, FiscalYearPeriod.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode inner
I_ControllingArea I_ControllingArea inner
I_FiscalCalendarDate I_FiscalCalendarDate inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPCLCSTRNGE1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Project I_ProjectBasicData Project
KEY FiscalYearPeriod I_FiscalCalendarDate FiscalYearPeriod
FiscalYear I_FiscalCalendarDate FiscalYear
FiscalPeriod I_FiscalCalendarDate FiscalPeriod
FiscalPeriodName
GlobalCurrency I_ControllingArea ControllingAreaCurrency 
@AbapCatalog.sqlViewName: 'PPCLCSTRNGE1'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true 
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #COMPOSITE
@VDM.private: true

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:    #MIXED
@ObjectModel.usageType.serviceQuality: #C

@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_ProjFiscalTRSPCLPerd
  as select distinct from I_ProjectBasicData
    inner join            I_CompanyCode          on I_CompanyCode.CompanyCode = I_ProjectBasicData.CompanyCode
    inner join            I_FiscalCalendarDate   on I_CompanyCode.FiscalYearVariant = I_FiscalCalendarDate.FiscalYearVariant
    inner join            I_ControllingArea      on I_ControllingArea.ControllingArea      =  I_ProjectBasicData.ControllingArea
    association [0..1] to I_FiscalYearPeriodText on  I_FiscalCalendarDate.FiscalYearVariant = I_FiscalYearPeriodText.FiscalYearVariant
                                                 and I_FiscalCalendarDate.FiscalYear        = I_FiscalYearPeriodText.FiscalYear
                                                 and I_FiscalCalendarDate.FiscalPeriod      = I_FiscalYearPeriodText.FiscalPeriod
                                                 
{

  key I_ProjectBasicData.Project,
  key I_FiscalCalendarDate.FiscalYearPeriod,
      I_FiscalCalendarDate.FiscalYear,
      I_FiscalCalendarDate.FiscalPeriod,
      I_FiscalYearPeriodText[1:Language =  $session.system_language].FiscalPeriodName,
      I_ControllingArea.ControllingAreaCurrency as GlobalCurrency

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_FISCALCALENDARDATE",
"I_FISCALYEARPERIODTEXT",
"I_PROJECTBASICDATA"
],
"ASSOCIATED":
[
"I_FISCALYEARPERIODTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More