IHPA table — PM Partner Assignment Table
IHPA stores the partner assignments (partner function plus partner number) attached to Plant Maintenance and Customer Service objects such as equipment, functional locations, orders and notifications. Each row links a generic object number to a partner function code and the business partner, customer, vendor or personnel number that fills it. Multiple rows per object are normal since one object can carry several partner functions.
This page covers the IHPA table that holds partner function assignments for PM and CS technical objects, keyed on the generic object number rather than the equipment or functional location number directly. It focuses on how to resolve that object number, which pitfalls trip up consultants querying it, and how the table behaves in S/4HANA.
Published 16 Sept 2026· 983 words
What it stores
One row in IHPA represents a single partner function assigned to a single PM or CS object. The object is not identified by equipment number or functional location code but by the generic object number (OBJNR) that SAP uses to link status management, classification and partner data across many application areas. A functional location might have one row for the 'ordered by' function, another for 'manufacturer', another for a responsible sales employee, each pointing to a different partner number. The same structure is reused for equipment, PM orders, notifications and maintenance plans, so the table is shared infrastructure rather than a PM-specific master data table in the usual sense. It does not store the partner's name or address itself, only the assignment and function.
Key fields
- MANDT - client
- OBJNR - generic object number linking to the object status/management record of the equipment, functional location, order, notification or maintenance plan
- PARVW - partner function code, defined in customizing, e.g. ordered-by, manufacturer, responsible sales employee
- PARNR - the partner number assigned to that function; resolved against customer, vendor or personnel master data depending on the partner function's category
- ADRNR - address number used when an ad-hoc or overriding address is stored instead of the partner master address
How it joins the data model
- IHPA-OBJNR = EQUI-OBJNR for equipment partner assignments
- IHPA-OBJNR = IFLOT-OBJNR for functional location partner assignments
- IHPA-OBJNR = AFIH-OBJNR for PM order header partner assignments
- IHPA-OBJNR = VIQMEL-OBJNR for notification partner assignments
- IHPA-PARNR resolved against KNA1-KUNNR, LFA1-LIFNR or the personnel master depending on PARVW category
How to read it safely
IHPA is client-dependent and can be large across a landscape with many equipment and functional location records, each carrying several partner functions. Never select on it without first restricting OBJNR to a known set, because there is no direct equipment or functional location field to filter on. The normal path is to look up the object number in EQUI, IFLOT, AFIH or VIQMEL first, then query IHPA with that value or a range of values. Restricting by PARVW narrows results to a specific function, which is usually what the investigation actually needs rather than pulling every partner row for an object.
How to prove it in the data
To confirm who is set as 'ordered by' on a piece of equipment, first read EQUI for the equipment number to get OBJNR, then select IHPA where OBJNR equals that value and PARVW equals the ordered-by function code from customizing. The PARNR returned is then looked up in the customer or vendor master depending on the partner function's category to get the actual name. An empty result set confirms no partner was ever assigned for that function, not that the assignment was deleted.
ECC vs S/4HANA
IHPA continues to exist as a transparent table in S/4HANA and is still the table PM and CS transactions write to when maintaining partner assignments on equipment, functional locations, orders and notifications. The underlying customer, vendor and personnel master data feeding PARNR has moved toward the unified Business Partner model in S/4HANA, but that consolidation happens in the master data layer, not in the structure of IHPA itself. No general replacement by a compatibility view is expected for this table in the way seen with some finance and sales tables.
Common pitfalls
- Treating PARNR as always a customer number; depending on the partner function's configured category it may resolve against customer, vendor or personnel master data, and joining blindly to KNA1 silently returns nothing for a vendor or employee partner
- Assuming an object number can be typed directly into IHPA; OBJNR is an internal generated key and must be fetched from the owning object table first
- Missing that a single object can have multiple rows for the same partner function; selecting the first row found and assuming it is the only one misses secondary assignments
- Concluding 'no partner assigned' means the object has no responsible party at all, when responsibility may actually sit at the maintenance plant, planner group or cost center level instead
- Ignoring that partner function codes (PARVW) are customized per client; a code meaning 'manufacturer' in one system may not exist or mean something different in another
- Comparing ADRNR blindly with the partner's current master address; an ad-hoc address stored in IHPA can be stale and no longer matches the partner master after an address change
- Assuming the table is only used by PM; the same structure serves other application areas, so unrestricted selects can return rows that have nothing to do with the equipment or functional location being investigated if OBJNR ranges are not carefully scoped
Whose problem this is
Partner function customizing (which functions exist and what they represent) belongs to the PM configuration team. Day-to-day assignment of actual partners to equipment or functional locations is maintained by the maintenance planner or master data steward responsible for the technical object. Cross-object partner data quality issues that surface in reporting are usually a master data governance question, not a Basis or ABAP one.
Related SAP objects
Reviewed pages this object connects to in the ERPClimb knowledge graph.
Source: ERPClimb — https://erpclimb.com/sap-tables/ihpaERPClimb is an independent platform and is not affiliated with SAP SE. Reference pages are written and reviewed by SAP consultants for learning and troubleshooting.