I_BankAccCashPoolTP

DDL: I_BANKACCCASHPOOLTP Type: view TRANSACTIONAL

Bank Account Cash Pool

I_BankAccCashPoolTP is a Transactional CDS View that provides data about "Bank Account Cash Pool" in SAP S/4HANA. It reads from 6 data sources and exposes 6 fields with key fields BankAccountInternalID, BankAccountRevision, CashPool.

6 data source(s) 6 fields

Data Sources (6)

SourceAliasJoin Type
fclm_bam_aclink2 a from
fibl_rpcode_grel g left_outer
copc_hierorg hierorg left_outer
fclm_bam_hiert hiert left_outer
copc_acct_group p left_outer
fibl_rpcode r left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IBANKACCCPTP view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Bank Account Cash Pool view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID fclm_bam_aclink2 acc_id
KEY BankAccountRevision fclm_bam_aclink2 revision
KEY CashPool copc_acct_group group_id
CashPoolName copc_acct_group cash_pool_name
BankAccountGroupId copc_hierorg hierid
AccountGroupName fclm_bam_hiert hiername 
@AbapCatalog: {
    sqlViewName: 'IBANKACCCPTP',
    compiler.compareFilter: true
}

@VDM:{
    viewType: #TRANSACTIONAL,
    lifecycle.contract.type:#SAP_INTERNAL_API
}

@EndUserText.label: 'Bank Account Cash Pool'

@ObjectModel.usageType: {
  serviceQuality: #C,
  sizeCategory:   #S,
  dataClass:      #MIXED
}

@AccessControl.authorizationCheck: #NOT_REQUIRED


define view I_BankAccCashPoolTP
  as select from fclm_bam_aclink2 as a
     left outer join fibl_rpcode as r on r.bukrs = a.bukrs and r.hbkid = a.hbkid and r.hktid = a.hktid
     left outer join fibl_rpcode_grel as g on g.rpcode = r.rpcode                                      
     left outer join copc_acct_group as p on p.group_id = g.rpgroup
     left outer join copc_hierorg as hierorg on hierorg.objid = p.tag_orgunit
     left outer join fclm_bam_hiert as hiert on hiert.hierid = hierorg.hierid and hiert.langu = $session.system_language

{
         @ObjectModel: {
                readOnly:  true,
                foreignKey.association: null
              }
  key    a.acc_id as BankAccountInternalID,
         @ObjectModel: {
          readOnly:  true,
          foreignKey.association: null
         }
  key    a.revision  as BankAccountRevision,
         @ObjectModel: {
            readOnly:  true,
            foreignKey.association: null
           }
  key    p.group_id as CashPool,
         @ObjectModel: {
          readOnly:  true,
          foreignKey.association: null
         }
        p.cash_pool_name as CashPoolName, 
        @ObjectModel: {
        readOnly:  true,
        foreignKey.association: null
        }
        hierorg.hierid as BankAccountGroupId,
        @ObjectModel: {
        readOnly:  true,
        foreignKey.association: null
        }
        hiert.hiername as AccountGroupName
}
where p.group_id is not null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"COPC_ACCT_GROUP",
"COPC_HIERORG",
"FCLM_BAM_ACLINK2",
"FCLM_BAM_HIERT",
"FIBL_RPCODE",
"FIBL_RPCODE_GREL"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More