I_CashPool

DDL: I_CASHPOOL SQL: ICASHPOOL Type: view BASIC Package: FINS_FIS_CASH

Cash Pool Bank Account Relationship

I_CashPool is a Basic CDS View that provides data about "Cash Pool Bank Account Relationship" in SAP S/4HANA. It reads from 2 data sources (fibl_rpcode, fibl_rpcode_grel) and exposes 5 fields with key fields CashPool, CompanyCode, HouseBank, BankAccount. Part of development package FINS_FIS_CASH.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
fibl_rpcode rp inner
fibl_rpcode_grel rpgrp inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICASHPOOL view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Cash Pool Bank Account Relationship view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropogatedAnnotations true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CashPool
KEY CompanyCode fibl_rpcode bukrs
KEY HouseBank fibl_rpcode partn
KEY BankAccount fibl_rpcode bankn
CashPoolName 
@AbapCatalog.sqlViewName: 'ICASHPOOL'
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Cash Pool Bank Account Relationship'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MIXED
@Metadata.ignorePropogatedAnnotations: true
//@ObjectModel.representativeKey: 'CashPool'

define view I_CashPool
  as select distinct from copc_acct_group  as cshpl
    inner join            fibl_rpcode_grel as rpgrp on cshpl.group_id = rpgrp.rpgroup
    inner join            fibl_rpcode      as rp    on  rpgrp.bukrs  = rp.bukrs
                                                    and rpgrp.hbkid  = rp.hbkid
                                                    and rpgrp.rpcode = rp.rpcode
{

      @ObjectModel.text.element: 'CashPoolName'
  key cast (cshpl.group_id as cashpool_id)        as CashPool,
  key rp.bukrs                                    as CompanyCode,
  key rp.partn                                    as HouseBank,
  key rp.bankn                                    as BankAccount,
      cast(cshpl.cash_pool_name as cashpool_name) as CashPoolName
}

Learn More