C_PCEctxPropertyTP

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_PCEctxPropertyTP.
-- 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_PCEctxPropertyTP AS
SELECT
  ActivePCEctxPrptyUUID,
  cast( '' as ehfnd_chm_cas_no ) AS CASNumber,
  cast( '' as ehfnd_chm_lisu_ec_number ) AS ECNumber,
  _ChmlCmplncInfo.MaterialIsSold AS MaterialIsSold,
  _ChmlCmplncInfo.MaterialIsTransported AS MaterialIsTransported,
  _ChmlCmplncInfo.MaterialIsProduced AS MaterialIsProduced,
  _ChmlCmplncInfo.MaterialIsSourced AS MaterialIsSourced,
  _ChmlCmplncInfo.ChmlCmplncProdIsResearched AS ChmlCmplncProdIsResearched,
  _ChmlCmplncInfo.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  LastChangeUTCDateTime,
  LastChangedByUser,
  cast( _LastChangedByUser.UserDescription as ehfnd_bo_lchg_uname_enhanced preserving type ) AS LastChangedByUserName,
  cast( '' as ehfnd_phrs_text ) AS PCEctxAbvOrgnsmNoDataRsnTxt,
  cast( '' as ehfnd_phrs_text ) AS PCEctxAcuteFishNoDataRsnTxt,
  cast( '' as ehfnd_phrs_text ) AS PCEctxAcuteInvbtNoDataRsnTxt,
  cast( '' as ehfnd_phrs_text ) AS PCEctxAqtcPlantNoDataRsnTxt,
  cast( '' as ehfnd_phrs_text ) AS PCEctxChrncFishNoDataRsnTxt,
  cast( '' as ehfnd_phrs_text ) AS PCEctxChrncInvbtNoDataRsnTxt,
  cast( '' as ehfnd_phrs_text ) AS PCEctxMicroOrgnsmNoDataRsnTxt,
  cast( '' as ehfnd_phrs_text ) AS PCEctxSoilOrgnsmNoDataRsnTxt,
  cast( '' as ehfnd_phrs_text ) AS PCEctxTrrstrlPlntNoDataRsnTxt,
  cast( '' as ehfnd_phrs_text ) AS PCEctxStbltyWaterNoDataRsnTxt,
  cast( '' as ehfnd_phrs_text ) AS PCEctxBioDgrdnNoDataRsnTxt,
  cast( '' as ehfnd_phrs_text ) AS PCEctxBioAccmlnNoDataRsnTxt
FROM I_PCEctxPropertyTP AS PCEctxPropertyTP
LEFT OUTER JOIN C_PCEctxAssmtToxicityTP AS _AssmtToxicity ON PCEctxPrptyUUID = _AssmtToxicity.PCEctxPrptyUUID  -- association [0..1]
LEFT OUTER JOIN C_PCEctxAqtcPlantTP AS _AqtcPlant ON PCEctxPrptyUUID = _AqtcPlant.PCEctxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN C_PCEctxAcuteFishTP AS _AcuteFish ON PCEctxPrptyUUID = _AcuteFish.PCEctxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN C_PCEctxChrncFishTP AS _ChrncFish ON PCEctxPrptyUUID = _ChrncFish.PCEctxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN C_PCEctxChrncAqtcInvbtTP AS _ChrncAqtcInvbt ON PCEctxPrptyUUID = _ChrncAqtcInvbt.PCEctxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN C_PCEctxAcuteAqtcInvbtTP AS _AcuteAqtcInvbt ON PCEctxPrptyUUID = _AcuteAqtcInvbt.PCEctxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN C_PCEctxMicroOrgnsmTP AS _MicroOrgnsm ON PCEctxPrptyUUID = _MicroOrgnsm.PCEctxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN C_PCEctxSoilDwellingOrgnsmTP AS _SoilDwellingOrgnsm ON PCEctxPrptyUUID = _SoilDwellingOrgnsm.PCEctxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN C_PCEctxTrrstrlPlantTP AS _TrrstrlPlant ON PCEctxPrptyUUID = _TrrstrlPlant.PCEctxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN C_PCEctxAbvGroundOrgnsmTP AS _AbvGroundOrgnsm ON PCEctxPrptyUUID = _AbvGroundOrgnsm.PCEctxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN C_PCEctxStbltyWaterTP AS _StbltyWater ON PCEctxPrptyUUID = _StbltyWater.PCEctxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN C_PCEctxBioDgrdnTP AS _BioDgrdn ON PCEctxPrptyUUID = _BioDgrdn.PCEctxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN C_PCEctxBioAccmlnTP AS _BioAccmln ON PCEctxPrptyUUID = _BioAccmln.PCEctxPrptyUUID  -- association [0..*]
LEFT OUTER JOIN C_PCEctxTransportTP AS _Transport ON PCEctxPrptyUUID = _Transport.PCEctxPrptyUUID  -- association [0..1]
LEFT OUTER JOIN C_PCEctxOxygenDmndTP AS _OxygenDmnd ON PCEctxPrptyUUID = _OxygenDmnd.PCEctxPrptyUUID  -- association [0..1]
LEFT OUTER JOIN C_PCEctxStbltySoilTP AS _StbltySoil ON PCEctxPrptyUUID = _StbltySoil.PCEctxPrptyUUID  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncInfo AS _ChmlCmplncInfo ON ChmlCmplncInfoUUID = _ChmlCmplncInfo.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _MaterialDataPrimary ON ChmlCmplncInfoUUID = _MaterialDataPrimary.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_PCPrptyRootType AS _PCPrptyRootType ON _PCPrptyRootType.DomainValue = 'EHFNDD_ECT'  -- association [0..1]
LEFT OUTER JOIN C_PCEctxHistory AS _PCEctxHistory ON ChmlCmplncInfoUUID = _PCEctxHistory.ChmlCmplncInfoUUID AND SubstanceUUID = _PCEctxHistory.SubstanceUUID  -- association [0..*]
LEFT OUTER JOIN P_CChmlCmplConstants AS _CChmlCmplConstants ON _CChmlCmplConstants.Constant0 = _CChmlCmplConstants.Constant0  -- association [0..1]
;