open items and closed items

[Former Member]

Hi,

I am working on a report,where there is a field called status.In this field I have created 3 select options(active,balance out,archive).In XK02 transaction when i enter the vendor number,company code,purchase organisation and select the archive option from the status field and try to save it,then it should check if there are any open PO's or SA's for that particular vendor.If there are any then it should give an error message.This is working fine and I am getting the error message for open line items.If I want to check this for closed line items how can I do that?How can I get the closed line items for that particular vendor?

Regards,

Hema

[Former Member]

Hi,

I am working on a report,where there is a field called status.In this field I have created 3 select options(active,balance out,archive).In XK02 transaction when i enter the vendor number,company code,purchase organisation and select the archive option from the status field and try to save it,then it should check if there are any open PO's or SA's for that particular vendor.If there are any then it should give an error message.This is working fine and I am getting the error message for open line items.If I want to check this for closed line items how can I do that?How can I get the closed line items for that particular vendor?

Regards,

Hema

[varma_narayana]

Hi Hema..

you can find the Status of PO in table EKBE. (PO history)

Vendor Open Items Table (BSIK)

Closed items Table (BSAK)

Reward if Helpful

[Former Member]

Hello Hema,

I didn't get your situation but, i came accross same type of situation.

i just went through VAPMA table there i got KUNNR and POSNR for a material number and i checked in VBUP table for the status using KUNNR and POSNR. The field in VBUP is LFGSA.

Reward If Helpful.

Regards

--

Sasidhar Reddy Matli.

Message was edited by:

Sasidhar Reddy Matli