The following indexes are available in the following tables for all database systems to speed up access:

Table

Index

Brief description

Fields

/SCT/QP_NODE

001

VNR/VVS

  • MANDT

  • VNR

  • VVS

/SCT/QP_NODE

002

Area of responsibility

  • MANDT

  • ZUSTBEREICH

/SCT/QP_NODE

003

LASTUPDATE

  • MANDT

  • LASTUPDATE

/SCT/QP_NODE

004

VGRP/VNAME/VGRP

  • MANDT

  • VGRP

  • VNAME

  • VNAMEG

/SCT/QP_NODE

005

VART/VNAME

  • MANDT

  • VART

  • VNAME

/SCT/QP_NODE

006

PREVOGUID

  • MANDT

  • PREVOGUID

/SCT/QP_NODE

007

INFO

  • MANDT

  • INFOSTATUS

  • INFOOGUID

/SCT/QP_NODE

008

OGUID

  • MANDT

  • OGUID

/SCT/QP_NODE

009

DOC

  • MANDT

  • DOCTYPE

  • DOCKEY

/SCT/QP_NODEREL

001

Parent VNR/VVS

  • MANDT

  • PVNR

  • PVVS

/SCT/QP_NODEREL

002

Children VNR/VVS

  • MANDT

  • CVNR

  • CVVS

/SCT/QP_NUM

001

Object type/element

  • MANDT

  • OBJEKTTYP

  • ELEMENT

/SCT/QP_STATUS

001

Main status

  • MANDT

  • ISTAT

/SCT/QP_VAL

001

Object type/element

  • MANDT

  • OBJEKTTYP

  • ELEMENT

  • VALUE

  • VALUE_MIN

  • VALUE_MAX

There is currently no need for the following tables:

  • /SCT/QP_ANA

  • /SCT/QP_BDS

  • /SCT/QP_LOG

  • /SCT/QP_NODET

  • /SCT/QP_PMK

  • /SCT/QP_STX

  • /SCT/QP_VALT