I_HouseBankBasic

DDL: I_HOUSEBANKBASIC SQL: IFIHOUSEBANKB Type: view BASIC
7 Fields 1 Data Sources

House Bank Basic

I_HouseBankBasic (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

House Bank · Financial Operations

I_HouseBankBasic is a Basic CDS View (Dimension) that provides data about "House Bank Basic" in SAP S/4HANA. It reads from 1 data source (I_Housebank) and exposes 7 fields with key fields CompanyCode, HouseBank.

SAP Help Documentation

CategoryCDS Views for Cash and Liquidity Management
Data CategoryDimension
StatusReleased
Purpose
This CDS view provides the prerequisites for answering the following business question: What are the bank names of my house banks?

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: F_BNKA_BUK (activity 03)

Structure
Object types This view is built on the following object types: Company Code Bank House Bank

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-CLM-BAM
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageFinancial Operations for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering the following business question:</p> <ul> <li><p>What are the bank names of my house banks?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_Housebank I_Housebank from

Annotations (19)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label House Bank Basic view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.sqlViewName IFIHOUSEBANKB view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey HouseBank view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.sapObjectNodeType.name HouseBank view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY HouseBank HouseBank Short Key for a House Bank
BankCountry BankCountry Bank Country/Region Key
BankInternalID BankInternalID Bank Keys
BankName _Bank BankName Name of Financial Institution
_Bank _Bank
_CompanyCode _CompanyCode

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_HouseBankBasic.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IFIHOUSEBANKB

CREATE VIEW I_HouseBankBasic AS
SELECT
  CompanyCode,
  HouseBank,
  BankCountry,
  BankInternalID,
  _Bank.BankName AS BankName
FROM I_Housebank
;

Learn More