C_MaintOrderPartnerDEX

DDL: C_MAINTORDERPARTNERDEX Type: view_entity CONSUMPTION Package: IWO1

Maintenance Order Partner

C_MaintOrderPartnerDEX is a Consumption CDS View that provides data about "Maintenance Order Partner" in SAP S/4HANA. It reads from 2 data sources (I_MaintenanceOrder, I_PlantMaintenancePartner) and exposes 13 fields with key fields MaintObjectInternalID, PartnerFunction, MaintenancePartnerObjectNumber. Part of development package IWO1.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_MaintenanceOrder MaintenanceOrder inner
I_PlantMaintenancePartner Partner from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Maintenance Order Partner view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.sapObjectNodeType.name MaintenanceOrderPartner view
Analytics.dataExtraction.enabled true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.modelingPattern #ANALYTICAL_FACT view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MaintObjectInternalID I_PlantMaintenancePartner MaintObjectInternalID
KEY PartnerFunction I_PlantMaintenancePartner PartnerFunction
KEY MaintenancePartnerObjectNumber I_PlantMaintenancePartner MaintenancePartnerObjectNumber
MaintenanceOrder I_MaintenanceOrder MaintenanceOrder
MaintObjectCategory I_PlantMaintenancePartner MaintObjectCategory
CreatedByUser I_PlantMaintenancePartner CreatedByUser
CreationDate I_PlantMaintenancePartner CreationDate
CreationTime I_PlantMaintenancePartner CreationTime
LastChangedByUser I_PlantMaintenancePartner LastChangedByUser
LastChangeTime I_PlantMaintenancePartner LastChangeTime
LastChangeDate I_PlantMaintenancePartner LastChangeDate
MaintenancePartner I_PlantMaintenancePartner MaintenancePartner
_PartnerFunction I_PlantMaintenancePartner _PartnerFunction 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl: { 
 authorizationCheck: #MANDATORY,
 personalData.blocking: #REQUIRED
}
@EndUserText.label: 'Maintenance Order Partner'
@Metadata.ignorePropagatedAnnotations: true

@VDM.viewType: #CONSUMPTION

@ObjectModel.sapObjectNodeType.name: 'MaintenanceOrderPartner'

@Analytics.dataExtraction: {
  enabled: true,
    delta.changeDataCapture: {
      mapping: [{
        role: #MAIN,
        table: 'ihpa',
        viewElement: [ 'MaintObjectInternalID', 'PartnerFunction', 'MaintenancePartnerObjectNumber' ],
        tableElement: [ 'objnr', 'parvw', 'counter' ]
      }]
    }

}

@ObjectModel: {
  usageType: {
    dataClass: #MIXED,
    sizeCategory: #XL,
    serviceQuality: #C
  },
  supportedCapabilities: [ #EXTRACTION_DATA_SOURCE ],
  modelingPattern: #ANALYTICAL_FACT
}

define view entity C_MaintOrderPartnerDEX
  as select from I_PlantMaintenancePartner as Partner
    inner join   I_MaintenanceOrder        as MaintenanceOrder on MaintenanceOrder.MaintenanceOrderInternalID = Partner.MaintObjectInternalID
{
      /* start suppress warning shlporigin_not_inherited */
  key Partner.MaintObjectInternalID,
  key Partner.PartnerFunction,
  key Partner.MaintenancePartnerObjectNumber,
      MaintenanceOrder.MaintenanceOrder,
      Partner.MaintObjectCategory,
      @Semantics.user.createdBy: true
      Partner.CreatedByUser,
      @Semantics.systemDate.createdAt: true
      Partner.CreationDate,
      @Semantics.systemTime.createdAt: true
      Partner.CreationTime,
      @Semantics.user.lastChangedBy: true
      Partner.LastChangedByUser,
      @Semantics.systemTime.lastChangedAt: true
      Partner.LastChangeTime,
      @Semantics.systemDate.lastChangedAt: true
      Partner.LastChangeDate,
      Partner.MaintenancePartner,
      /* end suppress warning shlporigin_not_inherited */
      
      Partner._PartnerFunction
      /*Association*/
}

Learn More