| 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 | BOART | Agreement type | nvarchar | 4 | 0 | CHAR | (N' ') | No | | BOART | Allow NULL? |
| 3 | KAPPL | Application | nvarchar | 2 | 0 | CHAR | (N' ') | No | T681A | KAPPL | Allow NULL? |
| 4 | ABTYP | Category of the rebate agreement | char | 1 | 0 | CHAR | (N' ') | No | | BOABTYP | Allow NULL? |
| 5 | DTVOB | Proposed starting date for the rebate validity period | char | 1 | 0 | CHAR | (N' ') | No | | DTVOB | Allow NULL? |
| 6 | DATVO | Date proposed as valid-to date | char | 1 | 0 | CHAR | (N' ') | No | | DATVO | Allow NULL? |
| 7 | ZLSCH | Payment Method | char | 1 | 0 | CHAR | (N' ') | No | T042Z | DZLSCH | Allow NULL? |
| 8 | ABSPZ | Scope of verification level of rebate agreement | char | 1 | 0 | CHAR | (N' ') | No | | ABSPZ | Allow NULL? |
| 9 | KOBOG | Condition type/table group for agreements | nvarchar | 4 | 0 | CHAR | (N' ') | No | T6B2 | KOBOG | Allow NULL? |
| 10 | ABWDT | Validity period of cond.records can differ from agreement | char | 1 | 0 | CHAR | (N' ') | No | | ABWDT | Allow NULL? |
| 11 | NUMKI | Number range in the case of internal number assignment | nvarchar | 2 | 0 | CHAR | (N' ') | No | | NUMKI | Allow NULL? |
| 12 | NUMKE | Number range in the case of external number assignment | nvarchar | 2 | 0 | CHAR | (N' ') | No | | NUMKE | Allow NULL? |
| 13 | UEVOR_BO | Overview screen for rebate agreement | nvarchar | 4 | 0 | CHAR | (N' ') | No | | UEVOR_BO | Allow NULL? |
| 14 | AUART_B1 | Order type for final settlement credit memo request | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVAK | AUART_B1 | Allow NULL? |
| 15 | AUART_B2 | Order type for making corrections to a rebate agreement | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVAK | AUART_B2 | Allow NULL? |
| 16 | BOSTA_MIN | Minimum value of the rebate agreement for final settlement | char | 1 | 0 | CHAR | (N' ') | No | | BOSTA_MIN | Allow NULL? |
| 17 | BOSTA | Default status of the rebate agreement | char | 1 | 0 | CHAR | (N' ') | No | | BOSTA_DEF | Allow NULL? |
| 18 | KOULP | Overlapping check for groups of conditions | char | 1 | 0 | CHAR | (N' ') | No | | KOULP | Allow NULL? |
| 19 | KOULPERR | Error during overlapping check | char | 1 | 0 | CHAR | (N' ') | No | | KOULPERR | Allow NULL? |
| 20 | HIABS | ID for higher-level agreement | char | 1 | 0 | CHAR | (N' ') | No | | HIABS | Allow NULL? |
| 21 | MAVER | Manual payment procedure for rebate agreements | char | 1 | 0 | CHAR | (N' ') | No | | MAVER | Allow NULL? |
| 22 | MRUAF | Reverse accruals in the case of manual payment | char | 1 | 0 | CHAR | (N' ') | No | | MRUAF | Allow NULL? |
| 23 | AUART_B3 | Order type for partial rebate settlement | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVAK | AUART_B3 | Allow NULL? |
| 24 | MANRU | Post manual accruals | char | 1 | 0 | CHAR | (N' ') | No | | MANRU | Allow NULL? |
| 25 | IDENT1 | Settlement calendar for rebate arrangements | nvarchar | 2 | 0 | CHAR | (N' ') | No | TFACD | WFCID1 | Allow NULL? |
| 26 | IDENT2 | Arrangement calendar for rebate arrangements | nvarchar | 2 | 0 | CHAR | (N' ') | No | TFACD | WFCID2 | Allow NULL? |
| 27 | UMKUM | Final settlement | char | 1 | 0 | CHAR | (N' ') | No | | UMKUM | Allow NULL? |
| 28 | CREDO | Settlement type for subsequent settlement | char | 1 | 0 | CHAR | (N' ') | No | | CREDO | Allow NULL? |
| 29 | BOBAS | Settlement basis (for purchasing documents only) | char | 1 | 0 | CHAR | (N' ') | No | | BOBAS | Allow NULL? |
| 30 | AUART_B4 | Order type for manual accruals for a rebate agreement | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVAK | AUART_B4 | Allow NULL? |
| 31 | ABEIN | Scope of statem. f. rebate arr. (Purchasing) -no longer used | char | 1 | 0 | CHAR | (N' ') | No | | ABEIN | Allow NULL? |
| 32 | PARGR | Partner Determination Procedure | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVPG | PARGR | Allow NULL? |
| 33 | UMABP | Bus.vol. comparsion for periods active - not used | char | 1 | 0 | CHAR | (N' ') | Yes | | WUMABP | Allow NULL? |
| 34 | FORZP | Subsequent settlement: time of LIS update | char | 1 | 0 | CHAR | (N' ') | Yes | | FORZP | Allow NULL? |
| 35 | LFART_1 | Bill.doc.type for final settlement of arrangements in Purch. | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WFART_1 | Allow NULL? |
| 36 | LFART_2 | Bill.doc.type for partial settlement of arrangements in Pur. | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WFART_2 | Allow NULL? |
| 37 | IDENT3 | Settlement periods for agreements | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | WFCID3 | Allow NULL? |
| 38 | ABPAR | Indicator for type of settlement partner (vendor/customer) | char | 1 | 0 | CHAR | (N' ') | Yes | | WABPAR | Allow NULL? |
| 39 | KFRST | Release status | char | 1 | 0 | CHAR | (N' ') | Yes | | KFRST | Allow NULL? |
| 40 | TXTGR | Text determination procedure | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TTXG | TXTGR | Allow NULL? |
| 41 | TDID | Text ID for text edit control | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TTXERN | TDID_TEC | Allow NULL? |
| 42 | KALBO | Settlement schema (subsequent settlement) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T683 | KALBO | Allow NULL? |
| 43 | UAART | Business Volume Comparison and Agreement Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T6B3 | UAART | Allow NULL? |
| 44 | KAPPL_NA | Application message conditions, settlement run | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T681A | NA_KAPPL_ABRLF | Allow NULL? |
| 45 | KALSMK | Message determination schema settlement run | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T683 | KALSMB_ABRLF | Allow NULL? |
| 46 | KSCHL | Message type, settlement run | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T685 | NA_KSCHL_ABRLF | Allow NULL? |
| 47 | KAPPL_KONA | Application for message conditions, rebate arrangement | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T681A | NA_KAPPL_KONA | Allow NULL? |
| 48 | KALSM_KONA | Message determination schema rebate arrangement | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T683 | KALSMB_KONA | Allow NULL? |
| 49 | KSCHL_KONA | Message type, rebate arrangement | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T685 | NA_KSCHL_KONA | Allow NULL? |
| 50 | ANGRP | Trigger Group Message Determination | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TMAN2 | ANGRP | Allow NULL? |
| 51 | ANBEDNFE | Trigger condition, message determination | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TMAN3 | ANBEDNFE | Allow NULL? |
| 52 | NAUMF_ENAW | Default aggregation level "Detailed statement" | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TMAB | NAUMF_ENAW | Allow NULL? |
| 53 | NAUMF_SNAW | Default aggregation level "Statement of statistical data" | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TMAB | NAUMF_SNAW | Allow NULL? |
| 54 | NAUMF_ANAW | Default Summarization Level: "Statement of Settlement Docs" | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TMAB | NAUMF_ANAW | Allow NULL? |
| 55 | KRUST | Do not post any prov. for accr. income f. settled arrangmnts | char | 1 | 0 | CHAR | (N' ') | Yes | | KRUST | Allow NULL? |
| 56 | KALSM_KRUST | Schema "Account key for provisions for accrued income" | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T683 | KALSM_KRUST | Allow NULL? |
| 57 | BON_ENH_VAKEY | Indicates Enhanced Rebate Settlement | char | 1 | 0 | CHAR | (N' ') | Yes | | BON_ENH_VAKEY | Allow NULL? |
| 58 | BON_ENH_INDIRECT | Indicator for Indirect Settlement Types | char | 1 | 0 | CHAR | (N' ') | Yes | | BON_ENH_INDIRECT | Allow NULL? |
| 59 | BON_ENH_PERIOD_S | Indicates Periodic Settlement | char | 1 | 0 | CHAR | (N' ') | Yes | | BON_ENH_PERIOD_S | Allow NULL? |
| 60 | BON_ENH_CONT | Indicates Contract Data | char | 1 | 0 | CHAR | (N' ') | Yes | | BON_ENH_CONT | Allow NULL? |
