I_TreasurySubPosition

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_TreasurySubPosition.
-- 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: ISUBPOS

CREATE VIEW I_TreasurySubPosition AS
SELECT
  os_guid AS TrsySubPosition,
  cast(hinst_oid as ftr_gen_hinst preserving type) AS HedgingInstrumentUUID,
  cast(hitem_oid as ftr_gen_hitem preserving type) AS HedgedItemUUID,
  cast(flg_freestanding as tpm_flg_freestanding preserving type) AS IsFreestanding,
  cast(position_oid as ftr_gen_position_uuid preserving type) AS TreasuryPosition,
  cast(subpos_nom_curr as ftr_gen_des_nominal_currency preserving type) AS DesignatedNominalCurrency
FROM trlt_subposition
LEFT OUTER JOIN I_HedgedItem AS _HedgedItem ON HedgedItemUUID = _HedgedItem.HedgedItemUUID  -- association [0..1]
LEFT OUTER JOIN I_HedgingInstrument AS _HedgingInstrument ON HedgingInstrumentUUID = _HedgingInstrument.HedgingInstrumentUUID  -- association [0..1]
LEFT OUTER JOIN I_HedgingRelationship AS _HedgingRelationship ON HedgingRelationshipUUID = _HedgingRelationship.HedgingRelationshipUUID  -- association [0..1]
LEFT OUTER JOIN I_TreasuryLedgerPosition AS _TrsyLedgerPosition ON TreasuryPosition = _TrsyLedgerPosition.TreasuryPosition  -- association [0..1]
;