P_ManageJournalEntry

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_ManageJournalEntry.
-- 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 P_ManageJournalEntry AS
SELECT
  _JournalEntry.CompanyCode AS CompanyCode,
  _JournalEntry.FiscalYear AS FiscalYear,
  _JournalEntry.AccountingDocument AS AccountingDocument,
  _JournalEntry.AccountingDocumentCategory AS AccountingDocumentCategory,
  _JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  _JournalEntry.SenderAccountingDocument AS SenderAccountingDocument,
  _JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  _JournalEntry.AdditionalCurrency1 AS AdditionalCurrency1,
  _JournalEntry.AdditionalCurrency1Role AS AdditionalCurrency1Role,
  _JournalEntry.AdditionalCurrency2 AS AdditionalCurrency2,
  _JournalEntry.AdditionalCurrency2Role AS AdditionalCurrency2Role,
  _JournalEntry.AlternativeReferenceDocument AS AlternativeReferenceDocument,
  _JournalEntry.Branch AS Branch,
  _JournalEntry.BusinessTransactionType AS BusinessTransactionType,
  _JournalEntry.CompanyCodeCurrency AS CompanyCodeCurrency,
  _JournalEntry.SenderCompanyCode AS SenderCompanyCode,
  _JournalEntry.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _JournalEntry.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  _JournalEntry.CreationTime AS CreationTime,
  _JournalEntry.DocumentDate AS DocumentDate,
  _JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  _JournalEntry.AbsoluteExchangeRate AS AbsoluteExchangeRate,
  cast(_JournalEntry.ExchangeRateDate as fin_currconvdat preserving type ) AS ExchangeRateDate,
  _JournalEntry.TaxAbsoluteExchangeRate AS TaxAbsoluteExchangeRate,
  _JournalEntry.CtryCrcyTxAbsoluteExchangeRate AS CtryCrcyTxAbsoluteExchangeRate,
  _JournalEntry.MarketDataAbsoluteExchangeRate AS MarketDataAbsoluteExchangeRate,
  _JournalEntry.TaxCountry AS TaxCountry,
  _JournalEntry.ExchangeRateType AS ExchangeRateType,
  _JournalEntry.FiscalPeriod AS FiscalPeriod,
  _JournalEntry.SenderFiscalYear AS SenderFiscalYear,
  _JournalEntry.JrnlEntryCntrySpecificRef1 AS JrnlEntryCntrySpecificRef1,
  _JournalEntry.JrnlEntryCntrySpecificDate1 AS JrnlEntryCntrySpecificDate1,
  _JournalEntry.JrnlEntryCntrySpecificRef2 AS JrnlEntryCntrySpecificRef2,
  _JournalEntry.JrnlEntryCntrySpecificDate2 AS JrnlEntryCntrySpecificDate2,
  _JournalEntry.JrnlEntryCntrySpecificRef3 AS JrnlEntryCntrySpecificRef3,
  _JournalEntry.JrnlEntryCntrySpecificDate3 AS JrnlEntryCntrySpecificDate3,
  _JournalEntry.JrnlEntryCntrySpecificRef4 AS JrnlEntryCntrySpecificRef4,
  _JournalEntry.JrnlEntryCntrySpecificDate4 AS JrnlEntryCntrySpecificDate4,
  _JournalEntry.JrnlEntryCntrySpecificRef5 AS JrnlEntryCntrySpecificRef5,
  _JournalEntry.JrnlEntryCntrySpecificDate5 AS JrnlEntryCntrySpecificDate5,
  _JournalEntry.JrnlEntryCntrySpecificBP1 AS JrnlEntryCntrySpecificBP1,
  _JournalEntry.JrnlEntryCntrySpecificBP2 AS JrnlEntryCntrySpecificBP2,
  cast(_JournalEntry.IntercompanyTransaction as fac_mje_bvorg preserving type ) AS IntercompanyTransaction,
  _JournalEntry.InvoiceReceiptDate AS InvoiceReceiptDate,
  _JournalEntry.LastManualChangeDate AS LastManualChangeDate,
  _JournalEntry.LastAutomaticChangeDate AS LastAutomaticChangeDate,
  _JournalEntry.Ledger AS Ledger,
  _JournalEntry.LedgerGroup AS LedgerGroup,
  _JournalEntry.SenderLogicalSystem AS SenderLogicalSystem,
  _JournalEntry.NmbrOfPages AS NmbrOfPages,
  cast(_JournalEntry.OriginalReferenceDocument as fis_awkey) AS OriginalReferenceDocument,
  _JournalEntry.ParkingTime AS ParkingTime,
  _JournalEntry.ParkedByUser AS ParkedByUser,
  _JournalEntry.ParkingDate AS ParkingDate,
  cast( dats_tims_to_tstmp( _JournalEntry.ParkingDate, _JournalEntry.ParkingTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as timestamp) as ParkingDateTime AS clientNULLastimestampasParkingDateTime,
  _JournalEntry.PostingDate AS PostingDate,
  _JournalEntry.RecurringAccountingDocument AS RecurringAccountingDocument,
  _JournalEntry.Reference1InDocumentHeader AS Reference1InDocumentHeader,
  _JournalEntry.Reference2InDocumentHeader AS Reference2InDocumentHeader,
  _JournalEntry.ReferenceDocumentType AS ReferenceDocumentType,
  _JournalEntry.ReversalReason AS ReversalReason,
  _JournalEntry.IsReversal AS IsReversal,
  _JournalEntry.IsReversed AS IsReversed,
  _JournalEntry.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  _JournalEntry.PlannedReversalDate AS PlannedReversalDate,
  _JournalEntry.TaxBaseAmountIsNetAmount AS TaxBaseAmountIsNetAmount,
  cast(_JournalEntry.TaxFulfillmentDate as txrg_fulfilldate_lbl preserving type ) AS TaxFulfillmentDate,
  _JournalEntry.TaxIsCalculatedAutomatically AS TaxIsCalculatedAutomatically,
  _JournalEntry.TaxReportingDate AS TaxReportingDate,
  cast(_JournalEntry.WithholdingTaxReportingDate as fac_mje_whtdate preserving type ) AS WithholdingTaxReportingDate,
  _JournalEntry.TransactionCode AS TransactionCode,
  cast( _JournalEntry.TransactionCurrency as fis_rwcur ) AS TransactionCurrency,
  _JournalEntry.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  _JournalEntry.JournalEntryLastChangeDateTime AS JournalEntryLastChangeDateTime,
  replace(replace(concat( $session.client, concat( rpad(_JournalEntry.CompanyCode, 4, '|'), concat( _JournalEntry.AccountingDocument, _JournalEntry.FiscalYear))), '|', '| |'), '|', '') as ChangeDocObject AS FiscalYearasChangeDocObject
FROM I_JournalEntry AS _JournalEntry
;