Ansicht
Dokumentation
05294 - Are other libraries available from SAP?
ROGBILLS - Synchronize billing plans rdisp/max_wprun_time - Maximum work process run timeThis documentation is copyright by SAP AG.
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
rdisp/max_wprun_time - Maximum work process run time Vendor Master (General Section)
This documentation is copyright by SAP AG.
Length: 1973 Date: 20240425 Time: 223817 sap01-206 ( 2 ms )