I_PaymentReceipt

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_PaymentReceipt.
-- 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: IPAYTRCPT

CREATE VIEW I_PaymentReceipt AS
SELECT
  paytrcpt_uuid AS PaymentReceiptUUID,
  paytrcpt_ref_no AS PredecessorReferenceDocument,
  paytrcpt_type AS PaymentReceiptType,
  cast( Description.ddtext as paytrcpt_type_desc ) AS PaymentReceiptTypeName,
  bukrs AS CompanyCode,
  paytrcpt_group AS PaymentReceiptLotNumber,
  paytrcpt_date AS PaymentReceiptIssueDate,
  FiscalYear,
  createrefuuid AS CreateReferencePaytRcptUUID,
  voidrefuuid AS VoidReferencePaytRcptUUID,
  ryoshusho AS OfficialReceiptNumber,
  CreatedByUser,
  createddate AS PaymentReceiptCreatedDate,
  LastChangedByUser,
  voidbyuser AS PaymentRcptVoidedByUserName,
  voideddate AS PaymentReceiptVoidedDate,
  paytrcpt_id AS PaymentReceiptID,
  Customer,
  Supplier,
  rldnr AS Ledger,
  output_uuid AS OutputRequestUUID,
  status AS PaymentReceiptStatus,
  voidremark AS AppraisalRemark,
  paytrcpt_ref1 AS JrnlEntryCntrySpecificRef1,
  paytrcpt_ref2 AS JrnlEntryCntrySpecificRef2,
  paytrcpt_ref3 AS JrnlEntryCntrySpecificRef3,
  cast('0' as abap.char(10)) AS AccountingDocument,
  voidr AS ChequeVoidReason,
  _PaymentTotal.CashAmtInCoCodeCrcy AS CashAmtInCoCodeCrcy,
  _PaymentTotal.PaymentCurrency AS PaymentCurrency
FROM paytrcpt AS PaymentReceipt
LEFT OUTER JOIN dd07t AS Description ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UserContactCard AS _CreateUserContactCard ON CreatedByUser = _CreateUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _VoidUserContactCard ON PaymentRcptVoidedByUserName = _VoidUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ChangeUserContactCard ON LastChangedByUser = _ChangeUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_PaymentReceiptRelatedDoc AS _AccountingDocument ON PaymentReceiptUUID = _AccountingDocument.PaymentReceiptUUID  -- association [0..*]
LEFT OUTER JOIN I_PH_PaymentReceipt AS _I_PH_PaymentReceipt ON PaymentReceiptUUID = _I_PH_PaymentReceipt.PaymentReceiptUUID  -- association [0..1]
LEFT OUTER JOIN P_PaymentReceiptPaytItemsTotal AS _PaymentTotal ON PaymentReceiptUUID = _PaymentTotal.PaymentReceiptUUID  -- association [0..1]
;