I_SuplrEvalUsrDfndCriteriaTP

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_SuplrEvalUsrDfndCriteriaTP.
-- 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: IMMPURUSRCRTTX

CREATE VIEW I_SuplrEvalUsrDfndCriteriaTP AS
SELECT
  SuplrEvalUsrDfndCritraUUID,
  Supplier,
  MaterialGroup,
  PurchasingCategory,
  SuplrEvalUserDefinedCriteria,
  ValidFrom,
  ValidTo,
  SuplrEvalUsrDfndCritraCrtedBy,
  SuplrEvalUserDfndCritraCrtnDte,
  SuplrEvalUsrDfndCritraChgdBy,
  SuplrEvalUserDfndCritraChgDate,
  TotNmbrOfSuplrUsrDfndCritra,
  IsDeleted,
  Comments,
  SupplierAccountGroup
FROM I_SuplrEvalUserDfndCriteriaCt AS _userDefCriteriaScore
LEFT OUTER JOIN I_SuplrEvalUserDefinedCriteria AS _SuplrEvalUserDfndCriteria ON SuplrEvalUserDefinedCriteria = _userDefCriteriaScore.SuplrEvalUserDefinedCriteria  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_SuplrEvalUsrDfndCritraStatus AS _StatusVH ON IsDeleted = _StatusVH.SuplrEvalUsrDfndCritraIsDeltd AND _StatusVH.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedBy ON SuplrEvalUsrDfndCritraCrtedBy = _CreatedBy.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedBy ON SuplrEvalUsrDfndCritraChgdBy = _LastChangedBy.UserID  -- association [1..1]
LEFT OUTER JOIN I_MaterialGroup AS _MatGroup ON MaterialGroup != '' AND MaterialGroup = _MatGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_PurchasingCategory AS _PurchasingCategory ON PurchasingCategory != '' AND PurchasingCategory = _PurchasingCategory.PurchasingCategory  -- association [1..1]
;