P_FundsCenterValidityDate

DDL: P_FUNDSCENTERVALIDITYDATE SQL: PFISTLVALDATE Type: view BASIC

P_FundsCenterValidityDate is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (fm01, fmfctr) and exposes 7 fields with key fields FinancialManagementArea, FundsCenter, FinMgmtAreaFiscalYear. It has 1 association to related views.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
fm01 _FM_Area inner
fmfctr fmfctr from

Associations (1)

CardinalityTargetAliasCondition
[1] I_FiscalYearPeriod _FiscalYearPeriod _FM_Area.ca_periv = _FiscalYearPeriod.FiscalYearVariant and _FiscalYearPeriod.FiscalPeriod = '001'

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
AbapCatalog.sqlViewName PFISTLVALDATE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea fmfctr fikrs
KEY FundsCenter fmfctr fictr
KEY FinMgmtAreaFiscalYear _FiscalYearPeriod FiscalYear
FiscalYearVariant fm01 ca_periv
ValidityEndDate
FiscalYearStartDate _FiscalYearPeriod FiscalYearStartDate
FiscalYearEndDate _FiscalYearPeriod FiscalYearEndDate 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M
@AbapCatalog.sqlViewName: 'PFISTLVALDATE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #BASIC //important!

@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_FundsCenterValidityDate
  as select from fmfctr
    inner join   fm01 as _FM_Area on _FM_Area.fikrs = fmfctr.fikrs

  association [1] to I_FiscalYearPeriod as _FiscalYearPeriod on  _FM_Area.ca_periv              = _FiscalYearPeriod.FiscalYearVariant
                                                             and _FiscalYearPeriod.FiscalPeriod = '001' //restrict cardinality; period 1 is always present


{
  key fmfctr.fikrs                          as FinancialManagementArea,
  key fmfctr.fictr                          as FundsCenter,
  key _FiscalYearPeriod.FiscalYear          as FinMgmtAreaFiscalYear,
      _FM_Area.ca_periv                     as FiscalYearVariant,
      max( fmfctr.datbis )                  as ValidityEndDate,
      _FiscalYearPeriod.FiscalYearStartDate as FiscalYearStartDate,
      _FiscalYearPeriod.FiscalYearEndDate   as FiscalYearEndDate

}

where
  (
        fmfctr.datbis >= _FiscalYearPeriod.FiscalYearEndDate
    and fmfctr.datab  <= _FiscalYearPeriod.FiscalYearStartDate
  )
  or(
        fmfctr.datbis >= _FiscalYearPeriod.FiscalYearStartDate
    and fmfctr.datab  <= _FiscalYearPeriod.FiscalYearStartDate
  )
  or(
        fmfctr.datbis <= _FiscalYearPeriod.FiscalYearEndDate
    and fmfctr.datab  >= _FiscalYearPeriod.FiscalYearStartDate
  )
  or(
        fmfctr.datbis >= _FiscalYearPeriod.FiscalYearEndDate
    and fmfctr.datab  <= _FiscalYearPeriod.FiscalYearEndDate
  )

group by
  fmfctr.fikrs,
  fmfctr.fictr,
  _FiscalYearPeriod.FiscalYear,
  _FM_Area.ca_periv,
  _FiscalYearPeriod.FiscalYearEndDate,
  _FiscalYearPeriod.FiscalYearStartDate
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FISCALYEARPERIOD",
"FM01",
"FMFCTR"
],
"ASSOCIATED":
[
"I_FISCALYEARPERIOD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More