I_InhRepairNote

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_InhRepairNote.
-- 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_InhRepairNote AS
SELECT
  InHouseRepair.CustMgmtObjectType AS CustMgmtObjectType,
  InHouseRepair.InHouseRepair AS InHouseRepair,
  stxh.tdid AS TextObjectType,
  stxh.tdspras AS Language,
  InHouseRepair.InHouseRepairUUID AS InHouseRepairUUID,
  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_InHouseRepair AS InHouseRepair ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessObjType AS _CustMgmtObjectType ON CustMgmtObjectType = _CustMgmtObjectType.BusinessObjectType  -- association [0..1]
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_InHouseRepair AS _InHouseRepair ON CustMgmtObjectType = _InHouseRepair.CustMgmtObjectType AND InHouseRepair = _InHouseRepair.InHouseRepair  -- association [0..1]
;