I_PRODUCTSTRUCTURENODEBASIC

CDS View

Product Structure Node Basic

I_PRODUCTSTRUCTURENODEBASIC is a CDS View in S/4HANA. Product Structure Node Basic. It contains 3 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 3 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_ProductStructureNodeVH view from CONSUMPTION Product Structure Node Value Help
I_ProductStructureNode view from BASIC Product Structure Node
I_ProductStructureNode_2 view from BASIC Product Structure Node
I_ProductStructureNodeVH view from BASIC Product Structure Node Value Help

Fields (3)

KeyField CDS FieldsUsed in Views
ClassInternalID ClassInternalID 2
ProductStructureGnrcObjType ProductStructureGnrcObjType 3
ProductStructureNodeType ProductStructureNodeType 2 
@AbapCatalog.sqlViewName: 'IPSNODEBASIC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: [ '_Text' ]
@VDM.viewType: #BASIC

//@ObjectModel.representativeKey: 'ProductStructureNode'

//@ObjectModel.semanticKey: 'ProductStructureNode'


@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C

@EndUserText.label: 'Product Structure Node Basic'
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_ProductStructureNodeBasic
  as select from pnodid
  //left outer to one join I_ProdStrucNodeGnrcObjTypeMap as _ppe_c_i2g            on pnodid.pntype = _ppe_c_i2g.ProductStructureNodeType

  association [0..1] to I_ProdStrucNodeGnrcObjTypeMap as _ppe_c_i2g            on pnodid.pntype = _ppe_c_i2g.ProductStructureNodeType
  association [0..*] to I_ProductStructureNodeText as _Text                     on  $projection.ProductStructureNodeUUID = _Text.ProductStructureNodeUUID
  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..*] to I_ProdStrucObjectUserAuthzn  as _LogAccMObjectUserAuthzn  on  $projection.ProductStructureNodeUniqueID          = _LogAccMObjectUserAuthzn.LogAccMObjectID
                                                                                and _LogAccMObjectUserAuthzn.LogAccMObjectType          = $projection.productstructuregnrcobjtype
{
          @ObjectModel.text.association: '_Text'
  key     pnodid.pnguid                                           as ProductStructureNodeUUID,
          bintohex( pnodid.pnguid )                               as ProductStructureNodeUniqueID,
          pnodid.pname                                            as ProductStructureNodeName,
          pntype                                                  as ProductStructureNodeType,
          _ppe_c_i2g.ProductStructureGnrcObjType,
          /*cast(
           case pntype
             when 'S_SW' then 'PLM_PPEPI'
             else _ppe_c_i2g.gos_object
          end as /plmb/gos_object_type)                           as ProductStructureGnrcObjType,*/
          clint                                                   as ClassInternalID,
          @Semantics.businessDate.at: true
          //@Semantics.businessDate.createdAt: true

          creadat                                                 as ProductStructureCreationDate,
          @Semantics.user.createdBy: true
          creaby                                                  as ProductStructureCreatedByUser,
          @Semantics.businessDate.at: true
          //@Semantics.businessDate.lastChangedAt: true

          chngdat                                                 as ProductStrucLastChangedDate,
          @Semantics.user.lastChangedBy: true
          chngby                                                  as ProductStrucLastChangedByUser,
          _Text,
          //_LogAccMObjSecureIDAssgmt.LogAccMObjectID,

          _LogAccMObjectTypeActive,
          _LogAccMObjSecureIDAssgmt,
          _LogAccMObjectUserAuthzn
}
where
  applobj_type = 'CMP'

Learn More