| 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 | LAUFD | Date ID | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | LAUFD_KK | Allow NULL? |
| 3 | LAUFI | Additional Identification Characteristic | nvarchar | 6 | 0 | CHAR | (N' ') | No | | MLFID_KK | Allow NULL? |
| 4 | GPART | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | GPART_KK | Allow NULL? |
| 5 | VKONT | Contract Account Number | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | VKONT_KK | Allow NULL? |
| 6 | MAZAE | Counter for several dunning notices to a business partner | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | MAZAE_KK | Allow NULL? |
| 7 | OPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | CHAR | (N' ') | No | DFKKKO | OPBEL_KK | Allow NULL? |
| 8 | OPUPW | Repetition Item in Contract Account Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | OPUPW_KK | Allow NULL? |
| 9 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | OPUPK_KK | Allow NULL? |
| 10 | OPUPZ | Subitem for a Partial Clearing in Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | OPUPZ_KK | Allow NULL? |
| 11 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 12 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 13 | MBETM | Dunned amount in transaction currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | MBETM_KK | |
| 14 | MBETH | Not used (formerly dunned amount in local currency) | decimal | 13 | 2 | DEC | ((0)) | Yes | | UNUSED_KK | |
| 15 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAEDN_KK | Allow NULL? |
| 16 | MINTM | Dunning interest in transaction currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | MINTM_KK | |
| 17 | MAHNS | Dunning Level | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | TFK047B | MAHNS_KK | Allow NULL? |
| 18 | MSTYP | Dunning Level Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFK047G | MSTYP_KK | Allow NULL? |
| 19 | MAHNN | New dunning level | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | TFK047B | MAHNN_KK | Allow NULL? |
| 20 | MANSP | Dunning Lock Reason | char | 1 | 0 | CHAR | (N' ') | Yes | TFK047S | MANSP_KK | Allow NULL? |
| 21 | XMFAK | Dunning Level is Optional | char | 1 | 0 | CHAR | (N' ') | Yes | | XMFAK_KK | Allow NULL? |
| 22 | XMSUS | Entry in Dunning History only Technically Conditional | char | 1 | 0 | CHAR | (N' ') | Yes | | XMSUS_KK | Allow NULL? |
| 23 | XMSTO | Dunning Notice Reversed | char | 1 | 0 | CHAR | (N' ') | Yes | | XMSTO_KK | Allow NULL? |
| 24 | XINFO | Information: Item Not Due for Dunning | char | 1 | 0 | CHAR | (N' ') | Yes | | XINFO_KK | Allow NULL? |
| 25 | MDRKD | Execution Date of Dunning Notice | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | MDRKD_KK | Allow NULL? |
| 26 | STAKZ | Type of statistical item | char | 1 | 0 | CHAR | (N' ') | Yes | | STAKZ_KK | Allow NULL? |
| 27 | XMVKT | Contract Account Not Unique | char | 1 | 0 | CHAR | (N' ') | Yes | | XMVKT_KK | Allow NULL? |
| 28 | VTREF | Reference Specifications from Contract | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | VTREF_KK | Allow NULL? |
| 29 | SUBAP | Subapplication in Contract Accounts Receivable and Payable | char | 1 | 0 | CHAR | (N' ') | Yes | | SUBAP_KK | Allow NULL? |
| 30 | SEGMENT | Segment for Segmental Reporting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SEGMT_KK | Allow NULL? |
| 31 | PRCTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PRCTR | Allow NULL? |
| 32 | MAHNV | Dunning Procedure | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MAHNV_KK | Allow NULL? |
| 33 | AUSDT | Date of issue | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AUSDT_KK | Allow NULL? |
| 34 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | SPART_KK | Allow NULL? |
| 35 | XTAUS | Item Split | char | 1 | 0 | CHAR | (N' ') | Yes | | XTAUS_KK | Allow NULL? |
| 36 | MOPUPZ | Maximum Subitem Number for Creation of Table Lines | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | MOPUPZ_KK | Allow NULL? |
| 37 | HIGHERDL | Item has higher dunning level than dunning notice | char | 1 | 0 | CHAR | (N' ') | Yes | | HIGHERDL_KK | Allow NULL? |
| 38 | DALIN | Dunning Item Created by Dunning Activity Run | char | 1 | 0 | CHAR | (N' ') | Yes | | DALIN_KK | Allow NULL? |
