SAP Table T5UAP
Address for personnel area/subarea
T5UAP (Address for personnel area/subarea) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link T5UAP to other SAP tables.
T5UAP table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
WERKS | Personnel Area | PERSA | T001P | CHAR | 4 | 0 | ||
BTRTL | Personnel Subarea | BTRTL_001P | T001P | CHAR | 4 | 0 | ||
ENDDA | End Date | ENDDA | DATS | 8 | 0 | |||
BEGDA | Start Date | BEGDA | DATS | 8 | 0 | |||
STRAS | Street and House Number | PAD_STRAS | CHAR | 60 | 0 | |||
LOCAT | 2nd Address Line | LOCAT | CHAR | 30 | 0 | |||
ORT01 | City | PAD_ORT01 | CHAR | 40 | 0 | |||
CONTY | Text length 25 | TEXT25 | CHAR | 25 | 0 | |||
STATE | Region (State, Province, County) | REGIO | T005S | CHAR | 3 | 0 | ||
ZIPCD | Postal Code | PSTLZ_HR | CHAR | 10 | 0 | |||
TELNR | Telephone Number | TELNR | CHAR | 14 | 0 | |||
CONTP | Employee's Name (Sortable by LAST NAME FIRST NAME) | SMNAM | CHAR | 30 | 0 | |||
TAXAR | Work Tax Area | WRKAR | T5UTB | CHAR | 4 | 0 |
T5UAP foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
T5UAP | BTRTL | T5UAP | WERKS | T001P | Personnel Area/Subarea | WERKS |
T5UAP | BTRTL | T5UAP | BTRTL | T001P | Personnel Area/Subarea | BTRTL |
T5UAP | BTRTL | T5UAP | MANDT | T001P | Personnel Area/Subarea | MANDT |
T5UAP | MANDT | T5UAP | MANDT | T000 | Clients | MANDT |
T5UAP | STATE | T5UAP | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
T5UAP | STATE | 'US ' | T005S | Taxes: Region (Province) Key | LAND1 | |
T5UAP | STATE | T5UAP | STATE | T005S | Taxes: Region (Province) Key | BLAND |
T5UAP | TAXAR | T5UAP | ENDDA | T5UTB | Work Tax Areas | ENDDA |
T5UAP | TAXAR | T5UAP | MANDT | T5UTB | Work Tax Areas | MANDT |
T5UAP | TAXAR | T5UAP | TAXAR | T5UTB | Work Tax Areas | TAXAR |
T5UAP | WERKS | T5UAP | MANDT | T001P | Personnel Area/Subarea | MANDT |
T5UAP | WERKS | T5UAP | WERKS | T001P | Personnel Area/Subarea | WERKS |
T5UAP | WERKS | T5UAP | BTRTL | T001P | Personnel Area/Subarea | BTRTL |