C_CollectionStrategyTP

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 C_CollectionStrategyTP.
-- 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: CCOLLSTRGYTP

CREATE VIEW C_CollectionStrategyTP AS
SELECT
  CollectionStrategy,
  CollectionStrategyForEdit,
  CollStrgyName,
  CollStrgyCurrency,
  _CurrencyText[1:Language = $session.system_language].CurrencyName AS CurrencyName,
  CollStrgyMaxValuation,
  CollStrgyAutoValuation,
  CollStrgyStsDesc,
  CollStrgyStsCriticality,
  CollDuDteCshDiscIsConsidered,
  CollStrgyNmbrDaysBeforeDueDate,
  CollStrgyTolDaysAfterDunn,
  CollItmWthLglDunProcedIsExcl,
  CollStrgyOverduePeriod1,
  CollStrgyOverduePeriod2,
  CollStrgyOverduePeriod3,
  CollStrgyOverduePeriod4,
  CollStrgyDueDatePeriod1,
  CollStrgyDueDatePeriod2,
  CollStrgyDueDatePeriod3,
  CollStrgyDueDatePeriod4,
  CollStrgyCreatedBy,
  _CreatedByContactCard.FullName AS CreatedByUserName,
  CollStrgyCreatedOn,
  CollStrgyLastChangedBy,
  CollStrgyLastChangedOn
FROM I_CollectionStrategyTP
LEFT OUTER JOIN C_CollRuleToCollStrgyTP AS _CollRuleToCollStrgyTP ON CollectionStrategy = _CollRuleToCollStrgyTP.CollectionStrategy  -- association [1..*]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByContactCard ON CollStrgyCreatedBy = _CreatedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_CurrencyText AS _CurrencyText ON CollStrgyCurrency = _CurrencyText.Currency  -- association [0..*]
;