T5DB8

Obsolete: Construction Sector: Team Assignment to Work Site | #obsolete | Component: Construction Industry

🔑 Keys (5)
💰 Amounts
∑ Quantities
📅 Dates (3)
☰ Categorical
Other (7)
🔗 Relations (24)

Column Name	Description
MANDT FK	Client
WERKS FK	Personnel Area
BTRTL FK	Personnel Subarea
KOLON FK	Team
ENDDA	End Date

Column Name	Description

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date
AEDTM	Last Changed On

Column Name	Description

Column Name	Description	Domain name
AENAM	Name of Person Who Changed Object	USNAM
ZEITY	Employee Subgroup Grouping for Work Schedules	ZEITY
MEHRR	Overtime Rule	P01B_MEHKN
AKKOR	Piecework Rule	P01B_AKKOR
RUEST	Setup time	DEC3_2
VORNR	Operation/Activity Number	VORNR
KDPOS	Item number in Sales Order	NUM06

Master Data Relations \| to Other Relations ↓	Join Conditions
Order Number Order Number Client	`T5DB8.AUFNR == AUFK.AUFNR` `T5DB8.MANDT == AUFK.MANDT`
Company Code	`T5DB8.MANDT == T001.MANDT` `T5DB8.BUKRS == T001.BUKRS`
Controlling Area	`T5DB8.MANDT == TKA01.MANDT` `T5DB8.KOKRS == TKA01.KOKRS`
Work schedule rule ? Work schedule rule ? Client ? Public Holiday Calendar	`T5DB8.[column in domain "MOSID"] == T508A.MOSID` `T5DB8.KOSCH == T508A.SCHKZ` `T5DB8.[column in domain "ENDDA"] == T508A.ENDDA` `T5DB8.MANDT == T508A.MANDT` `T5DB8.[column in domain "DZEITY"] == T508A.ZEITY` `T5DB8.MOFID == T508A.MOFID`
Cost Center ? Cost Center Controlling Area	`T5DB8.MANDT == CSKS.MANDT` `T5DB8.[column in domain "DATBI"] == CSKS.DATBI` `T5DB8.KOSTL == CSKS.KOSTL` `T5DB8.KOKRS == CSKS.KOKRS`
Cost Object Cost Object ? Client	`T5DB8.KSTRG == CKPH.KSTRG` `T5DB8.[column in domain "DATBI"] == CKPH.DATBI` `T5DB8.MANDT == CKPH.MANDT`
Client	`T5DB8.MANDT == T000.MANDT`
Public Holiday Calendar	`T5DB8.MOFID == THOCI.IDENT`
Network Number for Account Assignment Network Number for Account Assignment Client	`T5DB8.NPLNR == AUFK.AUFNR` `T5DB8.MANDT == AUFK.MANDT`
Premium Identifier ? Premium Identifier	`T5DB8.MANDT == T5DBK.MANDT` `T5DB8.[column in domain "ENDDA"] == T5DBK.ENDDA` `T5DB8.PRAEK == T5DBK.KONST`

Other Relations \| to Master Data Relations ↑	Join Conditions
Type of Work Type of Work ? Client ?	`T5DB8.ARTDA == T5DBH.BSATT` `T5DB8.[column in domain "ENDDA"] == T5DBH.ENDDA` `T5DB8.MANDT == T5DBH.MANDT` `T5DB8.[column in domain "P01B_BSATY"] == T5DBH.BSATY`
Personnel Subarea Personnel Subarea Personnel Area	`T5DB8.MANDT == T001P.MANDT` `T5DB8.BTRTL == T001P.BTRTL` `T5DB8.WERKS == T001P.WERKS`
Attributes Attributes ? Client ?	`T5DB8.KOA01 == T5DBH.BSATT` `T5DB8.[column in domain "ENDDA"] == T5DBH.ENDDA` `T5DB8.MANDT == T5DBH.MANDT` `T5DB8.[column in domain "P01B_BSATY"] == T5DBH.BSATY`
Attributes Attributes ? Client ?	`T5DB8.KOA02 == T5DBH.BSATT` `T5DB8.[column in domain "ENDDA"] == T5DBH.ENDDA` `T5DB8.MANDT == T5DBH.MANDT` `T5DB8.[column in domain "P01B_BSATY"] == T5DBH.BSATY`
Attributes Attributes ? Client ?	`T5DB8.KOA03 == T5DBH.BSATT` `T5DB8.[column in domain "ENDDA"] == T5DBH.ENDDA` `T5DB8.MANDT == T5DBH.MANDT` `T5DB8.[column in domain "P01B_BSATY"] == T5DBH.BSATY`
Attributes Attributes ? Client ?	`T5DB8.KOA04 == T5DBH.BSATT` `T5DB8.[column in domain "ENDDA"] == T5DBH.ENDDA` `T5DB8.MANDT == T5DBH.MANDT` `T5DB8.[column in domain "P01B_BSATY"] == T5DBH.BSATY`
Attributes Attributes ? Client ?	`T5DB8.KOA05 == T5DBH.BSATT` `T5DB8.[column in domain "ENDDA"] == T5DBH.ENDDA` `T5DB8.MANDT == T5DBH.MANDT` `T5DB8.[column in domain "P01B_BSATY"] == T5DBH.BSATY`
Attributes Attributes ? Client ?	`T5DB8.KOA06 == T5DBH.BSATT` `T5DB8.[column in domain "ENDDA"] == T5DBH.ENDDA` `T5DB8.MANDT == T5DBH.MANDT` `T5DB8.[column in domain "P01B_BSATY"] == T5DBH.BSATY`
Attributes Attributes ? Client ?	`T5DB8.KOA07 == T5DBH.BSATT` `T5DB8.[column in domain "ENDDA"] == T5DBH.ENDDA` `T5DB8.MANDT == T5DBH.MANDT` `T5DB8.[column in domain "P01B_BSATY"] == T5DBH.BSATY`
Attributes Attributes ? Client ?	`T5DB8.KOA08 == T5DBH.BSATT` `T5DB8.[column in domain "ENDDA"] == T5DBH.ENDDA` `T5DB8.MANDT == T5DBH.MANDT` `T5DB8.[column in domain "P01B_BSATY"] == T5DBH.BSATY`
Personnel Area	`T5DB8.MANDT == T500P.MANDT` `T5DB8.WERKS == T500P.PERSA`