T5DB4

HR Construction Site File | #other | Component: Construction Industry

🔑 Keys (12)
💰 Amounts
∑ Quantities
📅 Dates (5)
☰ Categorical (1)
Other (16)
🔗 Relations (29)

Column Name	Description
MANDT FK	Client
BAUID	Identification of CO Objects for HR Construction Sites	Show values
POSNR FK	Work Breakdown Structure Element (WBS Element)
AUFNR FK	Order Number
KOKRS FK	Controlling Area
KOSTL FK	Cost Center
NPLNR FK	Network Number for Account Assignment
VORNR	Operation/Activity Number
KDAUF FK	Sales Order Number
KDPOS	Item number in Sales Order
KSTRG FK	Cost Object
ENDDA	End Date

Column Name	Description

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date
AEDTM	Last Changed On
BENDD	End of Construction
BBEGD	Beginning of Construction

Column Name	Description
BAUID	Identification of CO Objects for HR Construction Sites	Show values

Column Name	Description	Domain name
AENAM	Name of Person Who Changed Object	USNAM
BALEI	Construction Site Supervisor	TEXT25
GMDP1	Percentage Rate of Trade Tax for Municipality	DEC3_2
GMDP2	Percentage Rate of Trade Tax for Municipality	DEC3_2
GMDP3	Percentage Rate of Trade Tax for Municipality	DEC3_2
STSPA	Division of State Statistics Office	P013_STSPA
BRFGP	Workers' Compensation Association Percentage	DEC3_2
STRAS	Street and House Number	TEXT30
ORT01	City	TEXT25
ORT02	District	TEXT25
PSTLZ	Postal Code	PSTLZ
TELNR	Telephone Number	TELNR
MEHKN	Overtime Rule	P01B_MEHKN
RUEST	Setup time	DEC3_2
BGKAG	WCA Company Number: Risk Category (Salaried Employees)	CHAR10
BGKGW	WCA Company Number: Risk Category (Industrial Workers)	CHAR10

Master Data Relations \| to Other Relations ↓	Join Conditions
Order Number Order Number Client	`T5DB4.AUFNR == AUFK.AUFNR` `T5DB4.MANDT == AUFK.MANDT`
Work Schedule Rules ? Work schedule rule ? Client ? Public Holiday Calendar	`T5DB4.[column in domain "MOSID"] == T508A.MOSID` `T5DB4.BASCH == T508A.SCHKZ` `T5DB4.[column in domain "ENDDA"] == T508A.ENDDA` `T5DB4.MANDT == T508A.MANDT` `T5DB4.[column in domain "DZEITY"] == T508A.ZEITY` `T5DB4.MOFID == T508A.MOFID`
Workers' Compensation Association Workers' Compensation Association Client ?	`T5DB4.BRFGN == T5D3A.BRFGN` `T5DB4.MANDT == T5D3A.MANDT` `T5DB4.[column in domain "ENDDA"] == T5D3A.ENDDA`
State Country/Region Key State	`T5DB4.MANDT == T005S.MANDT` `T5DB4.LAND1 == T005S.LAND1` `T5DB4.BULND == T005S.BLAND`
Hazard Rate Class Workers' Compensation Association Hazard Pay Area Employees ?	`T5DB4.MANDT == T5D3B.MANDT` `T5DB4.BRFGN == T5D3B.BRFGN` `T5DB4.GFTAN == T5D3B.GFTST` `T5DB4.[column in domain "ENDDA"] == T5D3B.ENDDA`
Hazard Rate Class Workers' Compensation Association Hazard Pay Area: Industrial Workers ?	`T5DB4.MANDT == T5D3B.MANDT` `T5DB4.BRFGN == T5D3B.BRFGN` `T5DB4.GFTGE == T5D3B.GFTST` `T5DB4.[column in domain "ENDDA"] == T5D3B.ENDDA`
Controlling Area	`T5DB4.MANDT == TKA01.MANDT` `T5DB4.KOKRS == TKA01.KOKRS`
Cost Center ? Cost Center Controlling Area	`T5DB4.MANDT == CSKS.MANDT` `T5DB4.[column in domain "DATBI"] == CSKS.DATBI` `T5DB4.KOSTL == CSKS.KOSTL` `T5DB4.KOKRS == CSKS.KOKRS`
Cost Object Cost Object ? Client	`T5DB4.KSTRG == CKPH.KSTRG` `T5DB4.[column in domain "DATBI"] == CKPH.DATBI` `T5DB4.MANDT == CKPH.MANDT`
Country Country/Region Key Client	`T5DB4.LAND1 == T005.LAND1` `T5DB4.MANDT == T005.MANDT`
Client	`T5DB4.MANDT == T000.MANDT`
Public Holiday Modifier	`T5DB4.MOFID == THOCI.IDENT`
Network Number for Account Assignment Network Number for Account Assignment Client	`T5DB4.NPLNR == AUFK.AUFNR` `T5DB4.MANDT == AUFK.MANDT`
Personnel Number Personnel Number Client	`T5DB4.PERNR == PA0003.PERNR` `T5DB4.MANDT == PA0003.MANDT`
Destination / Construction Industry Expenses Destination / Construction Industry Expenses Client	`T5DB4.REIZI == T5DB_REISEZIEL.REIZI` `T5DB4.MANDT == T5DB_REISEZIEL.MANDT`

