R_CmplRqRsltGHSConcnAcuteEstTP

DDL: R_CMPLRQRSLTGHSCONCNACUTEESTTP Type: view_entity TRANSACTIONAL
61 Fields 1 Data Sources 10 Associations

Acute Toxicity Estimate ATE - TP

R_CmplRqRsltGHSConcnAcuteEstTP is a Transactional CDS View that provides data about "Acute Toxicity Estimate ATE - TP" in SAP S/4HANA. It reads from 1 data source (I_CmplRqRsltGHSConcnAcuteEst) and exposes 61 fields with key field GHSClfnAcuteToxtyEstUUID. It has 10 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRsltGHSConcnAcuteEst I_CmplRqRsltGHSConcnAcuteEst from

Associations (10)

CardinalityTargetAliasCondition
[0..1] I_ProdCmplncPhrs _GHSClfnOralToxtyMethPhrs $projection.GHSClfnOralToxtyMethUUID = _GHSClfnOralToxtyMethPhrs.ProdCmplncPhrsUUID
[0..1] I_ProdCmplncPhrs _GHSClfnDermalToxtyMethPhrs $projection.GHSClfnDermalToxtyMethUUID = _GHSClfnDermalToxtyMethPhrs.ProdCmplncPhrsUUID
[0..1] I_ProdCmplncPhrs _GHSClfnInhltnToxtyAtmsphPhrs $projection.GHSClfnInhltnToxtyAtmsphUUID = _GHSClfnInhltnToxtyAtmsphPhrs.ProdCmplncPhrsUUID
[0..1] I_ProdCmplncPhrs _GHSClfnInhltnToxtyMethPhrs $projection.GHSClfnInhltnToxtyMethUUID = _GHSClfnInhltnToxtyMethPhrs.ProdCmplncPhrsUUID
[0..1] I_ProdCmplncPhrs _GHSClfnSubstOralMethPhrs $projection.GHSClfnSubstOralMethUUID = _GHSClfnSubstOralMethPhrs.ProdCmplncPhrsUUID
[0..1] I_ProdCmplncPhrs _GHSClfnSubstInhltnMethPhrs $projection.GHSClfnSubstInhltnMethUUID = _GHSClfnSubstInhltnMethPhrs.ProdCmplncPhrsUUID
[0..1] I_ProdCmplncPhrs _GHSClfnSubstDermalMethPhrs $projection.GHSClfnSubstDermalMethUUID = _GHSClfnSubstDermalMethPhrs.ProdCmplncPhrsUUID
[0..1] I_ProdCmplncPhrs _GHSClfnMFctrAddlInfo1Phrs $projection.GHSClfnMFctrAddlInfo1UUID = _GHSClfnMFctrAddlInfo1Phrs.ProdCmplncPhrsUUID
[0..1] I_ProdCmplncPhrs _GHSClfnMFctrAddlInfo2Phrs $projection.GHSClfnMFctrAddlInfo2UUID = _GHSClfnMFctrAddlInfo2Phrs.ProdCmplncPhrsUUID
[0..1] I_ProdCmplncPhrs _GHSClfnMFctrAddlInfo3Phrs $projection.GHSClfnMFctrAddlInfo3UUID = _GHSClfnMFctrAddlInfo3Phrs.ProdCmplncPhrsUUID

Annotations (8)

