Secondary index

[Former Member]

Hi,

There are some tables in systems like bsak, these are secondary index tables. What is the purpose of these tables. I know why we use secodary index on tables. But these tables are itself seconary index tables. Whats the purpose of these tables?

Thanks,

[Former Member]

hI,

Bsak and Bseg are account related tables . These are (very big tables ) cluster tables.for the performance point of view we will use this secondary index in the tables.

regards,

anilreddy

[Former Member]

HI,.

Some examples of index tables:

VAKGU Sales Index: Quotation Validity

VAKPA Sales Index: Orders by Partner Function

VAPMA Sales Index: Order Items by Material

VBOX SD Document: Billing Document: Rebate Index

VEPVG Delivery Due Index

VETVG Delivery Due Index for Stock Transfer

VKDFS SD Index: Billing Initiator

VLKPA SD Index: Deliveries by Partner Functions

VLPMA SD Index: Delivery Items by Material

VRKPA Sales Index: Bills by Partner Functions

VRPMA SD Index: Billing Items per Material

VTRDI Shipment Planning Index

EKKI Purchasing Condition Index

EKUB Index for Stock Transport Orders for Material

BSAD Accounting: Secondary Index for Customers (Cleared Items

BSAK Accounting: Secondary Index for Vendors (Cleared Items)

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

BSIA Archive Index for FI Documents (Outdated! See ARCH_IDX)

BSID Accounting: Secondary Index for Customers

BSIK Accounting: Secondary Index for Vendors

BSIM Secondary Index, Documents for Material

BSIP Index for Vendor Validation of Double Documents

BSIS Accounting: Secondary Index for G/L Accounts

BSIW Index table for customer bills of exchange used

BSIX Index table for customer bills of exchange used

Avoid using table VBFA (huge table). For preceding document linkages, use reference fields for e.g. tables LIPS/VBRK (fields VGBEL, VGPOS).

Tables VBUK/VBUP provide sales document statuses.

Regards

Sudheer

[Former Member]

BSEG is a cluster table and you can't create a secondary index on it. But there are a number of other fields that you would often like to base your select on. therefore, SAP has added these index table to allow you to get BSEG information if you don't know the company code and document number, but do know say the GL account number.

Rob