P_OrganicPeroxide

DDL: P_ORGANICPEROXIDE SQL: PORGPRXG Type: view COMPOSITE
26 Fields 2 Data Sources 1 Associations

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

Data Sources (2)

SourceAliasJoin Type
I_SubstActiveDraftLstdSubst _ListedSubstance inner
I_CmplRqVersOrganicPrxd OrganicPeroxid from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CmplRqVersDngrsGdsPrxdPrntT _OrgPeroxidePrintedName $projection.CmplRqVersOrganicPrxdUUID = _OrgPeroxidePrintedName.CmplRqVersOrganicPrxdUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PORGPRXG 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 CmplRqVersOrganicPrxdUUID I_CmplRqVersOrganicPrxd CmplRqVersOrganicPrxdUUID UUID
ProdCmplncDngrsGdsIdnNmbrType I_CmplRqVersOrganicPrxd ProdCmplncDngrsGdsIdnNmbrType Number (Prefix)
ProdCmplncDngrsGdsIdnNmbr I_CmplRqVersOrganicPrxd ProdCmplncDngrsGdsIdnNmbr Number
ListedSubstance I_CmplRqVersOrganicPrxd ListedSubstance Listed Substance
DngrsGdsPositionOnSource I_CmplRqVersOrganicPrxd DngrsGdsPositionOnSource Position on Source
SubstanceListUUID I_CmplRqVersOrganicPrxd SubstanceListUUID Substance List
CmplRqVersUUID I_CmplRqVersOrganicPrxd CmplRqVersUUID NodeID
DngrsGdsOrganicPrxdName I_CmplRqVersOrganicPrxd DngrsGdsOrganicPrxdName Organic Peroxide Name
DngrsGdsConcnLowrQtyOptr I_CmplRqVersOrganicPrxd DngrsGdsConcnLowrQtyOptr Operator for Lower Limit
DngrsGdsConcnLowrQty I_CmplRqVersOrganicPrxd DngrsGdsConcnLowrQty Concentration Lower Value
DngrsGdsConcnLowrQtyUnit I_CmplRqVersOrganicPrxd DngrsGdsConcnLowrQtyUnit Unit of the Concentration Lower Limit
DngrsGdsHasConcnLowrQty I_CmplRqVersOrganicPrxd DngrsGdsHasConcnLowrQty Concentration Lower Quantity Indicator
DngrsGdsConcnUprQtyOptr I_CmplRqVersOrganicPrxd DngrsGdsConcnUprQtyOptr Operator for Upper Limit
DngrsGdsConcnUprQty I_CmplRqVersOrganicPrxd DngrsGdsConcnUprQty Concentration Upper Value
DngrsGdsConcnUprQtyUnit I_CmplRqVersOrganicPrxd DngrsGdsConcnUprQtyUnit Unit of Concentration Upper Limit
DngrsGdsHasConcnUprQty I_CmplRqVersOrganicPrxd DngrsGdsHasConcnUprQty Concentration Upper Quantity Indicator
DngrsGdsOrganicPrxdAddlInfoTxt I_CmplRqVersOrganicPrxd DngrsGdsOrganicPrxdAddlInfoTxt Additional Info
DngrsGdsHasControlTemp I_CmplRqVersOrganicPrxd DngrsGdsHasControlTemp Control Temperature Indicator
DangerousGoodsControlTemp I_CmplRqVersOrganicPrxd DangerousGoodsControlTemp Control Temperature
DangerousGoodsControlTempUnit I_CmplRqVersOrganicPrxd DangerousGoodsControlTempUnit Control Temperature Unit
DngrsGdsHasEmergencyTemp I_CmplRqVersOrganicPrxd DngrsGdsHasEmergencyTemp Emergency Temperature Indicator
DangerousGoodsEmergencyTemp I_CmplRqVersOrganicPrxd DangerousGoodsEmergencyTemp Emergency Temperature
DangerousGoodsEmgyTempUnit I_CmplRqVersOrganicPrxd DangerousGoodsEmgyTempUnit Emergency Temperature Unit
SubstanceUUID I_SubstActiveDraftLstdSubst SubstanceUUID Substance
ActiveSubstanceUUID I_SubstActiveDraftLstdSubst ActiveSubstanceUUID Substance
_OrgPeroxidePrintedName _OrgPeroxidePrintedName

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_OrganicPeroxide.
-- 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: PORGPRXG

