| 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 | MATNR | IS-M: Material number of promotional material | nvarchar | 18 | 0 | CHAR | (N' ') | No | | MATNR_ISP | Allow NULL? |
| 3 | LIEFERANT | IS-M: Business Partner Key | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JGTGPNR | GPNR | Allow NULL? |
| 4 | LIEFMATNR | Material Number Used by Vendor | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | IDNLF | Allow NULL? |
| 5 | EINSTPRS | IS-M: Cost Price for Materials | decimal | 11 | 2 | CURR | ((0)) | Yes | | EINSTPRS | |
| 6 | EINSTPRSZK | IS-M: Future Cost Price for Materials | decimal | 11 | 2 | CURR | ((0)) | Yes | | EINSTPRSZK | |
| 7 | EINSTMWSKZ | Tax Code for Purchase of Promotional Material | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T007A | EINSTMWSKZ | Allow NULL? |
| 8 | DATEPRSZK | IS-M: Start of Validity of Future Cost Price | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATEPRSZK | Allow NULL? |
| 9 | WAEHRUNG | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 10 | VERSANDKNZ | IS-M: Shipping indicator (publisher or supplier) | char | 1 | 0 | CHAR | (N' ') | Yes | | VERSANDKNZ | Allow NULL? |
| 11 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 12 | WARENGRP | Material Group | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | T023 | MATKL | Allow NULL? |
| 13 | LOEVM | Deletion Flag for Master Data in Media Sales & Distribution | char | 1 | 0 | CHAR | (N' ') | Yes | | LOEVM_ISP | Allow NULL? |
| 14 | LOEKZ | Deletion Indicator for Master Data in Media Sales & Dist. | char | 1 | 0 | CHAR | (N' ') | Yes | | LOEKZ_ISP | Allow NULL? |
| 15 | XMATVERGRF | IS-M: Material out of stock | char | 1 | 0 | CHAR | (N' ') | Yes | | XMATVERGRF | Allow NULL? |
| 16 | KURZTEXT | IS-M: Short Text | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | BEZEICHN15 | Allow NULL? |
| 17 | LANGTEXT | IS-M: Long Text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | BEZEICHN50 | Allow NULL? |
| 18 | ERFUSER | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERFUSER | Allow NULL? |
| 19 | ERFDATE | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERFDATE | Allow NULL? |
| 20 | ERFTIME | Time Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERFTIME | Allow NULL? |
| 21 | AENUSER | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENUSER | Allow NULL? |
| 22 | AENDATE | Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AENDATE | Allow NULL? |
| 23 | AENTIME | Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AENTIME | Allow NULL? |
