alternative to BSEG

[Former Member]

HI Experts,

I am making customer ledger report for FI module. I have used BSEG table to customer account details. As BSEG is big table so it takes lots of time to execute. Is there any alternative to BSEG table where I get the same data with fast processing.

urgent

Thanks

Khan

[former_member624107]

BSEG is a cluster table which contain data from tables

BSIS, BSIK, BSAS, BSAK

so u can use any of the above mentioned tables instead of bseg

[former_member624107]

Hi

BSEG is a cluster table which contain data from tables

BSID , BSAD ,BSIS, BSIK, BSAS, BSAK

for performance improvement u can use one of the above mentioned tables accordingly..

[Former Member]

hi,

So if I USE BSID insted of BSEG, do it has all the data compared to BSEG. Will it has all closing as well as open Items.

Thanks.

Khan

[Former Member]

You Should use BSID and BSAD tables in this case.

Regards,

Atish

[Former Member]

Accounts receivable scenario: BSID for open, BSAD for cleared

Accounts payable scenario : BSIK for open, BSAK for cleared

[Former Member]

The query is as Follow if you don't want to use BSEG.

REPORT  Zcustomer.
table :  BSID,BSAD

Parameter : ls_bukrs for  BSID-BUKRS .
Parameter : ls_keydt FOR  BSID-augdt.

  DATA  : lt_bsid      TYPE  TABLE OF _bsid ,
          ls_bsid      LIKE  LINE OF  lt_bsid,


 SELECT * FROM bsid INTO CORRESPONDING FIELDS OF TABLE lt_bsid
        WHERE budat  LE ls_keydt
        AND   bukrs  =  ls_bukrs.

SELECT * FROM bsad INTO CORRESPONDING FIELDS OF TABLE lt_bsid
        WHERE budat LE ls_keydt
        AND   augdt GT ls_keydt
        AND   bukrs  =  ls_bukrs.



so now your  internal table "lt_bsid" consist of  both open & Closed  line item



if you want the same for Vendor   do the  same replace the table's  with BSIK,BSAK

if  for G/L
Then   BSIS,BSAS.

Reward points if it is usefull ....

Girish

[Former Member]

THNAKS FOR HELP, But ur output doesnt match with FBL5N. Any alternative.

Thanks.

Khan

[Former Member]

Hi Khan

did you solve this problem, if solved can you please tell me how to do, mine is also same issue now.

[former_member15255]

Alternative for Bseg and customer line items are "BSAD & BSID"

Regards

suresh

[Former Member]

BSIK AND BSAK TABLES are there