C_ChmlCmplncLegalAreaVH

@EndUserText.label: 'Legal Area for Chemical Compliance Information'

@AbapCatalog:
{
  sqlViewName: 'CCCILGLAREAVH',
  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:  [ 'ProdCmplncLegalArea' ],
  representativeKey: 'ProdCmplncLegalArea',
  usageType:
  {
    dataClass: #MIXED,
    sizeCategory: #M,
    serviceQuality: #C
  }
}

@Metadata.ignorePropagatedAnnotations: true

--Header information
@UI:
{
  headerInfo:
  {
    typeName: 'Legal Area',
    typeNamePlural: 'Legal Areas'
  }
}

define view C_ChmlCmplncLegalAreaVH
  with parameters
    --Current UUID of CCI
    P_ChmlCmplncInfoUUID : sysuuid_x,
    --Draft Indicator
    P_IsActiveEntity     : boolean
  --Select data from master table 'Legal Area'
  as select from           I_ProdCmplncLegalArea as ProdCmplncLegalArea

  --Join data of all uses
    left outer to one join C_ChmlCmplncUse       as ExistingUse on  ExistingUse.ProdCmplncLegalArea = ProdCmplncLegalArea.ProdCmplncLegalArea
                                                                and ExistingUse.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,

      --Legal Area
      @ObjectModel.text.element:  [ 'ProdCmplncLegalAreaName' ]
  key ProdCmplncLegalArea.ProdCmplncLegalArea                                                  as ProdCmplncLegalArea,

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

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

      @UI.hidden: true
      @Semantics.text: true
      ProdCmplncLegalArea._Text[1: Language= $session.system_language].ProdCmplncLegalAreaName as ProdCmplncLegalAreaName,

      --Compliance Information
      _ChmlCmplncInfoActiveDraft

}
where
  ExistingUse.ChmlCmplncInfoUUID is null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_CHMLCMPLNCUSE",
"I_CHMLCMPLNCINFOACTIVEDRAFT",
"I_PRODCMPLNCLEGALAREA",
"I_PRODCMPLNCLEGALAREATEXT"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCINFOACTIVEDRAFT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/