I_ProductStructureVariant_2

DDL: I_PRODUCTSTRUCTUREVARIANT_2 SQL: IPSV Type: view COMPOSITE
25 Fields 2 Data Sources 6 Associations

Product Structure Variant

I_ProductStructureVariant_2 (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_ProductStructureVariant_2 is a Composite CDS View that provides data about "Product Structure Variant" in SAP S/4HANA. It reads from 2 data sources (I_ProdStrucVariantBasic, I_ProdStrucVariantChangeState) and exposes 25 fields with key fields ProductStructureVariantUUID, ProdStrucVariantChgStateIntID. It has 6 associations to related views.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentPLM-WUI-OBJ-PSM
CapabilitiesData Source for Defining CDS Entities, Data Source in SQL Select, Data Source for Search
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (2)

SourceAliasJoin Type
I_ProdStrucVariantBasic _Variant from
I_ProdStrucVariantChangeState _VntChangeState inner

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_ProdStrucVariantChangeState _VariantChangeState _Variant.ProductStructureVariantUUID = _VariantChangeState.ProductStructureVariantUUID and $projection.ProdStrucVariantChgStateIntID = _VariantChangeState.ProdStrucVariantChgStateIntID
[0..1] I_ProdStrucVariantBasic _VariantBasic $projection.ProductStructureVariantUUID = _VariantBasic.ProductStructureVariantUUID
[0..*] I_ProductStructureVariantText _Text _Variant.ProductStructureVariantUUID = _Text.ProductStructureVariantUUID and _VntChangeState.ProdStrucVariantChgStateIntID = _Text.ProdStrucVariantChgStateIntID
[0..1] I_ProdStrucLogAccMActive _PSVMasterLogAccMActive $projection.ProductStructureGnrcObjType = _PSVMasterLogAccMActive.LogAccMObjectType
[0..*] I_ProdStrucLogAccMSecureAssgmt _PSVMstrLogAccMSecureIDAssgmt $projection.ProdStrucVariantUniqueID = _PSVMstrLogAccMSecureIDAssgmt.LogAccMObjectID and $projection.ProductStructureGnrcObjType = _PSVMstrLogAccMSecureIDAssgmt.LogAccMObjectType
[0..*] I_ProdStrucLogAccMUserAuthzn _PSVMstrLogAccMUserAuthzn $projection.ProdStrucVariantUniqueID = _PSVMstrLogAccMUserAuthzn.LogAccMObjectID and $projection.ProductStructureGnrcObjType = _PSVMstrLogAccMUserAuthzn.LogAccMObjectType

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPSV view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
AbapCatalog.preserveKey true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey ProductStructureVariantUUID view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label Product Structure Variant view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY ProductStructureVariantUUID I_ProdStrucVariantBasic ProductStructureVariantUUID Internal Number of the PVS Variant
KEY ProdStrucVariantChgStateIntID I_ProdStrucVariantChangeState ProdStrucVariantChgStateIntID Internal Counter for iPPE Objects
ProdStrucVariantUniqueID I_ProdStrucVariantBasic ProdStrucVariantUniqueID
ProductStructureVariantName I_ProdStrucVariantBasic ProductStructureVariantName Variant
ProdStructureVariantParentUUID I_ProdStrucVariantBasic ProdStructureVariantParentUUID Internal Number of iPPE Node
ProductStructureCreationDate I_ProdStrucVariantBasic ProductStructureCreationDate Date of Application
ProductStructureCreatedByUser I_ProdStrucVariantBasic ProductStructureCreatedByUser User who created record
ProductStrucLastChangedDate I_ProdStrucVariantBasic ProductStrucLastChangedDate Date of Last Change
ProductStrucLastChangedByUser I_ProdStrucVariantBasic ProductStrucLastChangedByUser Name of Person Who Changed Object
ProdStrucVariantChangeNumber I_ProdStrucVariantChangeState ProdStrucVariantChangeNumber Change Number in iPPE
AuthorizationGroup I_ProdStrucVariantChangeState AuthorizationGroup Authorization group for change master record
ProdStrucVarIsMrkdForDeletion I_ProdStrucVariantChangeState ProdStrucVarIsMrkdForDeletion Deletion Indicator
ProdStrucVarChgNmbrDescription I_ProdStrucVariantChangeState ProdStrucVarChgNmbrDescription Change number description
ProductStructureVariantQty _VariantMaterial ProductStructureVariantQty Fixed Quantity in Variant of iPPE Product Structure
ProductStructureVariantUnit _VariantMaterial ProductStructureVariantUnit Unit of Measure
Material _VariantMaterial Material Product Number
MaterialAuthorizationGroup _VariantMaterial MaterialAuthorizationGroup Authorization Group
ProductStructureVariantType I_ProdStrucVariantBasic ProductStructureVariantType iPPE Variant Type
ProductStructureGnrcObjType I_ProdStrucVariantBasic ProductStructureGnrcObjType Object Type
_Text _Text
_VariantChangeState _VariantChangeState
_VariantBasic _VariantBasic
_PSVMasterLogAccMActive _PSVMasterLogAccMActive
_PSVMstrLogAccMSecureIDAssgmt _PSVMstrLogAccMSecureIDAssgmt
_PSVMstrLogAccMUserAuthzn _PSVMstrLogAccMUserAuthzn

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ProductStructureVariant_2.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IPSV

CREATE VIEW I_ProductStructureVariant_2 AS
SELECT
  _Variant.ProductStructureVariantUUID AS ProductStructureVariantUUID,
  _VntChangeState.ProdStrucVariantChgStateIntID AS ProdStrucVariantChgStateIntID,
  _Variant.ProdStrucVariantUniqueID AS ProdStrucVariantUniqueID,
  _Variant.ProductStructureVariantName AS ProductStructureVariantName,
  _Variant.ProdStructureVariantParentUUID AS ProdStructureVariantParentUUID,
  _Variant.ProductStructureCreationDate AS ProductStructureCreationDate,
  _Variant.ProductStructureCreatedByUser AS ProductStructureCreatedByUser,
  _Variant.ProductStrucLastChangedDate AS ProductStrucLastChangedDate,
  _Variant.ProductStrucLastChangedByUser AS ProductStrucLastChangedByUser,
  _VntChangeState.ProdStrucVariantChangeNumber AS ProdStrucVariantChangeNumber,
  _VntChangeState.AuthorizationGroup AS AuthorizationGroup,
  _VntChangeState.ProdStrucVarIsMrkdForDeletion AS ProdStrucVarIsMrkdForDeletion,
  _VntChangeState.ProdStrucVarChgNmbrDescription AS ProdStrucVarChgNmbrDescription,
  _VariantMaterial.ProductStructureVariantQty AS ProductStructureVariantQty,
  _VariantMaterial.ProductStructureVariantUnit AS ProductStructureVariantUnit,
  _VariantMaterial.Material AS Material,
  _VariantMaterial.MaterialAuthorizationGroup AS MaterialAuthorizationGroup,
  _Variant.ProductStructureVariantType AS ProductStructureVariantType,
  _Variant.ProductStructureGnrcObjType AS ProductStructureGnrcObjType
FROM I_ProdStrucVariantBasic AS _Variant
INNER JOIN I_ProdStrucVariantChangeState AS _VntChangeState ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProdStrucVariantChangeState AS _VariantChangeState ON _Variant.ProductStructureVariantUUID = _VariantChangeState.ProductStructureVariantUUID AND ProdStrucVariantChgStateIntID = _VariantChangeState.ProdStrucVariantChgStateIntID  -- association [0..1]
LEFT OUTER JOIN I_ProdStrucVariantBasic AS _VariantBasic ON ProductStructureVariantUUID = _VariantBasic.ProductStructureVariantUUID  -- association [0..1]
LEFT OUTER JOIN I_ProductStructureVariantText AS _Text ON _Variant.ProductStructureVariantUUID = _Text.ProductStructureVariantUUID AND _VntChangeState.ProdStrucVariantChgStateIntID = _Text.ProdStrucVariantChgStateIntID  -- association [0..*]
LEFT OUTER JOIN I_ProdStrucLogAccMActive AS _PSVMasterLogAccMActive ON ProductStructureGnrcObjType = _PSVMasterLogAccMActive.LogAccMObjectType  -- association [0..1]
LEFT OUTER JOIN I_ProdStrucLogAccMSecureAssgmt AS _PSVMstrLogAccMSecureIDAssgmt ON ProdStrucVariantUniqueID = _PSVMstrLogAccMSecureIDAssgmt.LogAccMObjectID AND ProductStructureGnrcObjType = _PSVMstrLogAccMSecureIDAssgmt.LogAccMObjectType  -- association [0..*]
LEFT OUTER JOIN I_ProdStrucLogAccMUserAuthzn AS _PSVMstrLogAccMUserAuthzn ON ProdStrucVariantUniqueID = _PSVMstrLogAccMUserAuthzn.LogAccMObjectID AND ProductStructureGnrcObjType = _PSVMstrLogAccMUserAuthzn.LogAccMObjectType  -- association [0..*]
;

Learn More