SAP ABAP Table QDQL (Quality level)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ QM-QC-AQC (Application Component) Active Quality Control
⤷ QDSE (Package) QM sample determination
⤷ QM-QC-AQC (Application Component) Active Quality Control
⤷ QDSE (Package) QM sample determination
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | QDQL | Table Relationship Diagram |
Short Description | Quality level |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
3 | MATNR | QMATNRQL | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
4 | PLNTY | QPLNTYQL | PLNTY | CHAR | 1 | 0 | Task List Type | TCA01 | |
5 | PLNNR | QPLNNRQL | PLNNR | CHAR | 8 | 0 | Key for Task List Group | PLKO | |
6 | PLNAL | QPLNALQL | ALTNR | CHAR | 2 | 0 | Group Counter | ||
7 | PLNFL | QPLNFLQL | PLNFOLGE | CHAR | 6 | 0 | Sequence of Operations Within a Plan | ||
8 | PLNKN | QPLNKNQL | KNTNR | NUMC | 8 | 0 | Number of Task List Node | ||
9 | ZAEHLERQL | QZAEHLERQL | QDYNANZ4 | INT4 | 10 | 0 | Sequential Counter for Different Quality Levels | ||
10 | LIFNR | QELIFNQL | LIFNR | CHAR | 10 | 0 | Vendor Account Number | LFA1 | |
11 | HERSTELLER | QHERSTQL | LIFNR | CHAR | 10 | 0 | Manufacturer Account Number | LFA1 | |
12 | KUNNR | QEKUNNQL | KUNNR | CHAR | 10 | 0 | Customer Account Number | KNA1 | |
13 | PRUEFART | QPART | QPART | CHAR | 8 | 0 | Inspection Type | TQ30 | |
14 | VORNR | QVORNRD | VORNR | CHAR | 4 | 0 | Operation Number in the Quality Level | ||
15 | MERKNR | QMERKNRD | QMERKNRP | NUMC | 4 | 0 | Characteristic Number in the Quality Level | ||
16 | VPLTY | VPLNTY | PLNTY | CHAR | 1 | 0 | Type of the referenced task list | TCA01 | |
17 | VPLNR | VPLNNR | PLNNR | CHAR | 8 | 0 | Group of the referenced task list | ||
18 | VPLAL | VPLNAL | ALTNR | CHAR | 2 | 0 | Group counter of the referenced task list | ||
19 | VPLFL | VPLBFL | PLNFOLGE | CHAR | 6 | 0 | Referenced sequence in routing | ||
20 | VPLNKN | PLNKN | KNTNR | NUMC | 8 | 0 | Number of the task list node | ||
21 | AENDLOSA | QAENDLOSA | QAENDERER | CHAR | 12 | 0 | User who Last Changed the Quality Level | ||
22 | AENDLOSM | QAENDLOSM | QAENDERER | CHAR | 12 | 0 | User who Manually Changed the Quality Level | ||
23 | AEDATLOSA | QAEDATLOSA | DATUM | DATS | 8 | 0 | Change Date of the Quality Level | ||
24 | AEDATLOSM | QAEDATLOSM | DATUM | DATS | 8 | 0 | Change Date (Manual) of the Quality Level | ||
25 | AEZEILOSA | QAEZEILOSA | QZEIT | TIMS | 6 | 0 | Change Time of Q-Level | ||
26 | AEZEILOSM | QAEZEILOSM | QZEIT | TIMS | 6 | 0 | Change Time (Manual) of Q-Level | ||
27 | PRUEFLOS | QPLOSQL | NUMC12 | NUMC | 12 | 0 | Number of the Last Inspection Lot with Usage Decision | ||
28 | BWLOS | QBWLOS | QBEWERTUNG | CHAR | 1 | 0 | Valuation (Usage Decision) of the Last Inspection Lot | ||
29 | BWLOSDYN | QBWLOSDYN | QBEWERTUNG | CHAR | 1 | 0 | Dynamic Modification Valuation of the Last Inspection Lot | ||
30 | STICHPRVER | QSTPRVER | QSTPRVER | CHAR | 8 | 0 | Sampling Procedure | QDSV | |
31 | DYNREGEL | QDYNREGEL | QDYNREGEL | CHAR | 3 | 0 | Dynamic Modification Rule | QDDR | |
32 | PRSTUFENAE | QPRSTNAE | QPRSTUFE | NUMC | 4 | 0 | Inspection Stage for Next Inspection | QDPS | |
33 | ANZLOSEOVE | QANZLOSOVE | QDYNANZ2 | INT2 | 5 | 0 | Number of Inspection Lots Without Usage Decision | ||
34 | ANZPRAEN | QANZPRAEN | QDYNANZ2 | INT2 | 5 | 0 | Number of Inspections Since Inspection Stage Change | ||
35 | ANZNIOAEN | QANZNIOAEN | QDYNANZ2 | INT2 | 5 | 0 | Number of Not-OK Inspections (Rejections) Since Stage Change | ||
36 | DBEWERTG | QDDBEWERTG | QEEBEWERTG | CHAR | 1 | 0 | Dynamic Modification Valuation (Accept/Reject) of Char. | ||
37 | MBEWERTG | QDMBEWERTG | QEEBEWERTG | CHAR | 1 | 0 | Valuation of the Characteristic from Results Recording | ||
38 | PLOSOVE | QPLOSQL1 | NUMC12 | NUMC | 12 | 0 | Number of Last Inspection Lot Without Usage Decision | ||
39 | DATLPRUEF | QDATLPRUEF | DATUM | DATS | 8 | 0 | Date of Last Inspection | ||
40 | ANZPRSTOP | QANZPRSTOP | QDYNANZ2 | INT2 | 5 | 0 | No. of Cancelled Inspections per Char. Since Last Inspection | ||
41 | DELDATUM | QDELDAT | DATUM | DATS | 8 | 0 | Deletion Date of the Quality Level | ||
42 | RESDATUM | QRESDAT | DATUM | DATS | 8 | 0 | Reset Date of Quality Level |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | QDQL | DYNREGEL | QDDR | DYNREGEL | REF | 1 | CN |
2 | QDQL | HERSTELLER | LFA1 | LIFNR | REF | C | CN |
3 | QDQL | KUNNR | KNA1 | KUNNR | REF | C | CN |
4 | QDQL | LIFNR | LFA1 | LIFNR | REF | C | CN |
5 | QDQL | MANDT | T000 | MANDT | KEY | 1 | CN |
6 | QDQL | MATNR | MARA | MATNR | KEY | 1 | CN |
7 | QDQL | PLNNR | PLKO | PLNNR | KEY | C | CN |
8 | QDQL | PLNTY | TCA01 | PLNTY | KEY | 1 | CN |
9 | QDQL | PRSTUFENAE | QDPS | PRSTUFE | REF | 1 | CN |
10 | QDQL | PRUEFART | TQ30 | ART | REF | C | CN |
11 | QDQL | STICHPRVER | QDSV | STICHPRVER | REF | C | CN |
12 | QDQL | VPLTY | TCA01 | PLNTY | KEY | 1 | CN |
13 | QDQL | WERKS | T001W | WERKS | KEY | 1 | CN |
History
Last changed by/on | SAP | 20020219 |
SAP Release Created in |