C_PCStRctTP

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_PCStRctTP.
-- 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_PCStRctTP AS
SELECT
  PCStRctUUID,
  PCPrptyProcgSts,
  _PCStRctReleased.PCStRctUUID AS PCStRctReleasedVersionUUID,
  PCPrptyReleasedBy,
  ValidityStartDateTime,
  ValidityEndDateTime,
  PCStRctTempToAvoidLowrLmtOptr,
  PCStRctTempToAvoidLowrLmtQty,
  PCStRctTempToAvoidUprLmtOptr,
  PCStRctTempToAvoidUprLmtQty,
  PCStRctTempToAvoidUnit,
  PCStRctReactivityNote,
  PCStRctChmlStabilityNote,
  PCStRctConditionsToAvoidNote,
  PCStRctIncompatibleMatlsNote,
  PCStRctHzDePrdsNote,
  PCStRctHzRctnsNote,
  PCStRctHzDePrdsNoDtaRsnUUID,
  _PCPrptyPhraseText.ProdCmplncPhrsText AS ProdCmplncPhrsText,
  PCStRctTempToAvdLowrLmtQtyVal,
  PCStRctTempToAvoidUprLmtQtyVal,
  _PCPrptyRootType._Text[ 1: Language = $session.system_language ].PCPrptyRootTypeName AS PCPrptyRootTypeName,
  virtual ChmlCmplncTypeImageURL : abap.char( 255 ) AS char255,
  _ChmlCmplncInfo.MaterialIsSold AS MaterialIsSold,
  _ChmlCmplncInfo.MaterialIsTransported AS MaterialIsTransported,
  _ChmlCmplncInfo.MaterialIsProduced AS MaterialIsProduced,
  _ChmlCmplncInfo.MaterialIsSourced AS MaterialIsSourced,
  _ChmlCmplncInfo.ChmlCmplncProdIsResearched AS ChmlCmplncProdIsResearched,
  _ChmlCmplncInfo.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser,
  cast( _LastChangedByUser.UserDescription as ehfnd_bo_lchg_uname_enhanced preserving type ) AS LastChangedByUserName
FROM R_PCStRctTP
LEFT OUTER JOIN C_PCStRctHistory AS _PCStRctHistory ON ChmlCmplncInfoUUID = _PCStRctHistory.ChmlCmplncInfoUUID  -- association [0..*]
;