I_EHSCmplRqParagraphCube

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_EHSCmplRqParagraphCube.
-- 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.
-- Parameters: P_Date : sydatum, P_Language : sylangu

CREATE VIEW I_EHSCmplRqParagraphCube AS
SELECT
  _ContentStructureNode.CmplRqVersChildUUID AS CmplRqVersChildUUID,
  _EHSLocationForFiltering(P_Date: $parameters.P_Date).EHSParentLocationUUID AS EHSMainLocationUUID,
  _ContentStructureNode._CmplRqClassifier.EHSLocClassifierRefUUID AS EHSLocClassifierRefUUID,
  _CmplRqVers.CmplRqVersUUID AS CmplRqVersUUID,
  _CmplRqVers._CmplRqVersAppltyArea.CmplRqVersAppltyAreaUUID AS CmplRqVersAppltyAreaUUID,
  _EHSLocationForFiltering(P_Date: $parameters.P_Date).EHSParentLocationID AS EHSMainLocationID,
  _ContentStructureNode._CmplRqClassifier._EHSLocClassifier._EHSClassifierRoot.EHSLocClassifierID AS EHSLocClassifierID,
  cast(left( _ContentStructureNode.CmplRqVersParagraphName, 250 ) as ehfnd_req_paragraph_short preserving type ) AS CmplRqVersParagraphName,
  _ContentStructureNode.CmplRqVersParagraphID AS CmplRqVersParagraphID,
  _ContentStructureNode.CmplRqAmendmentDate AS CmplRqAmendmentDate,
  cast(left( _ContentStructureNode.CmplRqContentName, 250 )as ehfnd_req_content_name_sort preserving type ) AS CmplRqContentName,
  cast(left(_ContentStructureNode.CmplRqLegalTextName, 250 ) as ehfnd_req_legal_link_text_shrt preserving type ) AS CmplRqLegalTextName,
  _ContentStructureNode.CmplRqVersParagraphType AS CmplRqVersParagraphType,
  cast(left(_EHSLocClassifiers(P_Mandt: $session.client, P_Langu: $parameters.P_Language).Classifiers, 250) as ehfnd_loc_clsf_text_short preserving type ) AS EHSLocClassifiersText,
  cast(left(_CmplRqVers.CmplRqVersName, 250) as ehfnd_crr_name_short preserving type) AS CmplRqVersName,
  cast( _CmplRqVers.CmplRqDomain as ehfnd_req_domain_nce preserving type ) AS CmplRqDomain,
  _CmplRqVers._CmplRqDomain._Text[1: Language = $parameters.P_Language].CmplRqDomainText AS CmplRqDomainText,
  _CmplRqVers.IssuingOrganization AS IssuingOrganization,
  cast( _EHSCmplRqPermit.BusinessPartner as bu_partner preserving type ) AS BusinessPartner,
  _CmplRqVers.EffectiveDate AS EffectiveDate,
  _CmplRqVers.CmplRqVersValidToDate AS CmplRqVersValidToDate,
  cast(substring(_CmplRqVers.EffectiveDate,1,4) as ehfnd_year_code ) AS CmplRqVersValidFromYear,
  cast(substring(_CmplRqVers.CmplRqVersValidToDate,1,4) as ehfnd_year_code ) AS CmplRqVersValidToYear,
  _CmplRqVers.CmplRqVersMaintStatus AS CmplRqVersMaintStatus,
  _CmplRqVers.CmplRqType AS CmplRqType,
  _CmplRqVers._CmplncRqmtType._Text[1: Language = $parameters.P_Language].CmplRqTypeName AS CmplRqTypeName,
  _CmplRqVers.CmplRqApplicationComponent AS CmplRqApplicationComponent,
  _CmplRqVers.CmplRqVersEHSLocationUUID AS CmplRqVersEHSLocationUUID,
  _EHSLocationRoot.EHSLocationID AS EHSLocationID,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._EHSLocationRevisionName[1: Language = $parameters.P_Language].EHSLocationName AS EHSLocationName,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].EHSLocationType AS EHSLocationType,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._EHSLocationType._Text[1: Language = $parameters.P_Language].EHSLocationTypeText AS EHSLocationTypeText,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].EHSLocationStatus AS EHSLocationStatus,
  cast( _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].EHSLocationAuthorizationGroup as ehfnd_loc_auth_group_nc preserving type ) AS EHSLocationAuthorizationGroup,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].Plant AS Plant,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].CostCenter AS CostCenter,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].CompanyCode AS CompanyCode,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].BusinessArea AS BusinessArea,
  _CmplRqVers.ContentProvider AS ContentProvider,
  _CmplRqVers._CmplRqVersAppltyArea.Country AS Country,
  _CmplRqVers._CmplRqVersAppltyArea._CountryText[1: Language = $parameters.P_Language ].CountryName AS CountryName,
  _CmplRqVers._CmplRqVersAppltyArea.Region AS Region,
  _CmplRqVers._CmplRqVersAppltyArea._RegionText[1: Language = $parameters.P_Language ].RegionName AS RegionName,
  _CmplRqVers.CmplRqVersPermitNumber AS CmplRqVersPermitNumber,
  _EHSCmplRqPermit.EHSCmplRqPermitLifecycle AS EHSCmplRqPermitLifecycle,
  _EHSCmplRqPermit._PermitLifecycleText[1: Language = $parameters.P_Language].EHSCmplRqPermitLifecycleName AS EHSCmplRqPermitLifecycleName,
  _CmplRqVers.ComplianceRequirement AS ComplianceRequirement,
  0 AS NumberOfRecords
FROM I_CmplRqVersEnhanced AS _CmplRqVers
LEFT OUTER JOIN I_EHSLocationRevision AS _EHSLocation ON CmplRqVersEHSLocationUUID = _EHSLocation.EHSLocationUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSLocationRoot AS _EHSLocationRoot ON CmplRqVersEHSLocationUUID = _EHSLocationRoot.EHSLocationUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSLocationForFiltering AS _EHSLocationForFiltering ON CmplRqVersEHSLocationUUID = _EHSLocationForFiltering.EHSLocationUUID  -- association [0..*]
LEFT OUTER JOIN P_EHSLOCCLASSIFIERS AS _EHSLocClassifiers ON CmplRqVersEHSLocationUUID = _EHSLocClassifiers.EHSLocationUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSCmplRqPermit AS _EHSCmplRqPermit ON CmplRqVersUUID = _EHSCmplRqPermit.CmplRqVersUUID  -- association [1..1]
LEFT OUTER JOIN I_EHSCmplRqPmtCntntStruc AS _ContentStructureNode ON CmplRqVersUUID = _ContentStructureNode.CmplRqVersUUID  -- association [1..*]
;