What is I_PCTxProperty in SAP S/4HANA?

I_PCTxProperty is a basic CDS view in SAP S/4HANA. Toxicological Property It contains 38 fields.

Which tables does I_PCTxProperty read from?

I_PCTxProperty reads data from: ehfndv_tx.

What VDM layer is I_PCTxProperty?

I_PCTxProperty is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_PCTxProperty

DDL: I_PCTXPROPERTY Type: view BASIC

38 Fields 1 Data Sources 38 Associations

Toxicological Property

I_PCTxProperty is a Basic CDS View that provides data about "Toxicological Property" in SAP S/4HANA. It reads from 1 data source (ehfndv_tx) and exposes 38 fields. It has 38 associations to related views.

Data Sources (1)

Source	Alias	Join Type
ehfndv_tx	ehfndv_tx	from

Associations (38)

Cardinality	Target	Alias	Condition
[0..*]	I_PCTxAcuteOralToxtyStudy	_AcuteOralToxtyStudy	`$projection.PCTxPrptyUUID = _AcuteOralToxtyStudy.PCTxPrptyUUID --Acute Inhalative Toxicty Study`
[0..*]	I_PCTxAcuteInhltnToxtyStudy	_AcuteInhltnToxtyStudy	`$projection.PCTxPrptyUUID = _AcuteInhltnToxtyStudy.PCTxPrptyUUID --Acute Dermal Toxicity Study`
[0..*]	I_PCTxAcuteDermalToxtyStudy	_AcuteDermalToxtyStudy	`$projection.PCTxPrptyUUID = _AcuteDermalToxtyStudy.PCTxPrptyUUID --Skin Irritation Study`
[0..*]	I_PCTxSkinIrritationStudy	_SkinIrritationStudy	`$projection.PCTxPrptyUUID = _SkinIrritationStudy.PCTxPrptyUUID --Eye irritation Study`
[0..*]	I_PCTxEyeIrritationStudy	_EyeIrritationStudy	`$projection.PCTxPrptyUUID = _EyeIrritationStudy.PCTxPrptyUUID --Sensitization Study`
[0..*]	I_PCTxSensitizationStudy	_SensitizationStudy	`$projection.PCTxPrptyUUID = _SensitizationStudy.PCTxPrptyUUID --Reapeted dose toxicity Study`
[0..*]	I_PCTxReptdDoseToxtyStudy	_ReptdDoseToxtyStudy	`$projection.PCTxPrptyUUID = _ReptdDoseToxtyStudy.PCTxPrptyUUID --Carcinogenicity Study`
[0..*]	I_PCTxCrcnGnctyStudy	_CrcnGnctyStudy	`$projection.PCTxPrptyUUID = _CrcnGnctyStudy.PCTxPrptyUUID --Genetic Toxicity in vitro Study`
[0..*]	I_PCTxGentcVitroStudy	_GtvtStudy	`$projection.PCTxPrptyUUID = _GtvtStudy.PCTxPrptyUUID --Genetic Toxicity in Vivo Study`
[0..*]	I_PCTxGentcVivoStudy	_GtvvStudy	`$projection.PCTxPrptyUUID = _GtvvStudy.PCTxPrptyUUID --Reprotoxicity Dev Study`
[0..*]	I_PCTxRprdvDevStudy	_RprdvDevStudy	`$projection.PCTxPrptyUUID = _RprdvDevStudy.PCTxPrptyUUID --Reprotoxicity Frtlty Study`
[0..*]	I_PCTxRprdvFrtltyStudy	_RprdvFertStudy	`$projection.PCTxPrptyUUID = _RprdvFertStudy.PCTxPrptyUUID --Experiences with Human Exposure`
[0..*]	I_PCTxHumanExposure	_HumanExp	`$projection.PCTxPrptyUUID = _HumanExp.PCTxPrptyUUID -- Neurological effects`
[0..*]	I_PCTxNeurologicalEffect	_NeurologicalEffct	`$projection.PCTxPrptyUUID = _NeurologicalEffct.PCTxPrptyUUID -- Other relevant toxicity information`
[0..*]	I_PCTxOtherRelevantInfo	_OtherReleventInfo	`$projection.PCTxPrptyUUID = _OtherReleventInfo.PCTxPrptyUUID -- Other health hazards`
[0..*]	I_PCTxOtherHealthHazard	_OthHlthHzd	`$projection.PCTxPrptyUUID = _OthHlthHzd.PCTxPrptyUUID -- Specific Risk assessment`
[0..*]	I_PCTxSpecificRiskAssmt	_SpecificRiskAssmt	`$projection.PCTxPrptyUUID = _SpecificRiskAssmt.PCTxPrptyUUID --Carcinogenicity Assessment`
[0..*]	I_PCTxCrcnGnctyAssmt	_CrcnGnctyAssmt	`$projection.PCTxPrptyUUID = _CrcnGnctyAssmt.PCTxPrptyUUID --Mutagenicity Assessment`
[0..*]	I_PCTxMtgnctyAssmt	_Mutagenicityassmt	`$projection.PCTxPrptyUUID = _Mutagenicityassmt.PCTxPrptyUUID --Reproductive Toxicity - Fertility Assessment`
[0..*]	I_PCTxRprdvFrtltyAssmt	_RprdvFrtltyAssmt	`$projection.PCTxPrptyUUID = _RprdvFrtltyAssmt.PCTxPrptyUUID --Reproductive Toxicity - Developmental Assessment`
[0..*]	I_PCTxRprdvDevAssmt	_RprdvDevAssmt	`$projection.PCTxPrptyUUID = _RprdvDevAssmt.PCTxPrptyUUID --Reproductive Toxicity - Lactation Assessment`
[0..*]	I_PCTxRprdvLactnAssmt	_RprdvLactnAssmt	`$projection.PCTxPrptyUUID = _RprdvLactnAssmt.PCTxPrptyUUID --STOT - Single Exposure Assessment`
[0..*]	I_PCTxSTOTSingleExpsrAssmt	_STOTSAssmt	`$projection.PCTxPrptyUUID = _STOTSAssmt.PCTxPrptyUUID --STOT - Repeated Exposure Assessment`
[0..*]	I_PCTxSTOTReptdExpsrAssmt	_STOTRAssmt	`$projection.PCTxPrptyUUID = _STOTRAssmt.PCTxPrptyUUID --Aspiration Toxicity Assessment`
[0..*]	I_PCTxAspirationToxtyAssmt	_AspirationAssmt	`$projection.PCTxPrptyUUID = _AspirationAssmt.PCTxPrptyUUID --Acute Oral Toxicity Assessment`
[0..*]	I_PCTxAcuteOralToxtyAssmt	_AcuteOralAssmt	`$projection.PCTxPrptyUUID = _AcuteOralAssmt.PCTxPrptyUUID --Acute Inhalation Toxicity Assessment`
[0..*]	I_PCTxAcuteInhltnToxtyAssmt	_AcuteInhltnAssmt	`$projection.PCTxPrptyUUID = _AcuteInhltnAssmt.PCTxPrptyUUID --Acute Dermal Toxicity Assessment`
[0..*]	I_PCTxAcuteDermalToxtyAssmt	_AcuteDermalAssmt	`$projection.PCTxPrptyUUID = _AcuteDermalAssmt.PCTxPrptyUUID --Skin Irritation Assessment`
[0..*]	I_PCTxSkinIrritationAssmt	_SkinIrritationAssmt	`$projection.PCTxPrptyUUID = _SkinIrritationAssmt.PCTxPrptyUUID --Eye Irritation Assessment`
[0..*]	I_PCTxEyeIrritationAssmt	_EyeIrritationAssmt	`$projection.PCTxPrptyUUID = _EyeIrritationAssmt.PCTxPrptyUUID --Respiratory Sensitization Assessment`
[0..*]	I_PCTxRespiratorySenstnAssmt	_RespiratorySenstnAssmt	`$projection.PCTxPrptyUUID = _RespiratorySenstnAssmt.PCTxPrptyUUID --Skin Sensitization Assessment`
[0..*]	I_PCTxSkinSenstnAssmt	_SkinSenstnAssmt	`$projection.PCTxPrptyUUID = _SkinSenstnAssmt.PCTxPrptyUUID --Referenced CCI`
[0..1]	I_ChmlCmplncInfo	_ChmlCmplncInfo	`$projection.ChmlCmplncInfoUUID = _ChmlCmplncInfo.ChmlCmplncInfoUUID --Referenced Substance`
[0..1]	I_Substance	_Substance	`$projection.SubstanceUUID = _Substance.SubstanceUUID --Link to processing status`
[0..1]	I_PCPrptyProcgSts	_ProcessingStatus	`$projection.PCPrptyProcgSts = _ProcessingStatus.PCPrptyProcgSts --Link to user data`
[0..1]	I_User	_CreatedByUser	`$projection.CreatedByUser = _CreatedByUser.UserID`
[0..1]	I_User	_LastChangedByUser	`$projection.LastChangedByUser = _LastChangedByUser.UserID`
[0..1]	I_User	_ReleasedByUser	`$projection.ReleasedByUser = _ReleasedByUser.UserID`

