Table BSID and BSAD

Table BSID and BSAD

the both of tables are FI tables and have a relation within Customer.

Document Header table : BKPF -> Accounting Document Header
Fields : BUKRS ->Company Code
BELNR->Accounting Document Header
GJAHR->Fiscal Year
These fields is important. Because Document Header can be repeated every year or other Company Code.

Document Segment : BSEG -> Accounting Document Segment
Fields : BUKRS-> Company Code
BELNR->Accounting Document Header
GJAHR->Fiscal Year
BUZEI->Number of Line Item Within Accounting Document
HKONT->General Ledger Account
SHKZG->Debit/Credit Indicator
S -> Debit
H -> Credit
This table is detail table. It would be very big records, because every posting accounting document will update this table. I can say it is Journal GL Table.

Allocation Table : BSID ->Accounting: Secondary Index for Customers -> Open Items
Fields : KUNNR -> Customer Number 1

I call this table as Allocation Table, because :
1. We can know total amount of every payment to allocate invoice.
2. Or Credit Memo can allocate to invoice
This table fill open invoice (It hasn't been paid yet) or Payment of invoice hasn't been fully (belum Lunas)
example :
Invoice 1000
Payment1 200
Payment2 400


Allocation Table : BSAD ->Accounting: Secondary Index for Customers -> Closed Items
It is the same as BSID, but it only fills invoice has been paid fully (Lunas)
example :
Invoice 1000
Payment1 200
Payment2 400
Payment3 400