Srf_Ushelpamountcodes

DDL: SRF_USHELPAMOUNTCODES SQL: SRFUSHELPAMNTCD Type: view

Amount Codes

Srf_Ushelpamountcodes is a CDS View that provides data about "Amount Codes" 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 (14)

NameTypeDefault
P_AmntCode1 abap.char(1)
P_AmntCode2 abap.char(1)
P_AmntCode3 abap.char(1)
P_AmntCode4 abap.char(1)
P_AmntCode5 abap.char(1)
P_AmntCode6 abap.char(1)
P_AmntCode7 abap.char(1)
P_AmntCode8 abap.char(1)
P_AmntCode9 abap.char(1)
P_AmntCodeA abap.char(1)
P_AmntCodeB abap.char(1)
P_AmntCodeC abap.char(1)
P_AmntCodeD abap.char(1)
P_AmntCodeE abap.char(1)

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName SRFUSHELPAMNTCD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Amount Codes view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (1)

KeyFieldSource TableSource FieldDescription
P_AmntCodeE0asAmntCode
@AbapCatalog.sqlViewName: 'SRFUSHELPAMNTCD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Amount Codes'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MIXED
define view Srf_Ushelpamountcodes
  with parameters
    P_AmntCode1 : abap.char(1),
    P_AmntCode2 : abap.char(1),
    P_AmntCode3 : abap.char(1),
    P_AmntCode4 : abap.char(1),
    P_AmntCode5 : abap.char(1),
    P_AmntCode6 : abap.char(1),
    P_AmntCode7 : abap.char(1),
    P_AmntCode8 : abap.char(1),
    P_AmntCode9 : abap.char(1),
    P_AmntCodeA : abap.char(1),
    P_AmntCodeB : abap.char(1),
    P_AmntCodeC : abap.char(1),
    P_AmntCodeD : abap.char(1),
    P_AmntCodeE : abap.char(1)

  as select from I_SAPClient
{

  replace( replace (concat (

  $parameters.P_AmntCode1,
    concat($parameters.P_AmntCode2,
    concat($parameters.P_AmntCode3,
    concat($parameters.P_AmntCode4,
    concat($parameters.P_AmntCode5,
    concat($parameters.P_AmntCode6,
    concat($parameters.P_AmntCode7,
    concat($parameters.P_AmntCode8,
    concat($parameters.P_AmntCode9,
    concat($parameters.P_AmntCodeA,
    concat($parameters.P_AmntCodeB,
    concat($parameters.P_AmntCodeC,
    concat($parameters.P_AmntCodeD, $parameters.P_AmntCodeE )))))))))) ))), '0', '- -') , '-', ' ' )

     as AmntCode

}  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SAPCLIENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/