Outstanding and Completed PO in MM

[former_member367551]

Dear forumers,

An outstanding PO is defined when a storekeeper has not done goods receipt and / or the account department has not done their invoice receipt.

A completed PO is defined when both goods receipt and invoice receipt have been completed for the PO.

How can I check for these conditions from the MM tables in the ABAP Dictionary? Which combination of fields can I refer to for this? I cannot simply rely on the EKBE-ELIKZ (Delivery Completed) field, can I?

Please help. Thank you!

[Former Member]

Hi ,

Check table EKBE -->to get MIGO/MIRO details , based on that u can find out.

regards

Prabhu

[former_member367551]

Prabhu,

I understand that MIGO (Good Receipt) and MIRO (Invoicing) are the correct MM transactions for this, but I need to know which fields are used for checking the outstanding / completed PO status. Any further hints?

[Former Member]

Hi D ,

Quantity , what else ? .

say my PO got 2 line items .

PO + 10 ---> 100kgs

+ 20---> 100kgs.

PO+10->MIGO->50KGS->MIRO--->50Kgs.

MGO---->25Kg->MIRO->25Kgs.

so all these data will be avail. in EKBE table, so here PO+10 got openb qty of 25Kgs , So u need to sum up all MIRO qtys/MIGOqtys to know the Open.

Regards

Prabhu

[Former Member]

hi,

Pass the po number(EBELN) and check the Movement Type((BWART) is '101' is it is true then the Good receipt has taken place and proceed with other checks ...

Hope it helps.

Regards,

Vikram.S

[former_member367551]

Vikram,

Thanks for the information here.. I've checked through the BWART field and I'm wondering, what do other BWART values stand for?

E.g. 101 - Goods receipt done, 102 - ?, 543 - ?, and there are even empty values here

[former_member184657]

well.. there are a hundred other(or more) movement types.

It depends on what your clients use.

Eg over here my clients use -

101 for Goods receipt

102 for Goods return

122 for Goods cancelled

412 for sale order

541 for Goods Issue

543 for consumption

301 for plant to plant transfer etc

You can go to MB51 report and do an F4 on Movt Type field to get a list of all Movement types

pk

[former_member367551]

Dear experts,

Is it sufficiently alright to have the following conditions:-

Outstanding PO

EKPO-ELIKZ = ' ' or

EKPO-WEPOS = ' ' or

EKPO-REPOS = ' '.

Completed PO

EKPO-ELIKZ = 'X' and

EKPO-WEPOS = 'X' and

EKPO-REPOS = 'X'.

[former_member367551]

Outstanding PO
EKPO-ELIKZ = ' ' or
EKPO-WEPOS = ' ' or
EKPO-REPOS = ' '.
Completed PO
EKPO-ELIKZ = 'X' and
EKPO-WEPOS = 'X' and
EKPO-REPOS = 'X'.

I just had a confirmation that the EKPO-ELIKZ field does not need to be checked for an outstanding or a completed PO.

Thanks for all the help!