topic Re: BSEG AND BKPF TABLES in Application Development and Automation Discussions

BSEG AND BKPF TABLES

Former Member — Wed, 09 May 2007 20:19:44 GMT

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

Re: BSEG AND BKPF TABLES

Former Member — Wed, 09 May 2007 20:34:56 GMT

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

BSAK is for Closed ones..

Re: BSEG AND BKPF TABLES

Former Member — Wed, 09 May 2007 20:56:14 GMT

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

Re: BSEG AND BKPF TABLES

Former Member — Wed, 09 May 2007 20:58:31 GMT

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.

Re: BSEG AND BKPF TABLES

Former Member — Wed, 09 May 2007 21:02:23 GMT

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?

Re: BSEG AND BKPF TABLES

Former Member — Wed, 09 May 2007 21:04:48 GMT

Sujamol,

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

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

SIRI

Re: BSEG AND BKPF TABLES

Former Member — Wed, 09 May 2007 21:23:14 GMT

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

Re: BSEG AND BKPF TABLES

Former Member — Wed, 09 May 2007 21:30:42 GMT

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...

Re: BSEG AND BKPF TABLES

Former Member — Thu, 10 May 2007 01:03:55 GMT

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

Re: BSEG AND BKPF TABLES

Former Member — Thu, 10 May 2007 01:15:04 GMT

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