Transparent table for CN41n field - Object type text

[Former Member]

Hi Friends

I am PS/PM consultabt. Working on PS since last 2 years.  This is really a very good forum. Got the answer for my questions most of the time.

I am looking for table for object type text on CN41n report to extract in BI report. It looks like control key descr. But its deifferent than in T430T.

Tried to find through SQL trace, but couldn't get exact table.

Descr on CN41n is "Int. Processed Activity" while control key descr is Network - Internal Processing

Appreciate if any one can find the relevant table.

thanks

[former_member612769]

Hi Bhavesh,

We have a similar requirement of bringing this report data into BW side. Can you please tell how did you bring this report CN41N to BW side. Did you use any standard Datasources to extract data?

Thanks in advance.

Regards,

Madhav

[Former Member]

CN41N builds its data based on the Logical Database PSJ.  Use SE36 to invesigate LDB PSJ.

Also, look in SE80 for package KAP0.  You should find the object type text table there.

[sanjeevc]

NW/Order and it's activity related table as mentioned below:

AUFK	Orders/networks headers
AFKO	Production Orders/networks
AFVC	Network activities
AFVU	Network activities
AFVV	Network activities
RESB	Network Components

Regards,

Sanjeev

[Former Member]

I have checked all basic tables for activities & n/w order and search help in ABAP dictionary. Requirement is business wants to see this field info in BI report. For that we need table to extract from.

Last option is debug, but being it a report, its very long program. We got a work around by getting control key descr. But the hunt is still on for exact table.

thanks

Bhavesh

[Former Member]

Hi,

Are you looking for Internally processed activity description? if so you better AFVC so that it has every thing related to actitivies.

Thanks,

Sudhakar

[Former Member]

Hi Sudhakar

I've already checked AFVC, but it didn't carry that descr. Field is OBJEKTTYP from Struct STRUCR in CN41n & that is not in AFVC.

thanks

Bhavesh

[Former Member]

Hi Bhavesh,

The output from CN41N are displayed from cluster of tables and rarely from individual level. So it is difficult to pin point exactly from which table the data is being displayed in CN41N. The only way is to find out "debug' the program to find out.

Else, find out from individual tables. If you don't mind can you rephrase your questions what you are looking exactly. sorry about that.

Did you get a chance to look into the other tables what Sanjeev has given to you.Still you can not find out what you are looking for then debug the CN41N program and find out.

Thanks,

Sudhakar