P_SelfReactiveSubstance

DDL: P_SELFREACTIVESUBSTANCE SQL: PSELFREACTIVE Type: view COMPOSITE
26 Fields 2 Data Sources 1 Associations

P_SelfReactiveSubstance is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_SubstActiveDraftLstdSubst, I_CmplRqVersSelfReactvSubst) and exposes 26 fields with key fields CmplRqVersSelfReactvSubstUUID, ActiveSubstanceUUID. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_SubstActiveDraftLstdSubst _ListedSubstance inner
I_CmplRqVersSelfReactvSubst SelfReactiveSubstance from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_DngrsGdsSelfReactvPrntT _SelfReactvPrintedName $projection.CmplRqVersSelfReactvSubstUUID = _SelfReactvPrintedName.CmplRqVersSelfReactvSubstUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PSELFREACTIVE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CmplRqVersSelfReactvSubstUUID I_CmplRqVersSelfReactvSubst CmplRqVersSelfReactvSubstUUID UUID
KEY ActiveSubstanceUUID I_SubstActiveDraftLstdSubst ActiveSubstanceUUID Substance
SubstanceListUUID I_CmplRqVersSelfReactvSubst SubstanceListUUID Substance List
CmplRqVersUUID I_CmplRqVersSelfReactvSubst CmplRqVersUUID NodeID
ProdCmplncDngrsGdsIdnNmbrType I_CmplRqVersSelfReactvSubst ProdCmplncDngrsGdsIdnNmbrType Number (Prefix)
ProdCmplncDngrsGdsIdnNmbr I_CmplRqVersSelfReactvSubst ProdCmplncDngrsGdsIdnNmbr Number
ListedSubstance I_CmplRqVersSelfReactvSubst ListedSubstance Listed Substance
DngrsGdsPositionOnSource I_CmplRqVersSelfReactvSubst DngrsGdsPositionOnSource Position on Source
DngrsGdsSelfReactvName I_CmplRqVersSelfReactvSubst DngrsGdsSelfReactvName Self-Reactive Substance Name
DngrsGdsConcnLowrQtyOptr I_CmplRqVersSelfReactvSubst DngrsGdsConcnLowrQtyOptr Operator for Lower Limit
DngrsGdsConcnLowrQty I_CmplRqVersSelfReactvSubst DngrsGdsConcnLowrQty Concentration Lower Value
DngrsGdsConcnLowrQtyUnit I_CmplRqVersSelfReactvSubst DngrsGdsConcnLowrQtyUnit Unit of the Concentration Lower Limit
DngrsGdsHasConcnLowrQty I_CmplRqVersSelfReactvSubst DngrsGdsHasConcnLowrQty Concentration Lower Quantity Indicator
DngrsGdsConcnUprQtyOptr I_CmplRqVersSelfReactvSubst DngrsGdsConcnUprQtyOptr Operator for Upper Limit
DngrsGdsConcnUprQty I_CmplRqVersSelfReactvSubst DngrsGdsConcnUprQty Concentration Upper Value
DngrsGdsConcnUprQtyUnit I_CmplRqVersSelfReactvSubst DngrsGdsConcnUprQtyUnit Unit of Concentration Upper Limit
DngrsGdsHasConcnUprQty I_CmplRqVersSelfReactvSubst DngrsGdsHasConcnUprQty Concentration Upper Quantity Indicator
DngrsGdsSelfReactvAddlInfoTxt I_CmplRqVersSelfReactvSubst DngrsGdsSelfReactvAddlInfoTxt Additional Info Self-reactive Substance
DngrsGdsHasControlTemp I_CmplRqVersSelfReactvSubst DngrsGdsHasControlTemp Control Temperature Indicator
DangerousGoodsControlTemp I_CmplRqVersSelfReactvSubst DangerousGoodsControlTemp Control Temperature
DangerousGoodsControlTempUnit I_CmplRqVersSelfReactvSubst DangerousGoodsControlTempUnit Control Temperature Unit
DngrsGdsHasEmergencyTemp I_CmplRqVersSelfReactvSubst DngrsGdsHasEmergencyTemp Emergency Temperature Indicator
DangerousGoodsEmergencyTemp I_CmplRqVersSelfReactvSubst DangerousGoodsEmergencyTemp Emergency Temperature
DangerousGoodsEmgyTempUnit I_CmplRqVersSelfReactvSubst DangerousGoodsEmgyTempUnit Emergency Temperature Unit
SubstanceUUID I_SubstActiveDraftLstdSubst SubstanceUUID Substance
_SelfReactvPrintedName _SelfReactvPrintedName

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 P_SelfReactiveSubstance.
-- 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.
-- SQL view name: PSELFREACTIVE

