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 | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||||||
| 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 |
Possible values
|
||||||||||
| STATUS | Status of Master Record | QLOESCHKZ1 | CHAR | 1 | 0 |
Possible values
|
||||||||||
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 | WERKS | T001W | Plants/Branches | WERKS |
| QPAM | WERKS | QPAM | MANDT | T001W | Plants/Branches | MANDT |
