C_MngEnvrmtCmplRqVers

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_MngEnvrmtCmplRqVers.
-- 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: CMNGENVCMPLREQ

CREATE VIEW C_MngEnvrmtCmplRqVers AS
SELECT
  CmplRqVersUUID,
  CmplRqVers,
  CmplRqUUID,
  ComplianceRequirement,
  CmplRqVersMaintStatus,
  CmplRqType,
  IssuingOrganization,
  IssgOrganizationFreeSearchName,
  cast(ContentProvider as abap.char(30)) AS CmplRqContentProvider,
  cast ('' as abap.char(100)) AS CmplRqContentProviderName,
  EffectiveDate,
  EffectiveDate AS CmplRqVersValidFromDate,
  CmplRqVersValidToDate,
  case when CmplRqVersNameInCurLang is not null and CmplRqVersNameInCurLang is not initial then CmplRqVersNameInCurLang when CmplRqVersEnglishName is not null and CmplRqVersEnglishName is not initial then CmplRqVersEnglishName else _CmplRqVersFallbackText.CmplRqVersName end as CmplRqVersName AS CmplRqVersNameendasCmplRqVersName,
  CmplRqVersNameInCurLang,
  CmplRqVersEnglishName,
  cast('' as ehfnd_country_id) AS Country,
  cast('' as ehfnd_region_id) AS Region,
  cast('' as abap.char(1000)) AS CmplRqVersAppltyAreaString,
  CmplRqVersExpiryDaysValue,
  CmplRqDomain,
  CmplRqVersPermitNumber,
  _CompReqDesc.CmplRqDescription AS CmplRqDescription,
  CmplRqPermitType,
  LastChangeDateTime,
  LastChangedByUser,
  _EHSBusinessUserValueHelp.PersonFullName AS PersonFullName
FROM I_CmplRqVersEnhanced
LEFT OUTER JOIN E_CmplRqVers AS _Extension ON CmplRqVersUUID = _Extension.CmplRqVersUUID  -- association [1..1]
LEFT OUTER JOIN C_EHSBusinessUserValueHelp AS _EHSBusinessUserValueHelp ON LastChangedByUser = _EHSBusinessUserValueHelp.UserID  -- association [1..1]
LEFT OUTER JOIN I_WasteStreamChnlPermitType AS _PermitType ON CmplRqPermitType = _PermitType.WasteStreamChnlPermitType  -- association [0..1]
LEFT OUTER JOIN P_CmplRqVersFallbackText AS _CmplRqVersFallbackText ON CmplRqVersUUID = _CmplRqVersFallbackText.CmplRqVersUUID  -- association [1..1]
;