Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from coco_kh on Aug 21 at 12:35 AM Hi Munir,
Thank you for your reply.
It is not one time activity. I thought it was easy to set up SQVI rather than download & refresh pibot on Excel sheet.
It seems there is no way to create a list I want so I will download data and work with Excel.
Thank you.
coco_kh
| | | ---------------Original Message---------------
From: coco_kh
Sent: Friday, August 15, 2014 5:33 AM
Subject: Left Outer Join - MAKT - Trying to Find Out Missing Description in MAKT
Hi,
I'm trying to find out missing description in MAKT.
SPRAS in MAKT has two values , "AL" and "OT". All material codes exist in "AL" records.
"OT" is missing some materail codes. I want to compare between "AL" and "OT".
My expected result is like --
AL MMname1 OT MMname1
AL MMname2 OT (null)
AL MMname3 OT MMname3
I created alias name for MAKT, like MAKT2. Then connect MAKT to MAKT2 with left outer link.
Link field is MATNR
Data selection is
MAKT : SPRAS = "AL"
MAKT2 : SPRAS = "OT"
What I got is ---
AL MMname1 OT MMname1
AL MMname3 OT MMname3
I have no authority to write query script. I just try to setup the connection on SQVI.
Thank you. |
| Reply to this email to post your response. __.____._ |   _.____.__ |
