I_ChmlCmplncAddlPrptyTP

DDL: I_CHMLCMPLNCADDLPRPTYTP Type: view TRANSACTIONAL
15 Fields 1 Data Sources 1 Associations

Chemical Compliance Addl Property

I_ChmlCmplncAddlPrptyTP is a Transactional CDS View that provides data about "Chemical Compliance Addl Property" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncAddlPrpty) and exposes 15 fields with key field ChmlCmplncAddlPrptyUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncAddlPrpty I_ChmlCmplncAddlPrpty from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ChmlCmplncPrptyAssgmtTP _ChmlCmplncPrptyAssgmt $projection.ChmlCmplncAddlPrptyUUID = _ChmlCmplncPrptyAssgmt.ChmlCmplncAddlPrptyUUID

Annotations (21)

NameValueLevelField
EndUserText.label Chemical Compliance Addl Property view
AbapCatalog.sqlViewName ICADLPRTYTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.compositionRoot true view
ObjectModel.draftEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence EHFNDW_CCA_ADLPR view
ObjectModel.writeActivePersistence EHFNDV_CCA_ADLPR view
ObjectModel.entityChangeStateId LastChangeUTCDateTime view
ObjectModel.sapObjectNodeType.name ChemicalComplianceAddlPrpty view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncAddlPrptyUUID ChmlCmplncAddlPrptyUUID Chml Cmplnc Adl Prpt
ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
ChmlCmplncAddlPrptyVersionID ChmlCmplncAddlPrptyVersionID Version Number
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
_ChmlCmplncPrptyAssgmt _ChmlCmplncPrptyAssgmt
_ChmlCmplncInfo _ChmlCmplncInfo
_ChmlCmplncAssgdObjectStatus _ChmlCmplncAssgdObjectStatus
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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 I_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 I_ChmlCmplncAddlPrptyTP AS
SELECT
  ChmlCmplncAddlPrptyUUID,
  ChmlCmplncInfoUUID,
  ChmlCmplncAddlPrptyVersionID,
  ChmlCmplncAddlPrptyStatus,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser,
  ValidityStartDateTime,
  ValidityEndDateTime
FROM I_ChmlCmplncAddlPrpty
LEFT OUTER JOIN I_ChmlCmplncPrptyAssgmtTP AS _ChmlCmplncPrptyAssgmt ON ChmlCmplncAddlPrptyUUID = _ChmlCmplncPrptyAssgmt.ChmlCmplncAddlPrptyUUID  -- association [0..*]
;

Learn More