topic Re: Finding Table Name in Application Development and Automation Discussions

Finding Table Name

Former Member — Mon, 13 Jul 2009 04:12:57 GMT

Hi,

I need to create a reoprt for all customer and total sale by ref to t-code fd11.

i am not finding the proper table name for getting customer and total sales.

Plz help me.

Thanks,

Sunil Sahoo

Re: Finding Table Name

Former Member — Mon, 13 Jul 2009 04:29:34 GMT

did u searched in MVKE table

please try doing this also put mv* and give for search in the table

hope u will get it

cheers

s.janagar

Re: Finding Table Name

Former Member — Mon, 13 Jul 2009 04:30:00 GMT

Try these tables...

KNA1 , KNB1, KNC1 , KNC3

Re: Finding Table Name

Former Member — Mon, 13 Jul 2009 04:42:44 GMT

Hi,

to find the table name, use SQL Trace...

just take some test data and run the transaction FD11, before running goto ST05 & click on Activate Trace button. once u r done with the transaction Deactivate Trace & display trace in same ST05.

Hope it helps!!

Rgds,

Pavan

Re: Finding Table Name

Former Member — Mon, 13 Jul 2009 05:40:33 GMT

hi ,

If you want to find table name .Go to the T-CODE and keep your cursor on the parameter and press F1 and it will show a pop-up press technical information button .In most of the time it will show the field name and the structure name only some times it will show table name . Get the field name from there . And go to T-CODE SE15 click on the tree ABAP DICTIONARY on the left. It will list tables,views,fields etc. Click the fields AND go to table fields . And enter the field name in the field name parameter and press execute button it will show the tables which has the particular field. You could further narrow down by finding the package for the particular t-code using SE93. And give its name in it.

With Regards,

M.Sreeram.

Re: Finding Table Name

Former Member — Mon, 13 Jul 2009 05:50:05 GMT

Dear Sunil,

Please find the tables which can help you out in developing this report.

BKPF,

BSEG,

BSAD,

BSAK,

BSAS,

BSID,

BSIK,

BSIS,

GLT0, " General Ledger

KNA1,

LFA1,

SKA1

Regds,

Anil