10-09-2007 10:37 AM
hi all,
I am fetching the data of main item from subitem of bom, the output is giving correctly.
But my selection criteria is bomcomponent and plant.
how to fetch the data plant wise also.
If I give bomcomponent in selection-screen , it gives all the plant details.
how to give the select query of that select options.
bomcomponent is in stpo table and plant is in mast.
thanks in adv
vidya.
Locating Main Item From Sub Item Of Bom
10-09-2007 10:52 AM
Hi,
MAST table has the field STLNR which can be used to retrieve data in combination with the plant.
Regards
10-09-2007 11:15 AM
hi sheldon,
thanks for ur reply.
if u don't mind tell me in detail.
I am not getting that one.
how to write the select stats for selectscreen of both bomcomponent and plant.
regards
vidya.
10-09-2007 1:45 PM
Hi,
Check the field WRKAN in STKO, see if its useful.
Else you will have to join the three tables STPO, STKO and MAST.
Regards
10-09-2007 11:10 AM
USe FM CSAP_MAT_BOM_READ or CS_BOM_EXPL_MAT_V2...
Best Regards, Murugesh AS