I_PaytReceiptJournalEntryVH

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_PaytReceiptJournalEntryVH.
-- 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: IPAYTRECPTJEVH

CREATE VIEW I_PaytReceiptJournalEntryVH AS
SELECT
  AccountingDocument.CompanyCode AS CompanyCode,
  AccountingDocument.FiscalYear AS FiscalYear,
  AccountingDocument.AccountingDocument AS AccountingDocument,
  AccountingDocument.AccountingDocumentItem AS AccountingDocumentItem,
  cast('' as butxt) AS CompanyCodeName,
  AccountingDocument.Customer AS Customer,
  cast('' as md_customer_name) AS CustomerName,
  cast('' as land1) AS Country,
  AccountingDocument.Supplier AS Supplier,
  cast('' as md_supplier_name) AS SupplierName,
  AccountingDocument.DocumentReferenceID AS DocumentReferenceID,
  AccountingDocument.BusinessPlace AS BusinessPlace,
  cast('' as name1) AS BusinessPlaceName,
  AccountingDocument.DocumentDate AS DocumentDate,
  AccountingDocument.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  AccountingDocument.AccountingDocumentType AS AccountingDocumentType,
  cast('' as farp_ltext_003t) AS AccountingDocumentTypeName,
  AccountingDocument.Currency AS Currency,
  AccountingDocument.AlternativeReferenceDocument AS AlternativeReferenceDocument,
  cast('' as ph_biz_style) AS PH_BusinessStyleOfBPText,
  _usedJounralEntry.JournalEntry AS JournalEntry,
  AccountingDocument.ClearingAccountingDocument AS ClearingAccountingDocument,
  AccountingDocument.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  AccountingDocument.CashDiscountAmount AS CashDiscountAmount,
  AccountingDocument.NetPaymentAmount AS NetPaymentAmount,
  1 AS OperationalDocItemQty
FROM P_PaytReceiptJournalEntry AS AccountingDocument
LEFT OUTER JOIN P_PaymentReceiptRelatedDoc AS _usedJounralEntry ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PaytReceiptSupplierVH AS _Supplier ON _Supplier.CompanyCode = AccountingDocument.CompanyCode AND _Supplier.Supplier = AccountingDocument.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PaytReceiptCustomerVH AS _Customer ON _Customer.CompanyCode = AccountingDocument.CompanyCode AND _Customer.Customer = AccountingDocument.Customer  -- association [0..1]
LEFT OUTER JOIN I_PaytReceiptBusinessPlaceVH AS _BusinessPlace ON _BusinessPlace.CompanyCode = AccountingDocument.CompanyCode AND _BusinessPlace.BusinessPlace = AccountingDocument.BusinessPlace  -- association [0..1]
LEFT OUTER JOIN I_PaytReceiptCompanyCodeVH AS _companyCodeName ON AccountingDocument.CompanyCode = _companyCodeName.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _ADocText ON AccountingDocument.AccountingDocumentType = _ADocText.AccountingDocumentType AND _ADocText.Language = $session.system_language  -- association [0..1]
;