I_ChgRecdRefProdStrucVarTP

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_ChgRecdRefProdStrucVarTP.
-- 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: ICHGRECREFPSVTP

CREATE VIEW I_ChgRecdRefProdStrucVarTP AS
SELECT
  ChangeRecordReferenceUUID,
  case when _variant.Class is null then cast(substring( reference_psm.ChangeRecordReference, 41, 18) as klasse_d) else cast(_variant.Class as klasse_d) end as Class AS Classasklasse_dendasClass,
  _variant.ProdStrucNodeDescription AS ProdStrucNodeDescription,
  _variant.ProdStrucVariantDescription AS ProdStrucVariantDescription,
  _variant.Material AS Material,
  _variant.ProductStructureNodeType AS ProductStructureNodeType,
  ChangeRecordUUID,
  ChangeRecordReferenceType,
  ChangeRecordReferenceSubtype,
  ChangeRecordReference,
  ParentChangeRecordRefUUID,
  IsMainReference,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  ChangeRecordItemRelevance,
  ChangeRecordVirtualRefInd,
  ChangeRecordRefObjectUUID,
  ChangeRecordItemProcgStatus,
  ChgRecdItmTgtSts,
  ChgRecdItmDSgntr,
  ChgRecdCurrentItemProcgStatus,
  reference_psm.ChgRecdReasonForChange AS ChgRecdReasonForChange,
  reference_psm.ExpdCompltnDte AS ExpdCompltnDte,
  reference_psm.ChgRecdAuthznGrpText AS ChgRecdAuthznGrpText,
  reference_psm.ChgRecdNmbrChgSts AS ChgRecdNmbrChgSts,
  reference_psm.ChangeNumber AS ChangeNumber
FROM I_ChgRecdRefProdStrucVarBsc AS reference_psm
;