SAP ABAP Table T5DB4 (HR Construction Site File)

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	T5DB4	Table Relationship Diagram
Short Description	HR Construction Site File

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	BAUID	☑	P01B_BAUID	P01B_BAUID	CHAR	1	0	Identification of CO Objects for HR Construction Sites
3	.INCLUDE	☑				0	0	Input Structure for RP_GET_BAUSTELLE
4	POSNR	☑	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
5	AUFNR	☑	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
6	KOKRS	☑	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
7	KOSTL	☑	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
8	NPLNR	☑	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
9	VORNR	☑	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
10	KDAUF	☑	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
11	KDPOS	☑	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
12	KSTRG	☑	KSTRG	KSTRG	CHAR	12	0	Cost Object	CKPH
13	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
14	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
15	.INCLUDE	☐				0	0	Include Structure for Construction Site Fields
16	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
17	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
18	BENDD	☐	P01B_BENDD	DATUM	DATS	8	0	End of Construction
19	BBEGD	☐	P01B_BEGDD	DATUM	DATS	8	0	Beginning of construction
20	BALEI	☐	P01B_BALEI	TEXT25	CHAR	25	0	Construction Site Supervisor
21	PERNR	☐	P01B_PERNR	PERSNO	NUMC	8	0	Personnel Number	PA0003
22	GMDN1	☐	GMNDN	GMNDN	NUMC	8	0	Municipality Number (D)	T5D2B
23	GMDP1	☐	P01B_GMDPR	DEC3_2	DEC	5	2	Percentage Rate of Trade Tax for Municipality
24	GMDN2	☐	GMNDN	GMNDN	NUMC	8	0	Municipality Number (D)	T5D2B
25	GMDP2	☐	P01B_GMDPR	DEC3_2	DEC	5	2	Percentage Rate of Trade Tax for Municipality
26	GMDN3	☐	GMNDN	GMNDN	NUMC	8	0	Municipality Number (D)	T5D2B
27	GMDP3	☐	P01B_GMDPR	DEC3_2	DEC	5	2	Percentage Rate of Trade Tax for Municipality
28	BULND	☐	BULND	REGIO	CHAR	3	0	State	T005S
29	STSPA	☐	P01B_STSPA	P013_STSPA	CHAR	4	0	Division of State Statistics Office
30	BRFGN	☐	P015_BRFGN	P015_BRFGN	CHAR	2	0	Workers' Compensation Association	T5D3A
31	GFTGE	☐	P01B_GFTGE	P015_GFTST	CHAR	2	0	Hazard Pay Area: Industrial Workers	T5D3B
32	GFTAN	☐	P01B_GFTAN	P015_GFTST	CHAR	2	0	Hazard Pay Area Employees	T5D3B
33	BRFGP	☐	P01B_BRFGP	DEC3_2	DEC	5	2	Workers' Compensation Association Percentage
34	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
35	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
36	ORT02	☐	ORT02	TEXT25	CHAR	25	0	District
37	PSTLZ	☐	PSTLZ_HR	PSTLZ	CHAR	10	0	Postal Code
38	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
39	TELNR	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
40	MOFID	☐	HIDENT	HIDENT	CHAR	2	0	Public Holiday Calendar	THOCI
41	BASCH	☐	P01B_BASC1	SCHKN	CHAR	8	0	Work schedule rule	T508A
42	MEHKN	☐	P01B_MEHKN	P01B_MEHKN	CHAR	2	0	Overtime Rule
43	RUEST	☐	P01B_RUEST	DEC3_2	DEC	5	2	Setup time
44	BSA01	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
45	BSA02	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
46	BSA03	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
47	BSA04	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
48	BSA05	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
49	BSA06	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
50	BSA07	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
51	BSA08	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
52	ARGEN	☐	P01B_ARGEN	P01B_ARGEN	NUMC	6	0	Work Cooperative	T5DB0
53	BGKAG	☐	P01B_BGKAG	CHAR10	CHAR	10	0	WCA Company Number: Risk Category (Salaried Employees)
54	BGKGW	☐	P01B_BGKGW	CHAR10	CHAR	10	0	WCA Company Number: Risk Category (Industrial Workers)
55	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	T5DB4	ARGEN	T5DB0	ARGEM	REF	1	CN
2	T5DB4	AUFNR	AUFK	AUFNR	KEY	C	CN
3	T5DB4	BASCH	T508A	SCHKZ	REF	C	CN
4	T5DB4	BRFGN	T5D3A	BRFGN	REF	C	CN
5	T5DB4	BSA01	T5DBH	BSATT	REF	C	CN
6	T5DB4	BSA02	T5DBH	BSATT	REF	C	CN
7	T5DB4	BSA03	T5DBH	BSATT	REF	C	CN
8	T5DB4	BSA04	T5DBH	BSATT	REF	C	CN
9	T5DB4	BSA05	T5DBH	BSATT	REF	C	CN
10	T5DB4	BSA06	T5DBH	BSATT	REF	C	CN
11	T5DB4	BSA07	T5DBH	BSATT	REF	C	CN
12	T5DB4	BSA08	T5DBH	BSATT	REF	C	CN
13	T5DB4	BULND	T005S	BLAND	REF	C	CN
14	T5DB4	GFTAN	T5D3B	GFTST	REF	C	CN
15	T5DB4	GFTGE	T5D3B	GFTST	REF	C	CN
16	T5DB4	GMDN1	T5D2B	GMDNR	REF	1	CN
17	T5DB4	GMDN2	T5D2B	GMDNR	REF	1	CN
18	T5DB4	GMDN3	T5D2B	GMDNR	REF	1	CN
19	T5DB4	KDAUF	VBUK	VBELN	KEY	C	CN
20	T5DB4	KOKRS	TKA01	KOKRS	KEY	C	CN
21	T5DB4	KOSTL	CSKS	KOSTL	KEY	C	CN
22	T5DB4	KSTRG	CKPH	KSTRG	KEY	C	CN
23	T5DB4	LAND1	T005	LAND1	REF	C	CN
24	T5DB4	MANDT	T000	MANDT	KEY	1	CN
25	T5DB4	MOFID	THOCI	IDENT	REF	C	CN
26	T5DB4	NPLNR	AUFK	AUFNR	KEY	C	CN
27	T5DB4	PERNR	PA0003	PERNR	REF	1	CN
28	T5DB4	POSNR	PRPS	PSPNR	KEY	C	CN
29	T5DB4	REIZI	T5DB_REISEZIEL	REIZI	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in