I_BusinessPartnerBankTP

DDL: I_BUSINESSPARTNERBANKTP SQL: IBUPABANKTP Type: view TRANSACTIONAL
25 Fields 1 Data Sources 1 Associations

Association View for bank details

I_BusinessPartnerBankTP is a Transactional CDS View that provides data about "Association View for bank details" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerBank) and exposes 25 fields with key fields BankIdentification, BusinessPartner. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerBank BusinessPartnerBank from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IBUPABANKTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Association View for bank details view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeEnabled true view
ObjectModel.writeDraftPersistence BUPA_BANK_D view
ObjectModel.draftEnabled true view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY BankIdentification I_BusinessPartnerBank BankIdentification Bank Details
KEY BusinessPartner I_BusinessPartnerBank BusinessPartner Issuing Authority
BankIdentificationForEdit I_BusinessPartnerBank BankIdentification Bank Details
BusinessPartnerForEdit I_BusinessPartnerBank BusinessPartner Issuing Authority
BankCountryKey I_BusinessPartnerBank BankCountryKey Bank Ctry/Reg.
BankName I_BusinessPartnerBank BankName Bank Name
BankNumber I_BusinessPartnerBank BankNumber Bank Key
SWIFTCode I_BusinessPartnerBank SWIFTCode SWIFT/BIC
BankControlKey I_BusinessPartnerBank BankControlKey Control Key
BankAccountHolderName I_BusinessPartnerBank BankAccountHolderName Account Holder
BankAccountName I_BusinessPartnerBank BankAccountName Account Name
IBAN I_BusinessPartnerBank IBAN IBAN House Bank
IBANValidityStartDate I_BusinessPartnerBank IBANValidityStartDate IBAN Valid From
BankAccount I_BusinessPartnerBank BankAccount Bank acct
BankAccountReferenceText I_BusinessPartnerBank BankAccountReferenceText Reference
CollectionAuthInd I_BusinessPartnerBank CollectionAuthInd Collect.author.
BPBankIsProtected I_BusinessPartnerBank BPBankIsProtected Sensitivity
BankValidityStartDate
BankValidityEndDate
ValidityStartDate I_BusinessPartnerBank ValidityStartDate Validity Start Date
ValidityEndDate I_BusinessPartnerBank ValidityEndDate ValidTo
PaymentSystem
AliasType
BPBankAccountAliasName
_BusinessPartner _BusinessPartner

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_BusinessPartnerBankTP.
-- 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: IBUPABANKTP

CREATE VIEW I_BusinessPartnerBankTP AS
SELECT
  BusinessPartnerBank.BankIdentification AS BankIdentification,
  BusinessPartnerBank.BusinessPartner AS BusinessPartner,
  BusinessPartnerBank.BankIdentification AS BankIdentificationForEdit,
  BusinessPartnerBank.BusinessPartner AS BusinessPartnerForEdit,
  BusinessPartnerBank.BankCountryKey AS BankCountryKey,
  BusinessPartnerBank.BankName AS BankName,
  BusinessPartnerBank.BankNumber AS BankNumber,
  BusinessPartnerBank.SWIFTCode AS SWIFTCode,
  BusinessPartnerBank.BankControlKey AS BankControlKey,
  BusinessPartnerBank.BankAccountHolderName AS BankAccountHolderName,
  BusinessPartnerBank.BankAccountName AS BankAccountName,
  BusinessPartnerBank.IBAN AS IBAN,
  BusinessPartnerBank.IBANValidityStartDate AS IBANValidityStartDate,
  BusinessPartnerBank.BankAccount AS BankAccount,
  BusinessPartnerBank.BankAccountReferenceText AS BankAccountReferenceText,
  BusinessPartnerBank.CollectionAuthInd AS CollectionAuthInd,
  BusinessPartnerBank.BPBankIsProtected AS BPBankIsProtected,
  tstmp_to_dats(BusinessPartnerBank.ValidityStartDate,'UTC', $session.client, 'NULL') AS BankValidityStartDate,
  tstmp_to_dats(BusinessPartnerBank.ValidityEndDate,'UTC', $session.client, 'NULL') AS BankValidityEndDate,
  BusinessPartnerBank.ValidityStartDate AS ValidityStartDate,
  BusinessPartnerBank.ValidityEndDate AS ValidityEndDate,
  BusinessPartnerBank._BusinessPartnerBankAlias.PaymentSystem AS PaymentSystem,
  BusinessPartnerBank._BusinessPartnerBankAlias.AliasType AS AliasType,
  BusinessPartnerBank._BusinessPartnerBankAlias.BPBankAccountAliasName AS BPBankAccountAliasName
FROM I_BusinessPartnerBank AS BusinessPartnerBank
LEFT OUTER JOIN I_BusinessPartnerTP AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
;

Learn More