I_CashOriginBudgetAccount

DDL: I_CASHORIGINBUDGETACCOUNT SQL: ICSHORIGBDGTACCT Type: view BASIC

Basic View for Cash Origin Accounts in PSM

I_CashOriginBudgetAccount is a Basic CDS View that provides data about "Basic View for Cash Origin Accounts in PSM" in SAP S/4HANA. It reads from 2 data sources (ska1, skb1) and exposes 5 fields with key fields ChartOfAccounts, CashLedgerAccount. It has 2 associations to related views.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
ska1 ska1 inner
skb1 skb1 inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ChartOfAccounts _ChartOfAccounts $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
[0..*] I_GLAccountText _Text $projection.ChartOfAccounts = _Text.ChartOfAccounts and $projection.CashLedgerAccount = _Text.GLAccount

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICSHORIGBDGTACCT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Basic View for Cash Origin Accounts in PSM view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey CashLedgerAccount view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts
KEY CashLedgerAccount
CashLedgerAccountExt
_ChartOfAccounts _ChartOfAccounts
_Text _Text 
@AbapCatalog.sqlViewName: 'ICSHORIGBDGTACCT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Basic View for Cash Origin Accounts in PSM'
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
     representativeKey: 'CashLedgerAccount',
     usageType: {
         dataClass: #MASTER,
         serviceQuality: #C,
         sizeCategory: #L
     }
}

define view I_CashOriginBudgetAccount
  as select distinct from t001
    inner join            skb1          on  t001.bukrs = skb1.bukrs
                                        and t001.fikrs is not initial

    inner join            ska1          on  ska1.ktopl = t001.ktopl
                                        and ska1.saknr = skb1.saknr

  association [0..1] to I_ChartOfAccounts as _ChartOfAccounts on  $projection.ChartOfAccounts   = _ChartOfAccounts.ChartOfAccounts
  association [0..*] to I_GLAccountText   as _Text            on  $projection.ChartOfAccounts   = _Text.ChartOfAccounts
                                                              and $projection.CashLedgerAccount = _Text.GLAccount
{
      @ObjectModel.foreignKey.association: '_ChartOfAccounts'
  key cast( ska1.ktopl as fis_ktopl       preserving type ) as ChartOfAccounts,
  key cast( ska1.saknr as fis_re_account  preserving type ) as CashLedgerAccount,
      cast( ska1.sakan as psm_bdgt_acct_cash_origin_ext preserving type ) as CashLedgerAccountExt,
 
      _ChartOfAccounts,
      _Text
}
where
    ( skb1.mitkz is initial or skb1.mitkz = 'A' )
  and skb1.xgkon is initial

Learn More