SAP ABAP Table QAPPS_D01 (Structure for QA22)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ QM-IM-UD (Application Component) Inspection Lot Completion
⤷ QV (Package) QM usage decision
⤷ QM-IM-UD (Application Component) Inspection Lot Completion
⤷ QV (Package) QM usage decision
Basic Data
Table Category | INTTAB | Structure |
Structure | QAPPS_D01 | Table Relationship Diagram |
Short Description | Structure for QA22 |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | VORNR | VORNR | VORNR | CHAR | 4 | 0 | Operation/Activity Number | ||
2 | PRUEFPKT | QPRUEFPKT | QPRUEFPKT | CHAR | 250 | 0 | Inspection Point | ||
3 | .INCLUDE | 0 | 0 | Selection table for inspection points | |||||
4 | KZSEL | QKZ | QKZ | CHAR | 1 | 0 | X and Blank (Indicator) | ||
5 | .INCLUDE | 0 | 0 | Inspection point | |||||
6 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
7 | PRUEFLOS | QPLOS | QPLOS | NUMC | 12 | 0 | Inspection Lot Number | QALS | |
8 | VORGLFNR | QLFNKN | KNTNR | NUMC | 8 | 0 | Current Node Number from Order Counter APLZL | ||
9 | PROBENR | QPROBENRPP | QPROBENR | NUMC | 6 | 0 | Sample Number (Based on an Inspection Point) | QASV | |
10 | TEILLOS | QTLOS | QTLOS | NUMC | 6 | 0 | Partial lot number | QALT | |
11 | PPSORTKEY | QPPSORTKEY | QPPSORT | CHAR | 70 | 0 | Key Field (Sort Field) for Inspection Point | ||
12 | MENGE | QMENGEPP | MENG13 | QUAN | 13 | 3 | Inspection Point Yield | ||
13 | MENGE_A | QMENGEPPA | MENG13 | QUAN | 13 | 3 | Scrap for Inspection Point | ||
14 | MENGE_N | QMENGEPPN | MENG13 | QUAN | 13 | 3 | Rework Quantity for The Inspection Point | ||
15 | MENGENEINH | QPPMEINH | MEINS | UNIT | 3 | 0 | Unit of Measure for the Inspection Point | T006 | |
16 | EQUNR | EQUNR | EQUNR | CHAR | 18 | 0 | Equipment Number | EQUI | |
17 | EQUNRAKT | QKZUSRAKT | QKZUSRAKT | CHAR | 1 | 0 | Field Active | ||
18 | TPLNR | TPLNR | TPLNR | CHAR | 30 | 0 | Functional Location | IFLOT | |
19 | TPLNRAKT | QKZUSRAKT | QKZUSRAKT | CHAR | 1 | 0 | Field Active | ||
20 | PHYNR | QPHYSPRNR | QPHYSPRNR | CHAR | 12 | 0 | Physical Sample Number | QPRS | |
21 | PHYNRAKT | QKZUSRAKT | QKZUSRAKT | CHAR | 1 | 0 | Field Active | ||
22 | USERC1 | QUSRCHAR18 | QUSRCHAR18 | CHAR | 18 | 0 | User Field for 18 Characters | ||
23 | USERC1AKT | QKZUSRAKT | QKZUSRAKT | CHAR | 1 | 0 | Field Active | ||
24 | USERC2 | QUSRCHAR10 | QUSRCHAR10 | CHAR | 10 | 0 | User Field for 10 Characters | ||
25 | USERC2AKT | QKZUSRAKT | QKZUSRAKT | CHAR | 1 | 0 | Field Active | ||
26 | USERN1 | QUSRNUMC10 | QUSRNUMC10 | NUMC | 10 | 0 | User Field for 10 Digits | ||
27 | USERN1AKT | QKZUSRAKT | QKZUSRAKT | CHAR | 1 | 0 | Field Active | ||
28 | USERN2 | QUSRNUMC3 | QUSRNUMC3 | NUMC | 3 | 0 | User Field for 3 Digits | ||
29 | USERN2AKT | QKZUSRAKT | QKZUSRAKT | CHAR | 1 | 0 | Field Active | ||
30 | USERD1 | QUSRDATS | QUSRDATS | DATS | 8 | 0 | User Field for Date | ||
31 | USERD1AKT | QKZUSRAKT | QKZUSRAKT | CHAR | 1 | 0 | Field Active | ||
32 | USERT1 | QUSRTIMS | QUSRTIMS | TIMS | 6 | 0 | User Field for Time | ||
33 | USERT1AKT | QKZUSRAKT | QKZUSRAKT | CHAR | 1 | 0 | Field Active | ||
34 | VKATART | QKATART | QKATART | CHAR | 1 | 0 | Catalog | TQ15 | |
35 | VWERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
36 | VAUSWAHLMG | QVMENGE | QAUSWAHLMG | CHAR | 8 | 0 | Selected Set of the Usage Decision | QPAM | |
37 | VCODEGRP | QVGRUPPE | QCODEGRP | CHAR | 8 | 0 | Code Group of the Usage Decision | QPGR | |
38 | VCODE | QVCODE | QCODE | CHAR | 4 | 0 | Usage Decision Code | QPCD | |
39 | VBEWERTUNG | QBEWERTUNG | QBEWERTUNG | CHAR | 1 | 0 | Code Valuation | ||
40 | KZBEWERT | QPPBEWERT | QPPBEWERT | CHAR | 1 | 0 | Valuation Status Inspection Point | ||
41 | KZFERTIG | QPPFERTIG | QPPFERTIG | CHAR | 1 | 0 | Inspection Point Status | ||
42 | KZPTLBEST | QKZPTLBEST | QKZ | CHAR | 1 | 0 | Inspection with Stock-Related Partial Lot Assignment | ||
43 | RUECK | CO_RUECK | CO_RUECK | NUMC | 10 | 0 | Completion confirmation number for the operation | ||
44 | RMZHL | CO_RMZHL | CIM_COUNT | NUMC | 8 | 0 | Confirmation counter | ||
45 | MBLNR | MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | ||
46 | MJAHR | MJAHR | GJAHR | NUMC | 4 | 0 | Year of material document | ||
47 | ZEILE | MBLPO | MBLPO | NUMC | 4 | 0 | Item in material document | ||
48 | PRUEFER | QPRUEFER | QPRUEFER | CHAR | 12 | 0 | Name of the Inspector | ||
49 | ENTSTEHDAT | QENTDATPP | DATUM | DATS | 8 | 0 | Date of Inspection Point Creation | ||
50 | ENTSTEHZT | QENTZEITPP | QZEIT | TIMS | 6 | 0 | Time of Inspection Point Creation | ||
51 | ERSTELLER | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
52 | ERSTELDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
53 | ERSTELZEIT | QZEITERSTL | QZEIT | TIMS | 6 | 0 | Time at which data record was created | ||
54 | AENDERER | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
55 | AENDERDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
56 | AENDERZEIT | QZEITAEND | QZEIT | TIMS | 6 | 0 | Time at which data record was last changed | ||
57 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
58 | KTEXTTLOS | QTXTTL | QKURZTEXT | CHAR | 40 | 0 | Short Text for Partial Lot | ||
59 | VETEXT | QTXTTL | QKURZTEXT | CHAR | 40 | 0 | Short Text for Partial Lot |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | QAPPS_D01 | EQUNR | EQUI | EQUNR | KEY | C | CN |
2 | QAPPS_D01 | MANDT | T000 | MANDT | |||
3 | QAPPS_D01 | MENGENEINH | T006 | MSEHI | |||
4 | QAPPS_D01 | PHYNR | QPRS | PHYNR | KEY | C | CN |
5 | QAPPS_D01 | PROBENR | QASV | PROBENR | KEY | 1 | CN |
6 | QAPPS_D01 | PRUEFLOS | QALS | PRUEFLOS | KEY | 1 | CN |
7 | QAPPS_D01 | TEILLOS | QALT | TEILLOS | KEY | 1 | CN |
8 | QAPPS_D01 | TPLNR | IFLOT | TPLNR | KEY | C | CN |
9 | QAPPS_D01 | VAUSWAHLMG | QPAM | AUSWAHLMGE | REF | C | CN |
10 | QAPPS_D01 | VCODE | QPCD | CODE | REF | C | CN |
11 | QAPPS_D01 | VCODEGRP | QPGR | CODEGRUPPE | REF | C | CN |
12 | QAPPS_D01 | VKATART | TQ15 | KATALOGART | REF | 1 | N |
13 | QAPPS_D01 | VWERKS | T001W | WERKS | REF | 1 | N |
History
Last changed by/on | SAP | 20020219 |
SAP Release Created in |