I_PLANTMAINTENANCEPARTNER
Plant Maintenance Partner
I_PLANTMAINTENANCEPARTNER is a CDS View in S/4HANA. Plant Maintenance Partner. It contains 17 fields. 12 CDS views read from this table.
CDS Views using this table (12)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_EquipmentPartner | view_entity | left_outer | COMPOSITE | Equipment Partner Functions |
| C_EquipmentPartnerDEX | view_entity | inner | CONSUMPTION | Equipment Partner DEX |
| C_FuncLocationPartnerDEX | view_entity | from | CONSUMPTION | Functional Location Partner |
| C_MaintOrderPartnerDEX | view_entity | from | CONSUMPTION | Maintenance Order Partner |
| C_SerialNumberHistoryPartner | view_entity | from | CONSUMPTION | Partner Detail for Serial Number History |
| I_MaintenanceOrderPartner | view | inner | COMPOSITE | Maintenance Order Partners |
| P_MaintNotificationPartner | view | left_outer | COMPOSITE | Responsible Partner for Maintenance Notification Header |
| P_MaintOrdResponsiblePartner | view | inner | COMPOSITE | Responsible Partner for Maintenance Order Header |
| P_MaintOrdResponsiblePartner | view | left_outer | COMPOSITE | Responsible Partner for Maintenance Order Header |
| P_MinPartnerNumberByObjAndFunc | view_entity | from | COMPOSITE | Minimum partner number by object id and function code |
| P_MinPartnerNumberByObjAndFunc | view_entity | left_outer | COMPOSITE | Minimum partner number by object id and function code |
| R_FunctionalLocationPartnerTP | view_entity | left_outer | TRANSACTIONAL | Functional Location Partner |
Fields (17)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | MaintenancePartnerObjectNumber | EquipmentPartnerObjectNmbr,FuncnlLocPartnerObjectNmbr,MaintenancePartnerObjectNumber,NotificationPartnerObjectNmbr | 7 |
| KEY | MaintObjectInternalID | MaintObjectInternalID | 7 |
| KEY | Partner | EquipmentPartner,MaintenanceOrderPartner,Partner | 6 |
| KEY | PartnerFunction | PartnerFunction | 5 |
| _ContactPerson | _ContactPerson | 2 | |
| _Customer | _Customer | 2 | |
| _Employee | _Employee | 2 | |
| _PartnerFunction | _PartnerFunction | 4 | |
| _Supplier | _Supplier | 2 | |
| CreatedByUser | CreatedByUser | 7 | |
| CreationDate | CreationDate | 7 | |
| CreationTime | CreationTime | 7 | |
| LastChangeDate | LastChangeDate | 7 | |
| LastChangedByUser | LastChangedByUser | 7 | |
| LastChangeTime | LastChangeTime | 7 | |
| MaintenancePartner | MaintenancePartner | 4 | |
| MaintObjectCategory | MaintObjectCategory | 3 |
@AbapCatalog: { sqlViewName: 'IPLANTMAINTPARTN', preserveKey }
--@Analytics: { dataCategory: #DIMENSION }
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Plant Maintenance Partner'
@ObjectModel.representativeKey: 'MaintObjectInternalID'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #BASIC
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
@Search.searchable: true
define view I_PlantMaintenancePartner
as select from ihpa
association [0..1] to I_PartnerFunction as _PartnerFunction on _PartnerFunction.PartnerFunction = $projection.PartnerFunction
/* Associations - DPP */
association [0..1] to I_ContactPerson as _ContactPerson on _ContactPerson.ContactPerson = $projection.Partner
association [0..1] to I_Customer as _Customer on _Customer.Customer = $projection.Partner
association [0..1] to I_WorkforcePerson as _Employee on _Employee.PersonExternalID = $projection.Partner
association [0..1] to I_OrganizationalUnitText as _OrganizationalUnitText on _OrganizationalUnitText.OrganizationalUnit = $projection.Partner
and _OrganizationalUnitText.Language = $session.system_language
and _OrganizationalUnitText.StartDate <= $session.system_date
and _OrganizationalUnitText.EndDate >= $session.system_date
association [0..1] to I_PMPositionText as _PositionText on _PositionText.PositionID = $projection.Partner
and _PositionText.Language = $session.system_language
and _PositionText.StartDate <= $session.system_date
and _PositionText.EndDate >= $session.system_date
association [0..1] to I_Supplier as _Supplier on _Supplier.Supplier = $projection.Partner
association [0..1] to I_User as _User on _User.UserID = $projection.Partner
association [0..1] to I_PMContactCardEmployee as _PersonResponsible on $projection.Partner = _PersonResponsible.PersonnelNumber
association [0..1] to I_PersonWorkAgreement_1 as _PersonWorkAgreement on $projection.Partner = _PersonWorkAgreement.PersonWorkAgreement
{
/* Fields */
key objnr as MaintObjectInternalID,
@Search.defaultSearchElement: true
@ObjectModel.foreignKey.association: '_PartnerFunction'
key cast(parvw as parvw_unv) as PartnerFunction,
key counter as MaintenancePartnerObjectNumber,
obtyp as MaintObjectCategory,
@API.element.successor: 'MaintenancePartner'
@API.element.releaseState: #DEPRECATED
@UI.hidden: true
parnr as Partner,
ernam as CreatedByUser,
erdat as CreationDate,
erzeit as CreationTime,
aenam as LastChangedByUser,
aezeit as LastChangeTime,
aedat as LastChangeDate,
parnr as MaintenancePartner,
// adrnr as Address,
/* Associations */
_PartnerFunction,
maintpartnerismainpartner as TechObjectPartnerIsMainPartner,
/* Associations - DPP */
_ContactPerson,
_Customer,
_Employee,
_OrganizationalUnitText,
_PositionText,
_Supplier,
_User,
_PersonResponsible,
_PersonWorkAgreement
}
where
ihpa.kzloesch = ' '