SAP Table QPAM
Inspection catalog selected sets
QPAM (Inspection catalog selected sets) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link QPAM to other SAP tables.
QPAM table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||
|
WERKS
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||||||
|
KATALOGART
Catalog
|
QKATART | TQ15 |
CHAR
|
1 | 0 | |||||||||||
|
AUSWAHLMGE
Selected Set
|
QAUSWAHLMG |
CHAR
|
8 | 0 | ||||||||||||
|
KSP01
Language Key
|
SPRAS | T002 |
LANG
|
1 | 0 | |||||||||||
|
KTX01
Short Description of the Selected Set
|
QKTEXTAM |
CHAR
|
40 | 0 | ||||||||||||
|
LTEXTV
Long Text Exists for the Selected Set
|
QLTEXTMGE |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
ERSTELLER
Name of User Who Created the Data Record
|
QERSTELLER |
CHAR
|
12 | 0 | ||||||||||||
|
E_DATUM
Date on Which the Data Record Was Created
|
QDATUMERST |
DATS
|
8 | 0 | ||||||||||||
|
AENDERER
Name of User who Most Recently Changed the Data Record
|
QAENDERER |
CHAR
|
12 | 0 | ||||||||||||
|
A_DATUM
Date on Which Data Record Was Changed
|
QDATUMAEND |
DATS
|
8 | 0 | ||||||||||||
|
VERWENDUNG
Data Record Is Used
|
QVERW |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
STATUS
Status of Master Record
|
QLOESCHKZ1 |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
QPAM foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| QPAM | KATALOGART | QPAM | MANDT |
TQ15
Inspection catalog type index
|
MANDT |
| QPAM | KATALOGART | QPAM | KATALOGART |
TQ15
Inspection catalog type index
|
KATALOGART |
| QPAM | KSP01 | QPAM | KSP01 |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| QPAM | MANDT | QPAM | MANDT |
T000
Clients
|
MANDT |
| QPAM | WERKS | QPAM | MANDT |
T001W
Plants/Branches
|
MANDT |
| QPAM | WERKS | QPAM | WERKS |
T001W
Plants/Branches
|
WERKS |