what is the diff bet BSID , BKPF & BSEG tables

[Former Member]

Hi,

can any one give me the clear pic on this BSID , BKPF & BSEG tables with flow..

please replay ASAP.

Regards,

Raghunath.S

[Former Member]

Hi Raghunath

Transanctions posted to FI(from all Modules) will store the BKPF and BSEG tables. BKPF is the header table and BSEG is the line item table.

BSID is the secondary index table for customer realated transactions. In BSID table most of the fileds avilable in BKPF and BSEG will be there.

Customer related open item transaction will update in BKPF&BSEG, BSID tables.

Regards

Venkat

[Former Member]

This message was moderated.

[Former Member]

HI,

Go to the following link, which gives the relationship among these tables....

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

Regards,

Sri

[Former Member]

hi,

only to suggest an action, just if necessary for you.

t code se11

put table name

click display

you'll can check descr + struct filed's tabls

regards

RR

[Former Member]

HI,

Table BKPF --> Document header level which includes GL, Customer & Vendor line items

Table BSEG --> Document LIne item which includes GL, Customer & Vendor line items

Table BSID --> Document line item for Customer only

regards

Meenakshi

[arvind_pereira]

Yes, Meenakshi I agree to the manner in which you have presented.

thanks

Arvind

[Former Member]

Hi You have to ad BSAD to yopur list

BSID = open items

BSAD = not open items

For kreditors it is BSIK and BSAK

For G/l a BSIS and and BSAS

When you make a posting it update's these tables.

For this reason it is important to set up your G/L accounts correct. When you found a way to change G/L account (if balans value is 0) you get wrong information in your line item overview. For the G/L accounts you can use the ABAP's RFSEPA** to change the G/L account (you have to make a little change in the program that you can run it and it only working for old G/L. Before you do this have a look to the OSS note about this, there are some riscks about this).

Paul