topic Re: ME23N : Material sub-components fields in Application Development and Automation Discussions

ME23N : Material sub-components fields

Former Member — Tue, 18 Dec 2012 09:54:02 GMT

Hi Experts-

Good day!

I would just like to ask if what table and field highlighted with red below refering to? This is a sub components of a line item (material) of ME23N. I check on table MAST then go to STPO. I found some fields in there but I just couldnt find the field for BATCH.

Your help is much appreciated. Thanks!

Re: ME23N : Material sub-components fields

kakshat — Tue, 18 Dec 2012 09:59:13 GMT

Did you check table MCHA? Field CHARG is batch.

Re: ME23N : Material sub-components fields

Former Member — Tue, 18 Dec 2012 10:02:13 GMT

Yeah I did. But how is it related to components of the specific line item? In the screenshot I've attached, I check the MCHA table witht he material. I saw values of the CHARG and I am not seeing it on the ME23N though.

Re: ME23N : Material sub-components fields

JL23 — Tue, 18 Dec 2012 10:15:06 GMT

subcontract components to a purchase order are stored in table RESB

the user has to enter the batch in the PO manually.

In the consumption it can be done using batch determination.

Re: ME23N : Material sub-components fields

Former Member — Tue, 18 Dec 2012 11:48:40 GMT

Like how would I do that? I mean how do I connect the PO details to table RESB in order to get the value of the field BATCH?

Re: ME23N : Material sub-components fields

JL23 — Tue, 18 Dec 2012 12:16:37 GMT

RESB table has a field EBELN which has the PO number , EBELP with item number, and EBELE for the schedule line.

So it should be pretty easy to get from the EKPO to RESB

Re: ME23N : Material sub-components fields

Former Member — Tue, 18 Dec 2012 12:35:09 GMT

Just noticed that. Ahmn, my problem is during creation of STO and then before saving the PO there should be checking if the line item has components. I did the checking via tables MAST and STPO.

Now if the line item has components, retrieve the value of the BATCH of each of the components of the line item.

Please do correct me if I'm wrong, with your suggested solution I don't think that would work upon CREATION of the PO.

Re: ME23N : Material sub-components fields

JL23 — Tue, 18 Dec 2012 12:50:15 GMT

Please explain your scenario in a whole, all those fragments are very confusing

Re: ME23N : Material sub-components fields

Former Member — Tue, 18 Dec 2012 12:57:25 GMT

Using table RESB during CREATION of STO will not work. As you said EBELN, EBELP, and EBELE will be used to connect PO to RESB to get the value of BATCH. However since this is still in CREATION stage of the STO, no data on table RESB will be retrieved yet.

Re: ME23N : Material sub-components fields

JL23 — Tue, 18 Dec 2012 13:33:24 GMT

Please explain your goal? what do you want to achieve? I assume you want do something with ABAP because it is here the ABAP forum.

Re: ME23N : Material sub-components fields

Former Member — Tue, 18 Dec 2012 13:53:39 GMT

Create STO.
Upon saving of STO, the following will be executed :

If line item has components, custom recalculation will be done.
If line item has no components, leave as is.

I used table MAST and STPO to check if the line item/material has components. This is done.

Now, my problem is the screenshot sent by the user (from Production system) has values on the batch field in which those values are numeric.

Those values will be used for the custom calculations. Of course the custom recalculation is done on the user exit of the ME23N.

I don't know how did the user entered the numeric values. I've already asked it but the user in on Vacation Leave. I couldn't find the table to retrieve the values.

I checked table MCHA. I saw some values but it is not appearing in the screenshot.

Re: ME23N : Material sub-components fields

JL23 — Tue, 18 Dec 2012 14:54:38 GMT

when a user creates the pruchase order with ME21N and goes into item detail material tab and clicks the component button, then he is able to enter a batch number to the component.

this batch number will then be seen in RESB table and is validated against table MCHA while entering

Re: ME23N : Material sub-components fields

Former Member — Wed, 19 Dec 2012 05:33:26 GMT

Thanks to this man!