C_ChmlCmplncInfoPCPrptyVH

@EndUserText.label: 'Property Group Value Help'

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

-- Access Control: Authorization checks
@AccessControl:
{
  authorizationCheck: #MANDATORY,
  -- blocking of personal data not required (no personal data fields exposed for material (MARA))
  personalData.blocking: #NOT_REQUIRED
}

-- Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

-- VDM view type
@VDM.viewType: #CONSUMPTION

@ObjectModel:
{
  dataCategory: #VALUE_HELP,
  resultSet.sizeCategory: #XS,
  semanticKey:  [ 'PCPrptyRootType' ],
  representativeKey: 'PCPrptyRootType',
  usageType:
  {
    dataClass: #MIXED,
    sizeCategory: #M,
    serviceQuality: #C
  }
}

@Metadata.ignorePropagatedAnnotations: true

-- Header information
@UI:
{
  headerInfo:
  {
    typeName: 'Property Group',
    typeNamePlural: 'Property Groups'
  }
}

define view C_ChmlCmplncInfoPCPrptyVH
  with parameters
    -- Current UUID of CCI
    P_ChmlCmplncInfoUUID : sysuuid_x,
    -- Draft Indicator
    P_IsActiveEntity     : boolean

  -- Select data from master table 'Property Type'
  as select from           I_PCPrptyRootType            as PCPrptyRootType

  -- Join data of all property groups
    left outer to one join C_ChmlCmplncInfoAssgdPCPrpty as ExistingProperty on  ExistingProperty.PCPrptyRootType    = PCPrptyRootType.PCPrptyRootType
                                                                            and ExistingProperty.ChmlCmplncInfoUUID = $parameters.P_ChmlCmplncInfoUUID

  association [1..1] to I_ChmlCmplncInfoActiveDraft as _ChmlCmplncInfoActiveDraft on _ChmlCmplncInfoActiveDraft.ActiveChmlCmplncInfoUUID = $parameters.P_ChmlCmplncInfoUUID

{
      -- Chemical Compliance UUID
      @UI.hidden: true
  key $parameters.P_ChmlCmplncInfoUUID              as ActiveChmlCmplncInfoUUID,

      -- Composition Type
      @ObjectModel.text.element: [ 'PCPrptyRootTypeName' ]
  key PCPrptyRootType.PCPrptyRootType,

      @UI.hidden: true
      _ChmlCmplncInfoActiveDraft.ChmlCmplncInfoUUID as ChmlCmplncInfoUUID,

      @Semantics.booleanIndicator: true
      @UI.hidden: true
      $parameters.P_IsActiveEntity                  as IsActiveEntity,

      @Semantics.text: true
      @UI.hidden: true
      coalesce(
        PCPrptyRootType._Text[1: Language = $session.system_language].PCPrptyRootTypeName,
        PCPrptyRootType._Text[1: Language = 'E'].PCPrptyRootTypeName
      )                                             as PCPrptyRootTypeName,

      -- Compliance Information
      _ChmlCmplncInfoActiveDraft
}

where
       ExistingProperty.ChmlCmplncInfoUUID is null
  and(
       PCPrptyRootType.PCPrptyRootType     = 'EHFNDD_PHYSCHEM'
    or PCPrptyRootType.PCPrptyRootType     = 'EHFNDD_ECTX'
    or PCPrptyRootType.PCPrptyRootType     = 'EHFNDD_SR'
    or PCPrptyRootType.PCPrptyRootType     = 'EHFNDD_TX'
    or PCPrptyRootType.PCPrptyRootType     = 'EHFNDD_STAR'
    or PCPrptyRootType.PCPrptyRootType     = 'EHFNDD_CCIDFR'
  )