topic Re: Reg loops in Application Development and Automation Discussions

Reg loops

Former Member — Wed, 16 Jul 2008 14:05:00 GMT

I have a internal table with various fields... like

SO SO line item Matnr Date Diff Result

1452261 10 NXP1010 2 Yes

1452261 10 NXP1010 3 Yes

1452261 10 NXP1010 1 No

1452261 10 NXP1010 0 No

Now i want to find the no of records only with result 'YES'. and also i want to find the total no of records.

<removed_by_moderator> <= read [the rules|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/rulesofEngagement] here!

Edited by: Julius Bussche on Jul 16, 2008 2:57 PM

Points removed from everyone who answered

Re: Reg loops

matt — Wed, 16 Jul 2008 14:06:59 GMT

loop through. if result equals yes, then add 1 to counter. get total number of lines using lines( ).

matt

Re: Reg loops

Former Member — Wed, 16 Jul 2008 14:08:46 GMT

hi,

You can find Total No of Records using

DESCRIBE <table> lines <line-var>.

That will Give You Total No of lines ie No of Records.

Regards

Sumit Agarwal

Re: Reg loops

former_member70391 — Wed, 16 Jul 2008 14:09:18 GMT

Hi ,

data: counter type i value 0.

Looat at table.

if table-result eq 'Yes'.

counter = counter + 1.

endif.

endloop.

Hope it helps.

Thanks & Regards,

Nagaraj Kalbavi

Re: Reg loops

Former Member — Wed, 16 Jul 2008 14:10:45 GMT

Copy the intenale table 1(original) to internal table 2.

Describe the 1nd internal table to find the total no of records.

delete the records which has NO.

and Describe the 2nd internal table to find the no of records only with result 'YES'.

Regards,

Rajasekhar Reddy.

Re: Reg loops

Former Member — Wed, 16 Jul 2008 14:11:38 GMT

Hi,

For finding total number of records use the following logic.


DATA: N1    TYPE I, 
          N2 type i.

 DESCRIBE TABLE ITAB LINES N1. 

*N contains the total number of records.

*for finding number of records with Yes try this way

itab1 = itab. * Itab1 same structure of itab.

delete itab1 where result = 'YES'.

DESCRIBE TABLE ITAB1 LINES N2. 

*number of records with result = Yes is N1 - N2.

I think this will be performance efficient(without loop) for your case of just knowing number of records

//Kothand

Re: Reg loops

Former Member — Wed, 16 Jul 2008 14:11:49 GMT

Use the fields that you want in the below select statement

TABLES xxxx.

SELECT * FROM xxxx

WHERE

Diff Result = 'YES' .

WRITE: / Diff Result.

ENDSELECT.

Regards

Divya