Application Development 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: 

problem with customer ACCOUNT BALANCE LIST

Former Member
0 Kudos

hi all ,

i want to create custmor a/c balance list LIKE below .

-


USER INPUT SCREEN -


Company code:

Fiscal year:

Customer no:__________ to _____

Document no:________ to ______

Posting date:________ to _______

-


I WANT TO DISPLAY REPORT LIKE THIS----


customer ACCOUNT BALANCE LIST(CENTERED)--heading

Company code(left justified)

Fiscal year(left justified)

-


Customer no: bsid-kunnr

Name: kna1-name1

Docu no: bkpf-belnr

Posting date: bkpf-budat

Ref text: bsid-sgtxt

Amount: bsid-dmbtr

-


PLZ SEND CODE FOR THIS OUTPUT

plz help me to display like this .

Edited by: raju on Sep 2, 2008 12:36 PM

3 REPLIES 3

Former Member
0 Kudos

hi raju,

this code u have to write in header part means in top-of-page event.

write : /60 'Customer Account Balance sheet' , centered color 2.

write: / 'Company code' , itab-compnycode left-justified.

write: / 'Fiscal year' , itab-year left-justified.

uline

write 😕 'Customer no:' , bsid-kunnr left-justified.

write 😕 '....................'.

write 😕 '....................'.

uline

instead of itab and bsid,kna1 use variables and like wise u can do for other fields .

And for body-part data use write statement for displaying.

and for this report u can do with write statement easily.

thanks,

Sanket.

0 Kudos

thanks for ur time sir ,

topofpage is k,

but how can i write select statements for this data retriving .

former_member184551
Contributor
0 Kudos

there is so much of code in the system already available for this. please do some research before posting, I dont think any one will send u the whole "code" for this.

check out these BAPI's

API_AR_ACC_GETBALANCEDITEMS Customer account clearing transactions

BAPI_AR_ACC_GETCURRENTBALANCE Closing balance of customer account

BAPI_AR_ACC_GETKEYDATEBALANCE

BAPI_AR_ACC_GETOPENITEMS Customer account open items at a key date

BAPI_AR_ACC_GETPERIODBALANCES Posting period totals per customer

Check out the FM 'Customer_balance'.

useful tables:

customer

bsid- for open items

bsad- for cleared items

Vendor

bsik

bsak

Use the clearing dates and posting dates for ur selection.

also see bkpf and bseg..(clsuter table so be carefull.)