fetch data from table and display it

[Former Member]

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.

[anversha_s]

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.

<b>select * from hrhap into corresponding fields of table itab.</b>

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.

[Former Member]

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.

<b>select * from hrhap into corresponding fields of itab.

append itab.

clear itab.

endselect.</b>

<u>(OR)</u>

<b>select * from hrhap into corresponding fields of table itab.</b>

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.

<u></u>

[Former Member]

select * from hrhap into corresponding fields of itab.

<b>append itab.

clear itab.</b>

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.

[Former Member]

Hi,

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.

Regards

amole

[Former Member]

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

gaurav

[Former Member]

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.