NameValueLevelField
EndUserText.label Acute Toxicity Estimate ATE - TP view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY GHSClfnAcuteToxtyEstUUID GHSClfnAcuteToxtyEstUUID Acute Toxicity Estimation UUID
CmplRqRsltUUID CmplRqRsltUUID SDS Assessment
GHSClfnOralToxtyLowrQtyOptr GHSClfnOralToxtyLowrQtyOptr Operator of Lower Limit
GHSClfnOralToxtyLowrQty GHSClfnOralToxtyLowrQty ATE Acute Oral Toxicity Lower Limit Qty
GHSClfnOralToxtyLowrQtyTxt GHSClfnOralToxtyLowrQtyTxt ATE Acute Oral Toxicity Lower Limit Text
GHSClfnOralToxtyUprQtyOptr GHSClfnOralToxtyUprQtyOptr Operator of Upper Limit
GHSClfnOralToxtyUprQty GHSClfnOralToxtyUprQty ATE Acute Oral Toxicity Upper Limit Qty
GHSClfnOralToxtyUprQtyTxt GHSClfnOralToxtyUprQtyTxt ATE Acute Oral Toxicity Upper Limit Text
GHSClfnOralToxtyUoM GHSClfnOralToxtyUoM ATE Acute Oral Toxicity Unit
GHSClfnOralToxtyMethUUID GHSClfnOralToxtyMethUUID Method
GHSClfnSubstOralMethUUID GHSClfnSubstOralMethUUID Method
GHSClfnInhltnToxtyLowrQtyOptr GHSClfnInhltnToxtyLowrQtyOptr Operator of Lower Limit
GHSClfnInhltnToxtyLowrQty GHSClfnInhltnToxtyLowrQty ATE Acute Inhalation Toxity Lowr Lmt Qty
GHSClfnInhltnToxtyLowrQtyTxt GHSClfnInhltnToxtyLowrQtyTxt ATE Acute Inhalation Toxty Lower Lmt Txt
GHSClfnInhltnToxtyUprQtyOptr GHSClfnInhltnToxtyUprQtyOptr Operator of Upper Limit
GHSClfnInhltnToxtyUprQty GHSClfnInhltnToxtyUprQty ATE Acute Inhalation Toxty Upper Lmt Qty
GHSClfnInhltnToxtyUprQtyTxt GHSClfnInhltnToxtyUprQtyTxt ATE Acute Inhalation Toxty Upper Lmt Txt
GHSClfnInhltnToxtyUoM GHSClfnInhltnToxtyUoM ATE Acute Inhalation Toxicity Unit
GHSClfnInhltnToxtyMethUUID GHSClfnInhltnToxtyMethUUID Method
GHSClfnSubstInhltnMethUUID GHSClfnSubstInhltnMethUUID Method
GHSClfnInhltnToxtyAtmsphUUID GHSClfnInhltnToxtyAtmsphUUID Test Atmosphere
GHSClfnDermalToxtyLowrQtyOptr GHSClfnDermalToxtyLowrQtyOptr Operator of Lower Limit
GHSClfnDermalToxtyLowrQty GHSClfnDermalToxtyLowrQty ATE Acute Dermal Toxicity Lower Lmt Qty
GHSClfnDermalToxtyLowrQtyTxt GHSClfnDermalToxtyLowrQtyTxt ATE Acute Dermal Toxicity Lower Lmt Txt
GHSClfnDermalToxtyUprQtyOptr GHSClfnDermalToxtyUprQtyOptr Operator of Upper Limit
GHSClfnDermalToxtyUprQty GHSClfnDermalToxtyUprQty ATE Acute Dermal Toxicity Upper Lmt Qty
GHSClfnDermalToxtyUprQtyTxt GHSClfnDermalToxtyUprQtyTxt ATE Acute Dermal Toxicity Upper Lmt Txt
GHSClfnDermalToxtyUoM GHSClfnDermalToxtyUoM ATE Acute Dermal Toxicity Unit
GHSClfnDermalToxtyMethUUID GHSClfnDermalToxtyMethUUID Method
GHSClfnSubstDermalMethUUID GHSClfnSubstDermalMethUUID Method
GHSClfnMFctrAcuteAqtcToxtyFctr GHSClfnMFctrAcuteAqtcToxtyQty M-Factor (Acute Aquatic Toxicity)
GHSClfnMFctrChrncAqtcToxtyFctr GHSClfnMFctrChrncAqtcToxtyQty M-Factor (Chronic Aquatic Toxicity)
GHSClfnMFctrAddlInfo1UUID GHSClfnMFctrAddlInfo1UUID Additional Regulatory Information
GHSClfnMFctrAddlInfo2UUID GHSClfnMFctrAddlInfo2UUID Additional Regulatory Information
GHSClfnMFctrAddlInfo3UUID GHSClfnMFctrAddlInfo3UUID Additional Regulatory Information
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_CmplRqRsltGHSClfnAssmt _CmplRqRsltGHSClfnAssmt
_CreatedByUser _CreatedByUser
_DermalLowerLimit _DermalLowerLimit
_DermalUpperLimit _DermalUpperLimit
_InhalationLowerLimit _InhalationLowerLimit
_InhalationUpperLimit _InhalationUpperLimit
_LastChangedByUser _LastChangedByUser
_OperatorLowerLimit _OperatorLowerLimit
_OperatorUpperLimit _OperatorUpperLimit
_UoMDermalToxty _UoMDermalToxty
_UoMInhalationToxty _UoMInhalationToxty
_UoMOralToxty _UoMOralToxty
_GHSClfnOralToxtyMethPhrs _GHSClfnOralToxtyMethPhrs
_GHSClfnDermalToxtyMethPhrs _GHSClfnDermalToxtyMethPhrs
_GHSClfnInhltnToxtyAtmsphPhrs _GHSClfnInhltnToxtyAtmsphPhrs
_GHSClfnInhltnToxtyMethPhrs _GHSClfnInhltnToxtyMethPhrs
_GHSClfnSubstOralMethPhrs _GHSClfnSubstOralMethPhrs
_GHSClfnSubstInhltnMethPhrs _GHSClfnSubstInhltnMethPhrs
_GHSClfnSubstDermalMethPhrs _GHSClfnSubstDermalMethPhrs
_GHSClfnMFctrAddlInfo1Phrs _GHSClfnMFctrAddlInfo1Phrs
_GHSClfnMFctrAddlInfo2Phrs _GHSClfnMFctrAddlInfo2Phrs
_GHSClfnMFctrAddlInfo3Phrs _GHSClfnMFctrAddlInfo3Phrs

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 R_CmplRqRsltGHSConcnAcuteEstTP.
-- 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 R_CmplRqRsltGHSConcnAcuteEstTP AS
SELECT
  GHSClfnAcuteToxtyEstUUID,
  CmplRqRsltUUID,
  GHSClfnOralToxtyLowrQtyOptr,
  GHSClfnOralToxtyLowrQty,
  GHSClfnOralToxtyLowrQtyTxt,
  GHSClfnOralToxtyUprQtyOptr,
  GHSClfnOralToxtyUprQty,
  GHSClfnOralToxtyUprQtyTxt,
  GHSClfnOralToxtyUoM,
  GHSClfnOralToxtyMethUUID,
  GHSClfnSubstOralMethUUID,
  GHSClfnInhltnToxtyLowrQtyOptr,
  GHSClfnInhltnToxtyLowrQty,
  GHSClfnInhltnToxtyLowrQtyTxt,
  GHSClfnInhltnToxtyUprQtyOptr,
  GHSClfnInhltnToxtyUprQty,
  GHSClfnInhltnToxtyUprQtyTxt,
  GHSClfnInhltnToxtyUoM,
  GHSClfnInhltnToxtyMethUUID,
  GHSClfnSubstInhltnMethUUID,
  GHSClfnInhltnToxtyAtmsphUUID,
  GHSClfnDermalToxtyLowrQtyOptr,
  GHSClfnDermalToxtyLowrQty,
  GHSClfnDermalToxtyLowrQtyTxt,
  GHSClfnDermalToxtyUprQtyOptr,
  GHSClfnDermalToxtyUprQty,
  GHSClfnDermalToxtyUprQtyTxt,
  GHSClfnDermalToxtyUoM,
  GHSClfnDermalToxtyMethUUID,
  GHSClfnSubstDermalMethUUID,
  GHSClfnMFctrAcuteAqtcToxtyQty AS GHSClfnMFctrAcuteAqtcToxtyFctr,
  GHSClfnMFctrChrncAqtcToxtyQty AS GHSClfnMFctrChrncAqtcToxtyFctr,
  GHSClfnMFctrAddlInfo1UUID,
  GHSClfnMFctrAddlInfo2UUID,
  GHSClfnMFctrAddlInfo3UUID,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM I_CmplRqRsltGHSConcnAcuteEst
