| 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 | * | MANDT | Allow NULL? |
| 2 | OPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | CHAR | (N' ') | No | DFKKKO | OPBEL_KK | Allow NULL? |
| 3 | WHGRP | Repetition group | nvarchar | 3 | 0 | NUMC | (N'000') | No | * | WHGRP_KK | Allow NULL? |
| 4 | OPUPW | Repetition Item in Contract Account Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | OPUPW_KK | Allow NULL? |
| 5 | WHANZ | Number of Items for this Repetition Group | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | WHANZ_KK | Allow NULL? |
| 6 | GPART | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | GPART_KK | Allow NULL? |
| 7 | VKONT | Contract Account Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | VKONT_KK | Allow NULL? |
| 8 | ABWBL | Number of the substitute FI-CA document | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ABWBL_KK | Allow NULL? |
| 9 | ABWTP | Category of substitute document in FI-CA | char | 1 | 0 | CHAR | (N' ') | Yes | | ABWTP_KK | Allow NULL? |
| 10 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT_KK | Allow NULL? |
| 11 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAEDN_KK | Allow NULL? |
| 12 | FAEDS | Due Date for Cash Discount | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAEDS_KK | Allow NULL? |
| 13 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PERSL_KK | Allow NULL? |
| 14 | XAESP | Printing - No Changes Possible | char | 1 | 0 | CHAR | (N' ') | Yes | | XAESP_KK | Allow NULL? |
| 15 | MANSP | Dunning Lock Reason | char | 1 | 0 | CHAR | (N' ') | Yes | * | MANSP_KK | Allow NULL? |
| 16 | AUGDT | Clearing date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AUGDT_KK | Allow NULL? |
| 17 | AUGBL | Clearing Document or Printed Document | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AUGBL_KK | Allow NULL? |
| 18 | AUGBD | Clearing document posting date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AUGBD_KK | Allow NULL? |
| 19 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | AUGRD_KK | Allow NULL? |
| 20 | AUGVD | Value date for clearing | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AUGVD_KK | Allow NULL? |
| 21 | AUGOB | Item Canceled | char | 1 | 0 | CHAR | (N' ') | Yes | | AUGOB_KK | Allow NULL? |
| 22 | XAUFL | Repetition Item was Broken Down | char | 1 | 0 | CHAR | (N' ') | Yes | | XAUFL_KK | Allow NULL? |
| 23 | XRAGL | Clearing posting reversed | char | 1 | 0 | CHAR | (N' ') | Yes | | XRAGL_KK | Allow NULL? |
| 24 | XPYOR | Item Included in a Payment Order | char | 1 | 0 | CHAR | (N' ') | Yes | | XPYOR_KK | Allow NULL? |
| 25 | STZAL | Status of Payment Processing | char | 1 | 0 | CHAR | (N' ') | Yes | | STZAL_KK | Allow NULL? |
| 26 | PNNUM | SEPA: Number of Direct Debit Pre-Notification | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | PNNUM_KK | Allow NULL? |
| 27 | PNHKF | SEPA: Origin of Direct Debit Pre-Notification | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PNHKF_KK | Allow NULL? |
| 28 | PNEXD | SEPA: Date of Execution of Direct Debit Pre-Notifcation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PNEXD_KK | Allow NULL? |
