| 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 | nvarchar | 6 | 0 | | | | Allow NULL? |
| 3 | VKORG | Sales Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | SPART | Division | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | VKBUR | Sales Office | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | VKGRP | Sales Group | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | XORG_ERG | IS-M: Contract has Explicitly Assigned Sales Areas | char | 1 | 0 | | | | Allow NULL? |
| 9 | ABINHNR | IS-M/AM: Number of Contract Holder | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | IHREZ | Your Reference | nvarchar | 12 | 0 | | | | Allow NULL? |
| 11 | KDMI | IS-M: Contact Person for Contract Holder | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | XQUASI | IS-M: System Contracts Yes/No Indicator | char | 1 | 0 | | | | Allow NULL? |
| 13 | XGE_GESCH | IS-M: Barter Deal Indicator | char | 1 | 0 | | | | Allow NULL? |
| 14 | XKUBO | IS-M: Indicator Customer Bonus Contract | char | 1 | 0 | | | | Allow NULL? |
| 15 | XTO_BEST | IS-M: "Confirnation Required" Indicator | char | 1 | 0 | | | | Allow NULL? |
| 16 | XTO_WARN | IS-M: Advance Warning Indicator | char | 1 | 0 | | | | Allow NULL? |
| 17 | XWARN_GEN | IS-M: Generate non-fulfillment warning | char | 1 | 0 | | | | Allow NULL? |
| 18 | XTO_HINW | IS-M: Generate end note indicator | char | 1 | 0 | | | | Allow NULL? |
| 19 | XHINW_GEN | IS-M: Generate validity period end note indicator | char | 1 | 0 | | | | Allow NULL? |
| 20 | XBESTK | IS-M: Contract Status (Created/Confirmed) | char | 1 | 0 | | | | Allow NULL? |
| 21 | B_DATUM | IS-M: Confirmation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | XNEUSTAT | IS-M: Renewal status (renewed y/n) | char | 1 | 0 | | | | Allow NULL? |
| 23 | E_DATUM | IS-M: Contract Renewal Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | V_NUMMER | IS-M: Current Number of Advance Warning | char | 1 | 0 | | | | Allow NULL? |
| 25 | V_DATUM | IS-M: Advance Warning Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | XENDK | IS-M: Status of runtime end note | char | 1 | 0 | | | | Allow NULL? |
| 27 | H_DATUM | IS-M: Date of End of Validity Period Note (Contract) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | XABRSPERR | IS-M: Settlement Block | char | 1 | 0 | | | | Allow NULL? |
| 29 | ABRECHK | IS-M: Settlement Type | char | 1 | 0 | | | | Allow NULL? |
| 30 | XABR | IS-M: Perform Settlement Yes/No Indicator | char | 1 | 0 | | | | Allow NULL? |
| 31 | R_DATUM | IS-M: Date of Last Interim/Final Settlement | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | ABRGNR | IS-M/AM: Contract Settlement Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 33 | EABR_NACHL | IS-M: Time of Final Settlement After Runtime (in Months) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 34 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | char | 1 | 0 | | | | Allow NULL? |
| 35 | XLOEKZ | Deletion Indicator for Master Data in Media Sales & Dist. | char | 1 | 0 | | | | Allow NULL? |
| 36 | XLFZAEN | IS-M: Validity Period in Contract Changed | char | 1 | 0 | | | | Allow NULL? |
| 37 | LFZBEG | IS-M: Start of Validity Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 38 | LFZEND | IS-M: End of Validity Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 39 | B_AUSR | IS-M: Rule for Contract Start | char | 1 | 0 | | | | Allow NULL? |
| 40 | E_AUSR | IS-M: Rule for Contract End | char | 1 | 0 | | | | Allow NULL? |
| 41 | XABE | IS-M: Automatic Contract Renewal? | char | 1 | 0 | | | | Allow NULL? |
| 42 | FVTNR | IS-M: Number of Follow-On Contract | nvarchar | 6 | 0 | | | | Allow NULL? |
| 43 | VVTNR | IS-M: Predecessor to Current Contract | nvarchar | 6 | 0 | | | | Allow NULL? |
| 44 | XNOBEL | IS-M: Do Not Perform Subsequent Debit | char | 1 | 0 | | | | Allow NULL? |
| 45 | XZWABR | IS-M: Perform Interim Settlement Automatically | char | 1 | 0 | | | | Allow NULL? |
| 46 | XBEARB | IS-M: Postprocess/Approve Contract | char | 1 | 0 | | | | Allow NULL? |
| 47 | ABS_NACHB | IS-M: Post-Editing Reason | nvarchar | 73 | 0 | | | | Allow NULL? |
| 48 | XKONZERN | IS-M: Group Contract | char | 1 | 0 | | | | Allow NULL? |
| 49 | XINSKUM | IS-M: Cumulation Rule for Contract Assignments | char | 1 | 0 | | | | Allow NULL? |
| 50 | ABS_TYP1 | IS-M/AM: Contract Category | char | 1 | 0 | | | | Allow NULL? |
| 51 | XBEST_PR | IS-M: Apply Best Conditions to Number / Quantity | char | 1 | 0 | | | | Allow NULL? |
| 52 | XPOSAEN | IS-M: "Contract Item Changed" Indicator | char | 1 | 0 | | | | Allow NULL? |
| 53 | XZIELAEN | IS-M: "Target Quantities in COA Changed" Indicator | char | 1 | 0 | | | | Allow NULL? |
| 54 | PR_BASIS | IS-M: Basis for scale access (number/quantity) | char | 1 | 0 | | | | Allow NULL? |
| 55 | MENGE1 | IS-M/AM: Agreed Quantity to be Sold | decimal | 12 | 3 | | | | |
| 56 | EINH1 | IS-M: Contract Units of Measurement | nvarchar | 3 | 0 | | | | Allow NULL? |
| 57 | AB_ZIEL1 | IS-M/AM: Target Quantity for Monetary Contract | decimal | 15 | 2 | | | | |
| 58 | AB_WEINH | IS-M: Currency Key for Contract | nvarchar | 5 | 0 | | | | Allow NULL? |
| 59 | RKSCHL | Condition Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 60 | BKSCHL | Condition Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 61 | MENGE2 | IS-M/AM: Agreed Quantity to be Sold | decimal | 12 | 3 | | | | |
| 62 | EINH2 | IS-M: Contract Units of Measurement | nvarchar | 3 | 0 | | | | Allow NULL? |
| 63 | MEINH | IS-M: Contract Units of Measurement | nvarchar | 3 | 0 | | | | Allow NULL? |
| 64 | ORIG_MENG1 | IS-M/AM: Agreed Quantity to be Sold | decimal | 12 | 3 | | | | |
| 65 | ORIG_MENG2 | IS-M/AM: Agreed Quantity to be Sold | decimal | 12 | 3 | | | | |
| 66 | ORIG_ZIEL1 | IS-M/AM: Target Quantity for Monetary Contract | decimal | 15 | 2 | | | | |
| 67 | XAB_PREIS | IS-M/AM: Basic Price from Contract Indicator | char | 1 | 0 | | | | Allow NULL? |
| 68 | XAB_PRLST | IS-M: Do not Overfulfill Contract Indicator | char | 1 | 0 | | | | Allow NULL? |
| 69 | AB_PREIS | IS-M: Current Valid Price from Contract | decimal | 15 | 2 | | | | |
| 70 | AB_KPREIS | IS-M: Price from Scale | decimal | 15 | 2 | | | | |
| 71 | AB_VPREIS | IS-M: Agreed Price from Contract | decimal | 15 | 2 | | | | |
| 72 | FMP_KPEIN | Condition pricing unit | decimal | 5 | 0 | | | | |
| 73 | FMP_KMEIN | Condition unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 74 | RKNUMV | IS-M: Discount from Scale | decimal | 5 | 2 | | | | |
| 75 | RABATT | IS-M: Current Valid Contract Discount Rate | decimal | 5 | 2 | | | | |
| 76 | VRABATT | IS-M: Agreed Discount | decimal | 5 | 2 | | | | |
| 77 | XRABAEN | IS-M/AM: Discount Changed Manually | char | 1 | 0 | | | | Allow NULL? |
| 78 | XRAB_CH | IS-M: Current discount change | char | 1 | 0 | | | | Allow NULL? |
| 79 | XRABA | IS-M/AM: Indicator: Adjust Discount During Contract Period? | char | 1 | 0 | | | | Allow NULL? |
| 80 | XERFUELLT | IS-M/AM: Contract Fulfilled Yes/No Indicator | char | 1 | 0 | | | | Allow NULL? |
| 81 | XRABAN | IS-M: Next discount level characteristic reached | char | 1 | 0 | | | | Allow NULL? |
| 82 | XRABAZW | IS-M/AM: Discount change with next interim settlement | char | 1 | 0 | | | | Allow NULL? |
| 83 | XRABSPERR | IS-M: Block higher-level discounts indicator | char | 1 | 0 | | | | Allow NULL? |
| 84 | XBRUTTO | IS-M: Gross Contract Characteristic | char | 1 | 0 | | | | Allow NULL? |
| 85 | BKNUMV | IS-M/AM: Bonus from Scale | decimal | 5 | 2 | | | | |
| 86 | XVBONUS | IS-M: Advance Bonus Indicator | char | 1 | 0 | | | | Allow NULL? |
| 87 | AKTBONUS | IS-M/AM: Current Valid Contract Bonus | decimal | 5 | 2 | | | | |
| 88 | VBONUS | IS-M: Agreed Bonus | decimal | 5 | 2 | | | | |
| 89 | XGUTSCHR | IS-M: Do not perform credit memo characteristic | char | 1 | 0 | | | | Allow NULL? |
| 90 | ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | | | | Allow NULL? |
| 91 | FREITEXT | IS-M: Freely Definable Text | nvarchar | 50 | 0 | | | | Allow NULL? |
| 92 | L_FKT_DAT | IS-M: Last Actual Billing Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 93 | L_AE_DAT | IS-M: Last Publication Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 94 | ABS_ZUST | IS-M: Person Responsible | nvarchar | 12 | 0 | | | | Allow NULL? |
| 95 | FRD_VTNR | IS-M: Externally Assigned Contract Number | nvarchar | 15 | 0 | | | | Allow NULL? |
| 96 | MM_VTNR | IS-M: Contract Number for Media-Mix Contract | nvarchar | 10 | 0 | | | | Allow NULL? |
| 97 | KOFRS | IS-M: Scale Base Formula Provided From the Contract | nvarchar | 3 | 0 | | | | Allow NULL? |
| 98 | LEVEL_BP | IS-M/AM: Contract BW Classification for Contract Holder | char | 1 | 0 | | | | Allow NULL? |
| 99 | LEVEL_BU | IS-M/AM: Contract BW Classification for Booking Unit | char | 1 | 0 | | | | Allow NULL? |
| 100 | SAERBMO | Total sales vol.all acc.assignments qualifying for discount | decimal | 15 | 2 | | | | |
| 101 | SAERBMM | IS-M: Total qty all acc.assignments qualifying for discount | decimal | 12 | 3 | | | | |
| 102 | SAERBME | IS-M: Total No.All Acc.Assignments Qualifying for Discount | decimal | 5 | 0 | | | | |
| 103 | SAEBOMO | IS-M: Total sales vol.all accept.assignments qual.for bonus | decimal | 15 | 2 | | | | |
| 104 | SAEBOMM | IS-M: Total quantity of all accpt.assignments qual.for bonus | decimal | 12 | 3 | | | | |
| 105 | SAEBOME | IS-M: Total Number All Acc.Assignments Qualifying for Bonus | decimal | 5 | 0 | | | | |
| 106 | SAEMRNRMO | Total sales vol.all orig.acc.assignments count.towards disc. | decimal | 15 | 2 | | | | |
| 107 | SAEMRNRMM | Total qty all acc.original assignments count.towards disc. | decimal | 12 | 3 | | | | |
| 108 | SAEMRNRME | Total No.of All Acc.Original Assignments Count.Towards Disc. | decimal | 5 | 0 | | | | |
| 109 | SAEMBNBMO | Total sales vol.of all acc.orig.assignments count.twrd bonus | decimal | 15 | 2 | | | | |
| 110 | SAEMBNBMM | Total qty of all original acc.assignments counting twrd bon. | decimal | 12 | 3 | | | | |
| 111 | SAEMBNBME | Total No.of All Acc.Original Assignments Count.Twrds Bonus | decimal | 5 | 0 | | | | |
| 112 | SAERFRRMO | Total sales vol.all acc.assignments qual.for dis.frm othr BU | decimal | 15 | 2 | | | | |
| 113 | SAERFRRMM | Total qty all acc.assignments qual.for disc.from other BU | decimal | 12 | 3 | | | | |
| 114 | SAERFRRME | Total No.All Acc.Assignments Qual.for Discount From Other BU | decimal | 5 | 0 | | | | |
| 115 | SAEBFRMO | Total sales vol. all acc.assign. qual.for bonus from othr BU | decimal | 15 | 2 | | | | |
| 116 | SAEBFRMM | Total qty of all accp.assignments qual.for bonus frm othr BU | decimal | 12 | 3 | | | | |
| 117 | SAEBFRME | Total Number of Assignments Qualify.for Bonus From Other BU | decimal | 5 | 0 | | | | |
| 118 | SAEFRMO | Total sales vol.of all accepted assignments from other BU | decimal | 15 | 2 | | | | |
| 119 | SAEFRMM | IS-M: Total quantity of all accept.assignments from other BU | decimal | 12 | 3 | | | | |
| 120 | SAEFRME | IS-M: Total Number of All Accepted Assignments From Other BU | decimal | 5 | 0 | | | | |
| 121 | SAEMFRBMO | Total sales vol.all acc.assign.count.twrds bonus frm othr BU | decimal | 15 | 2 | | | | |
| 122 | SAEMFRBMM | Total qty all acc.assignmnts count.twrds bonus from other BU | decimal | 12 | 3 | | | | |
| 123 | SAEMFRBME | Total No.All Acc.Assignmnts Count.Twrds Bonus From Other BU | decimal | 5 | 0 | | | | |
| 124 | SAEVBMO | IS-M: Total sales vol.all acc.assignments from other SA | decimal | 15 | 2 | | | | |
| 125 | SAEVBMM | IS-M: Total qty all acc.assignments from other sales area | decimal | 12 | 3 | | | | |
| 126 | SAEVBME | IS-M: Total Number of All Accepted Assignments From Other SA | decimal | 5 | 0 | | | | |
| 127 | SAEMAMO | IS-M: Total sales volume of all accepted manual assignments | decimal | 15 | 2 | | | | |
| 128 | SAEMAMM | IS-M: Total quantity of all manual assignments accepted | decimal | 12 | 3 | | | | |
| 129 | SAEMAME | IS-M: Total Number of All Manual Assignments Accepted | decimal | 5 | 0 | | | | |
| 130 | SAEMRMO | Total sales vol.from all acc.assignments count.toward disc. | decimal | 15 | 2 | | | | |
| 131 | SAEMRMM | Total qty of all acc.assignments counting towards discount | decimal | 12 | 3 | | | | |
| 132 | SAEMRME | IS-M: Total No.of All Acc.Assignments Counting Towards Disc. | decimal | 5 | 0 | | | | |
| 133 | SAEMBMO | IS-M: Total sales vol.of all acc.assignments count.twd bon. | decimal | 15 | 2 | | | | |
| 134 | SAEMBMM | IS-M: Total qty of all accept.assignments counting twrd bon. | decimal | 12 | 3 | | | | |
| 135 | SAEMBME | IS-M: Total No.All Accept.Assignments Which Count Twrds Bon. | decimal | 5 | 0 | | | | |
| 136 | SFKRBMO | Total sales vol.all billed assignments qualifying for disc. | decimal | 15 | 2 | | | | |
| 137 | SFKRBMM | Total qty all billed assignments qualifying for discount | decimal | 12 | 3 | | | | |
| 138 | SFKRBME | IS-M: Total No.All Bill.Assignments Qualifying for Discount | decimal | 5 | 0 | | | | |
| 139 | SFKBOMO | Total sales vol.all billed assignments qualifying for bonus | decimal | 15 | 2 | | | | |
| 140 | SFKBOMM | Total qty of all billed assignments qualifying for bonus | decimal | 12 | 3 | | | | |
| 141 | SFKBOME | Total Number of All Billed Assignments Qualifying for Bonus | decimal | 5 | 0 | | | | |
| 142 | SFKMRNRMO | Total sales vol.all billed orig.assignments count.twrd disc. | decimal | 15 | 2 | | | | |
| 143 | SFKMRNRMM | Total qty all billed original assignments count.twrd disc. | decimal | 12 | 3 | | | | |
| 144 | SFKMRNRME | Total No.of All Billed Original Assignments Count.Twrd Disc. | decimal | 5 | 0 | | | | |
| 145 | SFKMBNBMO | Total sales vol.all bill.original assignments count.twd bon. | decimal | 15 | 2 | | | | |
| 146 | SFKMBNBMM | Total qty of all billed original assignments count.twrd bon. | decimal | 12 | 3 | | | | |
| 147 | SFKMBNBME | Total No.of All Billed Original Assignments Count.Twrd Bonus | decimal | 5 | 0 | | | | |
| 148 | SFKRFRRMO | Total sales vol.all bill.assignm.qual.for disc from other BU | decimal | 15 | 2 | | | | |
| 149 | SFKRFRRMM | Total qty all billed assignments qual.for disc.from other BU | decimal | 12 | 3 | | | | |
| 150 | SFKRFRRME | Total No.All Billed Assignments Qual.for Disc.From Other BU | decimal | 5 | 0 | | | | |
| 151 | SFKBFRMO | Total sales vol.all bill.assign.qual.for bonus from other BU | decimal | 15 | 2 | | | | |
| 152 | SFKBFRMM | Total qty all billed assignments qual.for bonus frm other BU | decimal | 12 | 3 | | | | |
| 153 | SFKBFRME | Total No.All Billed Assignments Qual.for Bonus From Other BU | decimal | 5 | 0 | | | | |
| 154 | SFKFRMO | Total sales volume of all billed assignments from other BU | decimal | 15 | 2 | | | | |
| 155 | SFKFRMM | Total quantity of all billed assignments from other BU | decimal | 12 | 3 | | | | |
| 156 | SFKFRME | Total Number of All Billed Assignments From Other BU | decimal | 5 | 0 | | | | |
| 157 | SFKMFRBMO | Total sales vol.all bill.assign.count.twrd bon.from othr BU | decimal | 15 | 2 | | | | |
| 158 | SFKMFRBMM | Total qty all billed assignments count.twrd bonus frm oth.BU | decimal | 12 | 3 | | | | |
| 159 | SFKMFRBME | Total No.of All Bill.Assignments From Othr BU Count.Twrd Bon | decimal | 5 | 0 | | | | |
| 160 | SFKVBMO | Total sales vol. from all billed assignments from other SAs | decimal | 15 | 2 | | | | |
| 161 | SFKVBMM | Total quantity all billed assignments from other SA | decimal | 12 | 3 | | | | |
| 162 | SFKVBME | Total Number of All Billed Assignments From Other SA | decimal | 5 | 0 | | | | |
| 163 | SFKMAMO | Total sales volume of all billed manual assignments | decimal | 15 | 2 | | | | |
| 164 | SFKMAMM | IS-M: Total quantity of all billed manual assignments | decimal | 12 | 3 | | | | |
| 165 | SFKMAME | IS-M: Total Number of All Billed Manual Assignments | decimal | 5 | 0 | | | | |
| 166 | SFKMRMO | Total sales vol.all billed assignments count.toward discount | decimal | 15 | 2 | | | | |
| 167 | SFKMRMM | Total quantity of all billed assignments counting twrd disc. | decimal | 12 | 3 | | | | |
| 168 | SFKMRME | Total Number of All Billed Assignments Counting Toward Disc. | decimal | 5 | 0 | | | | |
| 169 | SFKMBMO | Total sales vol.all billed assignments counting twrd bonus | decimal | 15 | 2 | | | | |
| 170 | SFKMBMM | Total quantity of all billed assignments counting twrd bon. | decimal | 12 | 3 | | | | |
| 171 | SFKMBME | Total Number of All Billed Assignments That Count Twrd Bonus | decimal | 5 | 0 | | | | |
| 172 | ERFUSER | Created By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 173 | ERFDATE | Created On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 174 | ERFTIME | Time Created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 175 | AENUSER | Last Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 176 | AENDATE | Date of Last Change | nvarchar | 8 | 0 | | | | Allow NULL? |
| 177 | AENTIME | Time of Last Change | nvarchar | 6 | 0 | | | | Allow NULL? |
