Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Any problem using bseg and bkpf tables

Former Member
0 Kudos

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?

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

6 REPLIES 6

Former Member
0 Kudos

You can fetch the data from these tables. No issues with that.

former_member217316
Contributor
0 Kudos

Hi Aniesh

Use them, no issues. But try to be as selective as possible in your search as possible.

Hope this helps.

Harsh

anuj_srivastava
Active Participant
0 Kudos

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

Former Member
0 Kudos

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

0 Kudos

>

> 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.

Former Member
0 Kudos

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