Go to tcode SQVI.
Enter some name..like zserord. Create..
Data source: select table join
Click the insert table iconu2026enter the first table name
Again Click the insert table iconu2026enter the second table name
Then come back..
You will see all the fields in both the tables with two boxes next to each field..
The first box is the thing which you need to get in the output and the next box is for the inputting stuff..
Put tick mark in the relevant boxes according to ur requirementsu2026and execute...
COOIS Production Order Info System is the best available std report to view the Production Orders in Plant.However as per my knowledge, you can get serial number info at order level only in CO03 / CO02. Even though you will get order list in COOIS you will have to go to them single order wise.
You can get serial numbers at material level in MMBE / IQ03.But at order level you need to check for individual order as I mentioned above.
Pls. check above Tcodes.
Hope this helps.
Follow the procedure which kartik has given earlier. While selecting the fields for report you have to select the key fileds for selection screen from the both the table. Key fields only enable you to enter the selection criteria for the report.
Make note the key fields when you join the tables in table join mode.