P_NameOnGrpMbrListRptblQty

DDL: P_NAMEONGRPMBRLISTRPTBLQTY Type: view_entity COMPOSITE Package: EHFND_BO_COMPLIANCE_REQ
13 Fields 6 Data Sources 1 Associations

Internal View for the CFR49 Name on List for Rptbl Qty

P_NameOnGrpMbrListRptblQty 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 6 data sources and exposes 13 fields with key fields ListedSubstance, ListedSubstanceGroup. It has 1 association to related views. Part of development package EHFND_BO_COMPLIANCE_REQ.

Data Sources (6)

SourceAliasJoin Type
I_LstdSubstWthVarAndGrp ListedSubstance inner
I_CmplRqVersSubstanceList RegList inner
P_CmplRqVersETablThresholdList RelevantLisuGrps inner
I_Substance Substance inner
P_CmplRqVersListGrpAssgmtUnion SubstGrpMember from
P_US_AllRptblQtyCFRGrpItemSAP ThresholdList inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_ListSubstDfltNameAllLang _NameOnList SubstGrpMember.SubstanceListUUID = _NameOnList.SubstanceListUUID and SubstGrpMember.ListedSubstanceGroup = _NameOnList.ListedSubstance and _NameOnList.Language = 'E'

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 (13)

KeyFieldSource TableSource FieldDescription
KEY ListedSubstance P_CmplRqVersListGrpAssgmtUnion ListedSubstance Listed Substance
KEY ListedSubstanceGroup P_CmplRqVersListGrpAssgmtUnion ListedSubstanceGroup Group of Substances
CmplRqVersUUID P_CmplRqVersListGrpAssgmtUnion CmplRqVersUUID NodeID
SubstanceListUUID P_CmplRqVersListGrpAssgmtUnion SubstanceListUUID Substance List
ListedSubstanceGroupUUID P_CmplRqVersListGrpAssgmtUnion ListedSubstanceGroupUUID NodeID
SubstanceListType I_CmplRqVersSubstanceList SubstanceListType Regulatory List Type
SubstanceUUID I_Substance SubstanceUUID Substance
ListedSubstanceGroupName
SubstanceListItmThreshold P_US_AllRptblQtyCFRGrpItemSAP SubstanceListItmThreshold Threshold
SubstanceListItmThresholdUoM P_US_AllRptblQtyCFRGrpItemSAP SubstanceListItmThresholdUoM Unit
ResponsibleUnit I_Substance ResponsibleUnit Responsible Unit
CASNumber I_LstdSubstWthVarAndGrp CASNumber CAS Number
ECNumber I_LstdSubstWthVarAndGrp 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_NameOnGrpMbrListRptblQty.
-- 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_NameOnGrpMbrListRptblQty AS
SELECT
  SubstGrpMember.ListedSubstance AS ListedSubstance,
  SubstGrpMember.ListedSubstanceGroup AS ListedSubstanceGroup,
  SubstGrpMember.CmplRqVersUUID AS CmplRqVersUUID,
  SubstGrpMember.SubstanceListUUID AS SubstanceListUUID,
  SubstGrpMember.ListedSubstanceGroupUUID AS ListedSubstanceGroupUUID,
  RegList.SubstanceListType AS SubstanceListType,
  Substance.SubstanceUUID AS SubstanceUUID,
  _NameOnList._SubstanceNames[1:Language = 'E'].ListedSubstanceName AS ListedSubstanceGroupName,
  ThresholdList.SubstanceListItmThreshold AS SubstanceListItmThreshold,
  ThresholdList.SubstanceListItmThresholdUoM AS SubstanceListItmThresholdUoM,
  Substance.ResponsibleUnit AS ResponsibleUnit,
  ListedSubstance.CASNumber AS CASNumber,
  ListedSubstance.ECNumber AS ECNumber
FROM P_CmplRqVersListGrpAssgmtUnion AS SubstGrpMember
INNER JOIN I_LstdSubstWthVarAndGrp AS ListedSubstance ON /* join condition not captured in parsed metadata */
INNER JOIN I_Substance AS Substance ON /* join condition not captured in parsed metadata */
INNER JOIN I_CmplRqVersSubstanceList AS RegList ON /* join condition not captured in parsed metadata */
INNER JOIN P_US_AllRptblQtyCFRGrpItemSAP AS ThresholdList ON /* join condition not captured in parsed metadata */
INNER JOIN P_CmplRqVersETablThresholdList AS RelevantLisuGrps ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ListSubstDfltNameAllLang AS _NameOnList ON SubstGrpMember.SubstanceListUUID = _NameOnList.SubstanceListUUID AND SubstGrpMember.ListedSubstanceGroup = _NameOnList.ListedSubstance AND _NameOnList.Language = 'E'  -- association [0..1]
;

Learn More