SAP Table
QPAM Inspection catalog selected sets
SAP table QPAM has 4 primary key fields being MANDT,WERKS,KATALOGART,AUSWAHLMGE.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
QPAM columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||
| KeyWERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |||||||||
| KeyKATALOGART | Catalog | CHAR | 1 | 0 | TQ15 | QKATART | |||||||||
| KeyAUSWAHLMGE | 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 foreign keys.
| 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 |