N_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 N_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: NCHGRECREFPSV

CREATE VIEW N_ChgRecdObjPgProdStrucVar AS
SELECT
  ChangeRecordReferenceUUID,
  Class,
  ProductStructureNodeName,
  ProdStrucNodeDescription,
  ProductStructureVariantName,
  ProdStrucVariantDescription,
  ProdStrucVariantChangeNumber,
  Material,
  _ChangeRecordObjPg.ChangeRecordType AS ChangeRecordType,
  ChangeRecordUUID,
  ChangeRecordReferenceType,
  ParentChangeRecordRefUUID,
  ChangeRecordItemRelevance,
  ChangeRecordReference,
  CreatedByUser,
  CreationDateTime,
  cast( '00000000' as /plmb/created_on ) AS CreationDate,
  LastChangedByUser,
  LastChangeDateTime,
  cast( '00000000' as /plmb/changed_on ) AS LastChangeDate,
  _ChangeRecordObjPg.ChangeNumber AS ChangeNumber
FROM I_ChgRecdRefProdStrucVarBsc AS reference_psm
LEFT OUTER JOIN I_Classvh AS _ClassVH ON Class = _ClassVH.Class  -- association [0..1]
LEFT OUTER JOIN C_Nodevh AS _NodeVH ON ProductStructureNodeName = _NodeVH.ProductStructureNodeName  -- 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  -- association [0..1]
LEFT OUTER JOIN C_ChgRecdItemRelProdStrucVarVH AS _ChgRecdItemRelProdStrucVarVH ON ChangeRecordItemRelevance = _ChgRecdItemRelProdStrucVarVH.ChangeRecordItemRelevance AND ChangeRecordType = _ChgRecdItemRelProdStrucVarVH.ChangeRecordType AND ChangeRecordReferenceType = _ChgRecdItemRelProdStrucVarVH.ChangeRecordReferenceType  -- association [1..1]
LEFT OUTER JOIN C_ChangeRecordObjPg AS _ChangeRecordObjPg ON ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID  -- association [1..1]
;