I_FINVALIDATIONRULECNDN

CDS View

Validation Rule Precondition

I_FINVALIDATIONRULECNDN is a CDS View in S/4HANA. Validation Rule Precondition. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_FinValidationRuleCndnTP view_entity from TRANSACTIONAL Validation Rule Precondition
I_PubSecValidationCndnRule view union COMPOSITE Validation Precondition Rule 
@AbapCatalog.sqlViewName: 'IFINREVALDTNRL02'
@Search.searchable: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
   usageType: {
     dataClass:      #CUSTOMIZING,
     serviceQuality: #C,
     sizeCategory:   #L
   }
}
@EndUserText.label: 'Validation Rule Precondition'

define view I_FinValidationRuleCndn as select from finre_ui_cndn as _Condition
  inner join finre_ui_rule as _Rule 
  on _Condition.finsubstitutionvalidationrule = _Rule.finsubstitutionvalidationrule and
     _Rule.finsubstitutionvaldtnruletype = 'V'

{
      @Search.defaultSearchElement: true
  key _Condition.finsubstitutionvalidationrule  as FinSubstitutionValidationRule,
  key _Condition.isactive                       as IsActive,
  key _Condition.finsubstnvaldtnruleexprsqnc    as FinSubstnValdtnRuleExprSqnc,

      _Condition.finsubstnvaldtnrulecndnvaltype as FinSubstnValdtnRuleCndnValType,

      @Search.defaultSearchElement: true
      _Condition.finsubstnvaldtnrulefieldpath   as FinSubstnValdtnRuleFieldPath,
      _Condition.finsubstnvaldtnfunccallleft    as FinSubstnValdtnFuncCallLeft,
      _Condition.finsubstnvaldtnrulecndnrgsg    as FinSubstnValdtnRuleCndnRgSg,
      _Condition.finsubstnvaldtnrulecndnrgop    as FinSubstnValdtnRuleCndnRgOp,
      _Condition.finsubstnvaldtnrulecndnrgfr    as FinSubstnValdtnRuleCndnRgFr,
      _Condition.finsubstnvaldtnrulecndnrgto    as FinSubstnValdtnRuleCndnRgTo,
      _Condition.finsubstnvaldtnrulefieldpath2  as FinSubstnValdtnRuleFieldPath2,
      _Condition.finsubstnvaldtnfunccallrgfr    as FinSubstnValdtnFuncCallRgFr,
      _Condition.finsubstnvaldtnfunccallrgto    as FinSubstnValdtnFuncCallRgTo,
      _Condition.finsubstncstmbusobjcdsview     as FinSubstnCstmBusObjCDSView,
      _Condition.finsubstncstmbusobjsrcefld     as FinSubstnCstmBusObjSrceFld
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINRE_UI_CNDN",
"FINRE_UI_RULE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More