C_CN_PaymentRequisitionTP

DDL: C_CN_PAYMENTREQUISITIONTP Type: view_entity CONSUMPTION
28 Fields 1 Data Sources 2 OData Services

Payment Requisition for CN

C_CN_PaymentRequisitionTP is a Consumption CDS View that provides data about "Payment Requisition for CN" in SAP S/4HANA. It reads from 1 data source (R_CN_PaymentRequisitionTP) and exposes 28 fields with key field PaymentRequisitionUUID. It is exposed through 2 OData services (UI_CN_PAYTREQUISITION_CREATE, UI_CN_PAYTREQUISITION_MANAGE).

Data Sources (1)

SourceAliasJoin Type
R_CN_PaymentRequisitionTP R_CN_PaymentRequisitionTP projection

Annotations (8)

NameValueLevelField
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey PaymentRequisitionUUID view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Payment Requisition for CN view

OData Services (2)

ServiceBindingVersionContractRelease
UI_CN_PAYTREQUISITION_CREATE UI_CN_PAYTREQUISITION_C V2 C1 NOT_RELEASED
UI_CN_PAYTREQUISITION_MANAGE UI_CN_PAYTREQUISITION_M V2 C1 NOT_RELEASED

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY PaymentRequisitionUUID PaymentRequisitionUUID
PaymentRequisitionNumber PaymentRequisitionNumber
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
PaymentRequisitionStatus PaymentRequisitionStatus
PaymentRequisitionStatusName
Supplier Supplier Supplier
SupplierName _Supplier SupplierName Supplier Name
PaymentRequisitionPriority PaymentRequisitionPriority
PaymentRequisitionPriorityName
PaytRequisitionAmtInTransCrcy PaytRequisitionAmtInTransCrcy
Currency Currency Valuation Crcy
PaymentRequisitionType PaymentRequisitionType
PaymentRequisitionTypeName
PaymentMethod PaymentMethod Pymt Meth.
PaymentMethodDescription
NoteText NoteText Remark
WorkflowApproverNote WorkflowApproverNote
PlannedPaymentDate PlannedPaymentDate
PaymentDifferenceReason PaymentDifferenceReason Reason Code
PaymentDifferenceReasonName
CreatedByUser CreatedByUser User Name
CreatedByUserFullName _CreateUserContactCard FullName Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserFullName _ChangeUserContactCard FullName Name
ChangedOnDateTime ChangedOnDateTime Last Changed At
AuthorizationGroup AuthorizationGroup AuthorizGroup

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_PaymentRequisitionTP.
-- 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_PaymentRequisitionTP AS
SELECT
  PaymentRequisitionUUID,
  PaymentRequisitionNumber,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  PaymentRequisitionStatus,
  _StatusText[1: Language = $session.system_language].PaymentRequisitionStatusName AS PaymentRequisitionStatusName,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  PaymentRequisitionPriority,
  _PriorityText[1: Language = $session.system_language].PaymentRequisitionPriorityName AS PaymentRequisitionPriorityName,
  PaytRequisitionAmtInTransCrcy,
  Currency,
  PaymentRequisitionType,
  _RequisitionTypeText[1: Language = $session.system_language].PaymentRequisitionTypeName AS PaymentRequisitionTypeName,
  PaymentMethod,
  _PaymentMethodText[1: Language = $session.system_language].PaymentMethodDescription AS PaymentMethodDescription,
  NoteText,
  WorkflowApproverNote,
  PlannedPaymentDate,
  PaymentDifferenceReason,
  _PaytDifferenceReasonText[1: Language = $session.system_language].PaymentDifferenceReasonName AS PaymentDifferenceReasonName,
  CreatedByUser,
  _CreateUserContactCard.FullName AS CreatedByUserFullName,
  CreationDateTime,
  LastChangedByUser,
  _ChangeUserContactCard.FullName AS LastChangedByUserFullName,
  ChangedOnDateTime,
  AuthorizationGroup
FROM R_CN_PaymentRequisitionTP
;

Learn More