04-29-2008 2:43 PM
Hi,
We are facing issue in which we have to pull material no for some non copa postings.
But if we use BSEG table then serious performance issues are coming up..
so are there any other tables / combination of tables that we can look for instead of BSEG?
04-29-2008 3:41 PM
Hi,
BSEG is Cluster table, you can only select with key fields.
if you have a select:
select belnr budat wrbtr from bseg
into table it_bseg
where bukrs = bukrs
and belnr = belnr
and gjahr = gjahr
and bschl = 31.
it's much better to select of this way:
select belnr budat wrbtr from bseg
into table it_bseg
where bukrs = bukrs
and belnr = belnr
and gjahr = gjahr.
delete it_bseg where bschl ne '31'.
Regards,
Fernando
04-29-2008 2:46 PM
hi,
BSEG is a cluster table of the below specified transparent tables... instead of it retrieve the related data from the below tables
BSID Accounting: Secondary Index for Customers(Open Items)
BSIK Accounting: Secondary Index for Vendors
BSIM Secondary Index, Documents for Material
BSIS Accounting: Secondary Index for G/L Accounts
BSAD Accounting: Secondary Index for Customers(Cleared Items)
BSAK Accounting: Secondary Index for Vendors(Cleared Items)
BSAS Accounting: Secondary Index for G/L Accounts(Cleared Items)
Regards,
Santosh
04-29-2008 2:52 PM
Since we are pulling material based on G/L acct no.
We are thinking of using 2 tables
BSIS & BSIM...
But how can we connect these 2 tables also connect logic for the extractor?
Any idea?
04-29-2008 2:52 PM
/people/rob.burbank/blog/2007/11/12/quickly-retrieving-fi-document-data-from-bseg
04-29-2008 3:41 PM
Hi,
BSEG is Cluster table, you can only select with key fields.
if you have a select:
select belnr budat wrbtr from bseg
into table it_bseg
where bukrs = bukrs
and belnr = belnr
and gjahr = gjahr
and bschl = 31.
it's much better to select of this way:
select belnr budat wrbtr from bseg
into table it_bseg
where bukrs = bukrs
and belnr = belnr
and gjahr = gjahr.
delete it_bseg where bschl ne '31'.
Regards,
Fernando