08-18-2005 1:53 AM
hi,
just wanna what TCODE that will display all tables in SAP or tables that connected with PO.
thanks.
donna
08-18-2005 4:44 AM
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.
08-18-2005 2:09 AM
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
08-18-2005 2:09 AM
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
gv
08-18-2005 4:30 AM
Hi Donna,
u can also goto SE81 and find out from there for a specific functional component.
This is a useful tx.
Reg,
Prabhu.
08-18-2005 4:44 AM
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.
08-18-2005 4:52 AM
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
08-18-2005 8:22 AM
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.