Fields Required

[Lokeshchemiti]

Hi All ,

I'm working on a report related to BOM , regarding  this Where can i get the details of BOM Quantity,BOM Value,Issue Quantity,Issue value .

Any Transaction or Table Details ?

Thanks & Regards,

CLC

[former_member211676 · Accepted solution]

Hi CLC

If you required for components issued to a Production order along with quantities and values You can use COOIS transaction by selection Documented goods movement in List field.

Or

if you required Masted Data BOM details then go through the tables

STPO- BOM item details

STKO- BOM header details

Regards

kesava

[former_member209265]

Hi CLC,

First of all your logic is correct.

I think you wanted to know which table you will get the value. Not the transaction.

BOM related tables are :

STPO- BOM item details

STKO- BOM header details

From here you will get BOM qty, BOM value.

In AUFM you will get Issue qty and Issue value.

Still I am surprised why you can't see it fron COOIS/COOISPI in view as "Component" in list. Please refer the screen shot.

Regards,

Krishnendu.

[Lokeshchemiti]

Hi Krishnendu ,

Thank you ,

And apologize for not posting that i come to know those details in COOIS/COOISPI with the help of you, kesava and Ramagiri .But ,I wanted to know where these details will be maintained, as posted in my previous reply .

Thanks & Regards,

CLC

[Rains]

create LTP data through 1. MD61 says Material (FG) ABC = 500 If you look at Material (FG) ABC in CS03, it has components and multilevels. 2. Create Scenario MS31 3. Run LTP MS02 If I run MS04 it is not the same as in CS11. In CS11 I input Material (FG) ABC and the reg qty is 500. What should I do to make MS04 the same as CS11?

[Lokeshchemiti]

Hi All ,

From MBEW table,shall i take the BOM Value in the following logic ?

If Price Control Indicator is V,then selecting Moving Average Price as BOM Value

or

if Price Control Indicator is S,then selecting Standard price as BOM Value .

And also i wanted to know where these details(BOM Qty,BOM Value,Issue Qty,Issue Value) will be maintained( In which Transaction ) .

Please suggest .

Thanks & Regards ,

CLC

[former_member209265]

Hi,

Correct. Now where is the problem?

Regards,

Krishnendu.

[Lokeshchemiti]

Hi Krishnendu ,

Thank u ,Now where can i get the BOM Value from ?

Thanks & Regards ,

CLC

[Former Member]

Hi CLC,

In COOIS - Select List as Components. In Layout select the fields as given below. It will display the BOM  Qty as Requirement qty, Withdrawn qty, Open Qty and Withdrawan qty value.

Thanks & Regards,

Ramagiri

[Lokeshchemiti]

Hi All & Kesava,Krishnendu ,

As you said ,i had changed the layout and took all the fields,but i am not able to get the required fields( issue qty,issue value,bom value) . Please suggest .

I am trying to take RESB-ENMNG(Quantity Withdrawn) field as issue quantity &

RESB-ENWRT(Value Withdrawn) field as issue value ,Is it correct ?

Thanks & Regards ,

CLC

[former_member211676]

Hi CLC

RESB-ENWRT is the value of goods withdrawn.

Regards

Kesava

[Lokeshchemiti]

Hi Kesava ,

Yes, can i use that field as i mentioned before .

Thanks & Regards ,

CLC

[former_member211676]

Hi

Yes.. you can use RESB-ENWRT(Value Withdrawn) field as issue value.

Regards

Kesava

[Lokeshchemiti]

Hi ,

Thank you , I am taking the BOM Value from MBEW in the logic as explained in my last reply and

I wanted to know where these details(BOM Qty,BOM Value,Issue Qty,Issue Value) will be maintained( In which Transaction ) .

Thanks & Regards ,

CLC

[Lokeshchemiti]

Hi all & kesava ,Ramagiri,Krishnendu ,

I tried to check COOIS transaction by selecting Documented goods movement and Component .

But i didn't found the BOM Value,Issue Quantity,Issue Value in that .

Please suggest .

@ Anupam Sharma ,Thanks for the reply but i don't want to add the additional fields in the standard transaction COOIS .But actually, i want to add these fields in the custom report .Please suggest .

Thanks & Regards ,

CLC

[former_member211676]

Hi CLC

In coois or cooispi you need to change layout as per your requirement. You can make your own layout 

by red circled icon in below coois screen snap.

Regards

Kesava

[former_member211676]

Hi CLC

If you want to write a customized report for  Production Order consumption, I am giving some of fields which is useful.

Material

Quantity (WITHDRAWN)

Base Unit of Measure

Usage qty per UoM

Price

per

Plant

SLoc

WhN

Typ

Supply Area

Backflush

Conf. qty

Conf Scrap

RESB/MATNR

AUFM/MENGE

AFUM/MEINS

RESB/ESMNG

RESB/GPREIS

RESB/PEINH

RESB/WERKS

RESB/LGORT

RESB/LGNUM

RESB/LGTYP

RESB/PRVBE

RESB/RGEKZ

AFKO/IGMNG

AFKO/IASMG

Regards

Kesava

[former_member209265]

Hi CLC,

Change the layout and bring all the fields in display as required by you. As well short as per the order so that for one order you can see the document and BOM related quantity..

Regards,

Krishnendu.

[Anupam1143]

Hi CLC,

You can implement BAdi WORKORDER_INFOSYSTEM for adding the additional fields in COOIS.Also check this document:

.

Regards,

Anupam Sharma

[former_member209265]

Hi CLC,

For report related to production order go to COOIS and for process order go to COOISPI. Select Component in "List". Adjust the layout and bring the required field in display. All the value you can see.

In this reports you can search by material also which will give you the related orders and corresponding BOM Quantity,BOM Value,Issue Quantity,Issue value.

To check only BOM quantity use CS11 or CS12.

Regards,

Krishnendu.

[Former Member]

Hi,

Refer COOIS report -Components list it will display the BOM components, quantity, Issue qty, Value etc.

Thanks & Regards,

Ramagiri