C_MfgStandardTextVersionTP

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_MfgStandardTextVersionTP.
-- 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: CMFGSTDTXTVERS

CREATE VIEW C_MfgStandardTextVersionTP AS
SELECT
  StandardTextVersion.MfgStandardText AS MfgStandardText,
  StandardTextVersion.MfgStandardTextVersion AS MfgStandardTextVersion,
  StandardTextVersion.Language AS Language,
  StandardTextVersion.MfgStandardTextForEdit AS MfgStandardTextForEdit,
  StandardTextVersion.MfgStandardTextVersionStatus AS MfgStandardTextVersionStatus,
  _StdTxtVersionStatusValueHelp.MfgStdTextVersionStatusDesc AS MfgStdTextVersionStatusDesc,
  StandardTextVersion.MfgStdTextVersionStatusCritlty AS MfgStdTextVersionStatusCritlty,
  StandardTextVersion.MfgStandardTextLatestVersion AS MfgStandardTextLatestVersion,
  StandardTextVersion.CreationTime AS CreationTime,
  StandardTextVersion.CreationUserName AS CreationUserName,
  StandardTextVersion.LastChangeDateTime AS LastChangeDateTime,
  StandardTextVersion.LastChangedByUser AS LastChangedByUser,
  _LastChangedUser.UserDescription AS LastChangedByUserDescription,
  StandardTextVersion.MfgStandardTextContentUUID AS MfgStandardTextContentUUID,
  StandardTextVersion.MfgStandardTextContent AS MfgStandardTextContent,
  StandardTextVersion.Plant AS Plant,
  StandardTextVersion.MfgStandardTextCategory AS MfgStandardTextCategory,
  _User.UserDescription AS UserDescription,
  _User.UserID AS UserID,
  cast(' ' as abap.sstring( 1333 )) AS MfgStandardTextVersionKeyword
FROM I_MfgStandardTextVersionTP AS StandardTextVersion
LEFT OUTER JOIN C_MfgStandardTextTP AS _StandardText ON MfgStandardText = _StandardText.MfgStandardText  -- association [1..1]
LEFT OUTER JOIN I_MfgStdTxtVersStatusDesc AS _StdTxtVersionStatusValueHelp ON MfgStandardTextVersionStatus = _StdTxtVersionStatusValueHelp.MfgStandardTextVersionStatus AND _StdTxtVersionStatusValueHelp.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MfgStdTxtVersCreatedByVH AS _StdTxtVersCreatedByValueHelp ON CreationUserName = _StdTxtVersCreatedByValueHelp.UserID AND UserDescription = _StdTxtVersCreatedByValueHelp.UserDescription  -- association [1..1]
LEFT OUTER JOIN I_User AS _User ON CreationUserName = _User.UserID  -- association [1..1]
LEFT OUTER JOIN I_LanguageText AS _LanguageText ON Language = _LanguageText.LanguageCode  -- association [0..*]
LEFT OUTER JOIN C_MfgStdTxtVersionKeywordTP AS _Keyword ON MfgStandardText = _Keyword.MfgStandardText AND MfgStandardTextVersion = _Keyword.MfgStandardTextVersion AND Language = _Keyword.Language  -- association [1..*]
LEFT OUTER JOIN I_User AS _LastChangedUser ON LastChangedByUser = _LastChangedUser.UserID  -- association [1..1]
;