09-17-2008 1:01 PM
Dear All,
I am stuck up with an issue and hope to get some help from you.
This is realated to BOM Linking.
I want the link between BOM component and its BOM Characteristic Value.
For your reference i will give the navigation.
Go to CS02 Transaction and give any material and plant as input and select 1 for BOM usage and press enter. Then select any one BOM component and go to Extras in menu bar.
Extras -> Batch classification.
In the next screen in the last subscreen you will find the characteristics maintained against that BOM component.
I just want the link from BOM component to that characteristic Value.
Can you tell me how i can find out.
I tried INOB table but not getting exactly what to pass in INOB-OBJEK.
what is the combination that i have to give.
Thanks for your help in advance.
Regards,
Ravi Kiran
09-17-2008 1:18 PM
09-17-2008 1:12 PM
09-17-2008 1:23 PM
No Dude
I wont get the batch number there .
i should get the link between only raw material and characteristic values
Regards,
Ravi
09-17-2008 1:18 PM
09-17-2008 1:19 PM
09-17-2008 1:29 PM
09-17-2008 2:12 PM
09-17-2008 1:42 PM
Please see the select quiries below.
*LOADING FINISHED MATERIALS INTO AN INTERNAL TABLE
select matnr
mtart
into table it_mara1
from mara
where matnr in so_matnr
and mtart = 'FERT'.
if sy-subrc = 0.
sort it_mara1 by matnr.
endif.
*LOADING CORRESPONDING FROM Material to BOM LINK TABLE
if it_mara1 is not initial.
select matnr
werks
stlan
stlnr
stlal
into table it_mast
from mast
for all entries in it_mara1
where matnr = it_mara1-matnr .
if sy-subrc = 0.
sort it_mast by stlnr.
endif.
endif.
*LOADING CORRESPONDING BOM COMPONENTS FRON BOM ITEM TABLE
if it_mast is not initial.
select stlty
stlnr
stlkn
stpoz
idnrk
meins
menge
preis
peinh
from stpo
into table it_stpo
for all entries in it_mast
where stlnr = it_mast-stlnr.
if sy-subrc eq 0.
sort it_stpo by stlnr.
endif.
endif.
Hope this will help you,
With best wishes,
Murthy.
09-18-2008 4:59 AM
Hey Murthy,
I too am clear till there.
Lemme explain this more clearly.
Ultimately i need to hit Ausp table to get the characteristic value.
For this i wanted the Object Number.
This Object number would be stored in inob table in the combination of stlty stlnr and some other field.
When i give this combination and the class type '023' and table as 'STPO', i will get the object number.
Now the problem was earlier i was concatenating STLTY STLNR STLKN
but when there are any changes done at the BOM level the STLKN goes on increasing but in INOB table it remains some other value and that was what i was trying to find out.
Finally i got the solution but dunno if its ryt but my object is workin fine.
I got this field in STZU -CLSMX.
Anyways thanks for all your help.
Will surely give some points for all.
Hope this is fine.
Regards,
Ravi Kiran.
09-18-2008 5:01 AM