BSEG AND BKPF TABLES

[Former Member]

Hello Experts,

I am retrieving the vendor invoice information from BKPF and BSEG tables.. there r 3 radio buttons for parked or open or closed invoices...

for this requirement first of all i am taking the records from BKPF table into an internal table then i am taking the records from BSEG table for all entries in BKPF table.

from BSEG table i am taking the fields( WRBTR, EBELN, WERKS, BELNR) .

Here my question is...which one would be better whether i have to use the BSIK table it is containing all the fields except the WERKS or i have to go for BSEG only ... .is there any difference if i use BSIK instead of BSEG...

thanks alot for your help

SIRI

[Former Member]

BSIK is specifically for Open Items of accounting docs...

BSAK is for Closed ones..

[Former Member]

BSEG is huge table which contains line items for all the financial transactions. BSIK is a table which contains open items for vendors.

Better hit BSIK.

Thanks,

SKJ

[Former Member]

SKJ

you mean to say that when the open invoice radio button is hit then its better to retrieve the records from bsik instead of bseg rite...

then for the closed invoices i have to fetch the records again from bseg table?

can u guide me exactly wht to do in these 3 conditions?

what is the key for the open invoices in that table?

[Former Member]

Basically we have follwing tables:

BKPF - Accounting headers

BSEG - All line items info

BSAK - Vendor clear items

BSIK - Vendor Open items

BSAS - G/L account - clear item

BSIS - G/L account - open item

BSID - Customer open item

BSAD - Customer clear item

So in your case you need to hit BSIK table for vendor open items and for cleared ones BSAK

This is the key in BSIK:

BUKRS

LIFNR

UMSKS

UMSKZ

AUGDT

AUGBL

ZUONR

GJAHR

BELNR

BUZEI

If you hit BSEG you get all the information but chances of performance issue as it is a cluster.

Also, as you need only vendor invoice items, i dont think you need BSID or BSAD tables which are related to Customer.

Thanks,

SKJ

[Former Member]

ya your point is correct

but what r the keys for those open invoices and closed invoices in those tables... i think augbl is the key field if it is blank then those records r nothing but open invoices rite....

one more thing how to get the field WERKS... from which table i have to get this field...

[Former Member]

There is no key field or any flag which indicates a particular entry is open or clear.

The table itself says that it is a open or cleared line item

I am away from sys now will let you know about WERKS

Thanks,

SKJ

[Former Member]

Plant details WERKS you can get either from BSIS or BSAS (open and cleared G/L) tables.

but these two tables are also generally very huge in data.

Regards,

Atish

[Former Member]

If you decide to avoid BSEG, then you shud use the following 6 tables.

cleared entries

BSID - customer

BSIS - G/L account

BSIK - vendor

other entries.

BSAD, BSAS, BSAK respectively.

[Former Member]

Sujamol,

i need to get the vendor invoices for 3 conditions..

is it necessary to go into all those 6 tables....

SIRI