topic Re: Difference between Structure and Tables in Application Development and Automation Discussions

Difference between Structure and Tables

Former Member — Fri, 03 Aug 2007 09:57:00 GMT

Hi,

Please provide details of accessing data from structures. I know it has no underlying databse. If so where can i take it from.

Actually, for displaying details about PR, for some PR the description are "services" which are entered manually at the time making PR. I would like to get that description with the material number.

when i looked into ME53N, the description for "services" are from

[Table name: MEREQ3211GRID

Fieldname: TXZ01.] that particular field's technical settings gave this data.

So i would like to know how should i incorporate that into my program.

Regards,

Rajpriya

Re: Difference between Structure and Tables

Former Member — Fri, 03 Aug 2007 10:57:42 GMT

just goto table EBAN : Purchase Requisition.

there you will get all the details of Purchase Requisition

reward points plz

Re: Difference between Structure and Tables

Former Member — Fri, 03 Aug 2007 11:12:32 GMT

Welcome to SDN forum

When press F1 and F9 technical help you will get the structure name

then goto that field

take the data element

find the where used list of that data element select tables

execute

you will see lot of tables

in that search for purchase requisition

you will see the table <b>EBAN</b>

use it

<b>Reward points for useful Answers</b>

Regards

Anji

Re: Difference between Structure and Tables

Former Member — Fri, 03 Aug 2007 11:27:30 GMT

It is there in the following table as per the bussiness logic it gets updated from the struture MEREQ3211GRID in the Following below table using Function Modules used in th Screen program....

Where as for report developing purpose we can use it from the table's as below :

"Table-> EBAN

Purchase Requisition

"Field-> TXZ01

Short Text

"Table-> EKPB

"Material Provided" Item in Purchasing Document

"Field-> TXZ01

Short Text

"Table-> EKPO

Purchasing Document Item

"Field-> TXZ01

Short Text

Reward points if it usefull ...

Girish

Re: Difference between Structure and Tables

Former Member — Sat, 04 Aug 2007 03:41:34 GMT

Tables are Database, which stay in system for long duration , as good as permanent, untill & unless the data is archived, which is not very frequent. Data at transaction level are captured from multiple tables, so as to meet the requirement. We can view the data in the table through T.code SE11 & SE16. there are certain tables in which data can be maintained as well as displayed. To maintain data, we use T.Code: SM30 or SM31.

Structures are temporary table & hold the data for that particular instance or transaction.

Regards,

Rajesh Banka

Reward suitable points.

How to give points: Mark your thread as a question while creating it. In the answers you get, you can assign the points by clicking on the stars to the left. You also get a point yourself for rewarding (one per thread).