Purpose of the following tables?

[Former Member]

Hi All,

Does anyone knows the exact purpose of the following tables;

1. BSIK

2. BSAK

3. BSAS

4. BSIS

I need a clear description.

Thanks,

Kishan

[former_member181962]

These are secondary Index tables created for BSEg table, to make the data retrieval faster.

Depending upon what data you want to get from BSEG table, you can use the corresponding index viz. the tables you have mentioned.

1. BSIK :Accounting: Secondary Index for Vendors

2. BSAK :Accounting: Secondary Index for Vendors (Cleared Items)

3. BSAS :Accounting: Secondary Index for G/L Accounts (Cleared Items)

4. BSIS :Accounting: Secondary Index for G/L Accounts

[Former Member]

HI,

Refer this link:

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

http://help.sap.com/saphelp_erp2005/helpdata/en/6b/5fc3398c9f314de10000000a11402f/frameset.htm

Regards,

Gayathri

[Former Member]

Thanks All points Awarded!!!

[former_member188685]

Hi,

They are secondary index tables of BSEG.

BSIK Accounting: Secondary Index for Vendors

BSAK Accounting: Secondary Index for Vendors (Cleared Items)

BSAS Accounting: Secondary Index for G/L Accounts (Cleared Items)

BSIS Accounting: Secondary Index for G/L Accounts

Regards

Vijay

[Former Member]

HAI KISHAN.

these are FI/CO tables.

BSIK

(Accounting: Secondary index for

vendors)

BSAK

(Accounting: Secondary index for

vendors (cleared items))

BSAS

(Accounting: Secondary index for G/L

accounts (cleared items))

BSIS

(Accounting- Secondary Index for G/L Accounts)

FOR DETAILED INFORMATION VISIT THIS WEBSITE.

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

REGARDS,

PRABA.

[Former Member]

Hi

The main tables of FI document are:

- BKPF (header data)

- BSEG (Item data)

The Item can be for Vendor, Customer and G/L.

You can know the type of item seeing the field BSEG-KOART:

KOART = K -

---

> Vendor

KOART = D -

---

> Customer

KOART = S -

---

> G/L

An item can be cleared or open:

IF BSEG-AUGBL IS INITIAL -

---

> Item is open

IF NOT BSEG-AUGBL IS INITIAL -

---

> Item is cleared

For every type of BSEG there are always two tables: one for open item and one for cleared item.

These tables have data of BSEG and BKPF, their name is always:

BS<X><Z>

Where

<X> = A for cleared item

<X> = I for open item

<Z> = K (Vendor item)

<Z> = D (Custome item)

<Z> = S (G/L item)

So

BSIK is index table for open vendor items

BSAK is index table for cleared vendor items

BSIS is index table for open G/L items

BSAS is index table for cleared G/L items

It always should be better to read these table than BSEG.

Iy should read BSEG table only if it knows the keys.

Max