SAP ABAP Table T5DB7 (Team Description)

Hierarchy

☛ SAP_HRCDE (Software Component) Sub component SAP_HRCDE of SAP_HR
   ⤷ PY-DE-CI (Application Component) Construction Industry
     ⤷ P01B (Package) Payroll: Construction Industry

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T5DB7	Table Relationship Diagram
Short Description	Team Description

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	WERKS	☑	PERSA	PERSA	CHAR	4	0	Personnel Area	T500P
3	BTRTL	☑	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	T001P
4	KOLON	☑	P01B_KOLON	P01B_KOLON	CHAR	4	0	Team
5	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
6	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
7	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
8	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
9	KOTXT	☐	P01B_KOTXT	TEXT40	CHAR	40	0	Team Name
10	KOLEI	☐	P01B_KOLEI	TXT25	CHAR	25	0	Team Manager
11	PERNR	☐	P01B_PERNR	PERSNO	NUMC	8	0	Personnel Number	PA0003
12	KOFTX	☐	P01B_KOFTX	XFELD	CHAR	1	0	Indicator Text
13	FTXT1	☐	P01B_FTEXT	P01B_FTEXT	CHAR	72	0	User-Defined Text
14	FTXT2	☐	P01B_FTEXT	P01B_FTEXT	CHAR	72	0	User-Defined Text
15	FTXT3	☐	P01B_FTEXT	P01B_FTEXT	CHAR	72	0	User-Defined Text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T5DB7	BTRTL	T001P	BTRTL	KEY	1	CN
2	T5DB7	MANDT	T000	MANDT	KEY	1	CN
3	T5DB7	PERNR	PA0003	PERNR	REF	C	CN
4	T5DB7	WERKS	T500P	PERSA	KEY	1	CN

History

Last changed by/on	SAP	20080626
SAP Release Created in