Used the BOM Comparison report (CS14).  It will compare two Bill of materials for you.

Table for BOM fields

How to find Table in which the field 'Item ID' in the BOM (T-code cs01/cs02) is maintained? I had tried T-code SE16, but could not found tables for BOM.  In technical help I could see that Field Name is 'IDENT' and Data Element is 'ITMID'.

<<<
The BOM tables are as follows:

MAST---->Material to BOM Link

STKO ---->BOM Header

STPO----->BOM item

Go and run this tables and you will get the desired detail

Pallab

<<<
I had already checked the following tables but could not find the desired result.

STKO ----BOM - header

STPO ----BOM - item

STAS ----BOMs - Item Selection

STPN ----BOMs - follow-up control

STPU ----BOM - sub-item

STZU ----Permanent BOM data

PLMZ ----Allocation of BOM - items to operations

MAST ----Material to BOM link

KDST ----Sales order to BOM link

Can somebody suggest something different. Most important thing is I could not find any tables linked to BOM in T-Code  SE16.

Navin

<<<
The field you are looking for is, in the Table STPO, and field name ITMID, with data element CS_ITMID.

They both refer to the "External identification of an item", which is reserved for the "External system item number" for that BOM (just a guess). In case you are transferring your BOM from an external system.

For your information:
Why is it ITMID instead of IDENT?

That's because, system stores data in a database table, but during transactions it uses temporary data carriers (e.g. structures) until the program finishes. When the program is finished, it writes the temporary data to the actual database table. In your case, the database table is STPO, and the temporary data carrier is the RC29P structure. The field IDENT in RC29P is displayed during CS01/CS02, but when you save the BOM, it's written to the corresponding database table STPO's ITMID field.

If you enter a number in this field while you are creating an item in the BOM, it will be written to the field STPO-ITMID. However, if you don't enter a number yourself, system will fill that information itself, with a sequential number. But this time, system writes this number to the STPO-STVKN field. Therefore, system has 2 fields in the database table STPO for this data, but during the BOM editing, it displays only one of these fields. If data entered by user, it's displayed, if not, the system-given automatic number is displayed instead.

This information i didn't know before, but i knew before the use of temporary data during transactions. So, i checked the field during CS02, and i saw that field is RC29P-IDENT, and i guessed that it was stored in STPO table. Then i checked the RC29P-IDENT and i saw it was CHAR type with length 8.  I looked for the fields in STPO with type CHAR and length 8, the rest was easy to find.

Osman Karslioglu

<<<
If you use the tcode:se11 , you will find out that , the field which you need is  in the JHEAD.  And the JHEAD is a structure.

Skywalker

<<<
Structure JHEAD and its IDENT field has no use with BOM data.

You can also test this information.
1. Create a BOM.
2. Enter a BOM item: item cat, material number, and quantity, and press enter. (you will see, system enters 00000001 into Item ID automatically)
3. Enter another BOM item: item category, material number, quantity, and Item ID (eg. enter "TEST"), and press enter. (you will see that your text is displayed in the Item ID).
4. Save your BOM.
5. Enter the BOM again with CS02 and display BOM header. note the BOM number (just below plant and material numbers) 6. Run SE16 and enter the BOM number you noted in step 5.
7. Check the fields STVKN and ITMID fields. You will see:

STVKN, ITMID
00000001, <blank> for the first BOM item.
00000002, "TEST" for the second BOM item.

But in transaction CS02, system displays the Item ID
00000001 for first BOM item, and "TEST" for second BOM item.

Osman Karslioglu

SAP PP Reference Books:
SAP Production Planning , Configuration, Interview Questions and Certification, Books

Goto:
SAP MRP - Materials Requirements Planning Configuration Hints and Tips 

Back to:
SAP PP (Production Planning) Configuration Hints and Tips

Return to :-
SAP ABAP/4 Programming, Basis Administration, Configuration Hints and Tips