R_CN_RequisitionPaytStrategyTP

DDL: R_CN_REQUISITIONPAYTSTRATEGYTP Type: view_entity TRANSACTIONAL Package: GLO_FIN_PAY_REQN_CN
39 Fields 1 Data Sources 14 Associations

Payment Requisition: Payment Strategy for CN

R_CN_RequisitionPaytStrategyTP is a Transactional CDS View that provides data about "Payment Requisition: Payment Strategy for CN" in SAP S/4HANA. It reads from 1 data source (I_RequisitionPaytStrategy) and exposes 39 fields with key field PaymentRequisitionStrategyUUID. It has 14 associations to related views. Part of development package GLO_FIN_PAY_REQN_CN.

Data Sources (1)

SourceAliasJoin Type
I_RequisitionPaytStrategy PaymentStrategy from

Associations (14)

CardinalityTargetAliasCondition
[0..1] I_SupplierBankDetails _PayeeBank $projection.Bank = _PayeeBank.Bank and $projection.BankCountry = _PayeeBank.BankCountry and $projection.BankAccount = _PayeeBank.BankAccount and $projection.Supplier = _PayeeBank.Supplier
[0..*] I_CN_PaytReqnStrategyStatusT _StatusText $projection.PaymentReqnStrategyStatus = _StatusText.DomainValue
[0..1] I_UserContactCard _CreateUserContactCard $projection.CreatedByUser = _CreateUserContactCard.ContactCardID
[0..1] I_UserContactCard _ChangeUserContactCard $projection.LastChangedByUser = _ChangeUserContactCard.ContactCardID
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[1..*] I_HouseBankAccountText _HouseBankAccountText $projection.HouseBank = _HouseBankAccountText.HouseBank and $projection.CompanyCode = _HouseBankAccountText.CompanyCode and $projection.HouseBankAccount = _HouseBankAccountText.HouseBankAccount
[1..1] I_Bank_2 _Bank $projection.BankCountry = _Bank.BankCountry and $projection.Bank = _Bank.BankInternalID
[1..1] I_BankAccount _BankAccount $projection.BankCountry = _BankAccount.BankCountry and $projection.BankAccount = _BankAccount.BankAccountInternalID
[0..1] I_PaymentMethod _PaymentMethod $projection.Country = _PaymentMethod.Country and $projection.PaymentMethod = _PaymentMethod.PaymentMethod
[0..1] I_FinancialTransactionType _FinancialTransactionTypeText $projection.FinancialTransactionType = _FinancialTransactionTypeText.FinancialTransactionType
[0..*] R_CN_RequisitionPaymentItemTP _PaymentItem
[0..*] R_CN_RequisitionPaymentNoteTP _PaymentNote
[0..*] R_CN_ReqnPayStrategyHistoryTP _StrategyHistory

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Payment Requisition: Payment Strategy for CN view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY PaymentRequisitionStrategyUUID PaymentRequisitionStrategyUUID Payt Reqn Stgy UUID
PaymentRequisitionUUID PaymentRequisitionUUID PaymentReqnID
PaytRequisitionStrategyNumber PaytRequisitionStrategyNumber Payment Strategy Num
PaymentReqnStrategyStatus PaymentReqnStrategyStatus Payt Reqn Stgy Sts
PaytReqnStrategyAmtInTransCrcy PaytReqnStrategyAmtInTransCrcy Stgy Amount
Currency Currency Valuation Crcy
PaymentMethod PaymentMethod Pymt Meth.
PaymentDate PaymentDate Payment Date
CompanyCode _Requisition CompanyCode Receiver Company Code
Country
HouseBank HouseBank House Bank
RankNumberOfHouseBankAccount RankNumberOfHouseBankAccount Sort
HouseBankAccount HouseBankAccount House Bank Account
HouseBankAccountForEdit HouseBankAccount House Bank Account
Supplier _Requisition Supplier Supplier
BankCountry BankCountry Bank Ctry/Rgn. Key
Bank Bank Bank Number
BankAccount BankAccount Bank acct
BPBankAccountInternalID BPBankAccountInternalID BP Bank Account
FinancialTransactionType FinancialTransactionType Transact. Type
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
ChangedOnDateTime ChangedOnDateTime Last Changed At
_Requisition _Requisition
_PaymentItem _PaymentItem
_PaymentNote _PaymentNote
_StrategyHistory _StrategyHistory
_HouseBankAccountText _HouseBankAccountText
_PayeeBank _PayeeBank
_Bank _Bank
_BankAccount _BankAccount
_CompanyCode _CompanyCode
_Supplier _Supplier
_PaymentMethod _PaymentMethod
_StatusText _StatusText
_CreateUserContactCard _CreateUserContactCard
_ChangeUserContactCard _ChangeUserContactCard
_FinancialTransactionTypeText _FinancialTransactionTypeText

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 R_CN_RequisitionPaytStrategyTP.
-- 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 R_CN_RequisitionPaytStrategyTP AS
SELECT
  PaymentRequisitionStrategyUUID,
  PaymentRequisitionUUID,
  PaytRequisitionStrategyNumber,
  PaymentReqnStrategyStatus,
  PaytReqnStrategyAmtInTransCrcy,
  Currency,
  PaymentMethod,
  PaymentDate,
  _Requisition.CompanyCode AS CompanyCode,
  _Requisition._CompanyCode.Country AS Country,
  HouseBank,
  RankNumberOfHouseBankAccount,
  HouseBankAccount,
  HouseBankAccount AS HouseBankAccountForEdit,
  _Requisition.Supplier AS Supplier,
  BankCountry,
  Bank,
  BankAccount,
  BPBankAccountInternalID,
  FinancialTransactionType,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  ChangedOnDateTime
FROM I_RequisitionPaytStrategy AS PaymentStrategy
LEFT OUTER JOIN I_SupplierBankDetails AS _PayeeBank ON Bank = _PayeeBank.Bank AND BankCountry = _PayeeBank.BankCountry AND BankAccount = _PayeeBank.BankAccount AND Supplier = _PayeeBank.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CN_PaytReqnStrategyStatusT AS _StatusText ON PaymentReqnStrategyStatus = _StatusText.DomainValue  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _CreateUserContactCard ON CreatedByUser = _CreateUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ChangeUserContactCard ON LastChangedByUser = _ChangeUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_HouseBankAccountText AS _HouseBankAccountText ON HouseBank = _HouseBankAccountText.HouseBank AND CompanyCode = _HouseBankAccountText.CompanyCode AND HouseBankAccount = _HouseBankAccountText.HouseBankAccount  -- association [1..*]
LEFT OUTER JOIN I_Bank_2 AS _Bank ON BankCountry = _Bank.BankCountry AND Bank = _Bank.BankInternalID  -- association [1..1]
LEFT OUTER JOIN I_BankAccount AS _BankAccount ON BankCountry = _BankAccount.BankCountry AND BankAccount = _BankAccount.BankAccountInternalID  -- association [1..1]
LEFT OUTER JOIN I_PaymentMethod AS _PaymentMethod ON Country = _PaymentMethod.Country AND PaymentMethod = _PaymentMethod.PaymentMethod  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransactionType AS _FinancialTransactionTypeText ON FinancialTransactionType = _FinancialTransactionTypeText.FinancialTransactionType  -- association [0..1]
LEFT OUTER JOIN R_CN_RequisitionPaymentItemTP AS _PaymentItem ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CN_RequisitionPaymentNoteTP AS _PaymentNote ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CN_ReqnPayStrategyHistoryTP AS _StrategyHistory ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More