CREATE VIEW P_SelfReactiveSubstance AS
SELECT
  SelfReactiveSubstance.CmplRqVersSelfReactvSubstUUID AS CmplRqVersSelfReactvSubstUUID,
  _ListedSubstance.ActiveSubstanceUUID AS ActiveSubstanceUUID,
  SelfReactiveSubstance.SubstanceListUUID AS SubstanceListUUID,
  SelfReactiveSubstance.CmplRqVersUUID AS CmplRqVersUUID,
  SelfReactiveSubstance.ProdCmplncDngrsGdsIdnNmbrType AS ProdCmplncDngrsGdsIdnNmbrType,
  SelfReactiveSubstance.ProdCmplncDngrsGdsIdnNmbr AS ProdCmplncDngrsGdsIdnNmbr,
  SelfReactiveSubstance.ListedSubstance AS ListedSubstance,
  SelfReactiveSubstance.DngrsGdsPositionOnSource AS DngrsGdsPositionOnSource,
  SelfReactiveSubstance.DngrsGdsSelfReactvName AS DngrsGdsSelfReactvName,
  SelfReactiveSubstance.DngrsGdsConcnLowrQtyOptr AS DngrsGdsConcnLowrQtyOptr,
  SelfReactiveSubstance.DngrsGdsConcnLowrQty AS DngrsGdsConcnLowrQty,
  SelfReactiveSubstance.DngrsGdsConcnLowrQtyUnit AS DngrsGdsConcnLowrQtyUnit,
  SelfReactiveSubstance.DngrsGdsHasConcnLowrQty AS DngrsGdsHasConcnLowrQty,
  SelfReactiveSubstance.DngrsGdsConcnUprQtyOptr AS DngrsGdsConcnUprQtyOptr,
  SelfReactiveSubstance.DngrsGdsConcnUprQty AS DngrsGdsConcnUprQty,
  SelfReactiveSubstance.DngrsGdsConcnUprQtyUnit AS DngrsGdsConcnUprQtyUnit,
  SelfReactiveSubstance.DngrsGdsHasConcnUprQty AS DngrsGdsHasConcnUprQty,
  SelfReactiveSubstance.DngrsGdsSelfReactvAddlInfoTxt AS DngrsGdsSelfReactvAddlInfoTxt,
  SelfReactiveSubstance.DngrsGdsHasControlTemp AS DngrsGdsHasControlTemp,
  SelfReactiveSubstance.DangerousGoodsControlTemp AS DangerousGoodsControlTemp,
  SelfReactiveSubstance.DangerousGoodsControlTempUnit AS DangerousGoodsControlTempUnit,
  SelfReactiveSubstance.DngrsGdsHasEmergencyTemp AS DngrsGdsHasEmergencyTemp,
  SelfReactiveSubstance.DangerousGoodsEmergencyTemp AS DangerousGoodsEmergencyTemp,
  SelfReactiveSubstance.DangerousGoodsEmgyTempUnit AS DangerousGoodsEmgyTempUnit,
  _ListedSubstance.SubstanceUUID AS SubstanceUUID
FROM I_CmplRqVersSelfReactvSubst AS SelfReactiveSubstance
INNER JOIN I_SubstActiveDraftLstdSubst AS _ListedSubstance ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DngrsGdsSelfReactvPrntT AS _SelfReactvPrintedName ON CmplRqVersSelfReactvSubstUUID = _SelfReactvPrintedName.CmplRqVersSelfReactvSubstUUID  -- association [0..*]
;

Learn More