topic Re: Performance problem object classification in Application Development and Automation Discussions

Performance problem object classification

former_member595421 — Mon, 02 Mar 2020 21:50:37 GMT

Hallo experts,

I have a requirement to read the classification value of network plan and display it in ALV, for this work I have found the function module claf_classification_of_objects and it worked some how. My issue is that I have almost 300 network plan and by using this function module I have performance problem.

By searching for alternative, I have found out new Function Module: RFC_SELECT_OBJECTS_VIA_CLASS. By this function I can give the Class and I will receive all the objects, which have this class in classification. My problem is, I don't know how can I get the result, what come out from this function module, because the results is somehow displayed in Dialog and I have no idea, how can I get in in internal table or so on.

Does some one have any idea, how can I work around with it? Any kind of help would be greatly appreciated.

Best regards

Ton

Re: Performance problem object classification

RobertVit — Tue, 03 Mar 2020 06:32:35 GMT

Hi,

try function module CLAF_OBJECTS_OF_CLASS or call the RFC in parallel for faster runtime

Re: Performance problem object classification

Sandra_Rossi — Tue, 03 Mar 2020 08:08:50 GMT

Why do you use function modules which are not released by SAP, while there are officially-released BAPIs?

BAPI_CLASS_SELECT_OBJECTS

Re: Performance problem object classification

former_member595421 — Tue, 03 Mar 2020 21:04:00 GMT

Hi Rossi, thanks for your answer.

Let me explain a little bit more so you can better understand me. I just need to get the characteristics description in classification of network plant objects. The FM claf_classification_of_objects works, but I causes performance problem and im now trying to deal with it.

I have tried this BAPI you mentioend, but the problem here is, by this BAPI I get a table back (objectclassification I think so) and in this table there are only the internal number of the characteristics. What I really need here is the description from these characteristics, and when I do select again in those table like CABNT or CAWNT I again have performance problem. Secondly, in this table there are only the internal number of the objects from table INOB, not the number of the network plan, what I have (yes I know through the network plant number what I have I can get the internal number from table INOB, but its again performance problem by doing select in table INOB).

The FM RFC_SELECT_OBJECTS_VIA_CLASS give me exactly what I need, but as I mentioned, I have no idea how can I get the result back, because it was displayed in form from dialog (also not in Tables or Exporting like normal function module). I hope you can understand what problem I have. In any case, further tips are appreciated.

Thanks again and regards

Ton

Re: Performance problem object classification

former_member595421 — Tue, 03 Mar 2020 21:06:47 GMT

Hi Robert,

thanks for your answer. I will try this FM and will give you feedback, whether the fm helps me.

Regards

Ton

Re: Performance problem object classification

Sandra_Rossi — Wed, 04 Mar 2020 07:41:36 GMT

First of all, you should prefer officially-released function modules. They are supported by SAP, if there are performance issues, you may eventually get some help from SAP support.

If you have performance issues, you should use transaction codes SAT, SQL trace and its execution plans, and so on (eventually via Eclipse ADT) to determine the origin, then you can find a solution. It's difficult to help without further analysis from your side.

Re: Performance problem object classification

Sandra_Rossi — Wed, 04 Mar 2020 07:44:53 GMT

It's interesting that you experience performance issues simply while querying CABNT and CAWNT; can you show and explain what contain the input values of those SQL queries and show the execution plans via the SQL trace please?

Re: Performance problem object classification

kjyothiraditya — Wed, 04 Mar 2020 14:33:03 GMT

Hi ,

If your network plan her/item has material, you can pass this to inob and using the cuobj, you can pass to klah, kssk. Similarly pass the value from these to cawn / cawnt/cabn/ausp table.

Match the table using key fields or common fields.

I think you are using FM in a loop and this is causing performance problems.

Please let me know if this is helpful.

Re: Performance problem object classification

kjyothiraditya — Wed, 04 Mar 2020 14:36:58 GMT

Also please check this link Material classification tables

Re: Performance problem object classification

kjyothiraditya — Wed, 04 Mar 2020 14:41:05 GMT

ps-database-tables