C_CmplRqRsltDynPatternDetailTP

DDL: C_CMPLRQRSLTDYNPATTERNDETAILTP Type: view_entity CONSUMPTION
47 Fields 1 Data Sources 1 Associations 1 OData Services 2 Fiori Apps

Dynamic Pattern Assessment Detail

C_CmplRqRsltDynPatternDetailTP is a Consumption CDS View that provides data about "Dynamic Pattern Assessment Detail" in SAP S/4HANA. It reads from 1 data source (R_CmplRqRsltDynPatternDetailTP) and exposes 47 fields with key field CmplRqRsltDynPatternDetailUUID. It has 1 association to related views. It is exposed through 1 OData service (UI_EHS_FND_CRR_DYN_MAN). It is used in 2 Fiori applications: Manage Water Hazard Class, Assess Regulatory Data.

Data Sources (1)

SourceAliasJoin Type
R_CmplRqRsltDynPatternDetailTP R_CmplRqRsltDynPatternDetailTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_SubstanceNameText _SubstanceNameText $projection.CmplRqRsltComponentUUID = _SubstanceNameText.SubstanceUUID

Annotations (10)

NameValueLevelField
EndUserText.label Dynamic Pattern Assessment Detail view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey CmplRqRsltDynPatternDetailUUID view
UI.headerInfo.typeName Assessment view
UI.headerInfo.typeNamePlural Assessments view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_EHS_FND_CRR_DYN_MAN UI_EHS_FND_CRR_DYN_MAN V2 C1 NOT_RELEASED

Fiori Apps (2)

App IDApp NameTypeDescription
F5756 Manage Water Hazard Class Transactional Manage Water Hazard Class
F7081 Assess Regulatory Data Transactional, Reuse Component The app serves only as the technical basis for app variants of the apps for assessing products against compliance requirements based on the "Regulatory Data Assessment" compliance pattern (see related apps).

Manage Water Hazard Class

Business Role: Product Stewardship Specialist - Product Compliance

With this feature, you can assess products, raw materials and substances according to the applicable water hazard class regulations and manage the compliance assessments.

Assess Regulatory Data

