I_MaintOrderComponentTP

DDL: I_MAINTORDERCOMPONENTTP SQL: IMAINTOPCOMPTP Type: view TRANSACTIONAL Package: ODATA_EAM_ORD_MAN
33 Fields 1 Data Sources 2 Associations

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.

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 Order
KEY MaintenanceOrderOperation I_MaintOrderOperComp MaintenanceOrderOperation Suboperation
KEY MaintenanceOrderSubOperation I_MaintOrderOperComp MaintenanceOrderSubOperation Suboperation
KEY MaintOrderComponentInternalID I_MaintOrderOperComp MaintOrderComponentInternalID Object number
MaintenanceOrderComponent I_MaintOrderOperComp MaintenanceOrderComponent BOM item
MaintOrderComponentForEdit I_MaintOrderOperComp MaintenanceOrderComponent BOM item
Reservation I_MaintOrderOperComp Reservation Reservation
ReservationItem I_MaintOrderOperComp ReservationItem Reservation Item
ReservationType I_MaintOrderOperComp ReservationType Record type
Material I_MaintOrderOperComp Material Vehicle Model
MaterialGroup I_MaintOrderOperComp MaterialGroup Product Group
ComponentDescription I_MaintOrderOperComp ComponentDescription Item Text
RequirementQuantityInBaseUnit I_MaintOrderOperComp RequirementQuantityInBaseUnit
BaseUnit I_MaintOrderOperComp BaseUnit Unit of Measure
Plant I_MaintOrderOperComp Plant Valuation Area
StorageLocation I_MaintOrderOperComp StorageLocation StorageLocation
MaintOrderRoutingNumber I_MaintOrderOperComp MaintOrderRoutingNumber Plan No.f.Oper.
MaintOrderOperationCounter I_MaintOrderOperComp MaintOrderOperationCounter Counter
ItemCategory I_MaintOrderOperComp ItemCategory Item Category
IsDeleted I_MaintOrderOperComp IsDeleted TRUE
QuantityWithdrawnInBaseUnit I_MaintOrderOperComp QuantityWithdrawnInBaseUnit Withdrawal Qty
Supplier I_MaintOrderOperComp Supplier 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

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_MaintOrderComponentTP.
-- 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: IMAINTOPCOMPTP

CREATE VIEW I_MaintOrderComponentTP AS
SELECT
  I_MaintOrderOperComp.MaintenanceOrder AS MaintenanceOrder,
  I_MaintOrderOperComp.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  I_MaintOrderOperComp.MaintenanceOrderSubOperation AS MaintenanceOrderSubOperation,
  I_MaintOrderOperComp.MaintOrderComponentInternalID AS MaintOrderComponentInternalID,
  I_MaintOrderOperComp.MaintenanceOrderComponent AS MaintenanceOrderComponent,
  I_MaintOrderOperComp.MaintenanceOrderComponent AS MaintOrderComponentForEdit,
  I_MaintOrderOperComp.Reservation AS Reservation,
  I_MaintOrderOperComp.ReservationItem AS ReservationItem,
  I_MaintOrderOperComp.ReservationType AS ReservationType,
  I_MaintOrderOperComp.Material AS Material,
  I_MaintOrderOperComp.MaterialGroup AS MaterialGroup,
  I_MaintOrderOperComp.ComponentDescription AS ComponentDescription,
  I_MaintOrderOperComp.RequirementQuantityInBaseUnit AS RequirementQuantityInBaseUnit,
  I_MaintOrderOperComp.BaseUnit AS BaseUnit,
  I_MaintOrderOperComp.Plant AS Plant,
  I_MaintOrderOperComp.StorageLocation AS StorageLocation,
  I_MaintOrderOperComp.MaintOrderRoutingNumber AS MaintOrderRoutingNumber,
  I_MaintOrderOperComp.MaintOrderOperationCounter AS MaintOrderOperationCounter,
  I_MaintOrderOperComp.ItemCategory AS ItemCategory,
  I_MaintOrderOperComp.IsDeleted AS IsDeleted,
  I_MaintOrderOperComp.QuantityWithdrawnInBaseUnit AS QuantityWithdrawnInBaseUnit,
  I_MaintOrderOperComp.Supplier AS Supplier,
  I_MaintOrderOperComp._ItemCategoryText AS _ItemCategoryText,
  I_MaintOrderOperComp._Material AS _Material,
  I_MaintOrderOperComp._MaterialText AS _MaterialText,
  I_MaintOrderOperComp._Plant AS _Plant,
  I_MaintOrderOperComp._SafetyRelevance AS _SafetyRelevance,
  I_MaintOrderOperComp._StatusObject AS _StatusObject,
  I_MaintOrderOperComp._StorageLocation AS _StorageLocation,
  I_MaintOrderOperComp._UnitOfMeasure AS _UnitOfMeasure
FROM I_MaintOrderOperComp
LEFT OUTER JOIN I_MaintOrderOperationTP AS _MaintOrderOperationTP ON MaintenanceOrder = _MaintOrderOperationTP.MaintenanceOrder AND MaintenanceOrderOperation = _MaintOrderOperationTP.MaintenanceOrderOperation  -- association [1..1]
LEFT OUTER JOIN I_MaintOrderTP AS _MaintOrderTP ON MaintenanceOrder = _MaintOrderTP.MaintenanceOrder  -- association [1..1]
;

Learn More