P_ProjectPlanCostDates

DDL: P_PROJECTPLANCOSTDATES SQL: PPROPLNCSTDATE Type: view COMPOSITE Package: VDM_PS_ST

Dates based on Project Actual Costs

P_ProjectPlanCostDates is a Composite CDS View that provides data about "Dates based on Project Actual Costs" in SAP S/4HANA. It reads from 1 data source (P_EnterpriseProjectCosts) and exposes 11 fields. It has 1 association to related views. Part of development package VDM_PS_ST.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
P_EnterpriseProjectCosts CostItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_FiscalYearPeriodForCmpnyCode _FiscalPeriod CostItem.FiscalYear = _FiscalPeriod.FiscalYear and CostItem.FiscalPeriod = _FiscalPeriod.FiscalPeriod and CostItem.CompanyCode = _FiscalPeriod.CompanyCode

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPROPLNCSTDATE view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view

Fields (11)

KeyFieldSource TableSource FieldDescription
Project P_EnterpriseProjectCosts Project
ProjectInternalID P_EnterpriseProjectCosts ProjectInternalID
FiscalYear P_EnterpriseProjectCosts FiscalYear
FiscalPeriod P_EnterpriseProjectCosts FiscalPeriod
CalendarYear
CalendarMonth
CalendarDay
YearMonth
LastDayOfMonthDate
FirstDayOfMonthDate
ActualAmountInGlobalCurrency 
@AbapCatalog.sqlViewName: 'PPROPLNCSTDATE'
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED

@ObjectModel: {
  usageType:{ sizeCategory: #XXL,
              dataClass:    #MIXED,
              serviceQuality: #D    }
}

define view P_ProjectPlanCostDates as
    select from P_EnterpriseProjectCosts  as CostItem
     association [1..1] to I_FiscalYearPeriodForCmpnyCode as _FiscalPeriod on  CostItem.FiscalYear   = _FiscalPeriod.FiscalYear
                                                                        and CostItem.FiscalPeriod = _FiscalPeriod.FiscalPeriod
                                                                        and CostItem.CompanyCode  = _FiscalPeriod.CompanyCode
{
  CostItem.Project,
  CostItem.ProjectInternalID,
  CostItem.FiscalYear,
  CostItem.FiscalPeriod,
  _FiscalPeriod._FiscalPeriodStartDate.CalendarYear, //YYYY

  _FiscalPeriod._FiscalPeriodStartDate.CalendarMonth, //MM

  _FiscalPeriod._FiscalPeriodStartDate.CalendarDay, //DD

  _FiscalPeriod._FiscalPeriodStartDate._YearMonth.YearMonth, //YYYYMM 

  _FiscalPeriod._FiscalPeriodStartDate._YearMonth.LastDayOfMonthDate, //YYYYMMDD

  _FiscalPeriod._FiscalPeriodStartDate._YearMonth.FirstDayOfMonthDate, //YYYYMMDD       

  sum(CostItem.ActualAmountInGlobalCurrency) as ActualAmountInGlobalCurrency  
}
where CostItem.FiscalYearPeriod > '1900000' and CostItem.PlanningCategory = 'PLN'
group by
  CostItem.Project,
  CostItem.ProjectInternalID,
  CostItem.FiscalYear,
  CostItem.FiscalPeriod,
  CostItem.FiscalYearPeriod,
  _FiscalPeriod._FiscalPeriodStartDate.CalendarYear,
  _FiscalPeriod._FiscalPeriodStartDate.CalendarMonth,  
  _FiscalPeriod._FiscalPeriodStartDate.CalendarDay,
  _FiscalPeriod._FiscalPeriodStartDate._YearMonth.YearMonth,
  _FiscalPeriod._FiscalPeriodStartDate._YearMonth.LastDayOfMonthDate,
  _FiscalPeriod._FiscalPeriodStartDate._YearMonth.FirstDayOfMonthDate

Learn More