Ansicht
Dokumentation

MSS_GET_SQLCODE - Get sql code for MSS object

rdisp/max_wprun_time - Maximum work process run time   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.

This function returns information about the last executed SQL statement on a given SQL Server process id (SPID) or if the SPID = 0 the body SQL text of the given SAP generated stored procedure (SPNAME). To get this information the command 'dbcc inputbuffer' is issued and in case of a generated SAP stored procedure (see below) the stored procedure sap_mon_helptext is called.

If an SPID is given and the last executed SQL statement was the call of an SAP generated stored procedure, the body text of this stored procedure will be returned (in SQLCODE). Additionally the table SPPARAMS will be filled with the list of parameter names and their types (one row for each parameter). If it is a permanent stored procedure (name beginning with 'Y') the output parameter SPDESC will hold descriptive information about the stored procedure which is derived from the procedure name.

If no SAP generated stored procedure call is detected, the input buffer of the given SPID will be returned in SQLCODE.

The output in SQLCODE is formatted to be one print line per row.

Error conditions: If there is no i/o buffer associated with the given SPID or there is no such SQL Server process the exception NO_IO_ON_THIS_SPID will be raised. If the SAP generated stored procedure was not found on the database (should only happen for temporary stored procedures) the exception OBJECT_NOT_FOUND will be raised. If the given SPID is 0 (or no SPID is given) and the given SPNAME does not begin with 'Y' or '#' the exception SPNAME_NOT_SAP_CONFORM will be raised.

Parameters

ABLOCAT
ABNAME
CON_NAME
NO_PAR
NO_QUOTES
OBJECT_NAME
OBJ_DB
OBJ_SCHEMA
SCHEMA
SPPARAMS
SQLCODE
TABNAME
WITH_CREATEPROC

Exceptions

CONNECT_ERROR
DB_ERROR
DB_NOT_FOUND
INTERNAL_ERROR
INVALID_INPUT
INVALID_OBJECT
NOT_RUNNING_ON_MSSQL
NO_DB_ACCESS
SCHEMA_NOT_FOUND
SQLTEXT_NOT_FOUND

Function Group

SFMSS_MISC

ABAP Short Reference   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

Length: 2150 Date: 20240523 Time: 052000     sap01-206 ( 77 ms )