COSP-OBJNR, finanace

[Former Member]

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.

[pole_li]

Hi,

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

Regards,

Pole

[Former Member]

there was some other issue with the report..

[RaymondGiuseppi]

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