C_MntrPaymentReferenceNumber

DDL: C_MNTRPAYMENTREFERENCENUMBER Type: view_entity CONSUMPTION Package: ODATA_MONITOR_PAYMENT_BATCHES
10 Fields 2 Data Sources 2 OData Services

Reference Number

C_MntrPaymentReferenceNumber is a Consumption CDS View that provides data about "Reference Number" in SAP S/4HANA. It reads from 2 data sources (I_BankPaymentBatch, C_MonitorPaymentMediumPayment) and exposes 10 fields with key fields BatchUUID, PaymentRunDate, PaymentRunID, PayingCompanyCode, Supplier. It is exposed through 2 OData services (ASQL_F0770, ASQL_F2388). Part of development package ODATA_MONITOR_PAYMENT_BATCHES.

Data Sources (2)

SourceAliasJoin Type
I_BankPaymentBatch Batch from
C_MonitorPaymentMediumPayment CrossPayment inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
EndUserText.label Reference Number view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F0770 ASQL_F0770 C2 NOT_RELEASED
ASQL_F2388 ASQL_F2388 C2 NOT_RELEASED

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY BatchUUID I_BankPaymentBatch BatchUUID Target Grp GUID
KEY PaymentRunDate C_MonitorPaymentMediumPayment PaymentRunDate
KEY PaymentRunID C_MonitorPaymentMediumPayment PaymentRunID
KEY PayingCompanyCode C_MonitorPaymentMediumPayment PayingCompanyCode Paying Company Code
KEY Supplier C_MonitorPaymentMediumPayment Supplier Supplier
KEY Customer C_MonitorPaymentMediumPayment Customer Sold-to Party
KEY PaymentRecipient C_MonitorPaymentMediumPayment PaymentRecipient
KEY PaymentDocument C_MonitorPaymentMediumPayment PaymentDocument Payment Document Number
PaymentMediumReference
PaidItemDueDate

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_MntrPaymentReferenceNumber.
-- 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_MntrPaymentReferenceNumber AS
SELECT
  Batch.BatchUUID AS BatchUUID,
  CrossPayment.PaymentRunDate AS PaymentRunDate,
  CrossPayment.PaymentRunID AS PaymentRunID,
  CrossPayment.PayingCompanyCode AS PayingCompanyCode,
  CrossPayment.Supplier AS Supplier,
  CrossPayment.Customer AS Customer,
  CrossPayment.PaymentRecipient AS PaymentRecipient,
  CrossPayment.PaymentDocument AS PaymentDocument,
  Batch._PaymentMedia.PaymentMediumReference AS PaymentMediumReference,
  CrossPayment._PaymentProposalHeader.PaidItemDueDate AS PaidItemDueDate
FROM I_BankPaymentBatch AS Batch
INNER JOIN C_MonitorPaymentMediumPayment AS CrossPayment ON /* join condition not captured in parsed metadata */
;

Learn More