SAP ABAP Table P08_FPS_EXP (HR-GB: Reporting structure RTI FPS Expanded)

Hierarchy

☛

SAP_HRCGB (Software Component) Sub component SAP_HRCGB of SAP_HR
⤷

PY-GB (Application Component) United Kingdom
⤷

PC08 (Package) HR accounting: GB

Basic Data

Table Category	INTTAB	Structure
Structure	P08_FPS_EXP	Table Relationship Diagram
Short Description	HR-GB: Reporting structure RTI FPS Expanded

Delivery and Maintenance

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

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	SERIAL_NO	P08_SERIALNO	NUM8	NUMC	8	0	RTI Serial Number
2	ER_NAME	AD_NAME1_C	TEXT40	CHAR	40	0	Company name
3	ER_STRT	AD_STREET	TEXT60	CHAR	60	0	Street
4	ER_PLZ	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
5	ER_CITY	AD_CITY1	TEXT40	CHAR	40	0	City
6	ER_LAND	LANDX	TEXT15	CHAR	15	0	Country Name
7	TDREF	TDRCE	TDRCE	CHAR	10	0	Tax district indicator	*
8	TDNUM	TDNUM	TDNUM	CHAR	3	0	Tax district number	*
9	TDNME	TDNME	CHAR30	CHAR	30	0	Name of tax district
10	PRMNO	PRMNO	P08_PRMNO	CHAR	12	0	Permit number	*
11	ACCRF	ACCRF	CHAR16	CHAR	16	0	Accounts office reference
12	TAXYR	P08_TAXYR	GJAHR	NUMC	4	0	HR-GB: Tax year (for reports)
13	PERID	P08_NIID		CHAR	20	0	NI Number
14	ENAME	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant
15	TITLE	TITEL	TITEL	CHAR	15	0	Title	*
16	INITS	INITS	TEXT10	CHAR	10	0	Initials
17	NACHN	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
18	VORNA	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
19	MIDNM	PAD_MIDNM	PAD_VORNM	CHAR	40	0	Middle Name
20	LINE0	P08_ADRS1	CHAR80	CHAR	80	0	HR-GB: Legal reporting Address line 1
21	LINE1	P08_ADRS2	CHAR80	CHAR	80	0	HR-GB: Legal reporting Address line 2
22	LINE2	P08_ADRS3	CHAR80	CHAR	80	0	HR-GB: Legal reporting Address line 3
23	LINE3	P08_ADRS4	CHAR80	CHAR	80	0	HR-GB: Legal reporting Address line 4
24	PSTLZ	PSTLZ_HR	PSTLZ	CHAR	10	0	Postal Code
25	LAND	LAND1	LAND1	CHAR	3	0	Country Key	*
26	GBDAT	GBDAT	GBDAT	DATS	8	0	Date of Birth
27	GESCH	GESCH	GESCH	CHAR	1	0	Gender Key
28	PPNUM	P08_PASSPORT		CHAR	35	0	HR GB: Passport number
29	PNINO	P08_NIID		CHAR	20	0	NI Number
30	PINIT	INITS	TEXT10	CHAR	10	0	Initials
31	PNACH	P08_PNACHN	PAD_NACHN	CHAR	40	0	HR GB: Partner Last Name
32	PVORN	P08_PVORNA	PAD_VORNM	CHAR	40	0	HR GB: Partner First Name
33	PMIDN	P08_PMIDNM	PAD_VORNM	CHAR	40	0	HR GB: Partner Middle Name
34	STDAT	P08_STDAT	DATUM	DATS	8	0	HR GB: Start date of an employee
35	STDET	P08_P46CLS	P08_P46CLS	NUMC	1	0	HR GB: P46/P46(EXPAT) Class
36	STRDE	P08_STARTR	CHAR01	CHAR	1	0	Starter declaration XML
37	SLIND	P08_SLOANIND	CHAR03	CHAR	3	0	HR GB: Student Loan Indicator
38	EXPAT	P08_P46CLS	P08_P46CLS	NUMC	1	0	HR GB: P46/P46(EXPAT) Class
39	SO6MN	P08_SOM	CHAR03	CHAR	3	0	stay over 183 days
40	SL6MN	P08_SLM	CHAR03	CHAR	3	0	stay less than 183 days
41	INOUK	P08_IOUK	CHAR03	CHAR	3	0	In and Out of UK
42	EEACC	P08_EEACC	P08_EEACC	CHAR	3	0	Residence status Indicator
43	EPMSC	P08_EPMSC	P08_EPMSC	CHAR	3	0	EPM6(Modified) Scheme indicator
44	OPWID	P08_OPENSWDI	CHAR03	CHAR	3	0	Occupational Pensioner widow bereaved indicator
45	OPAMT	P08_OPAMT	PRBETRG	CURR	15	2	HR GB:Annual Amount of Occupational Pension
46	SPWID	P08_PENSWDI	FINAL	CHAR	3	0	State Pensioner widow bereaved indicator
47	SPAMT	P08_SPAMT	PRBETRG	CURR	15	2	HR GB: Annual Amount of State Pension
48	PAYID	P08_WRKSN_ENHANCED	CHAR10	CHAR	10	0	HR GB: HMRC Works Number
49	PYIND	P08_PAYCHIND	CHAR03	CHAR	3	0	HR GB: Payroll ID Change Indiator
50	OPAYID	P08_OPERSNO_ENHANCED	CHAR10	CHAR	10	0	HR GB: Old Payroll Id
51	IREMP	P08_IREMP	P08_IREMP	CHAR	3	0	Irregular Payments Indicator
52	ENDDT	P08_ENDAT	DATUM	DATS	8	0	HR GB: Leaving date of an employee
53	TPYEM	P08_TPYEM	PRBETRG	CURR	15	2	Taxable pay to date in this employment
54	TXPEM	P08_TXPEM	PRBETRG	CURR	15	2	Total tax to date in this employment
55	SLRPE	P08_SLRPE	PRBETRG	CURR	15	2	Student loan repayment
56	BHASH	P08_BHASH		CHAR	64	0	HR GB: Bacs Hash for RTI
57	PYFREQ	P08_PYFREQ	P08_PYFREQ	CHAR	2	0	HR GB: RTI Pay Frequency
58	PMTDAT	P08_PMTDATE	DATUM	DATS	8	0	HR GB: Payment Date
59	PMTMN	P08_PMTMN	P08_PMTMN	CHAR	2	0	HR GB: Payment Month Number
60	PMTWK	P08_PMTWK	P08_PMTWK	CHAR	2	0	HR GB: Payment Week Number
61	ERPER	P08_ERPER	CHAR6	CHAR	6	0	Number of Earnings Periods Covered by Payment
62	AERIND	P08_AGPIND	CHAR03	CHAR	3	0	HR GB: Aggregated payment indicator
63	LTPYI	P08_LTPYI	P08_LTPYI	CHAR	3	0	Late payment after notification Indicator
64	NHWKD	P08_NHWKD	P08_NHWKD	CHAR	20	0	HR GB: RTI Number of hours worked
65	TXCOD	P08_TXCODE	CHAR8	CHAR	8	0	Tax Code
66	SCVRI	P08_SVRI	XFELD	CHAR	1	0	Scottish Variable Rate Indicator
67	W1M1	P08_WMBASIS	FINAL	CHAR	3	0	HR GB: tax week1 Month1 indicator
68	TPYPE	P08_TPYPE	PRBETRG	CURR	15	2	Taxable pay in this pay period
69	PYTXN	P08_PYTXN	PRBETRG	CURR	15	2	Payments not subject to tax or NICs
70	DEDPP	P08_DEDPP	PRBETRG	CURR	15	2	Deductions from net pay
71	PADED	P08_PADED	PRBETRG	CURR	15	2	Pay after statutory deductions
72	BNTXP	P08_BNTXP	PRBETRG	CURR	15	2	Benefits taxed via the payroll
73	BNNIP	P08_BNNIP	PRBETRG	CURR	15	2	Amount of the benefits subject to Class 1 NIC
74	BNNNI	P08_BNNNI	PRBETRG	CURR	15	2	Amount of the benefits not subject to Class 1 NIC
75	EPCP	P08_EPCP	PRBETRG	CURR	15	2	employee pension contributions
76	ISCNI	P08_ISCNI	PRBETRG	CURR	15	2	Items subject to Class 1 NIC not taxed excluding pension
77	EPCNP	P08_EPCNP	PRBETRG	CURR	15	2	Employee pension contributions that are not paid
78	SLRPP	P08_SLRPP	PRBETRG	CURR	15	2	Student Loan repayment in this pay period
79	TXDRP	P08_TXDRP	PRBETRG	CURR	15	2	Tax deducted or refunded from this payment
80	SSPYD	P08_SSPY	PRBETRG	CURR	15	2	Statutory Sick Pay (SSP) year to date
81	SMPYD	P08_SMPY	PRBETRG	CURR	15	2	Statutory Maternity pay (SMP) year to date
82	OSSPY	P08_OSSPY	PRBETRG	CURR	15	2	Ordinary Statutory Paternity pay (SPP) year to date
83	SAPYD	P08_SAPY	PRBETRG	CURR	15	2	Statutory Adoption pay (SAP) year to date
84	ASPPY	P08_ASPPY	PRBETRG	CURR	15	2	Additional Statutory Paternity pay (ASPP) year to date
85	DIRFB	P08_DNIC	P08_DNIC	CHAR	2	0	HR GB: RTI Director's NIC calculation method
86	DIRAP	DIRAP	NUM2	NUMC	2	0	Director appointment Week/Month
87	DAPWM	P08_W1M1	CHAR01	CHAR	1	0	HR-GB: MM2 Week (or month) 1 indicator
88	BNTXY	P08_BNTXY	PRBETRG	CURR	15	2	Value of benefits taxed via payroll year to date
89	EPCNY	P08_EPCNY	PRBETRG	CURR	15	2	Pension paid NOT under Net pay arranement year to date
90	EPCPY	P08_EPCPY	PRBETRG	CURR	15	2	Value of pension paid under Net pay arrangement YTD
91	UAIND	P08_UAIND		CHAR	3	0	Indicator that an individual has been on an unpaid absence
92	ONSTR	P08_STRIKE	CHAR03	CHAR	3	0	On strike indicator
93	PYTNI	P08_PYTNI		CHAR	3	0	Payment to non individual
94	TCOPY	P08_TCOPY	PRBETRG	CURR	15	2	Trivial commutation payment
95	TCOPT	P08_TCOPT		CHAR	1	0	Trivial commutation payment type
96	ECON	ECONR	CHAR9	CHAR	9	0	Employer contracted out number (ECON)
97	PENID	P08_PENID	CHAR01	CHAR	1	0	HR-GB: MM2 Pension indicator
98	WRKSN	PERSNO	PERSNO	NUMC	8	0	Personnel number	*
99	NICAT	NICAT	NICAT	CHAR	2	0	NI category (GB)	*
100	NIPAY	P08_TNIPAY	PRBETRG	CURR	15	2	HR GB: Nipay this period
101	CTOUT	P08_CTOUT	XFELD	CHAR	1	0	Contracted Out Flag
102	PSCON	P08_SCON	CHAR9	CHAR	9	0	Pension scheme contracted out number
103	AMTTOLEL	P08_TOLEL	PRBETRG	CURR	15	2	Niable pay up to LEL
104	AMTLELERT	P08_LELERT	PRBETRG	CURR	15	2	Cumulated Niable pay to LEL to PT
105	AMTERTUAP	P08_TOUAP	PRBETRG	CURR	15	2	Niable pay between PT and UAP
106	AMTFROMUEL	P08_TOUEL	PRBETRG	CURR	15	2	Niable pay between UAP and UEL
107	EENIC	P08_EE_NIC_TP	PRBETRG	CURR	15	2	HR GB: Employees contributions this pay period
108	EENIC_YTD	P08_EE_NIC_YTD	PRBETRG	CURR	15	2	HR GB: Employees contributions year to date
109	ERNIC	P08_ER_NIC_TP	PRBETRG	CURR	15	2	HR GB: Total of employer NI Contributions in this period
110	ERNIC_YTD	P08_ER_NIC_YTD	PRBETRG	CURR	15	2	HR GB: Total of employer NI contributions year to date
111	NIPY_YTD	P08_NIPAY_YTD	PRBETRG	CURR	15	2	HR GB: Niable pay Year to date