What is I_MaintOrderSubOperationTP in SAP S/4HANA?

I_MaintOrderSubOperationTP is a transactional CDS view in SAP S/4HANA. MaintOrder Sub-Operation w/ Tech. Object It contains 88 fields.

Which tables does I_MaintOrderSubOperationTP read from?

I_MaintOrderSubOperationTP reads data from: I_MaintOrderSubOperTechObj.

What VDM layer is I_MaintOrderSubOperationTP?

I_MaintOrderSubOperationTP is classified as a Transactional view that supports create, update, and delete operations.

I_MaintOrderSubOperationTP

DDL: I_MAINTORDERSUBOPERATIONTP SQL: IMTORDSUBOPERTP Type: view TRANSACTIONAL

88 Fields 1 Data Sources 5 Associations

MaintOrder Sub-Operation w/ Tech. Object

I_MaintOrderSubOperationTP is a Transactional CDS View that provides data about "MaintOrder Sub-Operation w/ Tech. Object" in SAP S/4HANA. It reads from 1 data source (I_MaintOrderSubOperTechObj) and exposes 88 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation. It has 5 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_MaintOrderSubOperTechObj	I_MaintOrderSubOperTechObj	from

Associations (5)

Cardinality	Target	Alias	Condition
[1..1]	I_MaintOrderTP	_MaintOrderTP	`_MaintOrderTP.MaintenanceOrder = $projection.MaintenanceOrder`
[0..*]	I_MaintOrderComponentTP	_MaintOrderComponentTP	`_MaintOrderComponentTP.MaintenanceOrder = $projection.MaintenanceOrder and _MaintOrderComponentTP.MaintenanceOrderOperation = $projection.MaintenanceOrderOperation`
[1..1]	I_MaintOrderOperationTP	_MaintOrderOperationTP	`_MaintOrderOperationTP.MaintenanceOrder = $projection.MaintenanceOrder and _MaintOrderOperationTP.MaintenanceOrderOperation = $projection.MaintenanceOrderOperation`
[0..1]	I_Indicator	_IsFinallyConfirmed	`$projection.IsFinallyConfirmed = _IsFinallyConfirmed.IndicatorValue`
[0..*]	I_StatusObjectStatus	_StatusObjectStatus	`$projection.MaintOrderOperationInternalID = _StatusObjectStatus.StatusObject`

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	IMTORDSUBOPERTP	view
EndUserText.label	MaintOrder Sub-Operation w/ Tech. Object	view
ObjectModel.writeDraftPersistence	MAINTORDSOP_D	view
VDM.viewType	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.draftEnabled	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.createEnabled	true	view
ObjectModel.updateEnabled	true	view
ObjectModel.deleteEnabled	true	view

Fields (88)

