SAP table reference
QPAM
Inspection catalog selected setsExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table QPAM.
SAP table QPAM has 4 primary key fields: MANDT,WERKS,KATALOGART,AUSWAHLMGE.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
/ Fields
QPAM fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||
| Key WERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |||||||||
| Key KATALOGART | Catalog | CHAR | 1 | 0 | TQ15 | QKATART | |||||||||
| Key AUSWAHLMGE | Selected Set | CHAR | 8 | 0 | QAUSWAHLMG | ||||||||||
| KSP01 | Language Key | LANG | 1 | 0 | T002 | SPRAS | |||||||||
| KTX01 | Short Description of Selected Set | CHAR | 40 | 0 | QKTEXTAM | ||||||||||
| LTEXTV | Long Text Exists for the Selected Set | CHAR | 1 | 0 | QLTEXTMGE | ||||||||||
| ERSTELLER | Name of User Who Created the Data Record | CHAR | 12 | 0 | QERSTELLER | ||||||||||
| E_DATUM | System Date on Which Data Record Was Created | DATS | 8 | 0 | QDATUMERST | ||||||||||
| AENDERER | Name of User Who Last Changed Data Record | CHAR | 12 | 0 | QAENDERER | ||||||||||
| A_DATUM | System Date on Which Data Record Was Changed | DATS | 8 | 0 | QDATUMAEND | ||||||||||
| VERWENDUNG | Data Record Is Used | CHAR | 1 | 0 | QVERW | ||||||||||
| STATUS | Status of Master Record | CHAR | 1 | 0 | QLOESCHKZ1 | ||||||||||
| |||||||||||||||
| DEFAULTCODEGR | Default Code Group | CHAR | 8 | 0 | QPGR | QDEFAULTCODEGRP | |||||||||
| DEFAULTCODE | Default Code | CHAR | 4 | 0 | QPCD | QDEFAULTCODE | |||||||||
/ Relationships
QPAM relationships.
| Table | Field | Check table | Description | Check field |
|---|---|---|---|---|
| QPAM | DEFAULTCODE | QPCD | Inspection catalog codes | MANDT |
| QPAM | DEFAULTCODE | QPCD | Inspection catalog codes | KATALOGART |
| QPAM | DEFAULTCODE | QPCD | Inspection catalog codes | CODEGRUPPE |
| QPAM | DEFAULTCODE | QPCD | Inspection catalog codes | CODE |
| QPAM | DEFAULTCODE | QPCD | Inspection catalog codes | VERSION |
| QPAM | DEFAULTCODEGR | QPGR | Inspection catalog code groups | MANDT |
| QPAM | DEFAULTCODEGR | QPGR | Inspection catalog code groups | KATALOGART |
| QPAM | KATALOGART | TQ15 | Inspection catalog type index | KATALOGART |
| QPAM | KSP01 | T002 | Language Keys (Component BC-I18) | SPRAS |
| QPAM | WERKS | T001W | Plants/Branches | MANDT |
| QPAM | WERKS | T001W | Plants/Branches | WERKS |