| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | VTNR | IS-M: Contract Number for Media-Mix Contract | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | MXART | IS-M: Type of Media-Mix Contract Creation | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | PAKNR | IS-M: Number of a media-mix package | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | KAUSSCHL | IS-M: Condition Exclusion Rule for Media-Mix Contract | char | 1 | 0 | | | | Allow NULL? |
| 6 | ERFREGEL | IS-M: Fulfillment Rule for Media-Mix Contract | char | 1 | 0 | | | | Allow NULL? |
| 7 | BESTIMMTER | IS-M: Contract Number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 8 | MENGE1 | IS-M/AM: Target Number in the Contract | decimal | 5 | 0 | | | | |
| 9 | EINH1 | IS-M/AM: Unit for Target Number in Contract | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | MENGE2 | IS-M/AM: Target Quantity in the Contract | decimal | 12 | 3 | | | | |
| 11 | EINH2 | IS-M/AM: Unit for Target Quantity in the Contract | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | UMSATZ | IS-M/AM: Target Quantity for Monetary Contract | decimal | 15 | 2 | | | | |
| 13 | WEINH | IS-M: Currency Key for Contract | nvarchar | 5 | 0 | | | | Allow NULL? |
| 14 | ABRSTATUS | IS-M: Settlement Status of a Contract | char | 1 | 0 | | | | Allow NULL? |
| 15 | AUFSTATUS | IS-M: Explode Status of a Media-Mix COA | char | 1 | 0 | | | | Allow NULL? |
| 16 | ERFUSER | Created By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 17 | ERFDATE | Created On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | ERFTIME | Time Created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 19 | AENUSER | Last Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 20 | AENDATE | Date of Last Change | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | AENTIME | Time of Last Change | nvarchar | 6 | 0 | | | | Allow NULL? |
| 22 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | char | 1 | 0 | | | | Allow NULL? |
| 23 | VKORG | Sales Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 24 | ABSTYP | IS-M/AM: Contract Category | char | 1 | 0 | | | | Allow NULL? |
| 25 | ABSART | IS-M: Contract Type | char | 1 | 0 | | | | Allow NULL? |
| 26 | RABANP | IS-M: Disc./Price Adjustment During Contract Validity Period | char | 1 | 0 | | | | Allow NULL? |
| 27 | LFZBEG | IS-M: Start of Validity Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | LFZEND | IS-M: End of Validity Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | ABRGNR | IS-M/AM: Contract Settlement Number | nvarchar | 4 | 0 | | | | Allow NULL? |
