topic Data Selection from COSP table in Application Development and Automation Discussions

Data Selection from COSP table

Former Member — Mon, 15 Sep 2008 08:36:54 GMT

hi Experts

How to fetch data from COSP based on OBJNR.

Regards,

Amit Kumar

Re: Data Selection from COSP table

Former Member — Mon, 15 Sep 2008 08:49:21 GMT

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.

Re: Data Selection from COSP table

Firoz_Ashraf — Thu, 18 Sep 2008 09:55:41 GMT

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.