Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Difference between Structure and Tables

Former Member
0 Likes
652

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
563

just goto table EBAN : Purchase Requisition.

there you will get all the details of Purchase Requisition

reward points plz

4 REPLIES 4
Read only

Former Member
0 Likes
564

just goto table EBAN : Purchase Requisition.

there you will get all the details of Purchase Requisition

reward points plz

Read only

Former Member
0 Likes
563

Hi

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

Read only

Former Member
0 Likes
563

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

Read only

Former Member
0 Likes
563

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