SAP Table T5DB7
Team Description
T5DB7 (Team Description) 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 T5DB7 to other SAP tables.
T5DB7 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| WERKS | Personnel Area | PERSA | T500P | CHAR | 4 | 0 | ||||||
| BTRTL | Personnel Subarea | BTRTL | T001P | CHAR | 4 | 0 | ||||||
| KOLON | Team | P01B_KOLON | CHAR | 4 | 0 | |||||||
| ENDDA | End Date | ENDDA | DATS | 8 | 0 | |||||||
| BEGDA | Start Date | BEGDA | DATS | 8 | 0 | |||||||
| AEDTM | Changed On | AEDAT | DATS | 8 | 0 | |||||||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||
| KOTXT | Team Name | P01B_KOTXT | CHAR | 40 | 0 | |||||||
| KOLEI | Team Manager | P01B_KOLEI | CHAR | 25 | 0 | |||||||
| PERNR | Personnel Number | P01B_PERNR | PA0003 | NUMC | 8 | 0 | ||||||
| KOFTX | Indicator Text | P01B_KOFTX | CHAR | 1 | 0 |
Possible values
|
||||||
| FTXT1 | User-Defined Text | P01B_FTEXT | CHAR | 72 | 0 | |||||||
| FTXT2 | User-Defined Text | P01B_FTEXT | CHAR | 72 | 0 | |||||||
| FTXT3 | User-Defined Text | P01B_FTEXT | CHAR | 72 | 0 | |||||||
T5DB7 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| T5DB7 | BTRTL | T5DB7 | MANDT | T001P | Personnel Area/Subarea | MANDT |
| T5DB7 | BTRTL | T5DB7 | WERKS | T001P | Personnel Area/Subarea | WERKS |
| T5DB7 | BTRTL | T5DB7 | BTRTL | T001P | Personnel Area/Subarea | BTRTL |
| T5DB7 | MANDT | T5DB7 | MANDT | T000 | Clients | MANDT |
| T5DB7 | PERNR | T5DB7 | MANDT | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | MANDT |
| T5DB7 | PERNR | T5DB7 | PERNR | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | PERNR |
| T5DB7 | WERKS | T5DB7 | MANDT | T500P | Personnel Areas | MANDT |
| T5DB7 | WERKS | T5DB7 | WERKS | T500P | Personnel Areas | PERSA |
