I_HouseBankMaster

DDL: I_HOUSEBANKMASTER SQL: IHBKMASTER Type: view BASIC Package: FCLM_MANAGEBANKS
9 Fields 1 Data Sources

House Bank Master

I_HouseBankMaster is a Basic CDS View that provides data about "House Bank Master" in SAP S/4HANA. It reads from 1 data source (t012) and exposes 9 fields with key fields CompanyCode, HouseBank. Part of development package FCLM_MANAGEBANKS.

Data Sources (1)

SourceAliasJoin Type
t012 t012 from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IHBKMASTER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #BASIC view
EndUserText.label House Bank Master view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode t012 bukrs Value
KEY HouseBank t012 hbkid House Bank
BankCountry t012 banks Bank Ctry/Rgn. Key
BankInternalID t012 bankl House Bank
PhoneNumber1 t012 telf1 Telephone no.
TaxID1 t012 stcd1 Tax Number 1
ContactPersonName t012 name1 PA text
Language t012 spras Off. Language
BusinessPlace t012 bupla Business place

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_HouseBankMaster.
-- 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: IHBKMASTER

CREATE VIEW I_HouseBankMaster AS
SELECT
  t012.bukrs AS CompanyCode,
  t012.hbkid AS HouseBank,
  t012.banks AS BankCountry,
  t012.bankl AS BankInternalID,
  t012.telf1 AS PhoneNumber1,
  t012.stcd1 AS TaxID1,
  t012.name1 AS ContactPersonName,
  t012.spras AS Language,
  t012.bupla AS BusinessPlace
FROM t012
;

Learn More