topic Re: Table Structure in Application Development and Automation Discussions

Table Structure

Former Member — Mon, 19 Jun 2006 03:10:26 GMT

I'm little confused on how table structure works. But how can I fetch a dat from the table structure AFVGD?

Re: Table Structure

suresh_datti — Mon, 19 Jun 2006 03:12:05 GMT

A structure can be used to hold data only during the runtime of aprogram. you cannot fetch data as it is not a table.

~Suresh

Re: Table Structure

abdul_hakim — Mon, 19 Jun 2006 03:17:48 GMT

hi jose,

you cannot fetch data from structure instead it is used to hold data at runtime.

for eg.

tables mara."defining structure or interface workarea..

parameters p_matnr like mara-matnr.

select single * from mara where matnr = p_matnr.

**the above select query fetches the data from the table MARA and place it in the structure MARA iteself.

Cheers,

Abdul Hakim

Re: Table Structure

Former Member — Mon, 19 Jun 2006 03:18:48 GMT

hi ,

Use Pattern button in ur program,Check Structured data obj -> fields from structure. Select the fields u want.Enter the name

It will create a structe with the needed fields..

DATA: BEGIN OF i_sub occurs 0 ,

mandt TYPE afvgd-mandt,

aufpl TYPE afvgd-aufpl,

END OF i_sub.

Add occurs 0. Now your Internal table is ready.

Rgds,

Jothi.

Re: Table Structure

Former Member — Mon, 19 Jun 2006 03:25:20 GMT

Hi Adrian,

Structure cannot hold data as structure is just used for data definition purpose.

You can store data in an internal table declared like a structure but not in structure directly.

Cheers,

Vikram

Re: Table Structure

Former Member — Mon, 19 Jun 2006 03:46:54 GMT

But how can I retrieve the data from the structure AFVGD? That's my problem for now.

Re: Table Structure

Former Member — Mon, 19 Jun 2006 03:52:42 GMT

Looks like you are dealing with a user exit / function which has a paramter of the type AFVGD. Is my assumption, right?

If yes, the structure will have data when the function / exit is being executed.

Else, you need to find the concerned table and get the data. If you are looking for work order data look at AFKO, AFVC tables or VIAUFKST view.

Regards,

Ravi

Note : Please mark the helpful answers

Re: Table Structure

abdul_hakim — Mon, 19 Jun 2006 03:53:02 GMT

hi jose,

again you cant retrive data from structure you can only retrieve it from the table...

Re: Table Structure

Former Member — Mon, 19 Jun 2006 03:54:27 GMT

Hi Adrian,

If your structure have a value, then fetch the data using <stucture Name>-<Field name>.

In ur case,

AFVGD-<Field name>

write: / AFVGD-<Field name>.

- Selvapandian Arunachalam

Re: Table Structure

Former Member — Mon, 19 Jun 2006 05:17:01 GMT

The field that I'm looking is not in AFKO or AFVC. I even look at the hierarchy and can't found it. I' looking for the fields xmnga, lmnga and rmnga.

Re: Table Structure

Former Member — Thu, 22 Jun 2006 06:23:53 GMT

I want to retrieve the production order operations and I'm having diffulty in finding what table they resides.

Re: Table Structure

abdul_hakim — Thu, 22 Jun 2006 06:26:03 GMT

could you open a new thread for this question.

mark all useful answers in this thread.

Cheers,

Abdul Hakim