Finding Table Name

[Former Member]

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

[Former Member]

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

[Former Member]

Try these tables...

KNA1 , KNB1, KNC1 , KNC3

[Former Member]

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

[Former Member]

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.

[Former Member]

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