how do i get data from a structure using join?

[Former Member]

hi,

what is the actual use of a structure.?

my problem is :

KUAGV is an existing STRUCTURE. it has got one fields each which links to MARA, AND VBKD tables. i want to fetch all related information from KUAGV, mara, vbkd . which is the better way : using joins or views or anything else? how do i

get data from a structure using join?

[former_member156446]

Hi Suja

you cannot join or write a select on structure...

you need to figure out where you can get that field in transparent table and need to get from there..

[Former Member]

HI

IT IS NOT POSSIBLE TO GET THE DATA FROM STRUTURES

YOU CAN'T RETRIVE OR JOIN THE STRUTURES

STRUTURE DOES BOT HOLD THE DATA

[Former Member]

ok i understood that no data retrieval is possible from structure. but tell me what is the use of a structure ?

[former_member156446]

What is the advantage of structures? How do you use them in the ABAP programs?

ANS:-

Adv:- GLOBAL EXISTANCE(these could be used by any other program without creating it again).

Award points if helpful..

[seshatalpasai_madala]

Hi,

A structure if created in DDIC(Data Dictionary) is a global DATA STRUCTURE which is used to group related information, for example you would group all the details of your bank account into a structure BANK_ACCOUNT that contains fields like account_Id, account_holder_name etc.

If you create a structure in your program then it is local to your program. So you use this structure to create data holders of this DATA TYPE to hold data in your program.

Hope its clear now.

STRUCTURE is similar to structure in any other programming language like "C".

Regards,

Sesh

[Former Member]

Hi Suja,

You cannot join or get data from structure.

if u wanna use the field in structure KUAGV then

search the transparent table in which ur fields are present.

Use of structure : Structure is just like a container it doesnt store the

data . The data come inside the structure and go it doesnt store it

Regards,

Azhar

[Former Member]

structure temporarily holds any data passed to it dynamically throughout the runtime but doesnot store it permanently. so

a structure cannot be included in a join.so instead of incuding structure KUAGV's field in a join

search the transparent table in which same field are present and use it in join.

A structure if created in DDIC(Data Dictionary) is a global DATA STRUCTURE which is used to group related information, for example you would group all the details of your bank account into a structure BANK_ACCOUNT that contains fields like account_Id, account_holder_name etc.

If you create a structure in your program then it is local to your program. So you use this structure to create data holders of this DATA TYPE to hold data in your program.

Edited by: suja thomas on Feb 11, 2008 6:24 AM

Edited by: suja thomas on Feb 11, 2008 6:31 AM