topic Re: Replacement for SADR in Application Development and Automation Discussions

Replacement for SADR

Former Member — Thu, 07 Nov 2013 23:30:14 GMT

I'm learning to work with ABAP-SAP and I want to know how can I replace this obsolete code:

SELECT SINGLE * FROM SADR

WHERE ADRNR EQ T001-ADRNR

I know SADR table is obsolet but I don´t know where do I start to replace this code.

Please somebody help me.

Thanks in advanced.

Message was edited by: Matthew Billingham - added meaningful subject.

Re: Replacement for SADR

Former Member — Thu, 07 Nov 2013 23:49:33 GMT

Hey mate,

Easy fix, just do the following,

SELECT * UP TO 1 ROWS

INTO lv_address

FROM adrc

WHERE addrnumber EQ lv_t001-adrnr

AND date_from LE sy-datum

AND date_to GE sy-datum.

ENDSELECT.

Make sure when doing a select statement always use the SELECT / ENDSELECT and UP TO 1 ROWS when you are not selecting the whole key of a table. Just using SELECT SINGLE will sometimes get you the wrong result.

Cheers

Shaun

Re: Replacement for SADR

former_member192854 — Fri, 08 Nov 2013 00:01:48 GMT

DATA lw_sadr TYPE sadr.

DATA lw_t001 TYPE t0001.

* First fetch your lw_t001 variable

SELECT SINGLE *

INTO lw_sadr

FROM sadr

WHERE adrnr EQ lw_t001-adrnr.

Re: Replacement for SADR

Former Member — Fri, 08 Nov 2013 00:31:31 GMT

Hey, thanks for the response, but, what if I use call function

WK_ADDR_SEL-ADDRNUMBER = TVBUR-ADRNR.

CALL FUNCTION 'ADDR_GET'

EXPORTING

ADDRESS_SELECTION = WK_ADDR_SEL

IMPORTING

SADR = SADR

EXCEPTIONS

PARAMETER_ERROR = 1

ADDRESS_NOT_EXIST = 2

VERSION_NOT_EXIST = 3

INTERNAL_ERROR = 4

OTHERS = 5.

what´s your opinion.

thank u.

Re: Replacement for SADR

Former Member — Fri, 08 Nov 2013 03:41:59 GMT

SELECT SINGLE * FROM SADR
     WHERE ADRNR EQ T001-ADRNR

In this query where you are storing your result. You need to create a workarea of type SADR and store your result into that.

Re: Replacement for SADR

Former Member — Fri, 08 Nov 2013 03:44:27 GMT

Hi , EASY ANSWER

data lv_var type sadr .

SELECT SINGLE * FROM SADR

Into lv_var

WHERE ADRNR EQ T001-ADRNR

Re: Replacement for SADR

sivaganesh_krishnan — Fri, 08 Nov 2013 03:45:59 GMT

HI alejandro,

ADRC is the central address table. It is has any address that you enter in SAP.

SADR is no longer used, it was the table prior to ADRC.

Check OSS note 85676 - Customer objects: conversion of SADR addresses.

You can code it like :

Select single *

from adrc

into internal_table

where condition.

Regards,

sivaganesh

Re: Replacement for SADR

Former Member — Fri, 08 Nov 2013 03:46:24 GMT

Hi Alvarez,

ADRC is the central address table. U can use this table as a replacement of SADR table.. and use ADDRNUMBER (address no) fied in where condition.

One more thing, create a work area (type ADRC) to hold the fetched values..

Re: Replacement for SADR

Former Member — Fri, 08 Nov 2013 03:47:36 GMT

Hi,

If you have a FM then you should go with it. But its all based on your requirement.

I checked the the above FM and its retrieving the value from SADR.

All you need to do is, declare an internal table of type sadr and use it in the importing parameter.

Regards.

Re: Replacement for SADR

former_member209120 — Fri, 08 Nov 2013 04:10:17 GMT

Hi alejandro Alvarez ,

Try like this

DATA : wa_adrc TYPE adrc.

SELECT SINGLE * FROM adrc
                 INTO wa_adrc
                 WHERE addrnumber EQ wa_t001-adrnr
                 AND date_from LE sy-datum
                 AND date_to    GE sy-datum.

If your requirement fulfills with Function Module ADDR_GET

then you can proceed with that......

Re: Replacement for SADR

Former Member — Fri, 08 Nov 2013 04:17:16 GMT

Hello Shiva,

what is the difference between ans posted by you and ans posted by ..???

small tip for you.. lv_var means (lv- local variable) which is use for single value.. you you want to make a work area the either use wa_var(work area) or ls_var(local structure)..

Re: Replacement for SADR

matt — Fri, 08 Nov 2013 06:15:45 GMT

Shaun Bradridge wrote:
Hey mate,
Easy fix, just do the following,
SELECT *  UP TO 1 ROWS
                     INTO lv_address
                     FROM adrc
                    WHERE addrnumber EQ lv_t001-adrnr
                      AND date_from  LE sy-datum
                      AND date_to    GE sy-datum.
   ENDSELECT.
Make sure when doing a select statement always use the SELECT / ENDSELECT and UP TO 1 ROWS when you are not selecting the whole key of a table. Just using SELECT SINGLE will sometimes get you the wrong result.
Cheers
Shaun

Wrong.

Re: Replacement for SADR

Former Member — Mon, 11 Nov 2013 23:40:51 GMT

Thanks for the kind words Matthew really helpful pointing out problems without giving resolution, but you are right, when you look at the sql statements that are actually the same when you use Select single or UP to 1 rows. It is just a developers best practice to use UP to 1 rows when not selecting from the whole key.

Shaun

Only

Re: Replacement for SADR

matt — Tue, 12 Nov 2013 06:57:00 GMT

I thought highlighting the incorrect statement was sufficient explanation.

"Just using SELECT SINGLE will sometimes get you the wrong result." No, it won't.

Is that enough?

It is not, in my view, developers best practice to use up to 1 rows when not selecting the whole key. It makes the code less readily understandable, so I think it is bad programming practice. SELECT SINGLE as an existence check, or when I'm only wanting results from part of the key, or where the table has a unique index that I'm actually using is perfectly acceptable. The only reason, in my view, that the SELECT ... UP TO 1 ROWS came up was because SLIN at one time objected to a SELECT SINGLEs where the full primary key isn't specified. Unfortunately many programmers (and QA departments) take SLIN as law, rather than as guidance - resulting in more complex code with all the consequences of that.

On this site, there are many myths that are perpetuated. If someone gives incorrect technical information I will point it out. Rejecting the post is an option, but I feel that closes discussion.

Re: Replacement for SADR

Former Member — Wed, 13 Nov 2013 17:09:30 GMT

Hi Ramesh I mean , if I want to use a function module, what FM would I use, because I have seen several options about that.

Can you tell me.

Thanks in advanced