C_FuncLocationPartnerDEX

DDL: C_FUNCLOCATIONPARTNERDEX Type: view_entity CONSUMPTION Package: ILOM

Functional Location Partner

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

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_FunctionalLocation Location inner
I_PlantMaintenancePartner Partner from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Functional Location Partner view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.sapObjectNodeType.name FunctionalLocationPartner 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
FunctionalLocation
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: 'Functional Location Partner'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #CONSUMPTION
@ObjectModel.sapObjectNodeType.name: 'FunctionalLocationPartner'
@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_FuncLocationPartnerDEX
  as select from I_PlantMaintenancePartner as Partner
    inner join   I_FunctionalLocation      as Location on Location.MaintObjectInternalID = Partner.MaintObjectInternalID

{
      /* start suppress warning shlporigin_not_inherited */
  key Partner.MaintObjectInternalID,
  key Partner.PartnerFunction,
  key Partner.MaintenancePartnerObjectNumber,
      cast( Location.FunctionalLocation  as ps_s4_tplnr preserving type ) as FunctionalLocation,
      Partner.MaintObjectCategory,
      Partner.CreatedByUser,
      Partner.CreationDate,
      Partner.CreationTime,
      Partner.LastChangedByUser,
      Partner.LastChangeTime,
      Partner.LastChangeDate,
      Partner.MaintenancePartner,
      /* end suppress warning shlporigin_not_inherited */

      Partner._PartnerFunction
}

Learn More