LEFT OUTER JOIN I_ProdCmplncPhrs AS _GHSClfnOralToxtyMethPhrs ON GHSClfnOralToxtyMethUUID = _GHSClfnOralToxtyMethPhrs.ProdCmplncPhrsUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncPhrs AS _GHSClfnDermalToxtyMethPhrs ON GHSClfnDermalToxtyMethUUID = _GHSClfnDermalToxtyMethPhrs.ProdCmplncPhrsUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncPhrs AS _GHSClfnInhltnToxtyAtmsphPhrs ON GHSClfnInhltnToxtyAtmsphUUID = _GHSClfnInhltnToxtyAtmsphPhrs.ProdCmplncPhrsUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncPhrs AS _GHSClfnInhltnToxtyMethPhrs ON GHSClfnInhltnToxtyMethUUID = _GHSClfnInhltnToxtyMethPhrs.ProdCmplncPhrsUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncPhrs AS _GHSClfnSubstOralMethPhrs ON GHSClfnSubstOralMethUUID = _GHSClfnSubstOralMethPhrs.ProdCmplncPhrsUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncPhrs AS _GHSClfnSubstInhltnMethPhrs ON GHSClfnSubstInhltnMethUUID = _GHSClfnSubstInhltnMethPhrs.ProdCmplncPhrsUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncPhrs AS _GHSClfnSubstDermalMethPhrs ON GHSClfnSubstDermalMethUUID = _GHSClfnSubstDermalMethPhrs.ProdCmplncPhrsUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncPhrs AS _GHSClfnMFctrAddlInfo1Phrs ON GHSClfnMFctrAddlInfo1UUID = _GHSClfnMFctrAddlInfo1Phrs.ProdCmplncPhrsUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncPhrs AS _GHSClfnMFctrAddlInfo2Phrs ON GHSClfnMFctrAddlInfo2UUID = _GHSClfnMFctrAddlInfo2Phrs.ProdCmplncPhrsUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncPhrs AS _GHSClfnMFctrAddlInfo3Phrs ON GHSClfnMFctrAddlInfo3UUID = _GHSClfnMFctrAddlInfo3Phrs.ProdCmplncPhrsUUID  -- association [0..1]
;

Learn More