topic Re: fetch value into internal table from bseg in Application Development and Automation Discussions

fetch value into internal table from bseg

Former Member — Mon, 30 Oct 2006 08:53:45 GMT

Hello

I am trying to fetch value of fields HKONT BSCHL from bseg into an internal table , but not able to do so, can any body tell how to do that, u help will be highly appreciated,

rgds

anupam

Re: fetch value into internal table from bseg

Former Member — Mon, 30 Oct 2006 09:00:57 GMT

Hi,

Sample code for you.

DATA : begin of it_bseg occurs 0,

bukrs like bseg-bukrs,

hkont like bseg-hkont,

end of it_bseg.

data : v_line type i.

start-of-selection.

select bukrs

hkont

from bseg

into table it_bseg

where bukrs = '0001'.

describe table it_bseg LINES v_line.

write / v_line.

Reward if this helps

Re: fetch value into internal table from bseg

Former Member — Mon, 30 Oct 2006 09:03:01 GMT

SELECT gjahr belnr buzei hkont bschl

into table itab

from bseg

where belnr eq ...

and gjahr eq ...

and buzei eq ...

Re: fetch value into internal table from bseg

Former Member — Mon, 30 Oct 2006 09:04:16 GMT

i am sure u have written a select query paste that here to see whats the wrong thing abt it

santhosh

Re: fetch value into internal table from bseg

Former Member — Mon, 30 Oct 2006 09:20:41 GMT

Hi,

That might be because of some error in ur code. Paste ur code here, lest its very hard 2 predict.

Re: fetch value into internal table from bseg

Former Member — Mon, 30 Oct 2006 09:31:21 GMT

I have written the same query which u mentioned but it takes a hell lot of time to execute, can u suggest any thing else.

rgds

anup

Re: fetch value into internal table from bseg

Former Member — Mon, 30 Oct 2006 09:39:55 GMT

Hi Anupam,

Since BSEG is a cluster table, it will have lots of entries. Try to put maximum key parameters in WHERE clause.

FYI. Key parameters are

BUKRS

BELNR

GJAHR

BUZEI

Re: fetch value into internal table from bseg

Former Member — Mon, 30 Oct 2006 10:45:34 GMT

Hi Palak

Actually I have to generate a report using table BKPF and BSEG, i tried using join but that doesnt works as BSEG is a cluster table,

i need to display

bseg-hkont, bkpf-blart , bseg-bschl , count

where bseg-bukrs = bkpf-bukrs and bseg-gjahr = bkpf-gjahr

where count will count total records ,example

hkont blart bschl count

766000 AB 15

766000 AB 40 5

766000 AB 50 10

in count 5 + 10 comes out to be 15

Re: fetch value into internal table from bseg

Clemenss — Mon, 30 Oct 2006 13:00:32 GMT

It is good practice and performance enhancement never (means never ever!) to fetch data from BSEG directly.

Better first get the relevant headers from one of the secondary index tables as there are:

BSAD : Accounting: Secondary Index for Customers (Cleared Items)

BSAK : Accounting: Secondary Index for Vendors (Cleared Items)

BSAS : Accounting: Secondary Index for G/L Accounts (Cleared Item

BSEC : One-Time Account Data Document Segment

BSID : Accounting: Secondary Index for Customers

BSIK : Accounting: Secondary Index for Vendors

BSIS : Accounting: Secondary Index for G/L Accounts

Choose the appropriate table(s) for your requirement.

Define a 'header' table with only key fields for BKPF/BSEG.

Select from secondary index table(s) appending the header itab.

Then fetch only the fields you really need from BSEG and BKPF into corresponding fields of your results table for all entries in...

Hope you can do it!

Regards,

Clemens