C_MfgStandardTextTP

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_MfgStandardTextTP.
-- 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: CMFGSTDTEXT

CREATE VIEW C_MfgStandardTextTP AS
SELECT
  StandardText.MfgStandardText AS MfgStandardText,
  StandardText.MfgStandardTextForEdit AS MfgStandardTextForEdit,
  StandardText.MfgStandardTextCategoryUUID AS MfgStandardTextCategoryUUID,
  StandardText.MfgStandardTextCategory AS MfgStandardTextCategory,
  StandardText.MfgStandardTextUsageType AS MfgStandardTextUsageType,
  StandardText.MfgStandardTextReferenceType AS MfgStandardTextReferenceType,
  StandardText.Plant AS Plant,
  StandardText.MfgStandardTextDescription AS MfgStandardTextDescription,
  StandardText.MfgStandardTextVersion AS MfgStandardTextVersion,
  StandardText.MfgStandardTextLatestVersion AS MfgStandardTextLatestVersion,
  StandardText.CreationTime AS CreationTime,
  StandardText.CreationUserName AS CreationUserName,
  StandardText.CreatedByUserDescription AS CreatedByUserDescription,
  cast(' ' as abap.sstring( 1333 )) AS MfgStandardTextVersionKeyword,
  StandardText.MfgStandardTextStatus AS MfgStandardTextStatus,
  MfgStandardTextVersionStatus,
  MfgStdTextVersionStatusCritlty
FROM I_MfgStandardTextTP AS StandardText
LEFT OUTER JOIN I_MfgStandardTextCategory AS _Category ON MfgStandardTextCategoryUUID = _Category.MfgStandardTextCategoryUUID  -- association [1..1]
LEFT OUTER JOIN C_MfgStandardTextVersionTP AS _Version ON MfgStandardText = _Version.MfgStandardText  -- association [1..*]
LEFT OUTER JOIN C_MfgStandardTextTextTP AS _Description ON MfgStandardText = _Description.MfgStandardText  -- association [1..*]
LEFT OUTER JOIN I_MfgStandardTextVH AS _StandardTextIDValueHelp ON MfgStandardTextForEdit = _StandardTextIDValueHelp.MfgStandardText  -- association [0..1]
LEFT OUTER JOIN I_MfgStdTextCategoryVH AS _TextCategoryValueHelp ON MfgStandardTextCategoryUUID = _TextCategoryValueHelp.MfgStandardTextCategoryUUID AND MfgStandardTextCategory = _TextCategoryValueHelp.MfgStandardTextCategory  -- association [0..1]
LEFT OUTER JOIN I_MfgStandardTextUsageTypeVH AS _UsageTypeValueHelp ON MfgStandardTextUsageType = _UsageTypeValueHelp.MfgStandardTextUsageType  -- association [0..1]
LEFT OUTER JOIN I_MfgStandardTextRefTypeVH AS _RefTypeValueHelp ON MfgStandardTextReferenceType = _RefTypeValueHelp.MfgStandardTextReferenceType  -- association [0..1]
LEFT OUTER JOIN I_MfgStdTxtVersStatusVH AS _StdTxtVersionStatusValueHelp ON MfgStandardTextVersionStatus = _StdTxtVersionStatusValueHelp.MfgStandardTextVersionStatus  -- association [1..1]
LEFT OUTER JOIN I_MfgStdTxtVersCreatedByVH AS _StdTxtVersCreatedByValueHelp ON CreationUserName = _StdTxtVersCreatedByValueHelp.UserID  -- association [1..1]
LEFT OUTER JOIN I_PlantStdVH AS _PlantValueHelp ON Plant = _PlantValueHelp.Plant  -- association [1..1]
LEFT OUTER JOIN C_MfgStdTextVersWhereUsedList AS _WhereUsed ON MfgStandardText = _WhereUsed.MfgStandardText  -- association [0..*]
;