cancel
Showing results for 
Search instead for 
Did you mean: 

SAP query report - using conditions

Former Member
0 Kudos

Hi

I have a created a query joing 3 tables EKKO,EKBE and custom table with purchase order, article and qty fields.

I want to create a discrepancy report :

1. Display records where EKBE qty (GI qty) and qty (GR qty) in custom table are not equal.

2. Custom table may have some dummy PO numbers( not existing in EKKO). How to pull them in the report?

Since PO numbers are key fields in all tables and joined, any PO number which exists in custom atble but does not exists in

ekko table doesn't appear in the report.

Any input will be highly appreciated.

Thanks

Sanjay

Accepted Solutions (0)

Answers (4)

Answers (4)

JL23
Active Contributor
0 Kudos
Former Member
0 Kudos

Hi,

Better apply logics with the help of abapor,develop custom reports for the same.

Thanks & Regards,

Sandesh Sawant

Former Member
0 Kudos

Hi,

Generally the tables for PO are EKKO & EKPO. For the custamized table are referencing PO? If no please give PO reference, ultimately will get upsated in EKKO. Another solution is tim creation stamp field will be there in custamized table. The record creation will be noted here. Pick from this field. Thanking you.

former_member329706
Active Contributor
0 Kudos

Hi,

Better develop a custom report with the help of technical team it may help you.