I_CmplRqVersRgtyListItmName

DDL: I_CMPLRQVERSRGTYLISTITMNAME Type: view COMPOSITE Package: EHFND_BO_COMPLIANCE_REQ
5 Fields 1 Data Sources 3 Associations

Regulatory list specific name of listed substances

I_CmplRqVersRgtyListItmName is a Composite CDS View that provides data about "Regulatory list specific name of listed substances" in SAP S/4HANA. It reads from 1 data source (I_CmplRqVersThldListItm) and exposes 5 fields with key fields ListedSubstance, SubstanceListUUID, SubstanceListItmUUID. It has 3 associations to related views. Part of development package EHFND_BO_COMPLIANCE_REQ.

Data Sources (1)

SourceAliasJoin Type
I_CmplRqVersThldListItm _ListItem from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_CmplRqVersListItmDfltName _NameOnList $projection.SubstanceListUUID = _NameOnList.SubstanceListUUID and $projection.ListedSubstance = _NameOnList.ListedSubstance and _NameOnList.Language = $session.system_language
[0..1] I_ListedSubstanceDefaultName _DefaultName $projection.ListedSubstance = _DefaultName.ListedSubstance --
[1..1] ehfndv_lisu_rt _ListedSubstanceHead $projection.ListedSubstance = _ListedSubstanceHead.listedsubstance

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICRVRLITMNAME view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Regulatory list specific name of listed substances view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey ListedSubstance view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ListedSubstance I_CmplRqVersThldListItm ListedSubstance Listed Substance
KEY SubstanceListUUID I_CmplRqVersThldListItm SubstanceListUUID Substance List
KEY SubstanceListItmUUID I_CmplRqVersThldListItm SubstanceListItmUUID UUID
ListedSubstanceCndn _ListedSubstanceHead ListedSubstanceCndn
SubstanceListItmAddlInfo I_CmplRqVersThldListItm SubstanceListItmAddlInfo Description(XL)

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_CmplRqVersRgtyListItmName.
-- 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_CmplRqVersRgtyListItmName AS
SELECT
  _ListItem.ListedSubstance AS ListedSubstance,
  _ListItem.SubstanceListUUID AS SubstanceListUUID,
  _ListItem.SubstanceListItmUUID AS SubstanceListItmUUID,
  _ListedSubstanceHead.ListedSubstanceCndn AS ListedSubstanceCndn,
  _ListItem.SubstanceListItmAddlInfo AS SubstanceListItmAddlInfo
FROM I_CmplRqVersThldListItm AS _ListItem
LEFT OUTER JOIN I_CmplRqVersListItmDfltName AS _NameOnList ON SubstanceListUUID = _NameOnList.SubstanceListUUID AND ListedSubstance = _NameOnList.ListedSubstance AND _NameOnList.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ListedSubstanceDefaultName AS _DefaultName ON ListedSubstance = _DefaultName.ListedSubstance  -- association [0..1]
LEFT OUTER JOIN ehfndv_lisu_rt AS _ListedSubstanceHead ON ListedSubstance = _ListedSubstanceHead.listedsubstance  -- association [1..1]
;

Learn More