topic Re: fetch data from table and display it in Application Development and Automation Discussions

fetch data from table and display it

Former Member — Thu, 05 Oct 2006 14:12:54 GMT

hi,

I am tryin to fetch data from hrhap which has display/maintenance disallowed. Hence i need to write a program to see whether it has any data or not. I am providing the code below, but its not giving results, please give me suggestions regarding the code..

thanks in advance,

Gaurav..

data : count type i value 0.

data : Begin of itab occurs 0 ,

plan_version like hrhap-plan_version,

APPRAISAL_ID like hrhap-APPRAISAL_ID,

AP_START_DATE like hrhap-AP_START_DATE,

AP_END_DATE like hrhap-AP_END_DATE,

AP_STATUS like hrhap-AP_STATUS,

AP_STATUS_SUB like hrhap-AP_STATUS_SUB,

OBJ_DATE_SET like hrhap-OBJ_DATE_SET,

REVIEW_DATE_SET like hrhap-REVIEW_DATE_SET,

AP_DATE_SET like hrhap-AP_DATE_SET,

AP_DATE_EARLIEST like hrhap-AP_DATE_EARLIEST,

AP_DATE_LATEST like hrhap-AP_DATE_LATEST,

CHANGE_DATE like hrhap-CHANGE_DATE,

CHANGE_TIME like hrhap-CHANGE_TIME,

CHANGE_USER like hrhap-CHANGE_USER,

end of itab.

select * from hrhap into corresponding fields of itab.

endselect.

loop at itab.

write 😕 itab-plan_version under 'plan_version',

itab-appraisal_id under 'Appraisal Id',

itab-AP_START_DATE under 'Start Date',

itab-AP_END_DATE under 'End date',

itab-AP_STATUS under 'Status',

itab-AP_STATUS_SUB under 'Substatus',

itab-OBJ_DATE_SET under 'Objective setting date',

itab-REVIEW_DATE_SET under 'Review date set',

itab-AP_DATE_SET under 'appraisal date',

itab-AP_DATE_EARLIEST under 'Earliest appraisal date',

itab-AP_DATE_LATEST under 'Latest Appraisal date',

itab-CHANGE_DATE under 'Change Date',

itab-CHANGE_TIME under 'change time',

itab-CHANGE_user under 'change user'.

count = count + 1.

endloop.

write : 'No of records' ,count.

Re: fetch data from table and display it

anversha_s — Thu, 05 Oct 2006 14:15:09 GMT

hi,

data : count type i value 0.

data : Begin of itab occurs 0 ,

plan_version like hrhap-plan_version,

APPRAISAL_ID like hrhap-APPRAISAL_ID,

AP_START_DATE like hrhap-AP_START_DATE,

AP_END_DATE like hrhap-AP_END_DATE,

AP_STATUS like hrhap-AP_STATUS,

AP_STATUS_SUB like hrhap-AP_STATUS_SUB,

OBJ_DATE_SET like hrhap-OBJ_DATE_SET,

REVIEW_DATE_SET like hrhap-REVIEW_DATE_SET,

AP_DATE_SET like hrhap-AP_DATE_SET,

AP_DATE_EARLIEST like hrhap-AP_DATE_EARLIEST,

AP_DATE_LATEST like hrhap-AP_DATE_LATEST,

CHANGE_DATE like hrhap-CHANGE_DATE,

CHANGE_TIME like hrhap-CHANGE_TIME,

CHANGE_USER like hrhap-CHANGE_USER,

end of itab.

select * from hrhap into corresponding fields of table itab.

loop at itab.

write 😕 itab-plan_version under 'plan_version',

itab-appraisal_id under 'Appraisal Id',

itab-AP_START_DATE under 'Start Date',

itab-AP_END_DATE under 'End date',

itab-AP_STATUS under 'Status',

itab-AP_STATUS_SUB under 'Substatus',

itab-OBJ_DATE_SET under 'Objective setting date',

itab-REVIEW_DATE_SET under 'Review date set',

itab-AP_DATE_SET under 'appraisal date',

itab-AP_DATE_EARLIEST under 'Earliest appraisal date',

itab-AP_DATE_LATEST under 'Latest Appraisal date',

itab-CHANGE_DATE under 'Change Date',

itab-CHANGE_TIME under 'change time',

itab-CHANGE_user under 'change user'.

count = count + 1.

endloop.

write : 'No of records' ,count.

rgds

anver

if hlped mark points.

Re: fetch data from table and display it

Former Member — Thu, 05 Oct 2006 14:17:51 GMT

Hi Mehta,

