I_TreasuryReferenceItem

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_TreasuryReferenceItem.
-- 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_TreasuryReferenceItem AS
SELECT
  cast( reftyp as trsy_ref_cat preserving type ) AS TreasuryReferenceCategory,
  cast( refnr as trsy_ref_nmbr preserving type ) AS TreasuryReferenceNumber,
  objnr AS TreasuryFinancialObject,
  cast( status as trsy_ref_item_status preserving type ) AS TreasuryReferenceItemStatus,
  cast( rrang as trsy_ref_item_ranking preserving type ) AS TreasuryReferenceItemRanking,
  cast( cruser as trsy_ref_item_cruser preserving type ) AS TrsyReferenceItemCreatedByUser,
  cast( dcrdat as trsy_ref_item_dcrdat preserving type ) AS TrsyReferenceItemCreationDate,
  cast( tcrtim as trsy_ref_item_tcrtim preserving type ) AS TrsyReferenceItemCreationTime,
  cast( upuser as trsy_ref_item_upuser preserving type ) AS TrsyRefItemLastChangedByUser,
  cast( dupdat as trsy_ref_item_dupdat preserving type ) AS TrsyRefItemLastChangeDate,
  cast( tuptim as trsy_ref_item_tuptim preserving type ) AS TrsyRefItemLastChangeTime,
  _TreasuryReference.TreasuryReferenceStatus AS TreasuryReferenceStatus
FROM refon
LEFT OUTER JOIN I_FinancialTransaction AS _FinancialTransaction ON TreasuryFinancialObject = _FinancialTransaction.TreasuryFinancialObject  -- association [0..1]
LEFT OUTER JOIN I_TreasuryReferenceCategory AS _TreasuryReferenceCategory ON TreasuryReferenceCategory = _TreasuryReferenceCategory.TreasuryReferenceCategory  -- association [1..1]
LEFT OUTER JOIN I_TreasuryReference AS _TreasuryReference ON TreasuryReferenceCategory = _TreasuryReference.TreasuryReferenceCategory AND TreasuryReferenceNumber = _TreasuryReference.TreasuryReferenceNumber  -- association [1..1]
;