C_ChmlCmplncInfoPCPrptyVH

@EndUserText.label: 'Property Group Value Help'

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

--Access Control: Authorization checks
@AccessControl:
{
  authorizationCheck: #MANDATORY
}

--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,

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

      @UI.hidden: true
      @Semantics.text: 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'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_CHMLCMPLNCINFOASSGDPCPRPTY",
"I_CHMLCMPLNCINFOACTIVEDRAFT",
"I_PCPRPTYROOTTYPE",
"I_PCPRPTYROOTTYPETEXT"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCINFOACTIVEDRAFT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/