I_MfgStandardTextVersion

DDL: I_MFGSTANDARDTEXTVERSION SQL: IMFGSTDTEXTVER Type: view BASIC
14 Fields 1 Data Sources

Standard Text Version Basic View

I_MfgStandardTextVersion is a Basic CDS View that provides data about "Standard Text Version Basic View" in SAP S/4HANA. It reads from 1 data source (mpe_st_ver) and exposes 14 fields with key fields MfgStandardText, MfgStandardTextVersion, Language.

Data Sources (1)

SourceAliasJoin Type
mpe_st_ver Version from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMFGSTDTEXTVER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Standard Text Version Basic View view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY MfgStandardText mpe_st_ver textid UUID
KEY MfgStandardTextVersion mpe_st_ver versionid Version
KEY Language mpe_st_ver language Report Text Language
MfgStandardTextForEdit mpe_st_ver textid UUID
MfgStandardTextContentUUID mpe_st_ver st_content_uuid Content UUID
MfgStandardTextVersionStatus mpe_st_ver versionstatus Status
MfgStandardTextLatestVersion mpe_st_ver latestversion Latest Ver.
CreationTime mpe_st_ver created_at Uploaded On
CreationUserName mpe_st_ver created_by Version Created By
LastChangeDateTime mpe_st_ver changed_at Timestamp
LastChangedByUser mpe_st_ver changed_by User Name
MfgStandardTextContent Content content Trusted Site Content
Plant StandardText plant Valuation Area
MfgStandardTextCategory Category text_category Category

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_MfgStandardTextVersion.
-- 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: IMFGSTDTEXTVER

CREATE VIEW I_MfgStandardTextVersion AS
SELECT
  Version.textid AS MfgStandardText,
  Version.versionid AS MfgStandardTextVersion,
  Version.language AS Language,
  Version.textid AS MfgStandardTextForEdit,
  Version.st_content_uuid AS MfgStandardTextContentUUID,
  Version.versionstatus AS MfgStandardTextVersionStatus,
  Version.latestversion AS MfgStandardTextLatestVersion,
  Version.created_at AS CreationTime,
  Version.created_by AS CreationUserName,
  Version.changed_at AS LastChangeDateTime,
  Version.changed_by AS LastChangedByUser,
  Content.content AS MfgStandardTextContent,
  StandardText.plant AS Plant,
  Category.text_category AS MfgStandardTextCategory
FROM mpe_st_ver AS Version
;

Learn More