| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | USERID | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | GUID | | varbinary | 16 | 0 | | | | |
| 4 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 5 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | | | Allow NULL? |
| 6 | ADDIBELNR | Document number for additional | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | ADDIPOSNR | Item number of an additional | nvarchar | 6 | 0 | | | | Allow NULL? |
| 8 | ADDIMAT | Material number for additional | nvarchar | 18 | 0 | | | | Allow NULL? |
| 9 | DATECR | Date of Additionals Document Creation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | ADDIIDOCD | Current Condition Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | ADDIFM | Procedure for additionals | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | ADDILIFNR | Additionals vendor | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | ADDIKSCHL | Additionals: Message type for deliveries | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | ADDIEBELN | Additionals: Document number for purchasing document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | KSCHLIDOC | Condition type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | KBETRIDOC | Old Condition Value | decimal | 11 | 2 | | | | |
| 17 | WAERSIDOC | Old Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 18 | NEWKBETR | New Condition Value | decimal | 11 | 2 | | | | |
| 19 | NEWWAERS | New Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 20 | ADDIRDID | Purchase Order Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | GUID_ALV | | varbinary | 16 | 0 | | | | |
| 22 | CREATE_IDOC_DAT | Date of IDoc Generation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | IDOC_PRICE_DAT | Condition Date of IDoc | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | CHANGE_PRICE_DAT | Flag: Date on Which Price Is Determined Has Changed | char | 1 | 0 | | | | Allow NULL? |
| 25 | ADDIMAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | | | Allow NULL? |
| 26 | ADDISTUNR | Additionals: step number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 27 | LFDNR | Key for transaction data for additionals | nvarchar | 4 | 0 | | | | Allow NULL? |
| 28 | CHECKSUM | Hash Value (160 Bits) | nvarchar | 40 | 0 | | | | Allow NULL? |
| 29 | CONDCHECKSUMIDOC | Hash Value (160 Bits) | nvarchar | 40 | 0 | | | | Allow NULL? |
| 30 | ADDIVKME | Sales unit of the material | nvarchar | 3 | 0 | | | | Allow NULL? |
| 31 | ADDIWERKS | Additionals: Plant to which the reference document belongs | nvarchar | 4 | 0 | | | | Allow NULL? |
| 32 | ADDIKUNNR | Additionals: Customer to whom the reference document belongs | nvarchar | 10 | 0 | | | | Allow NULL? |
| 33 | ADDIMATKL | Material group for an additional | nvarchar | 9 | 0 | | | | Allow NULL? |
| 34 | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 35 | CHANGED_BY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
