I_BankAccountMainLinkage

DDL: I_BANKACCOUNTMAINLINKAGE SQL: IBNKACCTMAINLNK Type: view BASIC

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.

2 data source(s) 6 fields

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
CompanyCode link CompanyCode
HouseBank link HouseBank
HouseBankAccount link HouseBankAccount
ValidityStartDate link ValidityStartDate
ValidityEndDate link ValidityEndDate 
@AbapCatalog.sqlViewName: 'IBNKACCTMAINLNK'
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Bank Account Main Linkage'
@ObjectModel.representativeKey: 'BankAccountInternalID'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MIXED
@Metadata.ignorePropogatedAnnotations: true
@Metadata.allowExtensions:true
define view I_BankAccountMainLinkage
  as select distinct from I_Bankaccountlinkage as link
    inner join P_BankAccountLinkageCount as cnt
    on  link.BankAccountInternalID = cnt.BankAccountInternalID
    left outer join febko
    on  link.CompanyCode      = febko.bukrs
    and link.HouseBank        = febko.hbkid
    and link.HouseBankAccount = febko.hktid
{
  key link.BankAccountInternalID,
  link.CompanyCode,
  link.HouseBank,
  link.HouseBankAccount,
  link.ValidityStartDate,
  link.ValidityEndDate
} where cnt = 1 or febko.kukey is not null

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BANKACCOUNTLINKAGE",
"P_BANKACCOUNTLINKAGECOUNT",
"FEBKO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More