C_ShrtTrmCshPosActualFlow

@AbapCatalog.sqlViewName: 'CSTCPACTLFLW'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Overdue Actual Flows'
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}

@UI.presentationVariant: [{requestAtLeast: ['AmountInTransactionCurrency','TransactionCurrency','DisplayCurrency','BankAccountCurrency']}]

@UI.headerInfo: {
  typeName: 'Cash Flow',
  typeNamePlural: 'Cash Flows',
  title: {  type: #STANDARD, value: 'TransactionDate' }
}

@VDM.viewType: #CONSUMPTION
define view C_ShrtTrmCshPosActualFlow
  as select from I_CashPositionFlow    as flow
    cross join   I_CashPositionProfile as profile
    cross join   I_Currency            as Currency
  association [0..*] to I_CshPosCurrencySourceText as _CshPosCurSoucText on $projection.CashPositionCurrencySource = _CshPosCurSoucText.CashPositionCurrencySource
{
      @UI.facet: [{
                    id: 'GenInfoSec',
                    type: #COLLECTION,
                    purpose: #STANDARD,
                    position: 10,
                    label: 'General Information'
                                             },
                    //General Info field group

                    {
                    id: 'GenInfo',
                    parentId: 'GenInfoSec',
                    type: #FIELDGROUP_REFERENCE,
                    position: 10,
                    targetQualifier: 'GenInfo',
                    label: 'General Information'

                                             }]
      @UI.hidden: true
  key profile.CashPositionProfile,
      @Semantics.currencyCode: true
      @EndUserText:{label: 'Display Currency'}
      @UI.hidden: true
  key Currency.Currency                                                        as CashPositionDisplayCurrency,
  key flow.OriginSystem,
      @UI.fieldGroup: [{position: 20, qualifier: 'GenInfo' }]
  key flow.OriginApplication,
      @UI.fieldGroup: [{position: 30, qualifier: 'GenInfo' }]
      @UI.lineItem: [{position: 10, importance: #HIGH }]
  key flow.OriginDocument,
  key flow.OriginTransaction,
  key flow.OriginTransactionQualifier,
  key flow.CashFlow,

      @UI.lineItem: [{position: 20, importance: #HIGH}]
      @UI.fieldGroup: [{position: 10, qualifier: 'GenInfo' }]
      flow.TransactionDate,

      flow.BankAccountInternalID,

      flow.CompanyCode,

      @UI.lineItem: [{position:30, importance: #HIGH }]
      @Semantics.amount.currencyCode: 'BankAccountCurrency'
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'CL_FCLM_STCP_CALCULATE_AMOUNT'
      @UI.fieldGroup: [{position: 40, qualifier: 'GenInfo' }]
      cast(cast(0 as abap.curr(23,2)) as fclm_amount_bnkcrcy preserving type ) as AmountInBankAccountCurrency,
      @Semantics.currencyCode: true
      @EndUserText:{label: 'Bank Account Currency'}
      @UI.hidden: true
      flow._BankAccount.BankAccountCurrency,

      @UI.lineItem: [{position: 40, importance: #HIGH }]
      @Semantics.amount.currencyCode: 'CashPositionDisplayCurrency'
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'CL_FCLM_STCP_CALCULATE_AMOUNT'
      @EndUserText:{label: 'Amount in Target Currency', quickInfo: 'Amount in Target Currency'}
      @UI.fieldGroup: [{position: 50, qualifier: 'GenInfo' }]
      cast(cast(0 as abap.curr(23,2)) as fqm_amount preserving type )          as AmountInDisplayCurrency,

      @UI.hidden                   : true
      profile. CashPositionCurrencySource,

      @UI.lineItem: [{position: 70, importance: #HIGH}]
      @UI.fieldGroup: [{position: 80, qualifier: 'GenInfo' }]
      @EndUserText:{label: 'Cash Position Currency Source', quickInfo: 'Cash Position Currency Source'}
      _CshPosCurSoucText[1:Language = $session.system_language].CashPositionCurrencySourceText,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'CL_FCLM_STCP_CALCULATE_AMOUNT'
      @UI.fieldGroup: [{position: 60, qualifier: 'GenInfo' }]
      @EndUserText:{label: 'Amount in Transaction Currency', quickInfo: 'Amount in Transaction Currency'}
      flow.AmountInTransactionCurrency                                         as CshPosScaledAmountInTransCrcy,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      @UI.hidden: true
      flow.AmountInTransactionCurrency,
      @Semantics.currencyCode: true
      @EndUserText:{label: 'Transaction Currency'}
      @UI.hidden: true
      flow.TransactionCurrency
}
where
      flow.IsValid              =  'X'
  and flow.CertaintyLevel       =  'ACTUAL'
  and flow.CashTransactionOwner <> 'IBU'
  and flow.CashTransactionOwner <> 'AGG'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BANKACCOUNT",
"I_CASHPOSITIONFLOW",
"I_CASHPOSITIONPROFILE",
"I_CSHPOSCURRENCYSOURCETEXT",
"I_CURRENCY"
],
"ASSOCIATED":
[
"I_CSHPOSCURRENCYSOURCETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/