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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Effective way for fetching data from a cluster table

Former Member

‎03-28-2009 6:44 AM

0 Kudos

hi all,

i m trying to use BSEG table for fetching FI data,since it is a cluster table it is taking lots of time to retrive data.So is there any substitute or specific way for reading data from a cluster table.

plz help,

regards

johnson george

2 REPLIES 2

Former Member

‎03-28-2009 6:47 AM

0 Kudos

there are two ways.

1. first fetch BKPF (header table) and then go to BSEG table by matching

BSEG-BUKRS = BKPF-BUKRS

BSEG-BELNR = BKPF-BELNR

BSEG-GJAHR = BKPF-GJAHR

2. or fetch the tables BSIS,BSAS,BSAD,BSID,BSAK,BSIK instead of using BSEG

Former Member

‎03-28-2009 6:45 PM

0 Kudos

This question has been asked and answered many times before. It's also too vague to give a good answer.

Please search the forum.

Rob