Which CDS Views use I_BANKACCOUNT?

I_BANKACCOUNT is used by 30 CDS view(s), including: A_BankAccount, A_BankAccountName, C_BankAccountNumberVH, C_BankAccountVH, C_ClosedBankAccountSituation, C_DeficitCashPoolAnalytics, C_DK_SAFTHeaderCoHouseBank, C_NO_SAFTHeaderCoHouseBank, C_RO_SAFTCompanyHouseBank, FCLM_BAL_ACCT_SETTING_DETAILS.

How many fields does I_BANKACCOUNT have?

I_BANKACCOUNT has 15 fields. Key fields: Bank, BankAccountCurrency, BankAccountInternalID, BankAccountStatus, BankAccountType, BankCountry, CompanyCode.

I_BANKACCOUNT

CDS View

Bank Account

I_BANKACCOUNT is a CDS View in S/4HANA. Bank Account. It contains 15 fields. 30 CDS views read from this table.

CDS Views using this table (30)

View	Type	Join	VDM	Description
A_BankAccount	view	from	BASIC	API for Bank Account
A_BankAccountName	view_entity	from	BASIC	API for Bank Account
C_BankAccountNumberVH	view	from	CONSUMPTION	Bank Account Number
C_BankAccountVH	view_entity	from	CONSUMPTION	Bank Account Master Data
C_ClosedBankAccountSituation	view	inner	CONSUMPTION	Closed bank account situation
C_DeficitCashPoolAnalytics	view	left_outer	CONSUMPTION	Deficit Cash Pool
C_DK_SAFTHeaderCoHouseBank	view	inner	CONSUMPTION	SAF T Danish Header Company House Bank
C_NO_SAFTHeaderCoHouseBank	view	inner	CONSUMPTION	SAF-T Norway Header Company House Bank
C_RO_SAFTCompanyHouseBank	view	inner	CONSUMPTION	HouseBank accounts
FCLM_BAL_ACCT_SETTING_DETAILS	view_entity	left_outer		Bank Account Setting Details
Fclm_Bam_Doc_Acc	view	left_outer		Document and Bank Account Mapping
Fclm_Bam_Doc_Dyn_Search	view	from		Document List for Dynamic Search
fclm_bam_shlp_acntid	view	from		CDS view for search help SHLP_ACNTID
Fclm_BankAccountGroupNode	view	union_all		Nodes of Selected Bank Account Group
I_APMBankAccountHarmonized	view_entity	from	BASIC	Bank acct with Harmonized account number
I_BankAccountAnalysisCube	view	from	COMPOSITE	Bank Account Analysis - Cube
I_BankAccountProfiles	view	from	COMPOSITE	Bank Accounts Count
I_BankAccountSignatoryPattern	view	from	COMPOSITE	Bank Account with Signatory Pattern
I_BankAccountStdVH	view	from	BASIC	Bank Account
I_BankAccountVH	view	from	BASIC	Explicit value help for I_BankAccount
I_BankAccountWithBP	view	from	COMPOSITE	Bank Account Data with BP
I_BkCashBalanceForPeriodCube	view_entity	inner	COMPOSITE	Bank Account Balances for Period - Cube
I_BkCshBalByCshBalDteCube	view_entity	inner	COMPOSITE	Bank Account Balances - Cube
P_BankAccountCount	view	from	COMPOSITE	Count of active bank account per bank
P_CASHFLOWCFA	view	left_outer	COMPOSITE	Cash Flow with Reconciliation Status
P_Cashposonallacct2	view	from	COMPOSITE	Cash Position related view 2
P_CshPosFlow	view	inner	COMPOSITE	Cash Position Flow
P_RecnclnBankAccount	view	inner	COMPOSITE	Reconciliation Bank Account
P_RecnclnIntradayBankAcct	view	from	COMPOSITE	Intraday Bank Account for Reconciliation
R_BkCshBalByCshBalDte	view_entity	inner	COMPOSITE	Balance By Cash Balance Date

Fields (15)

Key	Field	CDS Fields	Used in Views
KEY	Bank	Bank,BankKey,bankl	11
KEY	BankAccountCurrency	AccountCurrency,BankAccountCurrency	10
KEY	BankAccountInternalID	acc_id,BankAccountInternalID	12
KEY	BankAccountStatus	BankAccountStatus	4
KEY	BankAccountType	AccountType,BankAccountType	10
KEY	BankCountry	BankCountry,banks	10
KEY	CompanyCode	bukrs,bukrs_ext,CompanyCode,link_bukrs	8
	_Bank	_Bank	2
	_BankCountry	_BankCountry	2
	BankAccountCharacteristic	BankAccountCharacteristic	2
	BankAccountContractType	BankAccountContractType	3
	BankAccountNumber	acc_num,BankAccountNumber	8
	IBAN	IBAN	5
	ValidityEndDate	ValidityEndDate	1
	ValidityStartDate	ValidityStartDate	1

