I_BkRelshpDocBankAccount

DDL: I_BKRELSHPDOCBANKACCOUNT SQL: IBKRELDOCBKACCT Type: view COMPOSITE Package: FCLM_BRM_DOC
72 Fields 1 Data Sources 9 Associations

Bank Accounts of Bank Relationship Doc

I_BkRelshpDocBankAccount is a Composite CDS View that provides data about "Bank Accounts of Bank Relationship Doc" in SAP S/4HANA. It reads from 1 data source (I_BkRelshpDocBkAcctBasic) and exposes 72 fields with key field BankAccountInternalID. It has 9 associations to related views. Part of development package FCLM_BRM_DOC.

Data Sources (1)

SourceAliasJoin Type
I_BkRelshpDocBkAcctBasic I_BkRelshpDocBkAcctBasic from

Associations (9)

CardinalityTargetAliasCondition
[0..1] I_BankAcctContrTypeVH _ContractType $projection.BankAccountType = _ContractType.BankAccountType
[0..*] I_BankAccountType _BankAccountType $projection.BankAccountType = _BankAccountType.BankAccountType
[0..1] I_Bank _Bank $projection.Bank = _Bank.BankInternalID
[0..1] I_Country _BankCountry $projection.BankCountry = _BankCountry.Country
[0..1] I_BankHierBankGroupMapping _BankGroup $projection.BankAccountInternalID = _BankGroup.BankAccountInternalID
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_BankAccountText _BankAccountText $projection.BankAccountInternalID = _BankAccountText.BankAccountInternalID and _BankAccountText.Language = $session.system_language
[0..1] I_SingleActiveHouseBankAccount _HouseBankAccount $projection.BankAccountInternalID = _HouseBankAccount.BankAccountInternalID
[0..1] I_BankAccountStatus _BankAccountStatus $projection.BankAccountStatus = _BankAccountStatus.BankAccountStatus and _BankAccountStatus.Language = $session.system_language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IBKRELDOCBKACCT view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Bank Accounts of Bank Relationship Doc view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.personalData.blocking #REQUIRED view

Fields (72)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID BankAccountInternalID Technical ID
BankCountry BankCountry Bank Ctry/Rgn. Key
Bank Bank Bank Number
BankAccountNumber BankAccountNumber Bank Account
BankAccountType BankAccountType Account Type
BankAccountContractType _ContractType BankAccountContractType
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
IBAN IBAN IBAN House Bank
BankAccountStatus BankAccountStatus Account Status
CompanyCode CompanyCode Receiver Company Code
ProfitCenter ProfitCenter Profit Center
BusinessArea BusinessArea Business Area
Segment Segment Segment number
BankAccountHolderName BankAccountHolderName Account Holder
BankContactPerson BankContactPerson General Contact
BankRelationshipManager BankRelationshipManager Relationship Manager
CompanyContactPerson CompanyContactPerson Contact Person
BankAccountSupervisor BankAccountSupervisor Account Supervisor
CreatedByUser CreatedByUser User Name
OpenedByUser OpenedByUser Opened By
LastChangedByUser LastChangedByUser User Name
ReviewedByUser ReviewedByUser Reviewed By
ClosedByUser ClosedByUser Closed By
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
DomesticCutOffTime DomesticCutOffTime Cut-Off Domestic
CrossBorderCutOffTime CrossBorderCutOffTime Cut-Off Cross Border
PlannedClosingDate PlannedClosingDate Planned Closing
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
OpenedDate OpenedDate Opened On
OpenedTime OpenedTime Opened At
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
ClosedDate ClosedDate Closed On
ClosedTime ClosedTime Closed At
BankControlKey BankControlKey Control Key
IBANValidityStartDate IBANValidityStartDate IBAN Valid From
PaymentTransactionTypeGroup PaymentTransactionTypeGroup Payment Transaction Type Group
BankAccountCurrency BankAccountCurrency Currency
LeadingCashPoolID LeadingCashPoolID Cash Pool Name
ParticipantCashPoolID ParticipantCashPoolID Cash Pool Name
MaxTargetAmount MaxTargetAmount Target Balance
MinTransferAmount MinTransferAmount Min.Transfer Amount
LeadingPaymentMethod LeadingPaymentMethod Payment Method
ParticipantPaymentMethod ParticipantPaymentMethod Payment Method
PaymentServiceProvider PaymentServiceProvider Payt Srvc Provider
CashToleranceGroup CashToleranceGroup Tolerance Group
IntradayIsReconciled IntradayIsReconciled Reconcile Intraday
TreasuryFinancialObject TreasuryFinancialObject Val. Obj. No.
BankStatementCheckTime BankStatementCheckTime Check Time
BankStatementImportMethod BankStatementImportMethod EoD
IntraDayBankStateImportMethod IntraDayBankStateImportMethod Intraday
BankStatementImportChannel BankStatementImportChannel Importing Channel
IsUploadOfIntraDayStatement IsUploadOfIntraDayStatement Intraday Upload
EndOfDayIsReconciled EndOfDayIsReconciled Reconcile End-of-Day
IHBAccountHolder IHBAccountHolder Busn. Partner
BankGroup _BankGroup BankGroup
BusinessPartnerName _BankGroup BusinessPartnerName Extracted Customer Name
CompanyCodeCountry _CompanyCode Country Venue: Ctry/Reg
CompanyCodeName _CompanyCode CompanyCodeName Company Name
BankAccountDescription _BankAccountText BankAccountDescription
BankName _Bank BankName Bank Name
HouseBank _HouseBankAccount HouseBank House Bank
HouseBankAccount _HouseBankAccount HouseBankAccount House Bank Account
_ContractType _ContractType
_BankCountry _BankCountry
_BankAccountType _BankAccountType
_BankGroup _BankGroup
_CompanyCode _CompanyCode
_HouseBankAccount _HouseBankAccount
_BankAccountStatus _BankAccountStatus

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_BkRelshpDocBankAccount.
-- 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: IBKRELDOCBKACCT

