C_PCTrdScrtAssgmtVH

@EndUserText.label: 'Trade Secret Assignment'

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

--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: 'Trade Secret',
    typeNamePlural: 'Trade Secrets'
  }
}

define view entity C_PCTrdScrtAssgmtVH
  with parameters
    --Current UUID of CCI
    P_ChmlCmplncInfoUUID : sysuuid_x,
    --Draft Indicator
    P_IsActiveEntity     : boolean
  --Select data from master table 'Composition Type'
  as select from           I_ProdCmplncLegalArea as LegalArea

  --Join data of all legal composition that are assigned to current analytical composition
    left outer to one join I_ChmlComposition     as ExistingComp on  ExistingComp.ChmlCompositionType = 'TS'
                                                                 and ExistingComp.ProdCmplncLegalArea = LegalArea.ProdCmplncLegalArea
                                                                 and ExistingComp.ChmlCmplncInfoUUID  = $parameters.P_ChmlCmplncInfoUUID

  --join data of analytical composition (compliance information)
  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:  [ 'ProdCmplncLegalAreaName' ]
  key LegalArea.ProdCmplncLegalArea,

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

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

      --Description of Composition Type
      @UI.hidden: true
      @ObjectModel.readOnly: true
      @Semantics.text: true
      LegalArea._Text[1: Language = $session.system_language ].ProdCmplncLegalAreaName,

      --Compliance Information
      _ChmlCmplncInfoActiveDraft

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