openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/MSS_GET_SYSCACHESTATS:
    post:
      tags:
      - SFMSS_SYSTAB
      summary: retrieve the contents of syscacheobjects
      operationId: /rfc/MSS_GET_SYSCACHESTATS
      requestBody:
        content:
          application/json:
            schema:
              properties:
                BY_WHAT:
                  type: string
                  default: TOTALEXECTIME
                  maxLength: 15
                  description: Sorted by this column
                CON_NAME:
                  type: string
                  default: DEFAULT
                  maxLength: 30
                  description: Logical name of a database connection
                NROWS:
                  type: integer
                  format: int32
                  default: 300
                  description: Top n rows
                SCHEMA:
                  type: string
                  default: ' '
                  maxLength: 128
                  description: Target schema
                CACHESTATS:
                  type: array
                  items:
                    type: object
                    properties:
                      BUCKETID:
                        type: integer
                        format: int32
                        description: Cache object bucket ID
                      OBJTYPE:
                        type: string
                        maxLength: 16
                        description: SQL Server classification of object
                      DBNAME:
                        type: string
                        maxLength: 128
                        description: Database name
                      CO_UID:
                        type: string
                        maxLength: 128
                        description: Schema name
                      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: string
                        maxLength: 1
                        description: 'MS SQL Server: SP Statistics MSSTATS cursor usage'
                      CO_SQL:
                        type: string
                        maxLength: 3600
                        description: MS SQL command string
                      DBLOAD:
                        type: integer
                        format: int64
                        description: Database load  (ms)
                      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
                      PARAMS:
                        type: string
                        maxLength: 3900
                        description: MS SQL Statement arguments
                      ABNAME:
                        type: string
                        maxLength: 40
                        description: ABAP Program Name
                      ABLOCAT:
                        type: integer
                        format: int32
                        description: Offset of a Processing Control Block
                      TABNAME:
                        type: string
                        maxLength: 128
                        description: Table name
                      SPNAME:
                        type: string
                        maxLength: 128
                        description: Stored procedure name
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  CACHESTATS:
                    type: array
                    items:
                      type: object
                      properties:
                        BUCKETID:
                          type: integer
                          format: int32
                          description: Cache object bucket ID
                        OBJTYPE:
                          type: string
                          maxLength: 16
                          description: SQL Server classification of object
                        DBNAME:
                          type: string
                          maxLength: 128
                          description: Database name
                        CO_UID:
                          type: string
                          maxLength: 128
                          description: Schema name
                        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: string
                          maxLength: 1
                          description: 'MS SQL Server: SP Statistics MSSTATS cursor usage'
                        CO_SQL:
                          type: string
                          maxLength: 3600
                          description: MS SQL command string
                        DBLOAD:
                          type: integer
                          format: int64
                          description: Database load  (ms)
                        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
                        PARAMS:
                          type: string
                          maxLength: 3900
                          description: MS SQL Statement arguments
                        ABNAME:
                          type: string
                          maxLength: 40
                          description: ABAP Program Name
                        ABLOCAT:
                          type: integer
                          format: int32
                          description: Offset of a Processing Control Block
                        TABNAME:
                          type: string
                          maxLength: 128
                          description: Table name
                        SPNAME:
                          type: string
                          maxLength: 128
                          description: Stored procedure name
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
