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

Posted by Sap Land Tuesday, 28 June 2011 01:13

Posted by emmanuel_leclainche
on Jun 28 at 4:39 AM

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

---------------Original Message---------------
From: digidick
Sent: Tuesday, June 28, 2011 3:27 AM
Subject: Query writer table joins

Hi -

I am new to querywriter and an wanting to contract a report to compare the date of a PO to the posting date of an invoice posted against it. I saw this requirement referenced in an earlier thread and tables EKKO EKPO RBKP RSEG were mentioned as source tables but I am struggling to identify the fields that I need to link to generate the report.

Can anyone help ?

Thanks in anticipation

__.____._