BSIS Index

[Former Member]

Though its not a good practice to create a secondary index on SAP standard table, I had to create it. Now before moving it to production I have few doubts if any one can throw some light on it...

When this index can be transported to Production? Can this index be moved in the middle of the week or this can be moved only on Sundays? Are there certain special consideration for this ? Do you need to bring DBA in this issue due to the size of the table or any other issue that would be a concern to DBA?

Thank you,

[Former Member]

Yes - you must let the DBAs know what is going on. The new index will take up tablespace and must be created in the database. This will take time. You will probably not want to do this while BSIS is being updated (which would mean any time users are on the system).

As a matter of interest, what are the fields of the new index?

Rob

[Former Member]

Rob,

The fields are BUKRS,HKONT,BUDAT,XOPVW,ZUONR

[Former Member]

Well, BKPF already has an index that includes BUDAT.

Rob

[Former Member]

Rob

you mean to say I should do this way...

select * into table i_bkpf from bkpf where bukrs = tbukrs and budat in tbudat.

sort i_bkpf by bukrs belnr

select * into table i_bsis from bsis for all entris in i_bkpf where belnr = i_bkpf-belnr.

This will bring all the required records from BSIS and will not leave any record ?

What is the relation between BKPF and BSIS then?

Thanks

[Former Member]

Not quite. I meant more like:

SELECT *
  FROM bkpf
  INTO TABLE i_bkpf
  WHERE bukrs = tbukrs
    AND bstat = ' '
    AND budat IN tbudat.

SORT i_bkpf BY bukrs belnr gjahr.

SELECT *
  INTO TABLE i_bseg
  FROM bseg
  for ALL entris IN i_bkpf
  WHERE bukrs = i_bkpf-bukrs
    AND belnr = i_bkpf-belnr
    AND gjahr = i_bkpf-gjahr
    AND hkont IN so-hkont
    AND xopvw = p_xopvw
    AND zuonr IN so-zuonr.

Rob

[Former Member]

But I want all the records from BSIS, whats the relation between then all 3 files?

[Former Member]

BSIS is a secondary index table. It contains fields from BKPF and BSEG and combines records from both for open GL items.

Rob

[Former Member]

Thanks Rob for your inputs..

[Former Member]

Glad to help - hope it all works out for you.

Rob