abap query

[Former Member]

Hi Every One,

I have created 2 reports with abap query. one is related to customers and one is related to vendors. My reports are working properly except one problem. The problem is that i have selected KUNNR field in customer report when i m running the report that customer number is replaced by text (name1). Same thing is happening in vendor report also. than i realized that there is a text refrence with these 2 fields. Now i m not able to remove these text refrence filed. Kindly give me answers as its imp for me.

Regards

Abhishek Sinha

Idhasoft

[Former Member]

Hi,

If you have created using SQ02, you can edit there itself.

Lets say remove the unncecessary tables.

If some field gets overwritten, then move that statement in the coding part of the events to top. So that it will not replace the latest one.

You can also code accordingly in the events available in SQ02.

Don't forget to REGENERATE.

Regards,

Santhosh.

[Former Member]

is there any othere solution thru which we can remove text and reprot should show directly KUNNR. i think some thing must b there i m misssing some thing.

Regards

Abhishek Sinha

[Former Member]

Hi,

Which table are you using for displaying the KUNNR field.

[Former Member]

Hi i m using KAN1.

Abhishek

[Former Member]

Hi,

What i have understood from your problem is that you are giving customer number in the screen and in the output displayed instead of the customer number you are getting the customer name.. For this please check if you are sending the Kunnr fields or the name field to the final internal table..

[Former Member]

Hi Sneha actually i m functional consultant in PS. and the thing is i m using abap query thru tcodes sq01,02 and 03. Now u r right when i m running report instead of customer no the customer name is coming . I dont know abap and technicals much. In sq02 when we select field from the table few fields always have text mark (symbol). So all these fields which have text mark, thier values is getting change in reports means insted of vaules their description is comin. Please suggest me some thing.

Regards

Abhishek

Idhasoft