Annotations (10)

Name	Value	Level
EndUserText.label	Toxicological Property	view
AbapCatalog.sqlViewName	IPCTX	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#MANDATORY	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#BASIC	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.serviceQuality	#B	view

Fields (38)

Key	Field	Source Table	Source Field	Description
	_AcuteOralToxtyStudy		_AcuteOralToxtyStudy
	_AcuteInhltnToxtyStudy		_AcuteInhltnToxtyStudy
	_AcuteDermalToxtyStudy		_AcuteDermalToxtyStudy
	_SkinIrritationStudy		_SkinIrritationStudy
	_EyeIrritationStudy		_EyeIrritationStudy
	_SensitizationStudy		_SensitizationStudy
	_ReptdDoseToxtyStudy		_ReptdDoseToxtyStudy
	_CrcnGnctyStudy		_CrcnGnctyStudy
	_GtvtStudy		_GtvtStudy
	_GtvvStudy		_GtvvStudy
	_RprdvDevStudy		_RprdvDevStudy
	_RprdvFertStudy		_RprdvFertStudy
	_RprdvLactnAssmt		_RprdvLactnAssmt
	_HumanExp		_HumanExp
	_NeurologicalEffct		_NeurologicalEffct
	_OtherReleventInfo		_OtherReleventInfo
	_OthHlthHzd		_OthHlthHzd
	_SpecificRiskAssmt		_SpecificRiskAssmt
	_CrcnGnctyAssmt		_CrcnGnctyAssmt
	_Mutagenicityassmt		_Mutagenicityassmt
	_RprdvFrtltyAssmt		_RprdvFrtltyAssmt
	_RprdvDevAssmt		_RprdvDevAssmt
	_STOTSAssmt		_STOTSAssmt
	_STOTRAssmt		_STOTRAssmt
	_AspirationAssmt		_AspirationAssmt
	_AcuteOralAssmt		_AcuteOralAssmt
	_AcuteInhltnAssmt		_AcuteInhltnAssmt
	_AcuteDermalAssmt		_AcuteDermalAssmt
	_SkinIrritationAssmt		_SkinIrritationAssmt
	_EyeIrritationAssmt		_EyeIrritationAssmt
	_RespiratorySenstnAssmt		_RespiratorySenstnAssmt
	_SkinSenstnAssmt		_SkinSenstnAssmt
	_ChmlCmplncInfo		_ChmlCmplncInfo
	_Substance		_Substance
	_ProcessingStatus		_ProcessingStatus
	_CreatedByUser		_CreatedByUser
	_LastChangedByUser		_LastChangedByUser
	_ReleasedByUser		_ReleasedByUser

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_PCTxProperty.
-- 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_PCTxProperty AS
SELECT *  -- field list not available in parsed metadata
FROM ehfndv_tx
LEFT OUTER JOIN I_PCTxAcuteOralToxtyStudy AS _AcuteOralToxtyStudy ON PCTxPrptyUUID = _AcuteOralToxtyStudy.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxAcuteInhltnToxtyStudy AS _AcuteInhltnToxtyStudy ON PCTxPrptyUUID = _AcuteInhltnToxtyStudy.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxAcuteDermalToxtyStudy AS _AcuteDermalToxtyStudy ON PCTxPrptyUUID = _AcuteDermalToxtyStudy.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxSkinIrritationStudy AS _SkinIrritationStudy ON PCTxPrptyUUID = _SkinIrritationStudy.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxEyeIrritationStudy AS _EyeIrritationStudy ON PCTxPrptyUUID = _EyeIrritationStudy.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxSensitizationStudy AS _SensitizationStudy ON PCTxPrptyUUID = _SensitizationStudy.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxReptdDoseToxtyStudy AS _ReptdDoseToxtyStudy ON PCTxPrptyUUID = _ReptdDoseToxtyStudy.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxCrcnGnctyStudy AS _CrcnGnctyStudy ON PCTxPrptyUUID = _CrcnGnctyStudy.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxGentcVitroStudy AS _GtvtStudy ON PCTxPrptyUUID = _GtvtStudy.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxGentcVivoStudy AS _GtvvStudy ON PCTxPrptyUUID = _GtvvStudy.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxRprdvDevStudy AS _RprdvDevStudy ON PCTxPrptyUUID = _RprdvDevStudy.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxRprdvFrtltyStudy AS _RprdvFertStudy ON PCTxPrptyUUID = _RprdvFertStudy.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxHumanExposure AS _HumanExp ON PCTxPrptyUUID = _HumanExp.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxNeurologicalEffect AS _NeurologicalEffct ON PCTxPrptyUUID = _NeurologicalEffct.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxOtherRelevantInfo AS _OtherReleventInfo ON PCTxPrptyUUID = _OtherReleventInfo.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxOtherHealthHazard AS _OthHlthHzd ON PCTxPrptyUUID = _OthHlthHzd.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxSpecificRiskAssmt AS _SpecificRiskAssmt ON PCTxPrptyUUID = _SpecificRiskAssmt.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxCrcnGnctyAssmt AS _CrcnGnctyAssmt ON PCTxPrptyUUID = _CrcnGnctyAssmt.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxMtgnctyAssmt AS _Mutagenicityassmt ON PCTxPrptyUUID = _Mutagenicityassmt.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxRprdvFrtltyAssmt AS _RprdvFrtltyAssmt ON PCTxPrptyUUID = _RprdvFrtltyAssmt.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxRprdvDevAssmt AS _RprdvDevAssmt ON PCTxPrptyUUID = _RprdvDevAssmt.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxRprdvLactnAssmt AS _RprdvLactnAssmt ON PCTxPrptyUUID = _RprdvLactnAssmt.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxSTOTSingleExpsrAssmt AS _STOTSAssmt ON PCTxPrptyUUID = _STOTSAssmt.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxSTOTReptdExpsrAssmt AS _STOTRAssmt ON PCTxPrptyUUID = _STOTRAssmt.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxAspirationToxtyAssmt AS _AspirationAssmt ON PCTxPrptyUUID = _AspirationAssmt.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxAcuteOralToxtyAssmt AS _AcuteOralAssmt ON PCTxPrptyUUID = _AcuteOralAssmt.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxAcuteInhltnToxtyAssmt AS _AcuteInhltnAssmt ON PCTxPrptyUUID = _AcuteInhltnAssmt.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxAcuteDermalToxtyAssmt AS _AcuteDermalAssmt ON PCTxPrptyUUID = _AcuteDermalAssmt.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxSkinIrritationAssmt AS _SkinIrritationAssmt ON PCTxPrptyUUID = _SkinIrritationAssmt.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxEyeIrritationAssmt AS _EyeIrritationAssmt ON PCTxPrptyUUID = _EyeIrritationAssmt.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxRespiratorySenstnAssmt AS _RespiratorySenstnAssmt ON PCTxPrptyUUID = _RespiratorySenstnAssmt.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_PCTxSkinSenstnAssmt AS _SkinSenstnAssmt ON PCTxPrptyUUID = _SkinSenstnAssmt.PCTxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncInfo AS _ChmlCmplncInfo ON ChmlCmplncInfoUUID = _ChmlCmplncInfo.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_Substance AS _Substance ON SubstanceUUID = _Substance.SubstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_PCPrptyProcgSts AS _ProcessingStatus ON PCPrptyProcgSts = _ProcessingStatus.PCPrptyProcgSts  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ReleasedByUser ON ReleasedByUser = _ReleasedByUser.UserID  -- association [0..1]
;

Depth:

I_PCTxProperty view

ehfndv_tx

I_PCTxPropertyTP view
R_PCTxPropertyTP view_entity