P_FTR_ASGN_UTILIZE

CDS View

P_FTR_ASGN_UTILIZE is a CDS View in S/4HANA. 4 CDS views read from this table.

Used by 4 CDS view(s)

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_FacilityContract view from COMPOSITE Treasury Facility Contract
I_FacilityUtilization view from COMPOSITE Treasury Facility Utilization
I_Ftr_Cl_Utilize view from COMPOSITE Facility Utilization With Contract Info
P_CreditLineUtilization view from COMPOSITE 
@AbapCatalog.sqlViewName: 'PFTRASGNUTILIZE'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #B
@VDM.private:true
define view P_Ftr_Asgn_Utilize
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_StartDate                  : vdm_v_start_date,
    @Environment.systemField: #SYSTEM_DATE
    P_EndDate                    : vdm_v_end_date,
    P_CrdtLineReportingFrequency : ftr_date_granularity
  as select from    P_Ftr_Asgn_Daily_Fac_Amount(
                       P_StartDate : $parameters.P_StartDate,
                       P_EndDate   : $parameters.P_EndDate,
                       P_CrdtLineReportingFrequency: $parameters.P_CrdtLineReportingFrequency) as Facility
    left outer join P_Ftr_Asgn_Pos_With_Ratio(
                    P_StartDate : $parameters.P_StartDate,
                    P_EndDate   : $parameters.P_EndDate)                                       as Position on  Facility.KeyDate     >= Position.ChangeDate
                                                                                                           and Facility.RelatObject =  Position.RelatObject
{
  Facility.CompanyCode,
  Facility.FinancialTransaction,
  Facility.RelatObject,
  Facility.SyndicatedCounterparty,
  Facility.KeyDate,
  Facility.CreditLineReportingPeriod,
  Position.PositionObject,
  @Semantics.currencyCode: true
  Facility.TransactionCurrency,
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  @DefaultAggregation: #SUM
  cast(Facility.PositionAmount as ftr_totamtintranscrcy) as TotalAmount,

  @Semantics.amount.currencyCode: 'TransactionCurrency'
  @DefaultAggregation: #SUM
  case when Position.CurrencyConversionRate >= 0
  then
  cast(coalesce(
    round(
     division(
      division( cast(cast( Position.ChangeAmount * cast( case when Position.FacilityAmount > 0 or Position.RootAmount > 0  then Position.Ratio else Position.Ratio2 end as abap.dec(14,6)) as abap.dec( 21, 6 )) * Position.CurrencyConversionRate  as abap.dec( 21, 6 )), Position.ExchangeRateFactor, 6)
        * cast(div(decimal_shift(amount => Position.FixedAmountInPositionCurrency, currency => Position.TransactionCurrency, error_handling => 'KEEP_UNCONVERTED'), Position.FixedAmountInPositionCurrency) as abap.dec( 6, 0 )),
      cast(div(decimal_shift(amount => Facility.FixedAmountInFacilityCurrency, currency => Facility.TransactionCurrency, error_handling => 'KEEP_UNCONVERTED'), Facility.FixedAmountInFacilityCurrency) as abap.dec( 6, 0 )),
      6),
    2),
   0) as ftr_utilamtintranscrcy)
  else
  cast(coalesce(
    round(
     division(
       division( cast(division( cast(Position.ChangeAmount * cast( case when Position.FacilityAmount > 0 or Position.RootAmount > 0  then Position.Ratio else Position.Ratio2 end as abap.dec(14,6)) as abap.dec( 21, 6 )), abs(Position.CurrencyConversionRate),6 ) as abap.dec( 21, 6 )), Position.ExchangeRateFactor,6)
       * cast(div(decimal_shift(amount => Position.FixedAmountInPositionCurrency, currency => Position.TransactionCurrency, error_handling => 'KEEP_UNCONVERTED'), Position.FixedAmountInPositionCurrency) as abap.dec( 6, 0 )),
      cast(div(decimal_shift(amount => Facility.FixedAmountInFacilityCurrency, currency => Facility.TransactionCurrency, error_handling => 'KEEP_UNCONVERTED'), Facility.FixedAmountInFacilityCurrency) as abap.dec( 6, 0 )),
      6),
    2),
   0) as ftr_utilamtintranscrcy)
  end                                                    as UtilizedChangeAmount,

  Facility._TransactionCurrency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_FTR_ASGN_DAILY_FAC_AMOUNT",
"P_FTR_ASGN_POS_WITH_RATIO"
],
"ASSOCIATED":
[
"I_CURRENCY"
],
"BASE":
[
"P_FTR_ASGN_DAILY_FAC_AMOUNT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More