The QPPD uses 12 database tables to store data of the objects. The data is persisted client-dependently. The tables can be extended by customer-specific fields, which are not key fields.
In the following, the fields of the tables are described. This is necessary, for example, to customize the change documents and column groups.
#1: /SCT/QP_ANA
Table of the ANA object type for storing the chemical elements.
Nummer | Feld | Schlüssel |
|---|---|---|
1 | MANDT | X |
2 | GUID | X |
3 | ANATYP | X |
4 | CHEMELEM | X |
5 | BVNR | |
6 | BVVS | |
7 | SORTNR | |
8 | MODEREF | |
9 | MANU | |
10 | STATGEN | |
11 | STATELM | |
12 | SOLLINTUNTMIN | |
13 | SOLLINTUNT | |
14 | SOLLINTNENNWERT | |
15 | SOLLINTOBE | |
16 | SOLLINTOBEMAX | |
17 | SOLLEXTUNTMIN | |
18 | SOLLEXTUNT | |
19 | SOLLEXTNENNWERT | |
20 | SOLLEXTOBE | |
21 | SOLLEXTOBEMAX | |
22 | SOLLEINH | |
23 | DRKZWERT | |
24 | DRKZSOLL | |
25 | DRKZIST | |
26 | ALTZEUGTXT | |
27 | ALTZEUGEINH | |
28 | NKOM | |
29 | REFZEUG | |
30 | NSOLLINTUNTMIN | |
31 | NSOLLINTUNT | |
32 | NSOLLINTNENNWERT | |
33 | NSOLLINTOBE | |
34 | NSOLLINTOBEMAX | |
35 | NSOLLEXTUNTMIN | |
36 | NSOLLEXTUNT | |
37 | NSOLLEXTNENNWERT | |
38 | NSOLLEXTOBE | |
39 | NSOLLEXTOBEMAX | |
40 | AEGRUINT | |
41 | AEGRUEXT | |
42 | GENSOLLINTUNTMIN | |
43 | GENSOLLINTUNT | |
44 | GENSOLLINTNENNWE | |
45 | GENSOLLINTOBE | |
46 | GENSOLLINTOBEMAX | |
47 | GENSOLLEXTUNTMIN | |
48 | GENSOLLEXTUNT | |
49 | GENSOLLEXTNENNWE | |
50 | GENSOLLEXTOBE | |
51 | GENSOLLEXTOBEMAX | |
52 | GENSOLLEINH | |
53 | GENDRKZWERT | |
54 | GENDRKZSOLL | |
55 | GENDRKZIST | |
56 | GENALTZEUGTXT | |
57 | GENALTZEUGEINH | |
58 | GENNKOM | |
59 | GENREFZEUG | |
60 | GENAEGRUINT | |
61 | GENAEGRUEXT | |
62 | ORIGIN | |
63 | ERDAT | |
64 | ERTIME | |
65 | ERNAME | |
66 | AEDAT | |
67 | AETIME | |
68 | AENAME |
#2: /SCT/QP_BDS
Table of the DOCUMENTS object type, where the links to the SAP BDS are stored.
Nummer | Feld | Schlüssel |
|---|---|---|
1 | MANDT | X |
2 | GUID | X |
3 | CLASSNAME | X |
4 | CLASSTYPE | X |
5 | DOC_ID | |
6 | DOC_VER_NO | |
7 | REF_DOC_ID | |
8 | REF_DOC_VER_NO | |
9 | VNR | |
10 | VVS | |
11 | MODEREF | |
12 | DRKZZ | |
13 | DRKZA | |
14 | SPRAS | |
15 | ERDAT | |
16 | ERTIME | |
17 | ERNAME | |
18 | AEDAT | |
19 | AETIME | |
20 | AENAME |
#3: /SCT/QP_LOG
Table for messages.
Nummer | Feld | Schlüssel |
|---|---|---|
1 | MANDT | X |
2 | GUID | X |
3 | OBJEKTTYP | X |
4 | LFDNR | X |
5 | LOGKEY1 | |
6 | LOGKEY2 | |
7 | LOGKEY3 | |
8 | SOURCE | |
9 | TYPE | |
10 | FIELDS | |
11 | MSGTY | |
12 | MSGID | |
13 | MSGNO | |
14 | MSGV1 | |
15 | MSGV2 | |
16 | MSGV3 | |
17 | MSGV4 | |
18 | PROBCLASS | |
19 | OBJEKTTYPOSRTNR |
#4 /SCT/QP_NODE
Node table.
Nummer | Feld | Schlüssel |
|---|---|---|
1 | MANDT | X |
2 | GUID | X |
3 | VNR | |
4 | VVS | |
5 | MATNR | |
6 | OLD_MATNR | |
7 | SVNR | |
8 | ZSVNR | |
9 | KNOTENTYP | |
10 | VNAME | |
11 | VNAMEG | |
12 | VART | |
13 | VTYP | |
14 | VGRP | |
15 | VALIDFR | |
16 | VALIDTO | |
17 | OGUID | |
18 | PREVOGUID | |
19 | ZUSTBEREICH | |
20 | BENUTZER | |
21 | AUTH_GROUP | |
22 | ZSVVS | |
23 | VALID_DATE | |
24 | OVART | |
25 | HIERA | |
26 | CONTEXT | |
27 | RELDAT | |
28 | RELTIME | |
29 | RELNAME | |
30 | LASTUPDATE | |
31 | INFOSTATUS | |
32 | INFOUPDATE | |
33 | INFOOGUID | |
34 | DOCTYPE | |
35 | DOCKEY | |
36 | ORIGIN | |
37 | WERKS | |
38 | .INCLUDE | |
39 | ERDAT | |
40 | ERTIME | |
41 | ERNAME | |
42 | AEDAT | |
43 | AETIME | |
44 | AENAME |
#5 /SCT/QP_NODEREL
Table of relations between nodes.
Nummer | Feld | Schlüssel |
|---|---|---|
1 | MANDT | X |
2 | PGUID | X |
3 | CGUID | X |
4 | PKNOTENTYP | |
5 | PVNR | |
6 | PVVS | |
7 | CKNOTENTYP | |
8 | CVNR | |
9 | CVVS | |
10 | RELATTYP | |
11 | REFART | |
12 | REL_SET_TYP | |
13 | REL_STATUS | |
14 | REF_VERSLINK | |
15 | LASTUPDATE | |
16 | POSNR | |
17 | ERDAT | |
18 | ERTIME | |
19 | ERNAME | |
20 | AEDAT | |
21 | AETIME | |
22 | AENAME |
#6 /SCT/QP_NODET
Table of node texts.
Nummer | Feld | Schlüssel |
|---|---|---|
1 | MANDT | X |
2 | GUID | X |
3 | SPRAS | X |
4 | SCRTEXT_S | |
5 | SCRTEXT_M | |
6 | VTEXT |
#7 /SCT/QP_NUM
Table for redundant, numerical representation of values.
Nummer | Feld | Schlüssel |
|---|---|---|
1 | MANDT | X |
2 | GUID | X |
3 | OBJEKTTYP | X |
4 | ROWGRP | X |
5 | ELEMENT | X |
6 | LFDNR | X |
7 | TYPE | X |
8 | MIN_FLTP | |
9 | VAL_FLTP | |
10 | MAX_FLTP | |
11 | MIN_DEC | |
12 | VAL_DEC | |
13 | MAX_DEC | |
14 | RANGETYPE | |
15 | UNIT | |
16 | MIN_SI_FLTP | |
17 | VAL_SI_FLTP | |
18 | MAX_SI_FLTP | |
19 | MIN_SI_DEC | |
20 | VAL_SI_DEC | |
21 | MAX_SI_DEC | |
22 | UNIT_SI | |
23 | OVERFLOW_SI |
#8 /SCT/QP_PMK
Table for values of inspection characteristics.
Nummer | Feld | Schlüssel |
|---|---|---|
1 | MANDT | X |
2 | GUID | X |
3 | OBJEKTTYP | X |
4 | ROWGRP | X |
5 | MKMNR | X |
6 | BVNR | |
7 | BVVS | |
8 | SORTNR | |
9 | MODEREF | |
10 | MANU | |
11 | MANDATORY | |
12 | STATGEN | |
13 | STATELM | |
14 | WERKS | |
15 | PMTNR | |
16 | QSTPRVER | |
17 | KATALGART1 | |
18 | AUSWMENGE1 | |
19 | AUSWMGWRK1 | |
20 | AUSWVERS1 | |
21 | SOLLINTUNTMIN | |
22 | SOLLINTUNT | |
23 | SOLLINTNENNWERT | |
24 | SOLLINTOBE | |
25 | SOLLINTOBEMAX | |
26 | SOLLINTRANGET | |
27 | SOLLINTPLRANGET | |
28 | SOLLINTEINH | |
29 | SOLLEXTUNTMIN | |
30 | SOLLEXTUNT | |
31 | SOLLEXTNENNWERT | |
32 | SOLLEXTOBE | |
33 | SOLLEXTOBEMAX | |
34 | SOLLEXTRANGET | |
35 | SOLLEXTPLRANGET | |
36 | SOLLEINH | |
37 | DRKZWERT | |
38 | DRKZSOLL | |
39 | DRKZIST | |
40 | ALTZEUGTXT | |
41 | ALTSOLLZEUGUNT | |
42 | ALTSOLLNENNWERT | |
43 | ALTSOLLZEUGOBE | |
44 | ALTZEUGRANGET | |
45 | ALTZEUGEINH | |
46 | NKOM | |
47 | REFZEUG | |
48 | NSOLLINTUNTMIN | |
49 | NSOLLINTUNT | |
50 | NSOLLINTNENNWERT | |
51 | NSOLLINTOBE | |
52 | NSOLLINTOBEMAX | |
53 | NSOLLEXTUNTMIN | |
54 | NSOLLEXTUNT | |
55 | NSOLLEXTNENNWERT | |
56 | NSOLLEXTOBE | |
57 | NSOLLEXTOBEMAX | |
58 | NALTSOLLZEUGUNT | |
59 | NALTSOLLNENNWERT | |
60 | NALTSOLLZEUGOBE | |
61 | GENWERKS | |
62 | GENPMTNR | |
63 | GENQSTPRVER | |
64 | GENKATALGART1 | |
65 | GENAUSWMENGE1 | |
66 | GENAUSWMGWRK1 | |
67 | GENAUSWVERS1 | |
68 | GENSOLLINTUNTMIN | |
69 | GENSOLLINTUNT | |
70 | GENSOLLINTNENNWE | |
71 | GENSOLLINTOBE | |
72 | GENSOLLINTOBEMAX | |
73 | GENSOLLINTRANGET | |
74 | GENSOLLINTPLRANGET | |
75 | GENSOLLEXTUNTMIN | |
76 | GENSOLLEXTUNT | |
77 | GENSOLLEXTNENNWE | |
78 | GENSOLLEXTOBE | |
79 | GENSOLLEXTOBEMAX | |
80 | GENSOLLEXTRANGET | |
81 | GENSOLLEXTPLRANGET | |
82 | GENSOLLEINH | |
83 | GENDRKZWERT | |
84 | GENDRKZSOLL | |
85 | GENDRKZIST | |
86 | GENALTZEUGTXT | |
87 | GENALTSOLLZEUGUN | |
88 | GENALTSOLLNENNWE | |
89 | GENALTSOLLZEUGOB | |
90 | GENALTZEUGEINH | |
91 | GENNKOM | |
92 | GENREFZEUG | |
93 | GENRULE | |
94 | CONRULE | |
95 | ACTVALREQ | |
96 | ORIGIN | |
97 | FLAG01 | |
98 | FLAG02 | |
99 | FLAG03 | |
100 | FLAG04 | |
101 | FLAG05 | |
102 | FLAG06 | |
103 | FLAG07 | |
104 | FLAG08 | |
105 | FLAG09 | |
106 | FLAG10 | |
107 | ERDAT | |
108 | ERTIME | |
109 | ERNAME | |
110 | AEDAT | |
111 | AETIME | |
112 | AENAME |
#9 /SCT/QP_STATUS
Table for the status of the node.
Nummer | Feld | Schlüssel |
|---|---|---|
1 | MANDT | X |
2 | GUID | X |
3 | VNR | |
4 | VVS | |
5 | ISTAT | |
6 | IZQXX | |
7 | IZQER | |
8 | IZQFR | |
9 | IZQAL | |
10 | IZQLO | |
11 | IZQMA | |
12 | IZQMO | |
13 | IZQRF | |
14 | IZQSP | |
15 | IZQMV | |
16 | IZQMX | |
17 | IZQSB | |
18 | IZQOK | |
19 | IZQCN | |
20 | IZQIA | |
21 | IZQTD | |
22 | IZQWA | |
23 | IZQNO | |
24 | IZQMK | |
25 | IZQFB | |
26 | IZQ10 | |
27 | IZQ20 | |
28 | IZQ30 | |
29 | IZQ40 | |
30 | IZQ50 | |
31 | IZQ60 | |
32 | IZQ70 | |
33 | IZQ80 | |
34 | IZQ90 | |
35 | ZQA1 | |
36 | ZQA2 | |
37 | ZQA3 | |
38 | ZQAL | |
39 | ZQFF | |
40 | ZQFR | |
41 | ZQRA | |
42 | ZQKO | |
43 | ZQLO | |
44 | ZQLZ | |
45 | ZQMA | |
46 | ZQMB | |
47 | ZQMO | |
48 | ZQMZ | |
49 | ZQOK | |
50 | ZQOZ | |
51 | ZQSP | |
52 | ZQSZ | |
53 | ZQST | |
54 | ZQSB | |
55 | ZQRD | |
56 | ZQMV | |
57 | ZQIA | |
58 | ZQIR | |
59 | ZQFB | |
60 | ZQFZ | |
61 | ZQMK | |
62 | ZQKZ | |
63 | ZQNO | |
64 | ZQNZ | |
65 | ZQ10 | |
66 | ZQ11 | |
67 | ZQ12 | |
68 | ZQ20 | |
69 | ZQ21 | |
70 | ZQ22 | |
71 | ZQ30 | |
72 | ZQ31 | |
73 | ZQ32 | |
74 | ZQ40 | |
75 | ZQ41 | |
76 | ZQ42 | |
77 | ZQ50 | |
78 | ZQ51 | |
79 | ZQ52 | |
80 | ZQ60 | |
81 | ZQ61 | |
82 | ZQ62 | |
83 | ZQ70 | |
84 | ZQ71 | |
85 | ZQ72 | |
86 | ZQ80 | |
87 | ZQ81 | |
88 | ZQ82 | |
89 | ZQ90 | |
90 | ZQ91 | |
91 | ZQ92 |
#10 /SCT/QP_STX
Table for a link to long texts at nodes.
Nummer | Feld | Schlüssel |
|---|---|---|
1 | MANDT | X |
2 | GUID | X |
3 | TDOBJEKT | X |
4 | TDNAME | X |
5 | TDID | X |
6 | TDSPRAS | X |
7 | VNR | |
8 | VVS | |
9 | MODEREF | |
10 | MANU | |
11 | MANDATORY | |
12 | DRKZZ | |
13 | DRKZA | |
14 | ORIGIN | |
15 | ERDAT | |
16 | ERTIME | |
17 | ERNAME | |
18 | AEDAT | |
19 | AETIME | |
20 | AENAME |
#11 /SCT/QP_VAL
Table for technical values on object types.
Nummer | Feld | Schlüssel |
|---|---|---|
1 | MANDT | X |
2 | GUID | X |
3 | ANATYP | X |
4 | CHEMELEM | X |
5 | BVNR | |
6 | BVVS | |
7 | SORTNR | |
8 | MODEREF | |
9 | MANU | |
10 | STATGEN | |
11 | STATELM | |
12 | SOLLINTUNTMIN | |
13 | SOLLINTUNT | |
14 | SOLLINTNENNWERT | |
15 | SOLLINTOBE | |
16 | SOLLINTOBEMAX | |
17 | SOLLEXTUNTMIN | |
18 | SOLLEXTUNT | |
19 | SOLLEXTNENNWERT | |
20 | SOLLEXTOBE | |
21 | SOLLEXTOBEMAX | |
22 | SOLLEINH | |
23 | DRKZWERT | |
24 | DRKZSOLL | |
25 | DRKZIST | |
26 | ALTZEUGTXT | |
27 | ALTZEUGEINH | |
28 | NKOM | |
29 | REFZEUG | |
30 | NSOLLINTUNTMIN | |
31 | NSOLLINTUNT | |
32 | NSOLLINTNENNWERT | |
33 | NSOLLINTOBE | |
34 | NSOLLINTOBEMAX | |
35 | NSOLLEXTUNTMIN | |
36 | NSOLLEXTUNT | |
37 | NSOLLEXTNENNWERT | |
38 | NSOLLEXTOBE | |
39 | NSOLLEXTOBEMAX | |
40 | AEGRUINT | |
41 | AEGRUEXT | |
42 | GENSOLLINTUNTMIN | |
43 | GENSOLLINTUNT | |
44 | GENSOLLINTNENNWE | |
45 | GENSOLLINTOBE | |
46 | GENSOLLINTOBEMAX | |
47 | GENSOLLEXTUNTMIN | |
48 | GENSOLLEXTUNT | |
49 | GENSOLLEXTNENNWE | |
50 | GENSOLLEXTOBE | |
51 | GENSOLLEXTOBEMAX | |
52 | GENSOLLEINH | |
53 | GENDRKZWERT | |
54 | GENDRKZSOLL | |
55 | GENDRKZIST | |
56 | GENALTZEUGTXT | |
57 | GENALTZEUGEINH | |
58 | GENNKOM | |
59 | GENREFZEUG | |
60 | GENAEGRUINT | |
61 | GENAEGRUEXT | |
62 | ORIGIN | |
63 | ERDAT | |
64 | ERTIME | |
65 | ERNAME | |
66 | AEDAT | |
67 | AETIME | |
68 | AENAME |
#12 /SCT/QP_VALT
Table for language-dependent descriptions for technical values on object types.
Nummer | Feld | Schlüssel |
|---|---|---|
1 | MANDT | X |
2 | GUID | X |
3 | OBJEKTTYP | X |
4 | ROWGRP | X |
5 | ELEMENT | X |
6 | LFDNR | X |
7 | SPRAS | X |
8 | VNR | |
9 | VVS | |
10 | SCRTEXT_S | |
11 | SCRTEXT_M | |
12 | SCRTEXT_L |