We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-dev] How to compare the data of a column from a table?

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Posted by ehamsi
on Jun 30 at 1:41 AM
Mark this reply as helpfulMark as helpful
<font size=2 face="sans-serif">select distinct FBUDA from VBRP into itab-fbuda</font>
<br>
<br><font size=2 face="Arial">describe itab lines w_lines <br>
if w_lines = 1 <br>
print 'A' <br>
else <br>
print 'B'. </font>
<br>
<br><font size=2 face="sans-serif"><br>
Erdal Hamsi<br>
 <br>
<br>
</font>
<br>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">From:      
 </font><font size=1 face="sans-serif">"brigittemcdonald
via sap-dev" <sap-dev@Groups.ITtoolbox.com></font>
<br><font size=1 color=#5f5f5f face="sans-serif">To:      
 </font><font size=1 face="sans-serif">ehamsi <email@removed></font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date:      
 </font><font size=1 face="sans-serif">30.06.2010 03:18</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject:    
   </font><font size=1 face="sans-serif">RE:[sap-dev]
How to compare the data of a column from a table?</font>
<br>
<hr noshade>
<br>
<br>
<table>
<tr valign=top>
<td>
<table border width=100%>
<tr valign=top>
<td width=13%><a href=http://it.toolbox.com/trd/9/1/520774></a>
<td width=49%><font size=2 color=#7f604f face="Arial">Posted by </font><a href=http://it.toolbox.com/trd/9/1/520774><font size=2 color=blue face="Arial"><u>brigittemcdonald</u></fon t></a><font size=2 color=#7f604f face="Arial">
<br>
on Jun 29 at 8:13 PM </font>
<td width=37%>
<div align=right><a href=http://it.toolbox.com/api/ContentVote/3602574/1/1/ ><font size=2 color=blue face="Arial"><u>Mark
as helpful</u></font></a><font size=3> </font></div></table>
<br>
<table border width=100%>
<tr>
<td width=100%><font size=2 face="Arial">define itab with only one field:
fbuda. <br>
select FBUDA from VBRP into itab-fbuda (NOT select single) <br>
sort itab <br>
delete duplicates <br>
describe itab lines w_lines <br>
if w_lines = 1 <br>
print 'A' <br>
else <br>
print 'B'. <br>
<br>
You could also use collect if the circumstances are right for it. <br>
<br>
Regards <br>
Brigitte <br>
<br>
<br>
---------------Original Message--------------- <br>
From: KLK <br>
Sent: Tuesday, June 29, 2010 1:11 PM <br>
Subject: How to compare the data of a column from a table? <br>
<br>
> Hi, <br>
> <br>
> Can anyone please guide me how to compare the data of a column? <br>
> <br>
> Example, i wish to compare all data in column VBRP-FBUDA column after
select single * from vbrp where vbeln = VBRK-VBELN. <br>
> Flag = '1' if all line data in the column is the same. <br>
> Thanks. <br>
</font></table>
<br><font size=1 color=white

__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language