problem related to structures

[Former Member]

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.

[Former Member]

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.

[Former Member]

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..

[abdul_hakim]

Hello

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

Cheers,

Hakim

[Former Member]

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

[Former Member]

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

[Former Member]

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