C_PRAStateInterestOptionTP

DDL: C_PRASTATEINTERESTOPTIONTP Type: view_entity CONSUMPTION

PRA State Interest Option

C_PRAStateInterestOptionTP is a Consumption CDS View that provides data about "PRA State Interest Option" in SAP S/4HANA. It reads from 1 data source (R_PRAStateInterestOptionTP) and exposes 18 fields with key fields Country, PrimaryGeogrlLocation, PRAInterestOption, PRAStateIntrstOptnEffctvFrmDte.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
R_PRAStateInterestOptionTP R_PRAStateInterestOptionTP projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label PRA State Interest Option view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Metadata.allowExtensions true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY Country Country
KEY PrimaryGeogrlLocation PrimaryGeogrlLocation
KEY PRAInterestOption PRAInterestOption
KEY PRAStateIntrstOptnEffctvFrmDte PRAStateIntrstOptnEffctvFrmDte
PRAStateIntrstOptnEffctvToDate PRAStateIntrstOptnEffctvToDate
PRAInterestFormulaNumber PRAInterestFormulaNumber
PRAInterestOptionDesc PRAInterestOptionDesc
PRAInterestRateDateSelection PRAInterestRateDateSelection
PRAInterestCalculationType PRAInterestCalculationType
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
PrimaryGeogrlLocationName
_Country _Country
_CreatedByUser _CreatedByUser
_PRAInterestFormulaNumberVH _PRAInterestFormulaNumberVH
_PrimaryGeogrlLocation _PrimaryGeogrlLocation
_PRAInterestRateDateSel _PRAInterestRateDateSel
_PRAInterestCalcType _PRAInterestCalcType 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'PRA State Interest Option'

@VDM: {
  viewType: #CONSUMPTION,
  usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ] }

@ObjectModel.usageType:
{
  serviceQuality: #C,
  sizeCategory: #M,
  dataClass: #MASTER
}

@Metadata.allowExtensions: true
define root view entity C_PRAStateInterestOptionTP
  provider contract transactional_query
  as projection on R_PRAStateInterestOptionTP
{
      @ObjectModel.foreignKey.association: '_Country'   
  key Country,
      @ObjectModel.foreignKey.association: '_PrimaryGeogrlLocation'
  key PrimaryGeogrlLocation,
  key PRAInterestOption,
  key PRAStateIntrstOptnEffctvFrmDte,
      PRAStateIntrstOptnEffctvToDate,
      PRAInterestFormulaNumber,
      @Consumption.filter.hidden: true
      PRAInterestOptionDesc, 
      @ObjectModel.foreignKey.association: '_PRAInterestRateDateSel'
      PRAInterestRateDateSelection,
      @ObjectModel.foreignKey.association: '_PRAInterestCalcType'
      PRAInterestCalculationType,
      @Consumption.filter.hidden: true
      CreatedByUser,
      @Consumption.filter.hidden: true
      CreationDateTime,  
//      

      _PrimaryGeogrlLocation._Text[ 1: Language = $session.system_language ].PrimaryGeogrlLocationName as PrimaryGeogrlLocationName,
      /* Associations */
      @Consumption.filter.hidden: true
      _Country,
      @Consumption.filter.hidden: true
      _CreatedByUser,
      @Consumption.filter.hidden: true
      _PRAInterestFormulaNumberVH,
      @Consumption.filter.hidden: true
      _PrimaryGeogrlLocation,
      @Consumption.filter.hidden: true
      _PRAInterestRateDateSel,
      @Consumption.filter.hidden: true
      _PRAInterestCalcType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRIMARYGEOGRLLOCATION",
"I_PRIMARYGEOGRLLOCATIONTEXT",
"R_PRASTATEINTERESTOPTIONTP"
],
"ASSOCIATED":
[
"I_COUNTRYVH",
"I_PRAINTERESTCALCTYPE",
"I_PRAINTERESTFORMULANUMBERVH",
"I_PRAINTERESTRATEDATESEL",
"I_PRIMARYGEOGRLLOCATION",
"I_USER"
],
"BASE":
[
"R_PRASTATEINTERESTOPTIONTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More