I_HouseBankPaymentMethRankOrd

DDL: I_HOUSEBANKPAYMENTMETHRANKORD Type: view_entity BASIC Package: GLO_FIN_PAY_REQN_CN

Ranked account for payment method

I_HouseBankPaymentMethRankOrd is a Basic CDS View that provides data about "Ranked account for payment method" in SAP S/4HANA. It reads from 1 data source (t042iy) and exposes 7 fields with key fields CompanyCode, HouseBank, PaymentMethod, Currency, PaymentApplicationCode. Part of development package GLO_FIN_PAY_REQN_CN.

Data Sources (1)

SourceAliasJoin Type
t042iy t042iy from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Ranked account for payment method view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode zbukr Paying CoCd
KEY HouseBank hbkid House Bank
KEY PaymentMethod zlsch Pymt Meth.
KEY Currency waers Transaction Currency
KEY PaymentApplicationCode appli Program Indicator
KEY RankNumberOfHouseBankAccount rangf Sort
HouseBankAccount hktid House Bank Account

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_HouseBankPaymentMethRankOrd.
-- 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_HouseBankPaymentMethRankOrd AS
SELECT
  zbukr AS CompanyCode,
  hbkid AS HouseBank,
  zlsch AS PaymentMethod,
  waers AS Currency,
  appli AS PaymentApplicationCode,
  rangf AS RankNumberOfHouseBankAccount,
  hktid AS HouseBankAccount
FROM t042iy
;