Key	Field	Source Table	Source Field	Description
KEY	MaintenanceOrder	I_MaintOrderSubOperTechObj	MaintenanceOrder	Order
KEY	MaintenanceOrderOperation	I_MaintOrderSubOperTechObj	MaintenanceOrderOperation	Suboperation
KEY	MaintenanceOrderSubOperation	I_MaintOrderSubOperTechObj	MaintenanceOrderSubOperation	Suboperation
	MaintOrderSubOperationForEdit	I_MaintOrderSubOperTechObj	MaintenanceOrderSubOperation	Suboperation
	TechnicalObject	I_MaintOrderSubOperTechObj	TechnicalObject	Technical Object
	TechObjIsEquipOrFuncnlLoc	I_MaintOrderSubOperTechObj	TechObjIsEquipOrFuncnlLoc	Tech. Obj. Type
	ControllingArea	I_MaintOrderSubOperTechObj	ControllingArea	Controlling Area
	MaintOrderRoutingNumber	I_MaintOrderSubOperTechObj	MaintOrderRoutingNumber	Plan No.f.Oper.
	MaintOrderOperationCounter	I_MaintOrderSubOperTechObj	MaintOrderOperationCounter	Counter
	OperationControlKey	I_MaintOrderSubOperTechObj	OperationControlKey	Control Key
	OperationDescription	I_MaintOrderSubOperTechObj	OperationDescription	Op. Short Text
	MaintOrderOperationInternalID	I_MaintOrderSubOperTechObj	MaintOrderOperationInternalID	Object number
	Equipment	I_MaintOrderSubOperTechObj	Equipment	Equipment check
	FunctionalLocation	I_MaintOrderSubOperTechObj	FunctionalLocation	Object ID
	Plant	I_MaintOrderSubOperTechObj	Plant	Valuation Area
	OperationWorkCenterInternalID	I_MaintOrderSubOperTechObj	OperationWorkCenterInternalID	Object ID
	OperationWorkCenterTypeCode	I_MaintOrderSubOperTechObj	OperationWorkCenterTypeCode
	OperationPurgInfoRecdSearchTxt	I_MaintOrderSubOperTechObj	OperationPurgInfoRecdSearchTxt	Sort Term
	OperationRequisitionerName	I_MaintOrderSubOperTechObj	OperationRequisitionerName	Requisitioner
	OperationGoodsRecipientName	I_MaintOrderSubOperTechObj	OperationGoodsRecipientName	Recipient
	OpExternalProcessingPrice	I_MaintOrderSubOperTechObj	OpExternalProcessingPrice	Price
	OpExternalProcessingPriceUnit	I_MaintOrderSubOperTechObj	OpExternalProcessingPriceUnit	Price unit
	OpExternalProcessingCurrency	I_MaintOrderSubOperTechObj	OpExternalProcessingCurrency	Currency
	OperationTrackingNumber	I_MaintOrderSubOperTechObj	OperationTrackingNumber	Tracking Number
	OperationPurchasingInfoRecord	I_MaintOrderSubOperTechObj	OperationPurchasingInfoRecord	Info Record
	OperationUnloadingPointName	I_MaintOrderSubOperTechObj	OperationUnloadingPointName	Unloading Point
	OpPurchaseOutlineAgreement	I_MaintOrderSubOperTechObj	OpPurchaseOutlineAgreement	Agreement
	OpPurchaseOutlineAgreementItem	I_MaintOrderSubOperTechObj	OpPurchaseOutlineAgreementItem	Agreement Item
	OperationSupplier	I_MaintOrderSubOperTechObj	OperationSupplier	Supplier
	OperationPersonResponsible	I_MaintOrderSubOperTechObj	OperationPersonResponsible	Personnel no.
	Assembly	I_MaintOrderSubOperTechObj	Assembly	Pegged Reqmt
	OperationSystemCondition	I_MaintOrderSubOperTechObj	OperationSystemCondition	SystemCondition
	CostCtrActivityType	I_MaintOrderSubOperTechObj	CostCtrActivityType	Activity Type
	ReqgCostCenterControllingArea	I_MaintOrderSubOperTechObj	ReqgCostCenterControllingArea
	OperationCalculationControl	I_MaintOrderSubOperTechObj	OperationCalculationControl	Calculation key
	OperationWorkPercent	I_MaintOrderSubOperTechObj	OperationWorkPercent	Percent
	CapacityRequirement	I_MaintOrderSubOperTechObj	CapacityRequirement
	CapacityRequirementItem	I_MaintOrderSubOperTechObj	CapacityRequirementItem
	PurchaseRequisition	I_MaintOrderSubOperTechObj	PurchaseRequisition	Requisition
	PurchaseRequisitionItem	I_MaintOrderSubOperTechObj	PurchaseRequisitionItem	Requisn. item
	NumberOfCapacities	I_MaintOrderSubOperTechObj	NumberOfCapacities	Number
	OperationPlannedWork	I_MaintOrderSubOperTechObj	OperationPlannedWork
	OperationPlannedWorkUnit	I_MaintOrderSubOperTechObj	OperationPlannedWorkUnit
	OperationDuration	I_MaintOrderSubOperTechObj	OperationDuration
	OperationDurationUnit	I_MaintOrderSubOperTechObj	OperationDurationUnit
	OperationWorkCenter	I_MaintOrderSubOperTechObj	OperationWorkCenter
	CostElement	I_MaintOrderSubOperTechObj	CostElement	G/L Account
	MaterialGroup	I_MaintOrderSubOperTechObj	MaterialGroup	Product Group
	PurchasingGroup	I_MaintOrderSubOperTechObj	PurchasingGroup	Purchasing Group
	PurchasingOrganization	I_MaintOrderSubOperTechObj	PurchasingOrganization	Purchasing Organization
	Language	I_MaintOrderSubOperTechObj	Language	Report Text Language
	OperationHasLongText	I_MaintOrderSubOperTechObj	OperationHasLongText
	IsDeleted	I_MaintOrderSubOperTechObj	IsDeleted	TRUE
	MaintOperationExecStageCode	I_MaintOrderSubOperTechObj	MaintOperationExecStageCode	Execution Stage
	MaintOrdOpProcessPhaseCode	I_MaintOrderSubOperTechObj	MaintOrdOpProcessPhaseCode	Process Phase
	MaintOrdOpProcessSubPhaseCode	I_MaintOrderSubOperTechObj	MaintOrdOpProcessSubPhaseCode	Process Subphase
	MaintenanceJobVerification	I_MaintOrderSubOperTechObj	MaintenanceJobVerification
	MaintOperationalChecklistType	I_MaintOrderSubOperTechObj	MaintOperationalChecklistType	Checklist Type
	ConfirmationIsNotPossible
	_ActivityType	I_MaintOrderSubOperTechObj	_ActivityType
	_CostElement	I_MaintOrderSubOperTechObj	_CostElement
	_MaterialGroup	I_MaintOrderSubOperTechObj	_MaterialGroup
	_Assembly	I_MaintOrderSubOperTechObj	_Assembly
	_MaintenanceOperationComponent	I_MaintOrderSubOperTechObj	_MaintenanceOperationComponent
	_MaintenanceOrder	I_MaintOrderSubOperTechObj	_MaintenanceOrder
	_MaintenanceOrderOperation	I_MaintOrderSubOperTechObj	_MaintenanceOrderOperation
	_OperationCalculationControl	I_MaintOrderSubOperTechObj	_OperationCalculationControl
	_OperationControlKey	I_MaintOrderSubOperTechObj	_OperationControlKey
	_OperationPlanningValues	I_MaintOrderSubOperTechObj	_OperationPlanningValues
	_OperationSystemCondition	I_MaintOrderSubOperTechObj	_OperationSystemCondition
	_OpExternalProcessingCurrency	I_MaintOrderSubOperTechObj	_OpExternalProcessingCurrency
	_PlannedWorkUnitOfMeasure	I_MaintOrderSubOperTechObj	_PlannedWorkUnitOfMeasure
	_Plant	I_MaintOrderSubOperTechObj	_Plant
	_StatusObject	I_MaintOrderSubOperTechObj	_StatusObject
	_TechnicalObject	I_MaintOrderSubOperTechObj	_TechnicalObject
	_TechObjIsEquipOrFuncnlLoc	I_MaintOrderSubOperTechObj	_TechObjIsEquipOrFuncnlLoc
	_WorkCenter	I_MaintOrderSubOperTechObj	_WorkCenter
	_MaintOrderOperObjectListLink	I_MaintOrderSubOperTechObj	_MaintOrderOperObjectListLink
	_OperationHasLongText	I_MaintOrderSubOperTechObj	_OperationHasLongText
	_Supplier	I_MaintOrderSubOperTechObj	_Supplier
	_PersonResponsible	I_MaintOrderSubOperTechObj	_PersonResponsible
	_MaintOperationExecStageCode	I_MaintOrderSubOperTechObj	_MaintOperationExecStageCode
	_EAMProcessPhase	I_MaintOrderSubOperTechObj	_EAMProcessPhase
	_EAMProcessSubPhase	I_MaintOrderSubOperTechObj	_EAMProcessSubPhase
	_IsFinallyConfirmed		_IsFinallyConfirmed
	_MaintOrderTP		_MaintOrderTP
	_MaintOrderOperationTP		_MaintOrderOperationTP
	_MaintOrderComponentTP		_MaintOrderComponentTP

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_MaintOrderSubOperationTP.
-- 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: IMTORDSUBOPERTP

