I_AR_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_AR_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.

CREATE VIEW I_AR_PaytReceiptJournalEntryVH AS
SELECT
  _JournalEntry.CompanyCode AS CompanyCode,
  _JournalEntry.FiscalYear AS FiscalYear,
  _JournalEntry.AccountingDocument AS AccountingDocument,
  _JournalEntry.AccountingDocumentItem AS AccountingDocumentItem,
  _JournalEntry.CompanyCodeName AS CompanyCodeName,
  _JournalEntry.Customer AS Customer,
  _Customer.CustomerName AS CustomerName,
  _JournalEntry.Country AS Country,
  _JournalEntry.Supplier AS Supplier,
  cast('' as md_supplier_name) AS SupplierName,
  _JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  _JournalEntry.BusinessPlace AS BusinessPlace,
  _Branch.BranchName AS BusinessPlaceName,
  _JournalEntry.DocumentDate AS DocumentDate,
  _JournalEntry.PostingDate AS PostingDate,
  _JournalEntry.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  _ActgDocTypeText.AccountingDocumentTypeName AS AccountingDocumentTypeName,
  _JournalEntry.Currency AS Currency,
  _JournalEntry.AlternativeReferenceDocument AS AlternativeReferenceDocument,
  cast('' as ph_biz_style) AS PH_BusinessStyleOfBPText,
  cast('' as fis_belnr) AS JournalEntry,
  _JournalEntry.ClearingAccountingDocument AS ClearingAccountingDocument,
  _JournalEntry.CashDiscountAmount AS CashDiscountAmount,
  _JournalEntry.NetPaymentAmount AS NetPaymentAmount,
  _JournalEntry.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  _JournalEntry.OperationalDocItemQty AS OperationalDocItemQty,
  _Customer.AuthorizationGroup AS AuthorizationGroup
FROM P_PaytReceiptPaymentDocItem AS _JournalEntry
LEFT OUTER JOIN I_Customer AS _Customer ON _Customer.Customer = _JournalEntry.Customer  -- association [0..1]
LEFT OUTER JOIN I_Branch AS _Branch ON _Branch.Branch = _JournalEntry.BusinessPlace AND _Branch.CompanyCode = _JournalEntry.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _ActgDocTypeText ON _ActgDocTypeText.AccountingDocumentType = _JournalEntry.AccountingDocumentType AND _ActgDocTypeText.Language = $session.system_language  -- association [0..1]
;