ACR_PL_SAFT_HELPER_SUM_AMOUNT

DDL: ACR_PL_SAFT_HELPER_SUM_AMOUNT SQL: ACRPLSAFTHLPSUMA Type: view

SAF-T PL: Helper class for sum amounts

ACR_PL_SAFT_HELPER_SUM_AMOUNT is a CDS View that provides data about "SAF-T PL: Helper class for sum amounts" in SAP S/4HANA. It reads from 1 data source (I_SAPClient) and exposes 2 fields.

Data Sources (1)

SourceAliasJoin Type
I_SAPClient I_SAPClient from

Parameters (16)

NameTypeDefault
P_Currency waers
P_AddAmount1 saft_pl_field_amount
P_AddAmount2 saft_pl_field_amount
P_AddAmount3 saft_pl_field_amount
P_AddAmount4 saft_pl_field_amount
P_AddAmount5 saft_pl_field_amount
P_AddAmount6 saft_pl_field_amount
P_AddAmount7 saft_pl_field_amount
P_AddAmount8 saft_pl_field_amount
P_AddAmount9 saft_pl_field_amount
P_AddAmount10 saft_pl_field_amount
P_AddAmount11 saft_pl_field_amount
P_AddAmount12 saft_pl_field_amount
P_AddAmount13 saft_pl_field_amount
P_SubAmount1 saft_pl_field_amount
P_SubAmount2 saft_pl_field_amount

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ACRPLSAFTHLPSUMA view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #D view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label SAF-T PL: Helper class for sum amounts view

Fields (2)

KeyFieldSource TableSource FieldDescription
Currency
P_SubAmount2asTotalAmount
@AbapCatalog.sqlViewName: 'ACRPLSAFTHLPSUMA'
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling: { type: #INHERITED, algorithm: #SESSION_VARIABLE }
@ObjectModel.usageType: { dataClass: #MIXED, sizeCategory: #S, serviceQuality: #D }
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.preserveKey:true
@EndUserText.label: 'SAF-T PL: Helper class for sum amounts'
define view ACR_PL_SAFT_HELPER_SUM_AMOUNT
  with parameters
    P_Currency    : waers,
    P_AddAmount1  : saft_pl_field_amount,
    P_AddAmount2  : saft_pl_field_amount,
    P_AddAmount3  : saft_pl_field_amount,
    P_AddAmount4  : saft_pl_field_amount,
    P_AddAmount5  : saft_pl_field_amount,
    P_AddAmount6  : saft_pl_field_amount,
    P_AddAmount7  : saft_pl_field_amount,
    P_AddAmount8  : saft_pl_field_amount,
    P_AddAmount9  : saft_pl_field_amount,
    P_AddAmount10 : saft_pl_field_amount,
    P_AddAmount11 : saft_pl_field_amount,
    P_AddAmount12 : saft_pl_field_amount,
    P_AddAmount13 : saft_pl_field_amount,
    P_SubAmount1  : saft_pl_field_amount,
    P_SubAmount2  : saft_pl_field_amount
  as select from I_SAPClient
{

  @Semantics.currencyCode: true
  $parameters.P_Currency                                 as Currency,

  @Semantics.amount.currencyCode: 'Currency'
  ($parameters.P_AddAmount1 + $parameters.P_AddAmount2 +
  $parameters.P_AddAmount3 + $parameters.P_AddAmount4 +
  $parameters.P_AddAmount5 + $parameters.P_AddAmount6 +
  $parameters.P_AddAmount7 + $parameters.P_AddAmount8 +
  $parameters.P_AddAmount9 + $parameters.P_AddAmount10 +
  $parameters.P_AddAmount11 + $parameters.P_AddAmount12 +
  $parameters.P_AddAmount13 )
  -
  ( $parameters.P_SubAmount1 +$parameters.P_SubAmount2 ) as TotalAmount

}