Segregate report painter data from one cell to 3 cells

[former_member195427]

Hi Experts,

I have a hierarchy report created through report painter shown here:

The challenge here is to segregate data contained under 'Activity type' column into 3 different columns because our users are doing excel work every time after exporting this data to excel.

Could you please guide me if it is possible?

Please provide any pointers whatever you can give.

Thanks & Regards

Saurabh

[former_member195427]

Any pointers on it Experts?

Thanks

[Aniket_D]

Hi Sourabh

Query is not clear. You mean to have three separate columns for activity type instead of a singe column? What values exactly you need under each of these three columns?

Regards

Aniket

[former_member195427]

Hi Aniket,

You understood my query correctly.

Actually the column 'Activity type' contains 3 fields: Cost center 7600, Employee id  106014 and Employee name Robert as shown below:

I want to show these 3 fields into three different columns.

Thanks.

[Aniket_D]

Hello Sourabh

I observed that you have "labor hours by employee" report, how is it designed? Do you have employee number in report layout? You can use same logic to derive employee name.

Regards

Aniket

[ajaycwa1981]

Hi Sourabh

Click on the Actual amount, branch into actual line items.. See if you have Personnel Number there and also the name

If yes, take an extract into excel from the line items

If not, I guess, you can select the column in Excel and apply Data -> Fixed Length rule, wherein you can split One column into 3. The Length of ATY 7600 and CC 10xxxx is always going to be same

So you can write a macro to apply the formulae LEFT, MID and RIGHT in excel

Rgds

Ajay M

[former_member195427]

Thanks Ajay!

I would like to add some more info on this query:

Actually this report is using a report group Z002 which i could see in t-code GRR3.

With in that a report is configured : Z6PPP-02 which is ultimately called in a custom report (for which I attached the screen shot above in my query)

When I double click on Activity type column , I get the details as:

Now, could you please tell me how can I segregate the first column into 3 different column.

Thanks & regards

Saurabh

[ajaycwa1981]

Hi Saurabh

Am afraid its not possible. You are fetching the details of Partner Object and it is always updated with multiple pieces of Info in it like CC / Activity Type / XYZ

So, in my opinion, this will remain like that.. I would prefer having an Excel Macro or else develop a Z report

Br, Ajay M

[former_member195427]

Thanks Ajay.

We wont go with Z report because its again huge ABAP re work on already developed Z report.

Excel option: Can the same be done with in SAP in Excel layout as shown here:

Thanks.

[ajaycwa1981]

Hi Saurabh

Not really sure about that

You can do it from Data - Text to Column feature.. If it allows to do with in SAP, you can

See if any Technical Options in the menu allow you to modify the values here..

Else export to excel, have a formula (LEFT, MID , RIGHT) ready and simply paste it... Its done

If Column A has this info, create Columns J, K and L with LEFT, MID and RIGHT formula in them respectively... The moment you paste the data in excel, JKL will be populated

Br, Ajay M

[former_member195427]

Hi Ajay,

Thanks for your very useful inputs. But unfortunately our excel expert users are doing this so far for segregating the data and If I could do the same within SAP or outside SAP (Excel) its the same effort.

Are you sure that information contained in partner object can not be separated into parts and then be represented into output? Where can I find this info please?

Thanks & Regards

Saurabh

[ajaycwa1981]

Hi Saurabh

The only option to check if these fields are available individually in KSB1 report

For example: If the Partner Object text is a concatenation of Act Type, Cost Center and Employee No (Or Name), see if these fields are individually available in the report

About Act Type and CC am sure, it will be there.. Check for the Personnel No./ Name

Incase it is not available, you can use the exit COOMEP01  and add it into the KSB1 report.. We did that once to add XREF1,2,3 in KSB1 report

Details here

Add your desired fields in the include table CI_RKPOS and you need to write small abap code... Pasted below is sample to fetch xref1/2/3

The code is written in include ZXKAEPU01 of EXIT_SAPLKAEP_001

SELECT SINGLE vbel2 xref1 xref2 FROM bseg   INTO (cs_record-vbel2, cs_record-xref1, cs_record-xref2)              WHERE bukrs = cs_record-refbk                AND belnr = cs_record-refbn                AND gjahr = cs_record-refgj                AND buzei = cs_record-refbz.

Br, Ajay M