topic Re: Fetch Purchase orders based on Internal Order in Application Development and Automation Discussions

Fetch Purchase orders based on Internal Order

Former Member — Fri, 03 Dec 2010 06:21:52 GMT

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

Re: Fetch Purchase orders based on Internal Order

Former Member — Fri, 03 Dec 2010 06:36:13 GMT

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

Re: Fetch Purchase orders based on Internal Order

Former Member — Fri, 03 Dec 2010 07:15:44 GMT

Hi,

You can fetch purchase orders using IO thru table EKKN.

Kath

Re: Fetch Purchase orders based on Internal Order

Former Member — Fri, 03 Dec 2010 07:17:04 GMT

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

Re: Fetch Purchase orders based on Internal Order

Former Member — Fri, 03 Dec 2010 07:40:25 GMT

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

Re: Fetch Purchase orders based on Internal Order

Former Member — Fri, 03 Dec 2010 08:02:56 GMT

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)

Re: Fetch Purchase orders based on Internal Order

matt — Fri, 03 Dec 2010 08:43:32 GMT

Same question posted while logged in as

Any explanation, or should we delete both ids?

matt

Re: Fetch Purchase orders based on Internal Order

Former Member — Fri, 03 Dec 2010 08:47:55 GMT

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

Re: Fetch Purchase orders based on Internal Order

Former Member — Fri, 03 Dec 2010 08:52:45 GMT

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

Re: Fetch Purchase orders based on Internal Order

Former Member — Fri, 03 Dec 2010 09:00:05 GMT

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

Re: Fetch Purchase orders based on Internal Order

Former Member — Fri, 03 Dec 2010 09:05:12 GMT

Hi Manjunath,

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

Thanks

Chintu

Re: Fetch Purchase orders based on Internal Order

Former Member — Fri, 03 Dec 2010 09:10:10 GMT

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?

Re: Fetch Purchase orders based on Internal Order

Former Member — Fri, 03 Dec 2010 09:30:37 GMT

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

Re: Fetch Purchase orders based on Internal Order

Former Member — Fri, 03 Dec 2010 09:44:10 GMT

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

Re: Fetch Purchase orders based on Internal Order

Former Member — Fri, 03 Dec 2010 09:53:59 GMT

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

Re: Fetch Purchase orders based on Internal Order

Former Member — Mon, 27 Dec 2010 15:54:13 GMT

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.

Re: Fetch Purchase orders based on Internal Order

Former Member — Wed, 31 Dec 2014 20:30:24 GMT

Hi,

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