I_CASHPOSITIONPROFILE

CDS View

Define Cash Position Profile

I_CASHPOSITIONPROFILE is a CDS View in S/4HANA. Define Cash Position Profile. It contains 33 fields. 10 CDS views read from this table.

Used by 10 CDS view(s) 33 fields

CDS Views using this table (10)

ViewTypeJoinVDMDescription
C_CashPositionProfile view_entity from CONSUMPTION Cash Position Profile
C_CashPositionProfileWithCycle view_entity from CONSUMPTION Cash Position Profile With Cycle Info
C_ShrtTrmCshPosActualFlow view_entity cross CONSUMPTION Overdue Actual Flows
I_CashPositionProfileVH view_entity from COMPOSITE Cash Position Profile
P_ShrtTrmCshPosAccHier view_entity from COMPOSITE Short Term Cash Position Bank Acc Hier
P_ShrtTrmCshPosAccHier view_entity inner COMPOSITE Short Term Cash Position Bank Acc Hier
P_ShrtTrmCshPosAccHier view_entity union_all COMPOSITE Short Term Cash Position Bank Acc Hier
P_ShrtTrmCshPosAccWithProfile view_entity cross COMPOSITE Short Term Cash Position Acc Filter
P_ShrtTrmCshPosGrouping view_entity inner COMPOSITE Short Term Cash Position Grouping
P_ShrtTrmCshPosGrouping view_entity union_all COMPOSITE Short Term Cash Position Grouping

Fields (33)

KeyField CDS FieldsUsed in Views
KEY CashPositionProfile CashPositionProfile 4
_BankFeeExchRateTypeVH _BankFeeExchRateTypeVH 1
_CshPosBalCategoryText _CshPosBalCategoryText 1
_CshPosBalTypeText _CshPosBalTypeText 1
_CshPosShiftOptionText _CshPosShiftOptionText 1
_CshPosUnitText _CshPosUnitText 1
_CshPosViewTypeText _CshPosViewTypeText 1
_Currency _Currency 1
_FactoryCalendarText _FactoryCalendarText 1
CashBalanceType CashBalanceType 1
CashPositionBalanceCategory CashPositionBalanceCategory 1
CashPositionFutureIsVisible CashPositionFutureIsVisible 1
CashPositionHierLevel1 CashPositionHierLevel1 1
CashPositionHierLevel2 CashPositionHierLevel2 1
CashPositionHierLevel3 CashPositionHierLevel3 1
CashPositionHierSource CashPositionHierSource 2
CashPositionOverdueIsVisible CashPositionOverdueIsVisible 1
CashPositionOvrdIsIncldInClsg CashPositionOvrdIsIncldInClsg 1
CashPositionPeriodEndIsNatural CashPositionPeriodEndIsNatural 1
CashPositionPrdfndIncrement CashPositionPrdfndIncrement 1
CashPositionPrdfndInterimStep CashPositionPrdfndInterimStep 1
CashPositionProfileDescription CashPositionProfileDescription 1
CashPositionRootNode CashPositionRootNode 1
CashPositionRootNodeIsNeeded CashPositionRootNodeIsNeeded 1
CashPositionShiftOption CashPositionShiftOption 1
CashPositionSmartCrcyIsEnabled CashPositionSmartCrcyIsEnabled 1
CashPositionViewCategory CashPositionViewCategory 1
DisplayCurrency DisplayCurrency 1
EmbeddedCshPosDetViewIsVisible EmbeddedCshPosDetViewIsVisible 1
EndOfDayRecnclnRsltIsConsdrd EndOfDayRecnclnRsltIsConsdrd 1
ExchangeRateType ExchangeRateType 1
FactoryCalendar FactoryCalendar 1
IntradayRecnclnRsltIsConsdrd IntradayRecnclnRsltIsConsdrd 1 
@EndUserText.label: 'Define Cash Position Profile'
@VDM.viewType:#COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.representativeKey: 'CashPositionProfile'
@Analytics.technicalName: 'ICSHPOSPRFL'
@Metadata.ignorePropagatedAnnotations: true

define root view entity I_CashPositionProfile
  as select from I_CashPositionProfileBasic as Main
  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.CashBalanceType = _CshPosBalTypeText.CashBalanceType
  association [0..*] to I_CshPosBalanceCategoryText as _CshPosBalCategoryText on $projection.CashPositionBalanceCategory = _CshPosBalCategoryText.CashPositionBalanceCategory
  association [0..*] to I_CshPosViewTypeText        as _CshPosViewTypeText    on $projection.CashPositionViewCategory = _CshPosViewTypeText.CashPositionViewCategory


