openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/SQL_MSSQL_ANALYSIS_READ:
    post:
      tags:
      - STUL
      summary: SQL Server read SQL Statements out of Stored Procedure Stats into Moni
      operationId: /rfc/SQL_MSSQL_ANALYSIS_READ
      requestBody:
        content:
          application/json:
            schema:
              properties:
                ADDONKEY:
                  type: string
                  maxLength: 128
                  description: Generic key for add-on data collection
                NOOFSTMTS:
                  type: integer
                  format: int32
                  description: SQL Server MSSTATS number of calls
                TIMELIMIT:
                  type: integer
                  format: int32
                  description: SQL Server MSSTATS number of calls
                INDEX_FIELDS:
                  type: array
                  items:
                    type: object
                    properties:
                      DDLANGUAGE:
                        type: string
                        maxLength: 1
                        description: Language key
                      TABNAME:
                        type: string
                        maxLength: 30
                        description: Table name
                      INDEXNAME:
                        type: string
                        maxLength: 3
                        description: Unique index ID within a table
                      INDEXPOS:
                        type: integer
                        format: int64
                        description: Position of the field in the table
                      FIELDNAME:
                        type: string
                        maxLength: 30
                        description: Field name
                INDEX_HEADER:
                  type: array
                  items:
                    type: object
                    properties:
                      TABNAME:
                        type: string
                        maxLength: 30
                        description: Table name
                      INDEXNAME:
                        type: string
                        maxLength: 3
                        description: Unique index ID within a table
                      LASTCHANG:
                        type: string
                        maxLength: 12
                        description: Last changed by
                      UNIQUEFLAG:
                        type: string
                        maxLength: 1
                        description: Flag for UNIQUE indexes
                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
                JOIN_CONDITIONS:
                  type: array
                  items:
                    type: object
                    properties:
                      VIEWNAME:
                        type: string
                        maxLength: 30
                        description: Name of SAP table view
                      LTAB:
                        type: string
                        maxLength: 30
                        description: Table Name
                      LFIELD:
                        type: string
                        maxLength: 30
                        description: Field name
                      OPERATOR:
                        type: string
                        maxLength: 2
                        description: 'Operator in a selection condition  enumValues: NE=Not equal to,GT=Greater than,LE=less than or equal to,EQ=Equal to,LK=Like mask (allowed meta characters: ''_'' and ''%''),LT=Smaller than,GE=Greater than or equal to'
                        enum:
                        - NE
                        - GT
                        - LE
                        - EQ
                        - LK
                        - LT
                        - GE
                      RTAB:
                        type: string
                        maxLength: 30
                        description: Table Name
                      RFIELD:
                        type: string
                        maxLength: 30
                        description: Field name
                      SOURCE:
                        type: string
                        maxLength: 1
                        description: Single-Character Flag
                      FRKTAB:
                        type: string
                        maxLength: 30
                        description: Table Name
                      FRKFIELD:
                        type: string
                        maxLength: 30
                        description: Field Name
                      FRKDIR:
                        type: string
                        maxLength: 1
                        description: 'Direction of Foreign Key Dependency  enumValues: I=Import,E=Export'
                        enum:
                        - I
                        - E
                      VOPERATOR:
                        type: string
                        maxLength: 8
                        description: 'Operator in a selection condition (screen field)  enumValues: NOT LIKE=NOT LIKE pattern (invalid metachars: ''_'' and ''%''),<=Less than,>=Greater than,<==less than or equal to,GT=Greater than (>),LIKE=LIKE pattern (valid metacharacters: ''_'' and ''%''),==Equal to,LT=Less than (<),EQ=Equal to (=),<>=Not equal to,LE=Less than or equal to (<=),GE=Greater than or equal to (>=),NE=Not equal to (<>),>==Greater than or equal to'
                        enum:
                        - NOT LIKE
                        - <
                        - '>'
                        - <=
                        - GT
                        - LIKE
                        - =
                        - LT
                        - EQ
                        - <>
                        - LE
                        - GE
                        - NE
                        - '>='
                MSSTATS_LIST:
                  type: array
                  items:
                    type: object
                    properties:
                      ANLYID:
                        type: string
                        maxLength: 14
                        description: SQL Server statement download analysis id
                      STMT_ID:
                        type: string
                        maxLength: 2
                        description: SQL Server statement download statement id
                      SPNAME:
                        type: string
                        maxLength: 255
                        description: SQL server stored procedure name
                      NCALL:
                        type: integer
                        format: int32
                        description: SQL Server MSSTATS number of calls
                      TOTAL_MS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS total runtime
                      AVG_MS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS average runtime
                      MAX_MS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS maximum runtime
                      MIN_MS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS minimum runtime
                      RF_TOT_MS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS total runtime w/ fetch
                      RF_AVG_MS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS average runtime w/ fetch
                      RF_MAX_MS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS maximum runtime w/ fetch
                      RF_MIN_MS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS minimum runtime w/ fetch
                      MIN_ROWS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS minimum rows
                      MAX_ROWS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS maximum riws
                      TOTAL_ROWS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS total rows
                      AVG_ROWS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS average rows
                      PCURSOR:
                        type: string
                        maxLength: 1
                        description: SQL Server MSSTATS cursor used?
                      ROW_COUNT:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS row count of longest call
                      RF_MS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS total runtime of longest call
                      STMTTYPE:
                        type: string
                        maxLength: 20
                        description: SQL Server MSSTATS statement type
                      OBJNAME:
                        type: string
                        maxLength: 256
                        description: SQL Server MSSTATS object name
                      INSTANCE:
                        type: string
                        maxLength: 20
                        description: SQL Server MSSTATS instance name
                      TIMEPROW:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS time per row
                      SQLTEXT:
                        type: string
                        maxLength: 50
                        description: First 50 characters of a SQL Server statement
                PHYS_TABLES:
                  type: array
                  items:
                    type: object
                    properties:
                      DDLANGUAGE:
                        type: string
                        maxLength: 1
                        description: 'R/3: Sprachenschluessel'
                      VIEWNAME:
                        type: string
                        maxLength: 30
                        description: Name eines SAP-Tabellenviews
                      TABNAME:
                        type: string
                        maxLength: 30
                        description: Tabellenname
                      TABPOS:
                        type: integer
                        format: int64
                        description: Position in einer Wiederholgruppe
                      FORTABNAME:
                        type: string
                        maxLength: 30
                        description: Tabellenname
                      FORFIELD:
                        type: string
                        maxLength: 30
                        description: Feldname
                      FORDIR:
                        type: string
                        maxLength: 1
                        description: Richtung einer Fremdschluesselbeziehung
                PROG_INFO:
                  type: array
                  items:
                    type: object
                    properties:
                      ANLYID:
                        type: string
                        maxLength: 14
                        description: SQL Server analysis ID for statement download
                      STMTID:
                        type: string
                        maxLength: 2
                        description: SQL Server statement ID in a statement analysis
                      PROGNAME:
                        type: string
                        maxLength: 40
                        description: SQL Server statement download
                      CREABY:
                        type: string
                        maxLength: 12
                        description: SQL Server statement download prog info creator
                      CREADATE:
                        type: string
                        format: date
                        description: SQL Server program create date
                      LCHANGBY:
                        type: string
                        maxLength: 12
                        description: SQL Server statement download
                      LCHANGDAT:
                        type: string
                        format: date
                        description: SQL Serever program change date
                SELECTION_CONDITIONS:
                  type: array
                  items:
                    type: object
                    properties:
                      DDLANGUAGE:
                        type: string
                        maxLength: 1
                        description: Language Key
                      CONDNAME:
                        type: string
                        maxLength: 30
                        description: Selection condition ID
                      POSITION:
                        type: integer
                        format: int64
                        description: Position in a repetition group
                      TABNAME:
                        type: string
                        maxLength: 30
                        description: Table Name
                      FIELDNAME:
                        type: string
                        maxLength: 30
                        description: Field name
                      NEGATION:
                        type: string
                        maxLength: 3
                        description: 'NOT operator in selection conditions  enumValues: NOT=Negation'
                        enum:
                        - NOT
                      OPERATOR:
                        type: string
                        maxLength: 2
                        description: 'Operator in a selection condition  enumValues: NE=Not equal to,GT=Greater than,LE=less than or equal to,EQ=Equal to,LK=Like mask (allowed meta characters: ''_'' and ''%''),LT=Smaller than,GE=Greater than or equal to'
                        enum:
                        - NE
                        - GT
                        - LE
                        - EQ
                        - LK
                        - LT
                        - GE
                      CONSTANTS:
                        type: string
                        maxLength: 38
                        description: Constant in selection conditions
                      CONTLINE:
                        type: string
                        maxLength: 1
                        description: 'Flag for continuation line in selection conditions  enumValues: ""=Do not set flag,X=Set flag'
                        enum:
                        - ''
                        - X
                      AND_OR:
                        type: string
                        maxLength: 3
                        description: 'AND/OR link in a selection condition  enumValues: AND=AND operation,OR=OR operation'
                        enum:
                        - AND
                        - OR
                      OFFSET:
                        type: integer
                        format: int64
                        description: Offset within a matchcode field
                      FLENGTH:
                        type: integer
                        format: int64
                        description: Field length within a MC ID
                      MCOFIELD:
                        type: string
                        maxLength: 30
                        description: Matchcode field name
                SERVER_INFO:
                  type: array
                  items:
                    type: object
                    properties:
                      ANLYID:
                        type: string
                        maxLength: 14
                        description: SQL Server statement download analysis ID
                      HOSTNAME:
                        type: string
                        maxLength: 20
                        description: SQL Server hostname
                      INSTNAME:
                        type: string
                        maxLength: 20
                        description: SQL Server R/3 instance name
                      RESETTIME:
                        type: string
                        maxLength: 24
                        description: SQL Server time at which client process logged in
                      COLLECTING:
                        type: string
                        maxLength: 1
                        description: SQL Server MSSTATS collection switched on/off
                      OLESTATSON:
                        type: string
                        maxLength: 1
                        description: SQL Server MSSTATS profile parameter for on/off
                      MSQSTATSON:
                        type: string
                        maxLength: 1
                        description: SQL Server MSSTATS profile parameter for on/off
                      DLLDATE:
                        type: string
                        maxLength: 24
                        description: SQL Server DB library creation date
                STMT_EXPLAIN:
                  type: array
                  items:
                    type: object
                    properties:
                      ANLYID:
                        type: string
                        maxLength: 14
                        description: SQL Server analysis ID for statement download
                      STMTID:
                        type: string
                        maxLength: 2
                        description: SQL Server statement ID in a statement analysis
                      TDFORMAT:
                        type: string
                        maxLength: 2
                        description: Tag column
                      TDLINE:
                        type: string
                        maxLength: 132
                        description: Text Line
                STMT_STRING:
                  type: array
                  items:
                    type: object
                    properties:
                      ANLYID:
                        type: string
                        maxLength: 14
                        description: SQL Server analysis ID for statement download
                      STMTID:
                        type: string
                        maxLength: 2
                        description: SQL Server statement ID in a statement analysis
                      TDFORMAT:
                        type: string
                        maxLength: 2
                        description: Tag column
                      TDLINE:
                        type: string
                        maxLength: 132
                        description: Text Line
                TABLELIST:
                  type: array
                  items:
                    type: object
                    properties:
                      ANLYID:
                        type: string
                        maxLength: 14
                        description: SQL Server statement download analysis ID
                      STMT_ID:
                        type: string
                        maxLength: 2
                        description: SQL Server statement download statement ID
                      TABNAME:
                        type: string
                        maxLength: 256
                        description: SQL Server statement download table name
                TABLE_FIELDS:
                  type: array
                  items:
                    type: object
                    properties:
                      TABNAME:
                        type: string
                        maxLength: 30
                        description: Table name
                      FIELDNAME:
                        type: string
                        maxLength: 30
                        description: Field name
                      POSITION:
                        type: integer
                        format: int64
                        description: Position of the field in the table
                      DDLANGUAGE:
                        type: string
                        maxLength: 1
                        description: Language key
                      DDTEXT:
                        type: string
                        maxLength: 60
                        description: Short text describing R/3 Repository objects
                      BASTABNAME:
                        type: string
                        maxLength: 30
                        description: Table name
                TABLE_HEADER:
                  type: array
                  items:
                    type: object
                    properties:
                      TABNAME:
                        type: string
                        maxLength: 30
                        description: Table name
                      DDLANGUAGE:
                        type: string
                        maxLength: 1
                        description: Language key
                      DDTEXT:
                        type: string
                        maxLength: 60
                        description: Explanatory short text
                      BUFFERTYPE:
                        type: string
                        maxLength: 1
                        description: Buffering type indicator
                      TABCLASS:
                        type: string
                        maxLength: 8
                        description: Table type
                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
                VIEW_TABLES:
                  type: array
                  items:
                    type: object
                    properties:
                      DDLANGUAGE:
                        type: string
                        maxLength: 1
                        description: Language Key
                      VIEWNAME:
                        type: string
                        maxLength: 30
                        description: Name of SAP table view
                      TABNAME:
                        type: string
                        maxLength: 30
                        description: Table Name
                      TABPOS:
                        type: integer
                        format: int64
                        description: Position in a repetition group
                      FORTABNAME:
                        type: string
                        maxLength: 30
                        description: Table Name
                      FORFIELD:
                        type: string
                        maxLength: 30
                        description: Field Name
                      FORDIR:
                        type: string
                        maxLength: 1
                        description: 'Direction of Foreign Key Dependency  enumValues: I=Import,E=Export'
                        enum:
                        - I
                        - E
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  DBSUMMARY:
                    type: object
                    properties:
                      ANLYID:
                        type: string
                        maxLength: 14
                        description: SQL Server statement download analysis ID
                      ACTUALDAY:
                        type: string
                        format: date
                        description: SQL Server analysis date
                      ACTUALTIME:
                        type: string
                        maxLength: 6
                        description: SQL Server analysis time
                      VERSION:
                        type: string
                        maxLength: 50
                        description: SQL Server version
                      NOSERVERS:
                        type: integer
                        format: int32
                        description: SQL Server servers
                      NOSERVERON:
                        type: integer
                        format: int32
                        description: SQL Server servers with MSSTATS ON
                      REQBUFFPG:
                        type: integer
                        format: int32
                        description: SQL Server requests for buffer pages
                      SQLBATCHS:
                        type: integer
                        format: int32
                        description: SQL Server transact-SQL batches received
                      PAGEREADS:
                        type: integer
                        format: int32
                        description: SQL Server physical page reads
                      PAGEWRITES:
                        type: integer
                        format: int32
                        description: SQL Server physical page writes
                      TOTALCALLS:
                        type: integer
                        format: int32
                        description: SQL Server number of calls
                      TOTALRFTIM:
                        type: integer
                        format: int32
                        description: SQL Server total time with fetch
                  SUMMARY:
                    type: object
                    properties:
                      ANLYID:
                        type: string
                        maxLength: 14
                        description: SQL Server analysis ID for statement analysis
                      SPNAME:
                        type: string
                        maxLength: 255
                        description: SQL Server stored procedure name
                      NCALL:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS summary number of calls
                      TOTAL_MS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS summary total runtime
                      AVG_MS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS summary average runtime
                      MAX_MS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS summary maximum runtime
                      MIN_MS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS summary minimum runtime
                      RF_TOT_MS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS summary total runtime w/ fetch
                      RF_AVG_MS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS summary average runtime w/ fetch
                      RF_MAX_MS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS summary maximum runtime w/ fetch
                      RF_MIN_MS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS summary minimun runtime w/ fetch
                      MIN_ROWS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS summary minimum rows returned
                      MAX_ROWS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS summary maximum rows returned
                      TOTAL_ROWS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS summary total rows returned
                      AVG_ROWS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS summary average rows returned
                      PCURSOR:
                        type: string
                        maxLength: 1
                        description: SQL Server MSSTATS summary cursor used?
                      ROW_COUNT:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS summary row count of longest call
                      RF_MS:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS summary total runtime of longest call
                      TIMEPROW:
                        type: integer
                        format: int64
                        description: SQL Server MSSTATS time per row
                  INDEX_FIELDS:
                    type: array
                    items:
                      type: object
                      properties:
                        DDLANGUAGE:
                          type: string
                          maxLength: 1
                          description: Language key
                        TABNAME:
                          type: string
                          maxLength: 30
                          description: Table name
                        INDEXNAME:
                          type: string
                          maxLength: 3
                          description: Unique index ID within a table
                        INDEXPOS:
                          type: integer
                          format: int64
                          description: Position of the field in the table
                        FIELDNAME:
                          type: string
                          maxLength: 30
                          description: Field name
                  INDEX_HEADER:
                    type: array
                    items:
                      type: object
                      properties:
                        TABNAME:
                          type: string
                          maxLength: 30
                          description: Table name
                        INDEXNAME:
                          type: string
                          maxLength: 3
                          description: Unique index ID within a table
                        LASTCHANG:
                          type: string
                          maxLength: 12
                          description: Last changed by
                        UNIQUEFLAG:
                          type: string
                          maxLength: 1
                          description: Flag for UNIQUE indexes
                  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
                  JOIN_CONDITIONS:
                    type: array
                    items:
                      type: object
                      properties:
                        VIEWNAME:
                          type: string
                          maxLength: 30
                          description: Name of SAP table view
                        LTAB:
                          type: string
                          maxLength: 30
                          description: Table Name
                        LFIELD:
                          type: string
                          maxLength: 30
                          description: Field name
                        OPERATOR:
                          type: string
                          maxLength: 2
                          description: 'Operator in a selection condition  enumValues: NE=Not equal to,GT=Greater than,LE=less than or equal to,EQ=Equal to,LK=Like mask (allowed meta characters: ''_'' and ''%''),LT=Smaller than,GE=Greater than or equal to'
                          enum:
                          - NE
                          - GT
                          - LE
                          - EQ
                          - LK
                          - LT
                          - GE
                        RTAB:
                          type: string
                          maxLength: 30
                          description: Table Name
                        RFIELD:
                          type: string
                          maxLength: 30
                          description: Field name
                        SOURCE:
                          type: string
                          maxLength: 1
                          description: Single-Character Flag
                        FRKTAB:
                          type: string
                          maxLength: 30
                          description: Table Name
                        FRKFIELD:
                          type: string
                          maxLength: 30
                          description: Field Name
                        FRKDIR:
                          type: string
                          maxLength: 1
                          description: 'Direction of Foreign Key Dependency  enumValues: I=Import,E=Export'
                          enum:
                          - I
                          - E
                        VOPERATOR:
                          type: string
                          maxLength: 8
                          description: 'Operator in a selection condition (screen field)  enumValues: NOT LIKE=NOT LIKE pattern (invalid metachars: ''_'' and ''%''),<=Less than,>=Greater than,<==less than or equal to,GT=Greater than (>),LIKE=LIKE pattern (valid metacharacters: ''_'' and ''%''),==Equal to,LT=Less than (<),EQ=Equal to (=),<>=Not equal to,LE=Less than or equal to (<=),GE=Greater than or equal to (>=),NE=Not equal to (<>),>==Greater than or equal to'
                          enum:
                          - NOT LIKE
                          - <
                          - '>'
                          - <=
                          - GT
                          - LIKE
                          - =
                          - LT
                          - EQ
                          - <>
                          - LE
                          - GE
                          - NE
                          - '>='
                  MSSTATS_LIST:
                    type: array
                    items:
                      type: object
                      properties:
                        ANLYID:
                          type: string
                          maxLength: 14
                          description: SQL Server statement download analysis id
                        STMT_ID:
                          type: string
                          maxLength: 2
                          description: SQL Server statement download statement id
                        SPNAME:
                          type: string
                          maxLength: 255
                          description: SQL server stored procedure name
                        NCALL:
                          type: integer
                          format: int32
                          description: SQL Server MSSTATS number of calls
                        TOTAL_MS:
                          type: integer
                          format: int64
                          description: SQL Server MSSTATS total runtime
                        AVG_MS:
                          type: integer
                          format: int64
                          description: SQL Server MSSTATS average runtime
                        MAX_MS:
                          type: integer
                          format: int64
                          description: SQL Server MSSTATS maximum runtime
                        MIN_MS:
                          type: integer
                          format: int64
                          description: SQL Server MSSTATS minimum runtime
                        RF_TOT_MS:
                          type: integer
                          format: int64
                          description: SQL Server MSSTATS total runtime w/ fetch
                        RF_AVG_MS:
                          type: integer
                          format: int64
                          description: SQL Server MSSTATS average runtime w/ fetch
                        RF_MAX_MS:
                          type: integer
                          format: int64
                          description: SQL Server MSSTATS maximum runtime w/ fetch
                        RF_MIN_MS:
                          type: integer
                          format: int64
                          description: SQL Server MSSTATS minimum runtime w/ fetch
                        MIN_ROWS:
                          type: integer
                          format: int64
                          description: SQL Server MSSTATS minimum rows
                        MAX_ROWS:
                          type: integer
                          format: int64
                          description: SQL Server MSSTATS maximum riws
                        TOTAL_ROWS:
                          type: integer
                          format: int64
                          description: SQL Server MSSTATS total rows
                        AVG_ROWS:
                          type: integer
                          format: int64
                          description: SQL Server MSSTATS average rows
                        PCURSOR:
                          type: string
                          maxLength: 1
                          description: SQL Server MSSTATS cursor used?
                        ROW_COUNT:
                          type: integer
                          format: int64
                          description: SQL Server MSSTATS row count of longest call
                        RF_MS:
                          type: integer
                          format: int64
                          description: SQL Server MSSTATS total runtime of longest call
                        STMTTYPE:
                          type: string
                          maxLength: 20
                          description: SQL Server MSSTATS statement type
                        OBJNAME:
                          type: string
                          maxLength: 256
                          description: SQL Server MSSTATS object name
                        INSTANCE:
                          type: string
                          maxLength: 20
                          description: SQL Server MSSTATS instance name
                        TIMEPROW:
                          type: integer
                          format: int64
                          description: SQL Server MSSTATS time per row
                        SQLTEXT:
                          type: string
                          maxLength: 50
                          description: First 50 characters of a SQL Server statement
                  PHYS_TABLES:
                    type: array
                    items:
                      type: object
                      properties:
                        DDLANGUAGE:
                          type: string
                          maxLength: 1
                          description: 'R/3: Sprachenschluessel'
                        VIEWNAME:
                          type: string
                          maxLength: 30
                          description: Name eines SAP-Tabellenviews
                        TABNAME:
                          type: string
                          maxLength: 30
                          description: Tabellenname
                        TABPOS:
                          type: integer
                          format: int64
                          description: Position in einer Wiederholgruppe
                        FORTABNAME:
                          type: string
                          maxLength: 30
                          description: Tabellenname
                        FORFIELD:
                          type: string
                          maxLength: 30
                          description: Feldname
                        FORDIR:
                          type: string
                          maxLength: 1
                          description: Richtung einer Fremdschluesselbeziehung
                  PROG_INFO:
                    type: array
                    items:
                      type: object
                      properties:
                        ANLYID:
                          type: string
                          maxLength: 14
                          description: SQL Server analysis ID for statement download
                        STMTID:
                          type: string
                          maxLength: 2
                          description: SQL Server statement ID in a statement analysis
                        PROGNAME:
                          type: string
                          maxLength: 40
                          description: SQL Server statement download
                        CREABY:
                          type: string
                          maxLength: 12
                          description: SQL Server statement download prog info creator
                        CREADATE:
                          type: string
                          format: date
                          description: SQL Server program create date
                        LCHANGBY:
                          type: string
                          maxLength: 12
                          description: SQL Server statement download
                        LCHANGDAT:
                          type: string
                          format: date
                          description: SQL Serever program change date
                  SELECTION_CONDITIONS:
                    type: array
                    items:
                      type: object
                      properties:
                        DDLANGUAGE:
                          type: string
                          maxLength: 1
                          description: Language Key
                        CONDNAME:
                          type: string
                          maxLength: 30
                          description: Selection condition ID
                        POSITION:
                          type: integer
                          format: int64
                          description: Position in a repetition group
                        TABNAME:
                          type: string
                          maxLength: 30
                          description: Table Name
                        FIELDNAME:
                          type: string
                          maxLength: 30
                          description: Field name
                        NEGATION:
                          type: string
                          maxLength: 3
                          description: 'NOT operator in selection conditions  enumValues: NOT=Negation'
                          enum:
                          - NOT
                        OPERATOR:
                          type: string
                          maxLength: 2
                          description: 'Operator in a selection condition  enumValues: NE=Not equal to,GT=Greater than,LE=less than or equal to,EQ=Equal to,LK=Like mask (allowed meta characters: ''_'' and ''%''),LT=Smaller than,GE=Greater than or equal to'
                          enum:
                          - NE
                          - GT
                          - LE
                          - EQ
                          - LK
                          - LT
                          - GE
                        CONSTANTS:
                          type: string
                          maxLength: 38
                          description: Constant in selection conditions
                        CONTLINE:
                          type: string
                          maxLength: 1
                          description: 'Flag for continuation line in selection conditions  enumValues: ""=Do not set flag,X=Set flag'
                          enum:
                          - ''
                          - X
                        AND_OR:
                          type: string
                          maxLength: 3
                          description: 'AND/OR link in a selection condition  enumValues: AND=AND operation,OR=OR operation'
                          enum:
                          - AND
                          - OR
                        OFFSET:
                          type: integer
                          format: int64
                          description: Offset within a matchcode field
                        FLENGTH:
                          type: integer
                          format: int64
                          description: Field length within a MC ID
                        MCOFIELD:
                          type: string
                          maxLength: 30
                          description: Matchcode field name
                  SERVER_INFO:
                    type: array
                    items:
                      type: object
                      properties:
                        ANLYID:
                          type: string
                          maxLength: 14
                          description: SQL Server statement download analysis ID
                        HOSTNAME:
                          type: string
                          maxLength: 20
                          description: SQL Server hostname
                        INSTNAME:
                          type: string
                          maxLength: 20
                          description: SQL Server R/3 instance name
                        RESETTIME:
                          type: string
                          maxLength: 24
                          description: SQL Server time at which client process logged in
                        COLLECTING:
                          type: string
                          maxLength: 1
                          description: SQL Server MSSTATS collection switched on/off
                        OLESTATSON:
                          type: string
                          maxLength: 1
                          description: SQL Server MSSTATS profile parameter for on/off
                        MSQSTATSON:
                          type: string
                          maxLength: 1
                          description: SQL Server MSSTATS profile parameter for on/off
                        DLLDATE:
                          type: string
                          maxLength: 24
                          description: SQL Server DB library creation date
                  STMT_EXPLAIN:
                    type: array
                    items:
                      type: object
                      properties:
                        ANLYID:
                          type: string
                          maxLength: 14
                          description: SQL Server analysis ID for statement download
                        STMTID:
                          type: string
                          maxLength: 2
                          description: SQL Server statement ID in a statement analysis
                        TDFORMAT:
                          type: string
                          maxLength: 2
                          description: Tag column
                        TDLINE:
                          type: string
                          maxLength: 132
                          description: Text Line
                  STMT_STRING:
                    type: array
                    items:
                      type: object
                      properties:
                        ANLYID:
                          type: string
                          maxLength: 14
                          description: SQL Server analysis ID for statement download
                        STMTID:
                          type: string
                          maxLength: 2
                          description: SQL Server statement ID in a statement analysis
                        TDFORMAT:
                          type: string
                          maxLength: 2
                          description: Tag column
                        TDLINE:
                          type: string
                          maxLength: 132
                          description: Text Line
                  TABLELIST:
                    type: array
                    items:
                      type: object
                      properties:
                        ANLYID:
                          type: string
                          maxLength: 14
                          description: SQL Server statement download analysis ID
                        STMT_ID:
                          type: string
                          maxLength: 2
                          description: SQL Server statement download statement ID
                        TABNAME:
                          type: string
                          maxLength: 256
                          description: SQL Server statement download table name
                  TABLE_FIELDS:
                    type: array
                    items:
                      type: object
                      properties:
                        TABNAME:
                          type: string
                          maxLength: 30
                          description: Table name
                        FIELDNAME:
                          type: string
                          maxLength: 30
                          description: Field name
                        POSITION:
                          type: integer
                          format: int64
                          description: Position of the field in the table
                        DDLANGUAGE:
                          type: string
                          maxLength: 1
                          description: Language key
                        DDTEXT:
                          type: string
                          maxLength: 60
                          description: Short text describing R/3 Repository objects
                        BASTABNAME:
                          type: string
                          maxLength: 30
                          description: Table name
                  TABLE_HEADER:
                    type: array
                    items:
                      type: object
                      properties:
                        TABNAME:
                          type: string
                          maxLength: 30
                          description: Table name
                        DDLANGUAGE:
                          type: string
                          maxLength: 1
                          description: Language key
                        DDTEXT:
                          type: string
                          maxLength: 60
                          description: Explanatory short text
                        BUFFERTYPE:
                          type: string
                          maxLength: 1
                          description: Buffering type indicator
                        TABCLASS:
                          type: string
                          maxLength: 8
                          description: Table type
                  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
                  VIEW_TABLES:
                    type: array
                    items:
                      type: object
                      properties:
                        DDLANGUAGE:
                          type: string
                          maxLength: 1
                          description: Language Key
                        VIEWNAME:
                          type: string
                          maxLength: 30
                          description: Name of SAP table view
                        TABNAME:
                          type: string
                          maxLength: 30
                          description: Table Name
                        TABPOS:
                          type: integer
                          format: int64
                          description: Position in a repetition group
                        FORTABNAME:
                          type: string
                          maxLength: 30
                          description: Table Name
                        FORFIELD:
                          type: string
                          maxLength: 30
                          description: Field Name
                        FORDIR:
                          type: string
                          maxLength: 1
                          description: 'Direction of Foreign Key Dependency  enumValues: I=Import,E=Export'
                          enum:
                          - I
                          - E
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
