SAP ABAP Table P0045 (HR Master Record: Infotype 0045 (Company Loans))

Hierarchy

☛ SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
   ⤷ PY-XX (Application Component) Payroll: General Parts
     ⤷ PCLO (Package) HR-PY: International Loan Functions

Basic Data

Table Category	INTTAB	Structure
Structure	P0045	Table Relationship Diagram
Short Description	HR Master Record: Infotype 0045 (Company Loans)

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	Headers for Infotype Records
2	.INCLUDE	☐				0	0	Keys for HR Master Data
3	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
4	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
5	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
6	OBJPS	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
7	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
8	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
9	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
10	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
11	.INCLUDE	☐				0	0	HR Master Record: Control Field
12	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
13	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
14	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
15	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
16	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
17	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
18	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
19	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
20	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
24	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
25	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
26	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
27	.INCLUDE	☐				0	0	HR Master Record: Infotype 0045 (Company Loans)
28	DLART	☐	DLART	SUBTY_591A	CHAR	4	0	Loan type	T591A
29	EXTDL	☐	EXTDL	CHAR20	CHAR	20	0	External Reference Number
30	DATBW	☐	DATBW	DATUM	DATS	8	0	Approval date
31	DARBT	☐	DARB1	P_AMT07	CURR	13	2	Loan amount granted
32	DBTCU	☐	WAERS	WAERS	CUKY	5	0	Currency Key	T500W
33	DKOND	☐	DKOND	DKOND	CHAR	2	0	Loan conditions	*
34	INDIN	☐	INDIN	DEC2_4	DEC	6	4	Individual Interest Rate
35	TILBG	☐	TILBG	DATUM	DATS	8	0	Repayment start
36	ANRTE	☐	ANRTE	P_AMT07	CURR	13	2	Annuity installment
37	ANRCU	☐	WAERS	WAERS	CUKY	5	0	Currency Key	T500W
38	TILBT	☐	TILBT	P_AMT07	CURR	13	2	Repayment installment
39	TILCU	☐	WAERS	WAERS	CUKY	5	0	Currency Key	T500W
40	DLEND	☐	PCLO_DLEND	DATUM	DATS	8	0	Expected End of Loan
41	EFFIN	☐	EFFIN	DEC2_4	DEC	6	4	Effective Interest Rate
42	.INCLUDE	☐				0	0	historical fields for IT0045 --- do not change
43	STFBI	☐	STFBI	WERT05	CURR	9	2	Exemption for Imputed Income
44	STFCU	☐	WAERS	WAERS	CUKY	5	0	Currency Key	T500W
45	IND_REFIN	☐	PCLO_IND_REFIN	DEC2_4	DEC	6	4	Individual Reference Interest Rate
46	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P0045	ANRCU	T500W	WAERS
2	P0045	DBTCU	T500W	WAERS
3	P0045	DLART	T591A	SUBTY	KEY	1	CN
4	P0045	INFTY	T582A	INFTY
5	P0045	PREAS	T530E	PREAS
6	P0045	STFCU	T500W	WAERS
7	P0045	TILCU	T500W	WAERS

History

Last changed by/on	SAP	20080626
SAP Release Created in