‎2007 Jun 26 2:17 PM
Hi,
I have a SAP query. It joins the SKB1 and SKA1 table, meaning that related alternative account numbers shall be printed if any for each record in SKB1. These two tables are joined by outer join.
The problem is the output. It only outputs the SKB1 records that have an alternative account, not the others
Ex.
G/L Account
Comp.code GL acc. Alternative print status
01 6005 7007 Printed
02 6005 Blank Not printed
03 6005 7007 Printed
etc.
What am I doing wrong ?
‎2007 Jul 23 8:17 PM