abap query

[former_member711289]

Hello every one,

I am functional consultant. I have created 2 reports one related to customer and one related to vendors now the problem is when i m running the reports its not showing all the records for ex if there are 200 record report is showing in 40 later on i got to know that its showing only those record which are fulfilling the criteria for example in my report one field is Email id of customers now the customer whose email id is not filled in master data is not coming in report. Is there any setting to remove this i wanna see all customers in reports irrespective wheterh their email id is there or not.

Kindly help me.

Regards

Abhishek Sinha

Idhasoft

[Former Member]

Hi,

Give a More meaningful subject line in the future.

Try removing the email from the output list or join condition.

Regards

Karthik D

[Former Member]

Hi,

There is no setting changes you can make.

You have to modify your select query and move the records to the Final internal table such that if there is a E-mail id then it should fill the record or else it should be blank.

If you tell us the way you have written the code, can help you in better way

Regards,

Ranjitha

[former_member711289]

Hi Ranjitha,

I have not written any code i have just selected the fields in sq02 whatever fileds required in report and in sq01 i have selected watever to display in report. I have to show email id . mob no tel no all these fields so i cant ignore these fields can u tell me ur solun in bit detail that would be helpfull for me.

Regards

Abhishek Sinha

[Former Member]

Hi:

hv u matching condition email in the select statement, if yes just remove it and then try.

Regards

Shashi

[former_member711289]

Hi Shasi,

Than also same records are getting displayed.

Abhisehk

[alex_m]

Hi,

In query you can use only exclusive join, pls work with your ABAP consultant and change the code in query program then you can get the expected output.

[former_member711289]

Hi Alaxander,

You mean to say i need to wright some code in code area of field that system should display records with particulat field and if that field is not available than in that case system should make that field blank and should go to other data. It means user of abap is required right?

Abhishek

[Former Member]

Abhishek

I have solved this problem in our system by changing the default joins to Outer. I am assuming your join is Inner (if the join line has no text accoss it then it is an Inner join)

In SQ02-

-place cursor on join line

-right click

-click Left Outer Join

-the join line will display Left Outer Join

I hope this works

PS. another "issue" you may find is when including data from ADR2, ADR3 etc, if there is more than 1 record in those tables for the same Vendor the Vendor list will show 2 rows

Regards

Ian Fa