Problem in reading loan balance field from Infotype 45

[Former Member]

Hi Friends,

Here I haveone requirement.

I want to read the field OPELO(loan balance) from Infotype 45(loans) for a loans report.

It is stored in a structure Q0045.

How to read thatfield value from this structure.

Can u Please respond immediately.

Thanks in advance,

[former_member304859]

Hi Nagaraju,

all the structure fields are filled in execution time therefore yo can't read the value of this field like a transparent table, because the value is not saved in any table. The value of the loan balance is stored in the payroll you needs to read the cluster payroll with the begda and endda that you want, the wagetype who has this value is /LLB.

Regards.

[abdul_hafeez4]

Try this one !

Gives you the monthly based loan deduction amount

select single abrdt into t_date1 from pa0003

where pernr eq itab-pernr.

call function 'FIMA_DAYS_AND_MONTHS_AND_YEARS'

exporting

i_date_from = pa0045-tilbg

• I_KEY_DAY_FROM =

• i_date_to = pn-endda

i_date_to = t_date1

• I_KEY_DAY_TO =

• I_FLG_SEPARATE = ' '

importing

• E_DAYS =

e_months = month

• E_YEARS =

.

do month times.

loans-balance = loans-balance + pa0045-tilbt.

enddo.

append loans.

clear loans.

clear : month.

endselect.

Regards !

Abdul Hafeez

[Former Member]

hi,

you just gothrough this code hope it will help you.

make structure with it0045 as your requirement.

make structure with ty_q0045 .

data : it_0045 type table of ty_0045 with header line.

data : it_Q0045 type table of ty_Q0045 with header line.

select f1 OPELO in to table it_0045 from pa0045 and give condn.

select f1 OPELO in to table it_Q0045 from Q0045 for all entries in it_0045

whereOPELO = it_0045-opelo

and give condn.

"From this table what data you require just retrive.

then take loop on it_0045 and pass all data from q0045 to it_0045.

loop at it_0045.

read table it_q0045 with key OPELO = it_q0045-OPELO.

if sy-subrc = 0.

move it_q0045 to it_0045.

endif.

endloop.

thanks regards..

bibek

[Former Member]

hi,

you just gothrough this code hope it will help you.

make structure with it0045 as your requirement.

make structure with ty_q0045 .

data : it_0045 type table of ty_0045 with header line.

data : it_Q0045 type table of ty_Q0045 with header line.

select f1 OPELO in to table it_0045 from pa0045 and give condn.

select f1 OPELO in to table it_Q0045 from Q0045 for all entries in it_0045

whereOPELO = it_0045-opelo

and give condn.

"From this table what data you require just retrive.

then take loop on it_0045 and pass all data from q0045 to it_0045.

loop at it_0045.

read table it_q0045 with key OPELO = it_q0045-OPELO.

if sy-subrc = 0.

move it_q0045 to it_0045.

endif.

endloop.

thanks regards..

bibek

[Former Member]

Hi,

U go for PE03 and mention there P0045 and Modify however U require. U will get Proper result

Regards

BALRAJ

[Former Member]

Hi Balraj,

Good to see immediate response.

But I am not much aware of Features .

Can u please help me with detailed steps.