P_AR_JournalEntry

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 P_AR_JournalEntry.
-- 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: PARJOURNALENTRY

CREATE VIEW P_AR_JournalEntry AS
SELECT
  JournalEntry.CompanyCode AS CompanyCode,
  JournalEntry.FiscalYear AS FiscalYear,
  JournalEntry.AccountingDocument AS AccountingDocument,
  JournalEntry.FiscalPeriod AS FiscalPeriod,
  JournalEntry.PostingDate AS PostingDate,
  JournalEntry.ExchangeRateType AS ExchangeRateType,
  JournalEntry.DocumentDate AS DocumentDate,
  JournalEntry.TaxReportingDate AS TaxReportingDate,
  JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  JournalEntry.AccountingDocumentCategory AS AccountingDocumentCategory,
  JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  JournalEntry.Branch AS Branch,
  cast( case when JournalEntry.NmbrOfPages = '000' or JournalEntry.NmbrOfPages = '' then '001' else JournalEntry.NmbrOfPages end as j_1anopg ) as NmbrOfPages AS NmbrOfPagesendasj_1anopgasNmbrOfPages,
  JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  JournalEntry.IsReversal AS IsReversal,
  JournalEntry.IsReversed AS IsReversed,
  JournalEntry.ReverseDocument AS ReverseDocument,
  JournalEntry.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  JournalEntry.ReversalReferenceDocument AS ReversalReferenceDocument,
  JournalEntry.OriginalReferenceDocument AS OriginalReferenceDocument,
  JournalEntry.ReferenceDocumentType AS ReferenceDocumentType,
  JournalEntry.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  JournalEntry.ExchangeRateDate AS ExchangeRateDate,
  JournalEntry.LogicalSystem AS LogicalSystem,
  JournalEntry.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast( JournalEntry.TransactionCurrency as fis_rwcur preserving type ) AS TransactionCurrency,
  JournalEntry.AdditionalCurrency1 AS AdditionalCurrency1,
  JournalEntry.AdditionalCurrency2 AS AdditionalCurrency2
FROM I_JournalEntry AS JournalEntry
LEFT OUTER JOIN P_AR_ConversionFactors AS _ConversionFactor ON _ConversionFactor.ExchangeRateType = ExchangeRateType AND _ConversionFactor.SourceCurrency = TransactionCurrency AND _ConversionFactor.TargetCurrency = CompanyCodeCurrency AND _ConversionFactor.ValidityStartDate <= PostingDate AND _ConversionFactor.ValidityEndDate >= PostingDate  -- association [0..1]
LEFT OUTER JOIN I_OneTimeAccountBP AS _OneTimeAccountBP ON JournalEntry.CompanyCode = _OneTimeAccountBP.CompanyCode AND JournalEntry.FiscalYear = _OneTimeAccountBP.FiscalYear AND JournalEntry.AccountingDocument = _OneTimeAccountBP.AccountingDocument  -- association [0..*]
;