01-15-2009 2:29 PM
I am writing a program to extract accounting data. Thank you for the many, many posts on BSEG and RFBLG. However, I am finding a few documents that do not have any entries in the six secondary index tables. I can go to FB03 and display a document and see two lines items, the debit and credit. I can look-up the document in BSEG and see both entries. But when I search through the six secondary tables I can only fine one of the line items in BSEG, not both. What other table(s) could be used?
Thanks,
Chris
01-15-2009 2:34 PM
HI,
Can you have a look into other tables
VBSEGD, VBSEGK, and other tables starting with VBSEG*
Regards,
Venkatesh
01-15-2009 2:34 PM
HI,
Can you have a look into other tables
VBSEGD, VBSEGK, and other tables starting with VBSEG*
Regards,
Venkatesh
01-15-2009 2:41 PM
Thank you for the suggestion. There are only two documents in this group of tables, non of which are my missing items.
Chris
01-15-2009 2:48 PM
The transaction that posted the documents was FBB1 - Post Foreign Currency Valuation.
01-15-2009 3:01 PM
Hi
U should check which values are store in fields BSEG-BUZID BSEG-KOART in order to understand in which secondary index table it can be stored.
Max
01-15-2009 3:10 PM
Good tip Max, thanks. My particular document has a KOART of S (both line items) in BSEG, so I expect to find the entries in BSAS/BSIS. One of my entries is in BSIS, but the other one is no where to be found. These happen to be odd account postings. DMBTR is zero and DMBE2 is not zero. If I look in BSEG only both DMBTR and DMBE2 are zero. If I look at the document via FB03 and drill into the line item it shows me that DMBE2 is the actual value, not zero. The data is in there somewhere, I just can't find it.
01-15-2009 3:12 PM
Hello Chris,
I think the secondary table to which the FI doc goes depens on doc. Type as well. I just posted a doc. using FBB1 and i can see the doc. in BSIS )
Which doc. type can you not find in BSIS?
BR,
Suhas
01-15-2009 3:24 PM
one more option: if the line item management is not ticked for the G/L account, the item is not saved into BSIS/BSAS (only into BSEG). You can check this in tcode FS00, or directly: SKB1-XKRES
01-15-2009 3:31 PM
Bingo! I will get will my master data group to correct this entry. Thanks for the help.
Chris
01-15-2009 3:39 PM
OK, one more thing: you'll need to run program RFSEPA01 after the master data has been changed, to create the missing entries in BSIS/BSAS.
01-15-2009 3:12 PM
Check BKPF-BSTAT for the missing items. I think you'll find that it is not blank in these cases. The actual value should give you an idea of what is going on.
Rob
01-15-2009 3:27 PM
I will answer to both of the previous comments.
The doc type I am not seeing in BSIS/BSAS is S (G/L Accounts).
BKPF-BSTAT is indeed blank (normal document).
I see nothing unique or special about the line items I am unable to find in the secondary tables. It appears to be identicle to the item that is in BSIS.