Which tables does C_MaintOrderSubOperationTP use?

C_MaintOrderSubOperationTP reads from 1 data source(s): I_MaintOrderSubOperationTP.

C_MaintOrderSubOperationTP

Q: How many fields does C_MaintOrderSubOperationTP have?

C_MaintOrderSubOperationTP has 85 fields. Key fields: MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation.

DDL: C_MAINTORDERSUBOPERATIONTP SQL: CMTORDSUBOPERTP Type: view CONSUMPTION Package: ODATA_EAM_MALFUNCTION_MANAGE

Consumption View for MaintOrder Suboperation

C_MaintOrderSubOperationTP is a Consumption CDS View that provides data about "Consumption View for MaintOrder Suboperation" in SAP S/4HANA. It reads from 1 data source (I_MaintOrderSubOperationTP) and exposes 85 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation. It has 2 associations to related views. Part of development package ODATA_EAM_MALFUNCTION_MANAGE.

Data Sources (1)

Source	Alias	Join Type
I_MaintOrderSubOperationTP	_MaintOrderSubOperationTP	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	C_MaintOrderTP	_MaintOrderTP	`$projection.MaintenanceOrder = _MaintOrderTP.MaintenanceOrder`
[1..1]	C_MaintOrderOperationTP	_MaintOrderOperationTP	`$projection.MaintenanceOrder = _MaintOrderOperationTP.MaintenanceOrder and $projection.MaintenanceOrderOperation = _MaintOrderOperationTP.MaintenanceOrderOperation`

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	CMTORDSUBOPERTP	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Consumption View for MaintOrder Suboperation	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.representativeKey	MaintenanceOrderSubOperation	view
ObjectModel.createEnabled	true	view
ObjectModel.updateEnabled	true	view
ObjectModel.deleteEnabled	true	view
ObjectModel.transactionalProcessingDelegated	true	view

Fields (85)

