openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/DB6_PM_TREORG:
    post:
      tags:
      - SDB6TABLE
      summary: 'DB6: Get REORG Data from DB6TREORG/DB6IREORG'
      operationId: /rfc/DB6_PM_TREORG
      requestBody:
        content:
          application/json:
            schema:
              properties:
                CONNECTION:
                  type: string
                  maxLength: 30
                  description: Logical name for a database connection
                FLAGGED_ONLY:
                  type: string
                  maxLength: 1
                  description: 'DB6: select only flagged tables or tables with flagged primary key'
                NUMBER_OF_ROWS:
                  type: integer
                  format: int32
                  description: 'DB6: Max. number of rows to select'
                ORDER_BY_SIZE:
                  type: string
                  maxLength: 1
                  description: 'DB6: order by size; only used if number of rows is spezified'
                SYSTEM_ID:
                  type: string
                  maxLength: 8
                  description: Logical name for a database connection
                TABLENAME:
                  type: string
                  maxLength: 18
                  description: 'DB6: Table Name'
                TABLESIZE:
                  type: integer
                  format: int64
                  description: 'DB6: Table Size'
                TSPACE:
                  type: string
                  maxLength: 30
                  description: 'DB6: Tablespace Name'
                IT_DB6TREORG:
                  type: array
                  items:
                    type: object
                    properties:
                      DB6TOWNER:
                        type: string
                        maxLength: 20
                        description: 'DB6: Schema Name'
                      DB6TNAME:
                        type: string
                        maxLength: 18
                        description: 'DB6: Table Name'
                      DB6TSPACE:
                        type: string
                        maxLength: 18
                        description: SYSCAT;Tablespace Name
                      DB6TSIZE:
                        type: integer
                        format: int32
                        description: 'ADMIN_GET_TAB_INFO: Table Size at last runstats'
                      DB6F1:
                        type: string
                        maxLength: 3
                        description: 'REORGCHK_TB_STATS: Formula 1 for REORGCHK Table'
                      DB6F2:
                        type: string
                        maxLength: 3
                        description: 'REORGCHK_TB_STATS: Formula 2 of REORGCHK Analysis'
                      DB6F3:
                        type: string
                        maxLength: 3
                        description: 'REORGCHK_TB_STATS: Formula 3 of REORGCHK Analysis'
                      DB6REORG:
                        type: string
                        maxLength: 3
                        description: REORGCHK_TB_STATS:REORGCHK - Recommendation
                      DB6DATETIM:
                        type: string
                        maxLength: 26
                        description: 'DB6: Built-In UDB Type Timestamp'
                      DB6RUNTIME:
                        type: string
                        maxLength: 6
                        description: 'SAP Reorg Jobs: Runtime of Last REORG'
                      DB6REODATE:
                        type: string
                        format: date
                        description: SAP Reorg Jobs:Date of Last REORG
                      DB6REOSIZE:
                        type: integer
                        format: int32
                        description: SAP Reorg Jobs:Table size at last reorg
                      TSPTYPE:
                        type: string
                        maxLength: 1
                        description: SYSCAT:Tablespace Type
                      PCTPAGESAVED:
                        type: integer
                        format: int32
                        description: 'SYSCAT: Percentage of pages saved by compression'
                      COMPRESSION:
                        type: string
                        maxLength: 1
                        description: 'SYSCAT: Type of compression'
                      DATA_OBJ_L_SIZE:
                        type: integer
                        format: int64
                        description: Number of logically allocated data pages
                      DATA_OBJ_P_SIZE:
                        type: integer
                        format: int64
                        description: Number of physically allocated data pages
                      INDEX_OBJ_L_SIZE:
                        type: integer
                        format: int64
                        description: Number of logically allocated  index pages
                      INDEX_OBJ_P_SIZE:
                        type: integer
                        format: int64
                        description: Number of physically allocated  index pages
                      LONG_OBJ_L_SIZE:
                        type: integer
                        format: int64
                        description: Number of logically allocated  long pages
                      LONG_OBJ_P_SIZE:
                        type: integer
                        format: int64
                        description: Number of physically allocated  long pages
                      LOB_OBJ_L_SIZE:
                        type: integer
                        format: int64
                        description: Number of logically allocated  LOB pages
                      LOB_OBJ_P_SIZE:
                        type: integer
                        format: int64
                        description: Number of physically allocated  LOG pages
                      XML_OBJ_L_SIZE:
                        type: integer
                        format: int64
                        description: Number of logically allocated  XML pages
                      XML_OBJ_P_SIZE:
                        type: integer
                        format: int64
                        description: Number of physically allocated  XML pages
                      LOAD_STATUS:
                        type: string
                        maxLength: 32
                        description: LOAD Status (IN_PROGRESS/PENDING)
                      LARGE_RIDS:
                        type: string
                        maxLength: 10
                        description: Large RIDs (YES/NO)
                      REORG_PENDING:
                        type: string
                        maxLength: 10
                        description: REORG pending (YES/NO)
                      INDEX_TYPE:
                        type: string
                        maxLength: 10
                        description: Index Type (Type-1/Type-2)
                      AVAILABLE:
                        type: string
                        maxLength: 10
                        description: Availability (YES/NO)
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  IT_DB6TREORG:
                    type: array
                    items:
                      type: object
                      properties:
                        DB6TOWNER:
                          type: string
                          maxLength: 20
                          description: 'DB6: Schema Name'
                        DB6TNAME:
                          type: string
                          maxLength: 18
                          description: 'DB6: Table Name'
                        DB6TSPACE:
                          type: string
                          maxLength: 18
                          description: SYSCAT;Tablespace Name
                        DB6TSIZE:
                          type: integer
                          format: int32
                          description: 'ADMIN_GET_TAB_INFO: Table Size at last runstats'
                        DB6F1:
                          type: string
                          maxLength: 3
                          description: 'REORGCHK_TB_STATS: Formula 1 for REORGCHK Table'
                        DB6F2:
                          type: string
                          maxLength: 3
                          description: 'REORGCHK_TB_STATS: Formula 2 of REORGCHK Analysis'
                        DB6F3:
                          type: string
                          maxLength: 3
                          description: 'REORGCHK_TB_STATS: Formula 3 of REORGCHK Analysis'
                        DB6REORG:
                          type: string
                          maxLength: 3
                          description: REORGCHK_TB_STATS:REORGCHK - Recommendation
                        DB6DATETIM:
                          type: string
                          maxLength: 26
                          description: 'DB6: Built-In UDB Type Timestamp'
                        DB6RUNTIME:
                          type: string
                          maxLength: 6
                          description: 'SAP Reorg Jobs: Runtime of Last REORG'
                        DB6REODATE:
                          type: string
                          format: date
                          description: SAP Reorg Jobs:Date of Last REORG
                        DB6REOSIZE:
                          type: integer
                          format: int32
                          description: SAP Reorg Jobs:Table size at last reorg
                        TSPTYPE:
                          type: string
                          maxLength: 1
                          description: SYSCAT:Tablespace Type
                        PCTPAGESAVED:
                          type: integer
                          format: int32
                          description: 'SYSCAT: Percentage of pages saved by compression'
                        COMPRESSION:
                          type: string
                          maxLength: 1
                          description: 'SYSCAT: Type of compression'
                        DATA_OBJ_L_SIZE:
                          type: integer
                          format: int64
                          description: Number of logically allocated data pages
                        DATA_OBJ_P_SIZE:
                          type: integer
                          format: int64
                          description: Number of physically allocated data pages
                        INDEX_OBJ_L_SIZE:
                          type: integer
                          format: int64
                          description: Number of logically allocated  index pages
                        INDEX_OBJ_P_SIZE:
                          type: integer
                          format: int64
                          description: Number of physically allocated  index pages
                        LONG_OBJ_L_SIZE:
                          type: integer
                          format: int64
                          description: Number of logically allocated  long pages
                        LONG_OBJ_P_SIZE:
                          type: integer
                          format: int64
                          description: Number of physically allocated  long pages
                        LOB_OBJ_L_SIZE:
                          type: integer
                          format: int64
                          description: Number of logically allocated  LOB pages
                        LOB_OBJ_P_SIZE:
                          type: integer
                          format: int64
                          description: Number of physically allocated  LOG pages
                        XML_OBJ_L_SIZE:
                          type: integer
                          format: int64
                          description: Number of logically allocated  XML pages
                        XML_OBJ_P_SIZE:
                          type: integer
                          format: int64
                          description: Number of physically allocated  XML pages
                        LOAD_STATUS:
                          type: string
                          maxLength: 32
                          description: LOAD Status (IN_PROGRESS/PENDING)
                        LARGE_RIDS:
                          type: string
                          maxLength: 10
                          description: Large RIDs (YES/NO)
                        REORG_PENDING:
                          type: string
                          maxLength: 10
                          description: REORG pending (YES/NO)
                        INDEX_TYPE:
                          type: string
                          maxLength: 10
                          description: Index Type (Type-1/Type-2)
                        AVAILABLE:
                          type: string
                          maxLength: 10
                          description: Availability (YES/NO)
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
