Fetch Purchase orders based on Internal Order

[Former Member]

Hi Experts,

I want to fetch purchase orders by passing internal order. Any Table or Fuction Module exists whcih has this functionality? please advise

Thanks in advance,

Chintu

[Former Member]

Hi Manjunath,

Actually, i have checked in se16...in the table ANEK, the purchase order(EBELN) filed has no value.

Thanks

Chintu

[Former Member]

whats this internal order exactly? which field/table ? how r u getting this internal order

[Former Member]

Hi Manjunath,

When I pass Asset No (ANLN1) and Comp code(BUKRS) in table ANLK, i get the internal order (OBJID).

Based on this Internal Order (OBJID), I want to fetch Purchase Orders.

Thanks

Chintu

[Former Member]

Thanks for ur reply.

I did where used list on this OBJID.

I found its used in ANEK.

if you pass OBJID in ANEK table ,you will get EBELN.(pur order)

[Former Member]

Hi Manjunath,

I have tried this. But the problem is the field EBELN (Purchase order) is not getting populated in this table ANEK.

Thanks,

Chintu

[Former Member]

May I know whats the internal table declaration u have used.Whats the select query you have used.

[Former Member]

Hi Manjunath,

Actually, i have checked in se16...in the table ANEK, the purchase order(EBELN) filed has no value.

Thanks

Chintu

[Former Member]

Then for that OBJID there is no EBELN. Thats not ur issue.

u can try checking in Quality System or any other systems.

I am not sure what your requirement is?

[Former Member]

Hi Manju,

I will explain with an example. In the Tcode ME23N, for the purchase order (1610000003), the internal order is 200005.

As you said, if i pass the OBJID(200005) in table ANEK, the EBELN value should be 1610000003 which is not in our case.

Hope this clears your question.

Thanks

Chintu

[Former Member]

Thanks for your reply.In ME23N screen, which tab i can find the internal order field

[Former Member]

In ME23N, for CAPEX PO, in the tab 'Accont Assignment', the field label is 'Order'

[Former Member]

Hi,

You can fetch purchase orders using IO thru table EKKN.

Kath

[Former Member]

Hi Kathy,

Thanks for your answer.

The table EKKN is for getting the internal orders by passing the purchase order. But i want the other way around i.e. Fetch Purchase orders by passing the internal order

Thanks

Chintu

[matt]

Same question posted while logged in as

Any explanation, or should we delete both ids?

matt

[Former Member]

Hi Matt,

I was suprised to see this. I have logged into my ID and when i have posted the question, the question didn't show in my ID.

Next time, i have logged into my ID again posted then it worked. Later on, i realised that the question was posted from some other ID. I dont know where was the problem? please advise.

Thanks,

Chintu

[Former Member]

I assume that because this thread is talking about tables that relate the PO and IO that SAP does not provide a standard report showing the relationship. Is this true? i have been searching for just that kind of report.

[Former Member]

Hi,

Standard report is available in SAP. Purchase orders with reference to internal orders can be listed using Tcode ME2K.