No values in table???

[MarcinPciak]

Hi,

I created screen using Graphical Screen Painter. I took a column from table SPFLI to my input field and put it into layout. However, when testing, I clicked input help key next to my input field and received message "No values found". How can I check if table contains data inside???

[Former Member]

hi,

define the field as database field ...

i.e,

TABLES : SPFLI.

<b>data: v_field like SPFLI-field.</b>

Regards,

Santosh

[anversha_s]

hi,

in pgm.

declare like this.

<b>TABLES : SPFLI.</b>

<b>data : filed_name like spfli-field_name.</b>

then pichk this field in theh layout from the program.

or

directly pick the field from the data base.

rgds

anver

if hlped pls mark points

[Former Member]

hi Marcin,

yeah, you need to declare the field as given below.

data : filed_name type spfli-field_name.

But to your question, "How can I check if table contains data inside?" , the answer is.......... Go to tansaction SE16, enter the table name (SPFLI, in this case) in the field and click F7 or press Enter..then you get the selection screen for restricting the data ..leave it as it is and press F8(Execute)...you will get the data for the entered table.

Hope this answers all your doubts.

Sajan.

Message was edited by: Sajan Joseph

[MarcinPciak]

Ok, you'are probably right, but let me explain what my problem is. I am doing an example from book "ABAP Objects" and just follow what they describe. I created screen using Graphical Screen Painter. Then I copied the input field SPLFI_CARRID from ABAP Dictionary. when testing and clicking input help key it should display possible entries as it is in example and it doesn't. I receive message "No values found". I am not sure if there are any entries in this table. Even if I add "data input type spfli-carrid" it still return this message. Sorry if my problem seems to be obvious to you.

[anversha_s]

hi,

<b>The problem is no data is available in the data base.</b>

go to se11 -> give the table name - > and check wheather data is there.

<b>it is not at all ur fault.</b>

rgds

anver

[MarcinPciak]

I cant see any data in here except defined fields, so probably they are not there. Sory

[anversha_s]

hi,

yes, data is not there.

so carry on with ur working in ABAP.

Regards,

Anver.

<b>pls mark points if ur issue solved</b>

[venkata_ramisetti]

Hi Marcin,

Looks like you have no data in the fight tables.

But don't worry about that. You can generate the demo data like how we do in SQL.

There is a standard program RSBCDAT3, it generates data for you when you run this program.

Please also check the below link.

http://searchsap.techtarget.com/tip/1,289483,sid21_gci784907,00.html

Thanks

Ramakrishna

[MarcinPciak]

Great tip, unfortunatelly I have MiniSAP and it doesn't have this program, at least it cant find it:(

Any other suggestion how to refiled these tables??

Thanks in advance

[venkata_ramisetti]

Hi Marcin,

Can you check the function module BCALV_GENERATE_TEST_DATA

available in your system?

If yes, execute it from SE37, it will generate test data for flight relavent tables.

Thanks

Ramakrishna

[MarcinPciak]

I wish I have it, but I dont:(

I found some examples from this book instead, but I cant import them. I dont know even if they constain these data.

I have two files over there

• K8A0H5B.B20 (Cofile)

• R8A0H5B.B20 (Datafile)

They say:

"These files contain the data you require to create a transport job to import the S_ABAP_BOOK

development class with example programs from the

"ABAP Objects" manual into an existing SAP system.

Copy the two files into the appropriate sub-directories in your system's central transport directory.

This is usually:

• usr\sap\trans\cofiles\K8A0H5B.B20 for the Cofile

• usr\sap\trans\data\R8A0H5B.B20 for the Datafile

Now go to the "bin" sub-directory of the central transport directory and

carry out the following steps there:

1. Insert the job into the buffer:

Statement: tp addtobuffer B20K8A0H5B <SID>

2. Test import (not absolutely necessary, but displays open repairs and

originals which would be overwritten by the import procedure):

Statement: tp tst B20K8A0H5B <SID>

3. Import job:

Statement: tp import B20K8A0H5B <SID> "

While trying to use tp to import I receive message: "..could not access file as suposed...".

[MarcinPciak]

Yupi!!!

I found that S_FLIGHT_MODEL_DATA_GENERATOR generates data for example tables. I used it and IT WORKED!!!

I appreciate your help anyway:)

regards,

Marcin

[anversha_s]

hi Marcin,

thats gr888..

keep learning ABAP and be active in SDN.

regards

Anver