I_PCStRct

DDL: I_PCSTRCT Type: view_entity BASIC
27 Fields 1 Data Sources 3 Associations

Stability and Reactivity

I_PCStRct is a Basic CDS View that provides data about "Stability and Reactivity" in SAP S/4HANA. It reads from 1 data source (ehfndd_star) and exposes 27 fields with key field PCStRctUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
ehfndd_star ehfndd_star from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ChmlCmplncInfo _ChmlCmplncInfo $projection.ChmlCmplncInfoUUID = _ChmlCmplncInfo.ChmlCmplncInfoUUID
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Stability and Reactivity view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY PCStRctUUID pcstrctuuid
ChmlCmplncInfoUUID chmlcmplncinfouuid Chemical Compliance Information PP
PCPrptyProcgSts pcprptyprocgsts Processing Status
PCPrptyReleasedBy pcprptyreleasedby Released By
ValidityStartDateTime validitystartdatetime Valid From Timestamp
ValidityEndDateTime validityenddatetime Valid To Timestamp
PCStRctReactivityNote pcstrctreactivitynote
PCStRctChmlStabilityNote pcstrctchmlstabilitynote
PCStRctConditionsToAvoidNote pcstrctconditionstoavoidnote
PCStRctTempToAvoidLowrLmtOptr pcstrcttemptoavoidlowrlmtoptr Operator of Lower Limit
PCStRctTempToAvoidLowrLmtQty pcstrcttemptoavoidlowrlmtqty
PCStRctTempToAvdLowrLmtQtyVal pcstrcttemptoavdlowrlmtqtyval
PCStRctTempToAvoidUprLmtOptr pcstrcttemptoavoiduprlmtoptr Operator of Upper Limit
PCStRctTempToAvoidUprLmtQty pcstrcttemptoavoiduprlmtqty
PCStRctTempToAvoidUprLmtQtyVal pcstrcttemptoavoiduprlmtqtyval
PCStRctTempToAvoidUnit pcstrcttemptoavoidunit Unit of Measurement
PCStRctHzRctnsNote pcstrcthzrctnsnote
PCStRctIncompatibleMatlsNote pcstrctincompatiblematlsnote
PCStRctHzDePrdsNote pcstrcthzdeprdsnote
PCStRctHzDePrdsNoDtaRsnUUID pcstrcthzdeprdsnodtarsnuuid
CreationUTCDateTime creationutcdatetime Time Stamp
CreatedByUser createdbyuser User Name
LastChangeUTCDateTime lastchangeutcdatetime Time Stamp
LastChangedByUser lastchangedbyuser User Name
_ChmlCmplncInfo _ChmlCmplncInfo
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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_PCStRct.
-- 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_PCStRct AS
SELECT
  PCStRctUUID,
  ChmlCmplncInfoUUID,
  PCPrptyProcgSts,
  PCPrptyReleasedBy,
  ValidityStartDateTime,
  ValidityEndDateTime,
  PCStRctReactivityNote,
  PCStRctChmlStabilityNote,
  PCStRctConditionsToAvoidNote,
  PCStRctTempToAvoidLowrLmtOptr,
  PCStRctTempToAvoidLowrLmtQty,
  PCStRctTempToAvdLowrLmtQtyVal,
  PCStRctTempToAvoidUprLmtOptr,
  PCStRctTempToAvoidUprLmtQty,
  PCStRctTempToAvoidUprLmtQtyVal,
  PCStRctTempToAvoidUnit,
  PCStRctHzRctnsNote,
  PCStRctIncompatibleMatlsNote,
  PCStRctHzDePrdsNote,
  PCStRctHzDePrdsNoDtaRsnUUID,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser
FROM ehfndd_star
LEFT OUTER JOIN I_ChmlCmplncInfo AS _ChmlCmplncInfo ON ChmlCmplncInfoUUID = _ChmlCmplncInfo.ChmlCmplncInfoUUID  -- 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]
;

Learn More