Other Relations \| to Master Data Relations ↑	Join Conditions
Work Cooperative Work Cooperative Client	`T5DB4.ARGEN == T5DB0.ARGEM` `T5DB4.MANDT == T5DB0.MANDT`
Construction Site Attributes Attributes ? Client ?	`T5DB4.BSA01 == T5DBH.BSATT` `T5DB4.[column in domain "ENDDA"] == T5DBH.ENDDA` `T5DB4.MANDT == T5DBH.MANDT` `T5DB4.[column in domain "P01B_BSATY"] == T5DBH.BSATY`
Construction Site Attributes Attributes ? Client ?	`T5DB4.BSA02 == T5DBH.BSATT` `T5DB4.[column in domain "ENDDA"] == T5DBH.ENDDA` `T5DB4.MANDT == T5DBH.MANDT` `T5DB4.[column in domain "P01B_BSATY"] == T5DBH.BSATY`
Construction Site Attributes Attributes ? Client ?	`T5DB4.BSA03 == T5DBH.BSATT` `T5DB4.[column in domain "ENDDA"] == T5DBH.ENDDA` `T5DB4.MANDT == T5DBH.MANDT` `T5DB4.[column in domain "P01B_BSATY"] == T5DBH.BSATY`
Construction Site Attributes Attributes ? Client ?	`T5DB4.BSA04 == T5DBH.BSATT` `T5DB4.[column in domain "ENDDA"] == T5DBH.ENDDA` `T5DB4.MANDT == T5DBH.MANDT` `T5DB4.[column in domain "P01B_BSATY"] == T5DBH.BSATY`
Construction Site Attributes Attributes ? Client ?	`T5DB4.BSA05 == T5DBH.BSATT` `T5DB4.[column in domain "ENDDA"] == T5DBH.ENDDA` `T5DB4.MANDT == T5DBH.MANDT` `T5DB4.[column in domain "P01B_BSATY"] == T5DBH.BSATY`
Construction Site Attributes Attributes ? Client ?	`T5DB4.BSA06 == T5DBH.BSATT` `T5DB4.[column in domain "ENDDA"] == T5DBH.ENDDA` `T5DB4.MANDT == T5DBH.MANDT` `T5DB4.[column in domain "P01B_BSATY"] == T5DBH.BSATY`
Construction Site Attributes Attributes ? Client ?	`T5DB4.BSA07 == T5DBH.BSATT` `T5DB4.[column in domain "ENDDA"] == T5DBH.ENDDA` `T5DB4.MANDT == T5DBH.MANDT` `T5DB4.[column in domain "P01B_BSATY"] == T5DBH.BSATY`
Construction Site Attributes Attributes ? Client ?	`T5DB4.BSA08 == T5DBH.BSATT` `T5DB4.[column in domain "ENDDA"] == T5DBH.ENDDA` `T5DB4.MANDT == T5DBH.MANDT` `T5DB4.[column in domain "P01B_BSATY"] == T5DBH.BSATY`
Municipality Numbers	`T5DB4.GMDN1 == T5D2B.GMDNR`
Municipality Key	`T5DB4.GMDN2 == T5D2B.GMDNR`
Municipality Key	`T5DB4.GMDN3 == T5D2B.GMDNR`