RE:[sap-log-mm] Query writer table joins

Posted by Sap Land Thursday 30 June 2011 06:54

Posted by digidick (SRM Support Analyst)
on Jun 30 at 10:00 AM

Hi

Thank you very much for the information below., much appreciated and I have built the report now. I decided that I wanted to include the requisition number and date so I added table EBAN and linked the EBELN field in EKKO to the EBAN table but I am now getting multiple entries for each PO. Do you have any idea why ?

Thanks for all your help.

Regards

Richard

---------------Original Message---------------
From: Emmanuel Leclainche
Sent: Tuesday, June 28, 2011 4:55 AM
Subject: Query writer table joins

Hello

RSEG must be the basis (first table entered) that's probably why you are struggling.
I dont think PO positions EKPO table useful, you would risk some duplicates.

Do the following links:

RSEG-BELNR=RBKP-BELNR
RSEG-GJAHR=RBKP-GJAHR
RSEG-EBELN=EKKO-EBELN

Then you can compare for example RBKP-BLDAT to EKKO-AEDAT. I use that query also.

Regards,
Emmanuel

pls mark as helpful.

__.____._