I_FMEATaskDescriptionTextTP

DDL: I_FMEATASKDESCRIPTIONTEXTTP Type: view_entity TRANSACTIONAL
11 Fields 1 Data Sources

FMEA Task Description - TP

I_FMEATaskDescriptionTextTP is a Transactional CDS View that provides data about "FMEA Task Description - TP" in SAP S/4HANA. It reads from 1 data source (I_FMEALongText) and exposes 11 fields with key fields FMEANodeUUID, Language.

Data Sources (1)

SourceAliasJoin Type
I_FMEALongText I_FMEALongText from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #TRANSACTIONAL view
EndUserText.label FMEA Task Description - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY FMEANodeUUID FMEANodeUUID
KEY Language Language Report Text Language
FMEALongText FMEALongText Trusted Site Content
LongTextCreatedByUser LongTextCreatedByUser Version Created By
LongTextCreatedAt LongTextCreatedAt Uploaded On
LongTextLastChangedByUser LongTextLastChangedByUser User Name
LongTextLastChangedAt LongTextLastChangedAt Timestamp
FMEAHeaderUUID _FMEATaskTP FMEAHeaderUUID
_FMEATaskTP _FMEATaskTP
_Language _Language
_FailureModeEffectAnalysisTP _FailureModeEffectAnalysisTP

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_FMEATaskDescriptionTextTP.
-- 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.

CREATE VIEW I_FMEATaskDescriptionTextTP AS
SELECT
  FMEANodeUUID,
  Language,
  FMEALongText,
  LongTextCreatedByUser,
  LongTextCreatedAt,
  LongTextLastChangedByUser,
  LongTextLastChangedAt,
  _FMEATaskTP.FMEAHeaderUUID AS FMEAHeaderUUID
FROM I_FMEALongText
;

Learn More