topic BSEG- performance issue in Application Development and Automation Discussions

BSEG- performance issue

Former Member — Mon, 25 Aug 2008 10:16:50 GMT

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

Re: BSEG- performance issue

naveen_inuganti2 — Mon, 25 Aug 2008 10:43:11 GMT

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

Re: BSEG- performance issue

Former Member — Mon, 25 Aug 2008 11:45:59 GMT

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.

Re: BSEG- performance issue

Former Member — Mon, 25 Aug 2008 20:24:11 GMT

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