I_PLANTMAINTENANCEPARTNER

CDS View
17 Fields 19 CDS Views

Plant Maintenance Partner

I_PLANTMAINTENANCEPARTNER is a CDS View in S/4HANA. Plant Maintenance Partner. It contains 17 fields. 19 CDS views read from this table.

CDS Views using this table (19)

ViewTypeJoinVDMDescription
A_EquipmentPartner view_entity left_outer COMPOSITE Equipment Partner Functions
C_EquipmentPartnerDEX view_entity from CONSUMPTION Equipment Partner for Data Product
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_IsolationCertificatePartner view_entity from BASIC Isolation Certificate Partner
I_MaintenanceOrderPartner view inner COMPOSITE Maintenance Order Partners
I_SerialNumberHistoryPartner view_entity from COMPOSITE Partner Detail for Serial Number History
P_MaintNotificationPartner view left_outer COMPOSITE
P_MaintOrdResponsiblePartner view inner COMPOSITE
P_MaintOrdResponsiblePartner view left_outer COMPOSITE
P_MinPartnerNumberByObjAndFunc view from COMPOSITE
P_MinPartnerNumberByObjAndFunc view left_outer COMPOSITE
R_FunctionalLocationPartnerTP view_entity left_outer TRANSACTIONAL Functional Location Partner
R_IsltnCertificatePartnerTP view_entity inner TRANSACTIONAL Isolation Certificate Partner - TP
R_IsltnCertTemplatePrtnFuncTP view_entity inner TRANSACTIONAL Isolation Certificate Tmpl Ptrn Fun - TP
R_ReferenceEquipmentPartnerTP view_entity inner TRANSACTIONAL Reference Equipment Partner - TP
R_SafetyCertificatePartnerTP view_entity inner TRANSACTIONAL Safety Certificate Partner
R_WorkPermitPartnerTP view_entity inner TRANSACTIONAL Work Permit Partner

Fields (17)

KeyField CDS FieldsUsed in Views
KEY MaintenancePartnerObjectNumber EquipmentPartnerObjectNmbr,FuncnlLocPartnerObjectNmbr,MaintenancePartnerObjectNumber,NotificationPartnerObjectNmbr 13
KEY MaintObjectInternalID MaintObjectInternalID 8
KEY Partner EquipmentPartner,MaintenanceOrderPartner,Partner 6
KEY PartnerFunction PartnerFunction 6
_ContactPerson _ContactPerson 2
_Customer _Customer 2
_Employee _Employee 2
_PartnerFunction _PartnerFunction 4
_Supplier _Supplier 2
CreatedByUser CreatedByUser 13
CreationDate CreationDate 13
CreationTime CreationTime 13
LastChangeDate LastChangeDate 13
LastChangedByUser LastChangedByUser 13
LastChangeTime LastChangeTime 13
MaintenancePartner ContactPersonResponsible,CustomerResponsible,DepartmentResponsible,MaintenancePartner,PersonResponsible,PositionResponsible,ReferenceEquipmentPartner,SupplierResponsible,UserResponsible 10
MaintObjectCategory MaintObjectCategory 9

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Plant Maintenance Partner
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PLANTMAINTENANCEPARTNER (
    MAINTENANCEPARTNEROBJECTNUMBER,
    MAINTOBJECTINTERNALID,
    PARTNER,
    PARTNERFUNCTION,
    _CONTACTPERSON,
    _CUSTOMER,
    _EMPLOYEE,
    _PARTNERFUNCTION,
    _SUPPLIER,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    MAINTENANCEPARTNER,
    MAINTOBJECTCATEGORY,
    PRIMARY KEY (MAINTENANCEPARTNEROBJECTNUMBER, MAINTOBJECTINTERNALID, PARTNER, PARTNERFUNCTION)
);

Learn More