C_ChmlCmplncMatlAssgmtTP

DDL: C_CHMLCMPLNCMATLASSGMTTP Type: view CONSUMPTION
11 Fields 1 Data Sources 1 Associations

Chemical Compliance Material Assignment

C_ChmlCmplncMatlAssgmtTP is a Consumption CDS View that provides data about "Chemical Compliance Material Assignment" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncMatlAssgmtTP) and exposes 11 fields with key field ChmlCmplncMatlAssgmtUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncMatlAssgmtTP I_ChmlCmplncMatlAssgmtTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_ChmlCmplncInfoTP _ChmlCmplncInfo _ChmlCmplncInfo.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID

Annotations (16)

NameValueLevelField
EndUserText.label Chemical Compliance Material Assignment view
AbapCatalog.sqlViewName CCCMATLASSGMTTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
Metadata.allowExtensions true view
Search.searchable true view

Fields (11)

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

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_ChmlCmplncMatlAssgmtTP.
-- 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_ChmlCmplncMatlAssgmtTP 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
LEFT OUTER JOIN C_ChmlCmplncInfoTP AS _ChmlCmplncInfo ON _ChmlCmplncInfo.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [1..1]
;

Learn More