To Calc Bill Discount,LC amount,Deposits,Cheque issue amt based on Bank key

105 Views

Hi,

I have a requirement where in I have to develop a report to display bank balance chart with the following details in the output.They are :

1. Posting Date

2. Bill Discount (BD)

3. Letter of Credit(LC)

4. Cheque Amount may be cheque issued.

5. Deposits.

Above are the information which i have to display based on Posting Date range , Company Code and Bank Key present in the selection-screen.

Below are my few observations:

1. To retrieve the Bill Discount, I am first fetching the data from BKPF table by checking the document types 'DZ' ,'KZ', Company code and Posting Date Range. Then using document number,company code present in these entries along with Posting key = 39 and special GL indicator = 'W' retrieving the data like DMBTR,WRBTR from BSEG.

2. Similarly for Letter of Credit amount retrieving the data in the same way as mentioned above except special GL indicator will be 'Y'.

Now please correct me if my approach is wrong. Request you all to throw some light as I am Technical Consultant and humbly looking forward to all your help.

Also, request to let me know the logic or process how one can calculate fourth point as well as Fifth point as mentioned above.

Regards,

Raghavendra Kulkarni.