What is C_ChmlCmpstnSubstLegalTP in SAP S/4HANA?

C_ChmlCmpstnSubstLegalTP is a consumption CDS view in SAP S/4HANA. Legal-Area-Specific Analytical Composition It contains 22 fields.

Which tables does C_ChmlCmpstnSubstLegalTP read from?

C_ChmlCmpstnSubstLegalTP reads data from: I_ChmlCompositionTP.

What VDM layer is C_ChmlCmpstnSubstLegalTP?

C_ChmlCmpstnSubstLegalTP is classified as a Consumption view optimized for specific business scenarios and reporting.

C_ChmlCmpstnSubstLegalTP

DDL: C_CHMLCMPSTNSUBSTLEGALTP Type: view CONSUMPTION

22 Fields 1 Data Sources 9 Associations

Legal-Area-Specific Analytical Composition

C_ChmlCmpstnSubstLegalTP is a Consumption CDS View that provides data about "Legal-Area-Specific Analytical Composition" in SAP S/4HANA. It reads from 1 data source (I_ChmlCompositionTP) and exposes 22 fields. It has 9 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_ChmlCompositionTP	Composition	from

Associations (9)

Cardinality	Target	Alias	Condition
[0..*]	C_ChmlCompSubstLegalTP	_ChemicalComponent	`$projection.ChmlCompositionUUID = _ChemicalComponent.ChmlCompositionUUID -------------------------------------------------------------------------------------------------------------------- --Activities Based on In Progress`
[0..*]	C_CmpstnCompNoReldCmpstn	_CompNoReldCmpstn	`$projection.ChmlCompositionUUID = _CompNoReldCmpstn.ChmlCompositionUUID ----------------------------------------------------------------------------------------------------------- --Additional information ----------------------------------------------------------------------------------------------------------- --Criticality of status`
[1..1]	P_ChmlCompositionCriticality	_StatusCriticality	`$projection.ActiveChmlCompositionUUID = _StatusCriticality.ChmlCompositionUUID --Product Data`
[1..1]	P_ChmlCmplncPrfrdMatlForCmpstn	_ProductData	`$projection.ActiveChmlCompositionUUID = _ProductData.ChmlCompositionUUID --Number of Compliance Requirement Results`
[0..1]	P_ChmlCmpstnCmplRqRsltNmbr	_NrOfCmplRqRslt	`$projection.ChmlCmplncInfoUUID = _NrOfCmplRqRslt.ChmlCmplncInfoUUID and $projection.ChmlCompositionType = _NrOfCmplRqRslt.ChmlCompositionType ----------------------------------------------------------------------------------------------------------- --Information for Navigation to associated compositions -----------------------------------------------------------------------------------------------------------`
[0..*]	I_ChmlComposition	_CompositionReld	`$projection.ChmlCmplncInfoUUID = _CompositionReld.ChmlCmplncInfoUUID and $projection.ChmlCompositionType = _CompositionReld.ChmlCompositionType and _CompositionReld.ChmlCompositionStatus = 'RE' --History`
[0..*]	C_CmpstnHistory	_CompositionHistory	`$projection.ChmlCmplncInfoUUID = _CompositionHistory.ChmlCmplncInfoUUID and $projection.ChmlCompositionType = _CompositionHistory.ChmlCompositionType ----------------------------------------------------------------------------------------------------------- --Information for Navigation to associated compositions ----------------------------------------------------------------------------------------------------------- --Associated product categorization phrase text`
[1..1]	C_ProdCmplncPhrsTxtWthFallback	_ProdCatztnPhraseText	`$projection.ChmlCmplncProdCatztnPhrsUUID = _ProdCatztnPhraseText.ProdCmplncPhrsUUID`
[0..1]	P_CChmlCmplConstants	_CChmlCmplConstants	`_CChmlCmplConstants.Constant0 = _CChmlCmplConstants.Constant0`

Annotations (23)

Name	Value	Level
EndUserText.label	Legal-Area-Specific Analytical Composition	view
AbapCatalog.sqlViewName	CCCMPSSUBLGTP	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
Metadata.allowExtensions	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.compositionRoot	true	view
ObjectModel.transactionalProcessingDelegated	true	view
ObjectModel.createEnabled	true	view
ObjectModel.updateEnabled	EXTERNAL_CALCULATION	view
ObjectModel.deleteEnabled	EXTERNAL_CALCULATION	view
ObjectModel.draftEnabled	true	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.serviceQuality	#C	view
UI.headerInfo.typeImageUrl	sap-icon: typeName:	view
UI.headerInfo.typeNamePlural	Manage Analytical Compositions	view
UI.headerInfo.title.label	Composition	view
UI.headerInfo.title.value	ChmlCompositionCombinedName	view
UI.headerInfo.description.label	Material Name	view
UI.headerInfo.description.value	ChmlCmplncInfoCombinedName	view

Fields (22)

Key	Field	Source Table	Source Field	Description
	ChmlCompositionUUIDasChmlCompositionUUID
	MaterialIsSold
	MaterialIsTransported
	MaterialIsProduced
	MaterialIsSourced
	ChmlCmplncInfoType
	ChmlCompositionTypeasChmlCompositionType
	LastChangedByUserasLastChangedByUser
	UserDescriptionasUserDescription
	ResponsibleUnitNameasResponsibleUnitName
	DngrsGdsRespUnitasDngrsGdsRespUnit
	ChmlCmplncInfoUUIDasChmlCmplncInfoUUID
	MaterialasMaterial
	SpecificationasSpecification
	ChmlCompTotalQty
	BOPFDetaildata_ChemicalComponent
	_ChmlCmplncInfo
	Additionalsections_CompNoReldCmpstn
	History_CompositionHistory
	_ProdCatztnPhraseText		_ProdCatztnPhraseText
	_CompositionStatus		_CompositionStatus
	_CompositionType		_CompositionType

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_ChmlCmpstnSubstLegalTP.
-- 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_ChmlCmpstnSubstLegalTP AS
SELECT
  Composition._ChmlCmplncInfo.MaterialIsSold AS MaterialIsSold,
  Composition._ChmlCmplncInfo.MaterialIsTransported AS MaterialIsTransported,
  Composition._ChmlCmplncInfo.MaterialIsProduced AS MaterialIsProduced,
  Composition._ChmlCmplncInfo.MaterialIsSourced AS MaterialIsSourced,
  Composition._ChmlCmplncInfo.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  cast( 0 as ehfnd_cci_ccomp_qty ) AS ChmlCompTotalQty
FROM I_ChmlCompositionTP AS Composition
LEFT OUTER JOIN C_ChmlCompSubstLegalTP AS _ChemicalComponent ON ChmlCompositionUUID = _ChemicalComponent.ChmlCompositionUUID  -- association [0..*]
LEFT OUTER JOIN C_CmpstnCompNoReldCmpstn AS _CompNoReldCmpstn ON ChmlCompositionUUID = _CompNoReldCmpstn.ChmlCompositionUUID  -- association [0..*]
LEFT OUTER JOIN P_ChmlCompositionCriticality AS _StatusCriticality ON ActiveChmlCompositionUUID = _StatusCriticality.ChmlCompositionUUID  -- association [1..1]
LEFT OUTER JOIN P_ChmlCmplncPrfrdMatlForCmpstn AS _ProductData ON ActiveChmlCompositionUUID = _ProductData.ChmlCompositionUUID  -- association [1..1]
LEFT OUTER JOIN P_ChmlCmpstnCmplRqRsltNmbr AS _NrOfCmplRqRslt ON ChmlCmplncInfoUUID = _NrOfCmplRqRslt.ChmlCmplncInfoUUID AND ChmlCompositionType = _NrOfCmplRqRslt.ChmlCompositionType  -- association [0..1]
LEFT OUTER JOIN I_ChmlComposition AS _CompositionReld ON ChmlCmplncInfoUUID = _CompositionReld.ChmlCmplncInfoUUID AND ChmlCompositionType = _CompositionReld.ChmlCompositionType AND _CompositionReld.ChmlCompositionStatus = 'RE'  -- association [0..*]
LEFT OUTER JOIN C_CmpstnHistory AS _CompositionHistory ON ChmlCmplncInfoUUID = _CompositionHistory.ChmlCmplncInfoUUID AND ChmlCompositionType = _CompositionHistory.ChmlCompositionType  -- association [0..*]
LEFT OUTER JOIN C_ProdCmplncPhrsTxtWthFallback AS _ProdCatztnPhraseText ON ChmlCmplncProdCatztnPhrsUUID = _ProdCatztnPhraseText.ProdCmplncPhrsUUID  -- association [1..1]
LEFT OUTER JOIN P_CChmlCmplConstants AS _CChmlCmplConstants ON _CChmlCmplConstants.Constant0 = _CChmlCmplConstants.Constant0  -- association [0..1]
;

Depth:

C_ChmlCmpstnSubstLegalTP view

I_ChmlCompositionTP view