SAP ABAP Table MGV_QPRS (Generated Table for View MGV_QPRS)
Basic Data
Table Category | VIEW | General view structure |
General view structure | MGV_QPRS | Table Relationship Diagram |
Short Description | Generated Table for View MGV_QPRS |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | PHYNR | QPHYSPRNR | QPHYSPRNR | CHAR | 12 | 0 | Physical Sample Number | ||
3 | OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | ONR00 | |
4 | STSMA | QSTSMA_PRS | J_STSMA | CHAR | 8 | 0 | Status Profile for Physical Samples | TJ20 | |
5 | PRART | QPRART | QPRART | CHAR | 2 | 0 | Physical-Sample Type | TQ40 | |
6 | PRTYP | QPRTYP | QPRTYP | CHAR | 1 | 0 | Sample Category | TQ44 | |
7 | PN_NR | QPZNR | NUMC12 | NUMC | 12 | 0 | Sample-Drawing Number | QPRN | |
8 | XMANU | QPRB_MAN | QKZ | CHAR | 1 | 0 | Manually Created Sample | ||
9 | GBTYP | QGEBINDET | QGEBINDET | CHAR | 6 | 0 | Physical-Sample Container | TQ42 | |
10 | MENGE | QPHYSPRUM | QMENGEPLOS | QUAN | 13 | 3 | Size of the Physical Sample | ||
11 | MEINH | QPHYSPRME | MEINS | UNIT | 3 | 0 | Unit of Measure for Physical Sample Size | T006 | |
12 | PLOS2 | QLOT_LATE | QPLOS | NUMC | 12 | 0 | Current or Last Inspection Lot for the Sample | QALS | |
13 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
14 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
15 | REVLV | REVLV | REVLV | CHAR | 2 | 0 | Revision level | ||
16 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | MCH1 | |
17 | KTEXT | QTEXT_PRS | TEXT80 | CHAR | 80 | 0 | Short Text for Physical Sample | ||
18 | QAUTH | QMATAUTH | QMATAUTH | CHAR | 6 | 0 | Material authorization group for activities in QM | TQ01B | |
19 | PNVER | QPRZIEHVER | QPRZIEHVER | CHAR | 8 | 0 | Sample-Drawing Procedure | QPRVK | |
20 | PNVEV | QVERSNPRZV | QVERSNR | CHAR | 6 | 0 | Version No. of the Sample-Drawing Procedure | QPRVK | |
21 | PNPOS | QZAEHLPRZV | NUM4 | NUMC | 4 | 0 | Item Number in Sample-Drawing Procedure | ||
22 | GEBEH | QGEBEH | MEINS | UNIT | 3 | 0 | Lot Container | T006 | |
23 | TPBIS | QPROBNRBIS | QPROBEPL | NUMC | 3 | 0 | Highest Partial Sample No. Valid for Instruction | ||
24 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
25 | ABORT | QAUFBEWORT | QAUFBEWORT | CHAR | 12 | 0 | Storage Location for a Physical Sample | TQ41 | |
26 | ABDAU | QAUFBDAUER | DEC5 | DEC | 5 | 0 | Storage Duration of the Physical Sample in Days | ||
27 | ABDAT | QAUFBDATUM | DATUM | DATS | 8 | 0 | Storage Deadline for Physical Sample | ||
28 | ABINF | QAUFBINFO | TEXT80 | CHAR | 80 | 0 | Storage Information for the Physical Sample | ||
29 | AENNA | QPRS_AEN | QAENDERER | CHAR | 12 | 0 | Last User who Changed the Physical-Sample Record | ||
30 | AENDT | QPRS_AENDT | DATUM | DATS | 8 | 0 | Date the Physical Sample Was Changed | ||
31 | AENZT | QPRS_AENZT | QZEIT | TIMS | 6 | 0 | Time at Which Physical-Sample Record Changed | ||
32 | VENUM | VENUM | VENUM | CHAR | 10 | 0 | Internal Handling Unit Number | ||
33 | VEPOS | VEPOS | VEPOS | NUMC | 6 | 0 | Handling Unit Item | ||
34 | ADDON_DUMMY | QDUMMY | QDUMMY | CHAR | 1 | 0 | Dummy Field for ADDON Structures in QM | ||
35 | PRIMPACK | QPRIMPACK | QPRIMPACK | CHAR | 8 | 0 | Primary Packaging (Stability Study) | TQ45 | |
36 | STABICON | QSTABICON | QSTABICON | CHAR | 8 | 0 | Storage Condition | TQ43 | |
37 | EINGDT | QST_EINGDT | DATUM | DATS | 8 | 0 | Date of Receipt of Initial Sample for Stability Study | ||
38 | EINLDT | QST_EINLDT | DATUM | DATS | 8 | 0 | Storage Date of Sample for Storage Condition | ||
39 | AUSLDT | QST_AUSLDT | DATUM | DATS | 8 | 0 | Date of Removal from Storage of Sample for Storage Condition | ||
40 | ENTORT | QPRSENTORT | TPLNR | CHAR | 30 | 0 | Location of Sample Drawing (Functional Location) | ||
41 | INFEORT | QPRSINFEORT | CHAR60 | CHAR | 60 | 0 | Description of Sample-Drawing Location | ||
42 | ENTDATUM | QPRSENTDATUM | DATUM | DATS | 8 | 0 | Date of Sample Drawing | ||
43 | ENTZEIT | QPRSENTZEIT | QZEIT | TIMS | 6 | 0 | Time of Sample Drawing | ||
44 | BEARBEITER | QPRSBEARBEITER | CHAR20 | CHAR | 20 | 0 | Processor Responsible for the Sample, Sample Taker | ||
45 | LABOR | QLABOR | QPLEXT_PRPLATZ | CHAR | 8 | 0 | Work Center (Laboratory) | ||
46 | MATNR_EXT | MATNR_EXT | MATNR_EXT | CHAR | 40 | 0 | External Long Material Number | ||
47 | MATNR_VERS | MATNR_VERS | MATNR_VERS | CHAR | 10 | 0 | Material Version Number |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MGV_QPRS | ABORT | TQ41 | AUFBEWORT | KEY | C | CN |
2 | MGV_QPRS | CHARG | MCH1 | CHARG | REF | C | CN |
3 | MGV_QPRS | GBTYP | TQ42 | GEBINDETYP | |||
4 | MGV_QPRS | GEBEH | T006 | MSEHI | |||
5 | MGV_QPRS | LGORT | T001L | LGORT | REF | C | CN |
6 | MGV_QPRS | MANDT | T000 | MANDT | KEY | 1 | CN |
7 | MGV_QPRS | MATNR | MARA | MATNR | REF | C | CN |
8 | MGV_QPRS | MEINH | T006 | MSEHI | |||
9 | MGV_QPRS | OBJNR | ONR00 | OBJNR | KEY | 1 | C |
10 | MGV_QPRS | PLOS2 | QALS | PRUEFLOS | |||
11 | MGV_QPRS | PNVER | QPRVK | PRZIEHVERF | |||
12 | MGV_QPRS | PNVEV | QPRVK | VERSION | |||
13 | MGV_QPRS | PN_NR | QPRN | PN_NR | REF | 1 | CN |
14 | MGV_QPRS | PRART | TQ40 | PRART | KEY | 1 | CN |
15 | MGV_QPRS | PRIMPACK | TQ45 | PRIMPACK | REF | 1 | CN |
16 | MGV_QPRS | PRTYP | TQ44 | PRTYP | REF | 1 | CN |
17 | MGV_QPRS | QAUTH | TQ01B | QMATAUTH | REF | C | CN |
18 | MGV_QPRS | STABICON | TQ43 | STABICON | REF | 1 | CN |
19 | MGV_QPRS | STSMA | TJ20 | STSMA | REF | C | CN |
20 | MGV_QPRS | WERKS | T001W | WERKS | KEY | 1 | CN |
History
Last changed by/on | SAP | 20070918 |
SAP Release Created in |