| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | PHYNR | Physical Sample Number | nvarchar | 12 | 0 | CHAR | (N' ') | No | | QPHYSPRNR | Allow NULL? |
| 3 | OBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | ONR00 | J_OBJNR | Allow NULL? |
| 4 | STSMA | Status Profile for Physical Samples | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TJ20 | QSTSMA_PRS | Allow NULL? |
| 5 | PRART | Physical-Sample Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TQ40 | QPRART | Allow NULL? |
| 6 | PRTYP | Sample Category | char | 1 | 0 | CHAR | (N' ') | Yes | TQ44 | QPRTYP | Allow NULL? |
| 7 | PN_NR | Sample-Drawing Number | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | QPRN | QPZNR | Allow NULL? |
| 8 | XMANU | Manually Created Sample | char | 1 | 0 | CHAR | (N' ') | Yes | | QPRB_MAN | Allow NULL? |
| 9 | GBTYP | Physical-Sample Container | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TQ42 | QGEBINDET | Allow NULL? |
| 10 | MENGE | Size of the Physical Sample | decimal | 13 | 3 | QUAN | ((0)) | Yes | | QPHYSPRUM | |
| 11 | MEINH | Unit of Measure for Physical Sample Size | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | QPHYSPRME | Allow NULL? |
| 12 | PLOS2 | Current or Last Inspection Lot for the Sample | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | QALS | QLOT_LATE | Allow NULL? |
| 13 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 14 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 15 | REVLV | Revision Level | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | REVLV | Allow NULL? |
| 16 | CHARG | Batch Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | MCH1 | CHARG_D | Allow NULL? |
| 17 | KTEXT | Short Text for Physical Sample | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | QTEXT_PRS | Allow NULL? |
| 18 | QAUTH | Material Authorization Group for Activities in QM | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TQ01B | QMATAUTH | Allow NULL? |
| 19 | PNVER | Sample-Drawing Procedure | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | QPRVK | QPRZIEHVER | Allow NULL? |
| 20 | PNVEV | Version No. of the Sample-Drawing Procedure | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | QPRVK | QVERSNPRZV | Allow NULL? |
| 21 | PNPOS | Item Number in Sample-Drawing Procedure | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | QZAEHLPRZV | Allow NULL? |
| 22 | GEBEH | Lot Container | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | QGEBEH | Allow NULL? |
| 23 | TPBIS | Highest Partial Sample No. Valid for Instruction | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | QPROBNRBIS | Allow NULL? |
| 24 | LGORT | Storage Location | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001L | LGORT_D | Allow NULL? |
| 25 | ABORT | Storage Location for a Physical Sample | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | TQ41 | QAUFBEWORT | Allow NULL? |
| 26 | ABDAU | Storage Duration of the Physical Sample in Days | decimal | 5 | 0 | DEC | ((0)) | Yes | | QAUFBDAUER | |
| 27 | ABDAT | Storage Deadline for Physical Sample | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | QAUFBDATUM | Allow NULL? |
| 28 | ABINF | Storage Information for the Physical Sample | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | QAUFBINFO | Allow NULL? |
| 29 | AENNA | Last User who Changed the Physical-Sample Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | QPRS_AEN | Allow NULL? |
| 30 | AENDT | Date the Physical Sample Was Changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | QPRS_AENDT | Allow NULL? |
| 31 | AENZT | Time at Which Physical-Sample Record Changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | QPRS_AENZT | Allow NULL? |
| 32 | VENUM | Internal Handling Unit Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VENUM | Allow NULL? |
| 33 | VEPOS | Handling Unit Item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | VEPOS | Allow NULL? |
| 34 | ADDON_DUMMY | Dummy Field for ADDON Structures in QM | char | 1 | 0 | CHAR | (N' ') | Yes | | QDUMMY | Allow NULL? |
| 35 | PRIMPACK | Primary Packaging (Stability Study) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TQ45 | QPRIMPACK | Allow NULL? |
| 36 | STABICON | Storage Condition | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TQ43 | QSTABICON | Allow NULL? |
| 37 | EINGDT | Date of Receipt of Initial Sample for Stability Study | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | QST_EINGDT | Allow NULL? |
| 38 | EINLDT | Storage Date of Sample for Storage Condition | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | QST_EINLDT | Allow NULL? |
| 39 | AUSLDT | Date of Removal from Storage of Sample for Storage Condition | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | QST_AUSLDT | Allow NULL? |
| 40 | ENTORT | Location of Sample Drawing (Functional Location) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | QPRSENTORT | Allow NULL? |
| 41 | INFEORT | Description of Sample-Drawing Location | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | QPRSINFEORT | Allow NULL? |
| 42 | ENTDATUM | Date of Sample Drawing | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | QPRSENTDATUM | Allow NULL? |
| 43 | ENTZEIT | Time of Sample Drawing | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | QPRSENTZEIT | Allow NULL? |
| 44 | BEARBEITER | Processor Responsible for the Sample, Sample Taker | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | QPRSBEARBEITER | Allow NULL? |
| 45 | LABOR | Work Center (Laboratory) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | QLABOR | Allow NULL? |
