topic Re: bsik table in Application Development and Automation Discussions

bsik table

Former Member — Mon, 28 Apr 2008 11:06:31 GMT

Hi All,

From bsik table i have to fetch only vendor open items .

what are the fields to be considered so that i can eliminate the other items like parked , deleted......etc

and get only the open items for that vendor..

Thanks.

Former Member — Mon, 28 Apr 2008 11:17:49 GMT

Hi,

The field BSTAT - Document Status decribes the category.

Try using this field.

Thanks,

Ruthra

Former Member — Mon, 28 Apr 2008 11:20:05 GMT

Hi,

to select open items for vendor you should read from table BSIK.

After this you can read table BSEG with BSIK-BUKRS, BSIK-BELNR, BSIK-GJAHR.

( Bseg is a cluster table and selections for vendor are slower than bsik)

for example:

code

select * from bsik

where bukrs = company_code

and lifnr = vendor_no

select * from bseg

where bukrs = bsik-bukrs

and belnr = bsik-belnr

and gjahr = bsik-gjahr

[/code]

BestRegards,

Ramesh.