SAP ABAP Table T5DB8 (Construction Sector: Team Assignment to Work Site)

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	T5DB8	Table Relationship Diagram
Short Description	Construction Sector: Team Assignment to Work Site

Delivery and Maintenance

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

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	T5DB7
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	ZEITY	☐	DZEITY	ZEITY	CHAR	1	0	Employee Subgroup Grouping for Work Schedules
10	MOFID	☐	HIDENT	HIDENT	CHAR	2	0	Public Holiday Calendar	THOCI
11	KOSCH	☐	P01B_KOSCH	SCHKN	CHAR	8	0	Work schedule rule	T508A
12	MEHRR	☐	P01B_MEHRR	P01B_MEHKN	CHAR	2	0	Overtime Rule
13	AKKOR	☐	P01B_AKKOR	P01B_AKKOR	CHAR	2	0	Piecework Rule
14	PRAEK	☐	P01B_PRAEK	P01B_KONST	CHAR	5	0	Premium Identifier	T5DBK
15	RUEST	☐	P01B_RUEST	DEC3_2	DEC	5	2	Setup time
16	KOA01	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
17	KOA02	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
18	KOA03	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
19	KOA04	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
20	KOA05	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
21	KOA06	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
22	KOA07	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
23	KOA08	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
24	POSNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
25	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
26	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
27	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
28	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
29	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
30	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
31	ARTDA	☐	P01B_ARTDA	P01B_BSATT	CHAR	2	0	Type of Work	T5DBH
32	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
33	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
34	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	CKPH

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T5DB8	ARTDA	T5DBH	BSATT	REF	C	CN
2	T5DB8	AUFNR	AUFK	AUFNR	REF	C	CN
3	T5DB8	BTRTL	T001P	BTRTL	KEY	1	CN
4	T5DB8	BUKRS	T001	BUKRS		C	CN
5	T5DB8	KDAUF	VBUK	VBELN	REF	C	CN
6	T5DB8	KOA01	T5DBH	BSATT	REF	C	CN
7	T5DB8	KOA02	T5DBH	BSATT	REF	C	CN
8	T5DB8	KOA03	T5DBH	BSATT	REF	C	CN
9	T5DB8	KOA04	T5DBH	BSATT	REF	C	CN
10	T5DB8	KOA05	T5DBH	BSATT	REF	C	CN
11	T5DB8	KOA06	T5DBH	BSATT	REF	C	CN
12	T5DB8	KOA07	T5DBH	BSATT	REF	C	CN
13	T5DB8	KOA08	T5DBH	BSATT	REF	C	CN
14	T5DB8	KOKRS	TKA01	KOKRS	REF	C	CN
15	T5DB8	KOLON	T5DB7	KOLON	KEY	1	CN
16	T5DB8	KOSCH	T508A	SCHKZ	REF	C	CN
17	T5DB8	KOSTL	CSKS	KOSTL	REF	C	CN
18	T5DB8	KSTRG	CKPH	KSTRG	REF	C	CN
19	T5DB8	MANDT	T000	MANDT	KEY	1	CN
20	T5DB8	MOFID	THOCI	IDENT	REF	C	CN
21	T5DB8	NPLNR	AUFK	AUFNR	REF	C	CN
22	T5DB8	POSNR	PRPS	PSPNR	REF	C	CN
23	T5DB8	PRAEK	T5DBK	KONST	REF	C	CN
24	T5DB8	WERKS	T500P	PERSA	KEY	1	CN

History

Last changed by/on	SAP	20080626
SAP Release Created in