C_MfgBuyOffTemplateTP

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_MfgBuyOffTemplateTP.
-- 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: CMFGBOFFTEMPLATE

CREATE VIEW C_MfgBuyOffTemplateTP AS
SELECT
  MfgBuyOffTemplate,
  MfgBuyOffTemplateForEdit,
  MfgBuyOffTemplateDescription,
  I_MfgBuyOffTemplateTP.CreatedByUser AS CreatedByUser,
  I_MfgBuyOffTemplateTP.LastChangedByUser AS LastChangedByUser,
  MfgBuyOffTemplateNote,
  LastChangeDateTime,
  _ChangeUser.UserDescription AS ChangedBy,
  CreationDateTime,
  _CreateUser.UserDescription AS MfgBuyOffCreatedBy
FROM I_MfgBuyOffTemplateTP
LEFT OUTER JOIN C_MfgBuyOffTmplSequenceTP AS _Sequence ON MfgBuyOffTemplate = _Sequence.MfgBuyOffTemplate  -- association [1..*]
LEFT OUTER JOIN I_MfgBuyOffTemplateVH AS _TemplateIDValueHelp ON MfgBuyOffTemplateForEdit = _TemplateIDValueHelp.MfgBuyOffTemplateForEdit OR MfgBuyOffTemplate = _TemplateIDValueHelp.MfgBuyOffTemplate  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreateUser ON CreatedByUser = _CreateUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangeUser ON LastChangedByUser = _ChangeUser.UserID  -- association [0..1]
;