PO and SO Payment

[Former Member]

Hi

I would like to pull payment information and the outstanding balance with regards to the PO and Sales orders.

1. What the table to be used?

2. What transaction can I verify that the reports is correct?

Thank you in advance

//psl

[Former Member]

Hi Andreas

Thank you very much for your information.

My objective is to get all the PO payment by date/month.

With your method, I have to get all PO in database, then look for data up to BSEG, then discard EKKO/BSEG records that are not in the user specified date/month, this will waste definitely cost too much of overhead to the server.

Any better suggestion?

Thanks again

//psl

[andreas_mann3]

Hi,

1) BSAK: all payments to your selection

2) BSEG -> find items with ebeln

( 3) ekko )

Andreas

[Former Member]

Hi

BSEG is a cluster table, to search for records by non-key fields like PO and clearing date sure will kill the program's performance, is there other alternative table that are more straight forward.

Some more, BSEG debit item GR/IR acount with PO data does not carry clearing information, instead it is the credit item for vendor account do carry clearing data.

So, BSEG may not be a good choice.

Apppreciate any more help. Thank you.

//psl

[andreas_mann3]

Hi,

this is the way you've to go:

-> EKKO 
    EKBE(ebeln)
     BSAK (bukrs belnr gjahr)
      BSEG (bukrs augbl gjahr)

regards Andreas

[Former Member]

Hi Mikko

In that way, if I want to get a list of PO payment in a certain month, I have to get all the PO, get the IR, FI document then filter out BSAK posting/document date, this seems wasting a lot of redundant processing time just to filter out payment done in a month that relates to PO.

In the other way, if I get a list of payment first, then trace back to PO information, how can I do that?

Shall I use BSAK to filter out by date then document type BLART first, then trace back to PO by FI documnet>IR>PO?

Another question, shall I use BSAK of REGUH?

Appreciate any help and any information. Thank you very much.

//psl

[Former Member]

Hi psl,

I think I found another way by looking at this with a pair of fresh eyes

I'm pretty sure you can just use table BSEG (acc doc line items) for your task. In the table, you can find the clearing date (AUGDT) and the PO number(EBELN), which should be more than enough. The clearing date indicates the payment date, if it exists yet.

So when going from PO to payment date, get the list of PO:s and with those look up the clearing dates from BSEG. The other way around, filter BSEG by e.g. clearing date and get the PO numbers.

Let me know how it works,

-Mikko

[Former Member]

Hi psl,

I don't have table names at hand now but what you need to do is to first get the PO/sales order number, look up the corresponding invoice and then check its clearing and/or payment status.

The payment information can be fetched from FI tables BSAK (vendor cleared items) and BSAD (customer cleared items), you just need the PO-specific invoice number as the key.

Hope this helps,

-Mikko