P_RO_SAFTJournalEntry

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_RO_SAFTJournalEntry.
-- 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: PROSAFTJRNLENTRY
-- Parameters: P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag, P_VATRegistration : stceg

CREATE VIEW P_RO_SAFTJournalEntry AS
SELECT
  Item.StatryRptCategory AS StatryRptCategory,
  Item.StatryRptgEntity AS StatryRptgEntity,
  Item.StatryRptRunID AS StatryRptRunID,
  Item.SourceLedger AS SourceLedger,
  Item.CompanyCode AS CompanyCode,
  Item.FiscalYear AS FiscalYear,
  Item.AccountingDocument AS AccountingDocument,
  Item.Ledger AS Ledger,
  Item.AccountingDocumentType AS AccountingDocumentType,
  Item.RO_SAFTJournalTransDescription AS RO_SAFTJournalTransDescription,
  Item.RO_SAFTJournalTransaction AS RO_SAFTJournalTransaction,
  Item.RO_SAFTJournalTransactionType AS RO_SAFTJournalTransactionType,
  Item.RO_SAFTSourceDocument AS RO_SAFTSourceDocument,
  Item.PostingDate AS PostingDate,
  Item.DocumentDate AS DocumentDate,
  Item.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  Item.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  max(Item.CustomerTaxID5) AS CustomerTaxID5,
  max(Item.SupplierTaxID5) AS SupplierTaxID5,
  max(Item.TransactionCode) AS TransactionCode
FROM P_RO_SAFTJournalEntryItem
;