P_PAYMENTREQUESTPAYEE

DDL: P_PAYMENTREQUESTPAYEE Type: view_entity COMPOSITE
11 Fields 1 Data Sources 2 Associations

P_PAYMENTREQUESTPAYEE is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_PaymentRequest) and exposes 11 fields with key fields PayeeName, CustomerSupplierAccount, FinancialAccountType, CompanyCode, BankAccount. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PaymentRequest I_PaymentRequest from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_PaymentRequestCustomerVH _Customer $projection.customersupplieraccount = _Customer.Customer and $projection.CompanyCode = _Customer.CompanyCode and $projection.BankCountry = _Customer.BankCountry and $projection.Bank = _Customer.Bank and $projection.BankAccount = _Customer.BankAccount
[1..1] C_PaymentRequestSupplierVH _Supplier $projection.customersupplieraccount = _Supplier.Supplier and $projection.CompanyCode = _Supplier.CompanyCode and $projection.BankCountry = _Supplier.BankCountry and $projection.Bank = _Supplier.Bank and $projection.BankAccount = _Supplier.BankAccount

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY PayeeName PayeeName
KEY CustomerSupplierAccount _PaytReqChangeAndPost CustomerSupplierAccount
KEY FinancialAccountType _PaytReqChangeAndPost FinancialAccountType Fin. Account Type
KEY CompanyCode I_PaymentRequest CompanyCode Receiver Company Code
KEY BankAccount I_PaymentRequest PayeeBankAccount
BankCountry I_PaymentRequest BankCountry Bank Ctry/Rgn. Key
Bank
PayeeStreet PayeeStreet
PayeeCountry PayeeCountry
_Customer _Customer
_Supplier _Supplier

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 P_PAYMENTREQUESTPAYEE.
-- 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 P_PAYMENTREQUESTPAYEE AS
SELECT
  PayeeName,
  _PaytReqChangeAndPost.CustomerSupplierAccount AS CustomerSupplierAccount,
  _PaytReqChangeAndPost.FinancialAccountType AS FinancialAccountType,
  I_PaymentRequest.CompanyCode AS CompanyCode,
  I_PaymentRequest.PayeeBankAccount AS BankAccount,
  I_PaymentRequest.BankCountry AS BankCountry,
  I_PaymentRequest._Bank.Bank AS Bank,
  PayeeStreet,
  PayeeCountry
FROM I_PaymentRequest
LEFT OUTER JOIN C_PaymentRequestCustomerVH AS _Customer ON customersupplieraccount = _Customer.Customer AND CompanyCode = _Customer.CompanyCode AND BankCountry = _Customer.BankCountry AND Bank = _Customer.Bank AND BankAccount = _Customer.BankAccount  -- association [1..1]
LEFT OUTER JOIN C_PaymentRequestSupplierVH AS _Supplier ON customersupplieraccount = _Supplier.Supplier AND CompanyCode = _Supplier.CompanyCode AND BankCountry = _Supplier.BankCountry AND Bank = _Supplier.Bank AND BankAccount = _Supplier.BankAccount  -- association [1..1]
;

Learn More