topic Re: Error in program of join two tables in Application Development and Automation Discussions

Error in program of join two tables

Former Member — Thu, 20 Sep 2007 09:27:28 GMT

I have written following code:

TABLES: lfa1, lfbk.

TYPES: BEGIN OF str1_lfa1_lfbk,

lifnr LIKE lfa1-lifnr,

sortl LIKE lfa1-sortl,

pstlz LIKE lfa1-pstlz,

ort01 LIKE lfa1-ort01,

name1 LIKE lfbk-bankn,

stras LIKE lfbk-banks,

adrnr LIKE lfbk-bankl,

END OF str1_lfa1_lfbk.

DATA: wa1_lfa1_lfbk TYPE str1_lfa1_lfbk,

it1_lfa1_lfbk TYPE STANDARD TABLE OF str1_lfa1_lfbk.

SELECT-OPTIONS: s_lifnr FOR lfa1-lifnr DEFAULT 1.

SELECT a~lifnr

a~sortl

a~pstlz

a~ort01

b~bankn

b~banks

b~bankl

INTO wa1_lfa1_lfbk

FROM lfa1 AS a INNER JOIN lfbk AS b

ON a_{lifnr = b}lifnr

WHERE a~lifnr IN s_lifnr.

APPEND wa1_lfa1_lfbk TO it1_lfa1_lfbk.

ENDSELECT.

LOOP AT it1_lfa1_lfbk INTO wa1_lfa1_lfbk.

ULINE.

WRITE: /5 wa1_lfa1_lfbk-lifnr,

20 wa1_lfa1_lfbk-sortl,

35 wa1_lfa1_lfbk-pstlz,

50 wa1_lfa1_lfbk-ort01.

SKIP.

WRITE: /5 text-001 wa1_lfa1_lfbk-bankn,

/5 text-002 wa1_lfa1_lfbk-banks,

/5 text-003 wa1_lfa1_lfbk-bankl.

ENDLOOP.

and getting following error:

Unable to interpret "WA1_LFA1_LFBK-BANKN". Possible causes of error:

Incorrect spelling or comma error.

plz help me i m new in ABAP

Re: Error in program of join two tables

Former Member — Thu, 20 Sep 2007 09:31:45 GMT

BANKN is not defined in you're structure so therefor unknown

kind regards

arthur

Re: Error in program of join two tables

Former Member — Thu, 20 Sep 2007 09:31:51 GMT

Because your declaration is this

name1 LIKE lfbk-bankn,

and you write the result using this

WRITE: /5 text-001 wa1_lfa1_lfbk-bankn,

try changing your write code to this

WRITE: /5 text-001 wa1_lfa1_lfbk-name1,

Re: Error in program of join two tables

Former Member — Thu, 20 Sep 2007 09:35:32 GMT

hi rakesh,

use bankn instead of name1 in the declaration of str1_lfa1_lfbk.

its better prog technique to put the same name as SAP defined.

use internal table in select stmt after into clause.

remove Endselect, coz performance wise it is not good.

and then loop athe int table to print the output.

Reward points if useful

Re: Error in program of join two tables

former_member404244 — Thu, 20 Sep 2007 09:36:38 GMT

Hi,

u have to define BANKN field in ur structure.Deifne it and chek it will work..

TYPES: BEGIN OF str1_lfa1_lfbk,

lifnr LIKE lfa1-lifnr,

sortl LIKE lfa1-sortl,

pstlz LIKE lfa1-pstlz,

ort01 LIKE lfa1-ort01,

name1 LIKE lfbk-bankn,

stras LIKE lfbk-banks,

adrnr LIKE lfbk-bankl,

banfn like........<specify the type>

END OF str1_lfa1_lfbk.

Regards,

Nagaraj

Re: Error in program of join two tables

Former Member — Thu, 20 Sep 2007 09:39:12 GMT

hi,

change ur code like this.

LOOP AT it1_lfa1_lfbk INTO wa1_lfa1_lfbk.

ULINE.

WRITE: /5 wa1_lfa1_lfbk-lifnr,

20 wa1_lfa1_lfbk-sortl,

35 wa1_lfa1_lfbk-pstlz,

50 wa1_lfa1_lfbk-ort01.

SKIP.

WRITE: /5 text-001,wa1_lfa1_lfbk-name1,

/5 text-002, wa1_lfa1_lfbk-stras,

/5 text-003, wa1_lfa1_lfbk-adrnr.

ENDLOOP.

Hope it will b useful.

Re: Error in program of join two tables

Former Member — Thu, 20 Sep 2007 09:43:03 GMT

Now i have done my structure as follows... but even then i am getting the same error

TYPES: BEGIN OF str1_lfa1_lfbk,

