SAP Table TQSS1
QM configuration: Plant level
TQSS1 (QM configuration: Plant level) 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 TQSS1 to other SAP tables.
TQSS1 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||||||||
| MERKKL | Weighting of the Characteristic | QMERKKLAS | TQ17A | CHAR | 2 | 0 | ||||||||||||||
| FEHLERKL | Defect Class | QFEHLKLAS | TQ17 | CHAR | 2 | 0 | ||||||||||||||
| HISTMERK | Insp. Characteristics Are Maintained with History | QHISTMERK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| HISTMETH | Inspection Methods Are Maintained with History | QHISTMETH | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| HISTMENGE | Selected Sets Are Maintained with History | QHISTMENGE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| PLAUSIFAK | Factor (%) with Which the Plausibility Limit Is Calculated | QPLAUSIFAK | DEC | 5 | 2 | |||||||||||||||
| NKSTMSGTYP | Message Category if There Are Too Many Decimal Places | QNKSTMSGTYP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| NKSTELLOF | Number of Additional Decimal Places for Statistical Values | QNKSTELLOF | INT1 | 3 | 0 |
Possible values
|
||||||||||||||
| NKSTAT | Decimal Places for Statistical Values, e.g. Indexes | QNKSTAT | INT1 | 3 | 0 |
Possible values
|
||||||||||||||
| EINFACHERF | Key for Configuration of Recording Function | QERFASKONF | TQ74 | CHAR | 1 | 0 | ||||||||||||||
| RDKLASPLAU | Marginal Classes up to the Plausibility Limits | QRDKLASPLA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| LGORTRLAGE | Return Storage Location | QLGO_RUECK | T001L | CHAR | 4 | 0 | ||||||||||||||
| KOSTLZERST | Cost Center for Destroyed Quantity at Inspection | QKOSTLZER | CSKS | CHAR | 10 | 0 | ||||||||||||||
| KOSTLSCHR | Cost Center for Scrap Postings | QKOSTLSCHR | CSKS | CHAR | 10 | 0 | ||||||||||||||
| KOSTRCHKRS | Controlling Area for Inspection Lot Cost Centers | QKOKRS | TKA01 | CHAR | 4 | 0 | ||||||||||||||
| STARTPROBE | Starting Value for the Assignment of Sample Numbers | QSTARTPROB | QASV | NUMC | 6 | 0 | ||||||||||||||
| INKREPROBE | Increment for the Assignment of Sample Numbers | QINKREPROB | QASV | NUMC | 6 | 0 | ||||||||||||||
| SELEZEIT | Selection Period for Inspection Lot Processing in Days | QSELEZEIT | INT2 | 5 | 0 | |||||||||||||||
| STPREINS | Sample n=1: Recording of Summarized Statistics | QSTPREINS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| SLWBEZ | Identification for the Inspection Point Field Combination | QSLWBEZ | TQ79 | CHAR | 3 | 0 | ||||||||||||||
| PPVEMENGE | Selected Set for Inspection Point Valuation | QPPVEMENGE | QPAM | CHAR | 8 | 0 | ||||||||||||||
| PPVEWERK | Plant of Selected Set for Inspection Point Valuation | QPPVEWERK | T001W | CHAR | 4 | 0 | ||||||||||||||
| PPVECODEGR | Code Group for Inspection Point Valuation | QPPVECODGR | QPGR | CHAR | 8 | 0 | ||||||||||||||
| PPVECODE | Code for Inspection Point Valuation | QPPVECODE | QPCD | CHAR | 4 | 0 | ||||||||||||||
| PPKZTLZU | Partial Lot Assignment in an Inspection During Production | QPPKZTLZU | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| PPSTPRVER | Freely-Defined Inspection Points | QPPSTPRVER | QDSV | CHAR | 8 | 0 | ||||||||||||||
| IHSTPRVER | Sampling Procedure for Inspection in Plant Maintenance | QIHSTPRVER | QDSV | CHAR | 8 | 0 | ||||||||||||||
| PVSTPRVER | Sampling Procedure for Sample Management | QPVSTPRVER | QDSV | CHAR | 8 | 0 | ||||||||||||||
| VOSTPRVER | Sampling Method (Proposal) | QVOSTPRVER | QDSV | CHAR | 8 | 0 | ||||||||||||||
| KZGEB | Recording of the No. of Containers for Inspection Lot | QKZGEB | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| AUARTPER | Order Type for Long-Running QM Orders | QAUARTPER | T003O | CHAR | 4 | 0 | ||||||||||||||
| AUARTEINZL | Order Type for QM Orders with Single Assignment to Insp. Lot | QAUARTEINZ | T003O | CHAR | 4 | 0 | ||||||||||||||
| SKIP_TIME | Waiting Time (Minutes) Since Insp. Lot Creation for Skip Lot | QSKIP_TIME | NUMC | 4 | 0 | |||||||||||||||
| AUD_HOURS | Waiting Time in Hours Since Insp. Lot Creation (auto. UD) | QAUD_HOURS | NUMC | 4 | 0 | |||||||||||||||
| AUD_MINUT | Waiting Time in Minutes Since Insp. Lot Creation (Auto. UD) | QAUD_MINUT | NUMC | 4 | 0 | |||||||||||||||
| VALNOSPEC | Batch Valuation Possible Without Specification | QVALNOSPEC | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| ARTQMAT | Inspection Type for Available Stock in Quality Inspection | QARTQMAT | TQ30 | CHAR | 8 | 0 | ||||||||||||||
| IMMEDIATE_CHDOC | Immediate Creation of Change Docs for Inspection Results | QIMMEDIATE_CHDOC | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
TQSS1 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TQSS1 | ARTQMAT | TQSS1 | MANDT | TQ30 | Inspection types | MANDT |
| TQSS1 | ARTQMAT | TQSS1 | ARTQMAT | TQ30 | Inspection types | ART |
| TQSS1 | AUARTEINZL | TQSS1 | AUARTEINZL | T003O | Order Types | AUART |
| TQSS1 | AUARTEINZL | TQSS1 | MANDT | T003O | Order Types | CLIENT |
| TQSS1 | AUARTPER | TQSS1 | MANDT | T003O | Order Types | CLIENT |
| TQSS1 | AUARTPER | TQSS1 | AUARTPER | T003O | Order Types | AUART |
| TQSS1 | EINFACHERF | TQSS1 | MANDT | TQ74 | Recording configuration | MANDT |
| TQSS1 | EINFACHERF | TQSS1 | EINFACHERF | TQ74 | Recording configuration | ERFASKONFI |
| TQSS1 | FEHLERKL | TQSS1 | MANDT | TQ17 | Defect classes | MANDT |
| TQSS1 | FEHLERKL | TQSS1 | FEHLERKL | TQ17 | Defect classes | FEHLKLASSE |
| TQSS1 | IHSTPRVER | TQSS1 | MANDT | QDSV | Sampling procedure | MANDT |
| TQSS1 | IHSTPRVER | TQSS1 | IHSTPRVER | QDSV | Sampling procedure | STICHPRVER |
| TQSS1 | INKREPROBE | * | QASV | Sample specifications for inspection processing | VORGLFNR | |
| TQSS1 | INKREPROBE | * | QASV | Sample specifications for inspection processing | MERKNR | |
| TQSS1 | INKREPROBE | TQSS1 | INKREPROBE | QASV | Sample specifications for inspection processing | PROBENR |
| TQSS1 | INKREPROBE | TQSS1 | MANDT | QASV | Sample specifications for inspection processing | MANDANT |
| TQSS1 | INKREPROBE | * | QASV | Sample specifications for inspection processing | PRUEFLOS | |
| TQSS1 | KOSTLSCHR | TQSS1 | MANDT | CSKS | Cost Center Master Data | MANDT |
| TQSS1 | KOSTLSCHR | TQSS1 | KOSTRCHKRS | CSKS | Cost Center Master Data | KOKRS |
| TQSS1 | KOSTLSCHR | TQSS1 | KOSTLSCHR | CSKS | Cost Center Master Data | KOSTL |
| TQSS1 | KOSTLSCHR | * | CSKS | Cost Center Master Data | DATBI | |
| TQSS1 | KOSTLZERST | TQSS1 | MANDT | CSKS | Cost Center Master Data | MANDT |
| TQSS1 | KOSTLZERST | TQSS1 | KOSTRCHKRS | CSKS | Cost Center Master Data | KOKRS |
| TQSS1 | KOSTLZERST | TQSS1 | KOSTLZERST | CSKS | Cost Center Master Data | KOSTL |
| TQSS1 | KOSTLZERST | * | CSKS | Cost Center Master Data | DATBI | |
| TQSS1 | KOSTRCHKRS | TQSS1 | MANDT | TKA01 | Controlling Areas | MANDT |
| TQSS1 | KOSTRCHKRS | TQSS1 | KOSTRCHKRS | TKA01 | Controlling Areas | KOKRS |
| TQSS1 | LGORTRLAGE | TQSS1 | MANDT | T001L | Storage Locations | MANDT |
| TQSS1 | LGORTRLAGE | TQSS1 | WERKS | T001L | Storage Locations | WERKS |
| TQSS1 | LGORTRLAGE | TQSS1 | LGORTRLAGE | T001L | Storage Locations | LGORT |
| TQSS1 | MANDT | TQSS1 | MANDT | T000 | Clients | MANDT |
| TQSS1 | MERKKL | TQSS1 | MANDT | TQ17A | Characteristic weightings | MANDT |
| TQSS1 | MERKKL | TQSS1 | MERKKL | TQ17A | Characteristic weightings | MERKKLASSE |
| TQSS1 | PPSTPRVER | TQSS1 | MANDT | QDSV | Sampling procedure | MANDT |
| TQSS1 | PPSTPRVER | TQSS1 | PPSTPRVER | QDSV | Sampling procedure | STICHPRVER |
| TQSS1 | PPVECODE | '3' | QPCD | Inspection catalog codes | KATALOGART | |
| TQSS1 | PPVECODE | TQSS1 | PPVECODEGR | QPCD | Inspection catalog codes | CODEGRUPPE |
| TQSS1 | PPVECODE | TQSS1 | PPVECODE | QPCD | Inspection catalog codes | CODE |
| TQSS1 | PPVECODE | * | QPCD | Inspection catalog codes | VERSION | |
| TQSS1 | PPVECODE | TQSS1 | MANDT | QPCD | Inspection catalog codes | MANDT |
| TQSS1 | PPVECODEGR | '3' | QPGR | Inspection catalog code groups | KATALOGART | |
| TQSS1 | PPVECODEGR | TQSS1 | PPVECODEGR | QPGR | Inspection catalog code groups | CODEGRUPPE |
| TQSS1 | PPVECODEGR | TQSS1 | MANDT | QPGR | Inspection catalog code groups | MANDT |
| TQSS1 | PPVEMENGE | TQSS1 | MANDT | QPAM | Inspection catalog selected sets | MANDT |
| TQSS1 | PPVEMENGE | TQSS1 | PPVEWERK | QPAM | Inspection catalog selected sets | WERKS |
| TQSS1 | PPVEMENGE | '3' | QPAM | Inspection catalog selected sets | KATALOGART | |
| TQSS1 | PPVEMENGE | TQSS1 | PPVEMENGE | QPAM | Inspection catalog selected sets | AUSWAHLMGE |
| TQSS1 | PPVEWERK | TQSS1 | MANDT | T001W | Plants/Branches | MANDT |
| TQSS1 | PPVEWERK | TQSS1 | PPVEWERK | T001W | Plants/Branches | WERKS |
| TQSS1 | PVSTPRVER | TQSS1 | MANDT | QDSV | Sampling procedure | MANDT |
| TQSS1 | PVSTPRVER | TQSS1 | PVSTPRVER | QDSV | Sampling procedure | STICHPRVER |
| TQSS1 | SLWBEZ | TQSS1 | MANDT | TQ79 | Table with inspection point/user field combinations | MANDT |
| TQSS1 | SLWBEZ | TQSS1 | SLWBEZ | TQ79 | Table with inspection point/user field combinations | SLWBEZ |
| TQSS1 | STARTPROBE | * | QASV | Sample specifications for inspection processing | VORGLFNR | |
| TQSS1 | STARTPROBE | * | QASV | Sample specifications for inspection processing | MERKNR | |
| TQSS1 | STARTPROBE | TQSS1 | STARTPROBE | QASV | Sample specifications for inspection processing | PROBENR |
| TQSS1 | STARTPROBE | TQSS1 | MANDT | QASV | Sample specifications for inspection processing | MANDANT |
| TQSS1 | STARTPROBE | * | QASV | Sample specifications for inspection processing | PRUEFLOS | |
| TQSS1 | VOSTPRVER | TQSS1 | MANDT | QDSV | Sampling procedure | MANDT |
| TQSS1 | VOSTPRVER | TQSS1 | VOSTPRVER | QDSV | Sampling procedure | STICHPRVER |
| TQSS1 | WERKS | TQSS1 | MANDT | T001W | Plants/Branches | MANDT |
| TQSS1 | WERKS | TQSS1 | WERKS | T001W | Plants/Branches | WERKS |
