C_CN_RequisitionPaytStrategyTP

DDL: C_CN_REQUISITIONPAYTSTRATEGYTP Type: view_entity CONSUMPTION Package: GLO_FIN_PAY_REQN_CN
34 Fields 1 Data Sources 2 OData Services

Payment Requisition: Payment Strategy for CN

C_CN_RequisitionPaytStrategyTP is a Consumption CDS View that provides data about "Payment Requisition: Payment Strategy for CN" in SAP S/4HANA. It reads from 1 data source (R_CN_RequisitionPaytStrategyTP) and exposes 34 fields with key field PaymentRequisitionStrategyUUID. It is exposed through 2 OData services (UI_CN_PAYTREQUISITION_CREATE, UI_CN_PAYTREQUISITION_MANAGE). Part of development package GLO_FIN_PAY_REQN_CN.

Data Sources (1)

SourceAliasJoin Type
R_CN_RequisitionPaytStrategyTP R_CN_RequisitionPaytStrategyTP projection

Annotations (9)

NameValueLevelField
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey PaymentRequisitionStrategyUUID view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Payment Requisition: Payment Strategy for CN view

OData Services (2)

ServiceBindingVersionContractRelease
UI_CN_PAYTREQUISITION_CREATE UI_CN_PAYTREQUISITION_C V2 C1 NOT_TO_BE_RELEASED_STABLE
UI_CN_PAYTREQUISITION_MANAGE UI_CN_PAYTREQUISITION_M V2 C1 NOT_TO_BE_RELEASED_STABLE

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY PaymentRequisitionStrategyUUID PaymentRequisitionStrategyUUID
PaymentRequisitionUUID PaymentRequisitionUUID
PaytRequisitionStrategyNumber PaytRequisitionStrategyNumber
PaymentReqnStrategyStatus PaymentReqnStrategyStatus
PaymentReqnStrategyStatusName
PaytReqnStrategyAmtInTransCrcy PaytReqnStrategyAmtInTransCrcy
Currency Currency Valuation Crcy
PaymentMethod PaymentMethod Pymt Meth.
PaymentMethodName _PaymentMethod PaymentMethodName Text
virtualBOEPackageIsInactiveabap_boolean
PaymentDate PaymentDate Payment Date
CompanyCode _Requisition CompanyCode Receiver Company Code
CompanyCodeName
HouseBank HouseBank House Bank
RankNumberOfHouseBankAccount RankNumberOfHouseBankAccount
HouseBankAccount HouseBankAccount House Bank Account
HouseBankAccountForEdit HouseBankAccountForEdit House Bank Account
HouseBankAccountDescription
Supplier _Requisition Supplier Supplier
SupplierName
BPSupplierName
Bank Bank Bank Number
BankName _Bank BankName Bank Name
BankAccount BankAccount Bank acct
BankAccountDescription
BankCountry BankCountry Bank Ctry/Rgn. Key
BPBankAccountInternalID BPBankAccountInternalID BP Bank Account
BankDetailReference _PayeeBank BankDetailReference
FinancialTransactionType FinancialTransactionType Transact. Type
FinancialTransactionTypeText
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
ChangedOnDateTime ChangedOnDateTime Last Changed At

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 C_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 C_CN_RequisitionPaytStrategyTP AS
SELECT
  PaymentRequisitionStrategyUUID,
  PaymentRequisitionUUID,
  PaytRequisitionStrategyNumber,
  PaymentReqnStrategyStatus,
  _StatusText[1: Language = $session.system_language].PaymentReqnStrategyStatusName AS PaymentReqnStrategyStatusName,
  PaytReqnStrategyAmtInTransCrcy,
  Currency,
  PaymentMethod,
  _PaymentMethod.PaymentMethodName AS PaymentMethodName,
  virtual BOEPackageIsInactive : abap_boolean AS virtualBOEPackageIsInactiveabap_boolean,
  PaymentDate,
  _Requisition.CompanyCode AS CompanyCode,
  _Requisition._CompanyCode.CompanyCodeName AS CompanyCodeName,
  HouseBank,
  RankNumberOfHouseBankAccount,
  HouseBankAccount,
  HouseBankAccountForEdit,
  _HouseBankAccountText[1: Language = $session.system_language].HouseBankAccountDescription AS HouseBankAccountDescription,
  _Requisition.Supplier AS Supplier,
  _Requisition._Supplier.SupplierName AS SupplierName,
  _Requisition._Supplier.BPSupplierName AS BPSupplierName,
  Bank,
  _Bank.BankName AS BankName,
  BankAccount,
  _BankAccount._Text[1: Language = $session.system_language].BankAccountDescription AS BankAccountDescription,
  BankCountry,
  BPBankAccountInternalID,
  _PayeeBank.BankDetailReference AS BankDetailReference,
  FinancialTransactionType,
  _FinancialTransactionTypeText._Text[1: Language = $session.system_language].FinancialTransactionTypeName AS FinancialTransactionTypeText,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  ChangedOnDateTime
FROM R_CN_RequisitionPaytStrategyTP
;

Learn More