I_MaintenanceOrderPartner

DDL: I_MAINTENANCEORDERPARTNER SQL: IMAINTORDPARTN Type: view COMPOSITE Package: IWO1

Maintenance Order Partners

I_MaintenanceOrderPartner is a Composite CDS View that provides data about "Maintenance Order Partners" in SAP S/4HANA. It reads from 2 data sources (I_MaintenanceOrder, I_PlantMaintenancePartner) and exposes 8 fields with key fields MaintenanceOrder, PartnerFunction, MaintenanceOrderPartner. It has 1 association to related views. Part of development package IWO1.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_MaintenanceOrder MaintenanceOrder from
I_PlantMaintenancePartner PlantMaintenancePartner inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MaintenanceOrder _MaintenanceOrder $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMAINTORDPARTN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Order Partners view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder I_MaintenanceOrder MaintenanceOrder
KEY PartnerFunction
KEY MaintenanceOrderPartner I_PlantMaintenancePartner Partner
_ContactPerson I_PlantMaintenancePartner _ContactPerson
_Customer I_PlantMaintenancePartner _Customer
_Employee I_PlantMaintenancePartner _Employee
_Supplier I_PlantMaintenancePartner _Supplier
_MaintenanceOrder _MaintenanceOrder 
@AbapCatalog.sqlViewName: 'IMAINTORDPARTN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Order Partners'

@Metadata.ignorePropagatedAnnotations: true

@VDM.viewType: #COMPOSITE

@ObjectModel.semanticKey:  [ 'MaintenanceOrder', 'PartnerFunction', 'MaintenanceOrderPartner' ]

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
define view I_MaintenanceOrderPartner
  as select from I_MaintenanceOrder        as MaintenanceOrder

    inner join   I_PlantMaintenancePartner as PlantMaintenancePartner on MaintenanceOrder.MaintenanceOrderInternalID = PlantMaintenancePartner.MaintObjectInternalID

  association [1..1] to I_MaintenanceOrder as _MaintenanceOrder on $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder
{

  key MaintenanceOrder.MaintenanceOrder,
  key cast(PlantMaintenancePartner.PartnerFunction as parvw_unv preserving type ) as PartnerFunction,
  key PlantMaintenancePartner.Partner                                             as MaintenanceOrderPartner,
  
      //assoc

      PlantMaintenancePartner._ContactPerson,
      PlantMaintenancePartner._Customer,
      PlantMaintenancePartner._Employee,
      PlantMaintenancePartner._Supplier,
      _MaintenanceOrder

}

Learn More