C_ChmlCmplncAddlPrptyTP

DDL: C_CHMLCMPLNCADDLPRPTYTP Type: view CONSUMPTION
30 Fields 1 Data Sources 4 Associations

Chemical Compliance Additional Property

C_ChmlCmplncAddlPrptyTP is a Consumption CDS View that provides data about "Chemical Compliance Additional Property" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncAddlPrptyTP) and exposes 30 fields with key field ChmlCmplncAddlPrptyUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncAddlPrptyTP I_ChmlCmplncAddlPrptyTP from

Associations (4)

CardinalityTargetAliasCondition
[1..*] C_ChmlCmplncPrptyAssgmtTP _ChmlCmplncPrptyAssgmt $projection.ChmlCmplncAddlPrptyUUID = _ChmlCmplncPrptyAssgmt.ChmlCmplncAddlPrptyUUID
[1..1] C_CmbndChmlCmplncInfoTP _ChmlCmplncInfoNavgn $projection.ChmlCmplncInfoUUID = _ChmlCmplncInfoNavgn.ChmlCmplncInfoUUID -- For Material name in header
[0..1] C_ChmlCmplncPrimMatl _MaterialDataPrimary _MaterialDataPrimary.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID -- For History
[1..*] C_ChmlCmplncAddlPrptyHistory _ChmlCmplncAddlPrptyHistory _ChmlCmplncAddlPrptyHistory.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID

Annotations (18)

NameValueLevelField
EndUserText.label Chemical Compliance Additional Property view
AbapCatalog.sqlViewName CCADLPRTY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true 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.representativeKey ChmlCmplncAddlPrptyUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncAddlPrptyUUID ChmlCmplncAddlPrptyUUID Chml Cmplnc Adl Prpt
ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
ActiveChmlCmplncAddlPrptyUUID ChmlCmplncAddlPrptyUUID Chml Cmplnc Adl Prpt
ChmlCmplncAddlPrptyVersionID ChmlCmplncAddlPrptyVersionID Version ID
ChmlCmplncAddlPrptyStatus ChmlCmplncAddlPrptyStatus Processing Status
CreationUTCDateTime CreationUTCDateTime Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeUTCDateTime LastChangeUTCDateTime Time Stamp
LastChangedByUser LastChangedByUser User Name
ValidityStartDateTime ValidityStartDateTime Valid From Timestamp
ValidityEndDateTime ValidityEndDateTime Valid To Timestamp
ChmlCmplncInfoCombinedName _MaterialDataPrimary ChmlCmplncInfoCombinedName
Material _MaterialDataPrimary Material Vehicle Model
ChmlCmplncProdIsResearched
MaterialIsDisposed _ChmlCmplncInfo MaterialIsDisposed Is Disposed
MaterialIsEmissionRelevant _ChmlCmplncInfo MaterialIsEmissionRelevant Emission Relevant
MaterialIsProduced _ChmlCmplncInfo MaterialIsProduced Is Produced
MaterialIsSold _ChmlCmplncInfo MaterialIsSold Is Sold
MaterialIsSourced _ChmlCmplncInfo MaterialIsSourced Is Purchased
MaterialIsTransported _ChmlCmplncInfo MaterialIsTransported Is Transported
ChmlCmplncInfoType _ChmlCmplncInfo ChmlCmplncInfoType Type of Chemical Compliance Information
AnalyticCmpstnNavgnLinkUUID _ChmlCmplncInfoNavgn AnalyticCmpstnNavgnLinkUUID
WasteCodeNavgnLinkUUID _ChmlCmplncInfoNavgn WasteCodeNavgnLinkUUID
PCPhysPrptyNavgnLinkUUID _ChmlCmplncInfoNavgn PCPhysPrptyNavgnLinkUUID
_ChmlCmplncPrptyAssgmt _ChmlCmplncPrptyAssgmt
_MaterialDataPrimary _MaterialDataPrimary
_ChmlCmplncInfo _ChmlCmplncInfo
_ChmlCmplncAssgdObjectStatus _ChmlCmplncAssgdObjectStatus
_ChmlCmplncAddlPrptyHistory _ChmlCmplncAddlPrptyHistory
_ChmlCmplncInfoNavgn _ChmlCmplncInfoNavgn

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_ChmlCmplncAddlPrptyTP.
-- 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_ChmlCmplncAddlPrptyTP AS
SELECT
  ChmlCmplncAddlPrptyUUID,
  ChmlCmplncInfoUUID,
  ChmlCmplncAddlPrptyUUID AS ActiveChmlCmplncAddlPrptyUUID,
  ChmlCmplncAddlPrptyVersionID,
  ChmlCmplncAddlPrptyStatus,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser,
  ValidityStartDateTime,
  ValidityEndDateTime,
  _MaterialDataPrimary.ChmlCmplncInfoCombinedName AS ChmlCmplncInfoCombinedName,
  _MaterialDataPrimary.Material AS Material,
  _ChmlCmplncInfo.MaterialIsDisposed AS MaterialIsDisposed,
  _ChmlCmplncInfo.MaterialIsEmissionRelevant AS MaterialIsEmissionRelevant,
  _ChmlCmplncInfo.MaterialIsProduced AS MaterialIsProduced,
  _ChmlCmplncInfo.MaterialIsSold AS MaterialIsSold,
  _ChmlCmplncInfo.MaterialIsSourced AS MaterialIsSourced,
  _ChmlCmplncInfo.MaterialIsTransported AS MaterialIsTransported,
  _ChmlCmplncInfo.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  _ChmlCmplncInfoNavgn.AnalyticCmpstnNavgnLinkUUID AS AnalyticCmpstnNavgnLinkUUID,
  _ChmlCmplncInfoNavgn.WasteCodeNavgnLinkUUID AS WasteCodeNavgnLinkUUID,
  _ChmlCmplncInfoNavgn.PCPhysPrptyNavgnLinkUUID AS PCPhysPrptyNavgnLinkUUID
FROM I_ChmlCmplncAddlPrptyTP
LEFT OUTER JOIN C_ChmlCmplncPrptyAssgmtTP AS _ChmlCmplncPrptyAssgmt ON ChmlCmplncAddlPrptyUUID = _ChmlCmplncPrptyAssgmt.ChmlCmplncAddlPrptyUUID  -- association [1..*]
LEFT OUTER JOIN C_CmbndChmlCmplncInfoTP AS _ChmlCmplncInfoNavgn ON ChmlCmplncInfoUUID = _ChmlCmplncInfoNavgn.ChmlCmplncInfoUUID  -- association [1..1]
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _MaterialDataPrimary ON _MaterialDataPrimary.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncAddlPrptyHistory AS _ChmlCmplncAddlPrptyHistory ON _ChmlCmplncAddlPrptyHistory.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [1..*]
;

Learn More