| 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 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | JHTVAABK | ABS_VTNR | Allow NULL? |
| 3 | ABRGNR | IS-M/AM: Contract Settlement Number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | JHTVAABK | ABRGNR | Allow NULL? |
| 4 | REGULIERER | IS-M: Payer | nvarchar | 10 | 0 | CHAR | (N' ') | No | JJVDB_MK | REGULIERER | Allow NULL? |
| 5 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | CHAR | (N' ') | No | JJVDB_MK_FK | INSERENT | Allow NULL? |
| 6 | TRENNUNG | IS-M/AM: Split Criteria for Payer/Advertiser Records | nvarchar | 10 | 0 | CHAR | (N' ') | No | | JH_TRENNUNG | Allow NULL? |
| 7 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVKO | VKORG | Allow NULL? |
| 8 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVTW | VTWEG | Allow NULL? |
| 9 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | No | TSPA | SPART | Allow NULL? |
| 10 | ABS_TYP | IS-M/AM: Contract Category | char | 1 | 0 | CHAR | (N' ') | Yes | TJH11 | ABS_TYP | Allow NULL? |
| 11 | ABINHNR | IS-M/AM: Number of Contract Holder | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JGTGPNR | ABINHNR | Allow NULL? |
| 12 | AB_BRUTTO | IS-M: Contract Gross | decimal | 15 | 2 | CURR | ((0)) | Yes | | AB_BRUTTO | |
| 13 | AB_WEINH | IS-M: Currency Key for Contract | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | AB_WEINH | Allow NULL? |
| 14 | ABRMM | IS-M: Quantity (mm, Pages, Seconds) | decimal | 12 | 3 | QUAN | ((0)) | Yes | | ABRMM | |
| 15 | ABRME | IS-M: Number | decimal | 5 | 0 | DEC | ((0)) | Yes | | ABRME | |
| 16 | EINH1 | IS-M: Contract Units of Measurement | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | AB_MEINH | Allow NULL? |
| 17 | EINH2 | IS-M: Contract Units of Measurement | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | AB_MEINH | Allow NULL? |
| 18 | PR_BASIS | IS-M: Basis for scale access (number/quantity) | char | 1 | 0 | CHAR | (N' ') | Yes | | PR_BASIS | Allow NULL? |
| 19 | ABRECHK | IS-M: Settlement Type | char | 1 | 0 | CHAR | (N' ') | Yes | TJH15 | ABRECHK | Allow NULL? |
| 20 | ABR_STATUS | IS-M: Contract Settlement Status | char | 1 | 0 | CHAR | (N' ') | Yes | | ABR_STATUS | Allow NULL? |
| 21 | STORNOGRD | IS-M: Cancellation Reason | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TJHSTOG | STOGRD_PAM | Allow NULL? |
| 22 | FAKSP | Block | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVFS | FAKSP | Allow NULL? |
| 23 | DATEAAFS | IS-M/AM: Billing Block Date for Contract Settlement | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATEAAFS | Allow NULL? |
| 24 | RAB_IST | IS-M: Contract Discount Granted to Date | decimal | 13 | 2 | CURR | ((0)) | Yes | | RAB_IST | |
| 25 | RAB_SOLL | IS-M: Current Contract Discount | decimal | 13 | 2 | CURR | ((0)) | Yes | | RAB_SOLL | |
| 26 | BON_IST | IS-M: Contract Bonus Granted to Date | decimal | 13 | 2 | CURR | ((0)) | Yes | | BON_IST | |
| 27 | BON_SOLL | IS-M/AM: Current Contract Bonus | decimal | 13 | 2 | CURR | ((0)) | Yes | | BON_SOLL | |
| 28 | ABETR_IST | IS-M: Contract Settlement Amount Paid to Date | decimal | 15 | 2 | CURR | ((0)) | Yes | | ABETR_IST | |
| 29 | ABETR_SOLL | IS-M: Current Contract Settlement Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | ABETR_SOLL | |
| 30 | GL_BETRAG | IS-M: Credit/Debit Memo Amount for Contract Settlement | decimal | 15 | 2 | CURR | ((0)) | Yes | | GL_BETRAG | |
| 31 | SFKRBMO | Total sales vol.all acc.assignments qualifying for discount | decimal | 15 | 2 | CURR | ((0)) | Yes | | SRBMO | |
| 32 | SFKRBMM | IS-M: Total qty all acc.assignments qualifying for discount | decimal | 12 | 3 | QUAN | ((0)) | Yes | | SRBMM | |
| 33 | SFKRBME | IS-M: Total No.All Acc.Assignments Qualifying for Discount | decimal | 5 | 0 | DEC | ((0)) | Yes | | SRBME | |
| 34 | SFKBOMO | IS-M: Total sales vol.all accept.assignments qual.for bonus | decimal | 15 | 2 | CURR | ((0)) | Yes | | SBOMO | |
| 35 | SFKBOMM | IS-M: Total quantity of all accpt.assignments qual.for bonus | decimal | 12 | 3 | QUAN | ((0)) | Yes | | SBOMM | |
| 36 | SFKBOME | IS-M: Total Number All Acc.Assignments Qualifying for Bonus | decimal | 5 | 0 | DEC | ((0)) | Yes | | SBOME | |
| 37 | JHABRDAT | IS-M: Contract Settlement Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | JHABRDAT | Allow NULL? |
| 38 | AAB_BEARB | IS-M: Contract Settlement Processed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | USR02 | AAB_BEARB | Allow NULL? |
