data base field

[Former Member]

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

[Former Member]

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.

[sridevi_p]

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

[Former Member]

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.