C_ChmlCmplncInfoInProdMaster

DDL: C_CHMLCMPLNCINFOINPRODMASTER Type: view_entity CONSUMPTION Package: EHFND_CNS_CCIDFR
12 Fields 1 Data Sources 2 OData Services

ChmlCmplncIdfr Names in Product Master

C_ChmlCmplncInfoInProdMaster is a Consumption CDS View that provides data about "ChmlCmplncIdfr Names in Product Master" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncMatlAssgmtTP) and exposes 12 fields with key field ChmlCmplncMatlAssgmtUUID. It is exposed through 2 OData services (ASQL_F7919, UI_EHS_FND_CCIDFR_MANAGE). Part of development package EHFND_CNS_CCIDFR.

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncMatlAssgmtTP I_ChmlCmplncMatlAssgmtTP from

Annotations (9)

NameValueLevelField
EndUserText.label ChmlCmplncIdfr Names in Product Master view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F7919 ASQL_F7919 C2 NOT_RELEASED
UI_EHS_FND_CCIDFR_MANAGE UI_EHS_FND_CCIDFR_MANAGE V4 C1 NOT_RELEASED

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncMatlAssgmtUUID ChmlCmplncMatlAssgmtUUID Product Assignment
ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
Material Material Vehicle Model
MaterialName
MaterialGroup
MaterialGroupName
CrossPlantStatusName
MatlAssgmtIsPrimary MatlAssgmtIsPrimary Preferred Name
ExternalProductGroup
Division _Product Division Internal Division ID
_ChmlCmplncInfo _ChmlCmplncInfo
_Product _Product

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_ChmlCmplncInfoInProdMaster.
-- 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_ChmlCmplncInfoInProdMaster AS
SELECT
  ChmlCmplncMatlAssgmtUUID,
  ChmlCmplncInfoUUID,
  Material,
  cast(_Product._Text[ 1: Language = $session.system_language ].ProductName as ehfnd_cci_material_name ) AS MaterialName,
  cast(_Product.ProductGroup as ehfnd_cci_material_group preserving type) AS MaterialGroup,
  _Product._ProductGroup._Text[1: Language = $session.system_language ].MaterialGroupName AS MaterialGroupName,
  cast(_Product._ProductStatusText[1: Language = $session.system_language ].MaterialUsabilityProfileName as ehfnd_cci_crossplantstatus_txt preserving type) AS CrossPlantStatusName,
  MatlAssgmtIsPrimary,
  cast(_Product.ExternalProductGroup as ehfnd_ext_material_group preserving type) AS ExternalProductGroup,
  _Product.Division AS Division
FROM I_ChmlCmplncMatlAssgmtTP
;

Learn More