SAP-tabelreferentie
QPAM
Inspection catalog selected setsBekijk een andere tabel
Vul een tabelcode of zoekwoord in om verder te zoeken.
Bekijk de structuur, velden en relaties van SAP-tabel QPAM.
SAP-tabel QPAM heeft 4 primaire sleutelvelden: MANDT,WERKS,KATALOGART,AUSWAHLMGE.
Bij analyse van data uit één SAP-instance is MANDT normaal overal gelijk en kun je dit veld weglaten uit relaties. Combineer je meerdere instances, neem MANDT dan wel op.
/ Velden
QPAM velden.
| Veld | Omschrijving | Datatype | Lengte | Decimalen | Checktabel | Data-element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sleutel MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||
| Sleutel WERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |||||||||
| Sleutel KATALOGART | Catalog | CHAR | 1 | 0 | TQ15 | QKATART | |||||||||
| Sleutel 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 | |||||||||
/ Relaties
QPAM relaties.
| Tabel | Veld | Checktabel | Omschrijving | Checkveld |
|---|---|---|---|---|
| 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 |