SAP ABAP Table T5DB5 (Construction Site File: Work Breakdown Structure Element)

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	T5DB5	Table Relationship Diagram
Short Description	Construction Site File: Work Breakdown Structure Element

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	POSNR	☑	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
3	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
4	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
5	.INCLUDE	☐				0	0	Include Structure for Construction Site Fields
6	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
7	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
8	BENDD	☐	P01B_BENDD	DATUM	DATS	8	0	End of Construction
9	BBEGD	☐	P01B_BEGDD	DATUM	DATS	8	0	Beginning of construction
10	BALEI	☐	P01B_BALEI	TEXT25	CHAR	25	0	Construction Site Supervisor
11	PERNR	☐	P01B_PERNR	PERSNO	NUMC	8	0	Personnel Number	PA0003
12	GMDN1	☐	GMNDN	GMNDN	NUMC	8	0	Municipality Number (D)	T5D2B
13	GMDP1	☐	P01B_GMDPR	DEC3_2	DEC	5	2	Percentage Rate of Trade Tax for Municipality
14	GMDN2	☐	GMNDN	GMNDN	NUMC	8	0	Municipality Number (D)	T5D2B
15	GMDP2	☐	P01B_GMDPR	DEC3_2	DEC	5	2	Percentage Rate of Trade Tax for Municipality
16	GMDN3	☐	GMNDN	GMNDN	NUMC	8	0	Municipality Number (D)	T5D2B
17	GMDP3	☐	P01B_GMDPR	DEC3_2	DEC	5	2	Percentage Rate of Trade Tax for Municipality
18	BULND	☐	BULND	REGIO	CHAR	3	0	State	T005S
19	STSPA	☐	P01B_STSPA	P013_STSPA	CHAR	4	0	Division of State Statistics Office
20	BRFGN	☐	P015_BRFGN	P015_BRFGN	CHAR	2	0	Workers' Compensation Association	T5D3A
21	GFTGE	☐	P01B_GFTGE	P015_GFTST	CHAR	2	0	Hazard Pay Area: Industrial Workers	T5D3B
22	GFTAN	☐	P01B_GFTAN	P015_GFTST	CHAR	2	0	Hazard Pay Area Employees	T5D3B
23	BRFGP	☐	P01B_BRFGP	DEC3_2	DEC	5	2	Workers' Compensation Association Percentage
24	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
25	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
26	ORT02	☐	ORT02	TEXT25	CHAR	25	0	District
27	PSTLZ	☐	PSTLZ_HR	PSTLZ	CHAR	10	0	Postal Code
28	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
29	TELNR	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
30	MOFID	☐	HIDENT	HIDENT	CHAR	2	0	Public Holiday Calendar	THOCI
31	BASCH	☐	P01B_BASC1	SCHKN	CHAR	8	0	Work schedule rule	T508A
32	MEHKN	☐	P01B_MEHKN	P01B_MEHKN	CHAR	2	0	Overtime Rule
33	RUEST	☐	P01B_RUEST	DEC3_2	DEC	5	2	Setup time
34	BSA01	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
35	BSA02	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
36	BSA03	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
37	BSA04	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
38	BSA05	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
39	BSA06	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
40	BSA07	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
41	BSA08	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
42	ARGEN	☐	P01B_ARGEN	P01B_ARGEN	NUMC	6	0	Work Cooperative	T5DB0
43	BGKAG	☐	P01B_BGKAG	CHAR10	CHAR	10	0	WCA Company Number: Risk Category (Salaried Employees)
44	BGKGW	☐	P01B_BGKGW	CHAR10	CHAR	10	0	WCA Company Number: Risk Category (Industrial Workers)
45	REIZI	☐	P01B_REIZI	CHAR10	CHAR	10	0	Destination / Construction Industry Expenses	T5DB_REISEZIEL

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T5DB5	ARGEN	T5DB0	ARGEM	REF	1	CN
2	T5DB5	BASCH	T508A	SCHKZ	REF	C	CN
3	T5DB5	BRFGN	T5D3A	BRFGN	REF	C	CN
4	T5DB5	BSA01	T5DBH	BSATT	REF	C	CN
5	T5DB5	BSA02	T5DBH	BSATT	REF	C	CN
6	T5DB5	BSA03	T5DBH	BSATT	REF	C	CN
7	T5DB5	BSA04	T5DBH	BSATT	REF	C	CN
8	T5DB5	BSA05	T5DBH	BSATT	REF	C	CN
9	T5DB5	BSA06	T5DBH	BSATT	REF	C	CN
10	T5DB5	BSA07	T5DBH	BSATT	REF	C	CN
11	T5DB5	BSA08	T5DBH	BSATT	REF	C	CN
12	T5DB5	BULND	T005S	BLAND		C	CN
13	T5DB5	GFTAN	T5D3B	GFTST	REF	C	CN
14	T5DB5	GFTGE	T5D3B	GFTST	REF	C	CN
15	T5DB5	GMDN1	T5D2B	GMDNR	REF	1	CN
16	T5DB5	GMDN2	T5D2B	GMDNR		1	CN
17	T5DB5	GMDN3	T5D2B	GMDNR		1	CN
18	T5DB5	LAND1	T005	LAND1	REF	C	CN
19	T5DB5	MANDT	T000	MANDT	KEY	1	CN
20	T5DB5	MOFID	THOCI	IDENT	REF	C	CN
21	T5DB5	PERNR	PA0003	PERNR	REF	1	CN
22	T5DB5	POSNR	PRPS	PSPNR	KEY	1	CN
23	T5DB5	REIZI	T5DB_REISEZIEL	REIZI	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in