I_PubSecValidationCndnRule

DDL: I_PUBSECVALIDATIONCNDNRULE SQL: IPSMVALCNDRUL Type: view COMPOSITE

Validation Precondition Rule

I_PubSecValidationCndnRule is a Composite CDS View that provides data about "Validation Precondition Rule" in SAP S/4HANA. It reads from 3 data sources (I_FinSubstitutionRuleCndn, I_FinValidationRuleCndn, I_FinValidationRuleValdtn) and exposes 20 fields with key fields FinSubstitutionValidationRule, IsActive, IsActive, IsActive.

3 data source(s) 20 fields

Data Sources (3)

SourceAliasJoin Type
I_FinSubstitutionRuleCndn I_FinSubstitutionRuleCndn from
I_FinValidationRuleCndn I_FinValidationRuleCndn union
I_FinValidationRuleValdtn I_FinValidationRuleValdtn union

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPSMVALCNDRUL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Validation Precondition Rule view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY FinSubstitutionValidationRule FinSubstitutionValidationRule
KEY IsActive IsActive
FinSubstnValdtnRuleCndnValType FinSubstnValdtnRuleCndnValType
FinSubstnValdtnRuleFieldPath FinSubstnValdtnRuleFieldPath
FinSubstnValdtnRuleCndnRgSg FinSubstnValdtnRuleCndnRgSg
FinSubstnValdtnRuleCndnRgOp FinSubstnValdtnRuleCndnRgOp
RangeFromValue
KEY IsActive IsActive
FinSubstnValdtnRuleCndnValType FinSubstnValdtnRuleCndnValType
FinSubstnValdtnRuleFieldPath FinSubstnValdtnRuleFieldPath
FinSubstnValdtnRuleCndnRgSg FinSubstnValdtnRuleCndnRgSg
FinSubstnValdtnRuleCndnRgOp FinSubstnValdtnRuleCndnRgOp
RangeFromValue
KEY IsActive IsActive
FinSubstnValdtnRuleCndnValType FinSubstnValdtnRuleCndnValType
FinSubstnValdtnRuleFieldPath FinSubstnValdtnRuleFieldPath
FinSubstnValdtnRuleCndnRgSg FinSubstnValdtnRuleCndnRgSg
FinSubstnValdtnRuleCndnRgOp FinSubstnValdtnRuleCndnRgOp
RangeFromValue
RangeToValue 
@AbapCatalog.sqlViewName: 'IPSMVALCNDRUL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Validation Precondition Rule'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
  sizeCategory: #L,
  serviceQuality: #C,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE

define view I_PubSecValidationCndnRule
  as select from I_FinSubstitutionRuleCndn
{
  key FinSubstitutionValidationRule                       as FinSubstitutionValidationRule,
  key IsActive                                            as IsActive,
      FinSubstnValdtnRuleCndnValType                      as FinSubstnValdtnRuleCndnValType,
      FinSubstnValdtnRuleFieldPath                        as FinSubstnValdtnRuleFieldPath,
      FinSubstnValdtnRuleCndnRgSg                         as FinSubstnValdtnRuleCndnRgSg,
      FinSubstnValdtnRuleCndnRgOp                         as FinSubstnValdtnRuleCndnRgOp,
      cast (FinSubstnValdtnRuleCndnRgFr as abap.numc(20)) as RangeFromValue,
      cast (FinSubstnValdtnRuleCndnRgTo as abap.numc(20)) as RangeToValue
      
}

union 
  select from I_FinValidationRuleCndn
  {
  key FinSubstitutionValidationRule,
  key IsActive,
      FinSubstnValdtnRuleCndnValType,
      FinSubstnValdtnRuleFieldPath,
      FinSubstnValdtnRuleCndnRgSg,
      FinSubstnValdtnRuleCndnRgOp,
      cast (FinSubstnValdtnRuleCndnRgFr as abap.numc(20)) as RangeFromValue,
      cast (FinSubstnValdtnRuleCndnRgTo as abap.numc(20)) as RangeToValue

}


union 
  select from I_FinValidationRuleValdtn

{
  key FinSubstitutionValidationRule,
  key IsActive,
      FinSubstnValdtnRuleCndnValType,
      FinSubstnValdtnRuleFieldPath,
      FinSubstnValdtnRuleCndnRgSg,
      FinSubstnValdtnRuleCndnRgOp,
      cast (FinSubstnValdtnRuleCndnRgFr as abap.numc(20)) as RangeFromValue,
      cast (FinSubstnValdtnRuleCndnRgTo as abap.numc(20)) as RangeToValue

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

Learn More