openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/DB6_EXPLAIN:
    post:
      tags:
      - DB6X
      summary: 'DB6: Explain - Perform Explain'
      operationId: /rfc/DB6_EXPLAIN
      requestBody:
        content:
          application/json:
            schema:
              properties:
                ADVISE_EXPLAIN_TIME:
                  type: string
                  maxLength: 26
                  description: explain time of index advisor
                INPUT_STATEMENT:
                  type: string
                  maxLength: 32000
                  description: 'stmt_text: SQL Statement to be explained'
                NO_DISPLAY:
                  type: string
                  default: ' '
                  maxLength: 1
                  description: flag for output of access plan in ascii or tree format
                SYS_DATA:
                  type: object
                  properties:
                    SYSID:
                      type: string
                      maxLength: 8
                      description: Name of the SAP System
                    SAPREL:
                      type: string
                      maxLength: 4
                      description: Release Status of SAP System
                    DBREL:
                      type: string
                      maxLength: 10
                      description: 'DB6: Database Release Level'
                    RFCDEST:
                      type: string
                      maxLength: 32
                      description: Logical Destination (Specified in Function Call)
                    DBHOST:
                      type: string
                      maxLength: 255
                      description: 'DBA Cockpit: Server Name'
                    SCHEMANAME:
                      type: string
                      maxLength: 20
                      description: 'DB6: Schema Name'
                    ENTRYSTATE:
                      type: integer
                      format: int32
                      description: 'State of entry: 1=INITIAL,2=COMPLETE,3=DISABLED'
                    ENTRYTYPE:
                      type: integer
                      format: int32
                      description: 'kind of system: 1=R/3 ,2=Non R/3'
                    DBCNAME:
                      type: string
                      maxLength: 30
                      description: Logical name for a database connection
                    DBSYS:
                      type: string
                      maxLength: 3
                      description: 'Database system  enumValues: DB2=DB2 UDB for OS/390,MSS=Microsoft SQL Server,ADA=SAP DB (ADABAS/D),INF=Informix,ORA=Oracle,DB4=DB2 UDB for AS/400,DB6=DB2 UDB for Unix and Windows'
                      enum:
                      - DB2
                      - MSS
                      - ADA
                      - INF
                      - ORA
                      - DB4
                      - DB6
                    DB_OPSYS:
                      type: string
                      maxLength: 10
                      description: Operating System of Application Server
                    COCKREL:
                      type: string
                      maxLength: 4
                      description: Release Status of SAP System
                    REALSID:
                      type: string
                      maxLength: 8
                      description: Name of the SAP System
                    DBSID:
                      type: string
                      maxLength: 128
                      description: 'DBA Cockpit: Database Name'
                    RZ20_MON:
                      type: string
                      maxLength: 1
                      description: Remote Alert Monitoring active ('X')/inactive (' ')
                    HIST_MON:
                      type: string
                      maxLength: 1
                      description: Remote History Collection active('X')/inactive(' ')
                    DESCRIPTION:
                      type: string
                      maxLength: 80
                      description: ''
                    CHANGEDATE:
                      type: string
                      format: date
                      description: Current Date of Application Server
                    CHANGETIME:
                      type: string
                      maxLength: 6
                      description: Current Time of Application Server
                    CHANGED_BY:
                      type: string
                      maxLength: 12
                      description: User Name
                    SYSTEMTYPE:
                      type: string
                      maxLength: 7
                      description: 'SAP DB: Instance Type  enumValues: CS=Content Server Database,LVC=liveCache,BW=Business Warehouse Database,OLTP=Online Transaction Processing Database'
                      enum:
                      - CS
                      - LVC
                      - BW
                      - OLTP
                    RFCDEST_2:
                      type: string
                      maxLength: 32
                      description: Logical Destination (Specified in Function Call)
                    REMOTE_COLL:
                      type: string
                      maxLength: 1
                      description: Collect data remote('X') or local (' ')
                    DBCON_VIA_RFC:
                      type: string
                      maxLength: 1
                      description: DB Connection via RFC Destination
                    PROMPT_USER_DATA:
                      type: string
                      maxLength: 1
                      description: Store password permanent
                    SLD_NAME:
                      type: string
                      maxLength: 255
                      description: ''
                    SLD_UPDATE:
                      type: string
                      maxLength: 14
                      description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                    DB13C_MON:
                      type: string
                      maxLength: 1
                      description: DB13C Integration active('X')/inactive('')
              required:
              - INPUT_STATEMENT
      responses:
        '200':
          description: OK
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
