I_CASHPOSITIONPROFILE

@EndUserText.label: 'Define Cash Position Profile'
@VDM.viewType:#BASIC
@AbapCatalog.sqlViewName: 'ICSHPOSPRFL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.representativeKey: 'CashPositionProfile'

define root view I_CashPositionProfile
  as select from fclm_cp_prof as Main
  // composition [0..*] of I_CashPositionProfileWorkArea  as _FilterWorkArea

 cross join fclm_config2 as _config
  association [0..1] to I_CurrencyStdVH                as _Currency                     on $projection.DisplayCurrency = _Currency.Currency
  association [0..1] to I_BankFeeExchRateTypeVH        as _BankFeeExchRateTypeVH        on $projection.ExchangeRateType = _BankFeeExchRateTypeVH.ExchangeRateType
  association [0..*] to I_CshPosHierSourceText         as _CshPosHierSourceText         on $projection.CashPositionHierSource = _CshPosHierSourceText.CashPositionHierSource
  association [0..*] to I_CshPosHierText               as _CshPosHierText               on $projection.CashPositionHierLevel1 = _CshPosHierText.CashPositionHierLevel1
  association [0..*] to I_CshPosHierText               as _CshPosHierTwoText            on $projection.CashPositionHierLevel2 = _CshPosHierTwoText.CashPositionHierLevel1
  association [0..*] to I_CshPosHierText               as _CshPosHierThreeText          on $projection.CashPositionHierLevel3 = _CshPosHierThreeText.CashPositionHierLevel1
  association [0..*] to I_FactoryCalendarText          as _FactoryCalendarText          on $projection.FactoryCalendar = _FactoryCalendarText.FactoryCalendar
  association [0..*] to I_CshPosShiftOptionText        as _CshPosShiftOptionText        on $projection.CashPositionShiftOption = _CshPosShiftOptionText.CashPositionShiftOption
  association [0..*] to I_CshPosUnitText               as _CshPosUnitText               on $projection.CashPositionPrdfndInterimStep = _CshPosUnitText.CashPositionPrdfndInterimStep
  association [0..*] to I_CshPosBalTypeText            as _CshPosBalTypeText            on $projection.CashPositionBalanceCategory = _CshPosBalTypeText.CashPositionBalanceCategory
  association [0..*] to I_CshPosViewTypeText           as _CshPosViewTypeText           on $projection.CashPositionViewCategory = _CshPosViewTypeText.CashPositionViewCategory
  //  association [0..*] to I_CshPosSclngOfDcmlPlacesText  as _CshPosSclngOfDcmlPlacesText  on $projection.cashpositionsclngofdcmlplaces = _CshPosSclngOfDcmlPlacesText.CashPositionSclngOfDcmlPlaces

  association [0..*] to I_CshPosSclngPreDcmlPlacesText as _CshPosSclngPreDcmlPlacesText on $projection.CshPosSclngOfPreDcmlPlaces = _CshPosSclngPreDcmlPlacesText.CshPosSclngOfPreDcmlPlaces
  association [0..*] to I_CashBalanceTypeText          as _CashBalanceTypeText          on $projection.CashBalanceType = _CashBalanceTypeText.CashBalanceType
   
  
{
  key profile_name                   as CashPositionProfile,
      prof_description               as CashPositionProfileDescription,
      hierarchy_source               as CashPositionHierSource,
      hierarchy_level1               as CashPositionHierLevel1,
      hierarchy_level2               as CashPositionHierLevel2,
      hierarchy_level3               as CashPositionHierLevel3,
      bank_acc_hierarchy_id          as BankAccountHierarchyName,
      balance_type                   as CashBalanceType,
      balance_category               as CashPositionBalanceCategory,
      view_category                  as CashPositionViewCategory,
      step_rhythm                    as CashPositionPrdfndIncrement,
      step_unit                      as CashPositionPrdfndInterimStep,
      period_end                     as CashPositionPeriodEndIsNatural,
      show_overdue                   as CashPositionOverdueIsVisible,
      include_overdue_in_closing     as CashPositionOvrdIsIncldInClsg,
      shift_option                   as CashPositionShiftOption,
      factory_calendar               as FactoryCalendar,
      display_currency               as DisplayCurrency,
      exchange_rate_type             as ExchangeRateType,
      //     scaling_decimal_place      as CashPositionSclngOfDcmlPlaces,

      scaling_predecimal_place       as CshPosSclngOfPreDcmlPlaces,
      need_root_node                 as CashPositionRootNodeIsNeeded,
      root_node                      as CashPositionRootNode,
      show_future                    as CashPositionFutureIsVisible,
      enable_smart_currency          as CashPositionSmartCrcyIsEnabled,
      display_embed_csh_pos_det_view as EmbeddedCshPosDetViewIsVisible,
 
      consider_intraday_recncln_rslt as IntradayRecnclnRsltIsConsdrd,
      
      @UI.hidden:true
      cast ( case when _config.rcn_model = 'X' then ''
      else 'X'
      end as fclm_cp_consdr_intrd_recn_rslt ) as ConsdrIntradayRecnclnIsHidden,
      cast ( case
       when enable_smart_currency <> 'X'
         and display_currency is not initial then '01'
       else '03'
      end as fclm_cp_currency_type ) as CashPositionCurrencySource,
      @Semantics.user.createdBy: true
      created_by                     as CreatedByUser,
      @Semantics.systemDateTime.createdAt: true
      created_at                     as CreationDateTime,
      @Semantics.user.lastChangedBy: true
      last_changed_by                as LastChangedByUser,
      @Semantics.systemDateTime.localInstanceLastChangedAt: true
      last_changed_at                as LastChangeDateTime,

      //  _FilterWorkArea,

      _Currency,
      _BankFeeExchRateTypeVH,
      _CshPosHierSourceText,
      _CshPosHierText,
      _CshPosHierTwoText,
      _CshPosHierThreeText,
      _FactoryCalendarText,
      _CshPosShiftOptionText,
      _CshPosUnitText,
      _CshPosBalTypeText,
      _CshPosViewTypeText,
      //  _CshPosSclngOfDcmlPlacesText,

      _CshPosSclngPreDcmlPlacesText,
      _CashBalanceTypeText
      

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCLM_CONFIG2",
"FCLM_CP_PROF"
],
"ASSOCIATED":
[
"I_BANKFEEEXCHRATETYPEVH",
"I_CASHBALANCETYPETEXT",
"I_CSHPOSBALTYPETEXT",
"I_CSHPOSHIERSOURCETEXT",
"I_CSHPOSHIERTEXT",
"I_CSHPOSSCLNGPREDCMLPLACESTEXT",
"I_CSHPOSSHIFTOPTIONTEXT",
"I_CSHPOSUNITTEXT",
"I_CSHPOSVIEWTYPETEXT",
"I_CURRENCYSTDVH",
"I_FACTORYCALENDARTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/