lifnr LIKE lfa1-lifnr,

sortl LIKE lfa1-sortl,

pstlz LIKE lfa1-pstlz,

ort01 LIKE lfa1-ort01,

bankn LIKE lfbk-bankn,

banks LIKE lfbk-banks,

bankl LIKE lfbk-bankl,

END OF str1_lfa1_lfbk.

Re: Error in program of join two tables

Former Member — Thu, 20 Sep 2007 09:45:08 GMT

hi,

try this.

LOOP AT it1_lfa1_lfbk INTO wa1_lfa1_lfbk.

ULINE.

WRITE: /5 wa1_lfa1_lfbk-lifnr,

20 wa1_lfa1_lfbk-sortl,

35 wa1_lfa1_lfbk-pstlz,

50 wa1_lfa1_lfbk-ort01.

SKIP.

WRITE: /5 text-001, wa1_lfa1_lfbk-bankn,

/5 text-002, wa1_lfa1_lfbk-banks,

/5 text-003, wa1_lfa1_lfbk-bankl.

ENDLOOP.

Re: Error in program of join two tables

Former Member — Thu, 20 Sep 2007 09:46:00 GMT

thanks...

I got the solution.

Re: Error in program of join two tables

former_member402443 — Thu, 20 Sep 2007 09:46:09 GMT

TABLES: lfa1, lfbk.

TYPES: BEGIN OF str1_lfa1_lfbk,

lifnr LIKE lfa1-lifnr,

sortl LIKE lfa1-sortl,

pstlz LIKE lfa1-pstlz,

ort01 LIKE lfa1-ort01,

name1 LIKE lfbk-bankn,

stras LIKE lfbk-banks,

adrnr LIKE lfbk-bankl,

END OF str1_lfa1_lfbk.

DATA: wa1_lfa1_lfbk TYPE str1_lfa1_lfbk,

it1_lfa1_lfbk TYPE STANDARD TABLE OF str1_lfa1_lfbk.

SELECT-OPTIONS: s_lifnr FOR lfa1-lifnr DEFAULT 1.

SELECT a~lifnr

a~sortl

a~pstlz

a~ort01

b~bankn

b~banks

b~bankl

INTO wa1_lfa1_lfbk

FROM lfa1 AS a INNER JOIN lfbk AS b

ON a_{lifnr = b}lifnr

WHERE a~lifnr IN s_lifnr.

APPEND wa1_lfa1_lfbk TO it1_lfa1_lfbk.

ENDSELECT.

LOOP AT it1_lfa1_lfbk INTO wa1_lfa1_lfbk.

ULINE.

WRITE: /5 wa1_lfa1_lfbk-lifnr,

20 wa1_lfa1_lfbk-sortl,

35 wa1_lfa1_lfbk-pstlz,

50 wa1_lfa1_lfbk-ort01.

SKIP.

//************Changes made here********

WRITE: /5 text-001,wa1_lfa1_lfbk-name1,

/5 text-002 ,wa1_lfa1_lfbk-stras,

/5 text-003 ,wa1_lfa1_lfbk-adrnr.

Re: Error in program of join two tables

former_member404244 — Thu, 20 Sep 2007 09:46:57 GMT

Hi,

change the write statement...like this

WRITE: /5 text-001,wa1_lfa1_lfbk-name1,

/5 text-002 ,wa1_lfa1_lfbk-stras,

/5 text-003 ,wa1_lfa1_lfbk-bankl.

Regards,

Nagaraj

Re: Error in program of join two tables

Former Member — Thu, 20 Sep 2007 09:48:02 GMT

hi,

if u got answer by code provided here than please reward point.

Re: Error in program of join two tables

Former Member — Thu, 20 Sep 2007 09:52:13 GMT

Hi,

use code as below :

TABLES: lfa1, lfbk.

TYPES: BEGIN OF str1_lfa1_lfbk,

lifnr LIKE lfa1-lifnr,

sortl LIKE lfa1-sortl,

pstlz LIKE lfa1-pstlz,

ort01 LIKE lfa1-ort01,

bankn LIKE lfbk-bankn,

banks LIKE lfbk-banks,

bankl LIKE lfbk-bankl,

END OF str1_lfa1_lfbk.

DATA: wa1_lfa1_lfbk TYPE str1_lfa1_lfbk,

it1_lfa1_lfbk TYPE STANDARD TABLE OF str1_lfa1_lfbk.

SELECT-OPTIONS: s_lifnr FOR lfa1-lifnr DEFAULT 1.

SELECT a~lifnr

a~sortl

a~pstlz

a~ort01

b~bankn

b~banks

b~bankl

INTO wa1_lfa1_lfbk

FROM lfa1 AS a INNER JOIN lfbk AS b

ON a_{lifnr = b}lifnr

