Ours is an Indian-PSU.
Housing loan is recovery from employee, the entire principal amount is recovered through salary installments. The interest will be recovered in installments once the principal amount is recovered fully.
Kindly advise SAP has any standard solution to address this requirement.
Create PCR loan interest amount go to another Custom wage type( Which is not effective deductions and payments) and cumulate unlimited and take report from CRT table (Custom report only), after completion loan payment again maintain Loan with zero interest based on CRT report value/maintain in IT2014 with end date in equal installments in different wage type with deduction priorities.
Mr XYZ taken loan type "H100" with Rs.100000 then every month loan recovery Rs.1000 and Loan interest will different each month. In sap /LRP for loan installment, /LID for Interest Due. then PCR logic is below.
vakeylntyp (loan type)
H100 (Assume housing loan type)
addwtr9100 (9100 is custom wage type which is not effecting deduction and payments means no maintenance cumulation class 1, 10)
Note: Insert this in loan accounting with P0045 function