SAP table QPAM (Inspection catalog selected sets)

SAP table QPAM has 4 primary key fields being MANDT,WERKS,KATALOGART,AUSWAHLMGE.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
WERKS Plant CHAR 4 0 T001W WERKS_D
KATALOGART Catalog CHAR 1 0 TQ15 QKATART
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
1 Being Created
2 Released
3 Can No Longer Be Used
4 Deletion Flag
DEFAULTCODEGR Default Code Group CHAR 8 0 QPGR QDEFAULTCODEGRP
DEFAULTCODE Default Code CHAR 4 0 QPCD QDEFAULTCODE

QPAM foreign key relationships

Table Field Check Table Check Field
0 QPAM DEFAULTCODE QPCD Inspection catalog codes MANDT
0 QPAM DEFAULTCODE QPCD Inspection catalog codes KATALOGART
0 QPAM DEFAULTCODE QPCD Inspection catalog codes CODEGRUPPE
0 QPAM DEFAULTCODE QPCD Inspection catalog codes CODE
0 QPAM DEFAULTCODE QPCD Inspection catalog codes VERSION
1 QPAM DEFAULTCODEGR QPGR Inspection catalog code groups MANDT
1 QPAM DEFAULTCODEGR QPGR Inspection catalog code groups KATALOGART
0 QPAM KATALOGART TQ15 Inspection catalog type index KATALOGART
1 QPAM KSP01 T002 Language Keys (Component BC-I18) SPRAS
0 QPAM WERKS T001W Plants/Branches MANDT
0 QPAM WERKS T001W Plants/Branches WERKS