Ansicht
Dokumentation

05297 - Are other libraries available from SAP?

05297 - Are other libraries available from SAP?

Fill RESBD Structure from EBP Component Structure   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.
SAP E-Book

Are other libraries available from SAP?

Robert,

Your SQL statement looks correct. Does the R/3 user profile (or *PUBLIC)
have authority to file and library? Here's a modified version of my example
with a WHERE clause.

Regards,
Stan

REPORT z_sm_sql_native .

DATA: BEGIN OF pdmopt,
option(2), " user option
command(250), " command
END OF pdmopt.

DATA: select(2).

select = 'CM'.

EXEC SQL PERFORMING output-option.
SELECT option, command
INTO :pdmopt
FROM mcpartland/qauooptsam
WHERE option = :select
ORDER BY option
ENDEXEC.

FORM output-option.
WRITE: / pdmopt-option, pdmopt-command.
ENDFORM.

-----Original Message-----
From: zreclay [mailto:zreclayZy...]
Sent: Thursday, 07 March, 2002 2:48 PM
To: DoNotReply@consolut.eu
Subject: Re: Are other libraries available from SAP?


Stan,

There are over 1/2 million records in this file and I only want to
return the values from one. I can't seem to get a "where" portion of
the SQL statement to take. Any suggestions?

Based on your example, I came up with this code which is
syntactically correct but bombs out when run:


REPORT ZBC_TEST_NATIVE_SQL .

DATA: V_ITEMNO(6) type p decimals 0.

DATA: BEGIN OF i_item,
v_item(6),
v_upcndc(11),
END OF i_item.

V_ITEMNO = 56023.

EXEC SQL PERFORMING output-option.
SELECT itemno, upcndc
INTO :i_item
FROM kerrdata/invmas
WHERE itemno = :v_itemno
ENDEXEC.

FORM output-option.
WRITE: / v_itemno, i_item-v_item, i_item-v_upcndc.
ENDFORM.


Thanks for your help.

Robert Clay


Durban Tours - Südafrika Safari

ROGBILLS - Synchronize billing plans   CPI1466 during Backup  
This documentation is copyright by SAP AG.

Length: 2326 Date: 20240304 Time: 231425     sap01-206 ( 2 ms )