P_FinTransAlternativeCondition

DDL: P_FINTRANSALTERNATIVECONDITION SQL: PFINTRSALTERCON Type: view COMPOSITE

Alternative Condition

P_FinTransAlternativeCondition is a Composite CDS View that provides data about "Alternative Condition" in SAP S/4HANA. It reads from 2 data sources (R_FinTransCashFlowActivity, R_FinTransAlternativeCondition) and exposes 10 fields.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
R_FinTransCashFlowActivity Activity inner
R_FinTransAlternativeCondition Condition from

Parameters (1)

NameTypeDefault
P_KeyDate vdm_v_key_date

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PFINTRSALTERCON view
EndUserText.label Alternative Condition view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
CompanyCode R_FinTransAlternativeCondition CompanyCode
FinancialTransaction R_FinTransAlternativeCondition FinancialTransaction
FinancialTransactionDirection R_FinTransAlternativeCondition FinancialTransactionDirection
FinConditionItem R_FinTransAlternativeCondition FinConditionItem
FinConditionFormulaReference R_FinTransAlternativeCondition FinConditionFormulaReference
FinCndnFormulaVariable R_FinTransAlternativeCondition FinCndnFormulaVariable
FinancialInstrumentActivity R_FinTransAlternativeCondition FinancialInstrumentActivity
ConditionPercentageRate R_FinTransAlternativeCondition ConditionPercentageRate
ConditionItemValidityStartDate R_FinTransAlternativeCondition ConditionItemValidityStartDate
FinancialInstrProductCategory R_FinTransCashFlowActivity FinancialInstrProductCategory 
@AbapCatalog.sqlViewName: 'PFINTRSALTERCON'
@EndUserText.label: 'Alternative Condition'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_FinTransAlternativeCondition
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : vdm_v_key_date
  as select from R_FinTransAlternativeCondition as Condition
    inner join   R_FinTransCashFlowActivity     as Activity on  Activity.CompanyCode                 = Condition.CompanyCode
                                                            and Activity.FinancialTransaction        = Condition.FinancialTransaction
                                                            and Activity.FinancialInstrumentActivity = Condition.FinancialInstrumentActivity
{
  Condition.CompanyCode,
  Condition.FinancialTransaction,
  Condition.FinancialTransactionDirection,
  Condition.FinConditionItem,
  Condition.FinConditionFormulaReference,
  Condition.FinCndnFormulaVariable,
  Condition.FinancialInstrumentActivity,
  Condition.ConditionPercentageRate,
  Condition.ConditionItemValidityStartDate,
  Activity.FinancialInstrProductCategory
}
where
  (
    (
           Condition.FinConditionItem               = '1000'
      and(
           Activity.FinancialInstrProductCategory   = '620'
        or Activity.FinancialInstrProductCategory   = '550'
        or Activity.FinancialInstrProductCategory   = '580'
      )
    )
    or     Activity.FinancialInstrProductCategory   = '560'
  )
  and(
           Condition.FinCndnFormulaVariable         = 'V3'
  )
  and(
           Condition.ConditionItemValidityStartDate <= $parameters.P_KeyDate
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_FINTRANSALTERNATIVECONDITION",
"R_FINTRANSCASHFLOWACTIVITY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More