I_BkAcctLnkgAcctDetnPaytMethVH

DDL: I_BKACCTLNKGACCTDETNPAYTMETHVH Type: view COMPOSITE

Payment Method for Account Determination

I_BkAcctLnkgAcctDetnPaytMethVH is a Composite CDS View that provides data about "Payment Method for Account Determination" in SAP S/4HANA. It reads from 4 data sources (I_BkToBkPaymentClearingAccount, I_CompanyCode, I_PaymentMethodInCountryVH, I_Bankaccountlinkage) and exposes 12 fields with key fields CompanyCode, BankAccountInternalID, Country, PaymentMethod, Currency. It has 2 associations to related views.

Data Sources (4)

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Bankaccountlinkage _Bankaccountlinkage a.PayingCompanyCode = _Bankaccountlinkage.CompanyCode and a.HouseBank = _Bankaccountlinkage.HouseBank and a.HouseBankAccount = _Bankaccountlinkage.HouseBankAccount
[0..*] I_PaymentMethodText _Text $projection.Country = _Text.Country and $projection.PaymentMethod = _Text.PaymentMethod

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IMBTPAYTMETHVH view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Payment Method for Account Determination view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey PaymentMethod view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #COMPOSITE view
Search.searchable true view
Consumption.ranked true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_BkToBkPaymentClearingAccount PayingCompanyCode Paying Company Code
KEY BankAccountInternalID I_Bankaccountlinkage BankAccountInternalID Technical ID
KEY Country I_PaymentMethodInCountryVH Country Venue: Ctry/Reg
KEY PaymentMethod I_BkToBkPaymentClearingAccount PaymentMethod Pymt Meth.
KEY Currency I_BkToBkPaymentClearingAccount Currency Valuation Crcy
PaymentMethodName I_PaymentMethodInCountryVH PaymentMethodName Text
BankAccount I_Bankaccountlinkage BankAccount Bank acct
HouseBank I_BkToBkPaymentClearingAccount HouseBank House Bank
HouseBankAccount I_BkToBkPaymentClearingAccount HouseBankAccount House Bank Account
_Text _Text
_Country I_PaymentMethodInCountryVH _Country
_Bankaccountlinkage _Bankaccountlinkage

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_BkAcctLnkgAcctDetnPaytMethVH.
-- 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_BkAcctLnkgAcctDetnPaytMethVH AS
SELECT
  a.PayingCompanyCode AS CompanyCode,
  d.BankAccountInternalID AS BankAccountInternalID,
  c.Country AS Country,
  a.PaymentMethod AS PaymentMethod,
  a.Currency AS Currency,
  c.PaymentMethodName AS PaymentMethodName,
  d.BankAccount AS BankAccount,
  a.HouseBank AS HouseBank,
  a.HouseBankAccount AS HouseBankAccount,
  c._Country AS _Country
FROM I_BkToBkPaymentClearingAccount AS a
INNER JOIN I_CompanyCode AS b ON /* join condition not captured in parsed metadata */
INNER JOIN I_PaymentMethodInCountryVH AS c ON /* join condition not captured in parsed metadata */
INNER JOIN I_Bankaccountlinkage AS d ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Bankaccountlinkage AS _Bankaccountlinkage ON a.PayingCompanyCode = _Bankaccountlinkage.CompanyCode AND a.HouseBank = _Bankaccountlinkage.HouseBank AND a.HouseBankAccount = _Bankaccountlinkage.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_PaymentMethodText AS _Text ON Country = _Text.Country AND PaymentMethod = _Text.PaymentMethod  -- association [0..*]
;