I_InhRepairItemNote

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_InhRepairItemNote.
-- 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.

CREATE VIEW I_InhRepairItemNote AS
SELECT
  InHouseRepairItem.CustMgmtObjectType AS CustMgmtObjectType,
  InHouseRepairItem.InHouseRepair AS InHouseRepair,
  InHouseRepairItem.InHouseRepairItem AS InHouseRepairItem,
  stxh.tdid AS TextObjectType,
  stxh.tdspras AS Language,
  InHouseRepairItem.InHouseRepairItemUUID AS InHouseRepairItemUUID,
  stxh.tdobject AS TextObjectCategory,
  stxh.tdfuser AS CreatedByUser,
  stxh.tdfdate AS CreationDate,
  stxh.tdftime AS CreationTime,
  stxh.tdluser AS LastChangedByUser,
  stxh.tdldate AS LastChangeDate,
  stxh.tdltime AS LastChangeTime,
  _InoteTemp.text AS InhRepairNoteText
FROM stxh
INNER JOIN I_InHouseRepairItem AS InHouseRepairItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TextObjectType AS _TextObjectType ON TextObjectType = _TextObjectType.TextObjectType AND TextObjectCategory = _TextObjectType.TextObjectCategory  -- association [0..1]
LEFT OUTER JOIN I_TextObjectCategory AS _TextObjectCategory ON TextObjectCategory = _TextObjectCategory.TextObjectCategory  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_InHouseRepairItem AS _InHouseRepairItem ON CustMgmtObjectType = _InHouseRepairItem.CustMgmtObjectType AND InHouseRepair = _InHouseRepairItem.InHouseRepair AND InHouseRepairItem = _InHouseRepairItem.InHouseRepairItem  -- association [0..1]
LEFT OUTER JOIN I_InHouseRepair AS _InHouseRepair ON CustMgmtObjectType = _InHouseRepair.CustMgmtObjectType AND InHouseRepair = _InHouseRepair.InHouseRepair  -- association [0..1]
;