C_EHSMyPermitsTP

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_EHSMyPermitsTP.
-- 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.

CREATE VIEW C_EHSMyPermitsTP AS
SELECT
  CmplRqVersUUID,
  CmplRqVersID,
  CmplRqVersCentralID,
  CmplRqUUID,
  CmplRqVersNameInCurLang,
  CmplRqVersEnglishName,
  CmplRqVersName,
  CmplRqDescription,
  _DescNode[1:Language = $session.system_language].CmplRqDescription AS EHSCmplRqDescriptionText,
  ComplianceRequirement,
  CmplRqVersPermitNumber,
  CmplRqVersMaintStatus,
  EHSLocationUUID,
  CmplRqDomain,
  CmplRqDomainText,
  CmplRqType,
  CmplRqPermitType,
  cast('' as abap.char( 10 ) ) AS WasteStreamChnlPermitType,
  _PermitType.WasteStreamChnlPermitTypeName AS WasteStreamChnlPermitTypeName,
  cast( BusinessPartner as bu_partner preserving type ) AS BusinessPartner,
  cast('' as text1024 ) AS EHSLocationURL,
  _IssuingAuthorityBP.BusinessPartnerName AS IssuingAuthorityName,
  IssuingOrganization,
  EHSCmplRqPermitLifecycle,
  EffectiveDate,
  CmplRqVersValidToDate,
  cast( 1 as abap.int1) AS CmplRqVersValidityCritlty,
  EHSLocationName,
  _CmplRqPermitLifecycleText.EHSCmplRqPermitLifecycleName AS EHSCmplRqPermitLifecycleName,
  cast('' as abap.char(1000)) AS CmplRqVersAppltyAreaString,
  EHSLocationIsAssigned,
  '' AS EHSMyPermitWasteDataIsHidden,
  '' AS UICT_PermitTypeIsReadOnly,
  EnvrmtWastePartDsplFcltyUUID,
  _WasteData.EnvrmtWastePartFcltyName AS EnvrmtWastePartFcltyName,
  EnvrmtWastePartnerUUID,
  EnvrmtWasteCodeUUID,
  _WasteData.EnvrmtWasteCode AS EnvrmtWasteCode,
  _WasteData.EnvrmtWasteCodeDescription AS EnvrmtWasteCodeDescription,
  Country,
  Region,
  _MainValAreaNode.CountryName AS CountryName,
  _MainValAreaNode.RegionName AS RegionName,
  CreatedByUser
FROM I_EHSCmplRqPermitTP
LEFT OUTER JOIN E_CmplRqVers AS _Extension ON CmplRqVersUUID = _Extension.CmplRqVersUUID  -- association [1..1]
LEFT OUTER JOIN I_LocationDescFallbackLang AS _LocTextDesc ON EHSLocationUUID = _LocTextDesc.EHSLocationUUID  -- association [1..1]
LEFT OUTER JOIN I_CmplncRqmtStatus AS _CmplncRqmtStatus ON CmplRqVersMaintStatus = _CmplncRqmtStatus.CmplRqStatus  -- association [0..1]
LEFT OUTER JOIN I_CmplncRqmtType AS _CmplncRqmtType ON CmplRqType = _CmplncRqmtType.CmplRqType  -- association [0..1]
LEFT OUTER JOIN I_CmplRqDomain AS _CmplRqDomain ON CmplRqDomain = _CmplRqDomain.CmplRqDomain  -- association [0..1]
LEFT OUTER JOIN I_CmplRqPermitLifecycleText AS _CmplRqPermitLifecycleText ON EHSCmplRqPermitLifecycle = _CmplRqPermitLifecycleText.EHSCmplRqPermitLifecycle AND _CmplRqPermitLifecycleText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _IssuingAuthorityBP ON BusinessPartner = _IssuingAuthorityBP.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_EHSCmplRqPermitDescTP AS _DescNode ON CmplRqVersUUID = _DescNode.CmplRqVersUUID  -- association [0..*]
LEFT OUTER JOIN C_EHSCmplRqPmtAppltyAreaTP AS _ValAreaNode ON CmplRqVersUUID = _ValAreaNode.CmplRqVersUUID  -- association [0..1]
LEFT OUTER JOIN C_EHSCmplRqPmtAppltyAreaTP AS _MainValAreaNode ON CmplRqVersUUID = _MainValAreaNode.CmplRqVersUUID AND _MainValAreaNode.EHSLocationIsCopied = 'X'  -- association [0..1]
LEFT OUTER JOIN C_EHSCmplRqPmtIssgOrgTP AS _IssOrg ON CmplRqVersUUID = _IssOrg.CmplRqVersUUID  -- association [0..*]
LEFT OUTER JOIN C_EHSCmplRqPermitNameTP AS _NameNode ON CmplRqVersUUID = _NameNode.CmplRqVersUUID  -- association [0..*]
LEFT OUTER JOIN C_EHSCmplRqPmtWasteDataTP AS _WasteData ON CmplRqVersUUID = _WasteData.CmplRqVersUUID  -- association [0..1]
LEFT OUTER JOIN I_WasteStreamChnlPermitType AS _PermitType ON CmplRqPermitType = _PermitType.WasteStreamChnlPermitType  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUserText ON CreatedByUser = _CreatedByUserText.UserID  -- association [0..1]
;