C_MngJrnlEntrReltdJournalEntry

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 C_MngJrnlEntrReltdJournalEntry.
-- 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 C_MngJrnlEntrReltdJournalEntry AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  cast(_CompanyCode.CompanyCodeName as fis_butxt preserving type) AS CompanyCodeName,
  AccountingDocumentCategory,
  cast(_AccountingDocumentCategoryT.AccountingDocumentCategoryName as fis_bstat_name preserving type ) AS AccountingDocumentCategoryName,
  AccountingDocumentHeaderText,
  AccountingDocumentType,
  _AccountingDocumentTypeText.AccountingDocumentTypeName AS AccountingDocumentTypeName,
  BusinessTransactionType,
  _BusinessTransactionTypeText.BusinessTransactionTypeName AS BusinessTransactionTypeName,
  AccountingDocumentCreationDate,
  DocumentDate,
  ExchangeRateDate,
  FiscalPeriod,
  IntercompanyTransaction,
  Ledger,
  LedgerGroup,
  cast(OriginalReferenceDocument as fis_awkey) AS OriginalReferenceDocument,
  PostingDate,
  ReferenceDocumentType,
  cast(_ReferenceDocumentTypeText.ReferenceDocumentTypeName as fac_text_typ preserving type) AS ReferenceDocumentTypeName
FROM I_JournalEntry AS _JournalEntry
LEFT OUTER JOIN I_ReferenceDocumentTypeText AS _ReferenceDocumentTypeText ON ReferenceDocumentType = _ReferenceDocumentTypeText.ReferenceDocumentType AND _ReferenceDocumentTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentCategoryT AS _AccountingDocumentCategoryT ON AccountingDocumentCategory = _AccountingDocumentCategoryT.AccountingDocumentCategory AND _AccountingDocumentCategoryT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingDocumentTypeText ON AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType AND _AccountingDocumentTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusTransactionTypeText AS _BusinessTransactionTypeText ON BusinessTransactionType = _BusinessTransactionTypeText.BusinessTransactionType AND _BusinessTransactionTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
;