on 02-19-2010 5:22 PM
All
trying to understand how things work between these tables.
how does data flow between these tables and when is an entry created in the BSIS / BSAS tables?
Thanks,
TZ
When we post to a GL Account which has Line item flag set, it will go into both BSEG and BSIS. If the GL Account is tagged Open as well, then the there is Open Item flag set in BSIS which will be checked. When we clear the Open items, then it will be removed from BSIS and BSAS.
In essense, total number of items in BSEG for a GL Account must be equal to sum of items in BSIS and BSAS.
If the Line item flag is not set, my understanding is it will hit only BSEG and not BSIS. Anybody correct me if I am wrong.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
BSEG - has all financial entries including all open items/cleared items from all module
BSIS - GL open items
BSAS - G/L Accounts (Cleared Items)
When financial entry is created for GL Open item managed accounts, it updates BSEG and BSIS. When it is cleared it is removed from BSIS and updated in BSAS.
Hope this helps
Narayanan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
see attached link on the wiki - this will help you understand the ERD of the various tables out there...
http://wiki.sdn.sap.com/wiki/download/attachments/4985/FI+Tables.JPG?version=1
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.