I_TrsyPosSimulatedValuation

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_TrsyPosSimulatedValuation.
-- 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_TrsyPosSimulatedValuation AS
SELECT
  cast (os_guid as ftr_gen_sim_val_uuid preserving type) AS TrsyPosSmltdValuationUUID,
  key_date AS TrsyPosSmltdValuationKeyDate,
  cast(position_oid as ftr_gen_position_uuid preserving type) AS TreasuryPosition
FROM tsvt_sim_val
LEFT OUTER JOIN I_TreasuryLedgerPosition AS _TreasuryLedgerPosition ON TreasuryPosition = _TreasuryLedgerPosition.TreasuryPosition  -- association [1..1]
LEFT OUTER JOIN I_TreasuryPositionIdentifier AS _PositionIdentifier ON ( TreasuryPosition = _PositionIdentifier.TreasuryPosition AND _PositionIdentifier.TreasuryPositionContext = 'TRL' )  -- association [1..1]
;