SAP ABAP Table P01W_DBEK (Data Module: Statement of Earnings for Sick Child)

Hierarchy

☛ SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
   ⤷ PY-XX-RS (Application Component) Reuse Services for Country Development
     ⤷ P01W (Package) HR Germany: Statements

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	P01W_DBEK	Table Relationship Diagram
Short Description	Data Module: Statement of Earnings for Sick Child

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	.INCLUDE	☑				0	0	Key Fields for Data Records
3	PERNR	☑	P01W_PERNR	PERSNO	NUMC	8	0	Personnel Number	*
4	MSGID	☑	P01W_MSGID	PCAL_MSGID	NUMC	4	0	HR: Notification Type
5	DATUM	☑	P01W_DATUM	DATS	DATS	8	0	Key Date
6	MNR	☑	P01W_MNR	NUMC04	NUMC	4	0	Message Number
7	.INCLUDE	☐				0	0	Data Module: Statement of Earnings for Sick Child
8	KENNG	☐	P01W_KENNG	TEXT04	CHAR	4	0	Identification
9	KNZST	☐	P01W_KNZST	TEXT1	CHAR	1	0	Reversal Indicator
10	WAERS	☐	P01W_WAERS_D	TEXT3	CHAR	3	0	Currency
11	NAMEK	☐	P01W_NAMEK	TEXT30	CHAR	30	0	Last Name of Child
12	VNAMK	☐	P01W_VNAMK	TEXT30	CHAR	30	0	Child's First Name
13	GBDAT	☐	P01W_GBDAT	NUMC08	NUMC	8	0	Child's Date of Birth
14	FLEDT	☐	P01W_FLEDT	NUMC08	NUMC	8	0	Participation in Working Time Model Since/From
15	KISTA	☐	P01W_KISTA	TEXT1	CHAR	1	0	Church Tax
16	STRKL	☐	P01W_STRKL	NUMC01	NUMC	1	0	Employment Tax Class
17	FRB1M	☐	P01W_FRB1M	NUMC08	NUMC	8	0	Monthly Tax-Free Amount
18	FRBDT	☐	P01W_FRBDT	NUMC08	NUMC	8	0	Tax-Free Amount From
19	LADAY	☐	P01W_LADAY	NUMC08	NUMC	8	0	Last Working Day
20	FIDAY	☐	P01W_FIDAY	NUMC08	NUMC	8	0	Return to Work
21	NET1D	☐	P01W_NET1D	NUMC08	NUMC	8	0	Net Remuneration on First Day of Release from Work
22	KUWAG	☐	P01W_KUWAG	NUMC01	NUMC	1	0	RHC/WC
23	WVLDT	☐	P01W_WVLDT_D	NUMC08	NUMC	8	0	Winter Compensation Advance Benefit Since
24	WALAZ	☐	P01W_WALAZ_D	CHAR01	CHAR	1	0	WC Advance Payment in (Last) Remuneration Period
25	STWAG	☐	P01W_STWAG_D	NUMC05	NUMC	5	0	No. of Hours for Which Winter Compensation Advance Was Paid
26	LFZED	☐	P01W_LFZED	NUMC08	NUMC	8	0	Contd Pay During WI/Rehab. Benefit or Release from Work To
27	VWBIS	☐	P01W_VWBIS_D	NUMC08	NUMC	8	0	Capital Formation Savings Payments To
28	VWBET	☐	P01W_VWBET_D	NUMC08	NUMC	8	0	Capital Formation Savings Payment
29	VWRHT	☐	P01W_VWRHT_D	NUMC01	NUMC	1	0	Payment Type for Capital Formation Savings Payments
30	ZSBTG	☐	P01W_ZSBTG_D	NUMC08	NUMC	8	0	Amount of Payments in Kind
31	KDGAM	☐	P01W_KDGAM_D	NUMC08	NUMC	8	0	Dissolution of Work Relationship on
32	KDZUM	☐	P01W_KDZUM_D	NUMC08	NUMC	8	0	Dissolution of Work Relationship on
33	KDGRD	☐	P01W_KDGRD	TEXT30	CHAR	30	0	Termination Reason
34	LRBEG	☐	P01W_LRBEG	NUMC08	NUMC	8	0	Last Remuneration Period in Payroll Run: Start
35	LREND	☐	P01W_LREND	NUMC08	NUMC	8	0	Last Remuneration Period in Payroll Run: End
36	LRBRT	☐	P01W_LRBRT	NUMC08	NUMC	8	0	Gross Remuneration
37	LRNET	☐	P01W_LRNET	NUMC08	NUMC	8	0	Net Remuneration
38	ABART	☐	P01W_ABART	CHAR01	CHAR	1	0	Fixed Monthly Salary/Monthly Remuneration
39	VRBRT	☐	P01W_VRBRT	NUMC08	NUMC	8	0	Agreed Gross Remuneration
40	VRNET	☐	P01W_VRNET	NUMC08	NUMC	8	0	Agreed Net Remuneration
41	UBEG1	☐	P01W_UNBEG	NUMC08	NUMC	8	0	Gross Remuneration Differs from Regular: Period Start
42	UEND1	☐	P01W_UNEND	NUMC08	NUMC	8	0	Gross Remuneration Differs from Regular: Period End
43	UBRT1	☐	P01W_UNBRT	NUMC08	NUMC	8	0	Gross Remuneration Differs from Regular: Gross Remuneration
44	UNET1	☐	P01W_UNNET	NUMC08	NUMC	8	0	Gross Remuneration Differs from Regular: Net Remuneration
45	UBEG2	☐	P01W_UNBEG	NUMC08	NUMC	8	0	Gross Remuneration Differs from Regular: Period Start
46	UEND2	☐	P01W_UNEND	NUMC08	NUMC	8	0	Gross Remuneration Differs from Regular: Period End
47	UBRT2	☐	P01W_UNBRT	NUMC08	NUMC	8	0	Gross Remuneration Differs from Regular: Gross Remuneration
48	UNET2	☐	P01W_UNNET	NUMC08	NUMC	8	0	Gross Remuneration Differs from Regular: Net Remuneration
49	UBEG3	☐	P01W_UNBEG	NUMC08	NUMC	8	0	Gross Remuneration Differs from Regular: Period Start
50	UEND3	☐	P01W_UNEND	NUMC08	NUMC	8	0	Gross Remuneration Differs from Regular: Period End
51	UBRT3	☐	P01W_UNBRT	NUMC08	NUMC	8	0	Gross Remuneration Differs from Regular: Gross Remuneration
52	UNET3	☐	P01W_UNNET	NUMC08	NUMC	8	0	Gross Remuneration Differs from Regular: Net Remuneration
53	XBEG1	☐	P01W_XXBEG	NUMC08	NUMC	8	0	Irregular Remuneration: Start of Period
54	XEND1	☐	P01W_XXEND	NUMC08	NUMC	8	0	Irregular Remuneration: End of Period
55	XBRT1	☐	P01W_XXBRT	NUMC08	NUMC	8	0	Irregular Remuneration: Gross Remuneration
56	XNET1	☐	P01W_XXNET	NUMC08	NUMC	8	0	Irregular Remuneration: Net Remuneration
57	XBEG2	☐	P01W_XXBEG	NUMC08	NUMC	8	0	Irregular Remuneration: Start of Period
58	XEND2	☐	P01W_XXEND	NUMC08	NUMC	8	0	Irregular Remuneration: End of Period
59	XBRT2	☐	P01W_XXBRT	NUMC08	NUMC	8	0	Irregular Remuneration: Gross Remuneration
60	XNET2	☐	P01W_XXNET	NUMC08	NUMC	8	0	Irregular Remuneration: Net Remuneration
61	XBEG3	☐	P01W_XXBEG	NUMC08	NUMC	8	0	Irregular Remuneration: Start of Period
62	XEND3	☐	P01W_XXEND	NUMC08	NUMC	8	0	Irregular Remuneration: End of Period
63	XBRT3	☐	P01W_XXBRT	NUMC08	NUMC	8	0	Irregular Remuneration: Gross Remuneration
64	XNET3	☐	P01W_XXNET	NUMC08	NUMC	8	0	Irregular Remuneration: Net Remuneration
65	EINKV	☐	P01W_EINKV	NUMC08	NUMC	8	0	Non-Recurring Payments Liable to Contributions in HI
66	EINRV	☐	P01W_EINRV	NUMC08	NUMC	8	0	Non-Recurring Payments Liable to Contributions in PI
67	BRTAE	☐	P01W_BRTAE_D	NUMC01	NUMC	1	0	Gross Remuneration Was Paid For
68	BRTTG	☐	P01W_BRTTG	NUMC02	NUMC	2	0	Number of Days for Which Gross Remuneration Is Paid
69	YBEG1	☐	P01W_XXBEG	NUMC08	NUMC	8	0	Irregular Remuneration: Start of Period
70	YEND1	☐	P01W_XXEND	NUMC08	NUMC	8	0	Irregular Remuneration: End of Period
71	YTAG1	☐	P01W_YYTAG	NUMC02	NUMC	2	0	Number of Working Days in Month
72	YBEG2	☐	P01W_XXBEG	NUMC08	NUMC	8	0	Irregular Remuneration: Start of Period
73	YEND2	☐	P01W_XXEND	NUMC08	NUMC	8	0	Irregular Remuneration: End of Period
74	YTAG2	☐	P01W_YYTAG	NUMC02	NUMC	2	0	Number of Working Days in Month
75	YBEG3	☐	P01W_XXBEG	NUMC08	NUMC	8	0	Irregular Remuneration: Start of Period
76	YEND3	☐	P01W_XXEND	NUMC08	NUMC	8	0	Irregular Remuneration: End of Period
77	YTAG3	☐	P01W_YYTAG	NUMC02	NUMC	2	0	Number of Working Days in Month
78	KRZAE	☐	P01W_KRZAE	NUMC01	NUMC	1	0	Reduction of Remuneration During Release form Work
79	KRZTG	☐	P01W_KRZTG	NUMC02	NUMC	2	0	Number of Days By Which Remuneration Is Reduced
80	FBEG1	☐	P01W_FLBEG	NUMC08	NUMC	8	0	Absence Times Without Remuneration: Start of Period
81	FEND1	☐	P01W_FLEND	NUMC08	NUMC	8	0	Absence Times Without Remuneration: End of Period
82	FTAG1	☐	P01W_FLTAG	NUMC02	NUMC	2	0	Absence Times Without Remuneration: No. of Days
83	FBEG2	☐	P01W_FLBEG	NUMC08	NUMC	8	0	Absence Times Without Remuneration: Start of Period
84	FEND2	☐	P01W_FLEND	NUMC08	NUMC	8	0	Absence Times Without Remuneration: End of Period
85	FTAG2	☐	P01W_FLTAG	NUMC02	NUMC	2	0	Absence Times Without Remuneration: No. of Days
86	FBEG3	☐	P01W_FLBEG	NUMC08	NUMC	8	0	Absence Times Without Remuneration: Start of Period
87	FEND3	☐	P01W_FLEND	NUMC08	NUMC	8	0	Absence Times Without Remuneration: End of Period
88	FTAG3	☐	P01W_FLTAG	NUMC02	NUMC	2	0	Absence Times Without Remuneration: No. of Days
89	FTG01	☐	P01W_FSTAG	NUMC08	NUMC	8	0	Release Day
90	FTG02	☐	P01W_FSTAG	NUMC08	NUMC	8	0	Release Day
91	FTG03	☐	P01W_FSTAG	NUMC08	NUMC	8	0	Release Day
92	FTG04	☐	P01W_FSTAG	NUMC08	NUMC	8	0	Release Day
93	FTG05	☐	P01W_FSTAG	NUMC08	NUMC	8	0	Release Day
94	FTG06	☐	P01W_FSTAG	NUMC08	NUMC	8	0	Release Day
95	FTG07	☐	P01W_FSTAG	NUMC08	NUMC	8	0	Release Day
96	FTG08	☐	P01W_FSTAG	NUMC08	NUMC	8	0	Release Day
97	FTG09	☐	P01W_FSTAG	NUMC08	NUMC	8	0	Release Day
98	FTG10	☐	P01W_FSTAG	NUMC08	NUMC	8	0	Release Day
99	FTG11	☐	P01W_FSTAG	NUMC08	NUMC	8	0	Release Day
100	FTG12	☐	P01W_FSTAG	NUMC08	NUMC	8	0	Release Day
101	FTG13	☐	P01W_FSTAG	NUMC08	NUMC	8	0	Release Day
102	FTG14	☐	P01W_FSTAG	NUMC08	NUMC	8	0	Release Day
103	FTG15	☐	P01W_FSTAG	NUMC08	NUMC	8	0	Release Day
104	FTG16	☐	P01W_FSTAG	NUMC08	NUMC	8	0	Release Day
105	FTG17	☐	P01W_FSTAG	NUMC08	NUMC	8	0	Release Day
106	FTG18	☐	P01W_FSTAG	NUMC08	NUMC	8	0	Release Day
107	FTG19	☐	P01W_FSTAG	NUMC08	NUMC	8	0	Release Day
108	FTG20	☐	P01W_FSTAG	NUMC08	NUMC	8	0	Release Day
109	KBEG1	☐	P01W_KIBEG	NUMC08	NUMC	8	0	Release from Work Due to Illness of Same Child: Period Start
110	KEND1	☐	P01W_KIEND	NUMC08	NUMC	8	0	Release from Work Due to Illness of Same Child: Period End
111	KTAG1	☐	P01W_KITAG	NUMC02	NUMC	2	0	Release from Work Due to Illness of Same Child: No. of Days
112	KBEG2	☐	P01W_KIBEG	NUMC08	NUMC	8	0	Release from Work Due to Illness of Same Child: Period Start
113	KEND2	☐	P01W_KIEND	NUMC08	NUMC	8	0	Release from Work Due to Illness of Same Child: Period End
114	KTAG2	☐	P01W_KITAG	NUMC02	NUMC	2	0	Release from Work Due to Illness of Same Child: No. of Days
115	ANGRD	☐	P01W_ANGRD_D	NUMC01	NUMC	1	0	No Entitlement to Paid Release from Work Due To
116	ANFRT	☐	P01W_ANFRT_D	NUMC02	NUMC	2	0	Entitlement to Paid Release from Work Limited To
117	UFTAG	☐	P01W_UFTAG	NUMC08	NUMC	8	0	Accident Date
118	LSTFZ	☐	P01W_LSTFZ	NUMC08	NUMC	8	0	Employment Tax-Free Bonuses in Last Remuneration Payt Period
119	LSTB1	☐	P01W_LSTBG	NUMC08	NUMC	8	0	Bonuses Exempt from Employment Tax: Start of Period
120	LSTE1	☐	P01W_LSTED	NUMC08	NUMC	8	0	Bonuses Exempt from Employment Tax: End of Period
121	LSTZ1	☐	P01W_LSTZU	NUMC08	NUMC	8	0	Pymt Exempt fr. Empl. Tax
122	LSTB2	☐	P01W_LSTBG	NUMC08	NUMC	8	0	Bonuses Exempt from Employment Tax: Start of Period
123	LSTE2	☐	P01W_LSTED	NUMC08	NUMC	8	0	Bonuses Exempt from Employment Tax: End of Period
124	LSTZ2	☐	P01W_LSTZU	NUMC08	NUMC	8	0	Pymt Exempt fr. Empl. Tax
125	LSTB3	☐	P01W_LSTBG	NUMC08	NUMC	8	0	Bonuses Exempt from Employment Tax: Start of Period
126	LSTE3	☐	P01W_LSTED	NUMC08	NUMC	8	0	Bonuses Exempt from Employment Tax: End of Period
127	LSTZ3	☐	P01W_LSTZU	NUMC08	NUMC	8	0	Pymt Exempt fr. Empl. Tax
128	SBKNA	☐	P01W_SBKNA	NUMC8	NUMC	8	0	Special Feature / Federal Miners' Insurance
129	AVMGG	☐	P01W_AVMGG	NUMC08	NUMC	8	0	Remuneration Converted to Be Exempt from Contributions

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P01W_DBEK	MANDT	T000	MANDT

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C