I_TravelConcurDocToCmtmtDoc

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_TravelConcurDocToCmtmtDoc.
-- 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_TravelConcurDocToCmtmtDoc AS
SELECT
  attr.system_key AS ConcurSystemKey,
  attr.document_type AS ConcurDocumentType,
  attr.document_id AS ConcurDocumentID,
  attr.revision_id AS ConcurDocumentRevisionNumber,
  attr.bukrs AS CompanyCode,
  attr.belnr AS JournalEntry,
  attr.gjahr AS FiscalYear,
  attr.posting_date AS PostingDate,
  doc.document_key AS ConcurDocumentKey,
  cast( attr.system_key as abap.char(10) ) AS ReferenceDocumentLogicalSystem
FROM cte_d_fgm_p_attr AS attr
LEFT OUTER JOIN I_ConcurDocumentType AS _ConcurDocumentType ON ConcurDocumentType = _ConcurDocumentType.ConcurDocumentType  -- association [1..1]
LEFT OUTER JOIN I_GLAccountLineItem AS _CommitmentDocument ON '0E' = _CommitmentDocument.SourceLedger AND CompanyCode = _CommitmentDocument.CompanyCode AND JournalEntry = _CommitmentDocument.AccountingDocument AND FiscalYear = _CommitmentDocument.FiscalYear  -- association [0..*]
LEFT OUTER JOIN I_FundsMgmtCommitmentEntryItem AS _CommitmentEntryItem ON ConcurDocumentKey = _CommitmentEntryItem.ReferenceDocument AND ReferenceDocumentLogicalSystem = _CommitmentEntryItem.ReferenceDocumentLogicalSystem AND '040' = _CommitmentEntryItem.FundsMgmtRefDocumentCategory AND ( ( ConcurDocumentType = 'EO' AND '53' = _CommitmentEntryItem.FundsMgmtValueType AND 'CERO' = _CommitmentEntryItem.ReferenceDocumentType ) OR( ConcurDocumentType = 'TR' AND '52' = _CommitmentEntryItem.FundsMgmtValueType AND 'CTR' = _CommitmentEntryItem.ReferenceDocumentType ) )  -- association [0..*]
;