C_ChmlCmplncInfoInProdMaster

DDL: C_CHMLCMPLNCINFOINPRODMASTER Type: view_entity CONSUMPTION
12 Fields 1 Data Sources

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.

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

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