SAP ABAP Table QPRS_SEL_P (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | QPRS_SEL_P |
Table Relationship Diagram 
|
| Short Description | Generated Table for View |
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 | PRTYP |
QPRTYP | QPRTYP | CHAR | 1 | 0 | Sample Category | TQ44 | |
| 4 | PRUEFLOS |
QPLOS | QPLOS | NUMC | 12 | 0 | Inspection Lot Number | QALS | |
| 5 | VORGLFNR |
QLFNKN | KNTNR | NUMC | 8 | 0 | Current Node Number from Order Counter APLZL | ||
| 6 | VORNR |
VORNR | VORNR | CHAR | 4 | 0 | Operation/Activity Number | ||
| 7 | PROBENR |
QPROBENRPP | QPROBENR | NUMC | 6 | 0 | Sample Number (Based on an Inspection Point) | QASV | |
| 8 | PPSORTKEY |
QPPSORTKEY | QPPSORT | CHAR | 70 | 0 | Key Field (Sort Field) for Inspection Point | ||
| 9 | VBEWERTUNG |
QBEWERTUNG | QBEWERTUNG | CHAR | 1 | 0 | Code Valuation | ||
| 10 | AENDERDAT |
AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
| 11 | AENDERZEIT |
QZEITAEND | QZEIT | TIMS | 6 | 0 | Time at which data record was last changed | ||
| 12 | USERC1 |
QUSRCHAR18 | QUSRCHAR18 | CHAR | 18 | 0 | User Field for 18 Characters | ||
| 13 | USERC2 |
QUSRCHAR10 | QUSRCHAR10 | CHAR | 10 | 0 | User Field for 10 Characters | ||
| 14 | USERN1 |
QUSRNUMC10 | QUSRNUMC10 | NUMC | 10 | 0 | User Field for 10 Digits | ||
| 15 | USERN2 |
QUSRNUMC3 | QUSRNUMC3 | NUMC | 3 | 0 | User Field for 3 Digits | ||
| 16 | USERD1 |
QUSRDATS | QUSRDATS | DATS | 8 | 0 | User Field for Date | ||
| 17 | USERT1 |
QUSRTIMS | QUSRTIMS | TIMS | 6 | 0 | User Field for Time |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | QPRS_SEL_P | MANDT |  T000 |
MANDT |
KEY | 1 | CN |
| 2 | QPRS_SEL_P | PROBENR | QASV |
PROBENR |
KEY | 1 | CN |
| 3 | QPRS_SEL_P | PRTYP | TQ44 |
PRTYP |
REF | 1 | CN |
| 4 | QPRS_SEL_P | PRUEFLOS | QALS |
PRUEFLOS |
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |
