C_ChmlCompositionTP

DDL: C_CHMLCOMPOSITIONTP Type: view CONSUMPTION
28 Fields 1 Data Sources 9 Associations

Substance-Based Analytical Composition

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

Data Sources (1)

SourceAliasJoin Type
I_ChmlCompositionTP Composition from

Associations (9)

CardinalityTargetAliasCondition
[0..*] C_ChmlComponentTP _ChemicalComponent $projection.ChmlCompositionUUID = _ChemicalComponent.ChmlCompositionUUID -------------------------------------------------------------------------------------------------------------------- --Activities Based on In Progress
[0..*] C_CmpstnCompNoReldCmpstn _CompNoReldCmpstn $projection.ChmlCompositionUUID = _CompNoReldCmpstn.ChmlCompositionUUID
[0..*] C_ChmlSuplrMatlNoReldCmpstn _ChmlSuplrMatlNoReldCmpstn $projection.ChmlCmplncInfoUUID = _ChmlSuplrMatlNoReldCmpstn.ChmlCmplncInfoUUID -------------------------------------------------------------------------------------------------------------------- --Activities Based on Released
[0..*] C_CmplRqRsltMarketability _CmplRqRslt $projection.ChmlCmplncInfoUUID = _CmplRqRslt.ChmlCmplncProdUUID and ( _CmplRqRslt.CmplRqPattern = 'CompliancePatternSupplierInfo' or _CmplRqRslt.CmplRqPattern = 'CompliancePatternSubstListChk' ) -------------------------------------------------------------------------------------------------------------------- --Additional Information --------------------------------------------------------------------------------------------------------------------
[1..1] C_ChmlCmplncPrimMatl _MaterialDataPrimary $projection.ChmlCmplncInfoUUID = _MaterialDataPrimary.ChmlCmplncInfoUUID -------------------------------------------------------------------------------------------------------------------- --Information for Navigation to associated compositions -------------------------------------------------------------------------------------------------------------------- --Released
[0..*] I_ChmlComposition _CompositionReld $projection.ChmlCmplncInfoUUID = _CompositionReld.ChmlCmplncInfoUUID and _CompositionReld.ChmlCompositionType = 'ANALYTIC1' and _CompositionReld.ChmlCompositionStatus = 'RE' --History
[0..*] C_CmpstnHistory _CompositionHistory $projection.ChmlCmplncInfoUUID = _CompositionHistory.ChmlCmplncInfoUUID and $projection.ChmlCompositionType = _CompositionHistory.ChmlCompositionType --Associated product categorization phrase text
[1..1] C_ProdCmplncPhrsTxtWthFallback _ProdCatztnPhraseText $projection.ChmlCmplncProdCatztnPhrsUUID = _ProdCatztnPhraseText.ProdCmplncPhrsUUID -- Constants
[1..1] P_CChmlCmplConstants _CChmlCmplConstants _CChmlCmplConstants.Constant0 = _CChmlCmplConstants.Constant0

Annotations (23)

NameValueLevelField
EndUserText.label Substance-Based Analytical Composition view
AbapCatalog.sqlViewName CCCOMPOSITION 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 ChmlCompositionTypeName view
UI.headerInfo.description.label Material Name view
UI.headerInfo.description.value ChmlCmplncInfoCombinedName view

Fields (28)

KeyFieldSource TableSource FieldDescription
ChmlCompositionUUIDasChmlCompositionUUID
MaterialIsSold
MaterialIsTransported
MaterialIsProduced
MaterialIsSourced
MaterialIsDisposed
MaterialIsEmissionRelevant
ChmlCmplncInfoType
ChmlCompositionTypeasChmlCompositionType
ChmlCmplncInfoUUIDasChmlCmplncInfoUUID
ChmlSuplrMatlHasCalcProblems
MaterialasMaterial
SpecificationasSpecification
ResponsibleUnitNameasResponsibleUnitName
DngrsGdsRespUnitasDngrsGdsRespUnit
ChmlCompTotalQty
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
LastChangedByUserName
BOPFDetaildata_ChemicalComponent
_ChmlCmplncInfo
Additionalsections_CmplRqRslt
_CompNoReldCmpstn _CompNoReldCmpstn
_ChmlSuplrMatlNoReldCmpstn _ChmlSuplrMatlNoReldCmpstn
History_CompositionHistory
_ProdCatztnPhraseText _ProdCatztnPhraseText
_CompositionType _CompositionType
_CompositionStatus _CompositionStatus

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_ChmlCompositionTP.
-- 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_ChmlCompositionTP AS
SELECT
  Composition._ChmlCmplncInfo.MaterialIsSold AS MaterialIsSold,
  Composition._ChmlCmplncInfo.MaterialIsTransported AS MaterialIsTransported,
  Composition._ChmlCmplncInfo.MaterialIsProduced AS MaterialIsProduced,
  Composition._ChmlCmplncInfo.MaterialIsSourced AS MaterialIsSourced,
  Composition._ChmlCmplncInfo.MaterialIsDisposed AS MaterialIsDisposed,
  Composition._ChmlCmplncInfo.MaterialIsEmissionRelevant AS MaterialIsEmissionRelevant,
  Composition._ChmlCmplncInfo.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  cast( '' as boole_d ) AS ChmlSuplrMatlHasCalcProblems,
  cast( 0 as ehfnd_cci_ccomp_qty ) AS ChmlCompTotalQty,
  CreatedByUser,
  LastChangedByUser,
  cast( _LastChangedByUser.UserDescription as ehfnd_bo_lchg_uname_enhanced preserving type ) AS LastChangedByUserName
FROM I_ChmlCompositionTP AS Composition
LEFT OUTER JOIN C_ChmlComponentTP AS _ChemicalComponent ON ChmlCompositionUUID = _ChemicalComponent.ChmlCompositionUUID  -- association [0..*]
LEFT OUTER JOIN C_CmpstnCompNoReldCmpstn AS _CompNoReldCmpstn ON ChmlCompositionUUID = _CompNoReldCmpstn.ChmlCompositionUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlSuplrMatlNoReldCmpstn AS _ChmlSuplrMatlNoReldCmpstn ON ChmlCmplncInfoUUID = _ChmlSuplrMatlNoReldCmpstn.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_CmplRqRsltMarketability AS _CmplRqRslt ON ChmlCmplncInfoUUID = _CmplRqRslt.ChmlCmplncProdUUID AND ( _CmplRqRslt.CmplRqPattern = 'CompliancePatternSupplierInfo' OR _CmplRqRslt.CmplRqPattern = 'CompliancePatternSubstListChk' )  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _MaterialDataPrimary ON ChmlCmplncInfoUUID = _MaterialDataPrimary.ChmlCmplncInfoUUID  -- association [1..1]
LEFT OUTER JOIN I_ChmlComposition AS _CompositionReld ON ChmlCmplncInfoUUID = _CompositionReld.ChmlCmplncInfoUUID AND _CompositionReld.ChmlCompositionType = 'ANALYTIC1' 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 [1..1]
;

Learn More