T5D16

Advanced Payment - Statement of Contributions Paid | #transactional | Component: Germany

🔑 Keys (11)
💰 Amounts (1)
∑ Quantities
📅 Dates (2)
☰ Categorical (1)
Other (1)
🔗 Relations (6)

Column Name	Description
MANDT FK	Client
MOD04	RP-DSV: Sort Modifier
ABKRS FK	Payroll Area
PABRJ	Payroll Year
PABRP	Payroll Period
WERKS FK	Personnel Area
BTRTL FK	Personnel Subarea
KVSCH FK	HI Fund Key for Compulsory Health Insurance Fund
KVGST FK	HI Fund Branch Office
LIART	List Type in SI Statement (D)
LFDNR	Sequence Number

Column Name	Description
💲 Currency Key (T500C.WAERS):
BETRG	HR payroll: Maximum amount

Column Name	Description

Column Name	Description
DATUM	Transfer date
DATIM	Transfer time

Column Name	Description
VRART	Processing Type for Advance Payment Contribution Statement	Show values

Column Name	Description	Domain name
DSN02	File name	TEXT20

Master Data Relations \| to Other Relations ↓	Join Conditions
Payroll Area	`T5D16.MANDT == T549A.MANDT` `T5D16.ABKRS == T549A.ABKRS`
Client	`T5D16.MANDT == T000.MANDT`

Other Relations \| to Master Data Relations ↑	Join Conditions
Personnel Subarea Personnel Subarea Personnel Area	`T5D16.MANDT == T001P.MANDT` `T5D16.BTRTL == T001P.BTRTL` `T5D16.WERKS == T001P.WERKS`
HI Fund Branch Office HI Fund Key for Compulsory Health Insurance Fund ? Client HI Fund Branch Office	`T5D16.KVSCH == T5D1K.KVSCH` `T5D16.[column in domain "ENDDA"] == T5D1K.ENDDA` `T5D16.MANDT == T5D1K.MANDT` `T5D16.KVGST == T5D1K.KVGES`
HI Fund Key for Compulsory Health Insurance Fund HI Fund Key for Compulsory Health Insurance Fund ?	`T5D16.MANDT == T5D11.MANDT` `T5D16.KVSCH == T5D11.KVSCH` `T5D16.[column in domain "ENDDA"] == T5D11.ENDDA`
Personnel Area	`T5D16.MANDT == T500P.MANDT` `T5D16.WERKS == T500P.PERSA`