SAP ABAP Table HRMS_BIW_PY_REC1 (BW: InfoSource for Payroll Data)

Hierarchy

☛ SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
   ⤷ PY-NO (Application Component) Norway
     ⤷ BWPY_RECON (Package) Payroll reconciliation BW extractors

Basic Data

Table Category	INTTAB	Structure
Structure	HRMS_BIW_PY_REC1	Table Relationship Diagram
Short Description	BW: InfoSource for Payroll Data

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	BIWMONTH	☐	RSCALMONTH	RSCALMONTH	NUMC	6	0	Calendar year / month
2	PERNR	☐	P_PERNR	PERNR	NUMC	8	0	Personnel Number
3	MOLGA	☐	MOLGA	MOLGA	CHAR	2	0	Country Grouping	*
4	LGART	☐	LGART	LGART	CHAR	4	0	Wage Type	T512W
5	.INCLU-_WP	☐				0	0	Time Data Extract (Fields from Infotypes 0001 and 0007)
6	ORG_UNIT_WP	☐	ORGEH	ORGEH	NUMC	8	0	Organizational Unit	*
7	JOB_WP	☐	STELL	STELL	NUMC	8	0	Job	*
8	POSITION_WP	☐	PLANS	PLANS	NUMC	8	0	Position	*
9	PERS_AREA_WP	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	*
10	PERS_SUBAREA_WP	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	*
11	EMPL_GROUP_WP	☐	PERSG	PERSG	CHAR	1	0	Employee Group	*
12	EMPL_SUBGROUP_WP	☐	PERSK	PERSK	CHAR	2	0	Employee Subgroup	*
13	CO_AREA_WP	☐	MAST_COAR	CACCD	CHAR	4	0	Controlling Area of Master Cost Center	*
14	COSTCENTER_WP	☐	MAST_CCTR	KOSTL	CHAR	10	0	Master Cost Center	*
15	COMP_CODE_WP	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
16	BUS_AREA_WP	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
17	TIME_STATUS_WP	☐	PT_ZTERF	ZTERF	NUMC	1	0	Employee Time Management Status	*
18	FM_AREA_WP	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
19	FUND_WP	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
20	FUNC_AREA_WP	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
21	GRANT_NBR_WP	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
22	ANZHL	☐	PRANZ	PRANZHL	DEC	15	2	HR payroll: Number
23	BETRG	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount
24	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
25	APZNR	☐	APZNR	PRSPL	RAW	1	0	PC205 assignment
26	CNTR1	☐	CNTRN	RAW1	RAW	1	0	National assignment indicator
27	CNTR2	☐	CNTRN	RAW1	RAW	1	0	National assignment indicator
28	CNTR3	☐	CNTRN	RAW1	RAW	1	0	National assignment indicator
29	C1ZNR	☐	C1ZNO	C1NUM	RAW	2	0	Pointer to cost accounting
30	EG_ACCDET	☐	P_MOFIX60	P_MOFIX60	CHAR	3	0	Transfer FI/CO: EE Grouping Standard Accounting FM/GM	*
31	EG_MO_FIX	☐	P_MOFIX60	P_MOFIX60	CHAR	3	0	Transfer FI/CO: EE Grouping Standard Accounting FM/GM	*
32	V0TYP	☐	V0TYP	V0TYP	CHAR	1	0	Variable assignment type
33	SEQNR	☐	CDSEQ	NUM5	NUMC	5	0	Sequence Number
34	FPPER	☐	FAPER	CHAR6	CHAR	6	0	For-period for payroll
35	INPER	☐	IPERI	CHAR6	CHAR	6	0	In-period for payroll
36	FPBEG	☐	FPBEG	DATUM	DATS	8	0	Start date of payroll period (FOR period)
37	FPEND	☐	FPEND	DATUM	DATS	8	0	End of payroll period (for-period)
38	SRTZA	☐	SRTZA	SRTZA	CHAR	1	0	Indicator: Status of record
39	ABKRS	☐	ABKRS	ABKRS	CHAR	2	0	Payroll Area	*
40	VOID	☐	VOID	XFELD	CHAR	1	0	Reversal Indicator
41	JUPER	☐	JUPER	JUPER	CHAR	4	0	Legal Person
42	PAYTY	☐	PAYTY	PAYTY	CHAR	1	0	Payroll type
43	RUNDT	☐	RUNDT	DATUM	DATS	8	0	Date of payroll run
44	PAYDT	☐	PAY_DATE	DATUM	DATS	8	0	Pay date for payroll result
45	PAYID	☐	PAYID	CHAR1	CHAR	1	0	Payroll Identifier
46	BONDT	☐	BONDT	DATUM	DATS	8	0	Off-cycle payroll payment date
47	IPERM	☐	PERMO	PERMO	NUMC	2	0	Period Parameters	*
48	OCRSN	☐	PAY_OCRSN	PAY_OCRSN	CHAR	4	0	Reason for Off-Cycle Payroll	*
49	KOKRS_C1	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
50	GSBER_C1	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
51	KOSTL_C1	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
52	BUKRS_C1	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
53	NPLNR_C1	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
54	AUFNR_C1	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
55	POSNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
56	FIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
57	FIKRS_FUND	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
58	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
59	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
60	PROZT	☐	PROZT	DEC3_2	DEC	5	2	Weighting Percentage
61	FDSEQNO	☐	SEQHX	RAW1	RAW	1	0	Sequential number
62	C0SEQNO	☐	SEQHX	RAW1	RAW	1	0	Sequential number
63	AUSART_FUND	☐	AUSART	AUSART	CHAR	4	0	Expenditure type	*
64	IPEND	☐	IPEND	DATUM	DATS	8	0	End of payroll period (IN period)
65	WP_BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
66	WP_ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HRMS_BIW_PY_REC1	LGART	T512W	LGART
2	HRMS_BIW_PY_REC1	WAERS	TCURC	WAERS

History

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