| 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 | PRUEFLOS | Inspection Lot Number | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | QALS | QPLOS | Allow NULL? |
| 3 | VORGLFNR | Current Node Number from Order Counter APLZL | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | QLFNKN | Allow NULL? |
| 4 | PROBENR | Sample Number (Based on an Inspection Point) | nvarchar | 6 | 0 | NUMC | (N'000000') | No | QASV | QPROBENRPP | Allow NULL? |
| 5 | TEILLOS | Partial lot number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | QALT | QTLOS | Allow NULL? |
| 6 | PPSORTKEY | Key Field (Sort Field) for Inspection Point | nvarchar | 70 | 0 | CHAR | (N' ') | No | | QPPSORTKEY | Allow NULL? |
| 7 | MENGE | Inspection Point Yield | decimal | 13 | 3 | QUAN | ((0)) | No | | QMENGEPP | |
| 8 | MENGE_A | Scrap for Inspection Point | decimal | 13 | 3 | QUAN | ((0)) | No | | QMENGEPPA | |
| 9 | MENGE_N | Rework Quantity for The Inspection Point | decimal | 13 | 3 | QUAN | ((0)) | Yes | | QMENGEPPN | |
| 10 | MENGENEINH | Unit of Measure for the Inspection Point | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | QPPMEINH | Allow NULL? |
| 11 | EQUNR | Equipment Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | EQUI | EQUNR | Allow NULL? |
| 12 | EQUNRAKT | Field Active | char | 1 | 0 | CHAR | (N' ') | Yes | | QKZUSRAKT | Allow NULL? |
| 13 | TPLNR | Functional Location | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | IFLOT | TPLNR | Allow NULL? |
| 14 | TPLNRAKT | Field Active | char | 1 | 0 | CHAR | (N' ') | Yes | | QKZUSRAKT | Allow NULL? |
| 15 | PHYNR | Physical Sample Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | QPRS | QPHYSPRNR | Allow NULL? |
| 16 | PHYNRAKT | Field Active | char | 1 | 0 | CHAR | (N' ') | Yes | | QKZUSRAKT | Allow NULL? |
| 17 | USERC1 | User Field for 18 Characters | nvarchar | 18 | 0 | CHAR | (N' ') | No | | QUSRCHAR18 | Allow NULL? |
| 18 | USERC1AKT | Field Active | char | 1 | 0 | CHAR | (N' ') | No | | QKZUSRAKT | Allow NULL? |
| 19 | USERC2 | User Field for 10 Characters | nvarchar | 10 | 0 | CHAR | (N' ') | No | | QUSRCHAR10 | Allow NULL? |
| 20 | USERC2AKT | Field Active | char | 1 | 0 | CHAR | (N' ') | No | | QKZUSRAKT | Allow NULL? |
| 21 | USERN1 | User Field for 10 Digits | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | QUSRNUMC10 | Allow NULL? |
| 22 | USERN1AKT | Field Active | char | 1 | 0 | CHAR | (N' ') | No | | QKZUSRAKT | Allow NULL? |
| 23 | USERN2 | User Field for 3 Digits | nvarchar | 3 | 0 | NUMC | (N'000') | No | | QUSRNUMC3 | Allow NULL? |
| 24 | USERN2AKT | Field Active | char | 1 | 0 | CHAR | (N' ') | No | | QKZUSRAKT | Allow NULL? |
| 25 | USERD1 | User Field for Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | QUSRDATS | Allow NULL? |
| 26 | USERD1AKT | Field Active | char | 1 | 0 | CHAR | (N' ') | No | | QKZUSRAKT | Allow NULL? |
| 27 | USERT1 | User Field for Time | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | QUSRTIMS | Allow NULL? |
| 28 | USERT1AKT | Field Active | char | 1 | 0 | CHAR | (N' ') | No | | QKZUSRAKT | Allow NULL? |
| 29 | VKATART | Catalog | char | 1 | 0 | CHAR | (N' ') | No | TQ15 | QKATART | Allow NULL? |
| 30 | VWERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 31 | VAUSWAHLMG | Selected Set of the Usage Decision | nvarchar | 8 | 0 | CHAR | (N' ') | No | QPAM | QVMENGE | Allow NULL? |
| 32 | VCODEGRP | Code Group of the Usage Decision | nvarchar | 8 | 0 | CHAR | (N' ') | No | QPGR | QVGRUPPE | Allow NULL? |
| 33 | VCODE | Usage Decision Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | QPCD | QVCODE | Allow NULL? |
| 34 | VBEWERTUNG | Code Valuation | char | 1 | 0 | CHAR | (N' ') | No | | QBEWERTUNG | Allow NULL? |
| 35 | KZBEWERT | Valuation Status Inspection Point | char | 1 | 0 | CHAR | (N' ') | No | | QPPBEWERT | Allow NULL? |
| 36 | KZFERTIG | Inspection Point Status | char | 1 | 0 | CHAR | (N' ') | No | | QPPFERTIG | Allow NULL? |
| 37 | KZPTLBEST | Inspection with Stock-Related Partial Lot Assignment | char | 1 | 0 | CHAR | (N' ') | No | | QKZPTLBEST | Allow NULL? |
| 38 | RUECK | Completion confirmation number for the operation | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | CO_RUECK | Allow NULL? |
| 39 | RMZHL | Confirmation counter | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | CO_RMZHL | Allow NULL? |
| 40 | MBLNR | Number of Material Document | nvarchar | 10 | 0 | CHAR | (N' ') | No | | MBLNR | Allow NULL? |
| 41 | MJAHR | Material Document Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | MJAHR | Allow NULL? |
| 42 | ZEILE | Item in Material Document | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | MBLPO | Allow NULL? |
| 43 | PRUEFER | Name of the Inspector | nvarchar | 12 | 0 | CHAR | (N' ') | No | | QPRUEFER | Allow NULL? |
| 44 | ENTSTEHDAT | Date of Inspection Point Creation | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | QENTDATPP | Allow NULL? |
| 45 | ENTSTEHZT | Time of Inspection Point Creation | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | QENTZEITPP | Allow NULL? |
| 46 | ERSTELLER | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | No | | ERNAM | Allow NULL? |
| 47 | ERSTELDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ERDAT | Allow NULL? |
| 48 | ERSTELZEIT | Time at which data record was created | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | QZEITERSTL | Allow NULL? |
| 49 | AENDERER | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | No | | AENAM | Allow NULL? |
| 50 | AENDERDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | AEDAT | Allow NULL? |
| 51 | AENDERZEIT | Time at which data record was last changed | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | QZEITAEND | Allow NULL? |
