P_ORGANICPEROXIDE

CDS View

P_ORGANICPEROXIDE is a CDS View in S/4HANA. It contains 11 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 11 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_OrganicPeroxideInAllLanguage view from COMPOSITE

Fields (11)

KeyField CDS FieldsUsed in Views
KEY CmplRqVersOrganicPrxdUUID CmplRqVersOrganicPrxdUUID 1
_OrgPeroxidePrintedName _OrgPeroxidePrintedName 1
ActiveSubstanceUUID ActiveSubstanceUUID 1
CmplRqVersUUID CmplRqVersUUID 1
DngrsGdsOrganicPrxdName DngrsGdsOrganicPrxdName 1
DngrsGdsPositionOnSource DngrsGdsPositionOnSource 1
ListedSubstance ListedSubstance 1
ProdCmplncDngrsGdsIdnNmbr ProdCmplncDngrsGdsIdnNmbr 1
ProdCmplncDngrsGdsIdnNmbrType ProdCmplncDngrsGdsIdnNmbrType 1
SubstanceListUUID SubstanceListUUID 1
SubstanceUUID SubstanceUUID 1 
@AbapCatalog.sqlViewName: 'PORGPRXG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM: {
  private: true,
  viewType: #COMPOSITE
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
  usageType: {
    serviceQuality: #C,
    sizeCategory: #L,
    dataClass: #MIXED
  }
}

// This view select all organic peroxid substances (listed substances on CRV level) which are assigned to a company substance


define view P_OrganicPeroxide
  as select from I_CmplRqVersOrganicPrxd as OrganicPeroxid
  -- Listed substance information
  -- Remark: Substance.substanceuuid is the active UUID => use _ListedSubstance.ActiveSubstanceUUID. If not no listed substance information is shown for draft
  inner join I_SubstActiveDraftLstdSubst   as _ListedSubstance        on _ListedSubstance.ListedSubstance = OrganicPeroxid.ListedSubstance
  // Text association - Organic Peroxide Printed Name

  association [0..*] to I_CmplRqVersDngrsGdsPrxdPrntT as _OrgPeroxidePrintedName on $projection.CmplRqVersOrganicPrxdUUID = _OrgPeroxidePrintedName.CmplRqVersOrganicPrxdUUID
{
  key OrganicPeroxid.CmplRqVersOrganicPrxdUUID,
      OrganicPeroxid.ProdCmplncDngrsGdsIdnNmbrType,
      OrganicPeroxid.ProdCmplncDngrsGdsIdnNmbr,
      OrganicPeroxid.ListedSubstance,
      OrganicPeroxid.DngrsGdsPositionOnSource,
      OrganicPeroxid.SubstanceListUUID,
      OrganicPeroxid.CmplRqVersUUID,
      OrganicPeroxid.DngrsGdsOrganicPrxdName,
      
      // these values are needed for the apply classification functionality

      OrganicPeroxid.DngrsGdsConcnLowrQtyOptr,
      OrganicPeroxid.DngrsGdsConcnLowrQty,
      OrganicPeroxid.DngrsGdsConcnLowrQtyUnit,
      OrganicPeroxid.DngrsGdsHasConcnLowrQty,
      OrganicPeroxid.DngrsGdsConcnUprQtyOptr,
      OrganicPeroxid.DngrsGdsConcnUprQty,
      OrganicPeroxid.DngrsGdsConcnUprQtyUnit,
      OrganicPeroxid.DngrsGdsHasConcnUprQty,
      OrganicPeroxid.DngrsGdsOrganicPrxdAddlInfoTxt,
      
      // these values are needed for the determine control and emergency temp. functionality

      OrganicPeroxid.DngrsGdsHasControlTemp,
      OrganicPeroxid.DangerousGoodsControlTemp,
      OrganicPeroxid.DangerousGoodsControlTempUnit,
      OrganicPeroxid.DngrsGdsHasEmergencyTemp,
      OrganicPeroxid.DangerousGoodsEmergencyTemp,  
      OrganicPeroxid.DangerousGoodsEmgyTempUnit,

      _ListedSubstance.SubstanceUUID,
      _ListedSubstance.ActiveSubstanceUUID,
      _OrgPeroxidePrintedName
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMPLRQVERSORGANICPRXD",
"I_SUBSTACTIVEDRAFTLSTDSUBST"
],
"ASSOCIATED":
[
"I_CMPLRQVERSDNGRSGDSPRXDPRNTT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More