@AbapCatalog.sqlViewName: 'SRFRUVATFORMV12'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #P
define view SRF_RUVATReturnFormulas_V1_2
with parameters
P_S3Line118 : hwste,
P_S3Line190 : hwste,
P_S4Line030 : hwste,
P_S4Line040 : hwste,
P_S4Line050 : hwste,
P_S4Line080 : hwste,
P_S5Line050 : hwste,
P_S5Line070 : hwste,
P_S6Line030 : hwste,
P_S6Line040 : hwste,
P_S6Line090 : hwste,
P_S6Line100 : hwste,
P_S6Line130 : hwste,
P_S6Line150 : hwste
as select from I_SAPClient
{
// function division by 1 with 0 decimal places is used to round the total value to an integer
division($parameters.P_S3Line118, 1, 0) as S3Line118,
division($parameters.P_S3Line190, 1, 0) as S3Line190,
division($parameters.P_S4Line030, 1, 0) as S4Line030,
division($parameters.P_S4Line040, 1, 0) as S4Line040,
division($parameters.P_S4Line050, 1, 0) as S4Line050,
division($parameters.P_S4Line080, 1, 0) as S4Line080,
division($parameters.P_S5Line050, 1, 0) as S5Line050,
division($parameters.P_S5Line070, 1, 0) as S5Line070,
division($parameters.P_S5Line050, 1, 0) as S5Line080, // the same parameter is used as for S5Line050
division($parameters.P_S5Line070, 1, 0) as S5Line090, // the same parameter is used as for S5Line070
division($parameters.P_S6Line030, 1, 0) as S6Line030,
division($parameters.P_S6Line040, 1, 0) as S6Line040,
division($parameters.P_S6Line030, 1, 0) as S6Line050, // the same parameter is used as for S6Line030
division($parameters.P_S6Line040, 1, 0) as S6Line060, // the same parameter is used as for S6Line040
division($parameters.P_S6Line090, 1, 0) as S6Line090,
division($parameters.P_S6Line100, 1, 0) as S6Line100,
division($parameters.P_S6Line130, 1, 0) as S6Line130,
division($parameters.P_S6Line150, 1, 0) as S6Line150
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SAPCLIENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/