Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

problem related to structures

Former Member
0 Likes
913

hi frends

I am new to ABAP. actually i am trying to write a program that reads the reservation no from an order and then for a particular reserved item it finds the "RESERVED QTY" and the "MOVING PRICE" of the material. then i multiply the these two fields to find the cost of the material reserved.

now the "RESERVATION NO " and " QUANTITY RESERVED" etc are fields under a structure name RESBD. PLz guide me how to select a particular value or a field in this strcture. Like we can use "SELECT" statement to get a particular field

e.g : select MENGE from RESBD

where RSPOS = var1.

endselect.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
845

Hi Achal,

RESBD is Structure... it doesn't contain any data...

So you have to identify the tables first where the data resides...

For your use Try RESB Table...

Also use SE11 transaction and search for where used list of Data Element and find tables...

Try like below..

Here RESB is reservation table...

SELECT MENGE 
FROM RESB
WHERE RSPOS = VAR1..

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya

5 REPLIES 5
Read only

Former Member
0 Likes
845

hi

you cant reterive the data from structure !

Only database table having the data.Structure used for holding the data in run time of the program..

Read only

abdul_hakim
Active Contributor
0 Likes
845

Hello

RESBD is a structure. So you cannot use SELECT MENGE FROM RESBD.

Cheers,

Hakim

Read only

0 Likes
845

frend, if we can not use select then how to do it. also when i place the cursor on the reservation no field and press "F1" t find the technical informatn then it displays a window where the table name is RESBD but when i used the SE11 to see the table it opens a structure. if strucutres are used to hold run time values then how to find where the reservation no and al other related values are stored

Read only

Former Member
0 Likes
845

Hi,

RESBD is a structure so you can 't read it with SELECT. But I guess that's obvious or you wouldn't have asked the question.

You need to find the table that corresponds to this structure, there are a number of techniques which you'll find if you search SDN or similar sites. A simple approach is to go to the Data Element for a field you want and do where-used, this will list the tables that contain the field.

Regards,

Nick

Read only

Former Member
0 Likes
846

Hi Achal,

RESBD is Structure... it doesn't contain any data...

So you have to identify the tables first where the data resides...

For your use Try RESB Table...

Also use SE11 transaction and search for where used list of Data Element and find tables...

Try like below..

Here RESB is reservation table...

SELECT MENGE 
FROM RESB
WHERE RSPOS = VAR1..

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya