topic Re: extracting data from different tables in Application Development and Automation Discussions

extracting data from different tables

Former Member — Thu, 05 Mar 2009 21:26:36 GMT

can some one help me to extract the data from:

NATION field from ADRC table + Company code (BURKS) field from LFA1.

I am using SQVI (query), but not succeeded. Please help me.....

Thanks

NIlesh

Re: extracting data from different tables

former_member376453 — Thu, 05 Mar 2009 21:53:10 GMT

I am not sure what is your exact requirement is, but in LFA1 there is one field ADRNR, fetch this field from LFA1 depending on the LIFNR, then go to ADRC and Put that ADRNR and fetch NATION.

Kuntal

Re: extracting data from different tables

Former Member — Thu, 05 Mar 2009 23:13:15 GMT

Hi,

select the record from lfa1 into wa with resect to BUKRS

select BUKRS
          ADRNR
  from lfa1
into wa
where BUKRS = 'XYZ'.

endselect.

"based on the ADRNR you got in wa. use that in ADRC table with SQVI query

Re: extracting data from different tables

former_member632729 — Fri, 06 Mar 2009 02:32:28 GMT

Hi Dude,

First fetch the data from the tables LFA1 and TZONE using the below condition..

LFA1-LIFNR = TZONE-LAND1

LFA1-LZONE = TZONE-ZONE1

and then TZONE table and ADRC table link..

TZONE-LAND1 = COUNTRY

TZONE-ZONE1 = TRANSPZONE..

Check with this link..

Re: extracting data from different tables

Former Member — Fri, 06 Mar 2009 03:33:57 GMT

Hi,

see this sample code based on the name u have to get i think..

SELECT SINGLE * FROM lfa1 INTO i_lfa1 WHERE lifnr = i_ekko-lifnr.

IF sy-subrc = 0.

*SELECT SINGLE * FROM adrc INTO i_adrc WHERE name1 = i_lfa1-name1.*

IF sy-subrc = 0.

i_zzep_pohdr_s-ven_name = i_lfa1-name1. "5

i_zzep_pohdr_s-ven_addy1 = i_adrc-street. "6

i_zzep_pohdr_s-ven_strt2 = i_adrc-str_suppl1. "7

i_zzep_pohdr_s-ven_strt3 = i_adrc-str_suppl2. "8

i_zzep_pohdr_s-ven_strt4 = i_adrc-str_suppl3. "9

i_zzep_pohdr_s-ven_strt5 = i_adrc-location. "10

i_zzep_pohdr_s-ven_tel_no = i_adrc-tel_number. "11

i_zzep_pohdr_s-ven_tel_ext = i_adrc-tel_extens. "12

i_zzep_pohdr_s-ven_fax_no = i_adrc-fax_number. "13

i_zzep_pohdr_s-nation = i_adrc-nation. "14

ENDIF.

Regards,

Kiran

Re: extracting data from different tables

Former Member — Fri, 06 Mar 2009 17:55:56 GMT

Yes,

I got it..............

Thanks alot.............