I_MngCollStrgyCollStrategy

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_MngCollStrgyCollStrategy.
-- 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: IMNGCOLLSTRGY

CREATE VIEW I_MngCollStrgyCollStrategy AS
SELECT
  CollectionStrategy,
  cast(_CollectionsStrategyText[Language = $session.system_language].CollStrgyName as fin_mng_colstr_strategy_text) AS CollStrgyName,
  CollStrgyCurrency,
  CollStrgyMaxValuation,
  CollDuDteCshDiscIsConsidered,
  CollStrgyNmbrDaysBeforeDueDate,
  CollStrgyTolDaysAfterDunn,
  CollItmWthLglDunProcedIsExcl,
  CollStrgyOverduePeriod1,
  CollStrgyOverduePeriod2,
  CollStrgyOverduePeriod3,
  CollStrgyOverduePeriod4,
  CollStrgyDueDatePeriod1,
  CollStrgyDueDatePeriod2,
  CollStrgyDueDatePeriod3,
  CollStrgyDueDatePeriod4,
  CollStrgyCreatedBy,
  CollStrgyCreatedOn,
  CollStrgyLastChangedBy,
  CollStrgyLastChangedOn
FROM I_CollectionsStrategy
LEFT OUTER JOIN P_CollectionStrategyUsage AS _CollectionStrategyUsage ON _CollectionStrategyUsage.CollectionStrategy = CollectionStrategy  -- association [1..1]
LEFT OUTER JOIN I_CollectionStrategyStatusText AS _StatusText ON _StatusText.CollStrgyIsActive = CollStrgyIsActive  -- association [1..*]
LEFT OUTER JOIN P_CollectionStrategyValuation AS _CollectionStrategyValuation ON _CollectionStrategyValuation.CollectionStrategy = CollectionStrategy  -- association [1..1]
;