topic Re: please explain me the code in Application Development and Automation Discussions

please explain me the code

Former Member — Tue, 24 Jul 2007 17:10:12 GMT

RANGES : r_matnr FOR mara-matnr .

SELECT lifnr

matnr

INTO CORRESPONDING FIELDS OF TABLE t_data

FROM zdata

WHERE lifnr = p_lifnr.

LOOP AT t_data .

r_matnr-sign = 'I' .

r_matnr-option = 'EQ' .

r_matnr-low = t_data-matnr .

APPEND r_matnr .

ENDLOOP.

SELECT mblnr

matnr

menge

INTO TABLE lt_menge

FROM mseg

FOR ALL ENTRIES IN lt_itab

WHERE mblnr = lt_itab-mblnr

AND matnr IN r_matnr

Re: please explain me the code

Former Member — Tue, 24 Jul 2007 19:42:09 GMT

***

This part will create a range variable. The range variable acts like Select-Options and
contains of the fields:
sign
options
low
high

***

RANGES : r_matnr FOR mara-matnr .

***

The internal table has perhaps more fields and in an different order than just
lifnr
matnr.
using CORRESPONDING FIELDS will do a name mapping. That means, this
table has to have at least fields with the same name.

***

SELECT lifnr

matnr

INTO CORRESPONDING FIELDS OF TABLE t_data

FROM zdata

WHERE lifnr = p_lifnr.

Now the report will loop over the just filled table and fill the range
object with the material number into the LOW field.

***

LOOP AT t_data .

r_matnr-sign = 'I' .

r_matnr-option = 'EQ' .

r_matnr-low = t_data-matnr .

APPEND r_matnr .

ENDLOOP.

in the next step, the code performs another select on an SAP table. This time
it uses the ranges variable and another table with the FOR ALL ENTRIES in <itab> to
get the values (mblnr, matnr, menge).

well... there are some limitations on the ranges table within an SQL where condition.

***

SELECT mblnr

matnr

menge

INTO TABLE lt_menge

FROM mseg

FOR ALL ENTRIES IN lt_itab

WHERE mblnr = lt_itab-mblnr

AND matnr IN r_matnr

Re: please explain me the code

Former Member — Wed, 25 Jul 2007 09:46:57 GMT

Hello madan,

RANGES : r_matnr FOR mara-matnr .

"""range is being declared for material number

***********************************************************

SELECT lifnr "Account Number of Vendor or Creditor

matnr "Material number

INTO CORRESPONDING FIELDS OF

TABLE t_data "respective fields of internal table

FROM zdata "Source table

WHERE

lifnr = p_lifnr."p_lifnr is used as selection criterion

"From the naming convention P_lifnr looks like a parameter entered by user

"So all material numbers and A/C numbers for a particular account number are being selected

***********************************************************

"The following process is defining a range.r_matnr will contain all Material numbers

which are available for the account number P_lifnr

eg:imagine that you have 1,2,3 matnr having LIFNR '001' from ZDATA

then:::::after this loop r_matnr eill contain 1,2,3>

LOOP AT t_data .

r_matnr-sign = 'I' .

r_matnr-option = 'EQ' .

r_matnr-low = t_data-matnr .

APPEND r_matnr .

ENDLOOP.

"select X from Y where matnr IN r_matnr" means

it will select field X from table Y

where material number = '1' or '2' or '3'...(based on matrn in the t_data)

***********************************************************

you are selecting from MSEG some fields which have material numbers in ZDATA for a particular

account number and which have mblnr values in lt_itab...ie records which have mblnr from lt_itab

and material number from ZDATA for the account number from the database table mseg

SELECT mblnr

matnr

menge

INTO TABLE lt_menge

FROM mseg

FOR ALL ENTRIES IN lt_itab

WHERE mblnr = lt_itab-mblnr

AND matnr IN r_matnr

***********************************************************

Reward if useful

Regards

Byju

Re: please explain me the code

KjetilKilhavn — Mon, 30 Jul 2007 09:08:04 GMT

Hello Madan, it is good you have found the performance & tuning forum. Here you can ask any beginner question you like, as the name indicates the forum is not restricted to performance or tuning related issues.

RANGES is a way of saying you miss the free-ranging shepherd life of previous generations. A very poetic statement to start your program, and a fine way to say that city life is not always a dance on roses.

SELECT denotes exclusivity. Not everyone, just the selected will be eligable for what comes next. Sort of like many religions where you are doomed unless you are a believer. As there are many different religions, we are either doomed in any case (all religions correct) or not doomed at all (all religions mistaken).

As you can see the selected few will be guided INTO a sheltered space and remembered by the program. In order to be among the eligable your life number (lifnr) must be one that has been picked by the gods (p_lifnr).

LOOP should be pretty self-explanatory for a programmer.

APPEND is a mis-spelling. It should be ATTEND. It is important to attend to the ceremonies of your religion if you want to be among the select few.

Finally the polyteistic nature of our world is referenced towards the end of the program, where the materialism of our society is hinted at.

Please don't hesitate to ask for interpretations of the next program you write. We are all here to help you with the basics and don't expect you to spend too much time learning the elementary things on your own.

<i><b>Remember:</b> Please reward all helpful contributions.</i>

Re: please explain me the code

former_member374 — Thu, 02 Aug 2007 15:50:26 GMT

Hi Kjetil,

10 points for your poetic answer. Made my day.

Will be happy for the rest of the morning.

-1 point if I could give to Madan for such a lazy question. Grrr.

All the best, Mark.