C_ChgRecdObjPgProdStrucVar

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_ChgRecdObjPgProdStrucVar.
-- 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: CCHGRECREFPSV

CREATE VIEW C_ChgRecdObjPgProdStrucVar AS
SELECT
  ChangeRecordReferenceUUID,
  _VariantVH.ProdStrucVariantUniqueID AS ProdStrucVariantUniqueID,
  cast( '' as productimageurl ) AS ProductImageURL,
  Class,
  ProductStructureNodeName,
  ProdStrucNodeDescription,
  ProductStructureVariantName,
  ProdStrucVariantDescription,
  ProdStrucVariantChangeNumber,
  Material,
  _MaterialText.MaterialName AS MaterialName,
  ChangeRecordUUID,
  ChangeRecordReferenceType,
  ParentChangeRecordRefUUID,
  ChangeRecordReference,
  ChgRecdCurrentItemProcgStatus,
  ChgRecdItmDSgntr,
  cast( '' as boolean) AS DigitalSignUserIsAuthorized,
  _DigSignStatusText.ChgRecdDigSignStatusTxt AS ChgRecdDigSignStatusTxt,
  cast( '' as boolean) AS ChgRecdObjDgtlSgntrEnable,
  ChgRecdReasonForChange,
  ExpdCompltnDte,
  ChgRecdAuthznGrpText,
  ChgRecdNmbrChgSts,
  ChangeNumber,
  CreatedByUser,
  CreationDateTime,
  cast( '00000000' as /plmb/created_on ) AS CreationDate,
  LastChangedByUser,
  LastChangeDateTime,
  cast( '00000000' as /plmb/changed_on ) AS LastChangeDate
FROM I_ChgRecdRefProdStrucVarTP AS ChangeRecordReferencePSVTP
LEFT OUTER JOIN I_Classvh AS _ClassVH ON Class = _ClassVH.Class  -- association [0..1]
LEFT OUTER JOIN C_ProductStructureNodeVH AS _NodeVH ON ProductStructureNodeName = _NodeVH.ProductStructureNodeName AND Class = _NodeVH.Class  -- association [0..1]
LEFT OUTER JOIN C_Chgnrvh AS _ChangeNumberVH ON ProdStrucVariantChangeNumber = _ChangeNumberVH.ProdStrucVariantChangeNumber  -- association [0..1]
LEFT OUTER JOIN C_ProductStructureVariantVH AS _VariantVH ON Class = _VariantVH.Class AND ProductStructureNodeName = _VariantVH.ProductStructureNodeName AND ProductStructureVariantName = _VariantVH.ProductStructureVariantName AND ProdStrucVariantChangeNumber = _VariantVH.ProdStrucVariantChangeNumber AND ( Material = _VariantVH.Material OR( Material = '' OR Material is null ) )  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_ChangeRecdDigSignStatusVH AS _DigSignStatusText ON ChgRecdItmDSgntr = _DigSignStatusText.ChgRecdDigitalSignatureStatus  -- association [0..*]
;