Ansicht
Dokumentation

05294 - Are other libraries available from SAP?

05294 - Are other libraries available from SAP?

BAL Application Log Documentation   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by SAP AG.
SAP E-Book

Are other libraries available from SAP?

Robert,

Try using a structure. Here's a working example that I keep around.

Regards,
Stan

REPORT z_sm_sql_native .

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

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

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

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


Hi, group

We are trying to access a file in a non-R/3 library via a little ABAP
program using native SQL. It isn't working. My question is: is it
possible to access files in data libraries other than R/3-specific
libraries? If so, how?

Here's our dummy code:

REPORT ZBC_TEST_SQL .
DATA: V_ITEM(10) TYPE C,
V_ITEMNO(6),
V_VNDRNO(10) TYPE C.
V_ITEMNO = 56023.
EXEC SQL.
SELECT ITEMNO, VNDRNO INTO :V_ITEM, :V_VNDRNO FROM KERRDATA/INVMAS
WHERE ITEMNO = V_ITEMNO
ENDEXEC.
WRITE: / V_ITEM.

Any suggestions/information is greatly appreciated.

Robert Clay


Durban Tours - Südafrika Safari

CL_GUI_FRONTEND_SERVICES - Frontend Services   CPI1466 during Backup  
This documentation is copyright by SAP AG.

Length: 1973 Date: 20240305 Time: 080639     sap01-206 ( 3 ms )