C_EquipmentPartnerDEX

DDL: C_EQUIPMENTPARTNERDEX Type: view_entity CONSUMPTION Package: IEQM

Equipment Partner DEX

C_EquipmentPartnerDEX is a Consumption CDS View (Fact) that provides data about "Equipment Partner DEX" in SAP S/4HANA. It reads from 2 data sources (I_Equipment, I_PlantMaintenancePartner) and exposes 13 fields with key fields MaintObjectInternalID, PartnerFunction, MaintenancePartnerObjectNumber. Part of development package IEQM.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_Equipment Equipment from
I_PlantMaintenancePartner Partner inner

Annotations (14)

NameValueLevelField
EndUserText.label Equipment Partner DEX view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.modelingPattern #ANALYTICAL_FACT view
ObjectModel.sapObjectNodeType.name EquipmentPartner view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Analytics.internalName #LOCAL view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MaintObjectInternalID I_PlantMaintenancePartner MaintObjectInternalID
KEY PartnerFunction I_PlantMaintenancePartner PartnerFunction
KEY MaintenancePartnerObjectNumber I_PlantMaintenancePartner MaintenancePartnerObjectNumber
Equipment I_Equipment Equipment
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 
@EndUserText.label: 'Equipment Partner DEX'
@AccessControl: {
    authorizationCheck:      #MANDATORY,
    personalData.blocking:   #REQUIRED
    }
@ObjectModel: {
    supportedCapabilities: [ #EXTRACTION_DATA_SOURCE ],
//    modelingPattern: #ANALYTICAL_DIMENSION,

    modelingPattern: #ANALYTICAL_FACT,
//    representativeKey: 'MaintenancePartnerObjectNumber',

    sapObjectNodeType.name: 'EquipmentPartner',
    usageType: {
       dataClass: #MASTER,
       serviceQuality: #C,
       sizeCategory: #XL
       }
    }
@Analytics: {
   internalName:#LOCAL,
//   dataCategory: #DIMENSION,

   dataCategory: #FACT,      
   dataExtraction: {
     enabled: true,
     delta.changeDataCapture: {
       mapping: [{ role: #MAIN, table: 'ihpa',
                   viewElement: [ 'MaintObjectInternalID', 'PartnerFunction', 'MaintenancePartnerObjectNumber' ],
                   tableElement: [ 'objnr', 'parvw', 'counter' ]
                }]
     }
   }
}
@VDM.viewType: #CONSUMPTION
@Metadata: {
    ignorePropagatedAnnotations: true,
    allowExtensions: true }
define view entity C_EquipmentPartnerDEX
  as select from I_Equipment               as Equipment 
  //    left outer to many join I_PlantMaintenancePartner as Partner   on Partner.MaintObjectInternalID = Equipment.MaintObjectInternalID

    inner join   I_PlantMaintenancePartner as Partner   on Partner.MaintObjectInternalID = Equipment.MaintObjectInternalID
{
      /* start suppress warning shlporigin_not_inherited */
  key Partner.MaintObjectInternalID,
  key Partner.PartnerFunction,
  key Partner.MaintenancePartnerObjectNumber,
      Equipment.Equipment,
      Partner.MaintObjectCategory,
      Partner.CreatedByUser,
      Partner.CreationDate,
      Partner.CreationTime,
      Partner.LastChangedByUser,
      Partner.LastChangeTime,
      Partner.LastChangeDate,
      Partner.MaintenancePartner,
      /* end suppress warning shlporigin_not_inherited */

      /* Associations */
      Partner._PartnerFunction
}

Learn More