Srf_RuSumSPLedger

DDL: SRF_RUSUMSPLEDGER SQL: SRFRUSUMSPL Type: view

Add two values together

Srf_RuSumSPLedger is a CDS View that provides data about "Add two values together" in SAP S/4HANA. It reads from 1 data source (I_SAPClient) and exposes 1 field.

Data Sources (1)

SourceAliasJoin Type
I_SAPClient I_SAPClient from

Parameters (2)

NameTypeDefault
P_Amount1 abap.char(100)
P_Amount2 abap.char(100)

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName SRFRUSUMSPL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Add two values together view
ObjectModel.usageType.serviceQuality #P view

Fields (1)

KeyFieldSource TableSource FieldDescription
numc100asaflex17d2o23sendendasSumResult
@AbapCatalog.sqlViewName: 'SRFRUSUMSPL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Add two values together'
@ObjectModel.usageType.serviceQuality: #P
define view Srf_RuSumSPLedger
  with parameters
    P_Amount1 : abap.char(100),
    P_Amount2 : abap.char(100)
  as select from I_SAPClient //dummy select, CDS view only used for calculations


{
  case $parameters.P_Amount1
       when '' then case $parameters.P_Amount2
                      when '' then 0
                              else cast( cast($parameters.P_Amount2 as abap.numc(100)) as aflex17d2o23s)
                    end
               else case $parameters.P_Amount2
                      when '' then cast( cast($parameters.P_Amount1 as abap.numc(100)) as aflex17d2o23s)
                              else cast( cast($parameters.P_Amount1 as abap.numc(100)) as aflex17d2o23s)
                                 + cast( cast($parameters.P_Amount2 as abap.numc(100)) as aflex17d2o23s)
                    end
  end                                                                                                       as SumResult
}