Key	Field	Source Table	Source Field	Description
KEY	MaintenanceOrder	I_MaintOrderSubOperationTP	MaintenanceOrder
KEY	MaintenanceOrderOperation
KEY	MaintenanceOrderSubOperation
	MaintOrderSubOperationForEdit
	TechnicalObject	I_MaintOrderSubOperationTP	TechnicalObject
	TechObjIsEquipOrFuncnlLoc	I_MaintOrderSubOperationTP	TechObjIsEquipOrFuncnlLoc
	ControllingArea	I_MaintOrderSubOperationTP	ControllingArea
	MaintOrderRoutingNumber	I_MaintOrderSubOperationTP	MaintOrderRoutingNumber
	MaintOrderOperationCounter	I_MaintOrderSubOperationTP	MaintOrderOperationCounter
	OperationControlKey	I_MaintOrderSubOperationTP	OperationControlKey
	OperationDescription	I_MaintOrderSubOperationTP	OperationDescription	Description
	MaintOrderOperationInternalID	I_MaintOrderSubOperationTP	MaintOrderOperationInternalID
	Equipment	I_MaintOrderSubOperationTP	Equipment
	FunctionalLocation	I_MaintOrderSubOperationTP	FunctionalLocation
	Plant	I_MaintOrderSubOperationTP	Plant
	OperationWorkCenterInternalID	I_MaintOrderSubOperationTP	OperationWorkCenterInternalID
	OperationWorkCenterTypeCode	I_MaintOrderSubOperationTP	OperationWorkCenterTypeCode
	OperationPurgInfoRecdSearchTxt	I_MaintOrderSubOperationTP	OperationPurgInfoRecdSearchTxt
	OperationRequisitionerName	I_MaintOrderSubOperationTP	OperationRequisitionerName
	OperationGoodsRecipientName	I_MaintOrderSubOperationTP	OperationGoodsRecipientName
	OpExternalProcessingPrice	I_MaintOrderSubOperationTP	OpExternalProcessingPrice
	OpExternalProcessingPriceUnit	I_MaintOrderSubOperationTP	OpExternalProcessingPriceUnit
	OpExternalProcessingCurrency	I_MaintOrderSubOperationTP	OpExternalProcessingCurrency
	OperationTrackingNumber	I_MaintOrderSubOperationTP	OperationTrackingNumber
	OperationPurchasingInfoRecord	I_MaintOrderSubOperationTP	OperationPurchasingInfoRecord
	OperationUnloadingPointName	I_MaintOrderSubOperationTP	OperationUnloadingPointName
	OpPurchaseOutlineAgreement	I_MaintOrderSubOperationTP	OpPurchaseOutlineAgreement
	OpPurchaseOutlineAgreementItem	I_MaintOrderSubOperationTP	OpPurchaseOutlineAgreementItem
	OperationSupplier	I_MaintOrderSubOperationTP	OperationSupplier
	OperationPersonResponsible	I_MaintOrderSubOperationTP	OperationPersonResponsible
	Assembly	I_MaintOrderSubOperationTP	Assembly
	OperationSystemCondition	I_MaintOrderSubOperationTP	OperationSystemCondition
	CostCtrActivityType	I_MaintOrderSubOperationTP	CostCtrActivityType
	ReqgCostCenterControllingArea	I_MaintOrderSubOperationTP	ReqgCostCenterControllingArea
	OperationCalculationControl	I_MaintOrderSubOperationTP	OperationCalculationControl
	OperationWorkPercent	I_MaintOrderSubOperationTP	OperationWorkPercent
	CapacityRequirement	I_MaintOrderSubOperationTP	CapacityRequirement
	PurchaseRequisition	I_MaintOrderSubOperationTP	PurchaseRequisition
	PurchaseRequisitionItem	I_MaintOrderSubOperationTP	PurchaseRequisitionItem
	NumberOfCapacities	I_MaintOrderSubOperationTP	NumberOfCapacities
	OperationPlannedWork	I_MaintOrderSubOperationTP	OperationPlannedWork	Planned Effort
	OperationPlannedWorkUnit	I_MaintOrderSubOperationTP	OperationPlannedWorkUnit
	OperationDuration	I_MaintOrderSubOperationTP	OperationDuration
	OperationDurationUnit	I_MaintOrderSubOperationTP	OperationDurationUnit
	OperationWorkCenter	I_MaintOrderSubOperationTP	OperationWorkCenter
	CostElement	I_MaintOrderSubOperationTP	CostElement
	MaterialGroup	I_MaintOrderSubOperationTP	MaterialGroup
	PurchasingGroup	I_MaintOrderSubOperationTP	PurchasingGroup
	PurchasingOrganization	I_MaintOrderSubOperationTP	PurchasingOrganization
	Language	I_MaintOrderSubOperationTP	Language
	OperationHasLongText	I_MaintOrderSubOperationTP	OperationHasLongText
	IsDeleted	I_MaintOrderSubOperationTP	IsDeleted
	MaintOperationExecStageCode	I_MaintOrderSubOperationTP	MaintOperationExecStageCode
	MaintOrdOpProcessPhaseCode	I_MaintOrderSubOperationTP	MaintOrdOpProcessPhaseCode
	MaintOrdOpProcessSubPhaseCode	I_MaintOrderSubOperationTP	MaintOrdOpProcessSubPhaseCode
	IsFinallyConfirmed	I_MaintOrderSubOperationTP	IsFinallyConfirmed
	ConfirmationIsNotPossible	I_MaintOrderSubOperationTP	ConfirmationIsNotPossible
	_ActivityType	I_MaintOrderSubOperationTP	_ActivityType
	_Assembly	I_MaintOrderSubOperationTP	_Assembly
	_CostElement	I_MaintOrderSubOperationTP	_CostElement
	_EAMProcessPhase	I_MaintOrderSubOperationTP	_EAMProcessPhase
	_EAMProcessSubPhase	I_MaintOrderSubOperationTP	_EAMProcessSubPhase
	_MaintenanceOperationComponent
	_MaintenanceOrder	I_MaintOrderSubOperationTP	_MaintenanceOrder
	_MaintenanceOrderOperation	I_MaintOrderSubOperationTP	_MaintenanceOrderOperation
	_MaintOperationExecStageCode	I_MaintOrderSubOperationTP	_MaintOperationExecStageCode
	_MaintOrderComponentTP
	_MaintOrderOperObjectListLink
	_MaterialGroup	I_MaintOrderSubOperationTP	_MaterialGroup
	_OperationCalculationControl	I_MaintOrderSubOperationTP	_OperationCalculationControl
	_OperationControlKey	I_MaintOrderSubOperationTP	_OperationControlKey
	_OperationHasLongText	I_MaintOrderSubOperationTP	_OperationHasLongText
	_OperationPlanningValues	I_MaintOrderSubOperationTP	_OperationPlanningValues
	_OperationSystemCondition	I_MaintOrderSubOperationTP	_OperationSystemCondition
	_OpExternalProcessingCurrency	I_MaintOrderSubOperationTP	_OpExternalProcessingCurrency
	_PersonResponsible	I_MaintOrderSubOperationTP	_PersonResponsible
	_PlannedWorkUnitOfMeasure	I_MaintOrderSubOperationTP	_PlannedWorkUnitOfMeasure
	_Plant	I_MaintOrderSubOperationTP	_Plant
	_StatusObject	I_MaintOrderSubOperationTP	_StatusObject
	_Supplier	I_MaintOrderSubOperationTP	_Supplier
	_TechnicalObject	I_MaintOrderSubOperationTP	_TechnicalObject
	_TechObjIsEquipOrFuncnlLoc	I_MaintOrderSubOperationTP	_TechObjIsEquipOrFuncnlLoc
	_WorkCenter	I_MaintOrderSubOperationTP	_WorkCenter
	_MaintOrderTP		_MaintOrderTP
	_MaintOrderOperationTP		_MaintOrderOperationTP

