Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

data base field

Former Member
0 Likes
406

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

2 REPLIES 2
Read only

sridevi_p
Active Contributor
0 Likes
378

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

Read only

Former Member
0 Likes
378

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.