topic Re: how do i get data from a structure using join? in Application Development and Automation Discussions

how do i get data from a structure using join?

Former Member — Thu, 31 Jan 2008 04:10:40 GMT

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?

Re: how do i get data from a structure using join?

former_member156446 — Thu, 31 Jan 2008 04:32:16 GMT

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

Re: how do i get data from a structure using join?

Former Member — Thu, 31 Jan 2008 05:47:37 GMT

IT IS NOT POSSIBLE TO GET THE DATA FROM STRUTURES

YOU CAN'T RETRIVE OR JOIN THE STRUTURES

STRUTURE DOES BOT HOLD THE DATA

Re: how do i get data from a structure using join?

Former Member — Thu, 31 Jan 2008 06:00:04 GMT

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

Re: how do i get data from a structure using join?

former_member156446 — Thu, 31 Jan 2008 06:02:44 GMT

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

Re: how do i get data from a structure using join?

seshatalpasai_madala — Thu, 31 Jan 2008 06:06:39 GMT

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

Re: how do i get data from a structure using join?

Former Member — Fri, 01 Feb 2008 07:03:40 GMT

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

Re: how do i get data from a structure using join?

Former Member — Mon, 11 Feb 2008 05:23:30 GMT

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.

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