C_ProductStructureNodeVH

@AbapCatalog.sqlViewName: 'CPSNODEVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
//@AccessControl.privilegedAssociations: ['_Text']

@VDM.viewType: #CONSUMPTION
@Consumption.ranked: true
//@ObjectModel.representativeKey: 'ProductStructureNode'

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
@EndUserText.label: 'Product Structure Node Value Help'
define view C_ProductStructureNodeVH
  as select from I_ProductStructureNodeBasic as _Node
  association [0..1] to I_ClfnClass                as _Class                    on  _Node.ClassInternalID = _Class.ClassInternalID
  association [0..*] to I_ProductStructureNodeText as _NodeText                     on  $projection.ProductStructureNodeUUID = _NodeText.ProductStructureNodeUUID
                                                                                    and _NodeText.Language = $session.system_language
  association [0..1] to I_ProdStrucLogAccMActive  as _LogAccMObjectTypeActive  on  $projection.ProductStructureGnrcObjType = _LogAccMObjectTypeActive.LogAccMObjectType
  association [0..1] to I_ProdStrucObjSecureIDAssgmt as _LogAccMObjSecureIDAssgmt on  $projection.ProductStructureNodeUniqueID           = _LogAccMObjSecureIDAssgmt.LogAccMObjectID
                                                                                and   $projection.ProductStructureGnrcObjType            = _LogAccMObjSecureIDAssgmt.LogAccMObjectType
  association [0..1] to I_ProdStrucObjectUserAuthzn  as _LogAccMObjectUserAuthzn  on  $projection.ProductStructureNodeUniqueID           = _LogAccMObjectUserAuthzn.LogAccMObjectID
                                                                                and   $projection.ProductStructureGnrcObjType            = _LogAccMObjectUserAuthzn.LogAccMObjectType
                                                                                and   $projection.ProductStructureGnrcObjType            = _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject      
                                                                                /*and (
                                                                                   _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject    = 'PLM_PPEPF'
                                                                                   or _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_PPEPI'
                                                                                   or _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_PPEPVW'
                                                                                 )
                                                                                and (
                                                                                   _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom      = '03'
                                                                                   or _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom   = '*'
                                                                                 )
                                                                                and _LogAccMObjectUserAuthzn.LogAccMUserAuthznField    = 'ACTVT'
                                                                                and (
                                                                                   _LogAccMObjectUserAuthzn.LogAccMUserEntityID        = $session.user
                                                                                   or _LogAccMObjectUserAuthzn.UserID                  = $session.user
                                                                                 )*/
{
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @EndUserText.label: 'Node'
      @ObjectModel.text.element: 'ProdStrucNodeDescription'
  key ProductStructureNodeName,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key _Class.Class,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      ProductStructureNodeType,

      @UI.hidden: true
      @Consumption.hidden
      ProductStructureCreatedByUser,

      @UI.hidden: true
      @Consumption.hidden
      ProductStrucLastChangedByUser,
      
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      _NodeText.ProdStrucNodeDescription,
      //_Text,


      @UI.hidden: true
      @Consumption.hidden
      //@ObjectModel.text.association: '_Text'

      ProductStructureNodeUUID,
      @UI.hidden: true
      @Consumption.hidden
      bintohex( ProductStructureNodeUUID ) as ProductStructureNodeUniqueID, 
      @UI.hidden: true
      @Consumption.hidden
      _Node.ProductStructureGnrcObjType,
           
      //_LogAccMObjSecureIDAssgmt.LogAccMObjectID,

      @UI.hidden: true
      _LogAccMObjectTypeActive,
      @UI.hidden: true
      _LogAccMObjSecureIDAssgmt,
      @UI.hidden: true
      _LogAccMObjectUserAuthzn
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCLASS",
"I_PRODUCTSTRUCTURENODEBASIC",
"I_PRODUCTSTRUCTURENODETEXT"
],
"ASSOCIATED":
[
"I_CLFNCLASS",
"I_PRODSTRUCLOGACCMACTIVE",
"I_PRODSTRUCOBJECTUSERAUTHZN",
"I_PRODSTRUCOBJSECUREIDASSGMT",
"I_PRODUCTSTRUCTURENODETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/