09-15-2008 9:36 AM
hi Experts
How to fetch data from COSP based on OBJNR.
Regards,
Amit Kumar
09-15-2008 9:49 AM
Hi,
Objnr is the primary key field of table ONR00 therefore this table is the checked table of COSP.
select * from cosp where objnr = onr00-objnr.
Hope this helps.
Regards,
Darpana.
09-18-2008 10:55 AM
Hi !
You have to concatenate some fields first depending on your data fetch for order, project or cost centre.
For example the object number for cost centre could be a combination of controllng area, cost centre etc.. Hence check the entries in table ONR00 ( the check table for Object number) and then make your select statement.
Regards,
Firoz.