SAP Table T500P
Personnel Areas
T500P (Personnel Areas) 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 T500P to other SAP tables.
T500P table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values |
|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |
|
PERSA
Personnel Area
|
PERSA |
CHAR
|
4 | 0 | ||
|
MOLGA
Country Grouping
|
MOLGA | T500L |
CHAR
|
2 | 0 | |
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |
|
NAME1
Personnel Area Text
|
PBTXT |
CHAR
|
30 | 0 | ||
|
NAME2
Name 2
|
NAME2 |
CHAR
|
30 | 0 | ||
|
STRAS
House number and street
|
STRAS |
CHAR
|
30 | 0 | ||
|
PFACH
PO Box
|
PFACH |
CHAR
|
10 | 0 | ||
|
PSTLZ
Postal Code
|
PSTLZ |
CHAR
|
10 | 0 | ||
|
ORT01
City
|
ORT01 |
CHAR
|
25 | 0 | ||
|
LAND1
Country Key
|
LAND1 | T005 |
CHAR
|
3 | 0 | |
|
REGIO
Region (State, Province, County)
|
REGIO | T005S |
CHAR
|
3 | 0 | |
|
COUNC
County Code
|
COUNC | T005E |
CHAR
|
3 | 0 | |
|
CITYC
City Code
|
CITYC | T005G |
CHAR
|
4 | 0 | |
|
ADRNR
Address
|
ADRNR |
CHAR
|
10 | 0 |
T500P foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| T500P | BUKRS | T500P | MANDT |
T001
Company Codes
|
MANDT |
| T500P | BUKRS | T500P | BUKRS |
T001
Company Codes
|
BUKRS |
| T500P | CITYC | T500P | REGIO |
T005G
City
|
REGIO |
| T500P | CITYC | T500P | CITYC |
T005G
City
|
CITYC |
| T500P | CITYC | T500P | MANDT |
T005G
City
|
MANDT |
| T500P | CITYC | T500P | LAND1 |
T005G
City
|
LAND1 |
| T500P | COUNC | T500P | LAND1 |
T005E
County
|
LAND1 |
| T500P | COUNC | T500P | REGIO |
T005E
County
|
REGIO |
| T500P | COUNC | T500P | COUNC |
T005E
County
|
COUNC |
| T500P | COUNC | T500P | MANDT |
T005E
County
|
MANDT |
| T500P | LAND1 | T500P | MANDT |
T005
Countries
|
MANDT |
| T500P | LAND1 | T500P | LAND1 |
T005
Countries
|
LAND1 |
| T500P | MANDT | T500P | MANDT |
T000
Clients
|
MANDT |
| T500P | MOLGA | T500P | MOLGA |
T500L
Personnel Country Grouping
|
MOLGA |
| T500P | REGIO | T500P | MANDT |
T005S
Taxes: Region (Province) Key
|
MANDT |
| T500P | REGIO | T500P | LAND1 |
T005S
Taxes: Region (Province) Key
|
LAND1 |
| T500P | REGIO | T500P | REGIO |
T005S
Taxes: Region (Province) Key
|
BLAND |