To find table & fields using T.Code ST05

[Former Member]

Dear all.

I've using t.code ST05 to find tables that i input data in system.

For example.

The first. I start T.Code ST05 then I chose SQL Trace and click Active Trace.

The second. I start new secssion and input T.code FB70 in Command Field.

in this secssion i know these files following.

1. Customer: ( INVFO-ACCNT )

2. Invoice date: ( INVFO-BLDAT )

3. Posting Date.( INVFO-BUDAT )

4. Cross-CC no.( INVFO-BVORG )

5. Amount.( INVFO-WRBTR )

8. Tax amount ( INVFO-WMWST )

9. Text. ( INVFO-SGTXT )

10. GL Acct.( ACGL_ITEM-HKONT )

11. Amount in doc.curr. (ACGL_ITEM-WRBTR).

...

such as i checked in t.code SE11 then INVFO & ACGL_ITEM is not table, they are structure.

I want to know extractly these fields in where tables.

the last. i come back Secssion with T.Code ST05 and click Deactive Trace

then i chose Performance Trace->Display detailed Trace list->Trace list-> summarize Trace by SQL statements

at this step i see columns "TabType", "Obj. name", "SQL statement"

and i search at that then i don't see these fields WRBTR, HKONT,..

Please guide me, to find these fields in where tables.

Thanks & best Regards,

Dungnv

[Former Member]

Hi NghiemVanDung ,

Check out in tables

BSID Accounting: Secondary Index for Customers

BSAD Accounting: Secondary Index for Customers (Cleared Items)

BSEG Accounting Document Segment

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya

[former_member434229]

Hi,

Just change the sequence as below:

start new secssion, input T code FB70 in Command Field.

Fill the following values.

1. Customer: ( INVFO-ACCNT )

2. Invoice date: ( INVFO-BLDAT )

3. Posting Date.( INVFO-BUDAT )

4. Cross-CC no.( INVFO-BVORG )

5. Amount.( INVFO-WRBTR )

8. Tax amount ( INVFO-WMWST )

9. Text. ( INVFO-SGTXT )

10. GL Acct.( ACGL_ITEM-HKONT )

11. Amount in doc.curr. (ACGL_ITEM-WRBTR).

Start a new session with T code St05. Activate the SQL trace.

Come back to first session, execute the screen. Then Deactivate SQL trace and check the log. This will drastically reduce the table entries and you can then check the table/s.

Regards,

Ni3

[Former Member]

it seems that you confuse tables and fields.

Tables are shown in the SE11 (DDIC), they are also shown in the ST05 if they are used in your program in column 'Obj.Name'.

The fields are not all shown, the statement shows only some fields of the where-clause.

You can check in the table DD03L (with SE11) which fields belong to which table, then you must view the detail or the ABAP source code in the ST05 of the respective table to see the complete statement.

Siegfried

[Former Member]

Thanks anybody help me but i don't solve my problem.

please, guide detail by step by step.

Thanks & best regards,

Dungnv

[HermannGahm]

Hi,

if your transaction FB70 is using asynchronous updates you have to trace the update processing as well (in order to find the sql statements...).

Kind regards,

Hermann

[Former Member]

Hi

Check with tables BKPF and BSEG.

Regards

Sripal

[Former Member]

rephrase your question and use

> Tables are shown in the SE11 (DDIC), they are also shown in the ST05 if they are used in your program in column 'Obj.Name'.

to finds out what are tables and what are fields.

Then it might be possible to help you.