topic Re: open items in Application Development and Automation Discussions

open items

Former Member — Fri, 06 Jul 2007 11:31:19 GMT

Hi,

What is meant by closed items and what is the table name for open items and closed items?

Regards,

Hema

Re: open items

Former Member — Fri, 06 Jul 2007 11:44:57 GMT

Hi,

OPEN ITEMS means the Billed/Invoice Amounts that are pending from Customers, i.e which we have to receive from Customers. BSID table will hold this data.

For every Billing Documnet created(VBRK/VBRP-VBELN) there will be an accounting document created in BSID/BSAD tables.

BSAD is the CLOSED ITEMS data means the AMOUNTS received from that customer.

OPEN ITEMS data means fetching data from BSID table Only

CLOSED ITEMS data means data fetching from BSAD only. All Items means from both the tables.

Reward all helpful answers..

Regards,

Omkar.

Re: open items

Former Member — Fri, 06 Jul 2007 11:51:57 GMT

Hi,

Open items are unpaid invoices.

Closed items are paid invoices.

if the table name contains I, that is open item

if the table name contains A, that is closed item

if the table name ends with S, that is GL account

exp BSIS- GL master open items

BSAS- GL master closed items

Pls reward points.

Regards,

Ameet

Re: open items

Former Member — Fri, 06 Jul 2007 11:54:59 GMT

Hi,

What is the field name for open items in BSID table

Regards,

Hema

Re: open items

Former Member — Fri, 06 Jul 2007 12:06:40 GMT

hema

I think for open items In BSID/BSAD tables

conditiond would be - BLART = 'RT'

or you can select the open items form bsid table like..

- Open Items:

SELECT * FROM BSID WHERE BUKRS = P_BUKRS

AND BUDAT <= KEY_DATE

based on company code and give date range....

bsid - open items for customers (accounts receivable)

bsad - cleared items for customers (payment received from customer)

bsik - open items for vendor (accounts payable)

bsak - cleared items for vendor (payment made to vendor)

~~Guduri

Re: open items

Former Member — Fri, 06 Jul 2007 12:17:52 GMT

In BSID/BSAD tables

- BLART = 'RT'

- All BSID (not cleared), BSAD (cleared) if AUGDT > '02/01/2007'

So you mean the items open at a date:

- Open Items:

SELECT * FROM BSID WHERE BUKRS = P_BUKRS

AND BUDAT <= KEY_DATE

- Cleared items

SELECT * FROM BSAD WHERE BUKRS = P_BUKRS

AND AUGDT > KEY_DATE

AND BUDAT <= KEY_DATE

The key date is not the due date, so you should explain what DUE DATE means for you.

Check the tcode..fbl5n

Regards,

Omkar.

Re: open items

Former Member — Fri, 06 Jul 2007 12:19:21 GMT

hi check this also....

http://www.erpgenie.com/abap/tables_fi.htm

Re: open items

Former Member — Fri, 06 Jul 2007 12:19:26 GMT

Coming to FI tables... there are only 6 important tables in whole Finance module which are mostly used by abapers.

They can be remember by:

if the table name contains I, that is open item

if the table name contains A, that is closed item

if the table name ends with S, that is GL account

exp BSIS- GL master open items

BSAS- GL master closed items

like wise...

if the table name ends with D, that is customer

BSID- GL master open items

BSAD- GL master closed items

if the table name ends with K, that is vendor

BSIK- GL master open items

BSAK- GL master closed items

Finally, table TSTC contains the list of all transaction codes.

reward points if it is usefull.....

Girish