C_EquipmentPartnerDEX

DDL: C_EQUIPMENTPARTNERDEX Type: view_entity CONSUMPTION
13 Fields 2 Data Sources

Equipment Partner for Data Product

C_EquipmentPartnerDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

EquipmentPartner · Asset Management

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

SAP API Hub

StateC1
Line of BusinessAsset Management
Application ComponentPM-EQM-EQ
CapabilitiesData Source for Data Extraction
PackageAsset Management for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (2)

SourceAliasJoin Type
I_Equipment Equipment inner
I_PlantMaintenancePartner Partner from

Annotations (13)

NameValueLevelField
EndUserText.label Equipment Partner for Data Product view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Analytics.internalName #LOCAL view
Analytics.dataCategory #FACT 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
ObjectModel.sapObjectNodeType.name EquipmentPartner view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MaintObjectInternalID I_PlantMaintenancePartner MaintObjectInternalID Object number
KEY PartnerFunction I_PlantMaintenancePartner PartnerFunction Partner Function
KEY MaintenancePartnerObjectNumber I_PlantMaintenancePartner MaintenancePartnerObjectNumber Counter for differentiation 6-digit
Equipment I_Equipment Equipment Equipment Number
MaintObjectCategory I_PlantMaintenancePartner MaintObjectCategory Object Type
CreatedByUser I_PlantMaintenancePartner CreatedByUser Name of Person Responsible for Creating the Object
CreationDate I_PlantMaintenancePartner CreationDate Record Created On
CreationTime I_PlantMaintenancePartner CreationTime Time at Which Record Was Added
LastChangedByUser I_PlantMaintenancePartner LastChangedByUser Name of Person Who Changed Object
LastChangeTime I_PlantMaintenancePartner LastChangeTime Time of Change
LastChangeDate I_PlantMaintenancePartner LastChangeDate Last Changed On
MaintenancePartner I_PlantMaintenancePartner MaintenancePartner Partner
_PartnerFunction I_PlantMaintenancePartner _PartnerFunction

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 C_EquipmentPartnerDEX.
-- 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.

CREATE VIEW C_EquipmentPartnerDEX AS
SELECT
  Partner.MaintObjectInternalID AS MaintObjectInternalID,
  Partner.PartnerFunction AS PartnerFunction,
  Partner.MaintenancePartnerObjectNumber AS MaintenancePartnerObjectNumber,
  Equipment.Equipment AS Equipment,
  Partner.MaintObjectCategory AS MaintObjectCategory,
  Partner.CreatedByUser AS CreatedByUser,
  Partner.CreationDate AS CreationDate,
  Partner.CreationTime AS CreationTime,
  Partner.LastChangedByUser AS LastChangedByUser,
  Partner.LastChangeTime AS LastChangeTime,
  Partner.LastChangeDate AS LastChangeDate,
  Partner.MaintenancePartner AS MaintenancePartner,
  Partner._PartnerFunction AS _PartnerFunction
FROM I_PlantMaintenancePartner AS Partner
INNER JOIN I_Equipment AS Equipment ON /* join condition not captured in parsed metadata */
;

Learn More