08-26-2009 8:03 AM
For fico details i using bseg and bkpf tables.
I noted that programming is very difficult because of these tables are cluster table.
plz give me other tables
if i using these tables any problem will come?
08-26-2009 8:18 AM
Hi Aniesh,
BSEG and BKPF are cluster tables. It contains transperant tables like BSIS, BSIK etc. For example to take vendor details usr the BSIK.If you use BSEG and BKPF it will take long time search. suppose your concern having lot of data means may be your server will get shutdown. So use only trasnperant tables like BSIS, BSIK etc.
Regards
R.Vijai
08-26-2009 8:10 AM
08-26-2009 8:12 AM
Hi Aniesh
Use them, no issues. But try to be as selective as possible in your search as possible.
Hope this helps.
Harsh
08-26-2009 8:14 AM
Hi ,
You can use the tables BSAK, BSIK, BSID and BSAD tables . You will get all the data that u r trying to fetch from BSEG and BKPF.
Getting the data from BSEG will certainly lower the performance of ur code.
Regards,
Anuj
Edited by: ANUJ SRIVASTAVA on Aug 26, 2009 12:44 PM
08-26-2009 8:18 AM
Hi Aniesh,
BSEG and BKPF are cluster tables. It contains transperant tables like BSIS, BSIK etc. For example to take vendor details usr the BSIK.If you use BSEG and BKPF it will take long time search. suppose your concern having lot of data means may be your server will get shutdown. So use only trasnperant tables like BSIS, BSIK etc.
Regards
R.Vijai
08-26-2009 10:51 AM
>
> Hi Aniesh,
>
> BSEG and BKPF are cluster tables. It contains transperant tables like BSIS, BSIK etc. For example to take vendor details usr the BSIK.If you use BSEG and BKPF it will take long time search. suppose your concern having lot of data means may be your server will get shutdown. So use only trasnperant tables like BSIS, BSIK etc.
>
>
> Regards
> R.Vijai
Incorrect. BKPF is a transparent table and not a cluster table and you can use it just like any other transparent table. BSEG is a cluster table but there is no problem selecting from it so long as you use the key of BUKRS, BELNR, GJAHR - unless you are selecting a very large amount of data, but then this can cause problems when selecting from any type of table.
The advantage of using BSEG over the other FI line item tables such as BSIS and BSIK is that it holds all the lines of an FI document while the others will hold only a subset eg BSIK will only hold lines that contain a vendor reference and BSAS holds only cleared GL account lines. Though you can only use it when you have the key. If you need to search on vendor, you can use BSIK as a starting point, but since I usually need to get hold of all the lines on an FI document, I then have to select from BSEG anyway.
08-26-2009 10:52 AM
Hi Aniesh Cherian,
Declare internal tables it_bseg and it_bkpf, write the select stmt for BSEG and BKPF, put records in internal tables.
Read those IT- table by using read table.......with ...... or where condition. but don't put bseg and bkpf table in loop stmt.
thanks
kallam