List of Unreleased PO s Based on Approval User id

[Former Member]

Hi All,

Me having an urgent requirement.

Actually we need to get all the list of Unreleased PO s based on the Approval User id (Usder Id of the  person who is responsible for the approval of PO).

Any standard FM ? or any other solution?.

Thanks in advance,

Biju.

Moderator message: please do some research before posting, do not flag your issues as "urgent"

Message was edited by: Thomas Zloch

[former_member585060]

Hi,

     Check the EKKO table for details regarding your requirment.

Identify what type of Purchase Order have Release Strategy.

EKKO-BSART.

Then check for the value of EKKO-FRGKE is. If is in 'B' means still the PO is not released and if it has 'R' then that means the PO is released.

Your SELECT on EKKO should be based on the AUART, ERNAM and FRGKE.

SELECT ebeln

                       FROM ekko

                       INTO TABLE i_ekko

                       WHERE auart = 'CP'  "For ref. i gave 'CP' Capital PO which require Release Strategy

                        AND      ernam = '  '  " user name who has to still approve

                        AND      frgke   = 'B'.

I_EKKO will have all the PO for that user which are still pending for approval.

If you ERNAM is not the Approval user name, you must check on the Release Strategy defined.

Thanks & Regards

Bala krishna