@AbapCatalog.sqlViewName: 'IFIBANKACCOUNT'
@AccessControl.authorizationCheck: #CHECK
@Analytics: { dataCategory: #DIMENSION }
@VDM.viewType: #BASIC
@EndUserText.label: 'Bank Account'
@ObjectModel: { supportedCapabilities:
[ #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #SEARCHABLE_ENTITY ],
 modelingPattern: #ANALYTICAL_DIMENSION,
 representativeKey: 'BankAccountInternalID'}
@ObjectModel.usageType: {
dataClass: #MASTER,
sizeCategory: #M,
serviceQuality: #C }
@Metadata.allowExtensions:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.privilegedAssociations:  [ '_Text' ]
@AbapCatalog.preserveKey:true
@Search.searchable: true

define view I_BankAccount
  as select from I_BankAccountBasicData
  //inner join I_CompanyCode on CompanyCode = I_CompanyCode.CompanyCode

  association [0..1] to I_Bank_2                   as _Bank                     on  $projection.BankCountry = _Bank.BankCountry
                                                                                and $projection.Bank        = _Bank.BankInternalID
  association [0..1] to I_CompanyCode              as _CompanyCode              on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..*] to I_ProfitCenter             as _ProfitCenter             on  $projection.ProfitCenter    = _ProfitCenter.ProfitCenter
                                                                                and $projection.ControllingArea = _ProfitCenter.ControllingArea
  association [0..1] to I_ControllingArea          as _ControllingArea          on  $projection.ControllingArea = _ControllingArea.ControllingArea
  association [0..1] to I_BusinessArea             as _BusinessArea             on  $projection.BusinessArea = _BusinessArea.BusinessArea
  association [0..1] to I_Segment                  as _Segment                  on  $projection.Segment = _Segment.Segment
  // association [0..*] to I_BankAccountText          as _Text                     on  $projection.BankAccountInternalID = _Text.BankAccountInternalID

  //                                                                                and _Text.Language                    = $session.system_language

  association [0..1] to I_BankAccountCurrency      as _BankAccountCurrency      on  $projection.BankAccountInternalID = _BankAccountCurrency.BankAccountInternalID
  association [0..*] to I_BankAccountHierarchyNode as _BankAccountHierarchyNode on  $projection.BankAccountInternalID = _BankAccountHierarchyNode.BankAccountInternalID
  association [0..1] to I_BankAccountReference     as _Reference                on  $projection.BankAccountInternalID = _Reference.BankAccountInternalID  
{
       -- @ObjectModel.hierarchy.association: '_BankAccountHierarchyNode'
       @ObjectModel.text.association: '_Text'
  key  BankAccountInternalID,
       @ObjectModel.foreignKey.association: '_BankCountry'
       BankCountry,
       //--[ GENERATED:012:E6ExH29r7kY4hHBW6NEXPW

//       @Consumption.valueHelpDefinition: [

//         { entity:  { name:    'I_BankStdVH',

//                      element: 'BankInternalID' },

//           additionalBinding: [{ localElement: 'BankCountry',

//                                 element: 'BankCountry' }]

//         }]

       @Consumption.valueHelpDefinition: [ 
       { qualifier: 'Deprecated', label:'Deprecated',  entity: { name: 'I_BankStdVH', element: 'BankInternalID' },
         additionalBinding: [{ localElement: 'BankCountry', element: 'BankCountry' }] } ,
       { label:'Bank Key', entity: { name: 'I_BankVH', element: 'BankInternalID' },
         additionalBinding: [{ localElement: 'BankCountry', element: 'BankCountry' }] } ]           
       // ]--GENERATED

       @ObjectModel.foreignKey.association: '_Bank'
       Bank,
       BankAccountNumber,
       //       _Text.BankAccountDescription as BankAccountDescription,

       BankAccountType,
       BankAccountContractType,
       ValidityStartDate,
       ValidityEndDate,
       //    valid_from           as BankAccountOpeningDate,   // Global Field is not verified by CASH team

       //    valid_to             as BankAccountClosingDate,   // Global Field is not verified by CASH team

       IBAN,
       BankAccountStatus,
       //--[ GENERATED:012:E6ExH29r7kY4hHBW6NEXPW

       @Consumption.valueHelpDefinition: [
         { entity:  { name:    'I_CompanyCodeStdVH',
                      element: 'CompanyCode' }
         }]
       // ]--GENERATED

       @ObjectModel.foreignKey.association: '_CompanyCode' //Inserted by VDM CDS Suite Plugin

       CompanyCode,
       _CompanyCode.Country         as Country,
       //    @ObjectModel.foreignKey.association: '_ProfitCenter' //Inserted by VDM CDS Suite Plugin

       //--[ GENERATED:012:E6ExH29r7kY4hHBW6NEXPW

       @Consumption.valueHelpDefinition: [
         { entity:  { name:    'I_ProfitCenterStdVH',
                      element: 'ProfitCenter' },
           additionalBinding: [{ localElement: 'ControllingArea',
                                 element: 'ControllingArea' }]
         }]
       // ]--GENERATED

       @ObjectModel.foreignKey.association: '_ProfitCenter' //Inserted by VDM CDS Suite Plugin

       ProfitCenter,
       //--[ GENERATED:012:E6ExH29r7kY4hHBW6NEXPW

       @Consumption.valueHelpDefinition: [
         { entity:  { name:    'I_BusinessAreaStdVH',
                      element: 'BusinessArea' }
         }]
       // ]--GENERATED

       @ObjectModel.foreignKey.association: '_BusinessArea' //Inserted by VDM CDS Suite Plugin

       BusinessArea,
       //--[ GENERATED:012:E6ExH29r7kY4hHBW6NEXPW

       @Consumption.valueHelpDefinition: [
         { entity:  { name:    'I_SegmentStdVH',
                      element: 'Segment' }
         }]
       // ]--GENERATED

       @ObjectModel.foreignKey.association: '_Segment' //Inserted by VDM CDS Suite Plugin

       Segment,
       BankAccountHolderName,
       BankContactPerson,
       BankRelationshipManager,
       CompanyContactPerson,
       BankAccountSupervisor,
       CreatedByUser,
       OpenedByUser,
       LastChangedByUser,
       ReviewedByUser,
       ClosedByUser,
       IsMarkedForDeletion,
       DomesticCutOffTime,
       CrossBorderCutOffTime,
       PlannedClosingDate, // Global Field is not verified by CASH team

       CreationDate,
       CreationTime,
       OpenedDate, // Global Field is not verified by CASH team

       OpenedTime, // Global Field is not verified by CASH team

       LastChangeDate,
       LastChangeTime,
       ClosedDate, // Global Field is not verified by CASH team

       ClosedTime, // Global Field is not verified by CASH team

       BankControlKey,
       IBANValidityStartDate,
       //    @ObjectModel.foreignKey.association: '_ControllingArea' //Inserted by VDM CDS Suite Plugin

       //I_CompanyCode.ControllingArea,

       //   TransactionCode,

       PaymentTransactionTypeGroup,
       BankAccountCurrency,
       LeadingCashPoolID,
       ParticipantCashPoolID,

       MaxTargetAmount,

       MinTransferAmount,
       LeadingPaymentMethod,
       ParticipantPaymentMethod,
       PaymentServiceProvider,
       CashToleranceGroup,
       IntradayIsReconciled,
       TreasuryFinancialObject,
       //--[ GENERATED:012:E6ExH29r7kY4hHBW6NEXPW

       @Consumption.valueHelpDefinition: [
         { entity:  { name:    'I_ControllingArea',
                      element: 'ControllingArea' }
         }]
       // ]--GENERATED

       @ObjectModel.foreignKey.association: '_ControllingArea'
       _CompanyCode.ControllingArea as ControllingArea,
       BankStatementCheckTime,
       BankStatementImportMethod,
       IntraDayBankStateImportMethod,
       BankStatementImportChannel,
       IsUploadOfIntraDayStatement,
       //Obsoleted

       EndOfDayIsReconciled,
       BkStmntEndOfDayIsReconciled,
       IHBAccountHolder,
       BankAccountCharacteristic,
       _Reference.BankAccountUUID,
       cast( bintohex( _Reference.BankAccountUUID  ) as fclm_bam_acct_oid ) as BankAccountOID,
       _Bank,
       _CompanyCode,
       _ProfitCenter,
       _BusinessArea,
       _Segment,
       _BankCountry,
       _ControllingArea,
       _Text,
       _BankAccountCurrency,
       _BankAccountHierarchyNode,
       _Reference,
       I_BankAccountBasicData._BankAccountType
}
where
  BankAccountStatus <> '28'

Depth:

I_BANKACCOUNT

CDS Views using this table (30)

Fields (15)

Learn More