I_BankChainItemTP

DDL: I_BANKCHAINITEMTP Type: view_entity TRANSACTIONAL
23 Fields 1 Data Sources 1 Associations

Intermediary bank of Bank Chain - TP

I_BankChainItemTP is a Transactional CDS View that provides data about "Intermediary bank of Bank Chain - TP" in SAP S/4HANA. It reads from 1 data source (I_BankChainItem) and exposes 23 fields with key fields BkChnCountryKeyOfRecipientBank, BkChnBankKeyOfRecipientBank, BkChnAcctNumberAtRecipientBank, BkChnCurrencyKey, BkChnCountryKeyOfSenderBank. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_BankChainItem I_BankChainItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BankChainBankTypeText _BankChainBankTypeText _BankChainBankTypeText.BkChnTypeOfBankInBankChain = $projection.BkChnTypeOfBankInBankChain and _BankChainBankTypeText.Language = $session.system_language

Annotations (8)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Intermediary bank of Bank Chain - TP view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY BkChnCountryKeyOfRecipientBank BkChnCountryKeyOfRecipientBank Country/Region Key of Recipient Bank
KEY BkChnBankKeyOfRecipientBank BkChnBankKeyOfRecipientBank Bank Key of Recipient Bank
KEY BkChnAcctNumberAtRecipientBank BkChnAcctNumberAtRecipientBank Account Number at Recipient Bank
KEY BkChnCurrencyKey BkChnCurrencyKey Currency
KEY BkChnCountryKeyOfSenderBank BkChnCountryKeyOfSenderBank Country/Region Key of Sender Bank
KEY BkChnBankKeyOfSenderBank BkChnBankKeyOfSenderBank Bank Key of Sender Bank
KEY BkChnPaymentMethodSupplement BkChnPaymentMethodSupplement Payment Method Supplement
KEY BkChnIntermediaryBank BkChnIntermediaryBank
BkChnCntryKeyOfRcpntBkForEdit BkChnCountryKeyOfRecipientBank Country/Region Key of Recipient Bank
BkChnBkKeyOfRcpntBkForEdit BkChnBankKeyOfRecipientBank Bank Key of Recipient Bank
BkChnAcctNmbrAtRcpntBkForEdit BkChnAcctNumberAtRecipientBank Account Number at Recipient Bank
BkChnCurrencyKeyForEdit BkChnCurrencyKey Currency
BkChnCntryKeyOfSndrBkForEdit BkChnCountryKeyOfSenderBank Country/Region Key of Sender Bank
BkChnBkKeyOfSndrBkForEdit BkChnBankKeyOfSenderBank Bank Key of Sender Bank
BkChnPaytMethSuplmntForEdit BkChnPaymentMethodSupplement Payment Method Supplement
BkChnIntermediaryBankForEdit BkChnIntermediaryBank
BkChnTypeOfBankInBankChain BkChnTypeOfBankInBankChain
BkChnCntryKeyOfCorrespondentBk BkChnCntryKeyOfCorrespondentBk
BkChnBkKeyOfCorrespondenceBank BkChnBkKeyOfCorrespondenceBank
BkChnAcctNmbrAtCorrespondBank BkChnAcctNmbrAtCorrespondBank
IBAN IBAN IBAN House Bank
_BankChainBankTypeText _BankChainBankTypeText
_Header _Header

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_BankChainItemTP.
-- 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.

CREATE VIEW I_BankChainItemTP AS
SELECT
  BkChnCountryKeyOfRecipientBank,
  BkChnBankKeyOfRecipientBank,
  BkChnAcctNumberAtRecipientBank,
  BkChnCurrencyKey,
  BkChnCountryKeyOfSenderBank,
  BkChnBankKeyOfSenderBank,
  BkChnPaymentMethodSupplement,
  BkChnIntermediaryBank,
  BkChnCountryKeyOfRecipientBank AS BkChnCntryKeyOfRcpntBkForEdit,
  BkChnBankKeyOfRecipientBank AS BkChnBkKeyOfRcpntBkForEdit,
  BkChnAcctNumberAtRecipientBank AS BkChnAcctNmbrAtRcpntBkForEdit,
  BkChnCurrencyKey AS BkChnCurrencyKeyForEdit,
  BkChnCountryKeyOfSenderBank AS BkChnCntryKeyOfSndrBkForEdit,
  BkChnBankKeyOfSenderBank AS BkChnBkKeyOfSndrBkForEdit,
  BkChnPaymentMethodSupplement AS BkChnPaytMethSuplmntForEdit,
  BkChnIntermediaryBank AS BkChnIntermediaryBankForEdit,
  BkChnTypeOfBankInBankChain,
  BkChnCntryKeyOfCorrespondentBk,
  BkChnBkKeyOfCorrespondenceBank,
  BkChnAcctNmbrAtCorrespondBank,
  IBAN
FROM I_BankChainItem
LEFT OUTER JOIN I_BankChainBankTypeText AS _BankChainBankTypeText ON _BankChainBankTypeText.BkChnTypeOfBankInBankChain = BkChnTypeOfBankInBankChain AND _BankChainBankTypeText.Language = $session.system_language  -- association [0..1]
;

Learn More