BSEG- performance issue

[Former Member]

Hi,

What are the table used for F-47 postings other than BSEG. I am not able to make a query of this table too.

PL advice.

Regards,

G. Shankar

[naveen_inuganti2]

Hi...

Here some table involved with F-47 transaction...

bkdf,

t001,

ofiwa

abuz,

addr1_sel

t000,

vf_debi,

rfcu3.

ofiwa_add_on.

Thanks,

Naveen.I

[Former Member]

Hi Shanker,

these are the tables used in the transaction:

TABLES: BKDF,

BKPF, *BKPF,

BSEC, *BSEC,

BSED, *BSED,

BSEG, *BSEG,

BSEGZ,

BSET, *BSET,

BSEZ, *BSEZ,

ICURR,

KNA1, *KNA1,

KNB1, *KNB1,

KNKK,

LFA1, *LFA1,

LFB1, *LFB1,

LFVI9,

NRIV,

RF05A,

SKA1,

SKB1,

SKAT,

X001.

TABLES: T001,

T001B,

T001D,

T003, *T003,

T003T,

T004,

T005,

T007A,

T009,

T009B,

T009Y,

T014,

T020,

T030,

T030B,

T030R,

T035,

T040S,

T043,

T043T, *T043T,

X043,

T052,

T052, *T052,

T057,

T059F,

T059Q,

T074U,

TBSL, *TBSL,

TBSLT, *TBSLT,

TTXD.

• What exactly you want to get from BSEG ?

if you want Customer * Open data goto BSID then BSEG

• closed items goto BSAD then BSEG

if you want vendor * Open data goto BSIK then BSEG

• closed items got BSAK then BSEG

• for better performance Use For all entries

Thanks & Regards,

Nisa.

[Former Member]

Hi,

Please make sure that you are using the index fields in the WHERE clause in the same sequence as they are maintained in the table.

If you are using non index fields, check with BASIS if you can create secondary index on the table for better performance (if your code is to be used on daily basis).

Check you are using INTO TABLE and not INTO CORRESPONDING FIELDS OF TABLE.

Thanks,

Kartavya