{
  key Main.CashPositionProfile,
      Main.CashPositionProfileDescription,
      Main.CashPositionHierSource,
      Main.CashPositionHierLevel1,
      Main.CashPositionHierLevel2,
      Main.CashPositionHierLevel3,
      Main.BankAccountHierarchyName,
      Main.CashBalanceType,
      Main.CashPositionBalanceCategory,
      Main.CashPositionViewCategory,
      Main.CashPositionPrdfndIncrement,
      Main.CashPositionPrdfndInterimStep,
      Main.CashPositionPeriodEndIsNatural,
      Main.CashPositionOverdueIsVisible,
      Main.CashPositionOvrdIsIncldInClsg,
      Main.CashPositionShiftOption,
      Main.FactoryCalendar,
      Main.DisplayCurrency,
      Main.ExchangeRateType,
      Main.CashPositionRootNodeIsNeeded,
      Main.CashPositionRootNode,
      Main.CashPositionFutureIsVisible,
      Main.CashPositionSmartCrcyIsEnabled,
      Main.EmbeddedCshPosDetViewIsVisible,
      Main.IntradayRecnclnRsltIsConsdrd,
      Main.EndOfDayRecnclnRsltIsConsdrd,


      Main.CashPositionCurrencySource,
      @Semantics.user.createdBy: true
      Main.CreatedByUser,
      @Semantics.systemDateTime.createdAt: true
      Main.CreationDateTime,
      @Semantics.user.lastChangedBy: true
      Main.LastChangedByUser,
      @Semantics.systemDateTime.localInstanceLastChangedAt: true
      Main.LastChangeDateTime,
      Main.CshPosKeyDteInThePastIsAllowed,

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


}
union all select distinct from I_CompanyCode as fakeentry
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.CashBalanceType = _CshPosBalTypeText.CashBalanceType
association [0..*] to I_CshPosBalanceCategoryText as _CshPosBalCategoryText on $projection.CashPositionBalanceCategory = _CshPosBalCategoryText.CashPositionBalanceCategory
association [0..*] to I_CshPosViewTypeText        as _CshPosViewTypeText    on $projection.CashPositionViewCategory = _CshPosViewTypeText.CashPositionViewCategory


{
  key cast('' as fclm_cp_profile)                     as CashPositionProfile,
      cast('Default Profile' as fclm_cp_profile_desc) as CashPositionProfileDescription,
      cast('01' as fclm_cp_profile_hiersrc)           as CashPositionHierSource,
      cast('' as fclm_cp_profile_hierlevel1)          as CashPositionHierLevel1,
      cast('' as fclm_cp_profile_hierlevel2)          as CashPositionHierLevel2,
      cast('' as fclm_cp_profile_hierlevel3)          as CashPositionHierLevel3,
      cast('' as vhrid )                              as BankAccountHierarchyName,
      cast('' as fclm_cp_balance_type)                as CashBalanceType,
      cast('2' as fclm_cp_balance_category)           as CashPositionBalanceCategory,
      '01'                                            as CashPositionViewCategory,
      cast('01' as step_rhythm)                       as CashPositionPrdfndIncrement,
      'D'                                             as CashPositionPrdfndInterimStep,
      ''                                              as CashPositionPeriodEndIsNatural,
      ''                                              as CashPositionOverdueIsVisible,
      ''                                              as CashPositionOvrdIsIncldInClsg,
      ''                                              as CashPositionShiftOption,
      ''                                              as FactoryCalendar,
      cast('' as disp_curr)                           as DisplayCurrency,
      cast('M' as kurst  )                            as ExchangeRateType,
      ''                                              as CashPositionRootNodeIsNeeded,
      ''                                              as CashPositionRootNode,
      ''                                              as CashPositionFutureIsVisible,
      ''                                              as CashPositionSmartCrcyIsEnabled,
      ''                                              as EmbeddedCshPosDetViewIsVisible,

      'X'                                             as IntradayRecnclnRsltIsConsdrd,
      'X'                                             as EndOfDayRecnclnRsltIsConsdrd,

      cast('03'     as fclm_cp_currency_type)         as CashPositionCurrencySource,
      ''                                              as CreatedByUser,
      cast('00' as dec15)                             as CreationDateTime,
      ''                                              as LastChangedByUser,
      cast('00' as dec15)                             as LastChangeDateTime,
      'X'                                             as CshPosKeyDteInThePastIsAllowed,
      _Currency,
      _BankFeeExchRateTypeVH,
      _CshPosHierSourceText,
      _CshPosHierText,
      _CshPosHierTwoText,
      _CshPosHierThreeText,
      _FactoryCalendarText,
      _CshPosShiftOptionText,
      _CshPosUnitText,
      _CshPosBalTypeText,
      _CshPosViewTypeText,
      _CshPosBalCategoryText

}

Learn More