vendor down payment list

[Former Member]

Hi

Sap Guru's

In my company client want report i have seen in google  also, but i didn't get proper information, he is asking each vendor wise down payment list along with PO number, posting date, amount and also with spl gl indicator. I have seen in BASK table level, at table level when i give Spl GL ind, it's not picking total line items comparing with PO history, And in the next step i remove Spl GL Ind, and given PO number then it's picking. Why all line items not coming comparing PO history by giving Spl GL Ind, is there any other way kindly give me suggestions

Regards,

Ramesh

[former_member198650 · Accepted solution]

Hi Ramesh,

You can get the details in the FBL1N repost also. Just click on special GL transactions indicator and execute it. Later you have to design your layout as per your need by selecting the required fields.

Regards,

Mukthar

[sanilbhandari]

Hi

If you are booking downpayments with reference to a PO, you may want to use ME80FN as well since it will list all the PO specific transaction per vendor

Regards

Sanil Bhandari

[Former Member]

Thanks for your reply,

But when i go this T.code ME80FN in this there no Spl GL Ind. my client want down payment list with reference of PO and document type also,

Kindly give me suggestions

[Former Member]

Thanks for your advice's experts,

But finally i got solution, no need to go any tables

Just went FBL1N and given all vendor and also selected Dynamic selection in that Spl GL Ind, Fiscal year Excute

Selected form layout Pur doc as aforesaid

Thanks

Ramesh

[Former Member]

Also check

we can get yearly balance for vendor and customer account with special GL indicator from table KNC3 and LFC3,KNC1 and LFC1 plzs check..below link..

http://scn.sap.com/thread/2011808

Regards

vamsi

[Former Member]

hi ... Pease find the some tables for PO history....

Sr. No  Field Text     Field Names  Table Name   Value

１         From Date    BUKRS BKPF Single values / ranges

２         To Date        GJAHR BKPF Single values / ranges

3          Doc type      BSART EKKO Single values / ranges

4          PO date       EBELN EKKO Single values / ranges

5          Created by   BEDAT EKKO Single values / ranges

6          GR Date      BUDAT EKBE Single values / ranges

7          Created by   ERNAM EKBE Single values / ranges

8          Invoice date  BUDAT EKBE Single values / ranges

9          Created by   ERNAM EKBE Single values / ranges

hope it will helps

Regards

Sudharsana

[Former Member]

Thanks for your reply svasmsi,

Can i get BSAK table level i aforesaid,

and what you given that tables also i checked