topic Re: data base field in Application Development and Automation Discussions

data base field

Former Member — Mon, 09 Jul 2007 04:50:59 GMT

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

sridevi_p — Mon, 09 Jul 2007 05:15:48 GMT

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 — Mon, 09 Jul 2007 06:02:19 GMT

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.