Srf_UsHelpAmount

DDL: SRF_USHELPAMOUNT SQL: SRFUSHELPAMOUNT Type: view

Helper view to convert amount with no decimals

Srf_UsHelpAmount is a CDS View that provides data about "Helper view to convert amount with no decimals" in SAP S/4HANA. It reads from 1 data source (I_SAPClient) and exposes 28 fields.

Data Sources (1)

SourceAliasJoin Type
I_SAPClient I_SAPClient from

Parameters (14)

NameTypeDefault
P_PayAmnt1 abap.curr( 23,2)
P_PayAmnt2 abap.curr( 23,2)
P_PayAmnt3 abap.curr( 23,2)
P_PayAmnt4 abap.curr( 23,2)
P_PayAmnt5 abap.curr( 23,2)
P_PayAmnt6 abap.curr( 23,2)
P_PayAmnt7 abap.curr( 23,2)
P_PayAmnt8 abap.curr( 23,2)
P_PayAmnt9 abap.curr( 23,2)
P_PayAmntA abap.curr( 23,2)
P_PayAmntB abap.curr( 23,2)
P_PayAmntC abap.curr( 23,2)
P_PayAmntD abap.curr( 23,2)
P_PayAmntE abap.curr( 23,2)

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName SRFUSHELPAMOUNT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Helper view to convert amount with no decimals view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (28)

KeyFieldSource TableSource FieldDescription
TaxBaseAmnt1
P_PayAmnt1when0then0else1endasAmntCode1
TaxBaseAmnt2
P_PayAmnt2when0then0else2endasAmntCode2
TaxBaseAmnt3
P_PayAmnt3when0then0else3endasAmntCode3
TaxAmnt4
P_PayAmnt4when0then0else4endasAmntCode4
TaxBaseAmnt5
P_PayAmnt5when0then0else5endasAmntCode5
TaxBaseAmnt6
P_PayAmnt6when0then0else6endasAmntCode6
TaxBaseAmnt7
P_PayAmnt7when0then0else7endasAmntCode7
TaxBaseAmnt8
P_PayAmnt8when0then0else8endasAmntCode8
TaxBaseAmnt9
P_PayAmnt9when0then0else9endasAmntCode9
TaxBaseAmntA
P_PayAmntAwhen0then0elseAendasAmntCodeA
TaxBaseAmntB
P_PayAmntBwhen0then0elseBendasAmntCodeB
TaxBaseAmntC
P_PayAmntCwhen0then0elseCendasAmntCodeC
TaxBaseAmntD
P_PayAmntDwhen0then0elseDendasAmntCodeD
TaxBaseAmntE
P_PayAmntEwhen0then0elseEendasAmntCodeE
@AbapCatalog.sqlViewName: 'SRFUSHELPAMOUNT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Helper view to convert amount with no decimals'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MIXED

define view Srf_UsHelpAmount
  with parameters
    P_PayAmnt1 : abap.curr( 23,2),
    P_PayAmnt2 : abap.curr( 23,2),
    P_PayAmnt3 : abap.curr( 23,2),
    P_PayAmnt4 : abap.curr( 23,2),
    P_PayAmnt5 : abap.curr( 23,2),
    P_PayAmnt6 : abap.curr( 23,2),
    P_PayAmnt7 : abap.curr( 23,2),
    P_PayAmnt8 : abap.curr( 23,2),
    P_PayAmnt9 : abap.curr( 23,2),
    P_PayAmntA : abap.curr( 23,2),
    P_PayAmntB : abap.curr( 23,2),
    P_PayAmntC : abap.curr( 23,2),
    P_PayAmntD : abap.curr( 23,2),
    P_PayAmntE : abap.curr( 23,2)

  as select from I_SAPClient
{
  cast(($parameters.P_PayAmnt1 * 100) as abap.dec( 23, 0))  as TaxBaseAmnt1,
  case $parameters.P_PayAmnt1
  when 0 then '0'
  else '1' end                                              as AmntCode1,

  cast(($parameters.P_PayAmnt2 * 100) as abap.dec( 23, 0))  as TaxBaseAmnt2,
  case $parameters.P_PayAmnt2
   when 0 then '0'
   else '2' end                                             as AmntCode2,

  cast(($parameters.P_PayAmnt3 * 100) as abap.dec( 23, 0))  as TaxBaseAmnt3,
  case $parameters.P_PayAmnt3
  when 0 then '0'
  else '3' end                                              as AmntCode3,

  cast(($parameters.P_PayAmnt4 * 100) as abap.dec( 23, 0))  as TaxAmnt4,
  case $parameters.P_PayAmnt4
  when 0 then '0'
  else '4' end                                              as AmntCode4,

  cast(($parameters.P_PayAmnt5 * 100) as abap.dec( 23, 0))  as TaxBaseAmnt5,
  case $parameters.P_PayAmnt5
  when 0 then '0'
  else '5' end                                              as AmntCode5,

  cast(($parameters.P_PayAmnt6 * 100) as abap.dec( 23, 0))  as TaxBaseAmnt6,

  case $parameters.P_PayAmnt6
  when 0 then '0'
  else '6' end                                              as AmntCode6,

  cast(($parameters.P_PayAmnt7 * 100) as abap.dec( 23, 0))  as TaxBaseAmnt7,
  case $parameters.P_PayAmnt7
  when 0 then '0'
  else '7' end                                              as AmntCode7,

  cast(($parameters.P_PayAmnt8 * 100) as abap.dec( 23, 0))  as TaxBaseAmnt8,
  case $parameters.P_PayAmnt8
   when 0 then '0'
   else '8' end                                             as AmntCode8,

  cast(($parameters.P_PayAmnt9 * 100) as abap.dec( 23, 0))  as TaxBaseAmnt9,
  case $parameters.P_PayAmnt9
   when 0 then '0'
   else '9' end                                             as AmntCode9,

  cast(($parameters.P_PayAmntA * 100) as abap.dec( 23, 0))  as TaxBaseAmntA,
  case $parameters.P_PayAmntA
   when 0 then '0'
   else 'A' end                                             as AmntCodeA,

  cast(($parameters.P_PayAmntB * 100) as abap.dec( 23, 0))  as TaxBaseAmntB,
  case $parameters.P_PayAmntB
   when 0 then '0'
   else 'B' end                                             as AmntCodeB,

  cast(($parameters.P_PayAmntC * 100) as abap.dec( 23, 0))  as TaxBaseAmntC,

  case $parameters.P_PayAmntC
   when 0 then '0'
   else 'C' end                                             as AmntCodeC,

  cast(($parameters.P_PayAmntD * 100) as abap.dec( 23, 0))  as TaxBaseAmntD,

  case $parameters.P_PayAmntD
   when 0 then '0'
   else 'D' end                                             as AmntCodeD,

  cast(($parameters.P_PayAmntE * 100) as abap.dec( 23, 0))  as TaxBaseAmntE,
  case $parameters.P_PayAmntE
   when 0 then '0'
   else 'E' end                                             as AmntCodeE


}