P_SRVCCONTRFIN

CDS View

P_SRVCCONTRFIN is a CDS View in S/4HANA. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_SrvcContrFinPeriodicSum view from COMPOSITE
P_SrvcContrFinSum view from COMPOSITE 
@AbapCatalog.sqlViewName: 'PSRVCCONTRFIN'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey: true
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
//@EndUserText.label: 'Year to Date Service contract financial data'


@ObjectModel: {
   usageType: {
     dataClass:      #MIXED,
     serviceQuality: #D,
     sizeCategory:   #XXL
   }
   }
@VDM: {
  viewType: #COMPOSITE,
  private:true
}
define view P_SrvcContrFin
  as select from P_SrvcContrFinance as _YTDFinance
  association [0..1] to P_Calendar     as _Calendar     on _Calendar.CalendarDate = $session.system_date
  association [0..1] to I_CalendarDate as _CalendarDate on _CalendarDate.CalendarDate = _YTDFinance.CreationDate
{
  key   ServiceContract,
  key   CompanyCodeCurrency,
        RevenueAmountInCompanyCodeCrcy,
        CostAmountInCompanyCodeCrcy,
        CreationDate,
        PostingDate,
        _CalendarDate.CalendarQuarter  as CalendarQuarter,
        _CalendarDate.CalendarYear     as CalendarYear,
        _CalendarDate.CalendarMonth    as CalendarMonth,
        _CalendarDate.CalendarWeek     as CalendarWeek,

        RecognizedMarginAmtInCCCrcy    as SrvcContrProfitabilityInDC,

        case
           when _Calendar.FirstDayOfYearDate <= CreationDate and CreationDate <= $session.system_date
           then RevenueAmountInCompanyCodeCrcy
           end                         as YTDSrvcContrRevnAmtInDC,

        case
        when _Calendar.FirstDayOfYearDate <= CreationDate and CreationDate <= $session.system_date
        then CostAmountInCompanyCodeCrcy
        end                            as YTDSrvcContrCostInDC,

        case
        when _Calendar.FirstDayOfYearDate <= CreationDate and CreationDate <= $session.system_date
        then RecognizedMarginAmtInCCCrcy
        end                            as YTDSrvcContrPrftMarginAmtInDC,

        _CalendarDate._CalendarMonth   as _CalendarMonth,
        _CalendarDate._CalendarQuarter as _CalendarQuarter,
        _CalendarDate._CalendarYear    as _CalendarYear

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE",
"P_CALENDAR",
"P_SRVCCONTRFINANCE"
],
"ASSOCIATED":
[
"I_CALENDARDATE",
"I_CALENDARMONTH",
"I_CALENDARQUARTER",
"I_CALENDARYEAR",
"P_CALENDAR"
],
"BASE":
[
"I_CALENDARDATE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More