ABAP Query : Multiple Rows in Report

[Former Member]

Hi Expert,

I am here with some coding error issue. i have created a custom field in abap query in which i want to pass Quality notification number to defects.

But when i execute the report it is showing me multiple of rows with same value and i have entered one value in report and i also want to calculate multiple rows if there is another same defect is updated in same notification.

Can you please guide me what is the actual problem.

Regards,

Qamber Abbas

[Former Member]

Hi Expert,

I am here with some coding error issue. i have created a custom field in abap query in which i want to pass Quality notification number to defects.

But when i execute the report it is showing me multiple of rows with same value and i have entered one value in report and i also want to calculate multiple rows if there is another same defect is updated in same notification.

Can you please guide me what is the actual problem.

Regards,

Qamber Abbas

[jogeswararao_kavala]

Give the table join picture. What all tables you have used?

Also why you've used KZLOESCH NE 'X'  twice ?

[Former Member]

Sir i just add simple three tables in order to generate my report according to inspection lot, if any inspection lot contains any defect recording notification which is like F1, F2 ,F3 it will show me in the report further if there is not any notification available then the report will show the total passed quantity in the inspection lot screen.

' KZLOESCH NE 'X'. this logic says the notification with deletion flag will not show in the report.

I just need to find out it is showing multiple rows and my coding logic is perfect hen it will only show one line for each defect.

Regards,

Qamber Abbas