SAP Table T5UPBSDSCITY
US Duty Station Cities
T5UPBSDSCITY (US Duty Station Cities) 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 T5UPBSDSCITY to other SAP tables.
T5UPBSDSCITY table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| STATE | Duty Station State or Country | P10_STATE | T5UPBSDSSTATE | CHAR | 2 | 0 | ||
| CONTY | Duty Station County | P10_CONTY | T5UPBSDSCOUNTY | CHAR | 3 | 0 | ||
| CITY | Duty Station City | P10_CITY | CHAR | 4 | 0 | |||
| LOCAR | Pay Scale Area | TRFGB | T510G | CHAR | 2 | 0 | ||
T5UPBSDSCITY foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| T5UPBSDSCITY | CONTY | T5UPBSDSCITY | MANDT | T5UPBSDSCOUNTY | US Federal Duty Station Counties | MANDT |
| T5UPBSDSCITY | CONTY | T5UPBSDSCITY | STATE | T5UPBSDSCOUNTY | US Federal Duty Station Counties | STATE |
| T5UPBSDSCITY | CONTY | T5UPBSDSCITY | CONTY | T5UPBSDSCOUNTY | US Federal Duty Station Counties | CONTY |
| T5UPBSDSCITY | LOCAR | T5UPBSDSCITY | MANDT | T510G | Pay Scale Areas | MANDT |
| T5UPBSDSCITY | LOCAR | '10' | T510G | Pay Scale Areas | MOLGA | |
| T5UPBSDSCITY | LOCAR | T5UPBSDSCITY | LOCAR | T510G | Pay Scale Areas | TRFGB |
| T5UPBSDSCITY | MANDT | T5UPBSDSCITY | MANDT | T000 | Clients | MANDT |
| T5UPBSDSCITY | STATE | T5UPBSDSCITY | MANDT | T5UPBSDSSTATE | US Federal Duty Station States | MANDT |
| T5UPBSDSCITY | STATE | T5UPBSDSCITY | STATE | T5UPBSDSSTATE | US Federal Duty Station States | STATE |
