BATCH field has no Value

[Former Member]

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

[Former Member]

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

[former_member404244]

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

[kesavadas_thekkillath]

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

[Former Member]

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