I_PaymentReceiptRelatedDoc

DDL: I_PAYMENTRECEIPTRELATEDDOC SQL: IPAYTRCPTADOC Type: view BASIC Package: GLO_FIN_PAYMENT_RECEIPT
8 Fields 2 Data Sources

Payment Receipt Related Acctg Documents

I_PaymentReceiptRelatedDoc is a Basic CDS View that provides data about "Payment Receipt Related Acctg Documents" in SAP S/4HANA. It reads from 2 data sources (paytrcpt, paytrcpt_adoc) and exposes 8 fields with key field WorkItemUUID. Part of development package GLO_FIN_PAYMENT_RECEIPT.

Data Sources (2)

SourceAliasJoin Type
paytrcpt PaymentReceipt left_outer
paytrcpt_adoc PaymentReceiptRelatedDoc from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPAYTRCPTADOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
EndUserText.label Payment Receipt Related Acctg Documents view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY WorkItemUUID paytrcpt_adoc_uuid Payt ADoc UUID
PaymentReceiptUUID paytrcpt_adoc paytrcpt_uuid Payt Rcpt UUID
Ledger paytrcpt_adoc rldnr Ledger (Compat.)
AccountingDocument belnr SD Document
LedgerGLLineItem
CompanyCode paytrcpt bukrs Value
FiscalYear paytrcpt fiscalyear G/L Fiscal Year
PaymentReceiptStatus paytrcpt status Workflow Status

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 I_PaymentReceiptRelatedDoc.
-- 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.
-- SQL view name: IPAYTRCPTADOC

CREATE VIEW I_PaymentReceiptRelatedDoc AS
SELECT
  paytrcpt_adoc_uuid AS WorkItemUUID,
  PaymentReceiptRelatedDoc.paytrcpt_uuid AS PaymentReceiptUUID,
  PaymentReceiptRelatedDoc.rldnr AS Ledger,
  belnr AS AccountingDocument,
  cast(RIGHT(docln ,3) as farp_buzei) AS LedgerGLLineItem,
  PaymentReceipt.bukrs AS CompanyCode,
  PaymentReceipt.fiscalyear AS FiscalYear,
  PaymentReceipt.status AS PaymentReceiptStatus
FROM paytrcpt_adoc AS PaymentReceiptRelatedDoc
LEFT OUTER JOIN paytrcpt AS PaymentReceipt ON /* join condition not captured in parsed metadata */
;

Learn More