P_MaintTaskListOpPRT

DDL: P_MAINTTASKLISTOPPRT Type: view_entity COMPOSITE Package: ODATA_EAM_TASKLIST_MAN
27 Fields 1 Data Sources

Maint. Task List Operation PRT

P_MaintTaskListOpPRT is a Composite CDS View that provides data about "Maint. Task List Operation PRT" in SAP S/4HANA. It reads from 1 data source (I_MaintTaskListOpPRT) and exposes 27 fields with key fields TaskListType, TaskListGroup, TaskListGroupCounter, TaskListSequence, TaskListOperationInternalId. Part of development package ODATA_EAM_TASKLIST_MAN.

Data Sources (1)

SourceAliasJoin Type
I_MaintTaskListOpPRT I_MaintTaskListOpPRT from

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY TaskListType TaskListType Task List Type
KEY TaskListGroup TaskListGroup Group
KEY TaskListGroupCounter TaskListGroupCounter Group Counter
KEY TaskListSequence TaskListSequence Sequence
KEY TaskListOperationInternalId TaskListOperationInternalId Node
KEY TaskListOpPRTIntID TaskListOpPRTIntID
KEY TaskListOpPRTIntVersCounter TaskListOpPRTIntVersCounter
ProdnRsceToolItemNumber ProdnRsceToolItemNumber Item Number
ProdnRsceToolStandardWorkQty ProdnRsceToolStandardWorkQty Quantity
ProdnRsceToolStdWorkQtyUnit ProdnRsceToolStdWorkQtyUnit Unit
ProdnRsceToolTotQtyCalcFormula ProdnRsceToolTotQtyCalcFormula
ProdnRsceToolUsageQuantity ProdnRsceToolUsageQuantity
ProdnRsceToolUsageQuantityUnit ProdnRsceToolUsageQuantityUnit
ProdnRsceToolUsageQtyCalcFmla ProdnRsceToolUsageQtyCalcFmla
ProductionResourceType ProductionResourceType Object Type
ProductionResourceInternalID ProductionResourceInternalID Object ID
ProdnRsceToolText ProdnRsceToolText
IsDeleted IsDeleted TRUE
_ProductionResourceType _ProductionResourceType
_ProdnRsceToolMasterData _ProdnRsceToolMasterData
_ProdnRsceToolTotQtyCalcFmla _ProdnRsceToolTotQtyCalcFmla
_ProdnRsceToolUsageQtyCalcFmla _ProdnRsceToolUsageQtyCalcFmla
_ProductionResourceToolUnit _ProductionResourceToolUnit
_ProdnResourceToolUsageUnit _ProdnResourceToolUsageUnit
_MaintenanceTaskList _MaintenanceTaskList
_ProdnRsceToolByInternalKey _ProdnRsceToolByInternalKey
_TaskListType _TaskListType

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 P_MaintTaskListOpPRT.
-- 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 P_MaintTaskListOpPRT AS
SELECT
  TaskListType,
  TaskListGroup,
  TaskListGroupCounter,
  TaskListSequence,
  TaskListOperationInternalId,
  TaskListOpPRTIntID,
  TaskListOpPRTIntVersCounter,
  ProdnRsceToolItemNumber,
  ProdnRsceToolStandardWorkQty,
  ProdnRsceToolStdWorkQtyUnit,
  ProdnRsceToolTotQtyCalcFormula,
  ProdnRsceToolUsageQuantity,
  ProdnRsceToolUsageQuantityUnit,
  ProdnRsceToolUsageQtyCalcFmla,
  ProductionResourceType,
  ProductionResourceInternalID,
  ProdnRsceToolText,
  IsDeleted
FROM I_MaintTaskListOpPRT
;

Learn More