I_InvmtMgmtSettlmtRuleContext

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_InvmtMgmtSettlmtRuleContext.
-- 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_InvmtMgmtSettlmtRuleContext AS
SELECT
  srp_uuid AS InvmtMgmtSettlmtRulePrpslUUID,
  im_info_uuid AS InvmMgmSettlmtRuleCntxtObjUUID,
  objty AS InvmMgmSettlmtRuleCntxtObjType,
  objid AS InvmMgmSettlmtRuleCntxtObjKey,
  text AS InvmMgmSettlmtRuleCntxtObjText,
  amount AS InvmMgmSettlmtRuleCntxtObjAmt,
  currency AS InvmMgmSettlmtRuleCntxtObjCrcy,
  quantity AS InvmMgmSettlmtRuleCntxtObjQty,
  unit AS InvmMgmSettlmtRuleCntxtObjUnit,
  note AS InvmMgmSettlmtRuleCntxtObjNote,
  objty_ref AS InvmMgmSetlRuleCntxtRefObjType,
  objid_ref AS InvmMgmSetlRuleCntxtRefObjKey
FROM fins_im_srp_info
LEFT OUTER JOIN I_InvmMgmSetlRuleCntxtObjTypeT AS _CntxtObjType ON InvmMgmSettlmtRuleCntxtObjType = _CntxtObjType.InvmMgmSettlmtRuleCntxtObjType AND _CntxtObjType.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_InvmMgmSetlRuleCntxtObjTypeT AS _RefCntxtObjType ON InvmMgmSetlRuleCntxtRefObjType = _RefCntxtObjType.InvmMgmSettlmtRuleCntxtObjType AND _RefCntxtObjType.Language = $session.system_language  -- association [0..1]
;