bsik table

[Former Member]

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]

Hi,

The field BSTAT - Document Status decribes the category.

Try using this field.

Thanks,

Ruthra

[Former Member]

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]

https://forums.sdn.sap.com/click.jspa?searchID=11218980&messageID=853238

BestRegards,

Ramesh.