P_SELFREACTIVESUBSTANCE

CDS View

All Self Reactive Substances linked with (company) subst

P_SELFREACTIVESUBSTANCE is a CDS View in S/4HANA. All Self Reactive Substances linked with (company) subst. 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_SelfReactiveSubstInAllLang view from COMPOSITE Self Reacted Substances Cross Joined with Languages

Fields (11)

KeyField CDS FieldsUsed in Views
KEY ActiveSubstanceUUID ActiveSubstanceUUID 1
KEY CmplRqVersSelfReactvSubstUUID CmplRqVersSelfReactvSubstUUID 1
_SelfReactvPrintedName _SelfReactvPrintedName 1
CmplRqVersUUID CmplRqVersUUID 1
DngrsGdsPositionOnSource DngrsGdsPositionOnSource 1
DngrsGdsSelfReactvName DngrsGdsSelfReactvName 1
ListedSubstance ListedSubstance 1
ProdCmplncDngrsGdsIdnNmbr ProdCmplncDngrsGdsIdnNmbr 1
ProdCmplncDngrsGdsIdnNmbrType ProdCmplncDngrsGdsIdnNmbrType 1
SubstanceListUUID SubstanceListUUID 1
SubstanceUUID SubstanceUUID 1 
@AbapCatalog.sqlViewName: 'PSELFREACTIVE'
@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 self reactive substances (listed substances on CRV level) which are assigned to a company substance


define view P_SelfReactiveSubstance
  as select from I_CmplRqVersSelfReactvSubst as SelfReactiveSubstance
  -- 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 = SelfReactiveSubstance.ListedSubstance

  // Text association - Self-reactive Substance Printed Name

  association [0..*] to I_DngrsGdsSelfReactvPrntT as _SelfReactvPrintedName on $projection.CmplRqVersSelfReactvSubstUUID = _SelfReactvPrintedName.CmplRqVersSelfReactvSubstUUID


{
  key SelfReactiveSubstance.CmplRqVersSelfReactvSubstUUID,
  key _ListedSubstance.ActiveSubstanceUUID,
      SelfReactiveSubstance.SubstanceListUUID,
      SelfReactiveSubstance.CmplRqVersUUID,
      SelfReactiveSubstance.ProdCmplncDngrsGdsIdnNmbrType,
      SelfReactiveSubstance.ProdCmplncDngrsGdsIdnNmbr,
      SelfReactiveSubstance.ListedSubstance,
      SelfReactiveSubstance.DngrsGdsPositionOnSource,
      SelfReactiveSubstance.DngrsGdsSelfReactvName,
      
      // these values are needed for the apply classification functionality

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

      SelfReactiveSubstance.DngrsGdsHasControlTemp,
      SelfReactiveSubstance.DangerousGoodsControlTemp,
      SelfReactiveSubstance.DangerousGoodsControlTempUnit,
      SelfReactiveSubstance.DngrsGdsHasEmergencyTemp,
      SelfReactiveSubstance.DangerousGoodsEmergencyTemp,  
      SelfReactiveSubstance.DangerousGoodsEmgyTempUnit,
            
      _ListedSubstance.SubstanceUUID,
      _SelfReactvPrintedName

}

Learn More