topic Re: all tables in Application Development and Automation Discussions

all tables

Former Member — Thu, 18 Aug 2005 00:53:23 GMT

hi,

just wanna what TCODE that will display all tables in SAP or tables that connected with PO.

thanks.

donna

Re: all tables

RichHeilman — Thu, 18 Aug 2005 01:09:22 GMT

SE11 will tell you everything you want to know in regard to tables in SAP. Finding tables for a particular business object is a little trickier, in some cases you may have to do an SQL trace to find them.

If you are looking for tables concerning purchase orders, here are a few.

EKAB	Release Documentation
EKAN	Vendor Address: Purchasing Document
EKBE	History per Purchasing Document
EKBEH	Removed PO History Records
EKBO	Index of Docs. for Price Determ./Updating, Subsequent Sett.
EKBZ	History per Purchasing Document: Delivery Costs
EKBZH	History per Purchasing Document: Delivery Costs
EKEH	Scheduling Agreement Release Documentation
EKEK	Header Data for Scheduling Agreement Releases
EKES	Vendor Confirmations
EKET	Scheduling Agreement Schedule Lines
EKETH	Scheduling Agreement Schedules: History Tables
EKKI	Purchasing Condition Index
EKKN	Account Assignment in Purchasing Document
EKKO	Purchasing Document Header
EKPA	Partner Roles in Purchasing
EKPB	"Material Provided" Item in Purchasing Document
EKPO	Purchasing Document Item
EKPV	Shipping-Specific Data on Stock Tfr. for Purch. Doc. Item
EKRS	ERS Procedure: Goods (Merchandise) Movements to be Invoiced
EKUB	Index for Stock Transport Orders for Material

Please remember to award points for helpful answers. Thanks.

Regards,

Rich Heilman

Message was edited by: Rich Heilman

Re: all tables

Former Member — Thu, 18 Aug 2005 01:09:31 GMT

just look at the table DD02L in se16 to find the list of table in sap

In the above tcode use tabname = ek* and TABCLASS = TRANSP to find the tables related to po.

regds

Re: all tables

Former Member — Thu, 18 Aug 2005 03:30:38 GMT

Hi Donna,

u can also goto SE81 and find out from there for a specific functional component.

This is a useful tx.

Reg,

Prabhu.

Re: all tables

Former Member — Thu, 18 Aug 2005 03:44:44 GMT

General method to find tables and other objects pertaining to any specific functional area is to go to transaction SE81. Navigate down the tree to desired functional area, click on the entry (MM-pur in this case). Then click on 'Select Subtree' button in toolbar. Your selection turns yellow. Then click on 'information system' button. You will go to object navigator. Expand the ABAP dictionary node on the left, double click on 'Database Tables'. Press F8 to see the list of tables.

Re: all tables

Former Member — Thu, 18 Aug 2005 03:52:15 GMT

just go to T-Code <b>DB15</b>

and enter <b>MM_EKKO</b> in Tables in Object

u will get the list of all the tables related to PO

cheers

abhishek suppal

Re: all tables

Former Member — Thu, 18 Aug 2005 07:22:15 GMT

Hi friends,

U can use transaction se49 to find the tables related to a particular transaction. But mind it, this txn not exist in 4.7, but still there exists the program in 4.7... u can create TXN for the program urself.

Program is : SAPMSEUZ

With regards,

praveen.