Deprecated
This CDS view is deprecated in S/4HANA. Use I_SftyRlvtChgAffcdObjUser_2 instead. View all deprecated CDS views →

I_SftyRlvtChgAffcdObjUser

DDL: I_SFTYRLVTCHGAFFCDOBJUSER Type: view COMPOSITE Package: EHHSS_BO_SRC

SRC: Relevant Affected Objects for Users

I_SftyRlvtChgAffcdObjUser is a Composite CDS View that provides data about "SRC: Relevant Affected Objects for Users" in SAP S/4HANA. It reads from 9 data sources and exposes 1 field with key field SafetyRelevantChgAffcdObjUUID. Part of development package EHHSS_BO_SRC.

Data Sources (9)

SourceAliasJoin Type
I_ProcCtrlChemicalBasicInfo BasicInfo left_outer
I_ChemicalApproval ChemicalApproval left_outer
I_ChemicalApprovalRole ChemicalApprovalRole left_outer
I_EHSLocationResponsible HSI_Responsible left_outer
I_HzdsSubstInventory Inventory left_outer
I_EHSRiskAssessment RiskAssessment left_outer
I_EHSRiskAssessmentTeam RiskAssessmentTeam left_outer
I_SafetyInstruction SafetyInstruction left_outer
I_EHSLocationResponsible SI_Responsible left_outer

Annotations (12)

NameValueLevelField
EndUserText.label SRC: Relevant Affected Objects for Users view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IEHSSRCOBJUSR view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_SftyRlvtChgAffcdObjUser_2 view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY SafetyRelevantChgAffcdObjUUID SafetyRelevantChgAffcdObjUUID NodeID

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_SftyRlvtChgAffcdObjUser.
-- 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_SftyRlvtChgAffcdObjUser AS
SELECT
  SafetyRelevantChgAffcdObjUUID
LEFT OUTER JOIN I_HzdsSubstInventory AS Inventory ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EHSLocationResponsible AS HSI_Responsible ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SafetyInstruction AS SafetyInstruction ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EHSLocationResponsible AS SI_Responsible ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChemicalApproval AS ChemicalApproval ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChemicalApprovalRole AS ChemicalApprovalRole ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProcCtrlChemicalBasicInfo AS BasicInfo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EHSRiskAssessment AS RiskAssessment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EHSRiskAssessmentTeam AS RiskAssessmentTeam ON /* join condition not captured in parsed metadata */
;