C_PCTrdScrtAssgmtVH

DDL: C_PCTRDSCRTASSGMTVH Type: view_entity CONSUMPTION Package: EHFND_CNS_CCI

Trade Secret Assignment

C_PCTrdScrtAssgmtVH is a Consumption CDS View that provides data about "Trade Secret Assignment" in SAP S/4HANA. It reads from 1 data source (I_ProdCmplncLegalArea) and exposes 4 fields. It has 1 association to related views. Part of development package EHFND_CNS_CCI.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_ProdCmplncLegalArea LegalArea from

Parameters (2)

NameTypeDefault
P_ChmlCmplncInfoUUID sysuuid_x
P_IsActiveEntity boolean

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ChmlCmplncInfoActiveDraft _ChmlCmplncInfoActiveDraft _ChmlCmplncInfoActiveDraft.ActiveChmlCmplncInfoUUID = $parameters.P_ChmlCmplncInfoUUID

Annotations (12)

NameValueLevelField
EndUserText.label Trade Secret Assignment view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.representativeKey ProdCmplncLegalArea view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.typeName Trade Secret view
UI.headerInfo.typeNamePlural Trade Secrets view

Fields (4)

KeyFieldSource TableSource FieldDescription
ProdCmplncLegalArea
ChmlCmplncInfoUUID _ChmlCmplncInfoActiveDraft ChmlCmplncInfoUUID
IsActiveEntity
ProdCmplncLegalAreaName 
@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

Learn More