07-01-2015 9:35 AM
Dear all,
Can anyone please suggest that the table in which the G/L related pernr and its amount getting saved .
Which table to use .
Iam using BSIS(To fetch open items ), and BSAS(to fetch the cleared items ) .
BKPF also I am using .
07-01-2015 9:41 AM
Hi Deepak,
If you are using PERNR and GL related then BSIS and BSAS is fine but apart from this you can check in BSIK(for open item) and BSAK(for cleared Items) because PERNR no is related to employees and employees are treated as vendor so hope these tables will help.
Regards
Eugene
07-01-2015 9:41 AM
Here is useful link showing relation between FI and HR, which it sounds like you are looking for?
http://www.sd-solutions.com/SAP-Payroll-FI.html
Also, check table BSEG.
07-01-2015 3:02 PM
Some fields are not copied by default from BKPF and BSEG to BSIS/BSAS. So you may be require to read BKPF and BSEG once the records are selected from secondary index tables.
But BSEG cluster table preventing JOIN option, you will be required to use some FOR ALL ENTRIES and even with the full cluster table primary keys (RFBLG: BUKRS, BELNR, GJAHR) than can raise performance issues. Also you won't actually be able to select data with those criteria.
Hint: But you can append some structures to BSIS/BSAS (same fields in both structure for clearing) as the standard SAP programs use some CORRESPONDING statements to fill the secondary index so those fields will be filled in future documents. Just write a small "one run" report to update appended fields for already posted documents. (e.g. fields as PERNR, EBELN or ANLN1 are often useful)
Regards,
Raymond