C_EngSnpshtChgNtcForEBOMVH

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_EngSnpshtChgNtcForEBOMVH.
-- 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: CSNPCNCREBOMVH

CREATE VIEW C_EngSnpshtChgNtcForEBOMVH AS
SELECT
  ChangeRecordBsc.ChangeRecord AS ChangeRecord,
  ChangeRecordRefEBOM.Material AS Material,
  ChangeRecordRefEBOM.Plant AS Plant,
  ChangeRecordRefEBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  ChangeRecordRefEBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  ChangeRecordRefEBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  ChangeRecordBsc.ChgRecordDescriptionText AS ChgRecordDescriptionText,
  ChangeRecordBsc.ChangeRecordType AS ChangeRecordType,
  ChangeRecordBsc.ChangeRecordStatus AS ChangeRecordStatus,
  ChangeRecordBsc.Partner AS Partner,
  _ChangeRecordContactPersonVH.PersonFullName AS PersonFullName,
  ChangeRecordBsc.CreatedByUser AS CreatedByUser,
  _UserInfo.UserDescription AS UserDescription
INNER JOIN I_ChangeRecordType AS ChangeRecordType ON /* join condition not captured in parsed metadata */
INNER JOIN I_ChgRecdRefEBOM AS ChangeRecordRefEBOM ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChangeRecordTypeText AS _ChangeRecordTypeText ON ChangeRecordType = _ChangeRecordTypeText.ChangeRecordType AND _ChangeRecordTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_IssActyMgmtUserStatus1t AS _IssActyMgmtUserStatus1t ON ChangeRecordStatus = _IssActyMgmtUserStatus1t.IssActyMgmtUserStatus1 AND _IssActyMgmtUserStatus1t.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_User AS _UserInfo ON CreatedByUser = _UserInfo.UserID  -- association [0..1]
LEFT OUTER JOIN I_ChangeRecordContactPerson AS _ChangeRecordContactPersonVH ON Partner = _ChangeRecordContactPersonVH.Partner  -- association [0..1]
;