SAP ABAP Table LQPRS (List Output Structure for Physical Samples)
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 | LQPRS | Table Relationship Diagram |
Short Description | List Output Structure for Physical Samples |
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 | .INCLUDE | 0 | 0 | Master record for phys. samples | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | PHYNR | QPHYSPRNR | QPHYSPRNR | CHAR | 12 | 0 | Physical Sample Number | * | |
4 | OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | ONR00 | |
5 | STSMA | QSTSMA_PRS | J_STSMA | CHAR | 8 | 0 | Status Profile for Physical Samples | TJ20 | |
6 | PRART | QPRART | QPRART | CHAR | 2 | 0 | Physical-Sample Type | TQ40 | |
7 | PRTYP | QPRTYP | QPRTYP | CHAR | 1 | 0 | Sample Category | TQ44 | |
8 | PN_NR | QPZNR | NUMC12 | NUMC | 12 | 0 | Sample-Drawing Number | QPRN | |
9 | XMANU | QPRB_MAN | QKZ | CHAR | 1 | 0 | Manually Created Sample | ||
10 | GBTYP | QGEBINDET | QGEBINDET | CHAR | 6 | 0 | Physical-Sample Container | TQ42 | |
11 | MENGE | QPHYSPRUM | QMENGEPLOS | QUAN | 13 | 3 | Size of the Physical Sample | ||
12 | MEINH | QPHYSPRME | MEINS | UNIT | 3 | 0 | Unit of Measure for Physical Sample Size | T006 | |
13 | PLOS2 | QLOT_LATE | QPLOS | NUMC | 12 | 0 | Current or Last Inspection Lot for the Sample | QALS | |
14 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
15 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
16 | REVLV | REVLV | REVLV | CHAR | 2 | 0 | Revision level | ||
17 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | MCH1 | |
18 | KTEXT | QTEXT_PRS | TEXT80 | CHAR | 80 | 0 | Short Text for Physical Sample | ||
19 | QAUTH | QMATAUTH | QMATAUTH | CHAR | 6 | 0 | Material authorization group for activities in QM | TQ01B | |
20 | PNVER | QPRZIEHVER | QPRZIEHVER | CHAR | 8 | 0 | Sample-Drawing Procedure | QPRVK | |
21 | PNVEV | QVERSNPRZV | QVERSNR | CHAR | 6 | 0 | Version No. of the Sample-Drawing Procedure | QPRVK | |
22 | PNPOS | QZAEHLPRZV | NUM4 | NUMC | 4 | 0 | Item Number in Sample-Drawing Procedure | ||
23 | GEBEH | QGEBEH | MEINS | UNIT | 3 | 0 | Lot Container | T006 | |
24 | TPBIS | QPROBNRBIS | QPROBEPL | NUMC | 3 | 0 | Highest Partial Sample No. Valid for Instruction | ||
25 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
26 | ABORT | QAUFBEWORT | QAUFBEWORT | CHAR | 12 | 0 | Storage Location for a Physical Sample | TQ41 | |
27 | ABDAU | QAUFBDAUER | DEC5 | DEC | 5 | 0 | Storage Duration of the Physical Sample in Days | ||
28 | ABDAT | QAUFBDATUM | DATUM | DATS | 8 | 0 | Storage Deadline for Physical Sample | ||
29 | ABINF | QAUFBINFO | TEXT80 | CHAR | 80 | 0 | Storage Information for the Physical Sample | ||
30 | AENNA | QPRS_AEN | QAENDERER | CHAR | 12 | 0 | Last User who Changed the Physical-Sample Record | ||
31 | AENDT | QPRS_AENDT | DATUM | DATS | 8 | 0 | Date the Physical Sample Was Changed | ||
32 | AENZT | QPRS_AENZT | QZEIT | TIMS | 6 | 0 | Time at Which Physical-Sample Record Changed | ||
33 | VENUM | VENUM | VENUM | CHAR | 10 | 0 | Internal Handling Unit Number | * | |
34 | VEPOS | VEPOS | VEPOS | NUMC | 6 | 0 | Handling Unit Item | * | |
35 | .INCLUDE | 0 | 0 | ||||||
36 | .INCLUDE | 0 | 0 | PLM ADDON for Sample Master Record | |||||
37 | ADDON_DUMMY | QDUMMY | QDUMMY | CHAR | 1 | 0 | Dummy Field for ADDON Structures in QM | ||
38 | .INCLU--AP | 0 | 0 | Addon Fields for Stability Study | |||||
39 | PRIMPACK | QPRIMPACK | QPRIMPACK | CHAR | 8 | 0 | Primary Packaging (Stability Study) | TQ45 | |
40 | STABICON | QSTABICON | QSTABICON | CHAR | 8 | 0 | Storage Condition | TQ43 | |
41 | EINGDT | QST_EINGDT | DATUM | DATS | 8 | 0 | Date of Receipt of Initial Sample for Stability Study | ||
42 | EINLDT | QST_EINLDT | DATUM | DATS | 8 | 0 | Storage Date of Sample for Storage Condition | ||
43 | AUSLDT | QST_AUSLDT | DATUM | DATS | 8 | 0 | Date of Removal from Storage of Sample for Storage Condition | ||
44 | ENTORT | QPRSENTORT | TPLNR | CHAR | 30 | 0 | Location of Sample Drawing (Functional Location) | * | |
45 | INFEORT | QPRSINFEORT | CHAR60 | CHAR | 60 | 0 | Description of Sample-Drawing Location | ||
46 | ENTDATUM | QPRSENTDATUM | DATUM | DATS | 8 | 0 | Date of Sample Drawing | ||
47 | ENTZEIT | QPRSENTZEIT | QZEIT | TIMS | 6 | 0 | Time of Sample Drawing | ||
48 | BEARBEITER | QPRSBEARBEITER | CHAR20 | CHAR | 20 | 0 | Processor Responsible for the Sample, Sample Taker | ||
49 | LABOR | QLABOR | QPLEXT_PRPLATZ | CHAR | 8 | 0 | Work Center (Laboratory) | ||
50 | KUNNR | QKUNWE | KUNNR | CHAR | 10 | 0 | Customer (Ship-To Party) | KNA1 | |
51 | LIFNR | ELIFN | LIFNR | CHAR | 10 | 0 | Vendor's account number | LFA1 | |
52 | HRSTL | QLIFNR | LIFNR | CHAR | 10 | 0 | Number of Manufacturer | LFA1 | |
53 | MBLNR | MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | ||
54 | ZEILE | MBLPO | MBLPO | NUMC | 4 | 0 | Item in material document | ||
55 | MJAHR | MJAHR | GJAHR | NUMC | 4 | 0 | Year of material document | ||
56 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | AUFK | |
57 | VERID | VERID | VERID | CHAR | 4 | 0 | Production Version | MKAL | |
58 | SA_AUFNR | SA_AUFNR | SA_AUFNR | CHAR | 12 | 0 | Run schedule header number | SAFK | |
59 | KZQUIT | QKZQUIT | QKZ | CHAR | 1 | 0 | Confirmation Required for Physical-Sample Drawing | ||
60 | SIG_IL_SDR | SIG_IL_SDR | SIG_IL_SDR | CHAR | 1 | 0 | Digital Signature for Confirmation of Phys.-Sample Drawing | ||
61 | FRGNA | QPRS_FRG | QAENDERER | CHAR | 12 | 0 | User who Released the Physical Sample | ||
62 | FRGDT | QPRS_FRGDT | DATUM | DATS | 8 | 0 | Physical Sample Release Date | ||
63 | FRGZT | QPRS_FRGZT | QZEIT | TIMS | 6 | 0 | Time of Physical Sample Release | ||
64 | PZTXT | QPZ_TEXT | TEXT40 | CHAR | 40 | 0 | Comments on the Physical-Sample Drawing | ||
65 | TXTMAT | QTXTMAT | QKURZTEXT | CHAR | 40 | 0 | Material short text | ||
66 | TXTLIEF | QTXTLIEF | QKURZTEXT | CHAR | 40 | 0 | Name of Vendor | ||
67 | TXTHERST | QTXTHERST | QKURZTEXT | CHAR | 40 | 0 | Name of Manufacturer | ||
68 | TXTKUNDE | QTXTKUNDE | QKURZTEXT | CHAR | 40 | 0 | Customer Name | ||
69 | STATU | QPRSSTATUS | CHAR40 | CHAR | 40 | 0 | Internal Status of Physical-Sample Record | ||
70 | ANWKZ | CO_ASTEX | KREUZ | CHAR | 1 | 0 | User status active | ||
71 | ANWST | QPRS_ANWST | CHAR40 | CHAR | 40 | 0 | User Status of the Physical-Sample Record |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | LQPRS | ABORT | TQ41 | AUFBEWORT | KEY | C | CN |
2 | LQPRS | AUFNR | AUFK | AUFNR | |||
3 | LQPRS | CHARG | MCH1 | CHARG | REF | C | CN |
4 | LQPRS | GBTYP | TQ42 | GEBINDETYP | |||
5 | LQPRS | GEBEH | T006 | MSEHI | |||
6 | LQPRS | HRSTL | LFA1 | LIFNR | |||
7 | LQPRS | KUNNR | KNA1 | KUNNR | |||
8 | LQPRS | LGORT | T001L | LGORT | REF | C | CN |
9 | LQPRS | LIFNR | LFA1 | LIFNR | |||
10 | LQPRS | MANDT | T000 | MANDT | KEY | 1 | CN |
11 | LQPRS | MATNR | MARA | MATNR | REF | C | CN |
12 | LQPRS | MEINH | T006 | MSEHI | |||
13 | LQPRS | OBJNR | ONR00 | OBJNR | KEY | 1 | C |
14 | LQPRS | PLOS2 | QALS | PRUEFLOS | |||
15 | LQPRS | PNVER | QPRVK | PRZIEHVERF | |||
16 | LQPRS | PNVEV | QPRVK | VERSION | |||
17 | LQPRS | PN_NR | QPRN | PN_NR | KEY | 1 | CN |
18 | LQPRS | PRART | TQ40 | PRART | KEY | 1 | CN |
19 | LQPRS | PRIMPACK | TQ45 | PRIMPACK | REF | 1 | CN |
20 | LQPRS | PRTYP | TQ44 | PRTYP | REF | 1 | CN |
21 | LQPRS | QAUTH | TQ01B | QMATAUTH | REF | C | CN |
22 | LQPRS | SA_AUFNR | SAFK | AUFNR | |||
23 | LQPRS | STABICON | TQ43 | STABICON | REF | 1 | CN |
24 | LQPRS | STSMA | TJ20 | STSMA | REF | C | CN |
25 | LQPRS | VERID | MKAL | VERID | REF | C | CN |
26 | LQPRS | WERKS | T001W | WERKS | KEY | 1 | CN |
History
Last changed by/on | SAP | 20050411 |
SAP Release Created in |