I_MaintenanceOrderOperationTP

DDL: I_MAINTENANCEORDEROPERATIONTP Type: view_entity TRANSACTIONAL
108 Fields 1 Data Sources

Maint Order Operation Projection - TP

I_MaintenanceOrderOperationTP is a Transactional CDS View that provides data about "Maint Order Operation Projection - TP" in SAP S/4HANA. It reads from 1 data source (R_MaintenanceOrderOperationTP) and exposes 108 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation.

Data Sources (1)

SourceAliasJoin Type
R_MaintenanceOrderOperationTP R_MaintenanceOrderOperationTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Maint Order Operation Projection - TP view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.modelingPattern #TRANSACTIONAL_PROJECTED_ENTITY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (108)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder Order
KEY MaintenanceOrderOperation MaintenanceOrderOperation Suboperation
KEY MaintenanceOrderSubOperation MaintenanceOrderSubOperation Suboperation
MaintOrderRoutingNumber MaintOrderRoutingNumber Plan No.f.Oper.
MaintenanceOrderRoutingNode MaintenanceOrderRoutingNode Counter
SuperiorOperationInternalID SuperiorOperationInternalID Sup. Op. Node
OperationControlKey OperationControlKey Control Key
OperationDescription OperationDescription Op. Short Text
OperationWorkCenterInternalID OperationWorkCenterInternalID Object ID
OperationWorkCenterTypeCode OperationWorkCenterTypeCode
Plant Plant Valuation Area
OperationStandardTextCode OperationStandardTextCode Std Text Key
Language Language Report Text Language
NumberOfTimeTickets NumberOfTimeTickets No.TimeTickets
OperationPurgInfoRecdSearchTxt OperationPurgInfoRecdSearchTxt Sort Term
OperationSupplier OperationSupplier Supplier
OpExternalProcessingPrice OpExternalProcessingPrice Price
OpExternalProcessingPriceUnit OpExternalProcessingPriceUnit Price unit
OpExternalProcessingCurrency OpExternalProcessingCurrency Currency
CostElement CostElement G/L Account
OperationPurchasingInfoRecord OperationPurchasingInfoRecord Info Record
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
MaterialGroup MaterialGroup Product Group
OpPurchaseOutlineAgreement OpPurchaseOutlineAgreement Agreement
OpPurchaseOutlineAgreementItem OpPurchaseOutlineAgreementItem Agreement Item
OperationRequisitionerName OperationRequisitionerName Requisitioner
OperationTrackingNumber OperationTrackingNumber Tracking Number
NumberOfCapacities NumberOfCapacities Number
OperationWorkPercent OperationWorkPercent Percent
OperationCalculationControl OperationCalculationControl Calculation key
ActivityType ActivityType Activity Type
OperationSystemCondition OperationSystemCondition SystemCondition
OperationGoodsRecipientName OperationGoodsRecipientName Recipient
OperationUnloadingPointName OperationUnloadingPointName Unloading Point
OperationPersonResponsible OperationPersonResponsible Personnel no.
EAMPlannedDeliveryDurnInDays EAMPlannedDeliveryDurnInDays Pl. Deliv. Time
MaintOrderOperationDuration MaintOrderOperationDuration Normal duration
MaintOrdOperationDurationUnit MaintOrdOperationDurationUnit Norm.duratn un.
OpErlstSchedldExecStrtDteTme OpErlstSchedldExecStrtDteTme Time Stamp
OpErlstSchedldExecEndDteTme OpErlstSchedldExecEndDteTme Time Stamp
OpLtstSchedldExecStrtDteTme OpLtstSchedldExecStrtDteTme Time Stamp
OpLtstSchedldExecEndDteTme OpLtstSchedldExecEndDteTme Time Stamp
OpActualExecutionStartDateTime OpActualExecutionStartDateTime Time Stamp
OpActualExecutionEndDateTime OpActualExecutionEndDateTime Time Stamp
OpBscStartDateConstraintType OpBscStartDateConstraintType StartConstraint
OpBscEndDateConstraintType OpBscEndDateConstraintType Fin. constraint
MaintOrdOperationWorkDuration MaintOrdOperationWorkDuration Work
MaintOrdOpWorkDurationUnit MaintOrdOpWorkDurationUnit Unit for work
MaintOrdOpConstraintStrtDteTme MaintOrdOpConstraintStrtDteTme Time Stamp
ConstraintDateForBscStartDate ConstraintDateForBscStartDate
ConstraintTimeForBscStartTime ConstraintTimeForBscStartTime
MaintOrdOpCstrtFinishDteTme MaintOrdOpCstrtFinishDteTme Time Stamp
ConstraintDateForBscFinishDate ConstraintDateForBscFinishDate
ConstraintTimeForBscFinishTime ConstraintTimeForBscFinishTime
MaintOrdOperationExecutionRate MaintOrdOperationExecutionRate Execution Fact.
Equipment Equipment Equipment check
FunctionalLocation FunctionalLocation Object ID
OpErlstSchedldExecStrtDte OpErlstSchedldExecStrtDte Earl.start date
OpErlstSchedldExecStrtTme OpErlstSchedldExecStrtTme
OpErlstSchedldExecEndDte OpErlstSchedldExecEndDte EarliestEndDate
OpErlstSchedldExecEndTme OpErlstSchedldExecEndTme
OpLtstSchedldExecStrtDte OpLtstSchedldExecStrtDte Latest start
OpLtstSchedldExecStrtTme OpLtstSchedldExecStrtTme
OpLtstSchedldExecEndDte OpLtstSchedldExecEndDte Lat.finish date
OpLtstSchedldExecEndTme OpLtstSchedldExecEndTme
OpActualExecutionStartDate OpActualExecutionStartDate Execution Start Date
OpActualExecutionStartTime OpActualExecutionStartTime
OpActualExecutionEndDate OpActualExecutionEndDate Execution End Date
OpActualExecutionEndTime OpActualExecutionEndTime
ActyConfFcstdEndDate ActyConfFcstdEndDate
ActyConfFcstdEndTime ActyConfFcstdEndTime
ActualWorkQuantity ActualWorkQuantity Actual work
MaintenanceActivityType MaintenanceActivityType MaintActivType
BusinessArea BusinessArea Business Area
ProfitCenter ProfitCenter Profit Center
CostingSheet CostingSheet Costing Sheet
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
FunctionalArea FunctionalArea Sendr Fctl Area
MaintOrdOperationIsMRPRelevant MaintOrdOperationIsMRPRelevant Res./Purc. req.
MaintControllingObjectClass MaintControllingObjectClass Object Class
WrkCtrIntCapRqmtsDistr WrkCtrIntCapRqmtsDistr Int. dist. key
MaintOrdOperationOverheadCode MaintOrdOperationOverheadCode Overhead key
MaintOrderOperationQuantity MaintOrderOperationQuantity Operation Qty
MaintOrdOperationQuantityUnit MaintOrdOperationQuantityUnit Act/op UoM
Assembly Assembly Pegged Reqmt
MaintOperationExecStageCode MaintOperationExecStageCode Execution Stage
MaintOrdOpAssgdWBSElmntInt MaintOrdOpAssgdWBSElmntInt WBS Internal ID
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
MaintOrderOperationInternalID MaintOrderOperationInternalID Object number
MaintenanceObjectListItem MaintenanceObjectListItem Object counters
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
MaintOrdOpProcessPhaseCode MaintOrdOpProcessPhaseCode Process Phase
MaintOrdOpProcessSubPhaseCode MaintOrdOpProcessSubPhaseCode Process Subphase
AllMaintOrdCompCmtdQtsAreKept AllMaintOrdCompCmtdQtsAreKept Keep Committed Qties
ControllingArea ControllingArea Controlling Area
MaintOrderConfirmation MaintOrderConfirmation Confirmation
MaintOrderConfCntrValue MaintOrderConfCntrValue Counter
MaintOrdOpHasNoRemainingWork MaintOrdOpHasNoRemainingWork No Remain. Work
MaintOrdOpHasLeanServices MaintOrdOpHasLeanServices operation has srv
MaintOrdOpDelivDateAdjustment MaintOrdOpDelivDateAdjustment Align Date
TaskListType TaskListType Task List Type
TaskListGroup TaskListGroup Group
TaskListGroupCounter TaskListGroupCounter Group Counter
_OperationWorkCenter _OperationWorkCenter
_Supplier _Supplier
_PersonResponsible _PersonResponsible

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_MaintenanceOrderOperationTP.
-- 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_MaintenanceOrderOperationTP AS
SELECT
  MaintenanceOrder,
  MaintenanceOrderOperation,
  MaintenanceOrderSubOperation,
  MaintOrderRoutingNumber,
  MaintenanceOrderRoutingNode,
  SuperiorOperationInternalID,
  OperationControlKey,
  OperationDescription,
  OperationWorkCenterInternalID,
  OperationWorkCenterTypeCode,
  Plant,
  OperationStandardTextCode,
  Language,
  NumberOfTimeTickets,
  OperationPurgInfoRecdSearchTxt,
  OperationSupplier,
  OpExternalProcessingPrice,
  OpExternalProcessingPriceUnit,
  OpExternalProcessingCurrency,
  CostElement,
  OperationPurchasingInfoRecord,
  PurchasingOrganization,
  PurchasingGroup,
  MaterialGroup,
  OpPurchaseOutlineAgreement,
  OpPurchaseOutlineAgreementItem,
  OperationRequisitionerName,
  OperationTrackingNumber,
  NumberOfCapacities,
  OperationWorkPercent,
  OperationCalculationControl,
  ActivityType,
  OperationSystemCondition,
  OperationGoodsRecipientName,
  OperationUnloadingPointName,
  OperationPersonResponsible,
  EAMPlannedDeliveryDurnInDays,
  MaintOrderOperationDuration,
  MaintOrdOperationDurationUnit,
  OpErlstSchedldExecStrtDteTme,
  OpErlstSchedldExecEndDteTme,
  OpLtstSchedldExecStrtDteTme,
  OpLtstSchedldExecEndDteTme,
  OpActualExecutionStartDateTime,
  OpActualExecutionEndDateTime,
  OpBscStartDateConstraintType,
  OpBscEndDateConstraintType,
  MaintOrdOperationWorkDuration,
  MaintOrdOpWorkDurationUnit,
  MaintOrdOpConstraintStrtDteTme,
  ConstraintDateForBscStartDate,
  ConstraintTimeForBscStartTime,
  MaintOrdOpCstrtFinishDteTme,
  ConstraintDateForBscFinishDate,
  ConstraintTimeForBscFinishTime,
  MaintOrdOperationExecutionRate,
  Equipment,
  FunctionalLocation,
  OpErlstSchedldExecStrtDte,
  OpErlstSchedldExecStrtTme,
  OpErlstSchedldExecEndDte,
  OpErlstSchedldExecEndTme,
  OpLtstSchedldExecStrtDte,
  OpLtstSchedldExecStrtTme,
  OpLtstSchedldExecEndDte,
  OpLtstSchedldExecEndTme,
  OpActualExecutionStartDate,
  OpActualExecutionStartTime,
  OpActualExecutionEndDate,
  OpActualExecutionEndTime,
  ActyConfFcstdEndDate,
  ActyConfFcstdEndTime,
  ActualWorkQuantity,
  MaintenanceActivityType,
  BusinessArea,
  ProfitCenter,
  CostingSheet,
  TaxJurisdiction,
  FunctionalArea,
  MaintOrdOperationIsMRPRelevant,
  MaintControllingObjectClass,
  WrkCtrIntCapRqmtsDistr,
  MaintOrdOperationOverheadCode,
  MaintOrderOperationQuantity,
  MaintOrdOperationQuantityUnit,
  Assembly,
  MaintOperationExecStageCode,
  MaintOrdOpAssgdWBSElmntInt,
  IsMarkedForDeletion,
  MaintOrderOperationInternalID,
  MaintenanceObjectListItem,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  MaintOrdOpProcessPhaseCode,
  MaintOrdOpProcessSubPhaseCode,
  AllMaintOrdCompCmtdQtsAreKept,
  ControllingArea,
  MaintOrderConfirmation,
  MaintOrderConfCntrValue,
  MaintOrdOpHasNoRemainingWork,
  MaintOrdOpHasLeanServices,
  MaintOrdOpDelivDateAdjustment,
  TaskListType,
  TaskListGroup,
  TaskListGroupCounter
FROM R_MaintenanceOrderOperationTP
;

Learn More