| 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 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | T024E | EKORG | Allow NULL? |
| 3 | INFNR | Number of Purchasing Info Record | nvarchar | 10 | 0 | CHAR | (N' ') | No | EINA | INFNR | Allow NULL? |
| 4 | HKRIT | Key for evaluation criterion | nvarchar | 2 | 0 | CHAR | (N' ') | No | T147G | HKRIT | Allow NULL? |
| 5 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | LIFNR | Allow NULL? |
| 6 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 7 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 8 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 9 | LEBDT | Date of last evaluation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LEBDT | Allow NULL? |
| 10 | DATUV | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATUM | Allow NULL? |
| 11 | KRT01 | Score for subcriterion 01 | decimal | 3 | 0 | DEC | ((0)) | Yes | | KRT01 | |
| 12 | KRT02 | Score for subcriterion 02 | decimal | 3 | 0 | DEC | ((0)) | Yes | | KRT02 | |
| 13 | KRT03 | Score for subcriterion 03 | decimal | 3 | 0 | DEC | ((0)) | Yes | | KRT03 | |
| 14 | KRT04 | Score for subcriterion 04 | decimal | 3 | 0 | DEC | ((0)) | Yes | | KRT04 | |
| 15 | KRT05 | Score for subcriterion 05 | decimal | 3 | 0 | DEC | ((0)) | Yes | | KRT05 | |
| 16 | KRT06 | Score for subcriterion 06 | decimal | 3 | 0 | DEC | ((0)) | Yes | | KRT06 | |
| 17 | KRT07 | Score for subcriterion 07 | decimal | 3 | 0 | DEC | ((0)) | Yes | | KRT07 | |
| 18 | KRT08 | Score for subcriterion 08 | decimal | 3 | 0 | DEC | ((0)) | Yes | | KRT08 | |
| 19 | KRT09 | Score for subcriterion 09 | decimal | 3 | 0 | DEC | ((0)) | Yes | | KRT09 | |
| 20 | KRT10 | Score for subcriterion 10 | decimal | 3 | 0 | DEC | ((0)) | Yes | | KRT10 | |
| 21 | KRT11 | Score for subcriterion 11 | decimal | 3 | 0 | DEC | ((0)) | Yes | | KRT11 | |
| 22 | KRT12 | Score for subcriterion 12 | decimal | 3 | 0 | DEC | ((0)) | Yes | | KRT12 | |
| 23 | KRT13 | Score for subcriterion 13 | decimal | 3 | 0 | DEC | ((0)) | Yes | | KRT13 | |
| 24 | KRT14 | Score for subcriterion 14 | decimal | 3 | 0 | DEC | ((0)) | Yes | | KRT14 | |
| 25 | KRT15 | Score for subcriterion 15 | decimal | 3 | 0 | DEC | ((0)) | Yes | | KRT15 | |
| 26 | KRT16 | Score for subcriterion 16 | decimal | 3 | 0 | DEC | ((0)) | Yes | | KRT16 | |
| 27 | KRT17 | Score for subcriterion 17 | decimal | 3 | 0 | DEC | ((0)) | Yes | | KRT17 | |
| 28 | KRT18 | Score for subcriterion 18 | decimal | 3 | 0 | DEC | ((0)) | Yes | | KRT18 | |
| 29 | KRT19 | Score for subcriterion 19 | decimal | 3 | 0 | DEC | ((0)) | Yes | | KRT19 | |
| 30 | KRT20 | Score for subcriterion 20 | decimal | 3 | 0 | DEC | ((0)) | Yes | | KRT20 | |
