I_CmplRqPattern

DDL: I_CMPLRQPATTERN SQL: ICOMPLRQPATTERN Type: view BASIC Package: EHFND_BO_COMPLIANCE_REQ
5 Fields 1 Data Sources 46 OData Services 7 Fiori Apps

Compliance Requirement Pattern

I_CmplRqPattern is a Basic CDS View that provides data about "Compliance Requirement Pattern" in SAP S/4HANA. It reads from 1 data source (P_CmplRqPattern) and exposes 5 fields with key fields CmplRqApplicationComponent, CmplRqPattern. It is exposed through 46 OData services (ASQL_F2578, ASQL_F2612, ASQL_F2928, ...). It is used in 7 Fiori applications: Manage Water Hazard Class, Registration for Confidential Business Information, Manage Exposure Scenarios, .... Part of development package EHFND_BO_COMPLIANCE_REQ.

Data Sources (1)

SourceAliasJoin Type
P_CmplRqPattern P_CmplRqPattern from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICOMPLRQPATTERN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Compliance Requirement Pattern view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view

OData Services (46)

ServiceBindingVersionContractRelease
ASQL_F2578 ASQL_F2578 C2 NOT_RELEASED
ASQL_F2612 ASQL_F2612 C2 NOT_RELEASED
ASQL_F2928 ASQL_F2928 C2 NOT_RELEASED
ASQL_F3025 ASQL_F3025 C2 NOT_RELEASED
ASQL_F3034 ASQL_F3034 C2 NOT_RELEASED
ASQL_F3040 ASQL_F3040 C2 NOT_RELEASED
ASQL_F3219 ASQL_F3219 C2 NOT_RELEASED
ASQL_F3220 ASQL_F3220 C2 NOT_RELEASED
ASQL_F3221 ASQL_F3221 C2 NOT_RELEASED
ASQL_F3235 ASQL_F3235 C2 NOT_RELEASED
ASQL_F3236 ASQL_F3236 C2 NOT_RELEASED
ASQL_F3346 ASQL_F3346 C2 NOT_RELEASED
ASQL_F3420 ASQL_F3420 C2 NOT_RELEASED
ASQL_F3460 ASQL_F3460 C2 NOT_RELEASED
ASQL_F3667 ASQL_F3667 C2 NOT_RELEASED
ASQL_F4510 ASQL_F4510 C2 NOT_RELEASED
ASQL_F4655 ASQL_F4655 C2 NOT_RELEASED
ASQL_F4794 ASQL_F4794 C2 NOT_RELEASED
ASQL_F4833 ASQL_F4833 C2 NOT_RELEASED
ASQL_F5034 ASQL_F5034 C2 NOT_RELEASED
ASQL_F5086 ASQL_F5086 C2 NOT_RELEASED
ASQL_F5087 ASQL_F5087 C2 NOT_RELEASED
ASQL_F5232 ASQL_F5232 C2 NOT_RELEASED
ASQL_F5282 ASQL_F5282 C2 NOT_RELEASED
ASQL_F5369 ASQL_F5369 C2 NOT_RELEASED
ASQL_F5995 ASQL_F5995 C2 NOT_RELEASED
ASQL_F6069 ASQL_F6069 C2 NOT_RELEASED
ASQL_F6187 ASQL_F6187 C2 NOT_RELEASED
ASQL_F6216 ASQL_F6216 C2 NOT_RELEASED
ASQL_F6278 ASQL_F6278 C2 NOT_RELEASED
ASQL_F6329 ASQL_F6329 C2 NOT_RELEASED
ASQL_F6342 ASQL_F6342 C2 NOT_RELEASED
ASQL_F6749 ASQL_F6749 C2 NOT_RELEASED
ASQL_F6750 ASQL_F6750 C2 NOT_RELEASED
ASQL_F6751 ASQL_F6751 C2 NOT_RELEASED
ASQL_F7081 ASQL_F7081 C2 NOT_RELEASED
ASQL_F7370 ASQL_F7370 C2 NOT_RELEASED
ASQL_F7414 ASQL_F7414 C2 NOT_RELEASED
UI_CN_UPADAGDSCLFNJTT617 UI_CN_UPADAGDSCLFNJTT617 V2 C1 NOT_RELEASED
UI_EHS_FND_CD_SUPLR_PROCESS UI_EHS_FND_CD_SUPLR_PROCV2 V2 C1 NOT_RELEASED
UI_EHS_FND_CRR_DYN_MAN UI_EHS_FND_CRR_DYN_MAN V2 C1 NOT_RELEASED
UI_EHS_FND_CRR_OVERVIEW UI_EHS_FND_CRR_OVERVIEW V2 C1 NOT_RELEASED
UI_EHS_SDS_CS_MAN UI_EHS_SDS_CS_MAN V2 C1 NOT_RELEASED
UI_EHS_SDS_ES_MAN UI_EHS_SDS_ES_MAN V2 C1 NOT_RELEASED
UI_EHS_SDS_ESDSANX_MAN UI_EHS_SDS_ESDSANX_MAN V2 C1 NOT_RELEASED
UI_EHS_SDS_TSR_MAN UI_EHS_SDS_TSR_MAN V2 C1 NOT_RELEASED