CREATE VIEW I_MaintOrderSubOperationTP AS
SELECT
  I_MaintOrderSubOperTechObj.MaintenanceOrder AS MaintenanceOrder,
  I_MaintOrderSubOperTechObj.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  I_MaintOrderSubOperTechObj.MaintenanceOrderSubOperation AS MaintenanceOrderSubOperation,
  I_MaintOrderSubOperTechObj.MaintenanceOrderSubOperation AS MaintOrderSubOperationForEdit,
  I_MaintOrderSubOperTechObj.TechnicalObject AS TechnicalObject,
  I_MaintOrderSubOperTechObj.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  I_MaintOrderSubOperTechObj.ControllingArea AS ControllingArea,
  I_MaintOrderSubOperTechObj.MaintOrderRoutingNumber AS MaintOrderRoutingNumber,
  I_MaintOrderSubOperTechObj.MaintOrderOperationCounter AS MaintOrderOperationCounter,
  I_MaintOrderSubOperTechObj.OperationControlKey AS OperationControlKey,
  I_MaintOrderSubOperTechObj.OperationDescription AS OperationDescription,
  I_MaintOrderSubOperTechObj.MaintOrderOperationInternalID AS MaintOrderOperationInternalID,
  I_MaintOrderSubOperTechObj.Equipment AS Equipment,
  I_MaintOrderSubOperTechObj.FunctionalLocation AS FunctionalLocation,
  I_MaintOrderSubOperTechObj.Plant AS Plant,
  I_MaintOrderSubOperTechObj.OperationWorkCenterInternalID AS OperationWorkCenterInternalID,
  I_MaintOrderSubOperTechObj.OperationWorkCenterTypeCode AS OperationWorkCenterTypeCode,
  I_MaintOrderSubOperTechObj.OperationPurgInfoRecdSearchTxt AS OperationPurgInfoRecdSearchTxt,
  I_MaintOrderSubOperTechObj.OperationRequisitionerName AS OperationRequisitionerName,
  I_MaintOrderSubOperTechObj.OperationGoodsRecipientName AS OperationGoodsRecipientName,
  I_MaintOrderSubOperTechObj.OpExternalProcessingPrice AS OpExternalProcessingPrice,
  I_MaintOrderSubOperTechObj.OpExternalProcessingPriceUnit AS OpExternalProcessingPriceUnit,
  I_MaintOrderSubOperTechObj.OpExternalProcessingCurrency AS OpExternalProcessingCurrency,
  I_MaintOrderSubOperTechObj.OperationTrackingNumber AS OperationTrackingNumber,
  I_MaintOrderSubOperTechObj.OperationPurchasingInfoRecord AS OperationPurchasingInfoRecord,
  I_MaintOrderSubOperTechObj.OperationUnloadingPointName AS OperationUnloadingPointName,
  I_MaintOrderSubOperTechObj.OpPurchaseOutlineAgreement AS OpPurchaseOutlineAgreement,
  I_MaintOrderSubOperTechObj.OpPurchaseOutlineAgreementItem AS OpPurchaseOutlineAgreementItem,
  I_MaintOrderSubOperTechObj.OperationSupplier AS OperationSupplier,
  I_MaintOrderSubOperTechObj.OperationPersonResponsible AS OperationPersonResponsible,
  I_MaintOrderSubOperTechObj.Assembly AS Assembly,
  I_MaintOrderSubOperTechObj.OperationSystemCondition AS OperationSystemCondition,
  I_MaintOrderSubOperTechObj.CostCtrActivityType AS CostCtrActivityType,
  I_MaintOrderSubOperTechObj.ReqgCostCenterControllingArea AS ReqgCostCenterControllingArea,
  I_MaintOrderSubOperTechObj.OperationCalculationControl AS OperationCalculationControl,
  I_MaintOrderSubOperTechObj.OperationWorkPercent AS OperationWorkPercent,
  I_MaintOrderSubOperTechObj.CapacityRequirement AS CapacityRequirement,
  I_MaintOrderSubOperTechObj.CapacityRequirementItem AS CapacityRequirementItem,
  I_MaintOrderSubOperTechObj.PurchaseRequisition AS PurchaseRequisition,
  I_MaintOrderSubOperTechObj.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_MaintOrderSubOperTechObj.NumberOfCapacities AS NumberOfCapacities,
  I_MaintOrderSubOperTechObj.OperationPlannedWork AS OperationPlannedWork,
  I_MaintOrderSubOperTechObj.OperationPlannedWorkUnit AS OperationPlannedWorkUnit,
  I_MaintOrderSubOperTechObj.OperationDuration AS OperationDuration,
  I_MaintOrderSubOperTechObj.OperationDurationUnit AS OperationDurationUnit,
  I_MaintOrderSubOperTechObj.OperationWorkCenter AS OperationWorkCenter,
  I_MaintOrderSubOperTechObj.CostElement AS CostElement,
  I_MaintOrderSubOperTechObj.MaterialGroup AS MaterialGroup,
  I_MaintOrderSubOperTechObj.PurchasingGroup AS PurchasingGroup,
  I_MaintOrderSubOperTechObj.PurchasingOrganization AS PurchasingOrganization,
  I_MaintOrderSubOperTechObj.Language AS Language,
  I_MaintOrderSubOperTechObj.OperationHasLongText AS OperationHasLongText,
  I_MaintOrderSubOperTechObj.IsDeleted AS IsDeleted,
  I_MaintOrderSubOperTechObj.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  I_MaintOrderSubOperTechObj.MaintOrdOpProcessPhaseCode AS MaintOrdOpProcessPhaseCode,
  I_MaintOrderSubOperTechObj.MaintOrdOpProcessSubPhaseCode AS MaintOrdOpProcessSubPhaseCode,
  I_MaintOrderSubOperTechObj.MaintenanceJobVerification AS MaintenanceJobVerification,
  I_MaintOrderSubOperTechObj.MaintOperationalChecklistType AS MaintOperationalChecklistType,
  I_MaintOrderSubOperTechObj._OperationControlKey.ConfirmationIsNotPossible AS ConfirmationIsNotPossible,
  I_MaintOrderSubOperTechObj._ActivityType AS _ActivityType,
  I_MaintOrderSubOperTechObj._CostElement AS _CostElement,
  I_MaintOrderSubOperTechObj._MaterialGroup AS _MaterialGroup,
  I_MaintOrderSubOperTechObj._Assembly AS _Assembly,
  I_MaintOrderSubOperTechObj._MaintenanceOperationComponent AS _MaintenanceOperationComponent,
  I_MaintOrderSubOperTechObj._MaintenanceOrder AS _MaintenanceOrder,
  I_MaintOrderSubOperTechObj._MaintenanceOrderOperation AS _MaintenanceOrderOperation,
  I_MaintOrderSubOperTechObj._OperationCalculationControl AS _OperationCalculationControl,
  I_MaintOrderSubOperTechObj._OperationControlKey AS _OperationControlKey,
  I_MaintOrderSubOperTechObj._OperationPlanningValues AS _OperationPlanningValues,
  I_MaintOrderSubOperTechObj._OperationSystemCondition AS _OperationSystemCondition,
  I_MaintOrderSubOperTechObj._OpExternalProcessingCurrency AS _OpExternalProcessingCurrency,
  I_MaintOrderSubOperTechObj._PlannedWorkUnitOfMeasure AS _PlannedWorkUnitOfMeasure,
  I_MaintOrderSubOperTechObj._Plant AS _Plant,
  I_MaintOrderSubOperTechObj._StatusObject AS _StatusObject,
  I_MaintOrderSubOperTechObj._TechnicalObject AS _TechnicalObject,
  I_MaintOrderSubOperTechObj._TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc,
  I_MaintOrderSubOperTechObj._WorkCenter AS _WorkCenter,
  I_MaintOrderSubOperTechObj._MaintOrderOperObjectListLink AS _MaintOrderOperObjectListLink,
  I_MaintOrderSubOperTechObj._OperationHasLongText AS _OperationHasLongText,
  I_MaintOrderSubOperTechObj._Supplier AS _Supplier,
  I_MaintOrderSubOperTechObj._PersonResponsible AS _PersonResponsible,
  I_MaintOrderSubOperTechObj._MaintOperationExecStageCode AS _MaintOperationExecStageCode,
  I_MaintOrderSubOperTechObj._EAMProcessPhase AS _EAMProcessPhase,
  I_MaintOrderSubOperTechObj._EAMProcessSubPhase AS _EAMProcessSubPhase
FROM I_MaintOrderSubOperTechObj
LEFT OUTER JOIN I_MaintOrderTP AS _MaintOrderTP ON _MaintOrderTP.MaintenanceOrder = MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN I_MaintOrderComponentTP AS _MaintOrderComponentTP ON _MaintOrderComponentTP.MaintenanceOrder = MaintenanceOrder AND _MaintOrderComponentTP.MaintenanceOrderOperation = MaintenanceOrderOperation  -- association [0..*]
LEFT OUTER JOIN I_MaintOrderOperationTP AS _MaintOrderOperationTP ON _MaintOrderOperationTP.MaintenanceOrder = MaintenanceOrder AND _MaintOrderOperationTP.MaintenanceOrderOperation = MaintenanceOrderOperation  -- association [1..1]
LEFT OUTER JOIN I_Indicator AS _IsFinallyConfirmed ON IsFinallyConfirmed = _IsFinallyConfirmed.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatus AS _StatusObjectStatus ON MaintOrderOperationInternalID = _StatusObjectStatus.StatusObject  -- association [0..*]
;

Depth:

I_MaintOrderSubOperationTP view

I_MaintOrderSubOperTechObj view