topic Syntax error in Application Development and Automation Discussions

Syntax error

Former Member — Thu, 28 Sep 2006 08:11:42 GMT

hello all,

SELECT B~MATNR

INTO TABLE LT_FINAL

FROM /SAPAPO/MATLOC AS A

INNER JOIN /SAPAPO/MATKEY AS B ON A_{MATID EQ B}MATID

INNER JOIN /SAPAPO/LOC AS C ON A_{LOCID EQ C}LOCID

WHERE C~LOCID EQ LT_ORDKEYS-LOCID.

Error : lt_ordkeys is a table without header line.

My Declaration is.

data : LT_ORDKEYS TYPE /SAPAPO/OM_ORDKEY_TAB,

But i cannot declare like

LT_ORDKEYS TYPE /SAPAPO/OM_ORDKEY_TAB with header line.

Then i cannot pass it to Fm CALL FUNCTION '/SAPAPO/OM_ORDER_GET_DATA'

importing parameter : et_ordkeys.

How to solve this ?

Re: Syntax error

Former Member — Thu, 28 Sep 2006 08:13:29 GMT

You can decalre it as LT_ORDKEYS TYPE TABLE OF /SAPAPO/OM_ORDKEY_TAB.

Best Regards,

Vibha

*Plz mark useful answers

Re: Syntax error

Former Member — Thu, 28 Sep 2006 08:25:48 GMT

Hi John,

the problem is, that the WHERE-Condition

WHERE C~LOCID EQ LT_ORDKEYS-LOCID.

compares a single value with a table.

Can you declare a range (e.g. LR_ORDKEYS), put the values from LT_ORDKEYS into this range and change the condition to

WHERE c~LOCID IN LR_ORDKEY?

Regards,

Stefan

Re: Syntax error

Former Member — Thu, 28 Sep 2006 08:29:57 GMT

Hi,

try below code

data LT_ORDKEYS like /SAPAPO/OM_ORDKEY_TAB occurs 0

with header line.

Regards

amole

Re: Syntax error

Former Member — Thu, 28 Sep 2006 08:34:31 GMT

Hi,

Can U paste tHe code from where ur getting the locid passed into the select query.

Regards

Ahasan

Re: Syntax error

Former Member — Thu, 28 Sep 2006 08:48:25 GMT

Hi Johnn,

Since LT_ORDKEYS is a table, try using the statement 'FOR ALL ENTRIES' in the select stmt. That should then equate each record of LT_ORDKEYS with C~LOCID.Also check LT_ORDKEYS is not initial before using a SELECT with 'FOR ALL ENTRIES' to avoid performance issues.

SELECT B~MATNR

INTO TABLE LT_FINAL

FROM /SAPAPO/MATLOC AS A

INNER JOIN /SAPAPO/MATKEY AS B ON A_{MATID EQ B}MATID

INNER JOIN /SAPAPO/LOC AS C ON A_{LOCID EQ C}LOCID

FOR ALL ENTRIES IN LT_ORDKEYS

WHERE C~LOCID EQ LT_ORDKEYS-LOCID.

Regards.