topic Re: ABAP Query : Multiple Rows in Report in Application Development and Automation Discussions

ABAP Query : Multiple Rows in Report

Former Member — Fri, 15 Apr 2016 07:02:32 GMT

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

Re: ABAP Query : Multiple Rows in Report

jogeswararao_kavala — Fri, 15 Apr 2016 23:58:13 GMT

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

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

Re: ABAP Query : Multiple Rows in Report

Former Member — Mon, 18 Apr 2016 06:39:39 GMT

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