QPRSA SAP (Archiving Structure for Physical Samples) Structure details

Dictionary Type: Structure
Description: Archiving Structure for Physical Samples




ABAP Code to SELECT data from QPRSA
Related tables to QPRSA
Access table QPRSA




Structure field list including key, data, relationships and ABAP select examples

QPRSA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Archiving Structure for Physical Samples" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_QPRSA TYPE QPRSA.

The QPRSA table consists of various fields, each holding specific information or linking keys about Archiving Structure for Physical Samples data available in SAP. These include MANDT (Client), PHYNR (Physical Sample Number), OBJNR (Object number), STSMA (Status Profile for Physical Samples).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP QPRSA structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
PHYNRPhysical Sample Number QPHYSPRNRCHAR12Assigned to domainALPHAQPHYSPRNRQPN
OBJNRObject number J_OBJNRCHAR22ONR00J_OBJNRONR
STSMAStatus Profile for Physical Samples QSTSMA_PRSCHAR8TJ20J_STSMA
PRARTPhysical-Sample Type QPRARTCHAR2TQ40QPRART
PRTYPSample Category QPRTYPCHAR1TQ44QPRTYP
PN_NRSample-Drawing Number QPZNRNUMC12QPRNNUMC12QPZ
XMANUManually Created Sample QPRB_MANCHAR1QKZ
GBTYPPhysical-Sample Container QGEBINDETCHAR6TQ42QGEBINDET
MENGESize of the Physical Sample QPHYSPRUMQUAN13(3) QMENGEPLOS
MEINHUnit of Measure for Physical Sample Size QPHYSPRMEUNIT3T006CUNITMEINS
PLOS2Current or Last Inspection Lot for the Sample QLOT_LATENUMC12QALSQPLOSQALS
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
REVLVRevision Level REVLVCHAR2NUMCVREVLVRVS
CHARGBatch Number CHARG_DCHAR10MCH1CHARGCHA
KTEXTShort Text for Physical Sample QTEXT_PRSCHAR80TEXT80
QAUTHMaterial Authorization Group for Activities in QM QMATAUTHCHAR6TQ01BQMATAUTH
PNVERSample-Drawing Procedure QPRZIEHVERCHAR8QPRVKQPRZIEHVERQPV
PNVEVVersion No. of the Sample-Drawing Procedure QVERSNPRZVCHAR6QPRVKALPHAQVERSNR
PNPOSItem Number in Sample-Drawing Procedure QZAEHLPRZVNUMC4NUM4
GEBEHLot Container QGEBEHUNIT3T006CUNITMEINS
TPBISHighest Partial Sample No. Valid for Instruction QPROBNRBISNUMC3QPROBEPL
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
ABORTStorage Location for a Physical Sample QAUFBEWORTCHAR12TQ41QAUFBEWORT
ABDAUStorage Duration of the Physical Sample in Days QAUFBDAUERDEC5DEC5
ABDATStorage Deadline for Physical Sample QAUFBDATUMDATS8DATUM
ABINFStorage Information for the Physical Sample QAUFBINFOCHAR80TEXT80
AENNALast User who Changed the Physical-Sample Record QPRS_AENCHAR12QAENDERER
AENDTDate the Physical Sample Was Changed QPRS_AENDTDATS8DATUM
AENZTTime at Which Physical-Sample Record Changed QPRS_AENZTTIMS6QZEIT
VENUMInternal Handling Unit Number VENUMCHAR10Assigned to domainALPHAVENUMVEL
VEPOSHandling Unit Item VEPOSNUMC6Assigned to domainVEPOS
ADDON_DUMMYDummy Field for ADDON Structures in QM QDUMMYCHAR1QDUMMY
.INCLU--AP 0
PRIMPACKPrimary Packaging (Stability Study) QPRIMPACKCHAR8TQ45QPRIMPACK
STABICONStorage Condition QSTABICONCHAR8TQ43QSTABICON
EINGDTDate of Receipt of Initial Sample for Stability Study QST_EINGDTDATS8DATUM
EINLDTStorage Date of Sample for Storage Condition QST_EINLDTDATS8DATUM
AUSLDTDate of Removal from Storage of Sample for Storage Condition QST_AUSLDTDATS8DATUM
ENTORTLocation of Sample Drawing (Functional Location) QPRSENTORTCHAR30Assigned to domainTPLNRTPLNRIFLM
INFEORTDescription of Sample-Drawing Location QPRSINFEORTCHAR60CHAR60
ENTDATUMDate of Sample Drawing QPRSENTDATUMDATS8DATUM
ENTZEITTime of Sample Drawing QPRSENTZEITTIMS6QZEIT
BEARBEITERProcessor Responsible for the Sample, Sample Taker QPRSBEARBEITERCHAR20CHAR20
LABORWork Center (Laboratory) QLABORCHAR8QPLEXT_PRPLATZ
PLOSCurrent or Last Inspection Lot for the Sample QLOT_LATENUMC12Assigned to domainQPLOSQALS
ANLDTCreation Date of Physical Sample QPRS_ANLDTDATS8DATUM

Key field Non-key field



How do I retrieve data from SAP structure QPRSA using ABAP code?

As QPRSA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on QPRSA as there is no data to select.

How to access SAP table QPRSA

Within an ECC or HANA version of SAP you can also view further information about QPRSA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!