Ansicht
Dokumentation

05292 - Are other libraries available from SAP?

05292 - Are other libraries available from SAP?

General Data in Customer Master   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.
SAP E-Book

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   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.

Length: 1027 Date: 20240508 Time: 013154     sap01-206 ( 3 ms )