Which tables does C_ProductStructureVariantVH use?

C_ProductStructureVariantVH reads from 1 data source(s): I_ProductStructureVariant_2.

C_ProductStructureVariantVH

Q: How many fields does C_ProductStructureVariantVH have?

C_ProductStructureVariantVH has 14 fields. Key fields: ProductStructureVariantName, ProdStrucVariantChangeNumber, ProductStructureNodeName, Class.

DDL: C_PRODUCTSTRUCTUREVARIANTVH SQL: CPSVVH Type: view CONSUMPTION

Value Help for Product Structure Variant

C_ProductStructureVariantVH is a Consumption CDS View that provides data about "Value Help for Product Structure Variant" in SAP S/4HANA. It reads from 1 data source (I_ProductStructureVariant_2) and exposes 14 fields with key fields ProductStructureVariantName, ProdStrucVariantChangeNumber, ProductStructureNodeName, Class. It has 4 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_ProductStructureVariant_2	_Variant	from

Associations (4)

Cardinality	Target	Alias	Condition
[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..1]	I_ProdStrucObjectUserAuthzn	_LogAccMObjectUserAuthzn	`$projection.ProdStrucVariantUniqueID = _LogAccMObjectUserAuthzn.LogAccMObjectID and $projection.ProductStructureGnrcObjType = _LogAccMObjectUserAuthzn.LogAccMObjectType and $projection.ProductStructureGnrcObjType = _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject`

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	CPSVVH	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
EndUserText.label	Value Help for Product Structure Variant	view
Search.searchable	true	view
VDM.viewType	#CONSUMPTION	view
Consumption.ranked	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.sizeCategory	#M	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (14)

Key	Field	Source Table	Source Field	Description
KEY	ProductStructureVariantName	I_ProductStructureVariant_2	ProductStructureVariantName
KEY	ProdStrucVariantChangeNumber	I_ProductStructureVariant_2	ProdStrucVariantChangeNumber
KEY	ProductStructureNodeName	_Node	ProductStructureNodeName	Node
KEY	Class
	ProdStrucVariantDescription			Variant Description
	ProdStrucNodeDescription			Node Description
	ProdStructureVariantParentUUID	I_ProductStructureVariant_2	ProdStructureVariantParentUUID
	Material	I_ProductStructureVariant_2	Material	Material
	ProdStrucVariantUniqueID	I_ProductStructureVariant_2	ProdStrucVariantUniqueID
	ProductStructureVariantType	I_ProductStructureVariant_2	ProductStructureVariantType
	ProductStructureGnrcObjType	I_ProductStructureVariant_2	ProductStructureGnrcObjType
	_LogAccMObjectTypeActive		_LogAccMObjectTypeActive
	_LogAccMObjSecureIDAssgmt		_LogAccMObjSecureIDAssgmt
	_LogAccMObjectUserAuthzn		_LogAccMObjectUserAuthzn

@AbapCatalog.sqlViewName: 'CPSVVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Value Help for Product Structure Variant'
@Search.searchable: true
@VDM.viewType: #CONSUMPTION
@Consumption.ranked: true
@ObjectModel.usageType: {serviceQuality: #C,
                          dataClass: #MIXED,
                          sizeCategory: #M}
@ClientHandling.algorithm: #SESSION_VARIABLE

define view C_ProductStructureVariantVH
  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..1] to I_ProdStrucObjectUserAuthzn  as _LogAccMObjectUserAuthzn  on  $projection.ProdStrucVariantUniqueID                = _LogAccMObjectUserAuthzn.LogAccMObjectID
                                                                                and   $projection.ProductStructureGnrcObjType             = _LogAccMObjectUserAuthzn.LogAccMObjectType
                                                                                and   $projection.ProductStructureGnrcObjType             = _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject
                                                                                /*and (
                                                                                   _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject    = 'PLM_PPEPV'
                                                                                   or _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_PPEPIV'
                                                                                 )
                                                                                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
                 @ObjectModel.text.element: 'ProdStrucVariantDescription'
  key            _Variant.ProductStructureVariantName,
                 @Search.defaultSearchElement: true
                 @Search.fuzzinessThreshold: 0.8
                 @Search.ranking: #HIGH
  key            _Variant.ProdStrucVariantChangeNumber,
                 @Search.defaultSearchElement: true
                 @Search.fuzzinessThreshold: 0.8
                 @Search.ranking: #HIGH
                 @EndUserText.label: 'Node'
  key            _Node.ProductStructureNodeName,
                 @Search.defaultSearchElement: true
                 @Search.fuzzinessThreshold: 0.8
                 @Search.ranking: #HIGH
  key            _Node._Class.Class,
                 
                 @Search.defaultSearchElement: true
                 @Search.fuzzinessThreshold: 0.8
                 @Search.ranking: #HIGH
                 @EndUserText.label: 'Variant Description'
                 _Variant._Text[1:Language = $session.system_language].ProdStrucVariantDescription,
                 @Search.defaultSearchElement: true
                 @Search.fuzzinessThreshold: 0.8
                 @Search.ranking: #HIGH
                 @EndUserText.label: 'Node Description'
                 _Node._Text[1:Language = $session.system_language].ProdStrucNodeDescription,
                 @UI.hidden: true
                 @Consumption.hidden
                 _Variant.ProdStructureVariantParentUUID,
                 @Search.fuzzinessThreshold: 0.3
                 @Search.ranking: #HIGH
                 @EndUserText.label: 'Material'
                 _Variant.Material,
                 @UI.hidden: true
                 @Consumption.hidden
                _Variant.ProdStrucVariantUniqueID,
                 @Search.defaultSearchElement: true
                 @Search.fuzzinessThreshold: 0.9
                 @Search.ranking: #HIGH 
                 _Variant.ProductStructureVariantType,
                 @UI.hidden: true
                 @Consumption.hidden
                 _Variant.ProductStructureGnrcObjType,
                 _LogAccMObjectTypeActive,
                 _LogAccMObjSecureIDAssgmt,
                 _LogAccMObjectUserAuthzn

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCLASS",
"I_PRODUCTSTRUCTURENODETEXT",
"I_PRODUCTSTRUCTURENODE_2",
"I_PRODUCTSTRUCTUREVARIANTTEXT",
"I_PRODUCTSTRUCTUREVARIANT_2"
],
"ASSOCIATED":
[
"I_PRODSTRUCLOGACCMACTIVE",
"I_PRODSTRUCOBJECTUSERAUTHZN",
"I_PRODSTRUCOBJSECUREIDASSGMT",
"I_PRODUCTSTRUCTURENODE_2"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

C_ProductStructureVariantVH view

I_ProductStructureVariant_2 view