I_EHSCmplRqPermit

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_EHSCmplRqPermit.
-- 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 I_EHSCmplRqPermit AS
SELECT
  CmplRqVersUUID,
  CmplRqVersID,
  CmplRqVersCentralID,
  title AS CmplRqVersName,
  cast(creationdatetime as ehfnd_datetime_cr preserving type) AS CreationDateTime,
  CreatedByUser,
  cast(lastchangedatetime as ehfnd_datetime_ch preserving type ) AS LastChangeDateTime,
  LastChangedByUser,
  cast(businesspartner as bu_partner preserving type ) AS BusinessPartner,
  ComplianceRequirement,
  cast(cmplrqversmaintstatus as ehfnd_req_status_nce preserving type ) AS CmplRqVersMaintStatus,
  cast(cmplrqtype as ehfnd_req_type_nce preserving type ) AS CmplRqType,
  cast( ehscmplrqpermitlifecycle as ehenv_pmt_lfcyc_id preserving type ) AS EHSCmplRqPermitLifecycle,
  CmplRqPattern,
  IssuingOrganization,
  cast(ehslocationuuid as ehfnd_location_uuid_ref preserving type ) AS EHSLocationUUID,
  cast(contentprovider as abap.char( 30 )) AS ContentProvider,
  CmplRqVersValidToDate,
  CmplRqApplicationComponent,
  CmplRqSourceURL,
  TransitionPeriodEndDate,
  CmplRqIsInitiallyPrvddBySAP,
  CmplRqVersDocumentationObject,
  CmplRqVersPermitNumber,
  cast(cmplrqdomain as ehfnd_req_domain_nce preserving type ) AS CmplRqDomain,
  EffectiveDate,
  CmplRqUUID,
  EHSCmplRqPmtNotifIsSent,
  EHSCmplRqPmtSetForRnwlOnDate,
  CmplRqVersChangeLog,
  cast(cmplrqpermittype as abap.char( 10 ) ) AS CmplRqPermitType,
  CmplRqIsCreatedFromDocument
FROM ehfndv_per_root
LEFT OUTER JOIN I_EHSCmplRqPermitDesc AS _DescNode ON CmplRqVersUUID = _DescNode.CmplRqVersUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSCmplRqPmtAppltyArea AS _ValAreaNode ON CmplRqVersUUID = _ValAreaNode.CmplRqVersUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSCmplRqPmtCntntStruc AS _ContentStructureNode ON CmplRqVersUUID = _ContentStructureNode.CmplRqVersUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSCmplRqPermitName AS _NameNode ON CmplRqVersUUID = _NameNode.CmplRqVersUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSCmplRqPmtIssgOrg AS _IssOrg ON CmplRqVersUUID = _IssOrg.CmplRqVersUUID  -- association [0..*]
LEFT OUTER JOIN I_CmplRqPermitLifecycleText AS _PermitLifecycleText ON EHSCmplRqPermitLifecycle = _PermitLifecycleText.EHSCmplRqPermitLifecycle AND _PermitLifecycleText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_EHSLocationRevisionBasic AS _LocRevision ON EHSLocationUUID = _LocRevision.EHSLocationUUID AND _LocRevision.RevisionStartDate <= $session.system_date AND _LocRevision.RevisionEndDate >= $session.system_date  -- association [1..1]
;