T5ITIS

Sickness handling scale c/company | #other | Component: Italy

🔑 Keys (7)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical (2)
Other (15)
🔗 Relations (18)

Column Name	Description
MANDT FK	Client
TRFAR FK	Pay scale type
TRFGB FK	Pay Scale Area
TRFKZ	ES grouping for collective agreement provision
TPTRA	Absence treatment type	Show values
SCAGLI	Seniority scale	Show values
ENDDA	End Date

Column Name	Description

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description
TPTRA	Absence treatment type	Show values
SCAGLI	Seniority scale	Show values

Column Name	Description	Domain name
MMLIM	Maximum number of months	P15_MAMLI
GGLI1	Sickness range days	P15_LIMMA
GGLR1	Subsequent sickness limit	P15_LIMRI
GGLI2	Sickness range days	P15_LIMMA
GGLR2	Subsequent sickness limit	P15_LIMRI
GGLI3	Sickness range days	P15_LIMMA
GGLR3	Subsequent sickness limit	P15_LIMRI
GGLI4	Sickness range days	P15_LIMMA
GGLR4	Subsequent sickness limit	P15_LIMRI
GGLI5	Sickness range days	P15_LIMMA
GGLR5	Subsequent sickness limit	P15_LIMRI
GGCOM	Grace days	P15_GGCOM
GGCOP	Extended grace days	P15_GGCPR
GGBON	Bonus days	P15_GGCOB
GGMAB	Max no. of days for bonus	P15_GGCOB

Master Data Relations \| to Other Relations ↓	Join Conditions
Client	`T5ITIS.MANDT == T000.MANDT`
Wage type: company integration ? ? Client Wage type: company integration	`T5ITIS.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIS.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIS.MANDT == T512W.MANDT` `T5ITIS.WTIN1 == T512W.LGART`
Wage type: company integration ? ? Client Wage type: company integration	`T5ITIS.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIS.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIS.MANDT == T512W.MANDT` `T5ITIS.WTIN2 == T512W.LGART`
Wage type: company integration ? ? Client Wage type: company integration	`T5ITIS.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIS.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIS.MANDT == T512W.MANDT` `T5ITIS.WTIN3 == T512W.LGART`
Wage type: company integration ? ? Client Wage type: company integration	`T5ITIS.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIS.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIS.MANDT == T512W.MANDT` `T5ITIS.WTIN4 == T512W.LGART`
Wage type: company integration ? ? Client Wage type: company integration	`T5ITIS.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITIS.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITIS.MANDT == T512W.MANDT` `T5ITIS.WTIN5 == T512W.LGART`

Other Relations \| to Master Data Relations ↑	Join Conditions
Absence/attendance category ? Absence/attendance category ? Client	`T5ITIS.[column in domain "SPRAS"] == T554P.SPRSL` `T5ITIS.ABST1 == T554P.ABSTP` `T5ITIS.[column in domain "MOABW"] == T554P.MOABW` `T5ITIS.MANDT == T554P.MANDT`
Absence/attendance category ? Absence/attendance category ? Client	`T5ITIS.[column in domain "SPRAS"] == T554P.SPRSL` `T5ITIS.ABST2 == T554P.ABSTP` `T5ITIS.[column in domain "MOABW"] == T554P.MOABW` `T5ITIS.MANDT == T554P.MANDT`
Absence/attendance category ? Absence/attendance category ? Client	`T5ITIS.[column in domain "SPRAS"] == T554P.SPRSL` `T5ITIS.ABST3 == T554P.ABSTP` `T5ITIS.[column in domain "MOABW"] == T554P.MOABW` `T5ITIS.MANDT == T554P.MANDT`
Absence/attendance category ? Absence/attendance category ? Client	`T5ITIS.[column in domain "SPRAS"] == T554P.SPRSL` `T5ITIS.ABST4 == T554P.ABSTP` `T5ITIS.[column in domain "MOABW"] == T554P.MOABW` `T5ITIS.MANDT == T554P.MANDT`
Absence/attendance category ? Absence/attendance category ? Client	`T5ITIS.[column in domain "SPRAS"] == T554P.SPRSL` `T5ITIS.ABST5 == T554P.ABSTP` `T5ITIS.[column in domain "MOABW"] == T554P.MOABW` `T5ITIS.MANDT == T554P.MANDT`
Percentage type Percentage type ? ? Client	`T5ITIS.ABSY1 == T5ITI3.ABSTY` `T5ITIS.[column in domain "MOABW"] == T5ITI3.MOABW` `T5ITIS.[column in domain "ENDDA"] == T5ITI3.ENDDA` `T5ITIS.MANDT == T5ITI3.MANDT`
Percentage type Percentage type ? ? Client	`T5ITIS.ABSY2 == T5ITI3.ABSTY` `T5ITIS.[column in domain "MOABW"] == T5ITI3.MOABW` `T5ITIS.[column in domain "ENDDA"] == T5ITI3.ENDDA` `T5ITIS.MANDT == T5ITI3.MANDT`
Percentage type Percentage type ? ? Client	`T5ITIS.ABSY3 == T5ITI3.ABSTY` `T5ITIS.[column in domain "MOABW"] == T5ITI3.MOABW` `T5ITIS.[column in domain "ENDDA"] == T5ITI3.ENDDA` `T5ITIS.MANDT == T5ITI3.MANDT`
Percentage type Percentage type ? ? Client	`T5ITIS.ABSY4 == T5ITI3.ABSTY` `T5ITIS.[column in domain "MOABW"] == T5ITI3.MOABW` `T5ITIS.[column in domain "ENDDA"] == T5ITI3.ENDDA` `T5ITIS.MANDT == T5ITI3.MANDT`
Percentage type Percentage type ? ? Client	`T5ITIS.ABSY5 == T5ITI3.ABSTY` `T5ITIS.[column in domain "MOABW"] == T5ITI3.MOABW` `T5ITIS.[column in domain "ENDDA"] == T5ITI3.ENDDA` `T5ITIS.MANDT == T5ITI3.MANDT`
Pay scale type ? Pay scale type	`T5ITIS.MANDT == T510A.MANDT` `T5ITIS.[column in domain "MOLGA"] == T510A.MOLGA` `T5ITIS.TRFAR == T510A.TRFAR`
Pay Scale Area ? Client Pay Scale Area	`T5ITIS.[column in domain "MOLGA"] == T510G.MOLGA` `T5ITIS.MANDT == T510G.MANDT` `T5ITIS.TRFGB == T510G.TRFGB`