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,
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.
No comments:
Post a Comment