@AbapCatalog.sqlViewName: 'CMTORDSUBOPERTP'
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Consumption View for MaintOrder Suboperation'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL

@ObjectModel: {
  representativeKey : 'MaintenanceOrderSubOperation',
  semanticKey: ['MaintenanceOrderSubOperation', 'MaintenanceOrderOperation', 'MaintenanceOrder'],
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true,
  transactionalProcessingDelegated: true
}

@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')

define view C_MaintOrderSubOperationTP
  as select from I_MaintOrderSubOperationTP as _MaintOrderSubOperationTP
  association [1..1] to C_MaintOrderTP          as _MaintOrderTP          on  $projection.MaintenanceOrder = _MaintOrderTP.MaintenanceOrder
  association [1..1] to C_MaintOrderOperationTP as _MaintOrderOperationTP on  $projection.MaintenanceOrder          = _MaintOrderOperationTP.MaintenanceOrder
                                                                          and $projection.MaintenanceOrderOperation = _MaintOrderOperationTP.MaintenanceOrderOperation
  {
      @ObjectModel.foreignKey.association: '_MaintOrderTP'
  key _MaintOrderSubOperationTP.MaintenanceOrder,
  key cast(_MaintOrderSubOperationTP.MaintenanceOrderOperation as maintenanceorderoperation preserving type)          as MaintenanceOrderOperation,
  key cast( _MaintOrderSubOperationTP.MaintenanceOrderSubOperation as maintenanceordersuboperation preserving type )  as MaintenanceOrderSubOperation,
      cast( _MaintOrderSubOperationTP.MaintOrderSubOperationForEdit as maintenanceordersuboperation preserving type ) as MaintOrderSubOperationForEdit,
      _MaintOrderSubOperationTP.TechnicalObject,
      _MaintOrderSubOperationTP.TechObjIsEquipOrFuncnlLoc,
      _MaintOrderSubOperationTP.ControllingArea,
      _MaintOrderSubOperationTP.MaintOrderRoutingNumber,
      _MaintOrderSubOperationTP.MaintOrderOperationCounter,
      _MaintOrderSubOperationTP.OperationControlKey,
      @EndUserText.label: 'Description'
      _MaintOrderSubOperationTP.OperationDescription,
      _MaintOrderSubOperationTP.MaintOrderOperationInternalID,
      _MaintOrderSubOperationTP.Equipment,
      _MaintOrderSubOperationTP.FunctionalLocation,
      _MaintOrderSubOperationTP.Plant,
      _MaintOrderSubOperationTP.OperationWorkCenterInternalID,
      _MaintOrderSubOperationTP.OperationWorkCenterTypeCode,
      _MaintOrderSubOperationTP.OperationPurgInfoRecdSearchTxt,
      _MaintOrderSubOperationTP.OperationRequisitionerName,
      _MaintOrderSubOperationTP.OperationGoodsRecipientName,
      _MaintOrderSubOperationTP.OpExternalProcessingPrice,
      _MaintOrderSubOperationTP.OpExternalProcessingPriceUnit,
      _MaintOrderSubOperationTP.OpExternalProcessingCurrency,
      _MaintOrderSubOperationTP.OperationTrackingNumber,
      _MaintOrderSubOperationTP.OperationPurchasingInfoRecord,
      _MaintOrderSubOperationTP.OperationUnloadingPointName,
      _MaintOrderSubOperationTP.OpPurchaseOutlineAgreement,
      _MaintOrderSubOperationTP.OpPurchaseOutlineAgreementItem,
      _MaintOrderSubOperationTP.OperationSupplier,
      _MaintOrderSubOperationTP.OperationPersonResponsible,      
      _MaintOrderSubOperationTP.Assembly,
      _MaintOrderSubOperationTP.OperationSystemCondition,
      _MaintOrderSubOperationTP.CostCtrActivityType,
      _MaintOrderSubOperationTP.ReqgCostCenterControllingArea,
      _MaintOrderSubOperationTP.OperationCalculationControl,
      _MaintOrderSubOperationTP.OperationWorkPercent,
      _MaintOrderSubOperationTP.CapacityRequirement,
      _MaintOrderSubOperationTP.PurchaseRequisition,
      _MaintOrderSubOperationTP.PurchaseRequisitionItem,
      _MaintOrderSubOperationTP.NumberOfCapacities,
      @EndUserText.label: 'Planned Effort'      
      _MaintOrderSubOperationTP.OperationPlannedWork,
      _MaintOrderSubOperationTP.OperationPlannedWorkUnit,
      _MaintOrderSubOperationTP.OperationDuration,
      _MaintOrderSubOperationTP.OperationDurationUnit,
      _MaintOrderSubOperationTP.OperationWorkCenter,
      _MaintOrderSubOperationTP.CostElement,
      _MaintOrderSubOperationTP.MaterialGroup,
      _MaintOrderSubOperationTP.PurchasingGroup,
      _MaintOrderSubOperationTP.PurchasingOrganization,
      _MaintOrderSubOperationTP.Language,
      _MaintOrderSubOperationTP.OperationHasLongText,
      _MaintOrderSubOperationTP.IsDeleted,
      _MaintOrderSubOperationTP.MaintOperationExecStageCode,
      _MaintOrderSubOperationTP.MaintOrdOpProcessPhaseCode,
      _MaintOrderSubOperationTP.MaintOrdOpProcessSubPhaseCode,
      @ObjectModel.readOnly: true
      @Semantics.quantity.unitOfMeasure: 'OperationPlannedWorkUnit'
      _MaintOrderSubOperationTP._OperationPlanningValues.ForecastedWorkQty,
      _MaintOrderSubOperationTP.IsFinallyConfirmed,
      _MaintOrderSubOperationTP.ConfirmationIsNotPossible,
      /* Associations */
      //I_MaintOrderSubOperationTP

      _MaintOrderSubOperationTP._ActivityType,
      _MaintOrderSubOperationTP._Assembly,
      _MaintOrderSubOperationTP._CostElement,
      _MaintOrderSubOperationTP._EAMProcessPhase,
      _MaintOrderSubOperationTP._EAMProcessSubPhase,
      --_MaintOrderSubOperationTP._MaintenanceOperationComponent,
      _MaintOrderSubOperationTP._MaintenanceOrder,
      _MaintOrderSubOperationTP._MaintenanceOrderOperation,
      _MaintOrderSubOperationTP._MaintOperationExecStageCode,
      --_MaintOrderSubOperationTP._MaintOrderComponentTP,
      --_MaintOrderSubOperationTP._MaintOrderOperObjectListLink,
      _MaintOrderSubOperationTP._MaterialGroup,
      _MaintOrderSubOperationTP._OperationCalculationControl,
      _MaintOrderSubOperationTP._OperationControlKey,
      _MaintOrderSubOperationTP._OperationHasLongText,
      _MaintOrderSubOperationTP._OperationPlanningValues,
      _MaintOrderSubOperationTP._OperationSystemCondition,
      _MaintOrderSubOperationTP._OpExternalProcessingCurrency,
      _MaintOrderSubOperationTP._PersonResponsible,
      _MaintOrderSubOperationTP._PlannedWorkUnitOfMeasure,
      _MaintOrderSubOperationTP._Plant,
      _MaintOrderSubOperationTP._StatusObject,
      _MaintOrderSubOperationTP._Supplier,
      _MaintOrderSubOperationTP._TechnicalObject,
      _MaintOrderSubOperationTP._TechObjIsEquipOrFuncnlLoc,      
      _MaintOrderSubOperationTP._WorkCenter,
      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
      _MaintOrderTP,
      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
      _MaintOrderOperationTP
}

Depth:

C_MaintOrderSubOperationTP view

I_MaintOrderSubOperationTP view