R_MaintTaskListOpLongTextTP

DDL: R_MAINTTASKLISTOPLONGTEXTTP Type: view_entity TRANSACTIONAL
13 Fields 2 Data Sources 2 Associations

Operation Longtext

R_MaintTaskListOpLongTextTP is a Transactional CDS View that provides data about "Operation Longtext" in SAP S/4HANA. It reads from 2 data sources (R_MaintTaskListOpBasicTP, I_TaskListOperationLongText) and exposes 13 fields with key fields TaskListType, TaskListGroup, TaskListGroupCounter, TaskListSequence, TaskListOperationInternalId. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
R_MaintTaskListOpBasicTP I_MaintTaskListOperation from
I_TaskListOperationLongText I_TaskListOperationLongText inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_MaintTaskListOpBasicTP _Operation $projection.TaskListType = _Operation.TaskListType and $projection.TaskListGroup = _Operation.TaskListGroup and $projection.TaskListGroupCounter = _Operation.TaskListGroupCounter and $projection.TaskListOperationInternalId = _Operation.TaskListOperationInternalId and $projection.TaskListSequence = _Operation.TaskListSequence and $projection.TaskListOpBOMItmIntVersCounter = _Operation.TaskListOpBOMItmIntVersCounter
[0..1] I_TextObjectPlainLongText _TextObjectPlainLongText _TextObjectPlainLongText.TextObjectKey = $projection.TextObjectKey and _TextObjectPlainLongText.TextObjectType = 'PLPO' and _TextObjectPlainLongText.TextObjectCategory = 'ROUTING' and _TextObjectPlainLongText.Language = $session.system_language

Annotations (10)

NameValueLevelField
AbapCatalog.dataMaintenance #RESTRICTED view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Operation Longtext view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY TaskListType R_MaintTaskListOpBasicTP TaskListType Task List Type
KEY TaskListGroup R_MaintTaskListOpBasicTP TaskListGroup Group
KEY TaskListGroupCounter R_MaintTaskListOpBasicTP TaskListGroupCounter Group Counter
KEY TaskListSequence R_MaintTaskListOpBasicTP TaskListSequence Sequence
KEY TaskListOperationInternalId R_MaintTaskListOpBasicTP TaskListOperationInternalId Node
KEY TaskListOpBOMItmIntVersCounter R_MaintTaskListOpBasicTP TaskListOpBOMItmIntVersCounter Counter
MaintenanceTaskListOperation R_MaintTaskListOpBasicTP MaintenanceTaskListOperation
TextObjectKey I_TaskListOperationLongText TextObjectKey Text Name
PlainLongText I_TaskListOperationLongText PlainLongText Long Text
Language _TextObjectPlainLongText Language Report Text Language
_Operation _Operation
_NonHistOp _NonHistOp
_Header _Header

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 R_MaintTaskListOpLongTextTP.
-- 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 R_MaintTaskListOpLongTextTP AS
SELECT
  I_MaintTaskListOperation.TaskListType AS TaskListType,
  I_MaintTaskListOperation.TaskListGroup AS TaskListGroup,
  I_MaintTaskListOperation.TaskListGroupCounter AS TaskListGroupCounter,
  I_MaintTaskListOperation.TaskListSequence AS TaskListSequence,
  I_MaintTaskListOperation.TaskListOperationInternalId AS TaskListOperationInternalId,
  I_MaintTaskListOperation.TaskListOpBOMItmIntVersCounter AS TaskListOpBOMItmIntVersCounter,
  I_MaintTaskListOperation.MaintenanceTaskListOperation AS MaintenanceTaskListOperation,
  I_TaskListOperationLongText.TextObjectKey AS TextObjectKey,
  I_TaskListOperationLongText.PlainLongText AS PlainLongText,
  _TextObjectPlainLongText.Language AS Language
FROM R_MaintTaskListOpBasicTP AS I_MaintTaskListOperation
INNER JOIN I_TaskListOperationLongText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_MaintTaskListOpBasicTP AS _Operation ON TaskListType = _Operation.TaskListType AND TaskListGroup = _Operation.TaskListGroup AND TaskListGroupCounter = _Operation.TaskListGroupCounter AND TaskListOperationInternalId = _Operation.TaskListOperationInternalId AND TaskListSequence = _Operation.TaskListSequence AND TaskListOpBOMItmIntVersCounter = _Operation.TaskListOpBOMItmIntVersCounter  -- association [1..1]
LEFT OUTER JOIN I_TextObjectPlainLongText AS _TextObjectPlainLongText ON _TextObjectPlainLongText.TextObjectKey = TextObjectKey AND _TextObjectPlainLongText.TextObjectType = 'PLPO' AND _TextObjectPlainLongText.TextObjectCategory = 'ROUTING' AND _TextObjectPlainLongText.Language = $session.system_language  -- association [0..1]
;

Learn More