| 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 | 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 | | LAUFI_KK | Allow NULL? |
| 4 | INTNR | Interval Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | INTNR_I_KK | Allow NULL? |
| 5 | LFDN1 | Current Record Number | int | 10 | 0 | INT4 | ((0)) | No | | LFSNR_KK | Allow NULL? |
| 6 | OPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | OPBEL_KK | Allow NULL? |
| 7 | OPUPW | Repetition Item in Contract Account Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | OPUPW_KK | Allow NULL? |
| 8 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | OPUPK_KK | Allow NULL? |
| 9 | BWBER | Valuation Area for FI-CA Year-End Closing | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | BWBER_KK | Allow NULL? |
| 10 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 11 | GPART | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | GPART_KK | Allow NULL? |
| 12 | VKONT | Contract Account Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | VKONT_KK | Allow NULL? |
| 13 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS_KK | Allow NULL? |
| 14 | OFFBT | Open amount at time of doubtful entry/IVA | decimal | 13 | 2 | CURR | ((0)) | Yes | | OFFBT_KK | |
| 15 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT_KK | Allow NULL? |
| 16 | GRUND | Adjustment reason | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | GRUND_KK | Allow NULL? |
| 17 | PROZT | Percentage share of value adjustment | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PROZT_KK | Allow NULL? |
| 18 | INFOZ | Doubtful Item Entry/Individual Value Adjustment | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | INFOZ_KK | Allow NULL? |
| 19 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAEDN_KK | Allow NULL? |
| 20 | BETRW | Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | BETRW_KK | |
| 21 | KENNZ | Dbtfl/IVA (manual/automatic) | char | 1 | 0 | CHAR | (N' ') | Yes | | KENNZ_KK | Allow NULL? |
| 22 | RGRND | Reset reason for doubtful entry/individual value adjustment | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | RGRND_KK | Allow NULL? |
| 23 | REDAT | Reset date for doubtful entry/individual value adjustment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REDAT_KK | Allow NULL? |
| 24 | APPLK | Application area | char | 1 | 0 | CHAR | (N' ') | Yes | | APPLK_KK | Allow NULL? |
| 25 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | HVORG_KK | Allow NULL? |
| 26 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | TVORG_KK | Allow NULL? |
| 27 | ABWTP | Category of substitute document in FI-CA | char | 1 | 0 | CHAR | (N' ') | Yes | | ABWTP_KK | Allow NULL? |
| 28 | KOFIZ | Account Determination ID | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | KOFIZ_KK | Allow NULL? |
| 29 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 30 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | SPART_KK | Allow NULL? |
| 31 | SEGMENT | Segment for Segmental Reporting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SEGMT_KK | Allow NULL? |
| 32 | WBBTR | Specified Value Adjustment Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | WBBTR_KK | |
| 33 | LDGRP | Ledger Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | LDGRP_KK | Allow NULL? |
| 34 | RTYPE | FPRW: Record Type (Internal Use) | char | 1 | 0 | CHAR | (N' ') | Yes | | RTYPE_KK | Allow NULL? |
