topic Re: To find table & fields using T.Code ST05 in Application Development and Automation Discussions

To find table & fields using T.Code ST05

Former Member — Tue, 07 Jul 2009 03:39:15 GMT

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

Re: To find table & fields using T.Code ST05

Former Member — Tue, 07 Jul 2009 04:53:48 GMT

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

Re: To find table & fields using T.Code ST05

former_member434229 — Tue, 07 Jul 2009 05:55:28 GMT

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

Re: To find table & fields using T.Code ST05

Former Member — Tue, 07 Jul 2009 06:07:02 GMT

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

Re: To find table & fields using T.Code ST05

Former Member — Wed, 15 Jul 2009 15:29:42 GMT

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

please, guide detail by step by step.

Thanks & best regards,

Dungnv

Re: To find table & fields using T.Code ST05

HermannGahm — Wed, 15 Jul 2009 15:32:53 GMT

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

Re: To find table & fields using T.Code ST05

Former Member — Thu, 30 Jul 2009 05:50:08 GMT

Check with tables BKPF and BSEG.

Regards

Sripal

Re: To find table & fields using T.Code ST05

Former Member — Thu, 30 Jul 2009 08:56:26 GMT

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.