openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/MSS_GET_MSSTATS:
    post:
      tags:
      - STUQ
      summary: Get MSSTATS list
      operationId: /rfc/MSS_GET_MSSTATS
      requestBody:
        content:
          application/json:
            schema:
              properties:
                ALL_DETAIL:
                  type: string
                  default: ' '
                  maxLength: 1
                  description: Single-character flag
                CON_NAME:
                  type: string
                  default: DEFAULT
                  maxLength: 30
                  description: DBCON Name
                IMPORTED_SP:
                  type: string
                  default: ' '
                  maxLength: 1
                  description: Single-character flag
                INSTNAME:
                  type: string
                  default: ' '
                  maxLength: 40
                  description: Appserver
                MAX_ROWS:
                  type: integer
                  format: int32
                  default: 100
                  description: Natural number
                OBJ_DB:
                  type: string
                  maxLength: 128
                  description: Database name
                OBJ_SCHEMA:
                  type: string
                  maxLength: 128
                  description: Schema name
                SCHEMA:
                  type: string
                  default: ' '
                  maxLength: 128
                  description: Target Schema
                SHOW_CACHE:
                  type: string
                  default: ' '
                  maxLength: 1
                  description: Single-character flag
                SHOW_EXP:
                  type: string
                  default: X
                  maxLength: 1
                  description: Single-character flag
                SHOW_IDX:
                  type: string
                  default: X
                  maxLength: 1
                  description: Single-character flag
                SORTEDCOLNAME:
                  type: string
                  default: RF_TOT_MS
                  maxLength: 10
                  description: Character field length = 10
                CACHE_OBJECTS:
                  type: array
                  items:
                    type: object
                    properties:
                      BUCKETID:
                        type: integer
                        format: int32
                        description: Cache object bucket ID
                      CACOBJTYPE:
                        type: string
                        maxLength: 35
                        description: Type of the object in the cache
                      OBJTYPE:
                        type: string
                        maxLength: 16
                        description: SQL Server classification of object
                      OBJID:
                        type: string
                        maxLength: 255
                        description: The  name of the object in cache
                      DBID:
                        type: integer
                        format: int32
                        description: MS SQL server database Id
                      CO_UID:
                        type: integer
                        format: int32
                        description: MS SQL server - user identification id
                      REFCOUNTS:
                        type: integer
                        format: int32
                        description: The number of other cache objects referencing this object
                      USECOUNTS:
                        type: integer
                        format: int32
                        description: The number of times this cache object has been used
                      PAGEUSED:
                        type: integer
                        format: int32
                        description: The number of pages consumed by this cache object
                      SETOPTS:
                        type: integer
                        format: int32
                        description: The SET options for a cache object; part of cache key
                      LANGID:
                        type: integer
                        format: int32
                        description: The language id of the connection that created cache object
                      DATEFORMAT:
                        type: integer
                        format: int32
                        description: The date format of the connection that created the cache obj
                      STATUS:
                        type: integer
                        format: int32
                        description: The status of the cache object
                      SQLBYTES:
                        type: integer
                        format: int32
                        description: The length of the cache object submitted.
                      CO_SQL:
                        type: string
                        maxLength: 3900
                        description: Procedure name or first 128 bytes of the submitted batch
                      LASTTIME:
                        type: integer
                        format: int64
                        description: Time statement took to execute last time
                      MAXEXECT:
                        type: integer
                        format: int64
                        description: Maximum execution time
                      AVGEXECT:
                        type: integer
                        format: int64
                        description: Average runtime
                      LASTRD:
                        type: integer
                        format: int64
                        description: Amount of data read during last execution
                      LASTWR:
                        type: integer
                        format: int64
                        description: Amount of data written during last execution
                      MINLOAD:
                        type: integer
                        format: int64
                        description: Database load  (ms)
                MSSTATS_LIST:
                  type: array
                  items:
                    type: object
                    properties:
                      SPNAME:
                        type: string
                        maxLength: 128
                        description: Stored procedure name
                      TABNAME:
                        type: string
                        maxLength: 128
                        description: Table name
                      ABNAME:
                        type: string
                        maxLength: 40
                        description: ABAP Program Name
                      ABLOCAT:
                        type: integer
                        format: int32
                        description: Offset of a Processing Control Block
                      NCALL:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS number calls'
                      TOTAL_MS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS total runtime'
                      AVG_MS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS average runtime'
                      MAX_MS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS maximum run time'
                      MIN_MS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS minimum runtime'
                      RF_TOT_MS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS total runtime w/ fetch'
                      RF_AVG_MS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS average runtime w/fetch'
                      RF_MAX_MS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS max runtime w/ fetch'
                      RF_MIN_MS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS Minimum runtim w/ fetch'
                      MIN_ROWS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS minimum rows returned'
                      MAX_ROWS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS maximum rows returned'
                      TOTAL_ROWS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS total rows returned'
                      AVG_ROWS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS average rows returned'
                      PCURSOR:
                        type: string
                        maxLength: 1
                        description: 'MS SQL Server: SP Statistics MSSTATS cursor usage'
                      ROW_COUNT:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS row count'
                      RF_MS:
                        type: integer
                        format: int32
                        description: The total runtime in ms of the call with the longest runtime
                      STMTTYPE:
                        type: string
                        maxLength: 20
                        description: 'MS SQL Server: SP Statistics MSSTATS statement type'
                      NSERVERS:
                        type: integer
                        format: int32
                        description: MS SQL Server MSSTATAS number of servers
                      INSTANCE:
                        type: string
                        maxLength: 40
                        description: Application Server Name
                      ROWPERMS:
                        type: integer
                        format: int64
                        description: MS SQL Server Extended MSSTATS Column Rows per MS
                      LISTINDEX:
                        type: integer
                        format: int32
                        description: SQL Server process ID
                      SQLTEXT:
                        type: string
                        maxLength: 50
                        description: First 50 characters of a SQL Server statement
                OBJECT_DETAIL:
                  type: array
                  items:
                    type: object
                    properties:
                      LISTINDEX:
                        type: integer
                        format: int32
                        description: SQL Server process ID
                      TEXTLINE:
                        type: string
                        maxLength: 3600
                        description: 'MS SQL Server: MSSTATS summary list'
                SPLIST:
                  type: array
                  items:
                    type: object
                    properties:
                      SPNAME:
                        type: string
                        maxLength: 128
                        description: Stored procedure name
                      TABNAME:
                        type: string
                        maxLength: 128
                        description: Table name
                      ABNAME:
                        type: string
                        maxLength: 40
                        description: ABAP Program Name
                      ABLOCAT:
                        type: integer
                        format: int32
                        description: Offset of a Processing Control Block
                      NCALL:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS number calls'
                      TOTAL_MS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS total runtime'
                      AVG_MS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS average runtime'
                      MAX_MS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS maximum run time'
                      MIN_MS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS minimum runtime'
                      RF_TOT_MS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS total runtime w/ fetch'
                      RF_AVG_MS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS average runtime w/fetch'
                      RF_MAX_MS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS max runtime w/ fetch'
                      RF_MIN_MS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS Minimum runtim w/ fetch'
                      MIN_ROWS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS minimum rows returned'
                      MAX_ROWS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS maximum rows returned'
                      TOTAL_ROWS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS total rows returned'
                      AVG_ROWS:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS average rows returned'
                      PCURSOR:
                        type: string
                        maxLength: 1
                        description: 'MS SQL Server: SP Statistics MSSTATS cursor usage'
                      ROW_COUNT:
                        type: integer
                        format: int32
                        description: 'MS SQL Server: SP Statistics MSSTATS row count'
                      RF_MS:
                        type: integer
                        format: int32
                        description: The total runtime in ms of the call with the longest runtime
                      STMTTYPE:
                        type: string
                        maxLength: 20
                        description: 'MS SQL Server: SP Statistics MSSTATS statement type'
                      NSERVERS:
                        type: integer
                        format: int32
                        description: MS SQL Server MSSTATAS number of servers
                      INSTANCE:
                        type: string
                        maxLength: 40
                        description: Application Server Name
                      ROWPERMS:
                        type: integer
                        format: int64
                        description: MS SQL Server Extended MSSTATS Column Rows per MS
                      LISTINDEX:
                        type: integer
                        format: int32
                        description: SQL Server process ID
                      SQLTEXT:
                        type: string
                        maxLength: 50
                        description: First 50 characters of a SQL Server statement
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  SUMMARY:
                    type: object
                    properties:
                      SPNAME:
                        type: string
                        maxLength: 128
                        description: Stored procedure name
                      NCALL:
                        type: integer
                        format: int64
                        description: 'MS SQL Server: MSSTATS summary of number of calls'
                      TOTAL_MS:
                        type: integer
                        format: int64
                        description: 'MS SQL Server: MSSTATS summary of total runtime'
                      AVG_MS:
                        type: integer
                        format: int64
                        description: 'MS SQL Server: MSSTATS summary of average runtime'
                      MAX_MS:
                        type: integer
                        format: int64
                        description: 'MS SQL Server: MSSTATS summary of maximum runtime'
                      MIN_MS:
                        type: integer
                        format: int64
                        description: 'MS SQL Server: MSSTATS summary of minimum runtime'
                      RF_TOT_MS:
                        type: integer
                        format: int64
                        description: MS SQL Server MSSTATS summary of total runtime w/ fetch
                      RF_AVG_MS:
                        type: integer
                        format: int64
                        description: MS SQL Server MSSTATS summary of average runtime w/ fetch
                      RF_MAX_MS:
                        type: integer
                        format: int64
                        description: MS SQL Server MSSTATS maximum runtime with fetch
                      RF_MIN_MS:
                        type: integer
                        format: int64
                        description: MS SQL Server MSSTATS summary of minimum runtime w/ fetch
                      MIN_ROWS:
                        type: integer
                        format: int64
                        description: 'MS SQL Server: MSSTATS minimum rows returned'
                      MAX_ROWS:
                        type: integer
                        format: int64
                        description: 'MS SQL Server: MSSTATS summary of maximum rows returned'
                      TOTAL_ROWS:
                        type: integer
                        format: int64
                        description: 'MS SQL Server: MSSTATS summary of total rows returned'
                      AVG_ROWS:
                        type: integer
                        format: int64
                        description: 'MS SQL Server: MSSTATS summary of average rows returned'
                      PCURSOR:
                        type: integer
                        format: int64
                        description: 'MS SQL Server: MSSTATS summary of number of calls'
                      ROW_COUNT:
                        type: integer
                        format: int64
                        description: 'MS SQL Server: MSSTATS summary of rows count'
                      RF_MS:
                        type: integer
                        format: int64
                        description: MS SQL Server MSSTATS summary of total runtime of max_ms
                      ROWPERMS:
                        type: integer
                        format: int64
                        description: MS SQL Server Extended MSSTATS Column Rows per MS
                  CACHE_OBJECTS:
                    type: array
                    items:
                      type: object
                      properties:
                        BUCKETID:
                          type: integer
                          format: int32
                          description: Cache object bucket ID
                        CACOBJTYPE:
                          type: string
                          maxLength: 35
                          description: Type of the object in the cache
                        OBJTYPE:
                          type: string
                          maxLength: 16
                          description: SQL Server classification of object
                        OBJID:
                          type: string
                          maxLength: 255
                          description: The  name of the object in cache
                        DBID:
                          type: integer
                          format: int32
                          description: MS SQL server database Id
                        CO_UID:
                          type: integer
                          format: int32
                          description: MS SQL server - user identification id
                        REFCOUNTS:
                          type: integer
                          format: int32
                          description: The number of other cache objects referencing this object
                        USECOUNTS:
                          type: integer
                          format: int32
                          description: The number of times this cache object has been used
                        PAGEUSED:
                          type: integer
                          format: int32
                          description: The number of pages consumed by this cache object
                        SETOPTS:
                          type: integer
                          format: int32
                          description: The SET options for a cache object; part of cache key
                        LANGID:
                          type: integer
                          format: int32
                          description: The language id of the connection that created cache object
                        DATEFORMAT:
                          type: integer
                          format: int32
                          description: The date format of the connection that created the cache obj
                        STATUS:
                          type: integer
                          format: int32
                          description: The status of the cache object
                        SQLBYTES:
                          type: integer
                          format: int32
                          description: The length of the cache object submitted.
                        CO_SQL:
                          type: string
                          maxLength: 3900
                          description: Procedure name or first 128 bytes of the submitted batch
                        LASTTIME:
                          type: integer
                          format: int64
                          description: Time statement took to execute last time
                        MAXEXECT:
                          type: integer
                          format: int64
                          description: Maximum execution time
                        AVGEXECT:
                          type: integer
                          format: int64
                          description: Average runtime
                        LASTRD:
                          type: integer
                          format: int64
                          description: Amount of data read during last execution
                        LASTWR:
                          type: integer
                          format: int64
                          description: Amount of data written during last execution
                        MINLOAD:
                          type: integer
                          format: int64
                          description: Database load  (ms)
                  MSSTATS_LIST:
                    type: array
                    items:
                      type: object
                      properties:
                        SPNAME:
                          type: string
                          maxLength: 128
                          description: Stored procedure name
                        TABNAME:
                          type: string
                          maxLength: 128
                          description: Table name
                        ABNAME:
                          type: string
                          maxLength: 40
                          description: ABAP Program Name
                        ABLOCAT:
                          type: integer
                          format: int32
                          description: Offset of a Processing Control Block
                        NCALL:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS number calls'
                        TOTAL_MS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS total runtime'
                        AVG_MS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS average runtime'
                        MAX_MS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS maximum run time'
                        MIN_MS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS minimum runtime'
                        RF_TOT_MS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS total runtime w/ fetch'
                        RF_AVG_MS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS average runtime w/fetch'
                        RF_MAX_MS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS max runtime w/ fetch'
                        RF_MIN_MS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS Minimum runtim w/ fetch'
                        MIN_ROWS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS minimum rows returned'
                        MAX_ROWS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS maximum rows returned'
                        TOTAL_ROWS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS total rows returned'
                        AVG_ROWS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS average rows returned'
                        PCURSOR:
                          type: string
                          maxLength: 1
                          description: 'MS SQL Server: SP Statistics MSSTATS cursor usage'
                        ROW_COUNT:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS row count'
                        RF_MS:
                          type: integer
                          format: int32
                          description: The total runtime in ms of the call with the longest runtime
                        STMTTYPE:
                          type: string
                          maxLength: 20
                          description: 'MS SQL Server: SP Statistics MSSTATS statement type'
                        NSERVERS:
                          type: integer
                          format: int32
                          description: MS SQL Server MSSTATAS number of servers
                        INSTANCE:
                          type: string
                          maxLength: 40
                          description: Application Server Name
                        ROWPERMS:
                          type: integer
                          format: int64
                          description: MS SQL Server Extended MSSTATS Column Rows per MS
                        LISTINDEX:
                          type: integer
                          format: int32
                          description: SQL Server process ID
                        SQLTEXT:
                          type: string
                          maxLength: 50
                          description: First 50 characters of a SQL Server statement
                  OBJECT_DETAIL:
                    type: array
                    items:
                      type: object
                      properties:
                        LISTINDEX:
                          type: integer
                          format: int32
                          description: SQL Server process ID
                        TEXTLINE:
                          type: string
                          maxLength: 3600
                          description: 'MS SQL Server: MSSTATS summary list'
                  SPLIST:
                    type: array
                    items:
                      type: object
                      properties:
                        SPNAME:
                          type: string
                          maxLength: 128
                          description: Stored procedure name
                        TABNAME:
                          type: string
                          maxLength: 128
                          description: Table name
                        ABNAME:
                          type: string
                          maxLength: 40
                          description: ABAP Program Name
                        ABLOCAT:
                          type: integer
                          format: int32
                          description: Offset of a Processing Control Block
                        NCALL:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS number calls'
                        TOTAL_MS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS total runtime'
                        AVG_MS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS average runtime'
                        MAX_MS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS maximum run time'
                        MIN_MS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS minimum runtime'
                        RF_TOT_MS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS total runtime w/ fetch'
                        RF_AVG_MS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS average runtime w/fetch'
                        RF_MAX_MS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS max runtime w/ fetch'
                        RF_MIN_MS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS Minimum runtim w/ fetch'
                        MIN_ROWS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS minimum rows returned'
                        MAX_ROWS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS maximum rows returned'
                        TOTAL_ROWS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS total rows returned'
                        AVG_ROWS:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS average rows returned'
                        PCURSOR:
                          type: string
                          maxLength: 1
                          description: 'MS SQL Server: SP Statistics MSSTATS cursor usage'
                        ROW_COUNT:
                          type: integer
                          format: int32
                          description: 'MS SQL Server: SP Statistics MSSTATS row count'
                        RF_MS:
                          type: integer
                          format: int32
                          description: The total runtime in ms of the call with the longest runtime
                        STMTTYPE:
                          type: string
                          maxLength: 20
                          description: 'MS SQL Server: SP Statistics MSSTATS statement type'
                        NSERVERS:
                          type: integer
                          format: int32
                          description: MS SQL Server MSSTATAS number of servers
                        INSTANCE:
                          type: string
                          maxLength: 40
                          description: Application Server Name
                        ROWPERMS:
                          type: integer
                          format: int64
                          description: MS SQL Server Extended MSSTATS Column Rows per MS
                        LISTINDEX:
                          type: integer
                          format: int32
                          description: SQL Server process ID
                        SQLTEXT:
                          type: string
                          maxLength: 50
                          description: First 50 characters of a SQL Server statement
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
