I_MaintOrderComponentTP

DDL: I_MAINTORDERCOMPONENTTP SQL: IMAINTOPCOMPTP Type: view TRANSACTIONAL Package: ODATA_EAM_ORD_MAN

Maintenance Order Operation Component

I_MaintOrderComponentTP is a Transactional CDS View that provides data about "Maintenance Order Operation Component" in SAP S/4HANA. It reads from 1 data source (I_MaintOrderOperComp) and exposes 33 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation, MaintOrderComponentInternalID. It has 2 associations to related views. Part of development package ODATA_EAM_ORD_MAN.

1 data source(s) 33 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintOrderOperComp I_MaintOrderOperComp from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_MaintOrderOperationTP _MaintOrderOperationTP $projection.MaintenanceOrder = _MaintOrderOperationTP.MaintenanceOrder and $projection.MaintenanceOrderOperation = _MaintOrderOperationTP.MaintenanceOrderOperation
[1..1] I_MaintOrderTP _MaintOrderTP $projection.MaintenanceOrder = _MaintOrderTP.MaintenanceOrder

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IMAINTOPCOMPTP view
EndUserText.label Maintenance Order Operation Component view
ObjectModel.writeDraftPersistence MAINTORDCOMP_D view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.draftEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder I_MaintOrderOperComp MaintenanceOrder
KEY MaintenanceOrderOperation I_MaintOrderOperComp MaintenanceOrderOperation
KEY MaintenanceOrderSubOperation I_MaintOrderOperComp MaintenanceOrderSubOperation
KEY MaintOrderComponentInternalID I_MaintOrderOperComp MaintOrderComponentInternalID
MaintenanceOrderComponent I_MaintOrderOperComp MaintenanceOrderComponent
MaintOrderComponentForEdit I_MaintOrderOperComp MaintenanceOrderComponent
Reservation I_MaintOrderOperComp Reservation
ReservationItem I_MaintOrderOperComp ReservationItem
ReservationType I_MaintOrderOperComp ReservationType
Material I_MaintOrderOperComp Material
MaterialGroup I_MaintOrderOperComp MaterialGroup
ComponentDescription I_MaintOrderOperComp ComponentDescription
RequirementQuantityInBaseUnit I_MaintOrderOperComp RequirementQuantityInBaseUnit
BaseUnit I_MaintOrderOperComp BaseUnit
Plant I_MaintOrderOperComp Plant
StorageLocation I_MaintOrderOperComp StorageLocation
MaintOrderRoutingNumber I_MaintOrderOperComp MaintOrderRoutingNumber
MaintOrderOperationCounter I_MaintOrderOperComp MaintOrderOperationCounter
ItemCategory I_MaintOrderOperComp ItemCategory
IsDeleted I_MaintOrderOperComp IsDeleted
QuantityWithdrawnInBaseUnit I_MaintOrderOperComp QuantityWithdrawnInBaseUnit
Supplier I_MaintOrderOperComp Supplier
_ItemCategoryText I_MaintOrderOperComp _ItemCategoryText
_Material I_MaintOrderOperComp _Material
_MaterialText I_MaintOrderOperComp _MaterialText
_Plant I_MaintOrderOperComp _Plant
_SafetyRelevance I_MaintOrderOperComp _SafetyRelevance
_StatusObject I_MaintOrderOperComp _StatusObject
_StorageLocation I_MaintOrderOperComp _StorageLocation
_UnitOfMeasure I_MaintOrderOperComp _UnitOfMeasure
_MaintOrderTP _MaintOrderTP
_MaintOrderOperationTP _MaintOrderOperationTP
_Supplier 
@AbapCatalog.sqlViewName: 'IMAINTOPCOMPTP'
@EndUserText.label: 'Maintenance Order Operation Component'
@ObjectModel.writeDraftPersistence: 'MAINTORDCOMP_D'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.draftEnabled: true
@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: true

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

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@ObjectModel.semanticKey: ['MaintenanceOrder', 'MaintenanceOrderOperation', 
'MaintenanceOrderSubOperation','MaintOrderComponentInternalID']

define view I_MaintOrderComponentTP
  as select from I_MaintOrderOperComp

  association [1..1] to I_MaintOrderOperationTP as _MaintOrderOperationTP on  $projection.MaintenanceOrder          = _MaintOrderOperationTP.MaintenanceOrder
                                                                          and $projection.MaintenanceOrderOperation = _MaintOrderOperationTP.MaintenanceOrderOperation
  association [1..1] to I_MaintOrderTP          as _MaintOrderTP          on  $projection.MaintenanceOrder = _MaintOrderTP.MaintenanceOrder
{
  key I_MaintOrderOperComp.MaintenanceOrder,
  key I_MaintOrderOperComp.MaintenanceOrderOperation,
  key I_MaintOrderOperComp.MaintenanceOrderSubOperation,
  key I_MaintOrderOperComp.MaintOrderComponentInternalID,
      I_MaintOrderOperComp.MaintenanceOrderComponent, 

      I_MaintOrderOperComp.MaintenanceOrderComponent as MaintOrderComponentForEdit,

      I_MaintOrderOperComp.Reservation,
      I_MaintOrderOperComp.ReservationItem,
      I_MaintOrderOperComp.ReservationType,
      I_MaintOrderOperComp.Material,
      I_MaintOrderOperComp.MaterialGroup,
      I_MaintOrderOperComp.ComponentDescription,
      I_MaintOrderOperComp.RequirementQuantityInBaseUnit,
      I_MaintOrderOperComp.BaseUnit,
      I_MaintOrderOperComp.Plant,
      I_MaintOrderOperComp.StorageLocation,
      I_MaintOrderOperComp.MaintOrderRoutingNumber,
      I_MaintOrderOperComp.MaintOrderOperationCounter,
      I_MaintOrderOperComp.ItemCategory,
      I_MaintOrderOperComp.IsDeleted, 
      I_MaintOrderOperComp.QuantityWithdrawnInBaseUnit,
      I_MaintOrderOperComp.Supplier,
      I_MaintOrderOperComp._ItemCategoryText,
      I_MaintOrderOperComp._Material,
      I_MaintOrderOperComp._MaterialText,
      I_MaintOrderOperComp._Plant,
      I_MaintOrderOperComp._SafetyRelevance,
      I_MaintOrderOperComp._StatusObject,
      I_MaintOrderOperComp._StorageLocation,
      I_MaintOrderOperComp._UnitOfMeasure,

      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
      _MaintOrderTP,
      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
      _MaintOrderOperationTP,
      -- For DCL:
      I_MaintOrderOperComp._Supplier
} where I_MaintOrderOperComp.IsDeleted = ''

Learn More