SAP ABAP Table RQPRS (Screen fields for processing the sample master record)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ QM-IM-SM (Application Component) Sample Management
⤷ QPR (Package) QM sample management
⤷ QM-IM-SM (Application Component) Sample Management
⤷ QPR (Package) QM sample management
Basic Data
Table Category | INTTAB | Structure |
Structure | RQPRS | Table Relationship Diagram |
Short Description | Screen fields for processing the sample master record |
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 | PHYNR | QPHYSPRNR | QPHYSPRNR | CHAR | 12 | 0 | Physical Sample Number | QPRS | |
2 | STATU | QPRSSTATUS | CHAR40 | CHAR | 40 | 0 | Internal Status of Physical-Sample Record | ||
3 | ANWKZ | CO_ASTEX | KREUZ | CHAR | 1 | 0 | User status active | ||
4 | ANWST | QPRS_ANWST | CHAR40 | CHAR | 40 | 0 | User Status of the Physical-Sample Record | ||
5 | PRART | QPRART | QPRART | CHAR | 2 | 0 | Physical-Sample Type | TQ40 | |
6 | PRTYP | QPRTYP | QPRTYP | CHAR | 1 | 0 | Sample Category | TQ44 | |
7 | KTEXT | QTEXT_PRS | TEXT80 | CHAR | 80 | 0 | Short Text for Physical Sample | ||
8 | PLOS2 | QLOT_LATE | QPLOS | NUMC | 12 | 0 | Current or Last Inspection Lot for the Sample | QALS | |
9 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
10 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
11 | REVLV | REVLV | REVLV | CHAR | 2 | 0 | Revision level | ||
12 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | MCH1 | |
13 | KUNNR | QKUNWE | KUNNR | CHAR | 10 | 0 | Customer (Ship-To Party) | KNA1 | |
14 | LIFNR | ELIFN | LIFNR | CHAR | 10 | 0 | Vendor's account number | LFA1 | |
15 | HRSTL | QLIFNR | LIFNR | CHAR | 10 | 0 | Number of Manufacturer | LFA1 | |
16 | MBLNR | MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | MSEG | |
17 | ZEILE | MBLPO | MBLPO | NUMC | 4 | 0 | Item in material document | MSEG | |
18 | MJAHR | MJAHR | GJAHR | NUMC | 4 | 0 | Year of material document | MSEG | |
19 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | AUFK | |
20 | VERID | VERID | VERID | CHAR | 4 | 0 | Production Version | MKAL | |
21 | SA_AUFNR | SA_AUFNR | SA_AUFNR | CHAR | 12 | 0 | Run schedule header number | SAFK | |
22 | PN_NR | QPZNR | NUMC12 | NUMC | 12 | 0 | Sample-Drawing Number | QPRN | |
23 | PNVER | QPRZIEHVER | QPRZIEHVER | CHAR | 8 | 0 | Sample-Drawing Procedure | QPRVK | |
24 | PNVEV | QVERSNPRZV | QVERSNR | CHAR | 6 | 0 | Version No. of the Sample-Drawing Procedure | ||
25 | MENGE | QPHYSPRUM | QMENGEPLOS | QUAN | 13 | 3 | Size of the Physical Sample | ||
26 | MEINH | QPHYSPRME | MEINS | UNIT | 3 | 0 | Unit of Measure for Physical Sample Size | T006 | |
27 | ANZGB | QANZGEB | QGEBPLOS | QUAN | 6 | 3 | QM - No. of Containers | ||
28 | GEBEH | QGEBEH | MEINS | UNIT | 3 | 0 | Lot Container | T006 | |
29 | GBTYP | QGEBINDET | QGEBINDET | CHAR | 6 | 0 | Physical-Sample Container | TQ42 | |
30 | PZTXT | QPZ_TEXT | TEXT40 | CHAR | 40 | 0 | Comments on the Physical-Sample Drawing | ||
31 | XMANU | QPRB_MAN | QKZ | CHAR | 1 | 0 | Manually Created Sample | ||
32 | ALORT | QAUFBLGORT | LGORT | CHAR | 4 | 0 | Actual Storage Location for the Physical Sample | T001L | |
33 | ABORT | QAUFBEWORT | QAUFBEWORT | CHAR | 12 | 0 | Storage Location for a Physical Sample | TQ41 | |
34 | ABDAU | QAUFBDAUER | DEC5 | DEC | 5 | 0 | Storage Duration of the Physical Sample in Days | ||
35 | ABDAT | QAUFBDATUM | DATUM | DATS | 8 | 0 | Storage Deadline for Physical Sample | ||
36 | ABINF | QAUFBINFO | TEXT80 | CHAR | 80 | 0 | Storage Information for the Physical Sample | ||
37 | AUFBX | QAUFB_KZ | QKZ | CHAR | 1 | 0 | Sample Was Stored | ||
38 | PRNVX | QPRNV_KZ | QKZ | CHAR | 1 | 0 | Physical Sample No Longer Exists | ||
39 | LOEKZ | QLOE_KZ | QKZ | CHAR | 1 | 0 | Deletion Flag | ||
40 | ANLNA | QPRS_ANL | QAENDERER | CHAR | 12 | 0 | User who Created the Physical Sample | ||
41 | ANLDT | QPRS_ANLDT | DATUM | DATS | 8 | 0 | Creation Date of Physical Sample | ||
42 | ANLZT | QPRS_ANLZT | QZEIT | TIMS | 6 | 0 | Time at Which the Physical Sample Was Created | ||
43 | FRGNA | QPRS_FRG | QAENDERER | CHAR | 12 | 0 | User who Released the Physical Sample | ||
44 | FRGDT | QPRS_FRGDT | DATUM | DATS | 8 | 0 | Physical Sample Release Date | ||
45 | FRGZT | QPRS_FRGZT | QZEIT | TIMS | 6 | 0 | Time of Physical Sample Release | ||
46 | XPR_O | QXPROBE_O | QKZ | CHAR | 1 | 0 | New Sample Without Copy Model | ||
47 | XPR_M | QXPROBE_M | QKZ | CHAR | 1 | 0 | New Sample with Copy Model | ||
48 | XPNRN | QXPN_NR_N | QKZ | CHAR | 1 | 0 | New Sample-Drawing Without Copy Model | ||
49 | XPNRR | QXPN_NR_R | QKZ | CHAR | 1 | 0 | New Physical-Sample Drawing with Copy Model | ||
50 | XPNRE | QXPN_NR_E | QKZ | CHAR | 1 | 0 | Extend Physical-Sample Drawing | ||
51 | VENUM | VENUM | VENUM | CHAR | 10 | 0 | Internal Handling Unit Number | VEKP | |
52 | VEPOS | VEPOS | VEPOS | NUMC | 6 | 0 | Handling Unit Item | VEPO | |
53 | EXIDV | EXIDV | EXIDV | CHAR | 20 | 0 | External Handling Unit Identification | ||
54 | QAUTH | QMATAUTH | QMATAUTH | CHAR | 6 | 0 | Material authorization group for activities in QM | * | |
55 | KTEXTMAT | QKTEXTMAT | QKURZTEXT | CHAR | 40 | 0 | Material short text | ||
56 | KTEXTLIEF | QTXTLIEF | QKURZTEXT | CHAR | 40 | 0 | Name of Vendor | ||
57 | KTEXTHERST | QTXTHERST | QKURZTEXT | CHAR | 40 | 0 | Name of Manufacturer | ||
58 | KTEXTKUNDE | QTXTKUNDE | QKURZTEXT | CHAR | 40 | 0 | Customer Name | ||
59 | .INCLUDE | 0 | 0 | PLM ADDON for Sample Master Record | |||||
60 | ADDON_DUMMY | QDUMMY | QDUMMY | CHAR | 1 | 0 | Dummy Field for ADDON Structures in QM | ||
61 | .INCLU--AP | 0 | 0 | Addon Fields for Stability Study | |||||
62 | PRIMPACK | QPRIMPACK | QPRIMPACK | CHAR | 8 | 0 | Primary Packaging (Stability Study) | TQ45 | |
63 | STABICON | QSTABICON | QSTABICON | CHAR | 8 | 0 | Storage Condition | TQ43 | |
64 | EINGDT | QST_EINGDT | DATUM | DATS | 8 | 0 | Date of Receipt of Initial Sample for Stability Study | ||
65 | EINLDT | QST_EINLDT | DATUM | DATS | 8 | 0 | Storage Date of Sample for Storage Condition | ||
66 | AUSLDT | QST_AUSLDT | DATUM | DATS | 8 | 0 | Date of Removal from Storage of Sample for Storage Condition | ||
67 | ENTORT | QPRSENTORT | TPLNR | CHAR | 30 | 0 | Location of Sample Drawing (Functional Location) | * | |
68 | INFEORT | QPRSINFEORT | CHAR60 | CHAR | 60 | 0 | Description of Sample-Drawing Location | ||
69 | ENTDATUM | QPRSENTDATUM | DATUM | DATS | 8 | 0 | Date of Sample Drawing | ||
70 | ENTZEIT | QPRSENTZEIT | QZEIT | TIMS | 6 | 0 | Time of Sample Drawing | ||
71 | BEARBEITER | QPRSBEARBEITER | CHAR20 | CHAR | 20 | 0 | Processor Responsible for the Sample, Sample Taker | ||
72 | KTEXTTPL | PLTXT | TEXT40 | CHAR | 40 | 0 | Description of functional location | ||
73 | LABOR | QLABOR | QPLEXT_PRPLATZ | CHAR | 8 | 0 | Work Center (Laboratory) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RQPRS | ABORT | TQ41 | AUFBEWORT | KEY | C | CN |
2 | RQPRS | ALORT | T001L | LGORT | KEY | C | CN |
3 | RQPRS | AUFNR | AUFK | AUFNR | |||
4 | RQPRS | CHARG | MCH1 | CHARG | |||
5 | RQPRS | GBTYP | TQ42 | GEBINDETYP | |||
6 | RQPRS | GEBEH | T006 | MSEHI | |||
7 | RQPRS | HRSTL | LFA1 | LIFNR | |||
8 | RQPRS | KUNNR | KNA1 | KUNNR | |||
9 | RQPRS | LIFNR | LFA1 | LIFNR | |||
10 | RQPRS | MATNR | MARA | MATNR | |||
11 | RQPRS | MBLNR | MSEG | MBLNR | |||
12 | RQPRS | MEINH | T006 | MSEHI | |||
13 | RQPRS | MJAHR | MSEG | MJAHR | |||
14 | RQPRS | PHYNR | QPRS | PHYNR | |||
15 | RQPRS | PLOS2 | QALS | PRUEFLOS | |||
16 | RQPRS | PNVER | QPRVK | PRZIEHVERF | |||
17 | RQPRS | PN_NR | QPRN | PN_NR | |||
18 | RQPRS | PRART | TQ40 | PRART | |||
19 | RQPRS | PRIMPACK | TQ45 | PRIMPACK | REF | 1 | CN |
20 | RQPRS | PRTYP | TQ44 | PRTYP | REF | 1 | CN |
21 | RQPRS | SA_AUFNR | SAFK | AUFNR | |||
22 | RQPRS | STABICON | TQ43 | STABICON | REF | 1 | CN |
23 | RQPRS | VENUM | VEKP | VENUM | |||
24 | RQPRS | VEPOS | VEPO | VEPOS | |||
25 | RQPRS | VERID | MKAL | VERID | |||
26 | RQPRS | WERKS | T001W | WERKS | |||
27 | RQPRS | ZEILE | MSEG | ZEILE |
History
Last changed by/on | SAP | 20050411 |
SAP Release Created in |