C_CmplRqRsltExpsrLmtCompTP

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_CmplRqRsltExpsrLmtCompTP.
-- 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: CCRROELCOMPTP

CREATE VIEW C_CmplRqRsltExpsrLmtCompTP AS
SELECT
  OccptlExpsrLmtCompUUID,
  OccptlExpsrLmtUUID,
  CmplRqRsltUUID,
  _OccptlExpsrLmtLstdSubstEnhcd.ListedSubstance AS ListedSubstance,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  CmplRqVersUUID,
  _OccptlExpsrLmtLstdSubstEnhcd.OccptlExpsrLmtQuantity AS OccptlExpsrLmtQuantity,
  _OccptlExpsrLmtLstdSubstEnhcd.OccptlExpsrLmtValueUoM AS OccptlExpsrLmtValueUoM,
  cast ('' as ehfnd_limit_combined) AS OccptlExpsrLmtValueCmbndText,
  _OccptlExpsrLmtLstdSubstEnhcd.OccptlExpsrLmtValueTypeText AS OccptlExpsrLmtValueTypeText,
  _OccptlExpsrLmtLstdSubstEnhcd.OccptlExpsrLmtTypeText AS OccptlExpsrLmtTypeText,
  _OccptlExpsrLmtLstdSubstEnhcd.CmRqVsOELMeasuredAs AS CmRqVsOELMeasuredAs,
  _OccptlExpsrLmtLstdSubstEnhcd.CmRqVsOELFormOfExposure AS CmRqVsOELFormOfExposure,
  _OccptlExpsrLmtLstdSubstEnhcd.CmRqVsOELPeakLmtExcursionFctr AS CmRqVsOELPeakLmtExcursionFctr,
  _OccptlExpsrLmtLstdSubstEnhcd.CmRqVsOELExcursionFctrCat AS CmRqVsOELExcursionFctrCat,
  _OccptlExpsrLmtLstdSubstEnhcd.CmRqVsOELMomentaryConcnValue AS CmRqVsOELMomentaryConcnValue,
  cast ('' as ehfnd_oel_list_of_notatext ) AS CmRqVsOELSetOfNotationText,
  cast ( _OccptlExpsrLmtLstdSubstEnhcd._CmplRqVersSubstanceList._Text[1: Language = $session.system_language].SubstanceListName as ehfnd_oel_subst_list preserving type ) AS SubstanceList,
  _OccptlExpsrLmtLstdSubstEnhcd.CASNumber AS CASNumber,
  SubstanceUUID,
  cast( '' as ehfnd_sub_substance_name_ltd ) AS SubstanceName,
  _OccptlExpsrLmtLstdSubstEnhcd.ListedSubstanceCndn AS ListedSubstanceCndn,
  cast ( _OccptlExpsrLmtLstdSubstEnhcd._SubstanceCndnText.ListedSubstanceCndnName as ehfnd_lisu_cndn_name preserving type ) AS ListedSubstanceCndnName
FROM I_CmplRqRsltExpsrLmtCompTP AS CmplRqRsltExpsrLmtComp
LEFT OUTER JOIN C_CmplRqRsltOccptlExpsrLmtTP AS _CmplRqRsltOccptlExpsrLmt ON CmplRqRsltUUID = _CmplRqRsltOccptlExpsrLmt.CmplRqRsltUUID  -- association [1..1]
LEFT OUTER JOIN C_CmplRqRsltExpsrLmtCompRatgTP AS _CmplRqRsltExpsrLmtCompRatg ON OccptlExpsrLmtCompUUID = _CmplRqRsltExpsrLmtCompRatg.PCPrptyParentUUID  -- association [0..*]
LEFT OUTER JOIN I_OccptlExpsrLmtLstdSubstEnhcd AS _OccptlExpsrLmtLstdSubstEnhcd ON CmplRqRsltExpsrLmtComp.OccptlExpsrLmtUUID = _OccptlExpsrLmtLstdSubstEnhcd.OccptlExpsrLmtUUID  -- association [0..1]
;