I_NodeGeneralData

@AbapCatalog.sqlViewName: 'INODEGENERALDATA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.lifecycle: {
//  contract: {

//    type: #PUBLIC_LOCAL_API

//  },

  status: #DEPRECATED,
  successor: 'I_ProductStructureNode'
}
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #C
@EndUserText.label: 'Node General Data'
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_NodeGeneralData
  as select from    I_NodeHeader as _NodeHeader
    left outer join I_Node_Class on  _NodeHeader.ClassInternalID = I_Node_Class.ClassInternalID
                                 and I_Node_Class.Language       = $session.system_language
  /*association [0..*] to I_NodeText                 as _NodeText                 on  $projection.ProductStructureNodeUUID = _NodeText.ProductStructureNodeUUID
  association [0..1] to C_NodeType                 as _NodeType                 on  $projection.ProductStructureNodeType = _NodeType.ProductStructureNodeType
  */
  /*association [0..*] to I_Variant_Intf             as _Variant_Intf             on  $projection.ProductStructureNodeUUID = _Variant_Intf.ProdStructureVariantParentUUID*/
  association [0..1] to I_LogAccMObjectTypeActive  as _LogAccMObjectTypeActive  on  _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_PPEPF'
                                                                                or  _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_PPEPI'
  association [0..*] to I_LogAccMObjSecureIDAssgmt as _LogAccMObjSecureIDAssgmt on  $projection.ProductStructureNodeUniqueID      = _LogAccMObjSecureIDAssgmt.LogAccMObjectID
                                                                                and (
                                                                                   _LogAccMObjSecureIDAssgmt.LogAccMObjectType    = 'PLM_PPEPF'
                                                                                   or _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_PPEPI'
                                                                                 )
  association [0..*] to I_LogAccMObjectUserAuthzn  as _LogAccMObjectUserAuthzn  on  $projection.ProductStructureNodeUniqueID           = _LogAccMObjectUserAuthzn.LogAccMObjectID
                                                                                and (
                                                                                   _LogAccMObjectUserAuthzn.LogAccMObjectType          = 'PLM_PPEPF'
                                                                                   or _LogAccMObjectUserAuthzn.LogAccMObjectType       = 'PLM_PPEPI'
                                                                                 )
                                                                                and (
                                                                                   _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject    = 'PLM_PPEPF'
                                                                                   or _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_PPEPI'
                                                                                 )
                                                                                and (
                                                                                   _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom      = '03'
                                                                                   or _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom   = '*'
                                                                                 )
                                                                                and _LogAccMObjectUserAuthzn.LogAccMUserAuthznField    = 'ACTVT'
                                                                                and (
                                                                                   _LogAccMObjectUserAuthzn.LogAccMUserEntityID        = $session.user
                                                                                   or _LogAccMObjectUserAuthzn.UserID                  = $session.user
                                                                                 )
{
  key      ProductStructureNodeUUID,
           ProductStructureNodeUniqueID,
           ProductStructureNodeName,
           _NodeHeader.ClassInternalID,
           ProductStructureNodeType,
           ProductStructureCreationDate,
           ProductStructureCreatedByUser,
           ProductStrucLastChangedDate,
           ProductStrucLastChangedByUser,
           ClassType,
           Class,
           ClassName,
           Language,
           //_LogAccMObjSecureIDAssgmt.LogAccMObjectID,

           _LogAccMObjectTypeActive,
           _LogAccMObjSecureIDAssgmt,
           _LogAccMObjectUserAuthzn
}