CREATE VIEW I_BkRelshpDocBankAccount AS
SELECT
  BankAccountInternalID,
  BankCountry,
  Bank,
  BankAccountNumber,
  BankAccountType,
  _ContractType.BankAccountContractType AS BankAccountContractType,
  ValidityStartDate,
  ValidityEndDate,
  IBAN,
  BankAccountStatus,
  CompanyCode,
  ProfitCenter,
  BusinessArea,
  Segment,
  BankAccountHolderName,
  BankContactPerson,
  BankRelationshipManager,
  CompanyContactPerson,
  BankAccountSupervisor,
  CreatedByUser,
  OpenedByUser,
  LastChangedByUser,
  ReviewedByUser,
  ClosedByUser,
  IsMarkedForDeletion,
  DomesticCutOffTime,
  CrossBorderCutOffTime,
  PlannedClosingDate,
  CreationDate,
  CreationTime,
  OpenedDate,
  OpenedTime,
  LastChangeDate,
  LastChangeTime,
  ClosedDate,
  ClosedTime,
  BankControlKey,
  IBANValidityStartDate,
  PaymentTransactionTypeGroup,
  BankAccountCurrency,
  LeadingCashPoolID,
  ParticipantCashPoolID,
  MaxTargetAmount,
  MinTransferAmount,
  LeadingPaymentMethod,
  ParticipantPaymentMethod,
  PaymentServiceProvider,
  CashToleranceGroup,
  IntradayIsReconciled,
  TreasuryFinancialObject,
  BankStatementCheckTime,
  BankStatementImportMethod,
  IntraDayBankStateImportMethod,
  BankStatementImportChannel,
  IsUploadOfIntraDayStatement,
  EndOfDayIsReconciled,
  IHBAccountHolder,
  _BankGroup.BankGroup AS BankGroup,
  _BankGroup.BusinessPartnerName AS BusinessPartnerName,
  _CompanyCode.Country AS CompanyCodeCountry,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _BankAccountText.BankAccountDescription AS BankAccountDescription,
  _Bank.BankName AS BankName,
  _HouseBankAccount.HouseBank AS HouseBank,
  _HouseBankAccount.HouseBankAccount AS HouseBankAccount
FROM I_BkRelshpDocBkAcctBasic
LEFT OUTER JOIN I_BankAcctContrTypeVH AS _ContractType ON BankAccountType = _ContractType.BankAccountType  -- association [0..1]
LEFT OUTER JOIN I_BankAccountType AS _BankAccountType ON BankAccountType = _BankAccountType.BankAccountType  -- association [0..*]
LEFT OUTER JOIN I_Bank AS _Bank ON Bank = _Bank.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_Country AS _BankCountry ON BankCountry = _BankCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_BankHierBankGroupMapping AS _BankGroup ON BankAccountInternalID = _BankGroup.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BankAccountText AS _BankAccountText ON BankAccountInternalID = _BankAccountText.BankAccountInternalID AND _BankAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SingleActiveHouseBankAccount AS _HouseBankAccount ON BankAccountInternalID = _HouseBankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankAccountStatus AS _BankAccountStatus ON BankAccountStatus = _BankAccountStatus.BankAccountStatus AND _BankAccountStatus.Language = $session.system_language  -- association [0..1]
;

Learn More