Fiori Apps (7)

App IDApp NameTypeDescription
F5756 Manage Water Hazard Class Transactional Manage Water Hazard Class
F6342 Registration for Confidential Business Information Transactional
F6749 Manage Exposure Scenarios Transactional Manage Exposure Scenarios
F6750 Manage Contributing Scenarios Transactional Manage Contributing Scenarios
F6751 Manage eSDS Annex Transactional Manage eSDS Annex
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).
F7436 Classify Dangerous Good - Unpackaged Product (JTT 617 3) Transactional

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.

Registration for Confidential Business Information

Business Role: Master Data Specialist - Product Compliance

With this feature, you can document the registration of confidential business information. Use the Registration of Confidential Business Information app to enter the registration number and affected product or substance data to document the registration on product level or component level, depending on the country- or region-specific requirements.

Manage Exposure Scenarios

Business Role: Product Stewardship Specialist - Product Compliance

With the Manage Exposure Scenarios app, you can provide detailed information on an exposure scenario to describe the operational conditions and risk management measures that ensure safe use of the substance or mixture. You can edit the data to ensure that it is up to date and the unpackaged product stays compliant. You can also create a new or assign an existing contributing scenario. You can then release a version of the exposure scenario to use it in the Manage eSDS Annex app.

Manage Contributing Scenarios

Business Role: Product Stewardship Specialist - Product Compliance

With the Manage Contributing Scenarios app, you can provide detailed information on contributing activities for a specific use that are part of an exposure scenario. You can then release a version of the contributing scenario to use it in the exposure scenarios.

Manage eSDS Annex

Business Role: Product Stewardship Specialist - Product Compliance

With the Manage eSDS Annex app, you can create new or assign existing exposure scenarios to an unpackaged product. You can specify the data that is required as an annex to a safety data sheet to ensure that the unpackaged product stays compliant.

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CmplRqApplicationComponent CmplRqApplicationComponent Solution Area
KEY CmplRqPattern CmplRqPattern Compliance Pattern
CmplRqPatternName Pattern Name
CmplRqPatternDocumentationLink
CmplRqVersDocumentationObject CmplRqVersDocumentationObject LOIO ID

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_CmplRqPattern.
-- 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: ICOMPLRQPATTERN

CREATE VIEW I_CmplRqPattern AS
SELECT
  CmplRqApplicationComponent,
  CmplRqPattern,
  cast( CmplRqPatternName as ehfnd_req_pattern_name_short) AS CmplRqPatternName,
  cast( '' as ehfnd_req_source_url ) AS CmplRqPatternDocumentationLink,
  CmplRqVersDocumentationObject
FROM P_CmplRqPattern
;

Learn More