P_NameOnListRptblQtyInternal

DDL: P_NAMEONLISTRPTBLQTYINTERNAL Type: view_entity COMPOSITE Package: EHFND_BO_COMPLIANCE_REQ
10 Fields 4 Data Sources

Internal View for the CFR49 Name on List for Rptbl Qty

P_NameOnListRptblQtyInternal is a Composite CDS View that provides data about "Internal View for the CFR49 Name on List for Rptbl Qty" in SAP S/4HANA. It reads from 4 data sources (I_ListedSubstanceSAP, P_CmplRqVersETablNameOnList, I_CmplRqVersSubstanceList, I_Substance) and exposes 10 fields with key fields SubstanceUUID, CmplRqVersUUID, language. Part of development package EHFND_BO_COMPLIANCE_REQ.

Data Sources (4)

SourceAliasJoin Type
I_ListedSubstanceSAP ListedSubstance inner
P_CmplRqVersETablNameOnList NameOnList inner
I_CmplRqVersSubstanceList RegList inner
I_Substance Substance from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SubstanceUUID I_Substance SubstanceUUID Substance
KEY CmplRqVersUUID P_CmplRqVersETablNameOnList root_key UUID
KEY language P_CmplRqVersETablNameOnList language Report Text Language
SubstanceListType I_CmplRqVersSubstanceList SubstanceListType Regulatory List Type
ListedSubstanceNameUUID P_CmplRqVersETablNameOnList listed_substance_name_uuid NodeID
SubstanceListItmThreshold Thresholdlist value Value from table
SubstanceListItmThresholdUoM
ResponsibleUnit I_Substance ResponsibleUnit Responsible Unit
CASNumber I_ListedSubstanceSAP CASNumber CAS Number
ECNumber I_ListedSubstanceSAP ECNumber EC Number

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_NameOnListRptblQtyInternal.
-- 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 P_NameOnListRptblQtyInternal AS
SELECT
  Substance.SubstanceUUID AS SubstanceUUID,
  NameOnList.root_key AS CmplRqVersUUID,
  NameOnList.language AS language,
  RegList.SubstanceListType AS SubstanceListType,
  NameOnList.listed_substance_name_uuid AS ListedSubstanceNameUUID,
  Thresholdlist.value AS SubstanceListItmThreshold,
  cast ( Thresholdlist.unit as ehfnd_regl_comp_unit_code_nce preserving type ) AS SubstanceListItmThresholdUoM,
  Substance.ResponsibleUnit AS ResponsibleUnit,
  ListedSubstance.CASNumber AS CASNumber,
  ListedSubstance.ECNumber AS ECNumber
FROM I_Substance AS Substance
INNER JOIN I_ListedSubstanceSAP AS ListedSubstance ON /* join condition not captured in parsed metadata */
INNER JOIN P_CmplRqVersETablNameOnList AS NameOnList ON /* join condition not captured in parsed metadata */
INNER JOIN I_CmplRqVersSubstanceList AS RegList ON /* join condition not captured in parsed metadata */
;

Learn More