topic Re: COSP-OBJNR, finanace in Application Development and Automation Discussions

COSP-OBJNR, finanace

Former Member — Sun, 01 Jun 2008 15:57:13 GMT

hi all,

i have to apply a select query on COSP table. and it is giving a performance issue.

but the problem is there is a field OBJNR within primary key.

but my senior designers told me, that OBJNR is an internally generated field and can not be put in selection screen. but i guess there is some pattern in the field.

the field itself is a 20 CHAR field.

first 2 char are generally KS or EO in my case (i dont know if there are others as well), then the next 4 and 4 are related to cost centres i guess..

is there a fixed pattern through which i can fill those fields and performance can be improved?

kindly help and provide details or links to references.

Re: COSP-OBJNR, finanace

pole_li — Mon, 02 Jun 2008 03:08:30 GMT

Hi,

For "KS", you can get the OBJNR from table CSKS, use cost center number as select-criteria.

Regards,

Pole

Re: COSP-OBJNR, finanace

Former Member — Mon, 30 Jun 2008 06:02:36 GMT

there was some other issue with the report..

Re: COSP-OBJNR, finanace

RaymondGiuseppi — Mon, 28 Jul 2008 06:11:08 GMT

First two character give the object type in CO :

- OR - order - AUFK

- PR - WBS - PRPS

- KS - cost center - CSKS

- KL - cost center / activity - CSSL

- etc. (look at table TBO01)

In the associated table there is a field OBJNR and the usual key fields like order number, project id, cost center id, etc.

Regards