PA0006 table — Addresses Infotype 0006 Table
PA0006 is the HR master data table for infotype 0006, Addresses. One row holds one address record for one personnel number for a given subtype (permanent residence, mailing, emergency contact, and so on) and validity period. It is queried whenever a consultant needs to confirm what postal or contact address SAP holds for an employee, or why a letter or payslip went to the wrong place.
This page covers the structure and behaviour of PA0006, the Addresses infotype table in HR master data. It focuses on the fields that actually matter for a lookup, the joins that connect it to the rest of the personnel record, and the specific mistakes consultants make when reading address data directly instead of through the infotype framework.
Published 15 Sept 2026· 1,085 words
What it stores
PA0006 stores one address record per personnel number, address subtype, and validity period. Subtypes distinguish address purposes such as permanent residence, temporary residence, mailing address, or emergency contact, and the exact list of subtypes is country-dependent because address screens differ by country grouping (MOLGA). A single employee can hold several concurrent rows because several address types are usually allowed to coexist without one delimiting another, and because a single subtype can itself repeat, for example several emergency contacts stored under the same subtype with different sequence numbers. The row does not necessarily hold the full postal detail in every system: where central address management is active, PA0006 can carry a pointer to the address stored centrally rather than the street and city fields themselves.
Key fields
- PERNR - personnel number the address belongs to
- SUBTY - address type subtype, for example permanent residence, mailing address, or emergency contact; the meaning of each code is country-grouping specific
- BEGDA / ENDDA - validity period of this particular address record
- SEQNR - sequence number distinguishing multiple records of the same subtype and validity period, used heavily for repeatable subtypes such as emergency contacts
- LAND1 - country key of the address itself, not the employee's country grouping
- STRAS - street and house number, when populated directly on the infotype rather than via central address management
- ORT01 - city
- PSTLZ - postal code
- REGIO - region or state code
- AEDTM / UNAME - date and user of the last change to the record
How it joins the data model
- PA0006-PERNR = PA0000-PERNR (employment status at the point the address applies)
- PA0006-PERNR = PA0001-PERNR (org assignment, cost center, personnel area context)
- PA0006-PERNR = PA0002-PERNR (name and personal data displayed alongside the address)
- PA0006-PERNR = PA0006-PERNR self-join across SUBTY to compare permanent versus mailing address for the same person and period
How to read it safely
Always restrict on MANDT, PERNR, and SUBTY before touching date logic; the table is not selective on its own and a scan across a large workforce without those keys is expensive. To find the address valid on a given day, filter BEGDA less than or equal to that date and ENDDA greater than or equal to it, then take the row with the highest SEQNR if more than one survives the filter, since some subtypes deliberately allow parallel entries. Prefer reading through the infotype framework (the standard read function modules or the logical database used by payroll and reporting) rather than a raw SELECT, because that layer respects authorization checks and time constraint rules that a direct query will silently ignore.
How to prove it in the data
Symptom: a payslip or letter was sent to the wrong home address. Select PA0006 where PERNR equals the employee number and SUBTY equals the permanent residence subtype for that country grouping, with BEGDA less than or equal to the issue date and ENDDA greater than or equal to it. Order by SEQNR descending. Check STRAS, ORT01, PSTLZ directly; if all three are blank, the address is not stored on the infotype and must be traced through the central address pointer instead.
ECC vs S/4HANA
PA0006 continues to exist in S/4HANA on-premise HCM as the same infotype table; there is no compatibility view replacement specific to this object. In a SuccessFactors Employee Central landscape, address data is captured and owned in Employee Central personal information entities rather than on PA0006 directly. When Employee Central Payroll or an on-premise payroll system is in scope, address data is replicated from Employee Central into PA0006 through point-to-point replication or an integration center mapping, with Employee Central address types mapped onto local infotype subtypes.
Common pitfalls
- Reading STRAS, ORT01, PSTLZ as blank and concluding the address is missing: many systems store the real address centrally and PA0006 only carries a reference to it, so the infotype screen in PA20 or PA30 will show a full address even though the raw table fields look empty.
- Hardcoding the meaning of a SUBTY value: subtype codes for address type are defined per country grouping, so subtype '1' in one country grouping is not guaranteed to mean the same thing in another.
- Ignoring SEQNR on repeatable subtypes: a query filtered only by PERNR, SUBTY, and date range can silently return several rows for subtypes that allow multiple concurrent entries, such as emergency contacts, and picking the wrong row produces a confident but wrong answer.
- Assuming one active address per person: several address subtypes are permitted to be valid at the same time, so 'the' current address is meaningless without also specifying which subtype is meant.
- Treating LAND1 on the address row as the employee's employment country: it is the country of that specific address and can differ from the country grouping that governs the employee's infotype screens and payroll country.
- Using MAX(BEGDA) to find the current record without also checking ENDDA: a record can be historically delimited and still have a BEGDA in the past relative to another, more recent but shorter-lived, record.
Whose problem this is
In an Employee Central landscape, the address is owned and corrected in the source system by HR operations or the employee via self-service, not by editing PA0006 directly. Any discrepancy between what an employee sees in Employee Central and what payroll or on-premise HR shows on PA0006 is an integration and replication mapping question, owned jointly by the Employee Central configuration team and the payroll or HCM technical team who maintain the replication.
Related SAP objects
Reviewed pages this object connects to in the ERPClimb knowledge graph.
Source: ERPClimb — https://erpclimb.com/sap-tables/pa0006ERPClimb is an independent platform and is not affiliated with SAP SE. Reference pages are written and reviewed by SAP consultants for learning and troubleshooting.