| 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 | JHTVAARI | ABS_VTNR | Allow NULL? |
| 3 | ABRGNR | IS-M/AM: Contract Settlement Number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | JHTVAARI | ABRGNR | Allow NULL? |
| 4 | APOSNR | IS-M: Contract Settlement - Item Number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | ABRG_POSNR | Allow NULL? |
| 5 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | JHTVAARI | VKORG | Allow NULL? |
| 6 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | JHTVAARI | VTWEG | Allow NULL? |
| 7 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | JHTVAARI | SPART | Allow NULL? |
| 8 | REGULIERER | IS-M: Payer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JHTVAARI | REGULIERER | Allow NULL? |
| 9 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JHTVAARI | INSERENT | Allow NULL? |
| 10 | TRENNUNG | IS-M/AM: Split Criteria for Payer/Advertiser Records | nvarchar | 10 | 0 | CHAR | (N' ') | No | JHTVAARI | JH_TRENNUNG | Allow NULL? |
| 11 | POSNR | IS-M: Contract, Item Number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | JHTVPO | ABS_POSNR | Allow NULL? |
| 12 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JHAK | AVM_NR | Allow NULL? |
| 13 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | JHAP | POS_NR | Allow NULL? |
| 14 | GRUPPABRNR | IS-M/AM: Billing Dataset | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | JHAGA | GRUPPABRNR | Allow NULL? |
| 15 | ZW_AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | JHAK | AVM_NR | Allow NULL? |
| 16 | ZW_POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | JHAP | POS_NR | Allow NULL? |
| 17 | ZW_GRABRNR | IS-M/AM: Billing Dataset | nvarchar | 3 | 0 | NUMC | (N'000') | No | JHAGA | GRUPPABRNR | Allow NULL? |
| 18 | AABRAUSW | IS-M: Contract Settlement Selection Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | AABRAUSW | Allow NULL? |
| 19 | VGBEL | IS-M: Document Number of Template Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | JHVGBEL | Allow NULL? |
| 20 | VGPOS | IS-M: Item Number of the Template Business Item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | JHVGPOS | Allow NULL? |
| 21 | VGETE | IS-M: Group/Settlement Number of Template Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | GRABR_VG | Allow NULL? |
| 22 | VGOBJ | IS-M: Preceding object type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJH97 | JHOBJAR_V | Allow NULL? |
| 23 | XVBELEGTYP | IS-M: Preceding Document Type of Contract Settlement Item | char | 1 | 0 | CHAR | (N' ') | Yes | | XVBELEGTYP | Allow NULL? |
| 24 | ABR_DAT | IS-M: Allocation Date of Contract Assignment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ABRUF_DAT | Allow NULL? |
| 25 | FKDAT | IS-M: Actual Billing/Settlement Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | JHFKDAT | Allow NULL? |
| 26 | WAERK_OLD | SD Document Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERK | Allow NULL? |
| 27 | XRABATT | IS-M: Assignment Qualifies for Discount | char | 1 | 0 | CHAR | (N' ') | Yes | | XRABATT | Allow NULL? |
| 28 | XMITZRAB | IS-M: Assignment Counts Towards Discount Fulfillment | char | 1 | 0 | CHAR | (N' ') | Yes | | XMITZRAB | Allow NULL? |
| 29 | XBONUS | IS-M: Assignment Qualifies for Bonus | char | 1 | 0 | CHAR | (N' ') | Yes | | XBONUS | Allow NULL? |
| 30 | XMITZBON | IS-M: Assignment Counts Towards Bonus Fulfillment | char | 1 | 0 | CHAR | (N' ') | Yes | | XMITZBON | Allow NULL? |
| 31 | AB_BRUTTO | IS-M: Contract Gross | decimal | 15 | 2 | CURR | ((0)) | Yes | | AB_BRUTTO | |
| 32 | ABRMM | IS-M: Quantity (mm, Pages, Seconds) | decimal | 12 | 3 | QUAN | ((0)) | Yes | | ABRMM | |
| 33 | ABRME | IS-M: Number | decimal | 5 | 0 | DEC | ((0)) | Yes | | ABRME | |
| 34 | OLD_KNUMV | Number of the document condition | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | KNUMV | Allow NULL? |
| 35 | OLD_KPOSN | Condition item number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | KPOSN | Allow NULL? |
| 36 | KURST | Exchange Rate Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCURV | KURST | Allow NULL? |
| 37 | ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DZTERM | Allow NULL? |
| 38 | FAKBELNR | IS-M/AM: Billing Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JHTFK | JJBELNR | Allow NULL? |
| 39 | FAKPOSNR | IS-M/AM: Item (number) in settlement document | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | JHTFP | JJPOSNR | Allow NULL? |
| 40 | NEW_KNUMV | Number of the document condition | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | KNUMV | Allow NULL? |
| 41 | NEW_KPOSN | Condition item number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | KPOSN | Allow NULL? |
| 42 | DIFF_KNUMV | Number of the document condition | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | KNUMV | Allow NULL? |
| 43 | VBTYP | IS-M/AM: Sales Document Category | char | 1 | 0 | CHAR | (N' ') | Yes | | ISPVBTYP | Allow NULL? |
| 44 | KALSM | Sales and Distribution: Pricing Procedure in Pricing | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T683 | KALSMASD | Allow NULL? |
| 45 | ABR_ZSTAT | IS-M: Settlement Status of the Assignment | char | 1 | 0 | CHAR | (N' ') | Yes | | ABR_ZSTAT | Allow NULL? |
| 46 | RAB_IST | IS-M: Contract Discount Granted to Date | decimal | 13 | 2 | CURR | ((0)) | Yes | | RAB_IST | |
| 47 | RAB_SOLL | IS-M: Current Contract Discount | decimal | 13 | 2 | CURR | ((0)) | Yes | | RAB_SOLL | |
| 48 | BON_IST | IS-M: Contract Bonus Granted to Date | decimal | 13 | 2 | CURR | ((0)) | Yes | | BON_IST | |
| 49 | BON_SOLL | IS-M/AM: Current Contract Bonus | decimal | 13 | 2 | CURR | ((0)) | Yes | | BON_SOLL | |
| 50 | ABETR_IST | IS-M: Contract Settlement Amount Paid to Date | decimal | 15 | 2 | CURR | ((0)) | Yes | | ABETR_IST | |
| 51 | ABETR_SOLL | IS-M: Current Contract Settlement Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | ABETR_SOLL | |
| 52 | GL_BETRAG | IS-M: Credit/Debit Memo Amount for Contract Settlement | decimal | 15 | 2 | CURR | ((0)) | Yes | | GL_BETRAG | |
| 53 | X_AVM_STOR | IS-M: Processing due to Order Reversal | char | 1 | 0 | CHAR | (N' ') | Yes | | X_AVM_STOR | Allow NULL? |
| 54 | XFR_AVM | IS-M: Assignment from data transfer legacy system indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | XFR_AVM | Allow NULL? |
| 55 | ZWGRFTYP | IS-M/AM: Twinned Billing Dataset Type | char | 1 | 0 | CHAR | (N' ') | No | TJHVAZW | JH_ZWGRFTYP | Allow NULL? |
| 56 | PACKAGE_ID | Package | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JJTPC | ISM_PACKAGE_ID | Allow NULL? |
| 57 | PK_REF_AVM_NR | Order Number for Package Reference Order | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISM_PK_REF_AVM_NR | Allow NULL? |
| 58 | PK_REF_POS_NR | Item Number of Package Item to be Referenced | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | ISM_PK_REF_POS_NR | Allow NULL? |
