N_ChangeRecordObjPgMatl

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_ChangeRecordObjPgMatl.
-- 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: NCHGRCDOBJPGMAT

CREATE VIEW N_ChangeRecordObjPgMatl AS
SELECT
  ChangeRecordReferenceUUID,
  Material.Material AS Material,
  _ChangeRecordObjPg.ChangeRecordType AS ChangeRecordType,
  ChangeRecordUUID,
  ChangeRecordReferenceType,
  ChangeRecordReferenceSubtype,
  ChangeRecordReference,
  ParentChangeRecordRefUUID,
  IsMainReference,
  CreatedByUser,
  CreationDateTime,
  cast( '00000000' as /plmb/created_on ) AS CreationDate,
  LastChangedByUser,
  LastChangeDateTime,
  cast( '00000000' as /plmb/changed_on ) AS LastChangeDate,
  _ChangeRecordProduct.ProductName AS ProductName,
  cast(_ChangeRecordProduct.ProductType as mtart preserving type ) AS MaterialType,
  _ChangeRecordProduct ._MaterialType._Text[1:Language = $session.system_language].MaterialTypeName AS MaterialTypeName,
  cast(_ChangeRecordProduct.BaseUnit as /plmb/cr_mat_base_unit preserving type ) AS MaterialBaseUnit,
  _ChangeRecordProduct._UnitOfMeasureValueHelp._Text[1:Language = $session.system_language].UnitOfMeasureLongName AS UnitOfMeasureLongName,
  cast(_ChangeRecordProduct.CrossPlantStatus as /plmb/cr_mat_status preserving type) AS CrossPlantStatus,
  _ChangeRecordProduct._ProductStatus._Text[1:Language = $session.system_language].MaterialUsabilityProfileName AS MaterialUsabilityProfileName
FROM I_ChgRecdRefMatBsc AS reference_mat
LEFT OUTER JOIN I_Material AS Material ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_ChangeRecordObjPg AS _ChangeRecordObjPg ON ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID  -- association [1..1]
LEFT OUTER JOIN C_ChangeRecordItemRelMatVH AS _ChangeRecordItemRelMatVH ON ChangeRecordItemRelevance = _ChangeRecordItemRelMatVH.ChangeRecordItemRelevance AND ChangeRecordType = _ChangeRecordItemRelMatVH.ChangeRecordType AND ChangeRecordReferenceType = _ChangeRecordItemRelMatVH.ChangeRecordReferenceType  -- association [1..1]
LEFT OUTER JOIN I_ChangeRecordProduct AS _ChangeRecordProduct ON Material = _ChangeRecordProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
;