openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/DB6_PM_TABLEDETAILS1:
    post:
      tags:
      - SDB6TABLE
      summary: 'DB6: Details of one Table Including Index and Structure'
      operationId: /rfc/DB6_PM_TABLEDETAILS1
      requestBody:
        content:
          application/json:
            schema:
              properties:
                CONNECTION:
                  type: string
                  maxLength: 30
                  description: Logical name for a database connection
                SYSTEM_ID:
                  type: string
                  maxLength: 8
                  description: Logical name for a database connection
                TABLENAME:
                  type: string
                  maxLength: 128
                  description: 'DB6: Table Name'
                TABSCHEMA:
                  type: string
                  maxLength: 20
                  description: 'DB6: Table Schema'
                IT_DB6PMCIDX:
                  type: array
                  items:
                    type: object
                    properties:
                      IDXSCHEMA:
                        type: string
                        maxLength: 20
                        description: 'DB6: Schema Name'
                      INDEXNAME:
                        type: string
                        maxLength: 128
                        description: DB6 Index Name
                      RCKTSPACE:
                        type: string
                        maxLength: 30
                        description: 'DB6: Tablespace Name'
                      SYSNLEAF:
                        type: integer
                        format: int64
                        description: 'DB6: Number of leaf'
                      SYSNLEVELS:
                        type: integer
                        format: int64
                        description: 'DB6: Number of levels'
                      SYS1STKCD:
                        type: integer
                        format: int64
                        description: DB6:Fistkeycard
                      SYS1ST2KCD:
                        type: integer
                        format: int64
                        description: 'DB6: First2keycard'
                      SYS1ST3KCD:
                        type: integer
                        format: int64
                        description: 'DB6: First3keycard'
                      SYS1ST4KCD:
                        type: integer
                        format: int64
                        description: 'DB6: First4keycard'
                      SYSFULLKCD:
                        type: integer
                        format: int64
                        description: 'DB6: Fullkeycard'
                      SYSCSTRATI:
                        type: integer
                        format: int64
                        description: 'DB6: Clusterratio'
                      SYSCSTFACT:
                        type: string
                        maxLength: 22
                        description: 'DB6: Clusterfactor'
                      SYSSEQ_PGS:
                        type: integer
                        format: int64
                        description: 'DB6: Sequential Pages'
                      SYSDENSITY:
                        type: integer
                        format: int64
                        description: 'DB6: Density'
                      SYSSTATDAT:
                        type: string
                        format: date
                        description: 'DB6: Date of last runstats'
                      SYSSTATTIM:
                        type: string
                        maxLength: 6
                        description: 'DB6: Time of last runstats'
                      RCKCARD:
                        type: string
                        maxLength: 10
                        description: 'DB6: Cardinality'
                      RCKTOTALKB:
                        type: integer
                        format: int64
                        description: 'DB6: Index size in kb'
                      RCKDB6F4:
                        type: string
                        maxLength: 3
                        description: 'DB6: Clusterratio'
                      RCKDB6F5:
                        type: string
                        maxLength: 3
                        description: 'DB6: index size / alloc. space'
                      RCKDB6F6:
                        type: string
                        maxLength: 3
                        description: DB6:num. entries / no. possible entries
                      RCKDB6F4R:
                        type: string
                        maxLength: 1
                        description: 'DB6: Recomm Flag Clusterratio'
                      RCKDB6F5R:
                        type: string
                        maxLength: 1
                        description: DB6:Recomm Flag index size / alloc. space
                      RCKDB6F6R:
                        type: string
                        maxLength: 1
                        description: DB6:Recomm Flag num. entries / no. possible entries
                      RCKDAT:
                        type: string
                        format: date
                        description: 'DB6: Date of last reorgcheck (dmdb6srp)'
                      RCKTIM:
                        type: string
                        maxLength: 6
                        description: 'DB6: Time of last reorgcheck (dmdb6srp)'
                      PCTFREE:
                        type: integer
                        format: int32
                        description: ''
                      RCKDB6F7:
                        type: string
                        maxLength: 3
                        description: ''
                      RCKDB6F8:
                        type: string
                        maxLength: 3
                        description: ''
                      RCKDB6F7R:
                        type: string
                        maxLength: 1
                        description: ''
                      RCKDB6F8R:
                        type: string
                        maxLength: 1
                        description: ''
                      INDEXTYPE:
                        type: string
                        maxLength: 4
                        description: indextype
                      DIMENSIONSEQ:
                        type: string
                        maxLength: 200
                        description: Columns in Dimension (MDC)
                      INDEXTYPE_TEXT:
                        type: string
                        maxLength: 15
                        description: Indextype genaue Bezeichnung
                IT_DB6PMCIST:
                  type: array
                  items:
                    type: object
                    properties:
                      INDSCHEMA:
                        type: string
                        maxLength: 20
                        description: 'DB6: Schema Name'
                      INDNAME:
                        type: string
                        maxLength: 128
                        description: 'DB6: Indexname'
                      COLSEQ:
                        type: integer
                        format: int64
                        description: 'DB6: Key column sequence'
                      COLORDER:
                        type: string
                        maxLength: 1
                        description: 'DB6: Order (A=ascending,''D=descending)'
                      DBCOLNO:
                        type: integer
                        format: int64
                        description: DB6:Database Column Number
                      DBCOLNAME:
                        type: string
                        maxLength: 30
                        description: DB6:Database Column Name
                      DBCOLTYPE:
                        type: string
                        maxLength: 18
                        description: DB6:Database Column Type
                      DBCOLLEN:
                        type: string
                        maxLength: 16
                        description: DB6:Database Column Length
                      R3COLNAME:
                        type: string
                        maxLength: 30
                        description: DB6:R/3 Column Name
                      R3KEYCOL:
                        type: string
                        maxLength: 1
                        description: DB6:R/3 Keys Columns
                      R3COLTYPE:
                        type: string
                        maxLength: 18
                        description: DB6:R/3 Column Type
                      R3COLLEN:
                        type: string
                        maxLength: 16
                        description: DB6:R/3 Column Len
                      PARTKEYSEQ:
                        type: integer
                        format: int32
                        description: column's position of partitioning key (0 not part of key)
                      INDEXTYPE:
                        type: string
                        maxLength: 4
                        description: Index type
                      DIMENSION:
                        type: integer
                        format: int32
                        description: Dimensionnumber in syscat.coluse (MDC)
                      COLSEQ_DIM:
                        type: integer
                        format: int32
                        description: Numeric position in dimension (syscat.coluse)
                IT_DB6PMCTAB:
                  type: array
                  items:
                    type: object
                    properties:
                      TABSCHEMA:
                        type: string
                        maxLength: 20
                        description: 'DB6: Schema Name'
                      TABLENAME:
                        type: string
                        maxLength: 18
                        description: 'DB6: Table Name'
                      RCKTSPACE:
                        type: string
                        maxLength: 30
                        description: 'DB6: Tablespace Name'
                      SYSCARD:
                        type: integer
                        format: int64
                        description: 'DB6: Cardinality'
                      SYSOVERFLW:
                        type: integer
                        format: int64
                        description: 'DB6: Overflow Records'
                      SYSNPAGES:
                        type: integer
                        format: int64
                        description: 'DB6: Number of Pages with data'
                      SYSFPAGES:
                        type: integer
                        format: int64
                        description: 'DB6: Total number of pages'
                      SYSSTATDAT:
                        type: string
                        format: date
                        description: 'DB6: Date of runstats'
                      SYSSTATTIM:
                        type: string
                        maxLength: 6
                        description: 'DB6: Time of runstats'
                      RCKTOTALKB:
                        type: integer
                        format: int64
                        description: 'DB6: Table size in kb'
                      RCKDB6F1:
                        type: string
                        maxLength: 3
                        description: 'DB6: Overflow Rows'
                      RCKDB6F2:
                        type: string
                        maxLength: 3
                        description: 'DB6: tablesize / alloc. space'
                      RCKDB6F3:
                        type: string
                        maxLength: 3
                        description: 'DB6: full pages / alloc. pages'
                      RCKDB6F1R:
                        type: string
                        maxLength: 1
                        description: 'DB6: Recomm Flag Overflow Rows'
                      RCKDB6F2R:
                        type: string
                        maxLength: 1
                        description: 'DB6: Recomm Flag tablesize / alloc. space'
                      RCKDB6F3R:
                        type: string
                        maxLength: 1
                        description: 'DB6: Recomm Flag full pages / alloc. pages'
                      RCKDAT:
                        type: string
                        format: date
                        description: 'DB6: Date of last reorgcheck (dmdb6srp)'
                      RCKTIM:
                        type: string
                        maxLength: 6
                        description: 'DB6: Time of last reorgcheck (dmdb6srp)'
                      RCKREODAT:
                        type: string
                        format: date
                        description: 'DB6: Date of last reorg table'
                      RCKREORTIM:
                        type: string
                        maxLength: 6
                        description: 'DB6: Runtime of last reorg table'
                      SYSVOLATIL:
                        type: string
                        maxLength: 1
                        description: 'DB6: Volatile Flag'
                      PCTFREE:
                        type: integer
                        format: int32
                        description: ''
                      STATS_PROF:
                        type: string
                        maxLength: 32000
                        description: ''
                      COMPRESSION:
                        type: string
                        maxLength: 1
                        description: V = Value compression activated, N = No compression
                      CLUSTERED:
                        type: string
                        maxLength: 1
                        description: Y = MDC Table ; Space non-MDC
                      DISTRIBSTAT:
                        type: string
                        maxLength: 1
                        description: Y = entries in coldist for table -> distrib. statististics
                      PARTITION_MODE:
                        type: string
                        maxLength: 1
                        description: H Hash Partitioning Space no partitioning
                      AVGROWCOMPSIZE:
                        type: integer
                        format: int32
                        description: Average length (bytes) of compr. rows; -1 no stats collected
                      AVGROWCOMPRATIO:
                        type: number
                        description: average compression ratio by row; -1 no stats collected
                      AVGROWSIZE:
                        type: integer
                        format: int32
                        description: average length (bytes) of compr. and umcompr. rows
                      PCTROWSCOMPR:
                        type: number
                        description: compr. rows as percentage of total number of rows in table
                      PCTPAGESSAVED:
                        type: integer
                        format: int32
                        description: approx. percentage of pages saved as result by row compr.
                      TABTYPE:
                        type: string
                        maxLength: 1
                        description: Table Type ('T' = Table, 'V' = Statistical View)
                IT_DB6PMCTST:
                  type: array
                  items:
                    type: object
                    properties:
                      DBCOLNO:
                        type: integer
                        format: int64
                        description: DB6:Database Column Number
                      DBCOLNAME:
                        type: string
                        maxLength: 30
                        description: DB6:Database Column Name
                      DBCOLTYPE:
                        type: string
                        maxLength: 18
                        description: DB6:Database Column Type
                      DBCOLLEN:
                        type: string
                        maxLength: 16
                        description: DB6:Database Column Length
                      R3COLNAME:
                        type: string
                        maxLength: 30
                        description: DB6:R/3 Column Name
                      R3KEYCOL:
                        type: string
                        maxLength: 1
                        description: DB6:R/3 Keys Columns
                      R3COLTYPE:
                        type: string
                        maxLength: 18
                        description: DB6:R/3 Column Type
                      R3COLLEN:
                        type: string
                        maxLength: 16
                        description: DB6:R/3 Column Len
                      PARTKEYSEQ:
                        type: integer
                        format: int32
                        description: column's position of partitioning key (0 not part of key)
              required:
              - TABLENAME
              - TABSCHEMA
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  RUNSTATS_SETTINGS:
                    type: object
                    properties:
                      TABSCHEMA:
                        type: string
                        maxLength: 20
                        description: 'DB6: Schema Name'
                      TABNAME:
                        type: string
                        maxLength: 128
                        description: 'DB6: long table name'
                      VWTYP:
                        type: string
                        maxLength: 1
                        description: ''
                      ACTIV:
                        type: string
                        maxLength: 1
                        description: ''
                      SAMPLSZTAB:
                        type: integer
                        format: int64
                        description: ''
                      SAMPLE_IDX:
                        type: string
                        maxLength: 1
                        description: ''
                      SAMPLE_TAB:
                        type: string
                        maxLength: 1
                        description: ''
                      KEYCOLONLY:
                        type: string
                        maxLength: 1
                        description: ''
                      AMETH:
                        type: string
                        maxLength: 1
                        description: ''
                      VOLA_STAT:
                        type: string
                        maxLength: 1
                        description: ''
                      VOLATHRESH:
                        type: integer
                        format: int64
                        description: ''
                      UPDRATIO:
                        type: integer
                        format: int64
                        description: ''
                      AEDAT:
                        type: string
                        format: date
                        description: ''
                      POOL_LIKE:
                        type: string
                        maxLength: 1
                        description: ''
                      SAMPLTYPE:
                        type: string
                        maxLength: 1
                        description: ''
                  IT_DB6PMCIDX:
                    type: array
                    items:
                      type: object
                      properties:
                        IDXSCHEMA:
                          type: string
                          maxLength: 20
                          description: 'DB6: Schema Name'
                        INDEXNAME:
                          type: string
                          maxLength: 128
                          description: DB6 Index Name
                        RCKTSPACE:
                          type: string
                          maxLength: 30
                          description: 'DB6: Tablespace Name'
                        SYSNLEAF:
                          type: integer
                          format: int64
                          description: 'DB6: Number of leaf'
                        SYSNLEVELS:
                          type: integer
                          format: int64
                          description: 'DB6: Number of levels'
                        SYS1STKCD:
                          type: integer
                          format: int64
                          description: DB6:Fistkeycard
                        SYS1ST2KCD:
                          type: integer
                          format: int64
                          description: 'DB6: First2keycard'
                        SYS1ST3KCD:
                          type: integer
                          format: int64
                          description: 'DB6: First3keycard'
                        SYS1ST4KCD:
                          type: integer
                          format: int64
                          description: 'DB6: First4keycard'
                        SYSFULLKCD:
                          type: integer
                          format: int64
                          description: 'DB6: Fullkeycard'
                        SYSCSTRATI:
                          type: integer
                          format: int64
                          description: 'DB6: Clusterratio'
                        SYSCSTFACT:
                          type: string
                          maxLength: 22
                          description: 'DB6: Clusterfactor'
                        SYSSEQ_PGS:
                          type: integer
                          format: int64
                          description: 'DB6: Sequential Pages'
                        SYSDENSITY:
                          type: integer
                          format: int64
                          description: 'DB6: Density'
                        SYSSTATDAT:
                          type: string
                          format: date
                          description: 'DB6: Date of last runstats'
                        SYSSTATTIM:
                          type: string
                          maxLength: 6
                          description: 'DB6: Time of last runstats'
                        RCKCARD:
                          type: string
                          maxLength: 10
                          description: 'DB6: Cardinality'
                        RCKTOTALKB:
                          type: integer
                          format: int64
                          description: 'DB6: Index size in kb'
                        RCKDB6F4:
                          type: string
                          maxLength: 3
                          description: 'DB6: Clusterratio'
                        RCKDB6F5:
                          type: string
                          maxLength: 3
                          description: 'DB6: index size / alloc. space'
                        RCKDB6F6:
                          type: string
                          maxLength: 3
                          description: DB6:num. entries / no. possible entries
                        RCKDB6F4R:
                          type: string
                          maxLength: 1
                          description: 'DB6: Recomm Flag Clusterratio'
                        RCKDB6F5R:
                          type: string
                          maxLength: 1
                          description: DB6:Recomm Flag index size / alloc. space
                        RCKDB6F6R:
                          type: string
                          maxLength: 1
                          description: DB6:Recomm Flag num. entries / no. possible entries
                        RCKDAT:
                          type: string
                          format: date
                          description: 'DB6: Date of last reorgcheck (dmdb6srp)'
                        RCKTIM:
                          type: string
                          maxLength: 6
                          description: 'DB6: Time of last reorgcheck (dmdb6srp)'
                        PCTFREE:
                          type: integer
                          format: int32
                          description: ''
                        RCKDB6F7:
                          type: string
                          maxLength: 3
                          description: ''
                        RCKDB6F8:
                          type: string
                          maxLength: 3
                          description: ''
                        RCKDB6F7R:
                          type: string
                          maxLength: 1
                          description: ''
                        RCKDB6F8R:
                          type: string
                          maxLength: 1
                          description: ''
                        INDEXTYPE:
                          type: string
                          maxLength: 4
                          description: indextype
                        DIMENSIONSEQ:
                          type: string
                          maxLength: 200
                          description: Columns in Dimension (MDC)
                        INDEXTYPE_TEXT:
                          type: string
                          maxLength: 15
                          description: Indextype genaue Bezeichnung
                  IT_DB6PMCIST:
                    type: array
                    items:
                      type: object
                      properties:
                        INDSCHEMA:
                          type: string
                          maxLength: 20
                          description: 'DB6: Schema Name'
                        INDNAME:
                          type: string
                          maxLength: 128
                          description: 'DB6: Indexname'
                        COLSEQ:
                          type: integer
                          format: int64
                          description: 'DB6: Key column sequence'
                        COLORDER:
                          type: string
                          maxLength: 1
                          description: 'DB6: Order (A=ascending,''D=descending)'
                        DBCOLNO:
                          type: integer
                          format: int64
                          description: DB6:Database Column Number
                        DBCOLNAME:
                          type: string
                          maxLength: 30
                          description: DB6:Database Column Name
                        DBCOLTYPE:
                          type: string
                          maxLength: 18
                          description: DB6:Database Column Type
                        DBCOLLEN:
                          type: string
                          maxLength: 16
                          description: DB6:Database Column Length
                        R3COLNAME:
                          type: string
                          maxLength: 30
                          description: DB6:R/3 Column Name
                        R3KEYCOL:
                          type: string
                          maxLength: 1
                          description: DB6:R/3 Keys Columns
                        R3COLTYPE:
                          type: string
                          maxLength: 18
                          description: DB6:R/3 Column Type
                        R3COLLEN:
                          type: string
                          maxLength: 16
                          description: DB6:R/3 Column Len
                        PARTKEYSEQ:
                          type: integer
                          format: int32
                          description: column's position of partitioning key (0 not part of key)
                        INDEXTYPE:
                          type: string
                          maxLength: 4
                          description: Index type
                        DIMENSION:
                          type: integer
                          format: int32
                          description: Dimensionnumber in syscat.coluse (MDC)
                        COLSEQ_DIM:
                          type: integer
                          format: int32
                          description: Numeric position in dimension (syscat.coluse)
                  IT_DB6PMCTAB:
                    type: array
                    items:
                      type: object
                      properties:
                        TABSCHEMA:
                          type: string
                          maxLength: 20
                          description: 'DB6: Schema Name'
                        TABLENAME:
                          type: string
                          maxLength: 18
                          description: 'DB6: Table Name'
                        RCKTSPACE:
                          type: string
                          maxLength: 30
                          description: 'DB6: Tablespace Name'
                        SYSCARD:
                          type: integer
                          format: int64
                          description: 'DB6: Cardinality'
                        SYSOVERFLW:
                          type: integer
                          format: int64
                          description: 'DB6: Overflow Records'
                        SYSNPAGES:
                          type: integer
                          format: int64
                          description: 'DB6: Number of Pages with data'
                        SYSFPAGES:
                          type: integer
                          format: int64
                          description: 'DB6: Total number of pages'
                        SYSSTATDAT:
                          type: string
                          format: date
                          description: 'DB6: Date of runstats'
                        SYSSTATTIM:
                          type: string
                          maxLength: 6
                          description: 'DB6: Time of runstats'
                        RCKTOTALKB:
                          type: integer
                          format: int64
                          description: 'DB6: Table size in kb'
                        RCKDB6F1:
                          type: string
                          maxLength: 3
                          description: 'DB6: Overflow Rows'
                        RCKDB6F2:
                          type: string
                          maxLength: 3
                          description: 'DB6: tablesize / alloc. space'
                        RCKDB6F3:
                          type: string
                          maxLength: 3
                          description: 'DB6: full pages / alloc. pages'
                        RCKDB6F1R:
                          type: string
                          maxLength: 1
                          description: 'DB6: Recomm Flag Overflow Rows'
                        RCKDB6F2R:
                          type: string
                          maxLength: 1
                          description: 'DB6: Recomm Flag tablesize / alloc. space'
                        RCKDB6F3R:
                          type: string
                          maxLength: 1
                          description: 'DB6: Recomm Flag full pages / alloc. pages'
                        RCKDAT:
                          type: string
                          format: date
                          description: 'DB6: Date of last reorgcheck (dmdb6srp)'
                        RCKTIM:
                          type: string
                          maxLength: 6
                          description: 'DB6: Time of last reorgcheck (dmdb6srp)'
                        RCKREODAT:
                          type: string
                          format: date
                          description: 'DB6: Date of last reorg table'
                        RCKREORTIM:
                          type: string
                          maxLength: 6
                          description: 'DB6: Runtime of last reorg table'
                        SYSVOLATIL:
                          type: string
                          maxLength: 1
                          description: 'DB6: Volatile Flag'
                        PCTFREE:
                          type: integer
                          format: int32
                          description: ''
                        STATS_PROF:
                          type: string
                          maxLength: 32000
                          description: ''
                        COMPRESSION:
                          type: string
                          maxLength: 1
                          description: V = Value compression activated, N = No compression
                        CLUSTERED:
                          type: string
                          maxLength: 1
                          description: Y = MDC Table ; Space non-MDC
                        DISTRIBSTAT:
                          type: string
                          maxLength: 1
                          description: Y = entries in coldist for table -> distrib. statististics
                        PARTITION_MODE:
                          type: string
                          maxLength: 1
                          description: H Hash Partitioning Space no partitioning
                        AVGROWCOMPSIZE:
                          type: integer
                          format: int32
                          description: Average length (bytes) of compr. rows; -1 no stats collected
                        AVGROWCOMPRATIO:
                          type: number
                          description: average compression ratio by row; -1 no stats collected
                        AVGROWSIZE:
                          type: integer
                          format: int32
                          description: average length (bytes) of compr. and umcompr. rows
                        PCTROWSCOMPR:
                          type: number
                          description: compr. rows as percentage of total number of rows in table
                        PCTPAGESSAVED:
                          type: integer
                          format: int32
                          description: approx. percentage of pages saved as result by row compr.
                        TABTYPE:
                          type: string
                          maxLength: 1
                          description: Table Type ('T' = Table, 'V' = Statistical View)
                  IT_DB6PMCTST:
                    type: array
                    items:
                      type: object
                      properties:
                        DBCOLNO:
                          type: integer
                          format: int64
                          description: DB6:Database Column Number
                        DBCOLNAME:
                          type: string
                          maxLength: 30
                          description: DB6:Database Column Name
                        DBCOLTYPE:
                          type: string
                          maxLength: 18
                          description: DB6:Database Column Type
                        DBCOLLEN:
                          type: string
                          maxLength: 16
                          description: DB6:Database Column Length
                        R3COLNAME:
                          type: string
                          maxLength: 30
                          description: DB6:R/3 Column Name
                        R3KEYCOL:
                          type: string
                          maxLength: 1
                          description: DB6:R/3 Keys Columns
                        R3COLTYPE:
                          type: string
                          maxLength: 18
                          description: DB6:R/3 Column Type
                        R3COLLEN:
                          type: string
                          maxLength: 16
                          description: DB6:R/3 Column Len
                        PARTKEYSEQ:
                          type: integer
                          format: int32
                          description: column's position of partitioning key (0 not part of key)
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
