A_CN_PaymentRequisition

DDL: A_CN_PAYMENTREQUISITION Type: view_entity CONSUMPTION Package: GLO_FIN_PAY_REQN_CN
19 Fields 1 Data Sources 1 OData Services

Payment Requisitions

A_CN_PaymentRequisition is a Consumption CDS View that provides data about "Payment Requisitions" in SAP S/4HANA. It reads from 1 data source (R_CN_PaymentRequisitionTP) and exposes 19 fields with key field PaymentRequisitionUUID. It is exposed through 1 OData service (API_CN_PAYMENTREQUISITION). Part of development package GLO_FIN_PAY_REQN_CN.

Data Sources (1)

SourceAliasJoin Type
R_CN_PaymentRequisitionTP R_CN_PaymentRequisitionTP projection

Annotations (10)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey PaymentRequisitionUUID view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Payment Requisitions view

OData Services (1)

ServiceBindingVersionContractRelease
API_CN_PAYMENTREQUISITION API_CN_PAYMENTREQUISITION V4 C2 C1

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY PaymentRequisitionUUID PaymentRequisitionUUID
PaymentRequisitionNumber PaymentRequisitionNumber
CompanyCode CompanyCode Receiver Company Code
Supplier Supplier Supplier
PaymentRequisitionStatus PaymentRequisitionStatus
PlannedPaymentDate PlannedPaymentDate
PaymentRequisitionPriority PaymentRequisitionPriority
PaytRequisitionAmtInTransCrcy PaytRequisitionAmtInTransCrcy
Currency Currency Valuation Crcy
PaymentRequisitionType PaymentRequisitionType
PaymentMethod PaymentMethod Pymt Meth.
NoteText NoteText Remark
WorkflowApproverNote WorkflowApproverNote
PaymentDifferenceReason PaymentDifferenceReason Reason Code
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User 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 A_CN_PaymentRequisition.
-- 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 A_CN_PaymentRequisition AS
SELECT
  PaymentRequisitionUUID,
  PaymentRequisitionNumber,
  CompanyCode,
  Supplier,
  PaymentRequisitionStatus,
  PlannedPaymentDate,
  PaymentRequisitionPriority,
  PaytRequisitionAmtInTransCrcy,
  Currency,
  PaymentRequisitionType,
  PaymentMethod,
  NoteText,
  WorkflowApproverNote,
  PaymentDifferenceReason,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  ChangedOnDateTime,
  AuthorizationGroup
FROM R_CN_PaymentRequisitionTP
;

Learn More