CREATE VIEW P_OrganicPeroxide AS
SELECT
  OrganicPeroxid.CmplRqVersOrganicPrxdUUID AS CmplRqVersOrganicPrxdUUID,
  OrganicPeroxid.ProdCmplncDngrsGdsIdnNmbrType AS ProdCmplncDngrsGdsIdnNmbrType,
  OrganicPeroxid.ProdCmplncDngrsGdsIdnNmbr AS ProdCmplncDngrsGdsIdnNmbr,
  OrganicPeroxid.ListedSubstance AS ListedSubstance,
  OrganicPeroxid.DngrsGdsPositionOnSource AS DngrsGdsPositionOnSource,
  OrganicPeroxid.SubstanceListUUID AS SubstanceListUUID,
  OrganicPeroxid.CmplRqVersUUID AS CmplRqVersUUID,
  OrganicPeroxid.DngrsGdsOrganicPrxdName AS DngrsGdsOrganicPrxdName,
  OrganicPeroxid.DngrsGdsConcnLowrQtyOptr AS DngrsGdsConcnLowrQtyOptr,
  OrganicPeroxid.DngrsGdsConcnLowrQty AS DngrsGdsConcnLowrQty,
  OrganicPeroxid.DngrsGdsConcnLowrQtyUnit AS DngrsGdsConcnLowrQtyUnit,
  OrganicPeroxid.DngrsGdsHasConcnLowrQty AS DngrsGdsHasConcnLowrQty,
  OrganicPeroxid.DngrsGdsConcnUprQtyOptr AS DngrsGdsConcnUprQtyOptr,
  OrganicPeroxid.DngrsGdsConcnUprQty AS DngrsGdsConcnUprQty,
  OrganicPeroxid.DngrsGdsConcnUprQtyUnit AS DngrsGdsConcnUprQtyUnit,
  OrganicPeroxid.DngrsGdsHasConcnUprQty AS DngrsGdsHasConcnUprQty,
  OrganicPeroxid.DngrsGdsOrganicPrxdAddlInfoTxt AS DngrsGdsOrganicPrxdAddlInfoTxt,
  OrganicPeroxid.DngrsGdsHasControlTemp AS DngrsGdsHasControlTemp,
  OrganicPeroxid.DangerousGoodsControlTemp AS DangerousGoodsControlTemp,
  OrganicPeroxid.DangerousGoodsControlTempUnit AS DangerousGoodsControlTempUnit,
  OrganicPeroxid.DngrsGdsHasEmergencyTemp AS DngrsGdsHasEmergencyTemp,
  OrganicPeroxid.DangerousGoodsEmergencyTemp AS DangerousGoodsEmergencyTemp,
  OrganicPeroxid.DangerousGoodsEmgyTempUnit AS DangerousGoodsEmgyTempUnit,
  _ListedSubstance.SubstanceUUID AS SubstanceUUID,
  _ListedSubstance.ActiveSubstanceUUID AS ActiveSubstanceUUID
FROM I_CmplRqVersOrganicPrxd AS OrganicPeroxid
INNER JOIN I_SubstActiveDraftLstdSubst AS _ListedSubstance ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CmplRqVersDngrsGdsPrxdPrntT AS _OrgPeroxidePrintedName ON CmplRqVersOrganicPrxdUUID = _OrgPeroxidePrintedName.CmplRqVersOrganicPrxdUUID  -- association [0..*]
;

Learn More