topic BATCH field has no Value in Application Development and Automation Discussions

BATCH field has no Value

Former Member — Tue, 09 Aug 2011 11:36:53 GMT

Hi Experts ,

I want to fetch Material No, Batch and Quantity by passing Production Order No and Movement Type = '261' from MSEG table .

I can't do direct select queries as i have to use the logic in side Loop EndLoop , so i am in search of any BAPI or FM .

I have checked BAPI_PRODORD_GET_DETAIL , but its not showing any values in BATCH fields under the table parameter COMPONENT where as Maetrial , Quantity are shwoing . If i check in table MSEG for the same PRD Ord no and Movement type Materials with Batch are showing .

Suggestion for any solution if anything i am missing in running this BAPI . Or any Other BAPI or FM for fulfilling my requirement will be highly appreciated .

Thanks

Prabhu

Re: BATCH field has no Value

former_member404244 — Tue, 09 Aug 2011 11:46:27 GMT

Hi,

In MSEG table you will find only the material document... You need to check AFPO table for production order.

You are using correct bapi to read the production order details.

Regards,

Nagaraj

Re: BATCH field has no Value

kesavadas_thekkillath — Tue, 09 Aug 2011 15:21:08 GMT


I can't do direct select queries as i have to use the logic in side Loop EndLoop

Select the data outside the loop and use the data inside the loop. Suppose if you are calling function module inside the loop are you sure that the select will not be executed multiple times inside the fm ?

Kesav

Re: BATCH field has no Value

Former Member — Tue, 09 Aug 2011 16:33:42 GMT

Hi Thanks for the suggestion.

I cant do selection of data before the loop . Anyway its my requirement .

My query is i have used the BAPI - BAPI_PRODORD_GET_DETAIL to get the Material No , Batch and Quantity from MSEG based on

the Production Order No and Movement type = '261' . But i am not getting the Batch No in the output table parameter of Component , through MSEG table has Batch No .

If you can suggest me some solution why the BATCH no is not getting populated in the BAPI .

Thanks

Prabhu