C_VariantList

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 C_VariantList.
-- 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: CVARIANTLIST

CREATE VIEW C_VariantList AS
SELECT
  _VariantHeader.ProductStructureVariantUUID AS ProductStructureVariantUUID,
  _VariantHistlData.ProdStrucVariantChgStateIntID AS ProdStrucVariantChgStateIntID,
  _VariantHeader.ProdStrucVariantUniqueID AS ProdStrucVariantUniqueID,
  ProductStructureVariantName,
  ProdStructureVariantParentUUID,
  ProductStructureVariantType,
  _VariantType.ProdStrucVarTypeDescription AS ProdStrucVarTypeDescription,
  ProductStructureCreationDate,
  ProductStructureCreatedByUser,
  ProductStrucLastChangedDate,
  ProductStrucLastChangedByUser,
  _VariantText.ProdStrucVariantDescription AS ProdStrucVariantDescription,
  _VariantHistlData.ProdStrucVariantChangeNumber AS ProdStrucVariantChangeNumber,
  _VariantHistlData.AuthorizationGroup AS AuthorizationGroup,
  _VariantHistlData.ProdStrucVarIsMrkdForDeletion AS ProdStrucVarIsMrkdForDeletion,
  _VariantHistlData.ProdStrucVarChgNmbrDescription AS ProdStrucVarChgNmbrDescription,
  _VariantMaterial.ProdStrucVarBasicDataChgState AS ProdStrucVarBasicDataChgState,
  _VariantMaterial.Material AS Material,
  _VariantMaterial.ProductStructureVariantQty AS ProductStructureVariantQty,
  _VariantMaterial.ProductStructureVariantUnit AS ProductStructureVariantUnit,
  _VariantMaterial.MaterialName AS MaterialName,
  _VariantMaterial.MaterialAuthorizationGroup AS MaterialAuthorizationGroup,
  _NodeList.ProductStructureNodeName AS ProductStructureNodeName,
  _NodeList.ProdStrucNodeDescription AS ProdStrucNodeDescription,
  _NodeList.ProductStructureNodeType AS ProductStructureNodeType,
  _NodeList.ProdStrucNodeTypeDescription AS ProdStrucNodeTypeDescription,
  _NodeList.Class AS Class,
  _NodeList.ClassName AS ClassName
LEFT OUTER JOIN I_VariantHistlData AS _VariantHistlData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_VariantText AS _VariantText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_VariantMaterial AS _VariantMaterial ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_VariantType AS _VariantType ON ProductStructureVariantType = _VariantType.ProductStructureVariantType  -- association [0..1]
LEFT OUTER JOIN C_NodeListNoDup AS _NodeList ON ProdStructureVariantParentUUID = _NodeList.ProductStructureNodeUUID  -- association [1..1]
LEFT OUTER JOIN I_LogAccMObjectTypeActive AS _LogAccMObjectTypeActive ON _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_PPEPV' OR _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_PPEPIV'  -- association [0..1]
LEFT OUTER JOIN I_LogAccMObjSecureIDAssgmt AS _LogAccMObjSecureIDAssgmt ON ProdStrucVariantUniqueID = _LogAccMObjSecureIDAssgmt.LogAccMObjectID AND ( _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_PPEPV' OR _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_PPEPIV' )  -- association [0..*]
LEFT OUTER JOIN I_LogAccMObjectUserAuthzn AS _LogAccMObjectUserAuthzn ON ProdStrucVariantUniqueID = _LogAccMObjectUserAuthzn.LogAccMObjectID AND ( _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_PPEPV' OR _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_PPEPIV' ) 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 )  -- association [0..*]
;