‎2007 Jul 09 5:50 AM
hi friends,
i want create AR againg report.
i want some field details for data base fields.
1. Open A/R Balance
2.Credit Availability
3.Aging Buckets
4.Debit Total
5.Credit Total
6.Net Balance
please tel me data base table fields for this fields.
regrads
jai
‎2007 Jul 09 6:15 AM
Hi,
All the fields can be fetched using -
BSEG - Line items
BKPF - Header fields
In it, H- Creditl S - Debit
But be careful to use BSEG - it is a cluster table and contain too many records.
Get the help of the FI consultant.
<i>Get back to me if u want more info and dont forget to avoid points</i>
Regards,
Sridevi
‎2007 Jul 09 7:02 AM
For aging report you can use the function module
customer_open_items
This takes the customer number and company code as input and gives all the open items of customer in T_POSTAB tables parameter.
Thanks.