Skip to Content
avatar image
Former Member

bsik table

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 28, 2008 at 11:17 AM

    Hi,

    The field BSTAT - Document Status decribes the category.

    Try using this field.

    Thanks,

    Ruthra

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 28, 2008 at 11:20 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded