openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/MSQ_TABANDIND_INFO:
    post:
      tags:
      - STUL
      summary: SQL Server get table and index statistics for a given table
      operationId: /rfc/MSQ_TABANDIND_INFO
      requestBody:
        content:
          application/json:
            schema:
              properties:
                TABNAME:
                  type: string
                  maxLength: 128
                  description: SQL Server table or index name
                INDEX_STATS:
                  type: array
                  items:
                    type: object
                    properties:
                      ANLYID:
                        type: string
                        maxLength: 14
                        description: SQL Server analysis ID for statement download
                      TABNAME:
                        type: string
                        maxLength: 256
                        description: SQL Server table name
                      IDXNAME:
                        type: string
                        maxLength: 256
                        description: SQL Server index name
                      IDXDESC:
                        type: string
                        maxLength: 210
                        description: SQL Server index description
                      IDXKEYS:
                        type: string
                        maxLength: 2078
                        description: SQL Server table index details
                      IDXHGT:
                        type: integer
                        format: int32
                        description: SQL Server height of the index
                      ROWMINLEN:
                        type: integer
                        format: int32
                        description: SQL server minimum size of the row
                      ROWMAXLEN:
                        type: integer
                        format: int32
                        description: SQL Server maximum size of the row
                      ROWMODCTR:
                        type: integer
                        format: int32
                        description: SQL Server modified rows in the table since last upd stats
                      AUTOUPDFLG:
                        type: string
                        maxLength: 3
                        description: SQL Server auto update flag
                      UPDDATE:
                        type: string
                        maxLength: 30
                        description: SQL Server last update statististics
                      TOTALROWS:
                        type: integer
                        format: int32
                        description: SQL Server total number of rows
                      ROWSAMPLED:
                        type: integer
                        format: int32
                        description: SQL Server number of sampled rows
                      STEPS:
                        type: integer
                        format: int32
                        description: SQL Server number of steps in histogram
                      DENSITY:
                        type: number
                        description: SQL Server density
                      AVGKEYLEN:
                        type: integer
                        format: int64
                        description: SQL Server index statistics avg key length
                      ALLDENSITY:
                        type: number
                        description: SQL Server column density
                      ALLDENSCOL:
                        type: string
                        maxLength: 256
                        description: SQL Server index field
                TABLE_STATS:
                  type: array
                  items:
                    type: object
                    properties:
                      ANLYID:
                        type: string
                        maxLength: 14
                        description: SQL Server analysis ID for statement download
                      TABNAME:
                        type: string
                        maxLength: 256
                        description: SQL Server table or index name
                      RESERVED:
                        type: integer
                        format: int32
                        description: SQL Server reserved size of table
                      DATASIZE:
                        type: integer
                        format: int32
                        description: SQL Server total used size of table
                      INDEXSIZE:
                        type: integer
                        format: int32
                        description: SQL Server total size of all indexes
                      UNUSEDSIZ:
                        type: integer
                        format: int32
                        description: SQL Server total unused size
                      TOTALROWS:
                        type: integer
                        format: int32
                        description: SQL Server number of rows in a table
                      MINLEN:
                        type: integer
                        format: int32
                        description: SQL Server minimum size of the row
                      MAXLEN:
                        type: integer
                        format: int32
                        description: SQL Server maximum size of the row
                      ROWMODCTR:
                        type: integer
                        format: int32
                        description: SQL Server modified rows since upd stats
                      SCHEMAVER:
                        type: integer
                        format: int32
                        description: SQL Server count of changes in schema
                      SCANDENS:
                        type: integer
                        format: int32
                        description: SQL Server table scan density
                      FILEGID:
                        type: integer
                        format: int32
                        description: SQL Server file group ID
                      LASTCHUSER:
                        type: string
                        maxLength: 12
                        description: SQL Server user last table change
                      LCHDATE:
                        type: string
                        format: date
                        description: SQL Server date of last change
                      LCHTIME:
                        type: string
                        maxLength: 6
                        description: SQL Server time of last change
                      BUFFERING:
                        type: string
                        maxLength: 1
                        description: SQL Server table buffering
                      GENBUFFFLD:
                        type: integer
                        format: int64
                        description: SQL Server number of gen buffered fields
                      BUFSTATE:
                        type: string
                        maxLength: 1
                        description: SQL Server table buffering on/off
              required:
              - TABNAME
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  INDEX_STATS:
                    type: array
                    items:
                      type: object
                      properties:
                        ANLYID:
                          type: string
                          maxLength: 14
                          description: SQL Server analysis ID for statement download
                        TABNAME:
                          type: string
                          maxLength: 256
                          description: SQL Server table name
                        IDXNAME:
                          type: string
                          maxLength: 256
                          description: SQL Server index name
                        IDXDESC:
                          type: string
                          maxLength: 210
                          description: SQL Server index description
                        IDXKEYS:
                          type: string
                          maxLength: 2078
                          description: SQL Server table index details
                        IDXHGT:
                          type: integer
                          format: int32
                          description: SQL Server height of the index
                        ROWMINLEN:
                          type: integer
                          format: int32
                          description: SQL server minimum size of the row
                        ROWMAXLEN:
                          type: integer
                          format: int32
                          description: SQL Server maximum size of the row
                        ROWMODCTR:
                          type: integer
                          format: int32
                          description: SQL Server modified rows in the table since last upd stats
                        AUTOUPDFLG:
                          type: string
                          maxLength: 3
                          description: SQL Server auto update flag
                        UPDDATE:
                          type: string
                          maxLength: 30
                          description: SQL Server last update statististics
                        TOTALROWS:
                          type: integer
                          format: int32
                          description: SQL Server total number of rows
                        ROWSAMPLED:
                          type: integer
                          format: int32
                          description: SQL Server number of sampled rows
                        STEPS:
                          type: integer
                          format: int32
                          description: SQL Server number of steps in histogram
                        DENSITY:
                          type: number
                          description: SQL Server density
                        AVGKEYLEN:
                          type: integer
                          format: int64
                          description: SQL Server index statistics avg key length
                        ALLDENSITY:
                          type: number
                          description: SQL Server column density
                        ALLDENSCOL:
                          type: string
                          maxLength: 256
                          description: SQL Server index field
                  TABLE_STATS:
                    type: array
                    items:
                      type: object
                      properties:
                        ANLYID:
                          type: string
                          maxLength: 14
                          description: SQL Server analysis ID for statement download
                        TABNAME:
                          type: string
                          maxLength: 256
                          description: SQL Server table or index name
                        RESERVED:
                          type: integer
                          format: int32
                          description: SQL Server reserved size of table
                        DATASIZE:
                          type: integer
                          format: int32
                          description: SQL Server total used size of table
                        INDEXSIZE:
                          type: integer
                          format: int32
                          description: SQL Server total size of all indexes
                        UNUSEDSIZ:
                          type: integer
                          format: int32
                          description: SQL Server total unused size
                        TOTALROWS:
                          type: integer
                          format: int32
                          description: SQL Server number of rows in a table
                        MINLEN:
                          type: integer
                          format: int32
                          description: SQL Server minimum size of the row
                        MAXLEN:
                          type: integer
                          format: int32
                          description: SQL Server maximum size of the row
                        ROWMODCTR:
                          type: integer
                          format: int32
                          description: SQL Server modified rows since upd stats
                        SCHEMAVER:
                          type: integer
                          format: int32
                          description: SQL Server count of changes in schema
                        SCANDENS:
                          type: integer
                          format: int32
                          description: SQL Server table scan density
                        FILEGID:
                          type: integer
                          format: int32
                          description: SQL Server file group ID
                        LASTCHUSER:
                          type: string
                          maxLength: 12
                          description: SQL Server user last table change
                        LCHDATE:
                          type: string
                          format: date
                          description: SQL Server date of last change
                        LCHTIME:
                          type: string
                          maxLength: 6
                          description: SQL Server time of last change
                        BUFFERING:
                          type: string
                          maxLength: 1
                          description: SQL Server table buffering
                        GENBUFFFLD:
                          type: integer
                          format: int64
                          description: SQL Server number of gen buffered fields
                        BUFSTATE:
                          type: string
                          maxLength: 1
                          description: SQL Server table buffering on/off
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
