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

Field Description Data Type Length Decimals Checktable Data Element
PERNR Personnel Number NUMC 8 0 PERNR_D
INFTY Infotype CHAR 4 0 T582A INFTY
SUBTY Subtype CHAR 4 0 SUBTY
OBJPS Object Identification CHAR 2 0 OBJPS
SPRPS Lock Indicator for HR Master Data Record CHAR 1 0 SPRPS
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
SEQNR Number of Infotype Record With Same Key NUMC 3 0 SEQNR
AEDTM Last Changed On DATS 8 0 AEDAT
UNAME Name of Person Who Changed Object CHAR 12 0 AENAM
HISTO Historical Record Flag CHAR 1 0 HISTO
ITXEX Text Exists for Infotype CHAR 1 0 ITXEX
REFEX Reference Fields Exist (Primary/Secondary Costs) CHAR 1 0 PRFEX
ORDEX Confirmation Fields Exist CHAR 1 0 ORDEX
ITBLD Infotype Screen Control CHAR 2 0 ITBLD
PREAS Reason for Changing Master Data CHAR 2 0 T530E PREAS
FLAG1 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG2 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG3 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG4 Reserved Field/Unused Field CHAR 1 0 NUSED
RESE1 Reserved Field/Unused Field of Length 2 CHAR 2 0 NUSED2
RESE2 Reserved Field/Unused Field of Length 2 CHAR 2 0 NUSED2
GRPVL Grouping Value for Personnel Assignments CHAR 4 0 PCCE_GPVAL
DLART Loan type CHAR 4 0 T591A DLART
EXTDL External Reference Number CHAR 20 0 EXTDL
DATBW Approval date DATS 8 0 DATBW
DARBT Loan amount granted CURR 13 2 DARB1
DBTCU Currency Key CUKY 5 0 T500W WAERS
DKOND Loan conditions CHAR 2 0 * DKOND
INDIN Individual Interest Rate DEC 6 4 INDIN
TILBG Repayment start DATS 8 0 TILBG
ANRTE Annuity installment CURR 13 2 ANRTE
ANRCU Currency Key CUKY 5 0 T500W WAERS
TILBT Repayment installment CURR 13 2 TILBT
TILCU Currency Key CUKY 5 0 T500W WAERS
DLEND Expected End of Loan DATS 8 0 PCLO_DLEND
EFFIN Effective Interest Rate DEC 6 4 EFFIN
STFBI Exemption for Imputed Income CURR 9 2 STFBI
STFCU Currency Key CUKY 5 0 T500W WAERS
IND_REFIN Individual Reference Interest Rate DEC 6 4 PCLO_IND_REFIN

P0045 foreign key relationships

Table Field Check Table Check Field
0 P0045 ANRCU T500W Valid Country Currencies MANDT
0 P0045 ANRCU T500W Valid Country Currencies LAND1
0 P0045 ANRCU T500W Valid Country Currencies WAERS
1 P0045 DBTCU T500W Valid Country Currencies MANDT
1 P0045 DBTCU T500W Valid Country Currencies LAND1
1 P0045 DBTCU T500W Valid Country Currencies WAERS
0 P0045 DLART T591A Subtype Characteristics MANDT
0 P0045 DLART T591A Subtype Characteristics INFTY
0 P0045 DLART T591A Subtype Characteristics SUBTY
1 P0045 INFTY T582A Infotypes: Customer-Specific Settings MANDT
1 P0045 INFTY T582A Infotypes: Customer-Specific Settings INFTY
0 P0045 PREAS T530E Reasons for Changes MANDT
0 P0045 PREAS T530E Reasons for Changes INFTY
0 P0045 PREAS T530E Reasons for Changes PREAS
1 P0045 STFCU T500W Valid Country Currencies MANDT
1 P0045 STFCU T500W Valid Country Currencies LAND1
1 P0045 STFCU T500W Valid Country Currencies WAERS
0 P0045 TILCU T500W Valid Country Currencies MANDT
0 P0045 TILCU T500W Valid Country Currencies LAND1
0 P0045 TILCU T500W Valid Country Currencies WAERS