How to enhance 0COSTELMNT_ATTR

[Former Member]

Hello Gurus,

Is there a possibility to enhance the 0costelmnt_attr extarctor?

the extract structure for the above datasource in the system is BIW_CSKB. The R3 release is 4.6C

I added new ZZXX fields to the table CSKB as BIW_CSKB is a view and does not allow to create a append structure directly.

But these new ZZXXX fields do not appear in RSA6 for 0COSTELMNT_ATTR.

How to handle this situation? Thanks in advance

-Simmi

[Former Member]

solved

[Former Member]

Here is the solution.

Steps

1.Enhance the CSKB table-- check with your ABAP and functional team

2.Append the view BIW_CSKB -GOTO Append view--cretae a append view straucture with the new fields added to CSKB

3.activate the structures well

4. check your ROSSFIELD table. you will have the fields with selection set to 'A'

5.write code to change the selection to 'X' or space as required

6.Once ROOSFIELD is changed, the new fields will appear in RSA6

7. wirte CMOD to populate the new fields

8. check in RSA3.

So, no need of custom extarctor!

Thanks

Simmi

[Former Member]

Thanks Nagesh. That is very comforting. I will go by creating a custom datasource. I needed confirmation from another BW savvy person.

Thanks

Simmi

[Former Member]

Guys, you have been real helpful. I am still confused.

Voodi says you cannot enhance the view directly in any version. Then Ganesh what is Appending the view? IS it not enhancing the view?

Next Ganesh,

As I said when I try it from RSA6 I am getting the error. So let me try enhancing the ROSSFIELD table for the extarctor.

Thanks

Simmi

[Former Member]

Appending a view - Only allows you to add the fields that are available in the table but not available in the view. If thats what you did, I'm not sure why they arent reflecting in RSA6 (thats the reason I didnt answer the other thread)

Anyway try out what Ganesh suggested and keep us all posted.

[Former Member]

Simmi,

We can't enhance 0COSTELMNT_ATTR for custom fields. I tried to append in my system, i couldn't able to do it. We don't have any option.

As you said it should come from Base Table. If you want enhance CSKS table, please check with SAP FI/CO Team. Check where the table is used. What is the impact of the change?

or Create a custom a Datasource for new fields.

Nagesh Ganisetti.

[Former Member]

From RSA6, when I try to enhance 0costelmnt_attr,I am getting belwo the error message

"The extract str. BIW_CSKB of DS 0COSTELMNT_ATTR is a view. This allows no CustApp

Message no. R8 513"

When you try in your system, does it allow the activity that you are suggesting? What is the system version tha tyou guys are on?

Thanks

Simmi

[Former Member]

Dont even bother looking to enhance a view - in no version you can do that.

[Former Member]

I don't understand why are you enhancing CSKB Table? try to enhance the Extract Structure. Don't enhance CSKB Table, that may lead issues in your SAP Side Programs.

Enhance your Extract Strcture from RSA6. still if you can't see the fields, You need to update ROOSFIIELD Table with required fields. Please check Forum you will find lot of threads.

i didn't tried to enhance DS in my system. If you can't able to do it from RSA6, open the View in change from SE1. go with menu option GOTO--> Append View --> Provde Strcture name.

BIW_CSKB is mend for SAP BI. if you play with CSKB table that may lead to inconsistencies where ever that table is used (if they use SELECT * INTO TABLE or SELECT SINGLE * INTO WA_xxxx).

Hope you understand it.

Nagesh Ganisetti.

[Former Member]

Hello Nagesh,

How in the world can you add fields directly in RSA6? Please explain the steps?

Simmi

[Former Member]

Simmi,

In RSA6, select your DS, go with Enhance Extract Strcture. System will propose Strcture name. Accept the Name by pressing Enter. It will lead to Strcture maintenance screen, provide description and Required fields and Data Elemenets. Save and Activate your Strcture.

Write a user exit to populate the Data for enahnced fields(write between case and endcase).

Nagesh Ganisetti.

[Former Member]

The view has been enhanced. But I am not able to see those new fileds in RSA6.

Please advise.

Thanks

Simmi

[Former Member]

Simmi,

Why don't you enhance your DS (0COSTELMNT_ATTR) directly? I don't think if you enhance your View will these fields will appear in DS?

Enhance your DS from RSA6 directly. did you find any risk in it?

Nagesh Ganisetti.

[Former Member]

I have seen this link before. But I am not trying to activate the business content. In my case,the extractor is live and in production. Now i want to enhance the structure, add new fields. But that is not possible as BIW_CSKB is a view and not a structure by itself.

How can we enhance this?

Thanks

Simmi

[Former Member]

Hi,

Enhancing a view is not possible directly using RSA6.Go into the View BIW-CSKB in SE 11 and choose Goto --> Append View.Now add the additional fields you wanted and then write the user exit to populate the data into those fields using CMOD.

Thanks,

SKat

[Former Member]

Hi

Refer this

Regards

N Ganesh