Basic FI Tables :

BKPF :

• FI Document header details stored in this table like document number, document date, posting date, entry date, reference, header text, exchange rate, document type, etc.,
• For each document it will store only one entry in the table.
• This may update if any changes made in the document header like change in the header text / reference field.
• Other than the above fields, some other fields also get updated like document change date, document reversal details (document number, date reversed)etc.,

BSEG :

• FI Document line item details stored in this table like posting key, GL account number, amount in local currency, amount in document currency, amount in 2nd & 3rd local currency, account assignment objects (cost center / internal order / WBS), short text, payment terms, discount details and etc.,
• For each document it will store minimum 2 entries and maximum 999 entries in the table.
• These line item entries updated if any changes made in the line items like change in the payment terms, payment block, payment method, short text and etc.,
• Other than the above fields, some other fields also get updated like clearing details (clearing document number, clearing date).

BSIK :

• FI Vendor open item details stored in this table.
• In this table you will find the both header and vendor line item details.
• For each vendor document it will store entries based on vendor line items in the document.
• This table updates only when there is a entry posted to the vendor.
• This table contains only open items relating to vendor.
• Entries in this table not appear if that line item cleared due to payment happend / document reversed / manually cleared with another line item.

BSAK :

• FI Vendor cleared item details stored in this table.
• In this table you will find the both header and vendor line item details (cleared).
• For each vendor document it will store entries based on vendor line items in the document and also line item which cleared the vendor open line item. Number entries will be minimum 2 line items (invoice line item & cleared line item) and maximum depends upon the documents it cleared
• This table updates when the vendor line item is cleared.
• This table contains only cleared items relating to vendor.
• Entries in this table not appear if that line item cleared due to payment happend / document reversed / manually cleared with another line item.
• This table updation follows the BSIK table updation.

BSID :

• FI Customer open item details stored in this table.
• In this table you will find the both header and customer line item details.
• For each customer document it will store entries based on customer line items in the document.
• This table updates only when there is a entry posted to the customer.
• This table contains only open items relating to customer.
• Entries in this table not appear if that line item cleared due to payment happend / document reversed / manually cleared with another line item.

BSAD :

• FI Customer cleared item details stored in this table.
• In this table you will find the both header and customer line item details (cleared).
• For each cusotmer document it will store entries based on customer line items in the document and also line item which cleared the customer open line item. Number entries will be minimum 2 line items (invoice line item & cleared line item) and maximum depends upon the documents it cleared
• This table updates when the customer line item is cleared.
• This table contains only cleared items relating to cusotmer.
• Entries in this table not appear if that line item cleared due to payment happend / document reversed / manually cleared with another line item.
• This table updation follows the BSID table updation.

BSIS : Same like BSIK & BSID, but the change here is open line items relating to the GENERAL LEDGER

BSAS : Same like BSAK & BSAK, but the change here is cleared line items relating to the GENERAL LEDGER

BSAT :

• This table contains the tax details posted in the document.
• Data relating to the fields like, Tax Code, Tax percentage,Tax amount, Input / Output tax indicatore, Jurisdiction code, and condition record number, etc.,