P_CmplRqVersThldListItmDtls

DDL: P_CMPLRQVERSTHLDLISTITMDTLS SQL: PCRVTHLDLSTITDT Type: view COMPOSITE Package: EHFND_BO_COMPLIANCE_REQ
15 Fields 2 Data Sources

Details of Threshold based Substance Lists

P_CmplRqVersThldListItmDtls is a Composite CDS View that provides data about "Details of Threshold based Substance Lists" in SAP S/4HANA. It reads from 2 data sources (I_CmplRqVersThldListItm, I_CmplRqVersRgtyListItmEnhcd) and exposes 15 fields with key fields CmplRqVers, SubstanceListItmUUID. Part of development package EHFND_BO_COMPLIANCE_REQ.

Data Sources (2)

SourceAliasJoin Type
I_CmplRqVersThldListItm _Item from
I_CmplRqVersRgtyListItmEnhcd _Subst inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PCRVTHLDLSTITDT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey SubstanceListItmUUID view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CmplRqVers I_CmplRqVersThldListItm CmplRqVers Compliance Requirement
KEY SubstanceListItmUUID I_CmplRqVersThldListItm SubstanceListItmUUID UUID
CmplRqVersUUID I_CmplRqVersThldListItm CmplRqVersUUID NodeID
SubstanceListUUID I_CmplRqVersThldListItm SubstanceListUUID Substance List
ListedSubstance I_CmplRqVersThldListItm ListedSubstance Listed Substance
SubstanceListItmThreshold I_CmplRqVersThldListItm SubstanceListItmThreshold Threshold
SubstanceListItmThresholdUoM I_CmplRqVersThldListItm SubstanceListItmThresholdUoM Unit
SubstanceListItmAddlInfo I_CmplRqVersThldListItm SubstanceListItmAddlInfo Description(XL)
CASNumber I_CmplRqVersRgtyListItmEnhcd CASNumber CAS Number
ECNumber I_CmplRqVersRgtyListItmEnhcd ECNumber EC Number
ListedSubstanceCndn
ListedSubstanceCndnName I_CmplRqVersRgtyListItmEnhcd ListedSubstanceCndnName
ListedSubstanceIsGroup I_CmplRqVersRgtyListItmEnhcd ListedSubstanceIsGroup
ListedSubstanceName I_CmplRqVersRgtyListItmEnhcd ListedSubstanceName Listed Subst. Name
MolecularFormula I_CmplRqVersRgtyListItmEnhcd MolecularFormula

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 P_CmplRqVersThldListItmDtls.
-- 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.
-- SQL view name: PCRVTHLDLSTITDT

CREATE VIEW P_CmplRqVersThldListItmDtls AS
SELECT
  _Item.CmplRqVers AS CmplRqVers,
  _Item.SubstanceListItmUUID AS SubstanceListItmUUID,
  _Item.CmplRqVersUUID AS CmplRqVersUUID,
  _Item.SubstanceListUUID AS SubstanceListUUID,
  _Item.ListedSubstance AS ListedSubstance,
  _Item.SubstanceListItmThreshold AS SubstanceListItmThreshold,
  _Item.SubstanceListItmThresholdUoM AS SubstanceListItmThresholdUoM,
  _Item.SubstanceListItmAddlInfo AS SubstanceListItmAddlInfo,
  _Subst.CASNumber AS CASNumber,
  _Subst.ECNumber AS ECNumber,
  cast( _Subst.ListedSubstanceCndn as ehfnd_lisu_cond_code_plain preserving type ) AS ListedSubstanceCndn,
  _Subst.ListedSubstanceCndnName AS ListedSubstanceCndnName,
  _Subst.ListedSubstanceIsGroup AS ListedSubstanceIsGroup,
  _Subst.ListedSubstanceName AS ListedSubstanceName,
  _Subst.MolecularFormula AS MolecularFormula
FROM I_CmplRqVersThldListItm AS _Item
INNER JOIN I_CmplRqVersRgtyListItmEnhcd AS _Subst ON /* join condition not captured in parsed metadata */
;

Learn More