C_CN_RequisitionHistoryTP

DDL: C_CN_REQUISITIONHISTORYTP Type: view_entity CONSUMPTION Package: GLO_FIN_PAY_REQN_CN
13 Fields 1 Data Sources 1 OData Services

Payment Requisition: History for CN

C_CN_RequisitionHistoryTP is a Consumption CDS View that provides data about "Payment Requisition: History for CN" in SAP S/4HANA. It reads from 1 data source (R_CN_RequisitionHistoryTP) and exposes 13 fields with key field PaymentRequisitionHistoryUUID. It is exposed through 1 OData service (UI_CN_PAYTREQUISITION_MANAGE). Part of development package GLO_FIN_PAY_REQN_CN.

Data Sources (1)

SourceAliasJoin Type
R_CN_RequisitionHistoryTP R_CN_RequisitionHistoryTP projection

Annotations (7)

NameValueLevelField
EndUserText.label Payment Requisition: History for CN view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey PaymentRequisitionHistoryUUID view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

OData Services (1)

ServiceBindingVersionContractRelease
UI_CN_PAYTREQUISITION_MANAGE UI_CN_PAYTREQUISITION_M V2 C1 NOT_TO_BE_RELEASED_STABLE

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY PaymentRequisitionHistoryUUID PaymentRequisitionHistoryUUID
PaymentRequisitionUUID PaymentRequisitionUUID
PaymentRequisitionStrategyUUID PaymentRequisitionStrategyUUID
PaymentReqnPaymentItemUUID PaymentReqnPaymentItemUUID
PaymentRequisitionAction PaymentRequisitionAction
PaymentRequisitionActionName
SystemMessageType SystemMessageType Message type
SystemMessageTypeName
virtualSystemMessageLongTextbaltmsg
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
ChangedOnDateTime ChangedOnDateTime Last Changed At
HistoryDateTime HistoryDateTime Created On

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_RequisitionHistoryTP.
-- 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_RequisitionHistoryTP AS
SELECT
  PaymentRequisitionHistoryUUID,
  PaymentRequisitionUUID,
  PaymentRequisitionStrategyUUID,
  PaymentReqnPaymentItemUUID,
  PaymentRequisitionAction,
  _ActionText[1: Language = $session.system_language].PaymentRequisitionActionName AS PaymentRequisitionActionName,
  SystemMessageType,
  _SystMsgTypeText[1: Language = $session.system_language].DomainText AS SystemMessageTypeName,
  virtual SystemMessageLongText: baltmsg AS virtualSystemMessageLongTextbaltmsg,
  CreatedByUser,
  CreationDateTime,
  ChangedOnDateTime,
  HistoryDateTime
FROM R_CN_RequisitionHistoryTP
;

Learn More