04-28-2008 12:06 PM
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.
04-28-2008 12:17 PM
Hi,
The field BSTAT - Document Status decribes the category.
Try using this field.
Thanks,
Ruthra
04-28-2008 12:17 PM
Hi,
The field BSTAT - Document Status decribes the category.
Try using this field.
Thanks,
Ruthra
04-28-2008 12:20 PM
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.