SAP table T5UAP (Address for personnel area/subarea)
SAP table T5UAP has 4 primary key fields being MANDT,WERKS,BTRTL,ENDDA.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| WERKS | Personnel Area | CHAR | 4 | 0 | T001P | PERSA | |
| BTRTL | Personnel Subarea | CHAR | 4 | 0 | T001P | BTRTL_001P | |
| ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||
| BEGDA | Start Date | DATS | 8 | 0 | BEGDA | ||
| STRAS | Street and House Number | CHAR | 60 | 0 | PAD_STRAS | ||
| LOCAT | 2nd Address Line | CHAR | 30 | 0 | LOCAT | ||
| ORT01 | City | CHAR | 40 | 0 | PAD_ORT01 | ||
| CONTY | Text length 25 | CHAR | 25 | 0 | TEXT25 | ||
| STATE | Region (State, Province, County) | CHAR | 3 | 0 | T005S | REGIO | |
| ZIPCD | Postal Code | CHAR | 10 | 0 | PSTLZ_HR | ||
| TELNR | Telephone Number | CHAR | 14 | 0 | TELNR | ||
| CONTP | Employee's Name (Sortable by LAST NAME FIRST NAME) | CHAR | 30 | 0 | SMNAM | ||
| TAXAR | Work Tax Area | CHAR | 4 | 0 | T5UTB | WRKAR |
T5UAP foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T5UAP | BTRTL | T001P | Personnel Area/Subarea | MANDT |
| 0 T5UAP | BTRTL | T001P | Personnel Area/Subarea | WERKS |
| 0 T5UAP | BTRTL | T001P | Personnel Area/Subarea | BTRTL |
| 1 T5UAP | STATE | T005S | Taxes: Region (Province) Key | LAND1 |
| 0 T5UAP | TAXAR | T5UTB | Work Tax Areas | MANDT |
| 0 T5UAP | TAXAR | T5UTB | Work Tax Areas | TAXAR |
| 0 T5UAP | TAXAR | T5UTB | Work Tax Areas | ENDDA |
| 1 T5UAP | WERKS | T001P | Personnel Area/Subarea | MANDT |
| 1 T5UAP | WERKS | T001P | Personnel Area/Subarea | WERKS |
| 1 T5UAP | WERKS | T001P | Personnel Area/Subarea | BTRTL |