P_CHMLCMPLNCINFOASSGDPCPRPTY

CDS View

Chemical Compliance Info assigned Properties

P_CHMLCMPLNCINFOASSGDPCPRPTY is a CDS View in S/4HANA. Chemical Compliance Info assigned Properties. It contains 5 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 5 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_ChmlCmplncInfoAssgdPCPrpty view from CONSUMPTION Chemical Compliance Info assigned Properties
C_CmbndChmlCmplncAssgdPCPrpty view from CONSUMPTION CCI - Physical-Chemical Property
P_ChmlCmplncInfoPrptyCmbnd view inner CONSUMPTION CCI Property Combined

Fields (5)

KeyField CDS FieldsUsed in Views
PCPrptyInProcProcgSts PCPrptyInProcProcgSts 1
PCPrptyNavgnLinkUUID PCPrptyNavgnLinkUUID 1
PCPrptyReldProcgSts PCPrptyReldProcgSts 1
PCPrptyRootType PCPrptyRootType 1
ReleasedByUser ReleasedByUser 1 
@EndUserText.label: 'Chemical Compliance Info assigned Properties'

@AbapCatalog:
{
  sqlViewName: 'PCCIASGDPRPTY',
  compiler.compareFilter: true,
  preserveKey:true
}

@AccessControl:
{
  authorizationCheck: #NOT_REQUIRED
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #CONSUMPTION
@VDM: {
    private: true
}

define view P_ChmlCmplncInfoAssgdPCPrpty

  -- Physical Chemical Property
  as select from P_ChmlCmplncInfoAssgdPCPhys
{
      --UUID of chemical compliance information
  key ChmlCmplncInfoUUID,

      --Property Type
  key PCPrptyRootType,

      --UUID of in process version
      PCPrptyInProcessUUID,

      --Status In Process
      PCPrptyInProcProcgSts,

      --Is Active entity
      PCPrptyInProcIsActive,

      --UUID of released version
      PCPrptyReleasedUUID,

      --Status Released
      PCPrptyReldProcgSts,

      --Released By User
      ReleasedByUser,

      --Is Active entity
      PCPrptyReldIsActive,

      --Navigation Link UUID
      PCPrptyNavgnLinkUUID,

      --Active Indicator
      PCPrptyIsActive
}
where
     PCPrptyInProcProcgSts = 'IP'
  or PCPrptyReldProcgSts   = 'RE'

//union all

//

//-- Physical Chemical Property

//select from P_ChmlCmplncInfoAssgdPCPhys2

//{

//      --UUID of chemical compliance information

//  key ChmlCmplncInfoUUID,

//

//      --Property Type

//  key PCPrptyRootType,

//

//      --UUID of in process version

//      PCPrptyInProcessUUID,

//

//      --Status In Process

//      PCPrptyInProcProcgSts,

//

//      --Is Active entity

//      PCPrptyInProcIsActive,

//

//      --UUID of released version

//      PCPrptyReleasedUUID,

//

//      --Status Released

//      PCPrptyReldProcgSts,

//

//      --Released By User

//      ReleasedByUser,

//

//      --Is Active entity

//      PCPrptyReldIsActive,

//

//      --Navigation Link UUID

//      PCPrptyNavgnLinkUUID,

//

//      --Active Indicator

//      PCPrptyIsActive

//}

//where

//     PCPrptyInProcProcgSts = 'IP'

//  or PCPrptyReldProcgSts   = 'RE'

//

--Ecological information
union all

select from P_ChmlCmplncInfoAssgdPCEctx
{
      --UUID of chemical compliance information
  key ChmlCmplncInfoUUID,

      --Property Type
  key PCPrptyRootType,

      --UUID of in process version
      PCPrptyInProcessUUID,

      --Status In Process
      PCPrptyInProcProcgSts,

      --Is Active entity
      PCPrptyInProcIsActive,

      --UUID of released version
      PCPrptyReleasedUUID,

      --Status Released
      PCPrptyReldProcgSts,

      --Released By User
      ReleasedByUser,

      --Is Active entity
      PCPrptyReldIsActive,

      --Navigation Link UUID
      PCPrptyNavgnLinkUUID,

      --Active Indicator
      PCPrptyIsActive

}
where
     PCPrptyInProcProcgSts = 'IP'
  or PCPrptyReldProcgSts   = 'RE'

--Safety-Related Property
union all

select from P_ChmlCmplncInfoAssgdPCSfty
{
      --UUID of chemical compliance information
  key ChmlCmplncInfoUUID,

      --Property Type
  key PCPrptyRootType,

      --UUID of in process version
      PCPrptyInProcessUUID,

      --Status In Process
      PCPrptyInProcProcgSts,

      --Is Active entity
      PCPrptyInProcIsActive,

      --UUID of released version
      PCPrptyReleasedUUID,

      --Status Released
      PCPrptyReldProcgSts,

      --Released By User
      ReleasedByUser,

      --Is Active entity
      PCPrptyReldIsActive,

      --Navigation Link UUID
      PCPrptyNavgnLinkUUID,

      --Active Indicator
      PCPrptyIsActive

}
where
     PCPrptyInProcProcgSts = 'IP'
  or PCPrptyReldProcgSts   = 'RE'

--Toxicological Information
union all

select from P_ChmlCmplncInfoAssgdPCTx
{
      --UUID of chemical compliance information
  key ChmlCmplncInfoUUID,

      --Property Type
  key PCPrptyRootType,

      --UUID of in process version
      PCPrptyInProcessUUID,

      --Status In Process
      PCPrptyInProcProcgSts,

      --Is Active entity
      PCPrptyInProcIsActive,

      --UUID of released version
      PCPrptyReleasedUUID,

      --Status Released
      PCPrptyReldProcgSts,

      --Released By User
      ReleasedByUser,

      --Is Active entity
      PCPrptyReldIsActive,

      --Navigation Link UUID
      PCPrptyNavgnLinkUUID,

      --Active Indicator
      PCPrptyIsActive

}
where
     PCPrptyInProcProcgSts = 'IP'
  or PCPrptyReldProcgSts   = 'RE'

Learn More