C_CmbndChmlCmplncAddlPrpty

DDL: C_CMBNDCHMLCMPLNCADDLPRPTY Type: view CONSUMPTION Package: EHFND_CNS_CCI
18 Fields 2 Data Sources

Combined Chem Cmplnc Additional Property

C_CmbndChmlCmplncAddlPrpty is a Consumption CDS View that provides data about "Combined Chem Cmplnc Additional Property" in SAP S/4HANA. It reads from 2 data sources (P_ChmlCmplncAssocAddlPrpty, I_ChmlCmplncPrptyAssgmt) and exposes 18 fields with key fields ChmlCmplncAddlPrptyUUID, ChmlCmplncPrptyAssgmtUUID, ChmlCmplncInfoUUID. Part of development package EHFND_CNS_CCI.

Data Sources (2)

SourceAliasJoin Type
P_ChmlCmplncAssocAddlPrpty ChmlCmplncAssocAddlPrpty inner
I_ChmlCmplncPrptyAssgmt ChmlCmplncPrptyAssgmt inner

Annotations (11)

NameValueLevelField
EndUserText.label Combined Chem Cmplnc Additional Property view
AbapCatalog.sqlViewName CCMBCHMLCMPADPRP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncAddlPrptyUUID ChmlCmplncAddlPrpty ChmlCmplncAddlPrptyUUID Chml Cmplnc Adl Prpt
KEY ChmlCmplncPrptyAssgmtUUID I_ChmlCmplncPrptyAssgmt ChmlCmplncPrptyAssgmtUUID CCI Property Assignm
KEY ChmlCmplncInfoUUID ChmlCmplncAddlPrpty ChmlCmplncInfoUUID Chemical Compliance Information PP
EHSChemicalPhysicalPropUUID I_ChmlCmplncPrptyAssgmt EHSChemicalPhysicalPropUUID CCI Property
EHSChemicalPhysicalUnitUUID I_ChmlCmplncPrptyAssgmt EHSChemicalPhysicalUnitUUID CCI Property Unit
ChmlCmplncAddlPrptyStatus ChmlCmplncAddlPrpty ChmlCmplncAddlPrptyStatus Processing Status
ValidityStartDateTime ChmlCmplncAddlPrpty ValidityStartDateTime Valid From Timestamp
ValidityEndDateTime ChmlCmplncAddlPrpty ValidityEndDateTime Valid To Timestamp
EHSPropertyName
ChmlCmplncPrptyValue I_ChmlCmplncPrptyAssgmt ChmlCmplncPrptyValue Property Value
EHSChemicalPhysicalPrptyUnit I_ChmlCmplncPrptyAssgmt EHSChemicalPhysicalPrptyUnit Unit of Measurement
EHSChemicalPhysPrptyUnitTxt
ChmlCmplncPrptyCmntText I_ChmlCmplncPrptyAssgmt ChmlCmplncPrptyCmntText Name
associations_ChmlCmplncInfo
_ChmlCmplncAssgdObjectStatus _ChmlCmplncAssgdObjectStatus
_EHSChemicalPhysicalPropName _EHSChemicalPhysicalPropName
_EHSChemicalPhysicalPropUnit _EHSChemicalPhysicalPropUnit
_ChmlCmplncPrptyAssgmt _ChmlCmplncPrptyAssgmt

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_CmbndChmlCmplncAddlPrpty.
-- 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_CmbndChmlCmplncAddlPrpty AS
SELECT
  ChmlCmplncAddlPrpty.ChmlCmplncAddlPrptyUUID AS ChmlCmplncAddlPrptyUUID,
  ChmlCmplncPrptyAssgmt.ChmlCmplncPrptyAssgmtUUID AS ChmlCmplncPrptyAssgmtUUID,
  ChmlCmplncAddlPrpty.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  ChmlCmplncPrptyAssgmt.EHSChemicalPhysicalPropUUID AS EHSChemicalPhysicalPropUUID,
  ChmlCmplncPrptyAssgmt.EHSChemicalPhysicalUnitUUID AS EHSChemicalPhysicalUnitUUID,
  ChmlCmplncAddlPrpty.ChmlCmplncAddlPrptyStatus AS ChmlCmplncAddlPrptyStatus,
  ChmlCmplncAddlPrpty.ValidityStartDateTime AS ValidityStartDateTime,
  ChmlCmplncAddlPrpty.ValidityEndDateTime AS ValidityEndDateTime,
  ChmlCmplncPrptyAssgmt._EHSChemicalPhysicalPropName._EHSChemicalPhysicalPropName[1:Language=$session.system_language].EHSPropertyName AS EHSPropertyName,
  ChmlCmplncPrptyAssgmt.ChmlCmplncPrptyValue AS ChmlCmplncPrptyValue,
  ChmlCmplncPrptyAssgmt.EHSChemicalPhysicalPrptyUnit AS EHSChemicalPhysicalPrptyUnit,
  ChmlCmplncPrptyAssgmt._EHSChemicalPhysicalPropUnit._UnitOfMeasureText[1:Language=$session.system_language].UnitOfMeasureLongName AS EHSChemicalPhysPrptyUnitTxt,
  ChmlCmplncPrptyAssgmt.ChmlCmplncPrptyCmntText AS ChmlCmplncPrptyCmntText
INNER JOIN I_ChmlCmplncPrptyAssgmt AS ChmlCmplncPrptyAssgmt ON /* join condition not captured in parsed metadata */
INNER JOIN P_ChmlCmplncAssocAddlPrpty AS ChmlCmplncAssocAddlPrpty ON /* join condition not captured in parsed metadata */
;

Learn More