T5ITNL

01/M data history | #transactional | Component: Italy

🔑 Keys (10)
💰 Amounts (2)
∑ Quantities
📅 Dates (4)
☰ Categorical (1)
Other (5)
🔗 Relations (5)

Column Name	Description
MANDT FK	Client
INPSM	INPS registration number
PERNR	Personnel Number
CODQU FK	INPS pay scale indicator 1
ASSCO	Insurances covered by INPS	Show values
CDRAP	Contribution Type (INPS Relation Indicator)
CDMOD FK	Form indicator
CDQUA FK	Form section indicator
CDESP FK	Contribution / exposure indicator
ENDDA	End Date

Column Name	Description
💲 Currency Key (T500C.WAERS):
IMPO1	Amount 1
IMPO2	Amount 2

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date
PERI1	Validity start period
PERI2	Validity end date

Column Name	Description
ASSCO	Insurances covered by INPS	Show values

Column Name	Description	Domain name
NUME1	Field number 1	P15_NUME1
NUME2	Field number 2	P15_NUME2
NUME3	Field number 3	P15_NUME3
NUME4	Field number 4	P15_NUME4
STRIN	String field	P15_STRIN

Master Data Relations	Join Conditions
Contribution / exposure indicator Form indicator Contribution / exposure indicator	`T5ITNL.MANDT == T5ITNT.MANDT` `T5ITNL.CDMOD == T5ITNT.CDMOD` `T5ITNL.CDESP == T5ITNT.CDESP`
Form indicator	`T5ITNL.MANDT == T5ITNM.MANDT` `T5ITNL.CDMOD == T5ITNM.CDMOD`
Form section indicator Form indicator Form section indicator	`T5ITNL.MANDT == T5ITNQ.MANDT` `T5ITNL.CDMOD == T5ITNQ.CDMOD` `T5ITNL.CDQUA == T5ITNQ.CDQUA`
INPS pay scale indicator 1 INPS pay scale indicator 1 Client	`T5ITNL.CODQU == T5ITNU.CODQU` `T5ITNL.MANDT == T5ITNU.MANDT`
Client	`T5ITNL.MANDT == T000.MANDT`