Use the below code.

data : count type i value 0.

data : Begin of itab occurs 0 ,

plan_version like hrhap-plan_version,

APPRAISAL_ID like hrhap-APPRAISAL_ID,

AP_START_DATE like hrhap-AP_START_DATE,

AP_END_DATE like hrhap-AP_END_DATE,

AP_STATUS like hrhap-AP_STATUS,

AP_STATUS_SUB like hrhap-AP_STATUS_SUB,

OBJ_DATE_SET like hrhap-OBJ_DATE_SET,

REVIEW_DATE_SET like hrhap-REVIEW_DATE_SET,

AP_DATE_SET like hrhap-AP_DATE_SET,

AP_DATE_EARLIEST like hrhap-AP_DATE_EARLIEST,

AP_DATE_LATEST like hrhap-AP_DATE_LATEST,

CHANGE_DATE like hrhap-CHANGE_DATE,

CHANGE_TIME like hrhap-CHANGE_TIME,

CHANGE_USER like hrhap-CHANGE_USER,

end of itab.

select * from hrhap into corresponding fields of itab.

append itab.

clear itab.

endselect.

(OR)

select * from hrhap into corresponding fields of table itab.

loop at itab.

write 😕 itab-plan_version under 'plan_version',

itab-appraisal_id under 'Appraisal Id',

itab-AP_START_DATE under 'Start Date',

itab-AP_END_DATE under 'End date',

itab-AP_STATUS under 'Status',

itab-AP_STATUS_SUB under 'Substatus',

itab-OBJ_DATE_SET under 'Objective setting date',

itab-REVIEW_DATE_SET under 'Review date set',

itab-AP_DATE_SET under 'appraisal date',

itab-AP_DATE_EARLIEST under 'Earliest appraisal date',

itab-AP_DATE_LATEST under 'Latest Appraisal date',

itab-CHANGE_DATE under 'Change Date',

itab-CHANGE_TIME under 'change time',

itab-CHANGE_user under 'change user'.

count = count + 1.

endloop.

write : 'No of records' ,count.

Re: fetch data from table and display it

Former Member — Thu, 05 Oct 2006 14:23:21 GMT

select * from hrhap into corresponding fields of itab.

append itab.

clear itab.

endselect.

loop at itab.

write 😕 itab-plan_version under 'plan_version',

itab-appraisal_id under 'Appraisal Id',

itab-AP_START_DATE under 'Start Date',

itab-AP_END_DATE under 'End date',

itab-AP_STATUS under 'Status',

itab-AP_STATUS_SUB under 'Substatus',

itab-OBJ_DATE_SET under 'Objective setting date',

itab-REVIEW_DATE_SET under 'Review date set',

itab-AP_DATE_SET under 'appraisal date',

itab-AP_DATE_EARLIEST under 'Earliest appraisal date',

itab-AP_DATE_LATEST under 'Latest Appraisal date',

itab-CHANGE_DATE under 'Change Date',

itab-CHANGE_TIME under 'change time',

itab-CHANGE_user under 'change user'.

count = count + 1.

endloop.

write : 'No of records' ,count.

Re: fetch data from table and display it

Former Member — Thu, 05 Oct 2006 14:30:44 GMT

Hi,

select * from hrhap into corresponding fields of itab.

append itab.

clear itab.

endselect.

select * from hrhap into corresponding fields of table itab.

loop at itab.

write 😕 itab-plan_version under 'plan_version',

itab-appraisal_id under 'Appraisal Id',

itab-AP_START_DATE under 'Start Date',

itab-AP_END_DATE under 'End date',

itab-AP_STATUS under 'Status',

itab-AP_STATUS_SUB under 'Substatus',

itab-OBJ_DATE_SET under 'Objective setting date',

itab-REVIEW_DATE_SET under 'Review date set',

itab-AP_DATE_SET under 'appraisal date',

itab-AP_DATE_EARLIEST under 'Earliest appraisal date',

itab-AP_DATE_LATEST under 'Latest Appraisal date',

itab-CHANGE_DATE under 'Change Date',

itab-CHANGE_TIME under 'change time',

itab-CHANGE_user under 'change user'.

count = count + 1.

endloop.

Regards

amole

Re: fetch data from table and display it

Former Member — Thu, 05 Oct 2006 14:38:00 GMT

thanks to all of you guys who sorted me out..

gaurav

Re: fetch data from table and display it

Former Member — Mon, 01 Oct 2007 09:09:32 GMT

Hi All,

I found that if i use SQVI it is easy to display the data. It is easy to create a view to display single or combinations of tables.