I_ProductStructureVariant

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.
-- 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: IPSVARIANT

CREATE VIEW I_ProductStructureVariant AS
SELECT
  _Variant.ProductStructureVariantUUID AS ProductStructureVariantUUID,
  _VntChangeState.ProdStrucVariantChgStateIntID AS ProdStrucVariantChgStateIntID,
  _Variant.ProdStrucVariantUniqueID AS ProdStrucVariantUniqueID,
  ProductStructureVariantName,
  ProdStructureVariantParentUUID,
  ProductStructureCreationDate,
  ProductStructureCreatedByUser,
  ProductStrucLastChangedDate,
  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
FROM I_ProdStrucVariantBasic AS _Variant
INNER JOIN I_ProdStrucVariantChangeState AS _VntChangeState ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProdStrucVariantMaterial AS _VariantMaterial 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 _ChangeMasterLogAccMActive ON _ChangeMasterLogAccMActive.LogAccMObjectType = 'PLM_PPEPV' OR _ChangeMasterLogAccMActive.LogAccMObjectType = 'PLM_PPEPIV'  -- association [0..1]
LEFT OUTER JOIN I_ProdStrucLogAccMSecureAssgmt AS _ChgMstrLogAccMSecureIDAssgmt ON ProdStrucVariantUniqueID = _ChgMstrLogAccMSecureIDAssgmt.LogAccMObjectID AND ( _ChgMstrLogAccMSecureIDAssgmt.LogAccMObjectType = 'PLM_PPEPV' OR _ChgMstrLogAccMSecureIDAssgmt.LogAccMObjectType = 'PLM_PPEPIV' )  -- association [0..*]
LEFT OUTER JOIN I_ProdStrucLogAccMUserAuthzn AS _ChangeMstrLogAccMUserAuthzn ON ProdStrucVariantUniqueID = _ChangeMstrLogAccMUserAuthzn.LogAccMObjectID AND ( _ChangeMstrLogAccMUserAuthzn.LogAccMObjectType = 'PLM_PPEPV' OR _ChangeMstrLogAccMUserAuthzn.LogAccMObjectType = 'PLM_PPEPIV' ) AND ( _ChangeMstrLogAccMUserAuthzn.LogAccMUserAuthznFrom = '03' OR _ChangeMstrLogAccMUserAuthzn.LogAccMUserAuthznFrom = '*' ) AND _ChangeMstrLogAccMUserAuthzn.UserID = $session.user  -- association [0..*]
;