topic Re: report in Application Development and Automation Discussions

report

MohitSingh — Thu, 12 Jul 2007 09:54:56 GMT

iam new to abap.In this report i have to calculate no of days employed for an employee i.e sy-date - joining-date, but its giving wrong o/p.please review my code give the correct solution.

REPORT ypr_mohitsingh_ex02 .

TABLES ytmohit_01.

data:itab type standard table of ytmohit_01.

data:wa type ytmohit_01,days.

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.

SELECT-OPTIONS: s_emplid FOR ytmohit_01-emp_id.

SELECTION-SCREEN END OF BLOCK b1.

start-of-selection.

SELECT * FROM ytmohit_01 into wa WHERE emp_id in s_emplid.

append wa to itab.

endselect.

loop at itab into wa.

days = sy-datum - ytmohit_01-joindate.

write:/ wa-fname ,wa-lname ,wa-occu ,wa-joindate ,days.

endloop.

Re: report

Former Member — Thu, 12 Jul 2007 09:57:30 GMT

Hi,

Change the code as follows,

loop at itab into wa.

days = sy-datum - wa-joindate.

write:/ wa-fname ,wa-lname ,wa-occu ,wa-joindate ,days.

endloop.

Reward if helpful.

Re: report

Former Member — Thu, 12 Jul 2007 09:57:34 GMT

Change as highlighted:

loop at itab into wa.

days = sy-datum - wa-joindate.

write:/ wa-fname ,wa-lname ,wa-occu ,wa-joindate ,days.

endloop.

Re: report

Former Member — Thu, 12 Jul 2007 09:58:00 GMT

Hello,

Change the code like this.


loop at itab into wa.
days = sy-datum - wa-joindate." Check here
write:/ wa-fname ,wa-lname ,wa-occu ,wa-joindate ,days.
endloop.

Vasanth

Re: report

Former Member — Thu, 12 Jul 2007 09:58:11 GMT

data:itab type standard table of ytmohit_01.

data:wa type ytmohit_01,days type i.

regards

shiba dutta

Re: report

Former Member — Thu, 12 Jul 2007 09:59:27 GMT

hi,

changes as

loop at itab into wa.

days = sy-datum - wa-joindate.

write:/ wa-fname ,wa-lname ,wa-occu ,wa-joindate ,days.

endloop.

Re: report

sharadendu_agrawal — Thu, 12 Jul 2007 09:59:27 GMT

Instead of subtracting the joining date fron sy-datum try to use a FM that gives the difference between two given dates. Hope it solves the problem.

Reward if useful.

Cheers

Sharadendu

Re: report

Former Member — Thu, 12 Jul 2007 10:18:28 GMT

Hi,

Try replacing the code.The changes made are,

1. Define a data type for variable 'days'.

2You have to subtract the sy-datum with wa-joindate and not from the table.

REPORT ypr_mohitsingh_ex02 .

TABLES ytmohit_01.

data:itab type standard table of ytmohit_01.

data:wa type ytmohit_01,days type i .

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.

SELECT-OPTIONS: s_emplid FOR ytmohit_01-emp_id.

SELECTION-SCREEN END OF BLOCK b1.

start-of-selection.

SELECT * FROM ytmohit_01 into wa WHERE emp_id in s_emplid.

append wa to itab.

endselect.

loop at itab into wa.

days = sy-datum - wa-joindate.

write:/ wa-fname ,wa-lname ,wa-occu ,wa-joindate ,days.

endloop.

Reward points if it was useful.

Regards,

Hema.