I_BankAccountMainLinkage

DDL: I_BANKACCOUNTMAINLINKAGE SQL: IBNKACCTMAINLNK Type: view BASIC Package: FCLM_BAM
6 Fields 2 Data Sources

Bank Account Main Linkage

I_BankAccountMainLinkage is a Basic CDS View (Dimension) that provides data about "Bank Account Main Linkage" in SAP S/4HANA. It reads from 2 data sources (P_BankAccountLinkageCount, febko) and exposes 6 fields with key field BankAccountInternalID. Part of development package FCLM_BAM.

Data Sources (2)

SourceAliasJoin Type
P_BankAccountLinkageCount cnt inner
febko febko left_outer

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IBNKACCTMAINLNK view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bank Account Main Linkage view
ObjectModel.representativeKey BankAccountInternalID view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropogatedAnnotations true view
Metadata.allowExtensions true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID link BankAccountInternalID Technical ID
CompanyCode link CompanyCode Receiver Company Code
HouseBank link HouseBank House Bank
HouseBankAccount link HouseBankAccount House Bank Account
ValidityStartDate link ValidityStartDate Validity Start Date
ValidityEndDate link ValidityEndDate ValidTo

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_BankAccountMainLinkage.
-- 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: IBNKACCTMAINLNK

CREATE VIEW I_BankAccountMainLinkage AS
SELECT
  link.BankAccountInternalID AS BankAccountInternalID,
  link.CompanyCode AS CompanyCode,
  link.HouseBank AS HouseBank,
  link.HouseBankAccount AS HouseBankAccount,
  link.ValidityStartDate AS ValidityStartDate,
  link.ValidityEndDate AS ValidityEndDate
INNER JOIN P_BankAccountLinkageCount AS cnt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN febko ON /* join condition not captured in parsed metadata */
;

Learn More