I_MfgWorkInstructionVersion

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_MfgWorkInstructionVersion.
-- 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: IMFGWIVERSION

CREATE VIEW I_MfgWorkInstructionVersion AS
SELECT
  WorkInstructionVersion.wi_id AS MfgWorkInstruction,
  WorkInstructionVersion.wi_version_no AS MfgWorkInstructionVersCounter,
  WorkInstructionVersion.spras AS Language,
  WorkInstructionVersion.wi_content_uuid AS MfgWorkInstructionContentUUID,
  WorkInstructionVersion.wi_id AS MfgWorkInstructionForEdit,
  WorkInstructionVersion.crea_date_time AS CreationTime,
  WorkInstructionVersion.crea_uname AS CreationUserName,
  WorkInstructionVersion.lchg_date_time AS LastChangeDateTime,
  WorkInstructionVersion.lchg_uname AS LastChangedByUser,
  Content.wi_content AS MfgWorkInstructionContent,
  WorkInstructionVersion.wi_status AS MfgWorkInstructionVersStatus,
  _Lang._Text[1:LanguageCode=Language].LanguageName AS LanguageName
FROM mpe_wi_version AS WorkInstructionVersion
INNER JOIN mpe_wi_content AS Content ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Language AS _Lang ON Language = _Lang.Language  -- association [1..1]
;