How to verify present data in database or not?

For example if i enter the range of values 1000 to 2000 it displays no data, I want cheak wather data is in database or not? Explain.

Interview Candidate
Oct 1st, 2007
2
2381

SAP R/3

Answer

Showing Answers 1 - 2 of 2 Answers

gunuputi_kiran
Profile Answers by gunuputi_kiran

Dec 26th, 2007

hi swapna,
This can be done by using AT SELECTION-SCREEN EVENT.

CODE:
TABLES : VBAP.
SELECT-OPTIONS : S_VBELN FOR VBAP-VBELN.
AT SELECTION-SCREEN. "FOR VALIDATIONS.
SELECT SINGLE VBELN FROM VBAP INTO VBAP-VBELN WHERE VBELN IN S_VBELN.

THE ABOVE CODE WILL SOLVE UR PROBLEM..

Regards,
Kiran Kumar.G.A
Have a Nice Day.

infoviewmohan
Profile Answers by infoviewmohan Questions by infoviewmohan

Jan 23rd, 2008

Just use select statement

like select * from kna1 into table itab where kna1 = field value of the pirticular table ie (kunnr)