WHERE a~lifnr IN s_lifnr.

APPEND wa1_lfa1_lfbk TO it1_lfa1_lfbk.

ENDSELECT.

LOOP AT it1_lfa1_lfbk INTO wa1_lfa1_lfbk.

ULINE.

WRITE: /5 wa1_lfa1_lfbk-lifnr,

20 wa1_lfa1_lfbk-sortl,

35 wa1_lfa1_lfbk-pstlz,

50 wa1_lfa1_lfbk-ort01.

SKIP.

WRITE: /5 text-001, wa1_lfa1_lfbk-bankn,

/5 text-002, wa1_lfa1_lfbk-banks,

/5 text-003, wa1_lfa1_lfbk-bankl.

ENDLOOP.

Reward points, if helpful,

Sandeep Kaushik

Re: Error in program of join two tables

Former Member — Thu, 20 Sep 2007 09:56:23 GMT

try this. PROBLEM RESOLVED

TABLES: lfa1, lfbk.

TYPES: BEGIN OF str1_lfa1_lfbk,

lifnr LIKE lfa1-lifnr,

sortl LIKE lfa1-sortl,

pstlz LIKE lfa1-pstlz,

ort01 LIKE lfa1-ort01,

name1 LIKE lfbk-bankn,

stras LIKE lfbk-banks,

adrnr LIKE lfbk-bankl,

END OF str1_lfa1_lfbk.

DATA: wa1_lfa1_lfbk TYPE str1_lfa1_lfbk,

it1_lfa1_lfbk TYPE STANDARD TABLE OF str1_lfa1_lfbk.

SELECT-OPTIONS: s_lifnr FOR lfa1-lifnr DEFAULT 1.

SELECT a~lifnr

a~sortl

a~pstlz

a~ort01

b~bankn

b~banks

b~bankl

INTO wa1_lfa1_lfbk

FROM lfa1 AS a INNER JOIN lfbk AS b

ON a_{lifnr = b}lifnr

WHERE a~lifnr IN s_lifnr.

APPEND wa1_lfa1_lfbk TO it1_lfa1_lfbk.

ENDSELECT.

LOOP AT it1_lfa1_lfbk INTO wa1_lfa1_lfbk.

ULINE.

WRITE: /5 wa1_lfa1_lfbk-lifnr,

20 wa1_lfa1_lfbk-sortl,

35 wa1_lfa1_lfbk-pstlz,

50 wa1_lfa1_lfbk-ort01.

SKIP.

WRITE: /5 text-001, wa1_lfa1_lfbk-name1,

/5 text-002, wa1_lfa1_lfbk-stras,

/5 text-003, wa1_lfa1_lfbk-adrnr.

ENDLOOP.

reward if useful.

Amit Singla

Re: Error in program of join two tables

Former Member — Thu, 20 Sep 2007 10:52:09 GMT

hi rakesh,

go through this code , it will surely works.

TABLES: lfa1, lfbk.

TYPES: BEGIN OF str1_lfa1_lfbk,

lifnr LIKE lfa1-lifnr,

sortl LIKE lfa1-sortl,

pstlz LIKE lfa1-pstlz,

ort01 LIKE lfa1-ort01,

name1 LIKE lfbk-bankn,

stras LIKE lfbk-banks,

adrnr LIKE lfbk-bankl,

END OF str1_lfa1_lfbk.

DATA: wa1_lfa1_lfbk TYPE str1_lfa1_lfbk,

it1_lfa1_lfbk TYPE STANDARD TABLE OF str1_lfa1_lfbk.

SELECT-OPTIONS: s_lifnr FOR lfa1-lifnr DEFAULT 1.

SELECT a~lifnr

a~sortl

a~pstlz

a~ort01

b~bankn

b~banks

b~bankl

INTO wa1_lfa1_lfbk

FROM lfa1 AS a INNER JOIN lfbk AS b

ON a_{lifnr = b}lifnr

WHERE a~lifnr IN s_lifnr.

APPEND wa1_lfa1_lfbk TO it1_lfa1_lfbk.

ENDSELECT.

LOOP AT it1_lfa1_lfbk INTO wa1_lfa1_lfbk.

ULINE.

WRITE: /5 wa1_lfa1_lfbk-lifnr,

20 wa1_lfa1_lfbk-sortl,

35 wa1_lfa1_lfbk-pstlz,

50 wa1_lfa1_lfbk-ort01.

SKIP.

WRITE: /5 text-001, wa1_lfa1_lfbk-name1,

/5 text-002, wa1_lfa1_lfbk-stras,

/5 text-003, wa1_lfa1_lfbk-adrnr.

ENDLOOP.

rewards points if helpfull.

with regards,

radhika kolluru.