R_ScrtyClCndnFormulaVariableTP

DDL: R_SCRTYCLCNDNFORMULAVARIABLETP Type: view_entity TRANSACTIONAL Package: RAP_FIN_TRM_SEC_SC

Scrty Class Condition Formula Variable

R_ScrtyClCndnFormulaVariableTP is a Transactional CDS View that provides data about "Scrty Class Condition Formula Variable" in SAP S/4HANA. It reads from 1 data source (I_ScrtyClCndnFormulaVariable) and exposes 10 fields with key fields SecurityClass, FinConditionConditionType, FinConditionFormulaReference, FinCndnFormulaVariable. It has 1 association to related views. Part of development package RAP_FIN_TRM_SEC_SC.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_ScrtyClCndnFormulaVariable I_ScrtyClCndnFormulaVariable from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_SecurityClassTP _SecurityClass $projection.SecurityClass = _SecurityClass.SecurityClass

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Scrty Class Condition Formula Variable view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SecurityClass SecurityClass
KEY FinConditionConditionType FinConditionConditionType
KEY FinConditionFormulaReference FinConditionFormulaReference
KEY FinCndnFormulaVariable FinCndnFormulaVariable
ConditionPercentageRate ConditionPercentageRate
InterestReference InterestReference
FinCndnFluctuationMarginRate FinCndnFluctuationMarginRate
_SecurityClassCondition _SecurityClassCondition
_SecurityClass _SecurityClass
_SecurityClassBasic _SecurityClassBasic 
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #TRANSACTIONAL
@ObjectModel:{
    usageType : {
        sizeCategory: #M,
        serviceQuality: #B,
        dataClass: #MASTER
    }
}
@EndUserText.label: 'Scrty Class Condition Formula Variable'
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
define view entity R_ScrtyClCndnFormulaVariableTP
  as select from I_ScrtyClCndnFormulaVariable
  association to parent R_SecurityClassConditionTP as _SecurityClassCondition on  $projection.SecurityClass                  = _SecurityClassCondition.SecurityClass
                                                                              and $projection.FinConditionConditionType      = _SecurityClassCondition.FinConditionConditionType
                                                                              and $projection.ConditionItemValidityStartDate = _SecurityClassCondition.ConditionItemValidityStartDate

  association [1..1] to R_SecurityClassTP as _SecurityClass on $projection.SecurityClass = _SecurityClass.SecurityClass
{

  key SecurityClass,
  key FinConditionConditionType,
  key case
        when dats_is_valid(ConditionItemValidityStartDate) = 1
          then ConditionItemValidityStartDate
        else
          '99991231'
      end as ConditionItemValidityStartDate,     
  key FinConditionFormulaReference,
  key FinCndnFormulaVariable,  
      ConditionPercentageRate,
      InterestReference,
      FinCndnFluctuationMarginRate,

      _SecurityClassCondition,
      _SecurityClass,

      @Consumption.hidden: true
      _SecurityClassBasic
}
where
  I_ScrtyClCndnFormulaVariable.FinConditionSubItem = '00'

Learn More