I_HouseBankBasic

DDL: I_HOUSEBANKBASIC SQL: IFIHOUSEBANKB Type: view BASIC Package: FCLM_BAM

House Bank Basic

I_HouseBankBasic (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public 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. Part of development package FCLM_BAM.

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 One of the following business catalogs needs to be assigned to a user to be able to use this CDS view: SAP_A4C_BC_DEV_TST_FIN_CM0_PC Users who want to use this CDS view must have a role that includes authorization based on at least one of the business catalogs listed above. In this role, the following restriction types must be set to read access: BUKRS These restriction types are edited in the Maintain Business Roles app.

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

CategoryBasic
StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-CLM-BAM-2CL
CapabilitiesData Source for Data Extraction,Data Source in SQL Select,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageFinancial Operations for SAP S/4HANA Cloud Public 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
;