I_ProductStructureVariantNode

DDL: I_PRODUCTSTRUCTUREVARIANTNODE SQL: IPSMVARNODE Type: view COMPOSITE

Product Structure Variant Node

I_ProductStructureVariantNode is a Composite CDS View that provides data about "Product Structure Variant Node" in SAP S/4HANA. It reads from 1 data source (I_ProductStructureVariant_2) and exposes 27 fields with key fields ProductStructureVariantUUID, ProdStrucVariantChgStateIntID. It has 4 associations to related views.

1 data source(s) 27 fields

Data Sources (1)

SourceAliasJoin Type
I_ProductStructureVariant_2 _Variant from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_ProductStructureNode_2 _Node $projection.ProdStructureVariantParentUUID = _Node.ProductStructureNodeUUID
[0..1] I_ProdStrucLogAccMActive _LogAccMObjectTypeActive $projection.ProductStructureGnrcObjType = _LogAccMObjectTypeActive.LogAccMObjectType
[0..1] I_ProdStrucObjSecureIDAssgmt _LogAccMObjSecureIDAssgmt $projection.ProdStrucVariantUniqueID = _LogAccMObjSecureIDAssgmt.LogAccMObjectID and $projection.ProductStructureGnrcObjType = _LogAccMObjSecureIDAssgmt.LogAccMObjectType
[0..*] I_ProdStrucObjectUserAuthzn _LogAccMObjectUserAuthzn $projection.ProdStrucVariantUniqueID = _LogAccMObjectUserAuthzn.LogAccMObjectID and _LogAccMObjectUserAuthzn.LogAccMObjectType = $projection.ProductStructureGnrcObjType

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPSMVARNODE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label Product Structure Variant Node view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY ProductStructureVariantUUID I_ProductStructureVariant_2 ProductStructureVariantUUID
KEY ProdStrucVariantChgStateIntID I_ProductStructureVariant_2 ProdStrucVariantChgStateIntID
ProdStructureVariantParentUUID ProdStructureVariantParentUUID
ProdStrucVariantUniqueID ProdStrucVariantUniqueID
ProductStructureNodeUniqueID _Node ProductStructureNodeUniqueID
ProductStructureNodeUUID _Node ProductStructureNodeUUID
ProductStructureNodeName _Node ProductStructureNodeName
ProductStructureNodeType _Node ProductStructureNodeType
ProductStructureGnrcObjType I_ProductStructureVariant_2 ProductStructureGnrcObjType
ProductStructureVariantType I_ProductStructureVariant_2 ProductStructureVariantType
ProdStrucVariantChangeNumber I_ProductStructureVariant_2 ProdStrucVariantChangeNumber
ProdStrucVarChgNmbrDescription I_ProductStructureVariant_2 ProdStrucVarChgNmbrDescription
ClassType
Class
ProdStrucNodeDescription Node Description
ProductStructureCreationDate ProductStructureCreationDate
ProductStructureCreatedByUser ProductStructureCreatedByUser
ProductStrucLastChangedDate ProductStrucLastChangedDate
ProductStrucLastChangedByUser ProductStrucLastChangedByUser
ProductStructureVariantName I_ProductStructureVariant_2 ProductStructureVariantName
Material I_ProductStructureVariant_2 Material
MaterialAuthorizationGroup I_ProductStructureVariant_2 MaterialAuthorizationGroup
ProdStrucVariantDescription Variant Description
ClassInternalID _Node ClassInternalID
_LogAccMObjectTypeActive _LogAccMObjectTypeActive
_LogAccMObjSecureIDAssgmt _LogAccMObjSecureIDAssgmt
_LogAccMObjectUserAuthzn _LogAccMObjectUserAuthzn 
@AbapCatalog.sqlViewName: 'IPSMVARNODE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
//@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

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

@EndUserText.label: 'Product Structure Variant Node'

@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_ProductStructureVariantNode
  as select from I_ProductStructureVariant_2 as _Variant
  association [1..1] to I_ProductStructureNode_2     as _Node                     on  $projection.ProdStructureVariantParentUUID = _Node.ProductStructureNodeUUID
  association [0..1] to I_ProdStrucLogAccMActive  as _LogAccMObjectTypeActive  on  $projection.ProductStructureGnrcObjType = _LogAccMObjectTypeActive.LogAccMObjectType
  association [0..1] to I_ProdStrucObjSecureIDAssgmt as _LogAccMObjSecureIDAssgmt on  $projection.ProdStrucVariantUniqueID              = _LogAccMObjSecureIDAssgmt.LogAccMObjectID
                                                                                and $projection.ProductStructureGnrcObjType             = _LogAccMObjSecureIDAssgmt.LogAccMObjectType
  association [0..*] to I_ProdStrucObjectUserAuthzn  as _LogAccMObjectUserAuthzn  on  $projection.ProdStrucVariantUniqueID              = _LogAccMObjectUserAuthzn.LogAccMObjectID
                                                                                and _LogAccMObjectUserAuthzn.LogAccMObjectType          = $projection.ProductStructureGnrcObjType
{

  key _Variant.ProductStructureVariantUUID,
  key _Variant.ProdStrucVariantChgStateIntID,
      ProdStructureVariantParentUUID,
      //ProductStructureNodeUUID,

      ProdStrucVariantUniqueID,
      _Node.ProductStructureNodeUniqueID,
      _Node.ProductStructureNodeUUID,
      _Node.ProductStructureNodeName,
      _Node.ProductStructureNodeType,
      _Variant.ProductStructureGnrcObjType,
      _Variant.ProductStructureVariantType,
      _Variant.ProdStrucVariantChangeNumber,
      _Variant.ProdStrucVarChgNmbrDescription,
      ProdStrucVariantConcatenated,
      _Node._Class.ClassType,
      _Node._Class.Class,
      @EndUserText.label: 'Node Description'
      _Node._Text[1:Language = $session.system_language].ProdStrucNodeDescription,
      @Semantics.businessDate.at: true
      @Semantics.businessDate.createdAt: true
      ProductStructureCreationDate,
      @Semantics.user.createdBy: true
      ProductStructureCreatedByUser,
      @Semantics.businessDate.at: true
      @Semantics.businessDate.lastChangedAt: true
      ProductStrucLastChangedDate,
      @Semantics.user.lastChangedBy: true
      ProductStrucLastChangedByUser,
      _Variant.ProductStructureVariantName,
      _Variant.Material,
      _Variant.MaterialAuthorizationGroup,
      @EndUserText.label: 'Variant Description'
      _Variant._Text[1:Language = $session.system_language].ProdStrucVariantDescription,
      _Node.ClassInternalID,
      _LogAccMObjectTypeActive,
      _LogAccMObjSecureIDAssgmt,
      _LogAccMObjectUserAuthzn
}

Learn More