I_MfgStandardTextVersionTP

DDL: I_MFGSTANDARDTEXTVERSIONTP SQL: IMFGSTDTEXTVERTP Type: view TRANSACTIONAL
17 Fields 1 Data Sources 2 Associations

Standard Text Version Transactional View

I_MfgStandardTextVersionTP is a Transactional CDS View that provides data about "Standard Text Version Transactional View" in SAP S/4HANA. It reads from 1 data source (I_MfgStandardTextVersion) and exposes 17 fields with key fields MfgStandardText, MfgStandardTextVersion, Language. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MfgStandardTextVersion Draft from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_MfgStandardTextTP _StandardText $projection.MfgStandardText = _StandardText.MfgStandardText
[1..*] I_MfgStdTxtVersionKeywordTP _Keyword $projection.MfgStandardText = _Keyword.MfgStandardText and $projection.MfgStandardTextVersion = _Keyword.MfgStandardTextVersion and $projection.Language = _Keyword.Language

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IMFGSTDTEXTVERTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Standard Text Version Transactional View view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.writeDraftPersistence MPE_ST_VER_D view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY MfgStandardText I_MfgStandardTextVersion MfgStandardText UUID
KEY MfgStandardTextVersion I_MfgStandardTextVersion MfgStandardTextVersion Version
KEY Language I_MfgStandardTextVersion Language Report Text Language
MfgStandardTextForEdit I_MfgStandardTextVersion MfgStandardTextForEdit UUID
MfgStandardTextVersionStatus I_MfgStandardTextVersion MfgStandardTextVersionStatus Status
MfgStandardTextLatestVersion I_MfgStandardTextVersion MfgStandardTextLatestVersion Latest Ver.
CreationTime I_MfgStandardTextVersion CreationTime Time of Change
CreationUserName I_MfgStandardTextVersion CreationUserName User Name
LastChangeDateTime I_MfgStandardTextVersion LastChangeDateTime Timestamp
LastChangedByUser I_MfgStandardTextVersion LastChangedByUser User Name
MfgStandardTextContentUUID I_MfgStandardTextVersion MfgStandardTextContentUUID Content UUID
MfgStandardTextContent I_MfgStandardTextVersion MfgStandardTextContent Trusted Site Content
Plant I_MfgStandardTextVersion Plant Valuation Area
MfgStandardTextCategory I_MfgStandardTextVersion MfgStandardTextCategory Category
MfgStdTextVersionStatusCritlty I_MfgStandardTextVersion MfgStdTextVersionStatusCritlty
_StandardText _StandardText
_Keyword _Keyword

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_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: IMFGSTDTEXTVERTP

CREATE VIEW I_MfgStandardTextVersionTP AS
SELECT
  Draft.MfgStandardText AS MfgStandardText,
  Draft.MfgStandardTextVersion AS MfgStandardTextVersion,
  Draft.Language AS Language,
  Draft.MfgStandardTextForEdit AS MfgStandardTextForEdit,
  Draft.MfgStandardTextVersionStatus AS MfgStandardTextVersionStatus,
  Draft.MfgStandardTextLatestVersion AS MfgStandardTextLatestVersion,
  Draft.CreationTime AS CreationTime,
  Draft.CreationUserName AS CreationUserName,
  Draft.LastChangeDateTime AS LastChangeDateTime,
  Draft.LastChangedByUser AS LastChangedByUser,
  Draft.MfgStandardTextContentUUID AS MfgStandardTextContentUUID,
  Draft.MfgStandardTextContent AS MfgStandardTextContent,
  Draft.Plant AS Plant,
  Draft.MfgStandardTextCategory AS MfgStandardTextCategory,
  Draft.MfgStdTextVersionStatusCritlty AS MfgStdTextVersionStatusCritlty
FROM I_MfgStandardTextVersion AS Draft
LEFT OUTER JOIN I_MfgStandardTextTP AS _StandardText ON MfgStandardText = _StandardText.MfgStandardText  -- association [1..1]
LEFT OUTER JOIN I_MfgStdTxtVersionKeywordTP AS _Keyword ON MfgStandardText = _Keyword.MfgStandardText AND MfgStandardTextVersion = _Keyword.MfgStandardTextVersion AND Language = _Keyword.Language  -- association [1..*]
;

Learn More