| 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 | WERK | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 3 | LOS | Retention Period for QM Transaction Data on Level 1 | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | QRESQALS | Allow NULL? |
| 4 | VORGMK | Retention Period for QM Transaction Data in Level 2 | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | QRESVOMK | Allow NULL? |
| 5 | PROBEN | Retention Period for QM Transaction Data on Level 3 | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | QRESPROBEN | Allow NULL? |
| 6 | DETERG | Retention Period for QM Transaction Data on Level 4 | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | QRESDETEE | Allow NULL? |
| 7 | STPRFMK | Retention Period for Archiving Master Insp. Characs | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | QRESQPMK | Allow NULL? |
| 8 | PMETHODEN | Retention Period for Archiving Inspection Methods | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | QRESQMTB | Allow NULL? |
| 9 | ARCHIV | Retention Period for Transaction Data in Quality Inspection | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | QRESARCH | Allow NULL? |
| 10 | QLAGE | Expiry Period of Q-Level in Days | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | QRESQDQL | Allow NULL? |
| 11 | QLAGECHARGE | Expiry Date of Quality Level (with Batch) in Days | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | QRESQDQLCH | Allow NULL? |