Need to identify the PO's with delivery address Blank in ME23N

[former_member200650]

Hi All

I have a requirement to monitor daily for the PO's which are having delivery address with Blank. Mainly the PO's which are linked with sales order. i.e. 3rd party, IPO sales orders.

In fact I need to find out for all PO's which are not having delivery address. The reason why I am not considering the other PO's which are not linked with Sales order is for standard PO's delivery address is copied from Plant or Storage location. Since it is a configuration normally I do not see any changes in PO delivery address.

Other Information:

in our client scenario normally what happens after creating sales order, PR gets generated followed by PO gets created using batch job. After PO creation some times what happens user goes to sales order ship to address and change the address. Due to this in PO (ME23N) the delivery address getting blank. since there is no address for that PO delivery is not getting created.

thanks

[former_member197616]

In third party normally it is the customer address to which the po to be shipped by vendor.

pl check the partner functions

[former_member200650]

Hi Sai

thanks for your reply. I checked the Customer ship to address which is different than the delivery address in PO. In this case the delivery is done by vendor to Plant address only. It is like IPO sales.

thanks

[Lakshmipathi]

Pass the PO references in EKPO table and check for the field ADRN2. Wherever, this is blank, the delivery address in the respective PO would be blank.

[former_member200650]

Hi Lakshmipathi

Thank you for your reply! I tried but still address is showing.

I checked with ADNRNR field also in EKPO table. When both ADRNR and ADRN2 field are blank but still the address is showing in Me23n.

Thanks