open items

[Former Member]

Hi,

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

Regards,

Hema

[Former Member]

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.

[Former Member]

Hi,

What is the field name for open items in BSID table

Regards,

Hema

[Former Member]

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

[Former Member]

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.

[Former Member]

hi check this also....

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

[Former Member]

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

[Former Member]

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

<b>They can be remember by:</b>

if the table name contains <b>I,</b> that is open item

if the table name contains<b> A,</b> that is closed item

if the table name ends with <b>S,</b> that is GL account

exp <b>BSIS- GL</b> master open items

<b>BSAS- GL</b> master closed items

<b>like wise...</b>

if the table name ends with D, that is customer

<b>BSID- GL</b> master open items

<b>BSAD- GL</b> master closed items

if the table name ends with K, that is vendor

<b>BSIK- GL</b> master open items

<b>BSAK- GL</b> master closed items

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

reward points if it is usefull.....

Girish