C_CN_RequisitionPaymentNoteTP

DDL: C_CN_REQUISITIONPAYMENTNOTETP Type: view_entity CONSUMPTION Package: GLO_FIN_PAY_REQN_CN
40 Fields 1 Data Sources 2 OData Services

Payment Requisition: Payment Note for CN

C_CN_RequisitionPaymentNoteTP is a Consumption CDS View that provides data about "Payment Requisition: Payment Note for CN" in SAP S/4HANA. It reads from 1 data source (R_CN_RequisitionPaymentNoteTP) and exposes 40 fields with key fields PaymentRequisitionPaytNoteUUID, BusinessTransactionDocUUID. 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_RequisitionPaymentNoteTP R_CN_RequisitionPaymentNoteTP projection

Annotations (9)

NameValueLevelField
Metadata.allowExtensions true view
EndUserText.label Payment Requisition: Payment Note for CN view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey PaymentRequisitionPaytNoteUUID view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M 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 (40)

KeyFieldSource TableSource FieldDescription
KEY PaymentRequisitionPaytNoteUUID PaymentRequisitionPaytNoteUUID
KEY BusinessTransactionDocUUID BusinessTransactionDocUUID
PaymentRequisitionStrategyUUID PaymentRequisitionStrategyUUID
PaymentRequisitionUUID PaymentRequisitionUUID
PaymentRequisitionPaytNoteType PaymentRequisitionPaytNoteType
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
BOEUsageAmountInTransCrcy BOEUsageAmountInTransCrcy
CompanyCode _BillOfExchange CompanyCode Receiver Company Code
CompanyName
BillOfExchangeNumber _BillOfExchange BillOfExchangeNumber
BillOfExchangeStatus _BillOfExchange BillOfExchangeStatus
BillOfExchangeStatusName
BillOfExchangePostingStatus _BillOfExchange BillOfExchangePostingStatus
BillOfExchangeReceiveDate _BillOfExchange BillOfExchangeReceiveDate
BillOfExchangeIssueDate _BillOfExchange BillOfExchangeIssueDate
BillOfExchangeDrawer _BillOfExchange BillOfExchangeDrawer
BOEDrawerBankKey _BillOfExchange BOEDrawerBankKey
BOEDrawerBankCountryKey _BillOfExchange BOEDrawerBankCountryKey
BOEDrawerBankName _BillOfExchange BOEDrawerBankName
BillOfExchangeDrawee _BillOfExchange BillOfExchangeDrawee
BOEDraweeBankKey _BillOfExchange BOEDraweeBankKey
BOEDraweeBankCountryKey _BillOfExchange BOEDraweeBankCountryKey
BOEDraweeBankName _BillOfExchange BOEDraweeBankName
BOEAcceptanceBankName _BillOfExchange BOEAcceptanceBankName
BOEAcceptanceBankKey _BillOfExchange BOEAcceptanceBankKey
BOEAcceptanceBankCountryKey _BillOfExchange BOEAcceptanceBankCountryKey
BillOfExchangeDueDate _BillOfExchange BillOfExchangeDueDate
BillOfExchangeAmtInTransCrcy _BillOfExchange BillOfExchangeAmtInTransCrcy
Currency Currency Valuation Crcy
Supplier _BillOfExchange Supplier Supplier
CustomerName
BPCustomerName
ProfitCenter _BillOfExchange ProfitCenter Profit Center
BillOfExchangeIsBlocked _BillOfExchange BillOfExchangeIsBlocked
BillOfExchangeIsAllowSplit _BillOfExchange BillOfExchangeIsAllowSplit Allow Split
BillOfExchangePackageRangeFrom _BillOfExchange BillOfExchangePackageRangeFrom Subpackage Range From
BillOfExchangePackageRangeTo _BillOfExchange BillOfExchangePackageRangeTo Subpackage Range To
BOEPackageAmountInTransCrcy _BillOfExchange BOEPackageAmountInTransCrcy Received/Issued Amount
BOEStandardAmountInTransCrcy _BillOfExchange BOEStandardAmountInTransCrcy Standard Amount

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_RequisitionPaymentNoteTP.
-- 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_RequisitionPaymentNoteTP AS
SELECT
  PaymentRequisitionPaytNoteUUID,
  BusinessTransactionDocUUID,
  PaymentRequisitionStrategyUUID,
  PaymentRequisitionUUID,
  PaymentRequisitionPaytNoteType,
  CreatedByUser,
  CreationDateTime,
  BOEUsageAmountInTransCrcy,
  _BillOfExchange.CompanyCode AS CompanyCode,
  _BillOfExchange._Company.CompanyCodeName AS CompanyName,
  _BillOfExchange.BillOfExchangeNumber AS BillOfExchangeNumber,
  _BillOfExchange.BillOfExchangeStatus AS BillOfExchangeStatus,
  _BillOfExchange._BillOfExchangeStatusText[1: Language = $session.system_language].BillOfExchangeStatusName AS BillOfExchangeStatusName,
  _BillOfExchange.BillOfExchangePostingStatus AS BillOfExchangePostingStatus,
  _BillOfExchange.BillOfExchangeReceiveDate AS BillOfExchangeReceiveDate,
  _BillOfExchange.BillOfExchangeIssueDate AS BillOfExchangeIssueDate,
  _BillOfExchange.BillOfExchangeDrawer AS BillOfExchangeDrawer,
  _BillOfExchange.BOEDrawerBankKey AS BOEDrawerBankKey,
  _BillOfExchange.BOEDrawerBankCountryKey AS BOEDrawerBankCountryKey,
  _BillOfExchange.BOEDrawerBankName AS BOEDrawerBankName,
  _BillOfExchange.BillOfExchangeDrawee AS BillOfExchangeDrawee,
  _BillOfExchange.BOEDraweeBankKey AS BOEDraweeBankKey,
  _BillOfExchange.BOEDraweeBankCountryKey AS BOEDraweeBankCountryKey,
  _BillOfExchange.BOEDraweeBankName AS BOEDraweeBankName,
  _BillOfExchange.BOEAcceptanceBankName AS BOEAcceptanceBankName,
  _BillOfExchange.BOEAcceptanceBankKey AS BOEAcceptanceBankKey,
  _BillOfExchange.BOEAcceptanceBankCountryKey AS BOEAcceptanceBankCountryKey,
  _BillOfExchange.BillOfExchangeDueDate AS BillOfExchangeDueDate,
  _BillOfExchange.BillOfExchangeAmtInTransCrcy AS BillOfExchangeAmtInTransCrcy,
  Currency,
  _BillOfExchange.Supplier AS Supplier,
  _BillOfExchange._Customer.CustomerName AS CustomerName,
  _BillOfExchange._Customer.BPCustomerName AS BPCustomerName,
  _BillOfExchange.ProfitCenter AS ProfitCenter,
  _BillOfExchange.BillOfExchangeIsBlocked AS BillOfExchangeIsBlocked,
  _BillOfExchange.BillOfExchangeIsAllowSplit AS BillOfExchangeIsAllowSplit,
  _BillOfExchange.BillOfExchangePackageRangeFrom AS BillOfExchangePackageRangeFrom,
  _BillOfExchange.BillOfExchangePackageRangeTo AS BillOfExchangePackageRangeTo,
  _BillOfExchange.BOEPackageAmountInTransCrcy AS BOEPackageAmountInTransCrcy,
  _BillOfExchange.BOEStandardAmountInTransCrcy AS BOEStandardAmountInTransCrcy
FROM R_CN_RequisitionPaymentNoteTP
;

Learn More