SAP ABAP Table P05_0854_UCSR_ALV (Employee with infotype 0854 record in selected period)

Hierarchy

☛ SAP_HRCNL (Software Component) Sub component SAP_HRCNL of SAP_HR
   ⤷ PA-PA-NL (Application Component) Netherlands
     ⤷ PB05 (Package) HR Master Data: Netherlands

Basic Data

Table Category	INTTAB	Structure
Structure	P05_0854_UCSR_ALV	Table Relationship Diagram
Short Description	Employee with infotype 0854 record in selected period

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	HR Master Record for Infotype 0854
2	.INCLUDE	☐				0	0	Headers for Infotype Records
3	.INCLUDE	☐				0	0	Keys for HR Master Data
4	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
5	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
6	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
7	OBJPS	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
8	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
9	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
10	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
11	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
12	.INCLUDE	☐				0	0	HR Master Record: Control Field
13	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
14	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
15	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
16	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
17	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
18	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
19	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
20	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
21	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
24	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
25	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
26	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
27	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
28	.INCLUDE	☐				0	0	HR Master Record for Infotype 0854 (Life-Course Sav. Scheme)
29	SPASA	☐	P05_SPASA	SUBTY_591A	CHAR	4	0	Savings Scheme Type	*
30	AANS1	☐	P05_AANSP	P_AMT07V	CURR	13	2	External Rights for Life-Course Savings Scheme
31	VGAAN	☐	P05_VGAAN	XFELD	CHAR	1	0	No Rights Statement
32	VGSPA	☐	P05_VGSPA	XFELD	CHAR	1	0	No Employee Savings Amount Statement
33	BETRS	☐	P05_BETRS	P_AMT07V	CURR	13	2	Savings Amount
34	BETRR	☐	P05_BETRR	P_AMT07V	CURR	13	2	Interest Amount for Life-Course Savings Scheme
35	EMFSS	☐	EMFSL_521B	EMFSL_521B	CHAR	8	0	Payee key for bank transfers	*
36	EMFTS	☐	EMFTT	TEXT40	CHAR	40	0	Payee text
37	BKPLS	☐	BKPZL	PSTLZ	CHAR	10	0	Postal code
38	BKORS	☐	ORT03	TEXT25	CHAR	25	0	City
39	BASKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
40	BASKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
41	BASKN	☐	BANK3	BANKN	CHAR	18	0	Bank account number
42	ZLSCS	☐	SLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
43	ZWECK	☐	DZWECK	TEXT40	CHAR	40	0	Purpose of Bank Transfers
44	DOELU	☐	P05_DOELU	P05_DOELU	CHAR	1	0	Reason for Withdrawal
45	BETRU	☐	P05_BETRU	P_AMT07V	CURR	13	2	Withdrawal Amount for Life-Course Savings Scheme
46	EMFSU	☐	EMFSL_521B	EMFSL_521B	CHAR	8	0	Payee key for bank transfers	*
47	EMFTU	☐	EMFTT	TEXT40	CHAR	40	0	Payee text
48	BKPLU	☐	BKPZL	PSTLZ	CHAR	10	0	Postal code
49	BKORU	☐	ORT03	TEXT25	CHAR	25	0	City
50	BAUKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
51	BAUKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
52	BAUKN	☐	BANK3	BANKN	CHAR	18	0	Bank account number
53	ZLSCU	☐	SLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
54	AANTJ	☐	P05_AANTJ	P05_AANTJ	INT1	3	0	External No. of Calendar Years f. Life-Course Savings Scheme
55	LLVLK	☐	P05_LLVLK	P_AMT07V	CURR	13	2	Externally Cumulated Life-Course Leave Tax Credit
56	DEBIT	☐	P00_XDEBIT_INFTY	XFELD	CHAR	1	0	Automatic Debit Authorization Indicator
57	IAAN1	☐	P05_IAANS	P_AMT07V	CURR	13	2	Internal Rights for Life-Course Savings Scheme
58	ZANZL	☐	DZANZL	DEC3	DEC	3	0	Number for determining further payment dates
59	ZFPER	☐	P05_DZFPER	PABRP	NUMC	2	0	First Savings Period
60	LLRGR	☐	P05_LLRGR	P05_LLRGR	CHAR	2	0	Grouping for Employer Contrib. to Life-Course Savings Scheme	*
61	BDRWG	☐	P05_BDRWGLLR	P05_WERTV7	CURR	7	2	Employer Contribution to Life-Course Savings Scheme
62	WGBSU	☐	P05_WGBSU	XFELD	CHAR	1	0	Save or Pay Out Employer Contribution
63	LLUBB	☐	P05_LLUBB	XFELD	CHAR	1	0	Savings Amount from Special Payments
64	PCTWN	☐	P05_PCTWNLLR	ANZHL	DEC	7	2	Employee Savings Percentage for Life-Course Savings Scheme
65	PCTWG	☐	P05_PCTWGLLR	P05_PCT	DEC	7	2	Employer Contribution Pct. to Life-Course Savings Scheme
66	BETRB	☐	P05_BETRS_BB	P_AMT07V	CURR	13	2	Savings Amount for Special Payments
67	PWNBB	☐	P05_PCTWNLLR_BB	ANZHL	DEC	7	2	EE Savings Percentage over SP for Life Course Savings Scheme
68	INTBB	☐	P05_DZANZL_BB	DEC3	DEC	3	0	Interval Between Savings Periods for Special Payments
69	ESPBB	☐	P05_DZFPER_BB	PABRP	NUMC	2	0	First Savings Period for Special Payments
70	FWGBB	☐	P05_FLAG_WG_BIJDR_BB	XFELD	CHAR	1	0	Employer Contribution as Special Payment
71	SRPER	☐	P05_SRPER	PRIOD	CHAR	6	0	Update Period Retro. Correct.
72	IBANS	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
73	IBANU	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
74	NOTAX	☐	P05_NOTAX	P_AMT07V	CURR	13	2	Life Course Savings Scheme: Non-Taxable Amount
75	.INCLUDE	☐				0	0
76	ENAME	☐	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P05_0854_UCSR_ALV	BASKS	T005	LAND1
2	P05_0854_UCSR_ALV	BAUKS	T005	LAND1
3	P05_0854_UCSR_ALV	INFTY	T582A	INFTY
4	P05_0854_UCSR_ALV	PREAS	T530E	PREAS
5	P05_0854_UCSR_ALV	ZLSCS	T042Z	ZLSCH
6	P05_0854_UCSR_ALV	ZLSCU	T042Z	ZLSCH

History

Last changed by/on	SAP	20130529
SAP Release Created in	600