Business Role: Product Stewardship Specialist - Product Compliance

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY CmplRqRsltDynPatternDetailUUID CmplRqRsltDynPatternDetailUUID
UUIDofCRRCmplRqRsltUUIDasCmplRqRsltUUID
ActiveCmplRqRsltUUID _CmplRqRsltDynPatternAssmt ActiveCmplRqRsltUUID Compliance Assessment UUID
ChmlCmplncInfoUUID _CmplRqRsltDynPatternAssmt ChmlCmplncInfoUUID Chemical Compliance Information PP
ChmlSuplrMatlUUID _CmplRqRsltDynPatternAssmt ChmlSuplrMatlUUID Supplier Raw Material
HostSubstanceUUID _CmplRqRsltDynPatternAssmt SubstanceUUID Substance
CmplRqVersUUID
ChmlCompositionType _CmplRqRsltDynPatternAssmt ChmlCompositionType Legal Area
SubstanceNameasSubstanceName
CmplRqRsltLowrValue1 CmplRqRsltLowrValue1
CmplRqRsltLowrValue1Txt CmplRqRsltLowrValue1Txt
CmplRqRsltUprValue1Optr CmplRqRsltUprValue1Optr
CmplRqRsltUprValue1 CmplRqRsltUprValue1
CmplRqRsltUprValue1Txt CmplRqRsltUprValue1Txt
CmplRqRsltLowrValue2 CmplRqRsltLowrValue2
CmplRqRsltLowrValue2Txt CmplRqRsltLowrValue2Txt
CmplRqRsltUprValue2Optr CmplRqRsltUprValue2Optr
CmplRqRsltUprValue2 CmplRqRsltUprValue2
CmplRqRsltUprValue2Txt CmplRqRsltUprValue2Txt
CmplRqRsltLowrValue3 CmplRqRsltLowrValue3
CmplRqRsltLowrValue3Txt CmplRqRsltLowrValue3Txt
CmplRqRsltUprValue3Optr CmplRqRsltUprValue3Optr
CmplRqRsltUprValue3 CmplRqRsltUprValue3
CmplRqRsltUprValue3Txt CmplRqRsltUprValue3Txt
CmplRqRsltLowrQty1 CmplRqRsltLowrQty1
CmplRqRsltLowrQty1Txt CmplRqRsltLowrQty1Txt
CmplRqRsltUprQty1Optr CmplRqRsltUprQty1Optr
CmplRqRsltUprQty1 CmplRqRsltUprQty1
CmplRqRsltUprQty1Txt CmplRqRsltUprQty1Txt
CmplRqRsltQty1UoM CmplRqRsltQty1UoM
CmplRqRsltQty1UoMTxt
CmplRqRsltLowrQty2 CmplRqRsltLowrQty2
CmplRqRsltLowrQty2Txt CmplRqRsltLowrQty2Txt
CmplRqRsltUprQty2Optr CmplRqRsltUprQty2Optr
CmplRqRsltUprQty2 CmplRqRsltUprQty2
CmplRqRsltUprQty2Txt CmplRqRsltUprQty2Txt
CmplRqRsltQty2UoM CmplRqRsltQty2UoM
CmplRqRsltQty2UoMTxt
CmplRqRsltMultiPhrase11UUID CmplRqRsltMultiPhrase11UUID
CmplRqRsltMultiPhrase12UUID CmplRqRsltMultiPhrase12UUID
CmplRqRsltMultiPhrase13UUID CmplRqRsltMultiPhrase13UUID
CmplRqRsltMultiPhrase21UUID CmplRqRsltMultiPhrase21UUID
CmplRqRsltMultiPhrase22UUID CmplRqRsltMultiPhrase22UUID
CmplRqRsltMultiPhrase23UUID CmplRqRsltMultiPhrase23UUID
CmplRqRsltText1 CmplRqRsltText1
virtualChmlCompReldQtyUnitTextmseht
_SubstanceNameText _SubstanceNameText

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 C_CmplRqRsltDynPatternDetailTP.
-- 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 C_CmplRqRsltDynPatternDetailTP AS
SELECT
  CmplRqRsltDynPatternDetailUUID,
  _CmplRqRsltDynPatternAssmt.ActiveCmplRqRsltUUID AS ActiveCmplRqRsltUUID,
  _CmplRqRsltDynPatternAssmt.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  _CmplRqRsltDynPatternAssmt.ChmlSuplrMatlUUID AS ChmlSuplrMatlUUID,
  _CmplRqRsltDynPatternAssmt.SubstanceUUID AS HostSubstanceUUID,
  _CmplRqRsltDynPatternAssmt._CmplRqVers.CmplRqVersUUID AS CmplRqVersUUID,
  _CmplRqRsltDynPatternAssmt.ChmlCompositionType AS ChmlCompositionType,
  CmplRqRsltLowrValue1,
  CmplRqRsltLowrValue1Txt,
  CmplRqRsltUprValue1Optr,
  CmplRqRsltUprValue1,
  CmplRqRsltUprValue1Txt,
  CmplRqRsltLowrValue2,
  CmplRqRsltLowrValue2Txt,
  CmplRqRsltUprValue2Optr,
  CmplRqRsltUprValue2,
  CmplRqRsltUprValue2Txt,
  CmplRqRsltLowrValue3,
  CmplRqRsltLowrValue3Txt,
  CmplRqRsltUprValue3Optr,
  CmplRqRsltUprValue3,
  CmplRqRsltUprValue3Txt,
  CmplRqRsltLowrQty1,
  CmplRqRsltLowrQty1Txt,
  CmplRqRsltUprQty1Optr,
  CmplRqRsltUprQty1,
  CmplRqRsltUprQty1Txt,
  CmplRqRsltQty1UoM,
  _UnitOfMeasureQty1._Text[1: Language = $session.system_language ].UnitOfMeasureName AS CmplRqRsltQty1UoMTxt,
  CmplRqRsltLowrQty2,
  CmplRqRsltLowrQty2Txt,
  CmplRqRsltUprQty2Optr,
  CmplRqRsltUprQty2,
  CmplRqRsltUprQty2Txt,
  CmplRqRsltQty2UoM,
  _UnitOfMeasureQty1._Text[1: Language = $session.system_language ].UnitOfMeasureName AS CmplRqRsltQty2UoMTxt,
  CmplRqRsltMultiPhrase11UUID,
  CmplRqRsltMultiPhrase12UUID,
  CmplRqRsltMultiPhrase13UUID,
  CmplRqRsltMultiPhrase21UUID,
  CmplRqRsltMultiPhrase22UUID,
  CmplRqRsltMultiPhrase23UUID,
  CmplRqRsltText1,
  virtual ChmlCompReldQtyUnitText : mseht AS virtualChmlCompReldQtyUnitTextmseht
FROM R_CmplRqRsltDynPatternDetailTP
LEFT OUTER JOIN C_SubstanceNameText AS _SubstanceNameText ON CmplRqRsltComponentUUID = _SubstanceNameText.SubstanceUUID  -- association [0..1]
;

Learn More