openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/GET_SYSCACHESTATS_MSQ:
    post:
      tags:
      - SFMSS_SYSTAB
      summary: retrieve the contents of syscacheobjects
      operationId: /rfc/GET_SYSCACHESTATS_MSQ
      requestBody:
        content:
          application/json:
            schema:
              properties:
                COMPILED:
                  type: string
                  maxLength: 1
                  description: SQL Server flag 'Y' if true , 'N' if false
                CON_NAME:
                  type: string
                  default: DEFAULT
                  maxLength: 30
                  description: Logical name of a database connection
                OBJTYPE:
                  type: string
                  maxLength: 16
                  description: SQL Server classification of object
                SCHEMA:
                  type: string
                  default: ' '
                  maxLength: 128
                  description: Target schema
                SQL:
                  type: string
                  maxLength: 128
                  description: MS SQL server stored procedure name
                CACHESTATS:
                  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
      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
                        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
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
